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

ciph3r · 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.

Guardian2003 · 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.

ciph3r · Worker Joined: Jun 01, 2005 Posts: 178

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.

Guardian2003 · 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?

ciph3r · Worker Joined: Jun 01, 2005 Posts: 178

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

Guardian2003 · 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?

ciph3r · Worker Joined: Jun 01, 2005 Posts: 178

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>

Guardian2003 · 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?

ciph3r · Worker Joined: Jun 01, 2005 Posts: 178

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.

ciph3r · Worker Joined: Jun 01, 2005 Posts: 178

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?

Guardian2003 · 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.

ciph3r · Worker Joined: Jun 01, 2005 Posts: 178

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.

ciph3r · Worker Joined: Jun 01, 2005 Posts: 178

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???

ciph3r · Worker Joined: Jun 01, 2005 Posts: 178

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 to the forums!

Guardian2003 · 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.

ciph3r · Worker Joined: Jun 01, 2005 Posts: 178

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.

ciph3r · Worker Joined: Jun 01, 2005 Posts: 178

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.

ciph3r · Worker Joined: Jun 01, 2005 Posts: 178

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?

Guardian2003 · 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 to the forums!

and I'll look at tem asa soon as I can bud.

ciph3r · Worker Joined: Jun 01, 2005 Posts: 178

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 to the forums!

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.

Guardian2003 · 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?

Guardian2003 · 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`));

ciph3r · Worker Joined: Jun 01, 2005 Posts: 178

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

Guardian2003 · Posted: Tue Aug 29, 2006 6:00 am

OK I'll take a look at that.

Guardian2003 · 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.