vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Problem Transfering Forum SQL (https://vborg.vbsupport.ru/showthread.php?t=128066)

netdebut 10-02-2006 10:07 AM

Problem Transfering Forum SQL
 
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...ir.php?do=list
IP Address : 199.121.156.50
Username : netdebut
Classname : vb_database


All times are GMT. The time now is 05:59 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01554 seconds
  • Memory Usage 1,714KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete