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..
Statistics: Posted Author: Unregistered — Sun Aug 20, 2006 6:58 am
]]>
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
phphphpbbbb
just incase this is an error...
Statistics: Posted Author: found it — Sun Aug 20, 2006 3:44 am
]]>
]]>
A
Statistics: Posted Author: Adrian Rea — Sun Aug 13, 2006 2:08 pm
]]>
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)
Statistics: Posted Author: Unregistered — Sun Aug 13, 2006 7:23 am
]]>
]]>
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.
Statistics: Posted Author: Amarth — Sat Aug 12, 2006 9:05 pm
]]>
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
Statistics: Posted Author: Amarth — Thu Aug 10, 2006 9:36 am
]]>