#19 Errors in MySQL Database before install

[Anonymous]

When the basilix.sql was run by MySQL, the following
errors were produced:

Error

SQL-query :

USE BASILIX \ p \ g CREATE TABLE ADDRESSBOOK(
ROWID BIGINT( 21 ) NOT NULL DEFAULT '1' AUTO_INCREMENT ,
OWNERID BIGINT( 21 ) NOT NULL ,
NICKNAME VARCHAR( 20 ) NOT NULL ,
EMAIL VARCHAR( 64 ) NOT NULL ,
NAME VARCHAR( 64 ) ,
TELEPHONE VARCHAR( 64 ) ,
FAX VARCHAR( 64 ) ,
NOTE VARCHAR( 128 ) ,
PRIMARY KEY ( ROWID )
) \ p \ g CREATE TABLE ADDRESSBOOKGRP(
ROWID BIGINT( 21 ) NOT NULL DEFAULT '1' AUTO_INCREMENT ,
OWNERID BIGINT( 21 ) NOT NULL ,
GRPNAME VARCHAR( 32 ) NOT NULL ,
MEMBERS VARCHAR( 128 ) NOT NULL DEFAULT '',
PRIMARY KEY ( ROWID )
) \ p \ g CREATE TABLE SESSION(
CUSTOMERID BIGINT( 21 ) NOT NULL DEFAULT '1'
AUTO_INCREMENT ,
USERNAME VARCHAR( 32 ) NOT NULL ,
DOMAIN VARCHAR( 64 ) NOT NULL ,
PASSWORD VARCHAR( 96 ) ,
SESSIONID VARCHAR( 36 ) ,
LASTACCESS VARCHAR( 12 ) NOT NULL ,
LASTTIME VARCHAR( 12 ) NOT NULL ,
LASTHOST VARCHAR( 64 ) NOT NULL ,
LASTADDR VARCHAR( 16 ) NOT NULL ,
LASTFOLDERS TEXT,
PRIMARY KEY ( CUSTOMERID )
) \ p \ g CREATE TABLE SETTINGS(
ROWID BIGINT( 21 ) NOT NULL DEFAULT '1' AUTO_INCREMENT ,
CUSTOMERID BIGINT( 21 ) NOT NULL ,
NAME VARCHAR( 64 ) ,
SIGN VARCHAR( 80 ) ,
LANG INT NOT NULL DEFAULT '1',
SORT INT NOT NULL DEFAULT '1',
RSORT INT NOT NULL DEFAULT '1',
PSIZE INT NOT NULL DEFAULT '20',
SAVESENT INT NOT NULL DEFAULT '0',
MOVETRASH INT NOT NULL DEFAULT '0',
THEME INT NOT NULL DEFAULT '0',
IFEXPAND CHAR( 1 ) NOT NULL DEFAULT '0',
PREVNEXT CHAR( 1 ) NOT NULL DEFAULT '0',
REPLYTO VARCHAR( 96 ) ,
PRIMARY KEY ( ROWID )
) \ p \ g CREATE TABLE SENDMSGS(
MSGID BIGINT( 21 ) NOT NULL DEFAULT '1' AUTO_INCREMENT ,
CUSTOMERID BIGINT( 21 ) NOT NULL ,
MSGDATE VARCHAR( 12 ) NOT NULL ,
MSGFROM VARCHAR( 64 ) ,
MSGTO TEXT,
MSGCC TEXT,
MSGBCC TEXT,
MSGSUBJECT VARCHAR( 64 ) ,
MSGBODY TEXT,
MSGATCHS TEXT,
PRIMARY KEY ( MSGID )
) \ p \ g

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 '\ p \ g
CREATE TABLE ADDRESSBOOK( ROWID BIGINT( 21 ) NOT NU

Weird? yes
e-mail: HM(at)HMStudios.net
MSN: MSN(at)HMStudios.net
AIM: HMHackMaster
ICQ:298181767
Yahoo!:HMHackMaster
Integrity Messenger: HMHackMaster

[Nobody/Anonymous]

Logged In: NO

What version of mysql?

[Cesaradf]

Logged In: YES
user_id=1053848

I had the same error
Mysql 4.1

[Mike Peters]

Logged In: YES
user_id=883360

Could you try the attached file instead.

[Cesaradf]

Logged In: YES
user_id=1053848

So, is going to be any patch or file update to solve this
problem?

[Cesaradf]

Logged In: YES
user_id=1053848

With MySQL 4.0.2 it gives me the same error

[Mike Peters]

Logged In: YES
user_id=883360

OK, new file. Could you try this one.

[Cesaradf]

Logged In: YES
user_id=1053848

"This one" what? There is no attached file.

[Mike Peters]