1. Home
  2. Community
  3. General Questions
  4. Error 1064 again

This website can use cookies to improve the user experience

This website can use cookies to improve the user experience and to provide certain services and functions to users. Cookies contain small amounts of information (such as login information and user preferences) and will be stored on your device.

Enable All Cookies Privacy Policy

Error 1064 again

General Questions 916 This topic was started by ,


avatar
cosmin 269
From: -
Error 1064 again

I'm embarassed to say I have no idea why this is happening. Maybe a template with a bug in it or something or uploading some messed up php file. I get this error

Error: 1064 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 1 on my frontpage. I'm using Esselbach 1.8.2.

Maybe you can help.

www.file-portal.net/index.php

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic

1 Re: Error 1064 again
avatar
OP 269
From: -
Error 1064 again

Thanks.
1 Re: Error 1064 again
avatar
Administrator
1342
From: Austria
Error 1064 again

Look like the "Max. News" setting (under Other/Websites) is empty, after there is no value after LIMIT.
1 Re: Error 1064 again
avatar
OP 269
From: -
Error 1064 again

Query: SELECT * FROM esselbach_st_stories WHERE story_main = '1' AND story_website = '1' AND story_sticky = '0' AND story_hook = '0' AND story_time < ('2007-03-25 06:34:52') OR story_main = '1' AND story_website = '0' AND story_sticky = '0' AND story_hook = '0' AND story_time < ('2007-03-25 06:34:52') ORDER BY story_time DESC LIMIT
1 Re: Error 1064 again
avatar
Administrator
1342
From: Austria
Error 1064 again

It would help if I know which query is causing this error

Open core.php and find:

echo "Error: <b>".mysql_errno()." <i>".mysql_error()."</i></b>";

and add the following line:

echo "<br /><br />Query: $var";

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.