Crazy-S wrote:I am having problems with a few of these SQL query's
Everything seemed to install fine once I found the manual SQL entries, as the auto install within the admin section will NOT work properly due to both links requiring categories Herocy be installed...
I did test installs and upgrades from the previous version for the current package on both vanilla and CH boards both with no problems. If there's a conflict of some kind, it's probably a result of another MOD you have installed.
Crazy-S wrote:Error creating store
SQL Error : 1054 Unknown column 'district_tax' in 'field list'
INSERT INTO phpbb_store_districts ( district_name, district_description, district_image, district_order, district_tax, district_max, district_store_price, district_store_price_cash, auth_view, auth_buy, auth_sell, auth_create ) VALUES ( 'Crazy-Software Wrappers', 'Sample', '', '10', '-1', '-1', '', '', 0, 1, 1, 1)
Line : 1817
File : admin_store.php
It appears that you missed an SQL query. More specifically, this one
Code: Select all
ALTER TABLE `phpbb_store_districts` ADD `district_tax` DECIMAL( 5, 2 ) DEFAULT '-1' NOT NULL AFTER `district_order` ;
Crazy-S wrote:The second
INSERT INTO `phpbb_config` VALUES ('store_installed', 'yes');
#1136 - Column count doesn't match value count at row 1
Have you installed a MOD that has changed the phpbb_config table in some way, such as Category Hierarchies?