vb.org Archive - SQL Database Problem

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

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - SQL Database Problem (https://vborg.vbsupport.ru/showthread.php?t=246136)

SQL Database Problem

Dear I Move My Forum Server, Moved Done But Some Problem Create in forum i cant view any Member Profile, Show This Error.
Profile Below Error Log

Quote:

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, usercsscache.cachedcss, IF(usercsscache.cachedcss IS NULL, 0, 1) AS hascachedcss, usercsscache.buildpermissions AS cssbuildpermissions, IF(userlist1.friend = 'yes', 1, 0) AS isfriend, IF (userlist1.friend = 'pending' OR userlist1.friend = 'denied', 1, 0) AS ispendingfriend, IF(userlist1.userid IS NOT NULL, 1, 0) AS u_iscontact_of_bbuser, IF (userlist2.friend = 'pending', 1, 0) AS requestedfriend, IF(userlist2.userid IS NOT NULL, 1, 0) AS bbuser_iscontact_of_user

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN sigpic AS sigpic ON (user.userid = sigpic.userid) LEFT JOIN usercsscache AS usercsscache ON (user.userid = usercsscache.userid)LEFT JOIN userlist AS userlist1 ON (userlist1.relationid = user.userid AND userlist1.type = 'buddy' AND userlist1.userid = 16)LEFT JOIN userlist AS userlist2 ON (userlist2.userid = user.userid AND userlist2.type = 'buddy' AND userlist2.relationid = 16)

WHERE user.userid = 33978;

MySQL Error : Unknown column 'customprofilepic.userid' in 'field list'
Error Number : 1054
Request Date : Thursday, July 8th 2010 @ 06:38:05 PM
Error Date : Thursday, July 8th 2010 @ 06:38:05 PM
Script : http://..................../member.php?u=3
Referrer : http://.........................../index.php
IP Address : 119.30.39.56
Username : kabir
Classname : vB_Database
MySQL Version : 5.0.91-community

Please Tell Me How To Solve This

You should ask over on vb.com since this isn't a question about a modification. Search first. I would run it by your new host too since they may have seen the problem before.

Im disable all modification but same problem

This doesn't have to be caused by a modification.

How did you move to the new serrver? What steps did you take?

PS What is the URL to your forum so we can see the issue in real life?

here site link http://www.gsmrapid.com/vbb/index.php

Code:

Database error in vBulletin 3.8.6:



Invalid SQL:



                SELECT 

                        userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,

                        IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, usercsscache.cachedcss, IF(usercsscache.cachedcss IS NULL, 0, 1) AS hascachedcss, usercsscache.buildpermissions AS cssbuildpermissions

                        

                FROM user AS user

                LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)

                LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN sigpic AS sigpic ON (user.userid = sigpic.userid) LEFT JOIN usercsscache AS usercsscache ON (user.userid = usercsscache.userid)

                

                WHERE user.userid = 3378;



MySQL Error   : Unknown column 'customprofilepic.userid' in 'field list'

Error Number  : 1054

Request Date  : Friday, July 30th 2010 @ 10:14:52 AM

Error Date    : Friday, July 30th 2010 @ 10:14:52 AM

Script        : http://www.gsmrapid.com/vbb/member.php?u=8772

Referrer      : http://www.gsmrapid.com/vbb/index.php

IP Address    : 119.30.39.56

Username      : anowar_virus

Classname     : vB_Database

MySQL Version : 

-->

You not answered how you performed the move.

1st Im backup my database MySQLDumper's Then im Compress All file & Folder on site root then download and Upload The New server. Then Install Dumper and Restore My database....

So the vBulletin files are still the same version as on your old server (ie. 3.8.6)?

There where no error messages when your restored the database?

If you look at the customprofilepic table, using for example phpMyAdmin, is there a column named userid?

Quote:

Originally Posted by Marco van Herwaarden (Post 2077118)

Thanks Dear Problem Solved column named userid Not Present There, i restored only customprofilepic Table .

Thanks Again Marco van Herwaarden

X vBulletin 3.8.12 by vBS Debug 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_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00937 seconds Memory Usage 1,745KB 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_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)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: