79 replies to this topic

[AlexStudio]

Did you upload your file to host?

[LOSHANNESSY]

lol... yes i did.

[AlexStudio]

No, you didn't upload the order.php to the right place.

In the second error message you posted:

Quote

ipaddy, ipisp orders where orders_id = '15'

the missing 'from' is still not there.

the SQL query should end with:

Quote

ipaddy, ipisp from orders where orders_id = '15';

[LOSHANNESSY]

i just triple checked, it's there and it's in the correct place.

[AlexStudio]

ok, you should also look into the file catalog/admin/includes/classes/order.php and make the necessary change as you did to the other order.php file.

[LOSHANNESSY]

new error message:
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 from orders where orders_id = '15'' at line 1

select customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from, ipaddy, ipisp from orders where orders_id = '15'

[LOSHANNESSY]

seems the problem could actually be stemming from /admin/includes/classes/orders.php

[LOSHANNESSY]

can anyone else help? have tried contacting the person who created this contribution, seems his email address is no longer.

[fl70]

In /admin/includes/classes/order.php
This section should be:

function query($order_id) {
$order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, ipaddy, ipisp last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");
$order = tep_db_fetch_array($order_query);

A few lines below that it should be:

	  $this->customer = array('name' => $order['customers_name'],
							  'company' => $order['customers_company'],
							  'street_address' => $order['customers_street_address'],
							  'suburb' => $order['customers_suburb'],
							  'city' => $order['customers_city'],
							  'postcode' => $order['customers_postcode'],
							  'state' => $order['customers_state'],
							  'country' => $order['customers_country'],
							  'format_id' => $order['customers_address_format_id'],
							  'telephone' => $order['customers_telephone'],
							  'email_address' => $order['customers_email_address'],
							  'ipaddy' => $order['ipaddy'],
							  'ipisp' => $order['ipisp']);

[rockadrome]

I just recently moved my site from a shared server to a dedicated server with a new host. Now the IP Recorder is broken and instead of showing me the customer IP/ISP it shows the IP for my new host and their name under ISP. I believe the IP recorder for my contact me is also broken this same way. However, who's online still works just fine.

Any ideas on how/where to look to correct this problem?

[ollyno1uk2]

Hi there

I have just installed teh contrib and it seems to be working although it does list my ISP as .co.uk rather than the full ISP but maybe that is just an issue with my ISP.

My problem is within the admin if I now try to edit an order or adda comment I get the following error

Warning: Cannot modify header information - headers already sent by (output started at /home/ollyno1/public_html/jbosolutions/admin/includes/languages/english/orders.php:90) in /home/ollyno1/public_html/jbosolutions/admin/includes/functions/general.php on line 22

Although it does seem to add comments to the order

Has anyone else had this?

Thanks in advance

[knifeman]

Baby Boy, on Mar 27 2005, 02:59 AM, said:

How can I get the ISP to be viewable. I see the IP, just cannot find the stupid ISP. Grrrrr, help.

Same here.

I have gone over the code several times. Even tried comparing to the older versions that did not work.

I installed V1.5 and I see the Ip in the edit order page, but no ISP. The ISp is recorded in the database, but will not show up next to the ISP heading on the page where you edit an order.

Tim


ps. I guess I should give up like the description says at the end.

Edited by knifeman, 28 October 2007 - 11:31 PM.

[none_uk]

got this installed, but not showing in admin section. using 1.5....

 function query($order_id) {
	  $order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, ipaddy, ipisp, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");
	  $order = tep_db_fetch_array($order_query);

i added the comma after ipisp but no joy

using RC1

Edited by none_uk, 09 February 2008 - 10:31 PM.

[syscon]

After installing "Order-IP-recorder v.1.5 on OSC v2.2 RC2 I get his error message when I try to check it out:

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /var/www/localhost/htdocs/sysconcept_ca/catalog/checkout_confirmation.php:1) in /var/www/localhost/htdocs/sysconcept_ca/catalog/includes/functions/sessions.php on line 102

Does anybody know how to fix it or alternative contribution?

[syscon]

syscon, on Apr 15 2008, 05:35 AM, said:

After installing "Order-IP-recorder v.1.5 on OSC v2.2 RC2 I get his error message when I try to check it out:

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /var/www/localhost/htdocs/sysconcept_ca/catalog/checkout_confirmation.php:1) in /var/www/localhost/htdocs/sysconcept_ca/catalog/includes/functions/sessions.php on line 102

Does anybody know how to fix it or alternative contribution?

problem solved! Error on my part (made a typo).

[modix]

Has anyone got it working on rc1 or rc2? Would be very interested in a solution that works for them.

[scorp]

Has anyone got it working on rc2?

My customer side works fine but theirs no Database save for either ip or isp.

[xmitman]

Like many people on this thread, I was unable to view the IP and ISP address in my orders and they weren't being written to my database.  Well I have corrected the code and now it works (at least for me) .  I'm finally able to contribute to this forum instead of asking for help. Go here  http://www.oscommerce.com/community/contributions,8156/  .  This is a full release that works with Oscommerce v2.3.1

[Robertnash777]

Sorry for Bouncing... but I have a problem with installing the IP recorder, I'm using V2.2 RC2, I have installed it, it did show on the checkout page, but everything got more narrow there, and on the back office when trying to open order, I got a blank page....

Any thoughts?

Thanks.

[DunWeb]

@Robertnash777

Refer to your original post for the reply.



Chris