IntegraMOD

Well, I was messing around with my databases and accidently deleted the wrong one. I deleted the database for my main forum. I have backups going all the way back to November. I used phpMyAdmin, through my host, to import the backup for August 8th. After waiting for some time, I got this error message:

Error

SQL query:

--
-- Table structure for table `phpbb_force_read_users`
--
CREATE TABLE phpbb_force_read_users(
user varchar( 255 ) NOT NULL default '',
READ int( 1 ) NOT NULL default '0',
time int( 10 ) NOT NULL default '0'
) TYPE = MYISAM ;

MySQL said: Documentation
#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 default '0',
time int(10) NOT NULL defau

What should I do to fix this? I'm using MySQL version 4.0.27-standard

Solved at last!

I asked on the phpbb forums and got an answer. I opened the backup and edited some stuff.


Changed this:

CREATE TABLE phpbb_force_read_users(
user varchar( 255 ) NOT NULL default '',
READ int( 1 ) NOT NULL default '0',
time int( 10 ) NOT NULL default '0'
) TYPE = MYISAM ;

To this:

CREATE TABLE phpbb_force_read_users(
`user` varchar( 255 ) NOT NULL default '',
`READ` int( 1 ) NOT NULL default '0',
`time` int( 10 ) NOT NULL default '0'
) TYPE = MYISAM ;

I don't know if this problem has ever been resolved in later versions, but I hope it will be fixed in version 1.4.1.

this topic aint solved.. am havin some problems as well.. i wil post them in a short while..

ok when i try to create this table

CREATE TABLE phphphpbbbb_ina_hall_of_fame(
game_id mediumint( 10 ) NOT NULL default '0',
current_user_id mediumint( 10 ) NOT NULL default '0',
current_score float( 10, 2 ) NOT NULL default '0.00',
current_date int( 10 ) NOT NULL default '0',
old_user_id mediumint( 10 ) NOT NULL default '0',
old_score float( 10, 2 ) NOT NULL default '0.00',
old_date int( 10 ) NOT NULL default '0'
) TYPE = MYISAM ;

i get this error

#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 'current_date int(10) NOT NULL default '0',
old_user_id mediu

(MySQL v 4.0.27)

I have removed the [solved] at the request of unregistered, as he continues to have isue. If this is found to be a seperate cause then we can split it later.

A

thanks Adrian Rea..

Hi

Code: Select all

CREATE TABLE phphphpbbbb_ina_hall_of_fame(game_id mediumint( 10 ) NOT NULL default '0',current_user_id mediumint( 10 ) NOT NULL default '0',current_score float( 10, 2 ) NOT NULL default '0.00',current_date int( 10 ) NOT NULL default '0',old_user_id mediumint( 10 ) NOT NULL default '0',old_score float( 10, 2 ) NOT NULL default '0.00',old_date int( 10 ) NOT NULL default '0') TYPE = MYISAM ;

just a quick question is this how your tables are set up in your database using

Code: Select all

phphphpbbbb

just incase this is an error...

hi, thanks for lookin into this..

Actually i have found the problem.. first of all, i have no reason for me to post my db prefix )
and that file (db backup from myphpadmin) had no errors..

so wat am thinkin is, am missing something or some field settings from "phpbb-backup-suite" when backin up MySQL DB..
If there is a setting to set in phpbb-backup-suite Mysql db backup page, then do let me know..

thanks..