PDA


View Full Version : Database error:


rawguru
02-13-2006, 12:15 AM
Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT links.linkid
FROM links AS links

WHERE suspended = 0 AND links.catid = '1' AND valid = 1
ORDER BY sticky DESC, desc
LIMIT 0,0;

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 'desc
LIMIT 0,0' at line 5
Error Number : 1064

Warning: Division by zero in /includes/functions.php on line 1821

--------------------

Also, when I go to modify settings in the admin section it says.

Warning: Invalid argument supplied for foreach() in /admincp/vba_links_admin.php on line 177

----

Please help. Thanks in advance.

Brian
02-13-2006, 02:58 PM
Looks like you set the number of links or posts to display per page to 0, which isn't valid.

rawguru
02-13-2006, 03:13 PM
How do I go about fixing this if when I got to modify settings in the admin section it says.

Warning: Invalid argument supplied for foreach() in /admincp/vba_links_admin.php on line 177

Thanks.

Brian
02-13-2006, 03:51 PM
Have you modified that file at all? There is no foreach() loop on line 177...

rawguru
02-13-2006, 04:24 PM
I dont know, I had it installed my someone. I am not really familiar with installing mods or add ons. Can you go into my admin cp and check it out. I can pay for your time...

Brian
02-13-2006, 04:40 PM
Sure. Just submit a support ticket via the Members' Area here and I'll take a look at things for you.