[TECK]

Originally posted by AmericanWoman
Ok, so that wasn't it. Hubby had been intelligent enough to edit the config.php to point to the proper database when he upgraded the dev site (thank heaven for small favors).

Here's the error:

Warning: Failed opening 'vbs_counter.php' for inclusion (include_path='') in /home/acurawo/public_html/dev/global.php(337) : eval()'d code on line 4

And here's the query generating the error:

Invalid SQL:
SELECT COUNT(*) AS total
FROM thread
WHERE dateline>1041714961 AND forumid IN( )

mysql error: You have an error in your SQL syntax near ')
' at line 4

Any ideas?

Is your vbStats hack. Just remove from phpinclude template the vbstats line and you are ok.
To get it working for the forum, add that line in the /forum global.php, just above:
[high]header = '';[/high]

Notice the empty [high]IN( )[/high]? that means you did not set yet your vbHome options and they are not cached in vBulletin yet (article forum). All you have to do is set at least one option in vbHome Page and it will automatically cache all vbHL options.

I also noticed you said something about full path etc?
In vbHL global.php you should have:
[high]$adminpath = 'yourforumfolder/admin';[/high] ONLY. Not the full path. Do not edit anything in the config.php file, is not needed.