You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 68 guest(s) and 1 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - Restore PHPBB Database Error [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
This forum is locked: you cannot post, reply to, or edit topics.  This topic is locked: you cannot edit posts or make replies.printer-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
SilentOne
Guest






PostPosted: Thu Oct 13, 2005 8:39 pm Reply with quoteBack to top

Whenever I attempt to back up and restore my phpbb2.0.15 forum, I recieve this error upon the 'Restore Database' step. The error occurs no matter whether I pick a full backup, or just restore data or structure.

Quote:
Error importing backup file

DEBUG MODE

SQL 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 '


My main objective is to backup my database, then restore it onto a different forum (running the same version of PHPBB). However, I recieve this error trying to restore on both forums.

Any ideas?
Find all posts by Anonymous
Guest







PostPosted: Thu Oct 13, 2005 8:42 pm Reply with quoteBack to top

Probably should mention that the original site from which the apparently flawed PHPBB database is coming from is running PHPNuke, and the second one is not.
Find all posts by Anonymous
Evaders99
Site Admin
Site Admin


Joined: Aug 17, 2003
Posts: 12372


PostPosted: Thu Oct 13, 2005 9:21 pm Reply with quoteBack to top

phpBB and phpNuke tables are not compatible. You cannot restore one into another. You will need phpBB to phpNuke OR phpNuke to phpBB converter

_________________
Helping those that help themselves
Read FIRST or DIE!

"Fighting is terrible, but not as terrible as losing the will to fight."
Star Wars Rebellion Network - Need Help? Evaders Squadron Coding
Find all posts by Evaders99View user's profileSend private messageVisit poster's websiteAIM Address
Guest







PostPosted: Fri Oct 14, 2005 5:42 am Reply with quoteBack to top

1) I got the same error backing up from the PHPNuke to the PHPNuke
2) Where can I find such a converter?
Find all posts by Anonymous
Evaders99
Site Admin
Site Admin


Joined: Aug 17, 2003
Posts: 12372


PostPosted: Fri Oct 14, 2005 11:52 am Reply with quoteBack to top

The script backup options aren't too reliable. I recommend using phpMyAdmin instead.

A phpBB to phpNuke converter is available at http://www.nukeresources.com

_________________
Helping those that help themselves
Read FIRST or DIE!

"Fighting is terrible, but not as terrible as losing the will to fight."
Star Wars Rebellion Network - Need Help? Evaders Squadron Coding
Find all posts by Evaders99View user's profileSend private messageVisit poster's websiteAIM Address
Display posts from previous:      
This forum is locked: you cannot post, reply to, or edit topics.  This topic is locked: you cannot edit posts or make replies.printer-friendly view
View previous topic Log in to check your private messages View next topic
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by · TOGETHER TEAM srl ITALY http://www.togetherteam.it · DONDELEO E-COMMERCE http://www.DonDeLeo.com
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.190 Seconds - 347 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::