AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   SQL Syntax error (https://forums.alliedmods.net/showthread.php?t=168047)

reinert 09-23-2011 16:19

SQL Syntax error
 
Quote:

L 09/23/2011 - 23:26:17: [AMXX] Plugin says: Incorrect table definition; there can be only one auto column and it must be defined as a key
L 09/23/2011 - 23:26:17: [AMXX] Run time error 1 (plugin "acommands.amxx") - forced exit
PHP Code:

new const szQuery[] =
    
"CREATE TABLE IF NOT EXISTS players ( player_id INT(6) NOT NULL AUTO_INCREMENT,\
    player_ip varchar(32),\
    player_name varchar(32),\
    player_auth varchar(32),\
    player_country varchar(3),\
    player_privileges int(2),\
    rank_kills int(6),\
    rank_deaths int(6),\
    rank_headshots int(6),\
    rank_skill int(6),\
    rank_points int(6),\
    ban_time int(6),\
    ban_reason varchar(64),\
    ban_admin varchar(32),\
    mute_time int(6),\
    mute_reason varchar(64),\
    mute_admin varchar(32),\
    last_online varchar(32))" 


Sylwester 09-23-2011 16:47

Re: SQL Syntax error
 
Code:

CREATE TABLE IF NOT EXISTS players ( player_id INT(6) AUTO_INCREMENT PRIMARY KEY, ...


All times are GMT -4. The time now is 19:41.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.