Jump to content

Archived

This topic is now archived and is closed to further replies.

Simplyeasier

1064 - You have an error in your SQL syntax

Recommended Posts

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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? :'(

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
:o 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:?


if at first you do succeed...try not to look surprised!

Share this post


Link to post
Share on other sites

Uh - lots of 1064 errors...

 

Here is my little Problem when I have products with a

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

 

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


OSC Webmakers Edition modiefied with many other contribs and enhancements.

+ STS 4.5.7 for 2.2MS2 and RC1

Share this post


Link to post
Share on other sites

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]

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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? :-"

Share this post


Link to post
Share on other sites
Any answer for this one? :-"

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites

In deed !

I found the fix, too and it`s realy easy to resolve the problem.

Now empty results don`t result in an SQL ERROR MESSAGE any more !

 

THANKS !!


OSC Webmakers Edition modiefied with many other contribs and enhancements.

+ STS 4.5.7 for 2.2MS2 and RC1

Share this post


Link to post
Share on other sites

Ok, after installing the Western Union and COD contribution, my problem is when selecting account and order history... When I revert back to the account history files the error disappears. Please help.... I think I am using sql3... I have been posting and trying to fix the error for two days.... THANKS!

 

I am receiving this error...

 

My Order History...

 

 

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 'select o.orders_id, o.orders_status, o.date_purchased, o.delive

 

select count(select o.orders_id, o.orders_status, o.date_purchased, o.delivery_name, ot.text as order_total, s.orders_status_name from orders o left join orders_total ot on (o.orders_id = ot.orders_id) left join orders_status s on (o.orders_status = s.orders_status_id and s.language_id = \'1\') where o.customers_id = \'2\' and ot.class = \'ot_total\' order by orders_id DESC) as total

 

[TEP STOP]

 

 

ORDER INFORMATION HISTORY...

 

HEADING_ORDER_STATUS

 

1054 - Unknown column 'osh.new_value' in 'where clause'

 

select os.orders_status_name, osh.date_added from orders_status os, orders_status_history osh where osh.orders_id = '221' and osh.new_value = os.orders_status_id and os.language_id = '1' order by osh.date_added desc

 

[TEP STOP]

 

 

 

 

 

Share this post


Link to post
Share on other sites
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.... :huh:

 

Does anyone has any idea on how to fix this? I have the same error. I first had the same problem as most people here had (the 1064 error). I tried the fix as suggested here (inserting some lines to check offset on 0). That fixed the 1064 error, but now I get negative result pages when I click on 'previous orders' on my website.

 

Anyone? Please. :)

Share this post


Link to post
Share on other sites
Does anyone has any idea on how to fix this? I have the same error. I first had the same problem as most people here had (the 1064 error). I tried the fix as suggested here (inserting some lines to check offset on 0). That fixed the 1064 error, but now I get negative result pages when I click on 'previous orders' on my website.

 

Anyone? Please. :)

 

Found out what the problem was. There was a table empty which wasn't supposed to be empty. All works fine now. :)

Share this post


Link to post
Share on other sites

When I try and go to my special items page all it shows me is:

 

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

 

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -9, 9

 

Can anyone help?

Share this post


Link to post
Share on other sites

×