Page 1 sur 1

DB function failed with error number 1146

Posté : ven. 10 déc. 2010 13:19
par gadgeteer
I tried to install your fine component on my system, but it gave the above error notice.
The rest of the message was as follows:
Table 'meentwdb.jcm_collector' doesn't exist SQL=INSERT INTO `jcm_collector` ( `id` ,`name` ,`alias` ,`description` ,`custom` ,`state` ,`created` ,`created_by` ,`created_by_alias` ,`modified` ,`modified_by` ,`publish_up` ,`publish_down` ,`checked_out` ,`checked_out_time` ,`image` ,`access` ,`home` ,`metakey` ,`metadesc` ,`metadata` ) VALUES ( '' , 'Campeugeot', 'campeugeot', 'Voici les miniatures inédites du CAMP.', '0', '1', '2008-11-02 17:09:55', '62', '', '0000-00-00 00:00:00', '0', '2008-11-02 17:10:19', '0000-00-00 00:00:00', '0', '0000-00-00 00:00:00', '', '0', '1', '', '', '' );
Should I create the table jcm_collector myself or do you have a solution?

Thank you for the support!

Gadgeteer

Re: DB function failed with error number 1146

Posté : mar. 21 déc. 2010 20:43
par steevo
Hi, sorry for the late reply.

That's not normal. All tables are created with the installation.
To be sure you could create tables before installing. To do that, you have to use the file admin/install.sql in the archive and insert it with your database manager (phpmyadmin for example).