PDA

View Full Version : problem running query for toplist hack


wreck
08-06-2004, 11:17 AM
this is the error i get trying to run it... the other 2 querys for it run perfectly fine no problems, but this one wont... anybody got any idea why it wont work? this is what the error says

Database mvzsvhjf_forums running on localhost
Error

SQL-query :

CREATE TABLE toplist_settings(

settingid int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
title varchar( 50 ) NOT NULL default '',
value varchar( 20 ) NOT NULL default '',
PRIMARY KEY ( settingid )
) INSERT INTO toplist_settings
VALUES (
'1', 'lastreset', '20020402'
)

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO toplist_settings VALUES('1','lastreset','20020402')

assassingod
08-06-2004, 11:32 AM
There are 2 queries theres, so try running each one seperatly:

CREATE TABLE toplist_settings(
settingid int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
title varchar( 50 ) NOT NULL default '',
value varchar( 20 ) NOT NULL default '',
PRIMARY KEY ( settingid )
)


and then


INSERT INTO toplist_settings
VALUES (
'1', 'lastreset', '20020402'
)

wreck
08-06-2004, 01:03 PM
oooo i didnt know that :-\ in the queries.txt file it showed it as one.. but now i know that ill try it now... thanks ill let u know if it worked

wreck
08-06-2004, 01:06 PM
wahoooo it worked lol

:-D thank you man i really appreciate that