Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-30-2008, 09:17 AM
Warlord's Avatar
Warlord Warlord is offline
 
Join Date: Jan 2002
Location: TN, USA
Posts: 668
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default $userinfo not parsing in User CP

I'm trying to figure out why I'm getting the following error when I visit my user cp on my site.


Quote:
Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT COUNT(*) AS comments FROM profilecomment
WHERE memberid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
Error Number : 1064
Date : Sunday, November 30th 2008 @ 05:55:36 AM
Script : http://www.projectfanboy.com/vb/usercp.php
Referrer : http://www.projectfanboy.com/vb/forumdisplay.php?f=64
IP Address : **.***.***.**
Username : StevenSykora
Classname : vB_Database
I'm not exactly sure when the error started occuring because I don't visit usercp.php much.

I'm using the Interactive Profiles hack by Psionic Vision, and it was working fine before. I started trying to add pieces of the MEMBERINFO template code to the USERCP_SHELL template. I tried removing those bits of code to see if I had caused the error by adding the code but still get the error.

I've also been running vBadvanced for quite some time, and recently performed the integration step on several vBulletin pages. I tried removing any pages I thought might be related to this problem from the vBadvanced integration and still get the error.

The only files that remain integrated are:

faq.php
calendar.php
forumdisplay.php
index.php
memberlist.php
showthread.php

I started searching files for the mysql query in the error and found this piece of code in profilecomment.php. It looks to me like the code isn't parsing $userinfo for some reason?

Quote:
// fetch count
$profilecommentscount = $db->query_first("
SELECT COUNT(*) AS comments FROM " . TABLE_PREFIX . "profilecomment
WHERE memberid = $userinfo[userid]
");
Am I totally off base here? Anyone have any ideas that might help me?

--------------- Added [DATE]1228048177[/DATE] at [TIME]1228048177[/TIME] ---------------

Nevermind, I figured it out. I had forgotten that I had edited the XML file originally packaged with the hack when I was trying to add some things to the User CP and overwritten the old product with it.

I uploaded the original XML file and my usercp works again.
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:44 PM.


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.03486 seconds
  • Memory Usage 2,225KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete