vb.org Archive - need help with SQL

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

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

- - need help with SQL (https://vborg.vbsupport.ru/showthread.php?t=150447)

mattonline

06-23-2007 01:16 PM

need help with SQL

OK so heres the story, for some reason my forum http://www.EntrepreneurForum.co.uk went down, lost its SQL database or something (not sure how it happend) so i re-installed the files, but i put in 3.67 files when the database was 3.65, and there were still errors, so i ran install/install.php and updated the database which is fine, but when i got to view members profiles

http://entrepreneurforum.co.uk/membe...lastposter&f=2
and some posts
http://entrepreneurforum.co.uk/showt...=4693#post4693
and this one is weird
http://entrepreneurforum.co.uk/showthread.php?t=2546

none of the threads work, how do i get them to work again? what do i do, i still have the SQL backup from the 22nd of june

thanks in advance

Do you suggest i re-install the forum, in 3.65 ?

anyone know

Dismounted

06-24-2007 04:59 AM

Those threads may have been created after the database backup, and therefore would not exist anymore.

mattonline

06-24-2007 06:48 AM

hm, if they were created after the DB backup then wouldn't they not be there,

But i've been able to sort the situation out now.

I've made it so your able to view the threads they work now.

But i keep having errors when i go to post a reply, such as MYSQL ones, but the message will still post fine, (am i missing a certain file?)

and i get DB error when i go to a profile.
http://www.entrepreneurforum.co.uk/m...lastposter&f=3

Lynne

06-24-2007 02:39 PM

Do you get the mysql error mailed to you? It would help if we could see it posted.

mattonline

06-24-2007 03:11 PM

Ok its shown below, i've managed to fix the one problem, of the error message comming up when you post a reply button, which was that i didn't have VBAdavnced installed, so that error is fixed now.

PHP Code:


		
			
Database error in vBulletin 3.6.5:



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 

            AND pf.hidden = 0

    ORDER BY pfc.displayorder, pf.displayorder;



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

Error Number : 1146

Date         : Sunday, June 24th 2007 @ 06:07:49 PM

Script       :

http://www.entrepreneurforum.co.uk/member.php?find=lastposter&t=16

Referrer     : 

IP Address   : 210.150.10.105

Username     : Unregistered

Classname    : vB_Database

Lynne

06-27-2007 01:50 PM

Do you have a table called "profilefieldcategory" (it's not standard in my vbulletin installation)? Could that be from VBAdvanced also?

All times are GMT. The time now is 12:15 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01555 seconds Memory Usage 1,727KB 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_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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
Messages: