*lol* A version a day it seems hellsatan is going for ;)

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT * FROM vbaffiliates ORDER BY linkid LIMIT
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Sunday 29th of December 2002 05:22:53 PM
Script: http://www.enactive.net/forums/forum...hp?action=list
Referer: http://www.enactive.net/forums/


I get this error. Any help?

So you noticed too? heh

@kevo - Yup...There should be at least one more version;)

That file you've got looks wrong:(

Send it to me in a PM;)

Satan

works now :)

Goody good:)

Satan

I worked out what it was i already have in the data base useing the settings number 32 and 99 so i just edited them to 33 and 98 and it works fine now.

Hmmm...

I'm glad that it worked, but you don;t usually get an SQL Syntax error for a duplicate Setting:confused:

Ah well...As long as it worked for you:)

Satan

I'm getting an error now too:

Invalid SQL: SELECT linkid,name,link,b_link,height,width,hits,userid FROM vbaffiliates WHERE moderated='1' ORDER BY RAND() LIMIT
mysql error: You have an error in your SQL syntax near '' at line 1


I restored a backup Global.php :)

You should set the script so that it uses the next avalible ids and use $DB_site->insert_id() to get the id to use in the rest of the settings.