The Unforgiven
New Member
- Joined
- Dec 9, 2008
- Messages
- 73
- Reaction score
- 0
I tried uploading schema.sqlite to my phpMyAdmin, and got this...
SQL query:
CREATE TABLE "groups"(
"id"INTEGER PRIMARY KEY ,
"name"VARCHAR( 255 ) NOT NULL ,
"flags"INTEGER NOT NULL DEFAULT 0,
"access"INTEGER NOT NULL ,
"maxdepotitems"INTEGER NOT NULL ,
"maxviplist"INTEGER NOT NULL
);
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 '"groups" (
"id" INTEGER PRIMARY KEY,
"name" VARCHAR(255) NOT NULL,
' at line 1
Also, the tutorial I'm using says to find schema.sql, and there isn't a file by that name. Just the aforementioned schema.sqlite. Can I get some help?
SQL query:
CREATE TABLE "groups"(
"id"INTEGER PRIMARY KEY ,
"name"VARCHAR( 255 ) NOT NULL ,
"flags"INTEGER NOT NULL DEFAULT 0,
"access"INTEGER NOT NULL ,
"maxdepotitems"INTEGER NOT NULL ,
"maxviplist"INTEGER NOT NULL
);
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 '"groups" (
"id" INTEGER PRIMARY KEY,
"name" VARCHAR(255) NOT NULL,
' at line 1
Also, the tutorial I'm using says to find schema.sql, and there isn't a file by that name. Just the aforementioned schema.sqlite. Can I get some help?
Last edited: