[wmabon]

TECK,

I installed vbHome (lite) to evaluate, and I've hit a bit of a bump in the road....

I would greatly appreciate your help in getting this up and running.

I read your instructions and I did not have any problems with steps 1-4 (to the best of my knowledge).

For Step 5 I did not find the modifyavatar template and I skipped this step. Perhaps vBulletin, which I paid to do the installation, did not include this file??

Step 6 also did not seem consistent with what I was finding, and I skipped this as well.

Step 7 I modified a few of the smile paths, and this seemed easy enough.

Step 8 I made an avatar image and changed the path to a full path, and this worked ok.

In Step 9 I generated a Journalists user group, but did not understand your comment about usergroup IDs.

I performed step 10

In step 11...

I uploaded the index to: /big/dom/xobesitypolicy/www

which I take to be my root dir.

I uploaded printarticle.php, but newthread.php was not in the installation I downloaded from you, so I skipped that.

template.php was already in my ADMIN dir, and not available for uploading...

I had no problem uploading the images...

For the final step, running the installer, I uploaded vbhlinstall to my root directory and just got a white screen in the browser...

Then when I went to the domain, obesitypolicy.com, I got:


Database error in vBulletin 2.2.8:

Invalid SQL:
SELECT COUNT(*) AS threads, SUM(IF(forumid<>, 1, 0)) AS threads, SUM(IF(forumid=, 1, 0)) AS headlines
FROM thread
WHERE lastpost>1035299570

mysql error: You have an error in your SQL syntax near ' 1, 0)) AS threads, SUM(IF(forumid=, 1, 0)) AS headlines
FROM thread
WHERE l' at line 2

mysql error number: 1064

Date: Tuesday 22nd of October 2002 04:57:02 PM
Script: http://obesitypolicy.com/vbulletin/
Referer:


TECK,

Any thoughts would be much appreciated? Can my company pay you to install this properly? My computer skills are pretty marginal. I'm doing this because we're a small organization....