How to get the shop plugin to work.
lukgoh |
|
---|---|
Hello guys,
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... :\ |
|
This post was edited by lukgoh (2010-11-12 00:13, 14 years ago) |
pieter |
|
---|---|
Maybe add this in the comment of the plugin-page: http://www.cotonti.com/downloads/plugins/ecommerce/145
... can we help you ...
|
lukgoh |
|
---|---|
Edit: Updated.
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. |
|
This post was edited by lukgoh (2010-11-12 00:23, 14 years ago) |
GHengeveld |
|
---|---|
A complete e-commerce/shop plugin is being developed by Kilandor if I'm not mistaking. I'm not sure if he'll release it as open-source though.
|
lukgoh |
|
---|---|
Yeah thanks Koradhil, I think I saw something about that when I was searching the forums earlier. I know there are a couple of these plugins around but their creators are selling them only.
|