Log in

View Full Version : Problem Transfering Forum SQL


netdebut
10-02-2006, 10:07 AM
I don't know if I can even post this here, but I'm having trouble transfering my old forum database to another. I've changed hosts and tried to move... I'm willing to pay someone to help me with this.

It's suppose to be quick and simple, but there's an error in the word table. Something about the "it?s" syntax. I'm unable to log into the main forum area..... nor control panel. And when I finally got it to login, it messes up with the control panel and when trying to log out.

morrow
10-03-2006, 03:08 AM
why not run a repair on your db?

netdebut
10-03-2006, 05:37 AM
Are you talking about the option under "Maintenance" for "Repair / Optimize Tables?"

I tried the tab [Fix Unique Indexes]. It doesn't work.

Here's what I get:

There seems to have been a problem with the Networker's Debut Private Forum database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

We apologise for any inconvenience.

And then:

Database error in vBulletin 3.6.1:

Invalid SQL:
SELECT varname, languageid, phrasetypeid, COUNT(*) AS occurences
FROM phrase
GROUP BY varname, languageid, phrasetypeid
HAVING occurences > 1;

MySQL Error : Unknown column 'phrasetypeid' in 'field list'
Error Number : 1054
Date : Tuesday, October 3rd 2006 @ 01:35:30 AM
Script : http://www.networkersdebut.com/forum/admincp/repair.php
Referrer : http://www.networkersdebut.com/forum/admincp/repair.php?do=list
IP Address : 199.121.156.50
Username : netdebut
Classname : vb_database