chrometweaks.org

Whats iPage.com? im confused I have no idea what the website it is?

Click Here To View All Answers...


Got a question... Whats iPage.com? I'm confused I have no idea what the website it is? Many thanks for any response. Second question of mine... 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........

Comments (118)

I would like to know the answer too. Anyone here know what is the right answer. I'll do some research and get back to you if I discover an answer. You should email the people at iPage as they probably could help you..

Comment #1

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

Comment #2

I replaced admin/orders.php and also admin/includes/languages/english/orders.php.

Didnt work, still getting the error.......

Comment #3

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.

This post has been edited by.

OceanRanch.

: 29 March 2004, 20:28..

Comment #4

I would check the file includes/classes/order.php - I'd guess that's where your error is...

Comment #5

I really dont think it's a file problem, I think it's database related.....but then again I am a n00b at sql so I dunno......

Comment #6

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

Hhmm now what?..

Comment #7

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

This post has been edited by.

BlueNoteMKVI.

: 29 March 2004, 21:07..

Comment #8

Eeehhh ok, I am new to using sql database, but I will give this a whirl.....thanks..

Comment #9

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

Comment #10

Post your admin/orders.php file here - i'll have a quick look...

Comment #11

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

Comment #12

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

Comment #13


This question was taken from a support group/message board and re-posted here so others can learn from it.