IP ORDER 1.0 Syntax Error

[Guest]

Hi guys!

 

 

I need a little help with this one.. here goes...

 

First, I should mention this, While working on my new site that is currently IP based and no domain attached at present. So please don't go to the site listed in my info.. thanks..

 

 

I placed a few orders and used Check/Money order in order for the IP and ISP to be recorded.. Because for one, the IP and ISP recorder does not record when a customer chooses to use PayPal as payment method..

 

Second, after my test order was placed.. I went into admin section to view the order and see how all was.. When I went to update the order .. And what I mean is update from "Pending" to Processing". I got this error immediately..

 

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 ' ipaddy, ipisp orders where orders_id = '9'' at line 1

 

select customers_name, customers_email_address, orders_status, date_purchased from, ipaddy, ipisp orders where orders_id = '9'

 

[TEP STOP]

 

 

Can anyone please explain to me what this means exactly? And please tell me how to fix it please..

Otherwise, the contribution is awesome! And makes things more efficient.

 

Thanks in advance,

 

Christine

[Guest]

Anyone? I don't know if it's something with this contribution or the SQL version.. Never the less.. i've emailed the hosting provider to find out more.. Still waiting on him as well.. Meanwhile, trying to get to the bottom of it.. :)

 

Thanks again,

 

Christine

[Guest]

Anyone? Please? :)

[Guest]

Okay.. I've been busting my butt trying to figure out what is causing this.. I even looked up SQL syntax errors in hopes to come across a meaning for this problem at hand..

 

Anyways.. I think I found the file in question.. Because when I add or take something away from this line of code.. It changes the error.. Where my efforts to munipulate other files did absolutely nothing. So it appears that admin/orders.php is the file and this is the code:

 

$order_updated = false;
	$check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from, ipaddy, ipisp " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");
	$check_status = tep_db_fetch_array($check_status_query);

 

Now, also.. My hosting has SQL version MySQL 4.0.25-standard installed.. And according to the error that I am getting.. It's saying that syntax has to be changed regarding the SQL server version.. So now.. It's a matter of coding.. But I don't think, but don't quote me on this.. I don't think that this is contribution related anymore.. And could possibly be an issue with the latest OsCommerce Snapshot..

 

If anyone can PLEASE shed some light on this.. It would be greatly appreciated.. Thanks so much!

 

Christine

[servitall]

check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from, ipaddy, ipisp " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

 

change this rule into this

 

check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased, ipaddy, ipisp from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

 

and it will work just fine.

Edited December 29, 2006 by servitall