Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

PHP Forum


You are currently viewing our PHP Forum as a guest. Please register to participate.
Login



Freelance Jobs

Reply
Help (1064 - You have an error in your SQL syntax)
Old 12-26-2010, 04:09 PM Help (1064 - You have an error in your SQL syntax)
Junior Talker

Posts: 4
Name: David
Trades: 0
On my Shopping Cart homepage the page is not displaying correctly. I have this error message under my flash banner. Could someone please be of assistance?

Thanks,

Issue* 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 'MAX_DISPLAY_PRODUCTS_FIRST_PAGE' at line 1

Code:
select p.products_id, p.products_image,  p.products_tax_class_id, pd.products_name, if(s.status,  s.specials_new_products_price, p.products_price) as products_price from  products p left join specials s on p.products_id = s.products_id,  products_description pd where p.products_status = '1' and p.products_id =  pd.products_id and pd.language_id = '1' order by p.products_date_added  desc limit MAX_DISPLAY_PRODUCTS_FIRST_PAGE
[TEP STOP]

Last edited by chrishirst; 12-26-2010 at 06:41 PM..
fl-webmaster is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 12-26-2010, 05:07 PM Re: Help (1064 - You have an error in your SQL syntax)
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,385
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
limit has to be a number
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 12-26-2010, 06:21 PM Re: Help (1064 - You have an error in your SQL syntax)
Junior Talker

Posts: 4
Name: David
Trades: 0
I'm sorry I do not understand what you mean by limit needs to be a number? Can you further assist me?

Also where would I update this info?

Last edited by fl-webmaster; 12-26-2010 at 06:25 PM..
fl-webmaster is offline
Reply With Quote
View Public Profile
 
Old 12-26-2010, 06:40 PM Re: Help (1064 - You have an error in your SQL syntax)
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,385
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Look at the query

limit expects a NUMERICAL VALUE

what is your value for limit?
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 12-26-2010, 06:51 PM Re: Help (1064 - You have an error in your SQL syntax)
Junior Talker

Posts: 4
Name: David
Trades: 0
I am currently testing... Thanks for the tip.
fl-webmaster is offline
Reply With Quote
View Public Profile
 
Old 12-26-2010, 07:50 PM Re: Help (1064 - You have an error in your SQL syntax)
Junior Talker

Posts: 4
Name: David
Trades: 0
i resolved my issue. I did not install the template correctly so I reinstalled it.
fl-webmaster is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Help (1064 - You have an error in your SQL syntax)
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.16986 seconds with 12 queries