Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro
Author Message
ciph3r
Worker
Worker


Joined: Jun 01, 2005
Posts: 178

PostPosted: Sat Jul 29, 2006 2:52 pm Reply with quote

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.
 
View user's profile Send private message Visit poster's website
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6792
Location: Ha Noi, Viet Nam

PostPosted: Sat Jul 29, 2006 3:14 pm Reply with quote

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.
 
View user's profile Send private message Send e-mail
ciph3r
PostPosted: Sat Jul 29, 2006 4:03 pm Reply with quote

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
PostPosted: Sat Jul 29, 2006 4:59 pm Reply with quote

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
PostPosted: Sat Jul 29, 2006 5:38 pm Reply with quote

Hmm, looks like the .sql its downloading is the HTML of the phpscript that backs up the database.....thats wierd
 
Guardian2003
PostPosted: Sat Jul 29, 2006 5:44 pm Reply with quote

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
PostPosted: Sat Jul 29, 2006 5:48 pm Reply with quote

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
PostPosted: Sat Jul 29, 2006 5:58 pm Reply with quote

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
PostPosted: Sat Jul 29, 2006 6:00 pm Reply with quote

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
PostPosted: Sat Jul 29, 2006 6:13 pm Reply with quote

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
PostPosted: Sat Jul 29, 2006 6:20 pm Reply with quote

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
PostPosted: Sat Jul 29, 2006 6:39 pm Reply with quote

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
PostPosted: Sat Jul 29, 2006 7:40 pm Reply with quote

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:

    1. I ran phpmyadmin, and backed up my nuke installation. (nuke.sql)

    2. I then ran the downgrading script from 7.8, to 7.6.

    3. Once the tables were downgraded, I exported ALL of the tables to a .sql file. (RNuke.sql)

    4. I then dropped all of the tables to my RNuke installation, and imported my nuke database I just made (nuke.sql)

    5. I then ran InstallSQL.php, and installed the NSN Groups tables, and the NukeSentinal tables.

    6. Started moving my blocks and images over.......so far so good.

    My forums, users, and everything else seems to be imported, although i did get 2 failed ALTER TABLE errors when I ran the downgrade script.

    Operation Status!
    --------------------------------------------------------------------------------
    - ALTER TABLE nuke_banner_clients failed
    - ALTER TABLE nuke_modules failed
    )


Did I do this right???
 
ciph3r
PostPosted: Sat Jul 29, 2006 9:10 pm Reply with quote

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!
 
Guardian2003
PostPosted: Sun Jul 30, 2006 4:53 am Reply with quote

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
PostPosted: Sun Jul 30, 2006 12:12 pm Reply with quote

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
PostPosted: Sun Jul 30, 2006 5:51 pm Reply with quote

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
PostPosted: Thu Aug 03, 2006 1:40 pm Reply with quote

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
PostPosted: Thu Aug 03, 2006 2:14 pm Reply with quote

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.
 
ciph3r
PostPosted: Sun Aug 06, 2006 10:55 pm Reply with quote

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.
 
Guardian2003
PostPosted: Sun Aug 06, 2006 11:53 pm Reply with quote

Looks like your host has a limit imposed.
Can you upload the zip to your website and send me PM me a link?
 
Guardian2003
PostPosted: Mon Aug 28, 2006 2:50 pm Reply with quote

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
PostPosted: Mon Aug 28, 2006 10:56 pm Reply with quote

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
PostPosted: Tue Aug 29, 2006 6:00 am Reply with quote

OK I'll take a look at that.
 
Guardian2003
PostPosted: Tue Aug 29, 2006 6:12 am Reply with quote

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.
 
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.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot 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
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©