Control Panel > Configure DB error

[suzarte]

Hi, after upgrade the SiT 3.41 for 3.45, when I'll need to change some thing in Control Panel > configure, the interface return this error.

Application Warning [512]
Table 'sit.sit_config' doesn't exist REPLACE INTO `sit_config` (`config`, `value`) VALUES ('application_name', 'Sit Central de Suporte') in /www/htdocs/sit-3.45/lib/functions.inc.php @ line 8103 trigger_error() cfgSave()

[ivanlucas]

HI Suzarte,

I think this must be a problem with the setup script, for some reason it has not created the config table needed to configure SiT with the GUI interface. I've logged it as Bug 674 you can monitor progress there.

As a work-around, to fix this you can run the following SQL which will create the config table for you:

Code: Select all

CREATE TABLE IF NOT EXISTS `config` (
  `config` varchar(255) NOT NULL,
  `value` text,
  PRIMARY KEY  (`config`)
) TYPE=MyISAM COMMENT='SiT configuration';


Note: if you are using a database prefix you'll have to change the table name above, e.g. if your db prefix is 'sit_' use:

Code: Select all

CREATE TABLE IF NOT EXISTS `sit_config` (
  `config` varchar(255) NOT NULL,
  `value` text,
  PRIMARY KEY  (`config`)
) TYPE=MyISAM COMMENT='SiT configuration';


Hope this helps,

Ivan

[suzarte]

Hi, ivanlucas
you solved my problem with this work-around.

thanks so much, for fast answer.