[solved] SQL Emergency :(
Posted: Mon Jun 19, 2006 11:41 pm<img>
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:
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
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:
- Code: 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