The Arcive of vBulletin Modifications Site.

store trouble · **Released**: 06-20-2003

after running the store query i get this error after i proceed to the second step.

PHP Code:


			Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: CREATE TABLE store (
  id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,   
  action varchar(255) NOT NULL,
  title varchar(255) NOT NULL,
  costs varchar(255) NOT NULL,
  sold smallint(5) DEFAULT '0',
  imgurl varchar(255) NOT NULL,
  description varchar(255) NOT NULL,
  ok char(1) NOT NULL default '',
  quantity smallint(5) DEFAULT '0',
  PRIMARY KEY (id)
)
mysql error: Table 'store' already exists

mysql error number: 1050

Date: Thursday 19th of June 2003 10:16:35 PM
Script: [url]http://www.******.com/forums/forums/admin/storequery.php[/url]
Referer: [url]http://www.******.com/forums/admin/storequery.php[/url]

any help is greatly appreciated

Lesane · #2 06-20-2003, 09:31 AM

Don't use storequery.php because that file is for a fresh install and not for the update as stated in the instructions. Check the upgrade directory for instructions to update your store to store version 2.0.

poetic · #3 06-20-2003, 11:23 AM

thank you, problem fixed, also though for some reason when i go into admin cpanel to edit the forum home template i can't find the first line it says to find, its just not there.

poetic · #4 06-20-2003, 09:12 PM

nvm, problem solved