Shop module Fatal error

Get help with installation and running official modules for phpwcms here. Please do not post bug reports or feature requests here.
Post Reply
powlido
Posts: 29
Joined: Mon 14. Jan 2008, 12:59

Shop module Fatal error

Post 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
User avatar
juergen
Moderator
Posts: 4556
Joined: Mon 10. Jan 2005, 18:10
Location: Weinheim
Contact:

Re: Shop module Fatal error

Post 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
powlido
Posts: 29
Joined: Mon 14. Jan 2008, 12:59

Re: Shop module Fatal error

Post 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
powlido
Posts: 29
Joined: Mon 14. Jan 2008, 12:59

Re: Shop module Fatal error

Post 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
User avatar
juergen
Moderator
Posts: 4556
Joined: Mon 10. Jan 2005, 18:10
Location: Weinheim
Contact:

Re: Shop module Fatal error

Post 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 :oops:
powlido
Posts: 29
Joined: Mon 14. Jan 2008, 12:59

Re: Shop module Fatal error

Post 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
User avatar
juergen
Moderator
Posts: 4556
Joined: Mon 10. Jan 2005, 18:10
Location: Weinheim
Contact:

Re: Shop module Fatal error

Post by juergen »

perhaps you should look pretty more around, cause this is working. There is a small howto in here in this forum.
powlido
Posts: 29
Joined: Mon 14. Jan 2008, 12:59

Re: Shop module Fatal error

Post 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
Post Reply