[YLP1]

I think I may have found what is causing this error. BUT I am not that familiar with PHP or VB so I have to rely on you php/vb gurus to help a girl out on this.

Here are the DB errors I receive from several vb pages:

Database error in vBulletin 3.0.7:

Invalid SQL: 
SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline
FROM vb3_user AS user
LEFT JOIN vb3_avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN vb3_customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid = 
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 5

mysql error number: 1064

Date: Sunday 01st of May 2005 09:39:30 PM
Script: http://www.yourlincolnpark.com/lpsforum/lpsforum.php
Referer: http://yourlincolnpark.com/lpsforum/index.php


Error occurs on these pages as well:

Date: Monday 02nd of May 2005 04:33:37 PM
Script: http://www.yourlincolnpark.com/lpsforum/lpsforum.php
Referer: http://www.yourlincolnpark.com/LPSForum/private.php?

mysql error number: 1064

Date: Sunday 01st of May 2005 09:37:57 PM
Script: http://www.yourlincolnpark.com/lpsforum/lpsforum.php
Referer: 

mysql error number: 1064

Date: Friday 29th of April 2005 01:20:16 PM
Script: http://www.yourlincolnpark.com/LPSForum/lpsforum.php
Referer: http://www.yourlincolnpark.com/LPSForum/showthread.php?t=5206

mysql error number: 1064

Date: Friday 29th of April 2005 06:41:57 PM
Script: http://www.yourlincolnpark.com/LPSForum/lpsforum.php
Referer: http://www.yourlincolnpark.com/LPSForum/search.php?searchid=

mysql error number: 1064

Date: Saturday 30th of April 2005 01:05:47 AM
Script: http://www.yourlincolnpark.com/LPSForum/lpsforum.php
Referer: http://www.yourlincolnpark.com/LPSForum/forumdisplay.php?f=22

After many hours or researching the error code and all vb sites this is what I found:

In showthead.php the journal code looks like below. However, this is something that I did not add so I am thinking the install script installed this??? The journal instructions indicate that this:
should be added to the memberlist.php which I did do.

Notice the word "journal" that was added (again by the Install script as I did not add this to my showthread.php file)

LEFT JOIN " . TABLE_PREFIX . "journals AS journal ON(journal.journalist_id = user.userid)

The instructions for the Journal say to add the below code to the Memberlist.php file:

LEFT JOIN " . TABLE_PREFIX . "journals AS journals ON(journals.journalist_id=user.userid)

Notice that the word "journal" in this code is journals (plural).

Since I am very new to PHP and VB, is this plural word of journal causing the error as indicated above?

If it isn't that ...can someone help me fix this error as I have tried everything.

U have attached my showthread file (I hope this is ok to do) in hopes that someone can help me fix this issue.

Thanks in advance.
Robin