355 replies to this topic

[bobsi18]

bobsi18, on Mar 16 2006, 10:37 PM, said:

Hi guys, I've been reading through the post and have a smiliar problem...  On my catalogue side of things (on the index.php page), I am getting the following error (instead of a list of products):

1064 - You have an error in your SQL syntax near '-_oscommerce' at line 1

show table status from domainname_com_au_-_oscommerce

[TEP STOP]

Please please please does anyone know what's happening?

Thanks, Barbara

please - does anyone know where i can look for help????

[enigma1]

there is no table status with the default osc dbase so you have to figure out what script/contributions are using this table. Probably something you installed?

[lee30]

Thanks Charles,

I have finally fixed this error after the host upgraded my site to a new mysql version.

No more headaches now, your help is much appreciated.

Lee

[LadyShelly]

Yep.

I'm offical confused and at wits end with this one.

Okay, so I've been fighting with getting PayPal orders to work. Thought I got it fixed. Logged in with my "test customer's name" after sucessfully sending money and purchasing items. Got the Order Sucess, got the emails, ect. So I log into 'My Account', click on Order History and bam!

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

select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '20' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' order by orders_id DESC limit -10, 10

So, I look this error, find this thread. Try the fix.

Now I'm getting negative page numbers, no error, and 0 of 0 orders in admin. When I first log into admin, it actually says 2 pending orders, but when I try to view them.... nothing 0 of 0.

What did I do and how do I fix it?

Edited by LadyShelly, 02 April 2006 - 09:07 PM.

[n2advnture]

LadyShelly, on Apr 2 2006, 04:06 PM, said:

So, I look this error, find this thread. Try the fix.

Now I'm getting negative page numbers, no error, and 0 of 0 orders in admin. When I first log into admin, it actually says 2 pending orders, but when I try to view them.... nothing 0 of 0.

What did I do and how do I fix it?

That's exactly what I get on the admin side.

If a custome logs in and view his/her "order history" nothing shows up as well.

~M

[john_spiral]

Thanks for the tip, fixed error with CCGV1.51a contribution

[Load-This]

Hey All,

I have added the fix into the /admin/split_page_results.php

It fixes up the tep errors ... but when someone has an order thats "Pending" .. or any of the other status's that used to display the tep error, it now doesnt display anything.

I have 2 "Pending" orders, but they are not displaying in the "Pending" table?

Any help?

[LadyShelly]

Just an update.... I still haven't got the negative pages fixed.

I have nearly reinstalled my entire oscommerce site, with the exception of the style page and index page... it's still there and I really don't know why since I copied the originals back over the changes to the split pages...

It just boggles the mind....  

[glamourfish]

Simplyeasier, on Apr 1 2005, 10:10 AM, said:

  NOTE - I have NOT asked you to change catalog/includes/classes/split_page_results.php  - If you have a problem on the catalog side you may want to try the same change in that file - I did and it went wrong so the change to my catalog/includes/classes/split_page_results.php  file is a little more elaborate and I will share that here if it becomes an issue - but for now it seems people will mostly have a problem with empty files on the admin side.

hth

Charles

I am getting this 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 '-20, 20' at line 1

nothing following when I am trying to update my data base importing it directly into my mySQL db via my control panel. Never had this before...any ideas:?

[runweb]

Uh - lots of 1064  errors...

Here is my little Problem when I have products with a

Quote

"

in the description text an someone is ont the products page of this product:

Quote

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 'D&W", Sondermodell")' at line 1

insert into user_tracking (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, page_desc) values ('', 'Guest', 'fa43eae0b6caf7a74c44353025863b8f', '84.170.74.243', '1148299179', '1148299179', '/webshop/catalog/product_info.php?products_id=1079',"Ford Escort MK II Zakspeed "D&W", Sondermodell")

Anyone an idea, what I could change do avoid this error message at the bottom of my shop.. ?

[janice171]

Hi,
I have a similar problem, but can't find a resolve in these forums..
can anyone help out?

here's what i get in admin/specials

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

select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -6, 6

[TEP STOP]

[amgelettronica]

Hello, I would be interested to use its contribution but it turns out not working because side admin exits this 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 '-20, 20' at line 1

select * from discount_coupons cd order by cd.date_end, date_start limit -20, 20

[TEP STOP]


I have controlled the code, but I do not succeed to find errors.

I use mysql 4.1.12, creed I am a fix of mysql. .I do not succeed to understand where. Someone can help me?

On my package I have istalled the TotalB2B, works equally? Thanks You

Mimmo

[enigma1]

amgelettronica, on May 31 2006, 09:10 AM, said:

Hello, I would be interested to use its contribution but it turns out not working because side admin exits this 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 '-20, 20' at line 1

select * from discount_coupons cd order by cd.date_end, date_start limit -20, 20

[TEP STOP]
I have controlled the code, but I do not succeed to find errors.

I use mysql 4.1.12, creed I am a fix of mysql. .I do not succeed to understand where. Someone can help me?

On my package I have istalled the TotalB2B, works equally? Thanks You

Mimmo

Have you installed the fix mentioned here? There is also a bug report.
http://www.oscommerce.com/community/bugs,1605

And it's best to get the latest osc update that includes many other fixes.
http://www.oscommerce.com/solutions/downloads

[amgelettronica]

Ok, Thanks you. Resolved.

Mimmo  

[cdllt]

Simplyeasier,
you are hero!
thank you so much for your help!
this is save my life

[n2advnture]

LadyShelly, on Apr 2 2006, 05:06 PM, said:

So, I look this error, find this thread. Try the fix.

Now I'm getting negative page numbers, no error, and 0 of 0 orders in admin. When I first log into admin, it actually says 2 pending orders, but when I try to view them.... nothing 0 of 0.

What did I do and how do I fix it?

Any answer for this one?  

[enigma1]

n2advnture, on Jun 4 2006, 10:18 AM, said:

Any answer for this one?  

I've seen it with incorrect database transfering from an old osc version to a later one.

[marcoj]

hi there

i've been having the same problem but in the Newsletter Manager

"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]"

i've tried the

"if ($offset < 0)
{
$offset = 0;
}

but it doesn't work.. can anyone help?

[enigma1]

marcoj, on Jun 14 2006, 07:01 AM, said:

hi there

i've been having the same problem but in the Newsletter Manager

"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]"

i've tried the

"if ($offset < 0)
{
$offset = 0;
}

its the same fix.
1. Make sure you install it properly
2. Make sure you modify both files on catalog and admin ends.
but it doesn't work.. can anyone help?

Edited by enigma1, 14 June 2006 - 04:41 PM.

[computerzenabled]

I honestly thought I wouldn't be able to fix the problem.  But it was pretty easy to resolve.

Thanks!