vb.org Archive - database error issue

Page 1 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - database error issue (https://vborg.vbsupport.ru/showthread.php?t=154166)

rjp0615

08-03-2007 03:28 AM

database error issue

can someone shed some light on this for me? i just imported a db dump into a new server

Quote:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT pf.profilefieldid, pf.profilefieldcategoryid, pf.required, pf.type, pf.data, pf.def, pf.height
FROM profilefield AS pf
LEFT JOIN profilefieldcategory AS pfc ON(pfc.profilefieldcategoryid = pf.profilefieldcategoryid)
WHERE pf.form = 0
ORDER BY pfc.displayorder, pf.displayorder;

MySQL Error : Table 'wrest7_forums.profilefieldcategory' doesn't exist
Error Number : 1146
Date : Thursday, August 2nd 2007 @ 10:26:40 PM
Script : http://wrestling-dungeon.net/forums/member.php?u=4716
Referrer : http://wrestling-dungeon.net/forums/...d.php?p=228347
IP Address : 75.35.243.47
Username : Dreamer
Classname : vb_database

Antivirus

08-03-2007 03:30 AM

iut seems like it's got something to do with the table prefix. Can you include your code for the query which is giving this error?

rjp0615

08-03-2007 03:35 AM

its no query, i just imported my forum to a new host, 5000+ members and this happened

Antivirus

08-03-2007 03:39 AM

It seems as though the database is expecting the table 'wrest7_forums.profilefieldcategory' to be in the database and it's not there. Look in your sql file you are trying to import and see if there's anything like DROP IF EXISTS, or CREATE TABLE, etc...

rjp0615

08-03-2007 03:41 AM

you're speaking greek to me now

Antivirus

08-03-2007 03:48 AM

the server is telling you the following error:

MySQL Error : Table 'wrest7_forums.profilefieldcategory' doesn't exist

It's expecting that table to exist and it doesn't.

How did you do your import? Using IMPEX or a mysql dump file?

ALSO: does your new vb installation's cfg file have anything set under the "table prefix" setting?

rjp0615

08-03-2007 03:54 AM

mysql dump, and no table prefix

R1lover

08-03-2007 04:01 AM

Is the old site still up? so you can try another backup of the database?

rjp0615

08-03-2007 04:03 AM

no, i just bought this site of somebody else, and this was the only backup i was given

R1lover

08-03-2007 04:15 AM

The only thing I can think to do, is to create the table and then see what happens.

There won't be any data in it but that may not be a big issue.

All times are GMT. The time now is 08:43 AM.

Page 1 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02187 seconds Memory Usage 1,725KB 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)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: