Database Problem - every time somebody tries to make a new album...

[euantor]

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT album.userid,,album.title,album.albumid
FROM album AS album
WHERE album.albumid in (20);

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 'album.title,album.albumid
FROM album AS album
WHERE album.albumid i' at line 1
Error Number : 1064
Request Date : Wednesday, November 18th 2009 @ 07:44:34 PM
Error Date : Wednesday, November 18th 2009 @ 07:44:34 PM
Script : http://www.360elites.net/album.php?albumid=20
Referrer : http://www.360elites.net/album.php?do=addalbum
IP Address : My IP (got rid of it for obvious reasons)
Username :
Classname : YABBDB
MySQL Version :


I thought at first it was because of YABBSEO so I disabled it. No luck. Same problem still happening. Any ideas as to why anybody? Also, are there any possible fixes?

[Lynne]

You can see it is missing something inbetween userid and album.title (two commas in a row). Try disabling ALL your plugins and trying again.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

[euantor]

Ok, cheers Lynne. I'll have a go with that.

EDIT: I don't appear to have my config.php file in my root. Should I re-upload it do you reckon?

[Lynne]

It's not supposed to be in your root - it is in your /includes directory.

[euantor]

Oh. Oops. My bad haha. Thanks once again Lynne xD

[euantor]

Ok, I disabled all plugins and it works perfectly. Now to find which is causing it...

Ok, so YABBSEO seems to be the problem... Pity - it's the best free SEO I can find D:

[zhenyu86]

I thought at first it was because of YABBSEO so I disabled it. No luck. Same problem still happening. Any ideas as to why anybody? Also, are there any possible fixes?

go to yabbseo/sitemap.func.php

find album.userid,,
then delete 1 of the ,
then it will work fine