PDA

View Full Version : store trouble


poetic
06-20-2003, 02:16 AM
after running the store query i get this error after i proceed to the second step.

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: http://www.******.com/forums/forums/admin/storequery.php
Referer: http://www.******.com/forums/admin/storequery.php


any help is greatly appreciated

Lesane
06-20-2003, 10: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
06-20-2003, 12:23 PM
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
06-20-2003, 10:12 PM
nvm, problem solved