Форумы / Cotonti / Extensions / shop system fix

How to get the shop plugin to work.

lukgoh
#1 11.11.2010 23:40
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... :\
Отредактировано: lukgoh (12.11.2010 00:13, 13 лет назад)
pieter
#2 11.11.2010 23:51
Maybe add this in the comment of the plugin-page: http://www.cotonti.com/downloads/plugins/ecommerce/145
... can we help you ...
lukgoh
#3 11.11.2010 23:52
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.
Отредактировано: lukgoh (12.11.2010 00:23, 13 лет назад)
GHengeveld
#4 12.11.2010 05:23
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
#5 12.11.2010 06:03
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.