Page 1 of 1
Shop module Fatal error
Posted: Thu 25. Sep 2008, 10:11
by 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
Re: Shop module Fatal error
Posted: Thu 25. Sep 2008, 12:56
by 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
Re: Shop module Fatal error
Posted: Thu 25. Sep 2008, 13:42
by 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
Re: Shop module Fatal error
Posted: Thu 25. Sep 2008, 13:44
by 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
Re: Shop module Fatal error
Posted: Thu 25. Sep 2008, 15:09
by 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
Re: Shop module Fatal error
Posted: Thu 25. Sep 2008, 17:58
by 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
Re: Shop module Fatal error
Posted: Thu 25. Sep 2008, 18:27
by juergen
perhaps you should look pretty more around, cause this is working. There is a small howto in here in this forum.
Re: Shop module Fatal error
Posted: Fri 26. Sep 2008, 09:53
by 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