cotonti.com : shop system fix https://www.cotonti.com Last topic posts Cotonti en Sun, 12 Apr 2026 21:50:20 -0000 lukgoh Fri, 12 Nov 2010 06:03:14 -0000 GHengeveld Fri, 12 Nov 2010 05:23:32 -0000 lukgoh
Just saw this in the main file:

# TODO LIST:
#
#   -> add textboxer
#   -> security?
#   -> main run over all sed functions! what can be done better?
#   -> Shopping cart
#   -> notify special user by mail or PM when new item is purchased
#   -> add some "NEW!" to recently added products 
#   -> maybe change the deletion process to reduce files...
#   -> automated shopping process (email to user, email to admin, paying methods?, ...)

Maybe the description for the plugin should be changed so people know that it is not a fully functioning shop?

Thanks,

Luke.]]> Thu, 11 Nov 2010 23:52:47 -0000 pieter http://www.cotonti.com/downloads/plugins/ecommerce/145]]> Thu, 11 Nov 2010 23:51:46 -0000 lukgoh
I just downloaded the shop system plugin to discover it did not work and I can see a lot of people are having the same problem without an easy to find solution, so here it is:

Sql tables:
CREATE TABLE `sed_products_itemcat` (
`prdct_catid` int(11) NOT NULL auto_increment,
`prdct_title` varchar(255) NOT NULL,
`prdct_desc` varchar(255) NOT NULL,
PRIMARY KEY (`prdct_catid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=71 ;

CREATE TABLE `sed_products_items` (
`prdct_id` int(11) unsigned NOT NULL auto_increment,
`prdct_state` tinyint(1) unsigned NOT NULL default '0',
`prdct_price` varchar(255) NOT NULL,
`prdct_amount` varchar(255) NOT NULL,
`prdct_extra1` varchar(255) NOT NULL,
`prdct_extra2` varchar(255) NOT NULL,
`prdct_extra3` varchar(255) NOT NULL default '',
`prdct_extra4` varchar(255) NOT NULL default '',
`prdct_extra5` varchar(255) NOT NULL default '',
`prdct_extra6` varchar(255) NOT NULL,
`prdct_extra7` varchar(255) NOT NULL,
`prdct_extra8` varchar(255) NOT NULL,
`prdct_extra9` varchar(255) NOT NULL,
`prdct_extra10` varchar(255) NOT NULL,
`prdct_title` varchar(255) default NULL,
`prdct_desc` varchar(255) default NULL,
`prdct_info` text,
`prdct_ownerid` int(11) NOT NULL default '0',
`prdct_date` int(11) NOT NULL default '0',
`prdct_update` int(11) NOT NULL,
`prdct_img` varchar(255) default NULL,
`prdct_cat` varchar(255) NOT NULL,
PRIMARY KEY (`prdct_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=44 ;

CREATE TABLE `sed_products_sold` (
`id` int(11) NOT NULL,
`prdct_id` int(11) unsigned NOT NULL,
`prdct_state` tinyint(1) unsigned NOT NULL default '0',
`prdct_buyerid` tinyint(1) default '0',
`prdct_amount` varchar(255) NOT NULL,
`prdct_date` int(11) NOT NULL default '0',
PRIMARY KEY (`prdct_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

was found in the comments for the plugin by fedai

I noticed that in shopsystem.php it was trying to enter the wrong information into the database.

I have attached the fixed php file.

Thanks,

Luke.

shopsystem_1089.zip

EDIT: Ok here is the new fix, just to warn you before downloading:

There is NO cart system or anyway of actually buying anything from the shop, its pointless. Also the easiest way of fixing the initial problem:
Fatal error : SQL error : Unknown column 'prdct_url' in 'field list'

is to change the sql table to the right names... :\]]> Thu, 11 Nov 2010 23:40:58 -0000