bobsi18 Posted March 18, 2006 Share Posted March 18, 2006 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???? Link to comment Share on other sites More sharing options...
Guest Posted March 27, 2006 Share Posted March 27, 2006 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? Link to comment Share on other sites More sharing options...
lee30 Posted March 29, 2006 Share Posted March 29, 2006 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 Link to comment Share on other sites More sharing options...
Guest Posted April 2, 2006 Share Posted April 2, 2006 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? :'( Link to comment Share on other sites More sharing options...
n2advnture Posted April 3, 2006 Share Posted April 3, 2006 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 Link to comment Share on other sites More sharing options...
Guest Posted April 5, 2006 Share Posted April 5, 2006 Thanks for the tip, fixed error with CCGV1.51a contribution :) Link to comment Share on other sites More sharing options...
Load-This Posted April 18, 2006 Share Posted April 18, 2006 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? Link to comment Share on other sites More sharing options...
Guest Posted April 29, 2006 Share Posted April 29, 2006 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: Link to comment Share on other sites More sharing options...
glamourfish Posted May 15, 2006 Share Posted May 15, 2006 :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! Link to comment Share on other sites More sharing options...
runweb Posted May 22, 2006 Share Posted May 22, 2006 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 Link to comment Share on other sites More sharing options...
janice171 Posted May 31, 2006 Share Posted May 31, 2006 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] Link to comment Share on other sites More sharing options...
amgelettronica Posted May 31, 2006 Share Posted May 31, 2006 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 Link to comment Share on other sites More sharing options...
Guest Posted May 31, 2006 Share Posted May 31, 2006 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 Link to comment Share on other sites More sharing options...
amgelettronica Posted June 2, 2006 Share Posted June 2, 2006 Ok, Thanks you. Resolved. Mimmo :thumbsup: Link to comment Share on other sites More sharing options...
cdllt Posted June 4, 2006 Share Posted June 4, 2006 Simplyeasier, you are hero! thank you so much for your help! this is save my life :) Link to comment Share on other sites More sharing options...
n2advnture Posted June 4, 2006 Share Posted June 4, 2006 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? :-" Link to comment Share on other sites More sharing options...
Guest Posted June 11, 2006 Share Posted June 11, 2006 Any answer for this one? :-" I've seen it with incorrect database transfering from an old osc version to a later one. Link to comment Share on other sites More sharing options...
marcoj Posted June 14, 2006 Share Posted June 14, 2006 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? Link to comment Share on other sites More sharing options...
Guest Posted June 14, 2006 Share Posted June 14, 2006 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? Link to comment Share on other sites More sharing options...
Guest Posted June 27, 2006 Share Posted June 27, 2006 :thumbsup: I honestly thought I wouldn't be able to fix the problem. But it was pretty easy to resolve. Thanks! Link to comment Share on other sites More sharing options...
runweb Posted June 27, 2006 Share Posted June 27, 2006 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 Link to comment Share on other sites More sharing options...
skeeweeaka Posted July 6, 2006 Share Posted July 6, 2006 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] Link to comment Share on other sites More sharing options...
robdc Posted August 2, 2006 Share Posted August 2, 2006 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. :) Link to comment Share on other sites More sharing options...
robdc Posted August 3, 2006 Share Posted August 3, 2006 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. :) Link to comment Share on other sites More sharing options...
tonspr Posted August 12, 2006 Share Posted August 12, 2006 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? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.