-
Scripting Help
(
https://forums.alliedmods.net/forumdisplay.php?f=11)
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.