Cannot add a Moderator

[ozwebsites]

When we try to add a moderator, we get a database error.

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT userid
FROM ******adv_links_moderator
WHERE userid = 1
AND catid =;

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 4
Error Number : 1064
Request Date : Tuesday, June 3rd 2008 @ 02:59:24 PM
Error Date : Tuesday, June 3rd 2008 @ 02:59:24 PM
Script : http://www.******.com/forum/admincp/vba_links_admin.php?do=doaddmod
Referrer : http://www.******.com/forum/admincp/vba_links_admin.php?do=addmoderator&catid=1&s=
IP Address : 12x.18x.2x.2x
Username : admin


Any suggestions please, have masked the ip and site

[Brian]

Thank you for pointing this out. I've just applied the fix to the download package here, so if you will download the files again and replace your forum/admincp/vba_links_admin.php file with the updated version, that should take care of the issue.

[ozwebsites]

Thank you for pointing this out. I've just applied the fix to the download package here, so if you will download the files again and replace your forum/admincp/vba_links_admin.php file with the updated version, that should take care of the issue.

Many Thanks.

Just noticed you are from Georgia.

One of my fave places.

Esp: Lake Lanier, Buckhead, Stone Mountain and the best place in the world. Tybee Island

[Brian]

Never been a big fan of Buckhead. The last time I went there I got really lost and ended up getting a ticket for trying to turn somewhere I apparently wasn't supposed to. First ticket I had in about 10 years too. Haven't been back since. :p
Love Typee Island and Lake Lanier though. My dad used to tell me a story about how one of my great-great-great grandfathers used to own Stone Mountain and ended up trading it for something cheap because he figured he was getting a good deal since all he was trading was a giant rock. No clue if it's actually true though.

[ozwebsites]

lol GOLD !