Page 1 of 1

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

Posted: 05 Jan 2018, 08:06
by atul
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'

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

Posted: 19 Feb 2018, 13:34
by RussH
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.

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

Posted: 09 Aug 2018, 01:30
by afedan
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?

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

Posted: 09 Aug 2018, 08:53
by afedan
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');

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

Posted: 09 Aug 2018, 12:56
by RussH
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.

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

Posted: 09 Aug 2018, 18:10
by afedan
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!

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

Posted: 10 Aug 2018, 14:01
by RussH
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!