Logged In: YES
user_id=114435
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
[09:23am] 121 [/usr/local/apache/web-
netsaint/nsa/etc]:ether% mysql -u monachus -p netsaint
< tables.mysql
Enter password:
ERROR 1064 at line 191: You have an error in your SQL
syntax near 'TRUE NOT NULL,
KEY service_id (service_id),
PRIMARY KEY (host,description)
)' at line 20
the offending line sets the field 'enable' to a bool
datatype, which is invalid in mySQL.
since this is a dump of your database, i'm interested
to know what you have that i don't which enables
boolean datatypes.
you're running version
# Server version 3.22.23b
i'm running version 3.23.24b.
how did you get boolean types?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=114435
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
[09:23am] 121 [/usr/local/apache/web-
netsaint/nsa/etc]:ether% mysql -u monachus -p netsaint
< tables.mysql
Enter password:
ERROR 1064 at line 191: You have an error in your SQL
syntax near 'TRUE NOT NULL,
KEY service_id (service_id),
PRIMARY KEY (host,description)
)' at line 20
the offending line sets the field 'enable' to a bool
datatype, which is invalid in mySQL.
since this is a dump of your database, i'm interested
to know what you have that i don't which enables
boolean datatypes.
you're running version
# Server version 3.22.23b
i'm running version 3.23.24b.
how did you get boolean types?