The query is:
log_camp_id_fk int(10) NOT NULL DEFAULT '0' ,
log_med_id_fk int(10) NOT NULL DEFAULT '0' ,
log_timestamp int(15) NOT NULL DEFAULT '0' ,
log_ip varchar(15) NOT NULL DEFAULT '' ,
log_type enum('1','2') NOT NULL DEFAULT '2'
)
...and the error is:
Reason: You have an error in your SQL syntax near 'Log( log_camp_id_fk int(10) NOT NULL DEFAULT '0' , log_med_id_fk int(10) NOT' at line 11064.
I just tried it again now incase it was a freaky error and it happened again. Using "Logs" worked fine :(
Code:
CREATE TABLE Log( log_camp_id_fk int(10) NOT NULL DEFAULT '0' ,
log_med_id_fk int(10) NOT NULL DEFAULT '0' ,
log_timestamp int(15) NOT NULL DEFAULT '0' ,
log_ip varchar(15) NOT NULL DEFAULT '' ,
log_type enum('1','2') NOT NULL DEFAULT '2'
)
...and the error is:
Reason: You have an error in your SQL syntax near 'Log( log_camp_id_fk int(10) NOT NULL DEFAULT '0' , log_med_id_fk int(10) NOT' at line 11064.
I just tried it again now incase it was a freaky error and it happened again. Using "Logs" worked fine :(
Quote:
Executed Query: CREATE TABLE Logs( log_camp_id_fk int(10) NOT NULL DEFAULT '0' , log_med_id_fk int(10) NOT NULL DEFAULT '0' , log_timestamp int(15) NOT NULL DEFAULT '0' , log_ip varchar(15) NOT NULL DEFAULT '' , log_type enum('1','2') NOT NULL DEFAULT '2' )