need help installing i followd the install directions buat i am still not able to add the sql into the roster sql.
i have set up the functionscart.php to reflect my sql settings any ideas for me? Site link

doommonkey wrote:need help installing i followd the install directions buat i am still not able to add the sql into the roster sql.
i have set up the functionscart.php to reflect my sql settings any ideas for me? Site link
[ http://www.heds.thedeathbringers.org/video/error.png ]

Hi doommonkey!

This is a problem of the used mysql-version.

Take the following sql- query and run it manually on your DB (with phpmyadmin for examle):

CREATE TABLE `roster_addon_shopping` (
`order_number` int(255) NOT NULL auto_increment,
`order_item` varchar(255) NOT NULL default '',
`order_quantity` int(10) NOT NULL default '0',
`order_maker` varchar(100) NOT NULL default '',
`order_requester` varchar(100) NOT NULL default '',
`order_maxprice` int(255) NOT NULL default '0',
`order_note` varchar(255) NOT NULL default '',
`order_price_demand` int(255) NOT NULL default '0',
`order_date` datetime default NULL,
`order_state` enum('none','outbox','send','info') NOT NULL default 'none',
`order_info` varchar(255) default NULL,
PRIMARY KEY (`order_number`)
) ENGINE=MyISAM AUTO_INCREMENT=1;


It´s the charset definition at the end and in one case it was the datetime column, so i changed it...


This should do the trick...

CuU

Hannah

worked great thank you