Error uploading Backup

Support for IntegraMOD 140

Moderator: Integra Moderator

Error uploading Backup

PostAuthor: Amarth » Thu Aug 10, 2006 9:36 am

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
Last edited by Amarth on Sat Aug 12, 2006 9:07 pm, edited 1 time in total.

Amarth
Members
Members
 
Posts: 32
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Fri Aug 04, 2006 9:28 pm
Cash on hand: 0.00

Re: Error uploading Backup

PostAuthor: Amarth » Sat Aug 12, 2006 9:05 pm

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.
Last edited by Amarth on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.

Amarth
Members
Members
 
Posts: 32
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Fri Aug 04, 2006 9:28 pm
Cash on hand: 0.00

PostAuthor: Unregistered » Sun Aug 13, 2006 7:19 am

this topic aint solved.. am havin some problems as well.. i wil post them in a short while..
Last edited by Unregistered on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
J O N H | P L A Y E R

Unregistered
Sr Integra Member
Sr Integra Member
 
Posts: 254
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Wed Jun 07, 2006 2:51 pm
Cash on hand: 0.00

Re: [SOLVED] Error uploading Backup

PostAuthor: Unregistered » Sun Aug 13, 2006 7:23 am

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)
Last edited by Unregistered on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
J O N H | P L A Y E R

Unregistered
Sr Integra Member
Sr Integra Member
 
Posts: 254
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Wed Jun 07, 2006 2:51 pm
Cash on hand: 0.00

PostAuthor: Adrian Rea » Sun Aug 13, 2006 2:08 pm

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
Last edited by Adrian Rea on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
User avatar
Adrian Rea
Sr Integra Member
Sr Integra Member
 
Posts: 1263
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sun Mar 12, 2006 12:59 am
Cash on hand: 0.00

PostAuthor: Unregistered » Sun Aug 13, 2006 2:31 pm

thanks Adrian Rea..
Last edited by Unregistered on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
J O N H | P L A Y E R

Unregistered
Sr Integra Member
Sr Integra Member
 
Posts: 254
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Wed Jun 07, 2006 2:51 pm
Cash on hand: 0.00

Re: Error uploading Backup

PostAuthor: found it » Sun Aug 20, 2006 3:44 am

Hi

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

just incase this is an error... :?:
Last edited by found it on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
[url=http]themes.[/url]
http://www.founditforum.com :: [url=http]Joining people together[/url]

[url=http][img=left]http://www.bbful.com/bbful_banner2.png[/img][/url]
User avatar
found it
Dev Team
Dev Team
 
Posts: 792
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Mon Mar 27, 2006 4:29 am
Cash on hand: 0.00

Re: Error uploading Backup

PostAuthor: Unregistered » Sun Aug 20, 2006 6:58 am

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..
Last edited by Unregistered on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
J O N H | P L A Y E R

Unregistered
Sr Integra Member
Sr Integra Member
 
Posts: 254
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Wed Jun 07, 2006 2:51 pm
Cash on hand: 0.00


Return to IntegraMOD 140

Who is online

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