MySQL Query Failed: Table 'opencats.module_schema' doesn't e

General discussion of OpenCATS

Moderators: RussH, cptr13

Forum rules
Just remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but keep comments directed to the topic at hand.
Post Reply
atul
Posts: 1
Joined: 05 Jan 2018, 07:57
what is two(2) plus three(3) ?: 5

MySQL Query Failed: Table 'opencats.module_schema' doesn't e

Post by atul » 05 Jan 2018, 08:06

I am trying to install opencats 0.9.4 by following this link
http://opencats-documentation.readthedo ... ndows.html

installed wamp server 3.0.6 with
Win64
Apache 2.4.23
PHP 5.6.25

I am getting this error at "Set up OpenCATS" step

Query Error -- Report to System Administrator ASAP
MySQL Query Failed: Table 'opencats.module_schema' doesn't exist
SELECT
version AS version
FROM
module_schema
WHERE
name = 'activity'

User avatar
RussH
Site Admin
Posts: 791
Joined: 12 Apr 2008, 08:28
what is two(2) plus three(3) ?: 5
Location: UK
Contact:

Re: MySQL Query Failed: Table 'opencats.module_schema' doesn

Post by RussH » 19 Feb 2018, 13:34

Hi,

apologies if this reply is a little late - however that table shoudl be created during initial setup. It's certainly in the code;
https://github.com/opencats/OpenCATS/bl ... schema.sql

Can I ask you to try the installation without the demo data, i.e. a clean install - as I believe the demo deta mysql code may not have been updated to include this table.
RussH

Report your issues and feature requests;
https://github.com/opencats/opencats/issues

Please CLICK THE TICK to accept the answer!

afedan
Posts: 3
Joined: 09 Aug 2018, 01:23
what is two(2) plus three(3) ?: 5

Re: MySQL Query Failed: Table 'opencats.module_schema' doesn't e

Post by afedan » 09 Aug 2018, 01:30

I got the same error even if I have installed in 'db name'_schema.sql the mysql code :
/*Table structure for table `module_schema` */

CREATE TABLE `module_schema` (
`module_schema_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`version` int(11) DEFAULT NULL,
PRIMARY KEY (`module_schema_id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `module_schema` */

insert into `module_schema`(`module_schema_id`,`name`,`version`) values (1,'activity',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (2,'attachments',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (3,'calendar',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (4,'candidates',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (5,'careers',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (6,'companies',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (7,'contacts',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (8,'export',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (9,'extension-statistics',1);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (10,'graphs',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (11,'home',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (12,'import',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (13,'install',363);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (14,'joborders',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (15,'lists',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (16,'login',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (17,'queue',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (18,'reports',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (19,'rss',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (20,'settings',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (21,'tests',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (22,'toolbar',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (23,'wizard',0);
insert into `module_schema`(`module_schema_id`,`name`,`version`) values (24,'xml',0);


So what can be the problem?

afedan
Posts: 3
Joined: 09 Aug 2018, 01:23
what is two(2) plus three(3) ?: 5

Re: MySQL Query Failed: Table 'opencats.module_schema' doesn't e

Post by afedan » 09 Aug 2018, 08:53

To further clarify the situation, I have configured the OpenCATS project with the default configuration:
/* Database configuration. */
define('DATABASE_USER', 'cats');
define('DATABASE_PASS', 'cats');
define('DATABASE_HOST', 'localhost');
define('DATABASE_NAME', 'cats_dev');

User avatar
RussH
Site Admin
Posts: 791
Joined: 12 Apr 2008, 08:28
what is two(2) plus three(3) ?: 5
Location: UK
Contact:

Re: MySQL Query Failed: Table 'opencats.module_schema' doesn't e

Post by RussH » 09 Aug 2018, 12:56

Okay,

lets take a few steps back and check the basics.

Can you confirm the version of opencats, mysql & php that you have?
The PHP support envelope and tested version of MariaDB is shown in the release notes https://github.com/opencats/OpenCATS/re ... ag/0.9.4-2

- you need to be compliant with this. Note that PHP v7 compatibility IS NOT in the current release.

If that's all clean - the first likely culprit is a crashed MySQL database.
RussH

Report your issues and feature requests;
https://github.com/opencats/opencats/issues

Please CLICK THE TICK to accept the answer!

afedan
Posts: 3
Joined: 09 Aug 2018, 01:23
what is two(2) plus three(3) ?: 5

Re: MySQL Query Failed: Table 'opencats.module_schema' doesn't e

Post by afedan » 09 Aug 2018, 18:10

Thank you RussH!
I have in fact used a php version that was not compatible with the OpenCats version! It was a php 4 version. Now I took the right version and it works fine!

User avatar
RussH
Site Admin
Posts: 791
Joined: 12 Apr 2008, 08:28
what is two(2) plus three(3) ?: 5
Location: UK
Contact:

Re: MySQL Query Failed: Table 'opencats.module_schema' doesn't e

Post by RussH » 10 Aug 2018, 14:01

afedan wrote:
09 Aug 2018, 18:10
Thank you RussH!
I have in fact used a php version that was not compatible with the OpenCats version! It was a php 4 version. Now I took the right version and it works fine!
No problem, glad it's working for you now!
RussH

Report your issues and feature requests;
https://github.com/opencats/opencats/issues

Please CLICK THE TICK to accept the answer!

Post Reply