Went from 7.8 to raven76, want to import my forums though.

Worker Joined: Jun 01, 2005 Posts: 178

I cant seem to import my old forums into ravennuke.

I go to our old site, admin, forums, then backup database, and download the .sql.
I then go to my ravennuke install, and try to restore the database from admin, and get this error:

Code:

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 ' <' at line 1

Our old site just used the forums that came with nuke (phpBB 2.0.15) i believe.

Any help would be greatly appriciated.

Posted: Sat Jul 29, 2006 3:14 pm

This process has been well documented in these forums.
The error probably doesn't seem to be one I have seen before though as a sql file would not nornally start with a < but a php file would.

Posted: Sat Jul 29, 2006 4:03 pm

Hmm, very good point. Where would I look (what file) to find this. It doesnt give me a filename in the error, so im not sure which to use.

Posted: Sat Jul 29, 2006 4:59 pm

The error is in the file you are trying to import the backup from "Error importing backup file".
What are the first few lines in that file?

Posted: Sat Jul 29, 2006 5:38 pm

Hmm, looks like the .sql its downloading is the HTML of the phpscript that backs up the database.....thats wierd

Posted: Sat Jul 29, 2006 5:44 pm

If you post the first few and last few lines it will help me determine the fix for this.
I presume you are trying to import the 'back up' into phpmyadmin?

Posted: Sat Jul 29, 2006 5:48 pm

Code:

#


# phpBB Backup Script


# Dump of tables for clangoat_nuke1


#


# DATE : 29-07-2006 20:39:33 GMT


#


#


# TABLE: auth_access


#


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">


<html>

Posted: Sat Jul 29, 2006 5:58 pm

I see whats happened.
You should have exported the data using phpmyadmin not the forum back up facility.
The forum back up has never worked for me.

Does the file actually contain any sql data?
How big is the file?

Posted: Sat Jul 29, 2006 6:00 pm

nah, just the html template for the backup.

I did manager to download the old db from backup db in my old nuke admin area, so im importing that one into phpmyadmin as we speak.

I will update soon.

Posted: Sat Jul 29, 2006 6:13 pm

Lets say I want to import EVERYTHING from our old phpnuke site, is the backup db the method I would use (nuke_users, and all my forums and stuff)

Or would it mess anything up?

Posted: Sat Jul 29, 2006 6:20 pm

I'm not sure which of the steps discussed in other threads dealing with this that you have done.
Essentially, you need to 'downgrade' the table structure to ensure it matches the structure used by Raven Nuke.
I beieve there is a 'sticky' post made by Raven detailing the steps required.

Posted: Sat Jul 29, 2006 6:39 pm

I did find his post.

I dont wanna upload, and overwrite the files with the rn76 because I have already a fully functional install. How would I downgrade the tables, backup, get everything in the rnuke folder, and restore the tables without messing anything up.

Posted: Sat Jul 29, 2006 7:40 pm

Ok, i did exactly what that post said.....and at first I could not add blocks or anything, but then I noticed I forgot to run the 2 sql installs.

Here is what I did:

Did I do this right???

Posted: Sat Jul 29, 2006 9:10 pm

So far so good, except im having trouble with the gallery image block not displaying correctly.

Seems to bleed out of the block. [ Only registered users can see links on this board! Get registered or login! ]

Posted: Sun Jul 30, 2006 4:53 am

It would be worth checking and comparing the structure of both of those tables. If you are unsure, just post the 'downgraded' table structures here and I'll take a look as soon as I can.

Posted: Sun Jul 30, 2006 12:12 pm

well, i think its a theme issue to be honest, because i loaded up the nukenews theme, and it was inside the block.

What exactly do you need me to do.

Posted: Sun Jul 30, 2006 5:51 pm

fixed it, i can modify the thumbnail size in the block.

I do want to make sure I got nukesentinal setup correctly.....how could I check that.

Posted: Thu Aug 03, 2006 1:40 pm

I just tried to search my forums, and get this error.

Code:

Could not delete old search id sessions





DEBUG MODE





SQL Error : 1054 Unknown column 'search_time' in 'where clause'





DELETE FROM nuke_bbsearch_results WHERE search_time < 1154630727





Line : 668


File : search.php

Guardian2003, are you still willing to take a look at my tables?

Posted: Thu Aug 03, 2006 2:14 pm

Sure, not a problem but I'm sorta floating between different places at the moment for the next few days so I'm not at my normal PC.
You can email them to me if you wish (zipped) [ Only registered users can see links on this board! Get registered or login! ] and I'll look at tem asa soon as I can bud.

Posted: Sun Aug 06, 2006 10:55 pm

Guardian2003, I cant email you dude, everytime I try I get this:

Code:

This message was created automatically by mail delivery software. A message that you sent has not yet been delivered to one or more of its recipients after more than 48 hours on the queue on srv04.hostww.net.





The message identifier is:     1G94Jm-0002nr-30


The subject of the message is: here you go man


The date of the message is:    Fri, 4 Aug 2006 14:23:37 -0400





The address to which the message has not yet been delivered is:





  [ Only registered users can see links on this board! Get registered or login! ]





No action is required on your part. Delivery attempts will continue for some time, and this warning may be repeated at intervals if the message remains undelivered. Eventually the mail delivery software will give up, and when that happens, the message will be returned to you.

Posted: Sun Aug 06, 2006 11:53 pm

Looks like your host has a limit imposed.
Can you upload the zip to your website and send me PM me a link?

Posted: Mon Aug 28, 2006 2:50 pm

OK sorry for the delay - you know why Wink

I checked your sql and found the following;
You have two tables relating to banner clients.
The nuke_banner_clients (notes the 's' at the end) seems to be from your nuke 7.8 so you can safely delete that table.
You have the correctly named nuke_banner_client table already so thats fine.

For some reason you are actually missing two required tables, these are nuke_bbconfirm and nuke_bbsessions_keys.

Here is the sql to put in phpmyadmin to create those two tables.

Code:




CREATE TABLE `nuke_bbconfirm` (


  `confirm_id` char(32) NOT NULL default '',


  `session_id` char(32) NOT NULL default '',


  `code` char(6) NOT NULL default '',


  PRIMARY KEY  (`session_id`,`confirm_id`));





CREATE TABLE `nuke_bbsessions_keys` (


  `key_id` varchar(32) NOT NULL default '0',


  `user_id` mediumint(8) NOT NULL default '0',


  `last_ip` varchar(8) NOT NULL default '0',


  `last_login` int(11) NOT NULL default '0',


  PRIMARY KEY  (`key_id`,`user_id`),


  KEY `last_login` (`last_login`));

Posted: Mon Aug 28, 2006 10:56 pm

I did that, but im still getting this

Code:




Could not delete old search id sessions





DEBUG MODE





SQL Error : 1054 Unknown column 'search_time' in 'where clause'





DELETE FROM nuke_bbsearch_results WHERE search_time < 1156823573





Line : 668


File : search.php

Posted: Tue Aug 29, 2006 6:00 am

OK I'll take a look at that.

Posted: Tue Aug 29, 2006 6:12 am

Can you walk me through the steps you are taking to get this so I can try and reproduce it please.
I have search all my archived and current copies of files and find no field 'search_time' in that table anywhere so I'm guessing that search_time is actually a variable that has not been assigned a value correctly.