Re: SQL Emergency :(

2006-06-20T00:16:16-07:00

Line number On/Off | Expand/Contract | Select all

CREATE TABLE IF NOT EXISTS `phpbb_force_read_users` (`user` varchar( 255 ) NOT NULL ,`read` int( 1 ) NOT NULL ,`time` int( 10 ) NOT NULL)

Statistics: Posted Author: Apocal — Tue Jun 20, 2006 12:16 am

[solved] SQL Emergency :(

2006-06-20T00:16:47-07:00

I was trying to do a mod and made sure that I made a back up of both my files and my database before doing so. Needless to find, I found that the mod is not compatible with Integramod. Therefore I dropped my tables for the old tables, but I found the following error:

Line number On/Off | Expand/Contract | Select all

CREATE TABLE phpbb_force_read_users(user varchar( 255 ) NOT NULL ,READ int( 1 ) NOT NULL ,time int( 10 ) NOT NULL);#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 'read int(1) NOT NULL, time int(10) NOT NULL)' at line 3

In order to get the database upload to go through correctly I deleted the folowing code]# TABLE: phpbb_force_read_users#DROP TABLE IF EXISTS phpbb_force_read_users;CREATE TABLE phpbb_force_read_users( user varchar(255) NOT NULL, read int(1) NOT NULL, time int(10) NOT NULL);[/code]

Does anyone have this code, or know how to fix this so I can complete the upload?

tx, rich

Statistics: Posted Author: Apocal — Mon Jun 19, 2006 11:41 pm

IntegraMOD

Re: SQL Emergency :(

[solved] SQL Emergency :(