[solved] SQL Emergency :(

Support for IntegraMOD 140

Moderator: Integra Moderator

[solved] SQL Emergency :(

PostAuthor: Apocal » 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:

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
Last edited by Apocal on Tue Jun 20, 2006 12:16 am, edited 1 time in total.
I understand MrDSL is the man to see for pcp.


- A tribute to the past.

Apocal
Members
Members
 
Posts: 65
Likes: 0 post
Liked in: 0 post
Joined: Fri Jun 16, 2006 3:08 pm
Cash on hand: 0.00

Re: SQL Emergency :(

PostAuthor: Apocal » Tue Jun 20, 2006 12:16 am

Code: 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)
Last edited by Apocal on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
I understand MrDSL is the man to see for pcp.


- A tribute to the past.

Apocal
Members
Members
 
Posts: 65
Likes: 0 post
Liked in: 0 post
Joined: Fri Jun 16, 2006 3:08 pm
Cash on hand: 0.00


Return to IntegraMOD 140

Who is online

Registered users: App360MonitorBot, Bing [Bot], Google [Bot]