vb.org Archive - $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.

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