[euantor]

Originally Posted by shabbir4it

Hi,

There is an sql syntax error in your plugin in yabbseo/sitemap.func.php, You can notice the extra comma the query.
Line:288

PHP Code:

$albums = $db->query_read("
        SELECT album.userid,,album.title,album.albumid
        FROM " . TABLE_PREFIX . "album AS album
        WHERE album.albumid in ($albumids)
        "); 


Regards,
Syed

I was getting the same error too. I fixed that one, but now I'm getting this one:

PHP Code:

Invalid SQL:

        SELECT pl.attachmentid
        FROM picturelegacy AS pl
        INNER JOIN attachment AS a ON (pl.attachmentid = a.attachmentid)
        WHERE pl.pictureid = 2
            AND pl.type = 'album' AND pl.primaryid = 1;

MySQL Error   : Unknown column 'pl.attachmentid' in 'field list'
Error Number  : 1054
Request Date  : Saturday, December 12th 2009 @ 03:15:47 PM
Error Date    : Saturday, December 12th 2009 @ 03:15:47 PM
Classname     : YABBDB