Results 1 to 3 of 3

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: ...

      
  1. #1
    Member
    Join Date
    Sep 2004
    Posts
    31
    Rep Power
    0


    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...

  2. #2
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,501
    Rep Power
    567
    Michael Sasek
    osCMax Developer


    osCmax installation service - Have our professionals install osCmax on your server - same day service!
    osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0

    Stay Up To Date with everything osCMax:
    Free osCMax Newsletters - Security notices, New Releases, osCMax News
    osCMax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    Member
    Join Date
    Sep 2004
    Posts
    31
    Rep Power
    0


    Default

    Thanks!!

Similar Threads

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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •