osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

Newsletter!?, ERROR: 1064 - You have an error in your SQL...

This is a discussion on Newsletter!?, ERROR: 1064 - You have an error in your SQL... within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; In Admin I get this error message everytime I enter something I have not entered anything. When clicking on Newsletter: ...


Go Back   osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > osCommerce 2.2 Modification Help

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 12-13-2004, 03:30 PM
Member
 
Join Date: Sep 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
calle
Default Newsletter!?, ERROR: 1064 - You have an error in your SQL...

In Admin I get this error message everytime I enter something I have not entered anything. When clicking on Newsletter:


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 '-20, 20' at line 1

select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -20, 20

[TEP STOP]


For example if I have no delivered orders I get the errror message. Then after "delivering" one order everything works fine. The mysql doesn't seem to be able to handle the fact that there are no info, i.e. no delivered orders.

How do I change this? Now I can't send any newsletters...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
  #2  
Old 12-13-2004, 04:13 PM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 11,061
Thanks: 81
Thanked 348 Times in 327 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default

see this:

http://oscdox.com/modules.php?op=mod...ename=SQLError
__________________
Michael Sasek
osCMax Developer


  • osCMax Templates - Hundreds of premium quality templates designed for osCMax 2. Loyalty discounts up to 30% off!
    Each purchase supports the osCMax project with much needed funds!

  • xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.

  • osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host. Default multi server configuration for exceptional performance!

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 12-14-2004, 03:40 AM
Member
 
Join Date: Sep 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
calle
Default

Thanks!!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
Closed Thread

Thread Tools

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 On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
osCMax-2.0RC2-update051112 1064 Error. gamerigs osCMax v2 Customization/Mods 3 12-05-2005 07:44 AM
1064 - You have an error in your SQL syntax. jamie74 osCommerce 2.2 Modification Help 0 10-20-2004 12:45 PM
1064 error when creating new account CTapia osCommerce 2.2 Installation Help 2 10-01-2004 03:20 AM
1064 - You have an error in your SQL syntax. j0ly osCommerce 2.2 Installation Help 1 08-24-2004 04:13 PM
1064 - You have an error in your SQL syntax Anonymous osCMax v1.7 Installation 3 05-10-2004 11:48 AM


All times are GMT -8. The time now is 10:41 AM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax