Guest Posted March 29, 2004 Share Posted March 29, 2004 I posted this about a week ago, but no one could help me, so I am reposting it to see if anyone can please tell me where to look to fix this problem.... when an order is placed, and I click on the order tab in the admin panel, I get this.... 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 '' at line 1 select products_description as desc_info from products_description where products_id = [TEP STOP] how can I fix this????? please someone help, I am pleading!!!! :( store opens on the 1st and I am running out of time...... Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2004 Share Posted March 29, 2004 did you install any contribs that modify the orders.php? IF so, then that's where to look. You can always revert to the original orders.php. -jared Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2004 Share Posted March 29, 2004 yes, I have a couple of mods that required changes to that folder, I will try and install a fresh copy of that file from another oscommerce install and see if that works, will post the outcome.... thanks :) Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2004 Share Posted March 29, 2004 i replaced admin/orders.php and also admin/includes/languages/english/orders.php didnt work, still getting the error..... :huh: Link to comment Share on other sites More sharing options...
OceanRanch Posted March 29, 2004 Share Posted March 29, 2004 Not good news for you. It's a pretty good bet that one of the many files you changed with the two contributions you added are not working well with the admin includes etc. I say this after looking at your posts on changing database fields etc for adding the two contributions last week. The SQL statement that is erroring out contains "desc_info". I could not find that code in any of the standard MS2 code. You can try to locate (i.e. search all of your source) to find the code that is causing the problem. It may be a define statement etc. Worse case, if you did not backup your source, you may need to "un-install" the contributions by reversing the steps per the instructions. Tom Link to comment Share on other sites More sharing options...
Chris Dunning Posted March 29, 2004 Share Posted March 29, 2004 I would check the file includes/classes/order.php - I'd guess that's where your error is. Chris Dunning osCommerce, Contributions Moderator Team Please do not send me PM! I do not read or answer these often. Use the email button instead! I do NOT support contributions other than my own. Emails asking for support on other people's contributions will be ignored. Ask in the forum or contact the contribution author directly. Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2004 Share Posted March 29, 2004 I would check the file includes/classes/order.php - I'd guess that's where your error is. nope, thats not it either..... :unsure: Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2004 Share Posted March 29, 2004 I really dont think its a file problem, I think its database related.....but then again I am a n00b at sql so I dunno.... <_< Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2004 Share Posted March 29, 2004 well here is something I just noticed...... when i click on edit under orders in admin panel, it gives me that error, but also when I click on invoice and packing slip I get the same exact error.....this is weird! :blink: hhmm now what? Link to comment Share on other sites More sharing options...
Chris Dunning Posted March 29, 2004 Share Posted March 29, 2004 Then to test that, try this: Make a backup of your database through phpMyAdmin. Download it to your hard drive. Re-install the stock osCommerce database from the distribution package. Check your site, see if the error exists. Slowly make the changes to your database structure until you find what breaks things. Chris Dunning osCommerce, Contributions Moderator Team Please do not send me PM! I do not read or answer these often. Use the email button instead! I do NOT support contributions other than my own. Emails asking for support on other people's contributions will be ignored. Ask in the forum or contact the contribution author directly. Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2004 Share Posted March 29, 2004 eeehhh ok, I am new to using sql database, but I will give this a whirl.....thanks Link to comment Share on other sites More sharing options...
Guest Posted March 30, 2004 Share Posted March 30, 2004 ok I have decided to install a fresh copy of oscommerce and copy over all files and database tables into the new installation. I cannot figure out what is wrong with this error....... :angry: :angry: :angry: Link to comment Share on other sites More sharing options...
♥yesudo Posted March 30, 2004 Share Posted March 30, 2004 post your admin/orders.php file here - i'll have a quick look. Your online success is Paramount. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.