Shop module Fatal error

[powlido]

Hi All - I am trying to set up the shop module (on phpwcms 1.3.9 - 2008/05/13) and I encounter the following error:

Code: Select all

{STATUS_MESSAGE}
Fatal error: _setConfig failed in /home/c/s/csruk/public_html/include/inc_lib/dbcon.inc.php on line 513

I have deleted and recreated the 'phpwcms_sysvalue' table as suggested by the forum, but I still get the error.

Any thoughts/comments very welcome!

Many thanks,

pwl

[juergen]

Hey,

that means that there is no sysvlaue table where anything can be insterted...

do this in phpmyadmin:

Code: Select all

CREATE TABLE IF NOT EXISTS `phpwcms_sysvalue` (
  `sysvalue_key` varchar(255) NOT NULL default '',
  `sysvalue_group` varchar(255) NOT NULL default '',
  `sysvalue_lastchange` int(11) NOT NULL default '0',
  `sysvalue_status` int(1) NOT NULL default '0',
  `sysvalue_vartype` varchar(100) NOT NULL default '',
  `sysvalue_value` text NOT NULL,
  PRIMARY KEY  (`sysvalue_key`),
  KEY `sysvalue_group` (`sysvalue_group`),
  KEY `sysvalue_status` (`sysvalue_status`)
) ENGINE=MyISAM DEFAULT ;

and error is gone

[powlido]

Many thanks for the response!

I have attempted to copy in the sql however I am being told there is an error on the query.

I will attempt to work out any typos etc (I'm pretty new to mysql stuff) however of you get a chance to repost that would be great.

thanks again

pwl

[powlido]

Sorry! This may help!

Code: Select all

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1.

Query: CREATE TABLE IF NOT EXISTS `phpwcms_sysvalue` ( `sysvalue_key` varchar(255) NOT NULL default '', `sysvalue_group` varchar(255) NOT NULL default '', `sysvalue_lastchange` int(11) NOT NULL default '0', `sysvalue_status` int(1) NOT NULL default '0', `sysvalue_vartype` varchar(100) NOT NULL default '', `sysvalue_value` text NOT NULL, PRIMARY KEY (`sysvalue_key`), KEY `sysvalue_group` (`sysvalue_group`), KEY `sysvalue_status` (`sysvalue_status`) ) ENGINE=MyISAM DEFAULT

cheers,

pwl

[juergen]

Code: Select all

CREATE TABLE IF NOT EXISTS `phpwcms_sysvalue` (
  `sysvalue_key` varchar(255) NOT NULL default '',
  `sysvalue_group` varchar(255) NOT NULL default '',
  `sysvalue_lastchange` int(11) NOT NULL default '0',
  `sysvalue_status` int(1) NOT NULL default '0',
  `sysvalue_vartype` varchar(100) NOT NULL default '',
  `sysvalue_value` text NOT NULL,
  PRIMARY KEY  (`sysvalue_key`),
  KEY `sysvalue_group` (`sysvalue_group`),
  KEY `sysvalue_status` (`sysvalue_status`)
) ENGINE=MyISAM  ;

Sorry, I took off my language settings and left DEFAULT

[powlido]

Superb!

Many thanks for that - resolved the error and seems to be working fine!

I have had a pretty good look around and can't see anywhere to actually implement the product I have created within the shop module?

Is this because the Shop module is not yet finished?

Thanks again,

pwl

[juergen]

perhaps you should look pretty more around, cause this is working. There is a small howto in here in this forum.

[powlido]

Ok! I found the stuff I was after... as you said a little more searching required!

Incase anyone is interested - this link contains the relevant RTs.

http://forum.phpwcms.org/viewtopic.php?f=18&t=15442

thanks for the help

pwl