AlexStudio Posted October 2, 2006 Share Posted October 2, 2006 Change it to $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 . "'"); Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
Guest Posted October 2, 2006 Share Posted October 2, 2006 nope, still no working :( Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 2, 2006 Share Posted October 2, 2006 still got the same error message? Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
Guest Posted October 2, 2006 Share Posted October 2, 2006 yes indeed :'( Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 2, 2006 Share Posted October 2, 2006 I need to see it in order to help you, please post the error message again. Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
Guest Posted October 2, 2006 Share Posted October 2, 2006 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 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 orders where orders_id = '15' CONTENTS OF /ADMIN/ORDERS.PHP: if (tep_not_null($action)) { switch ($action) { case 'update_order': $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); $status = tep_db_prepare_input($HTTP_POST_VARS['status']); $comments = tep_db_prepare_input($HTTP_POST_VARS['comments']); $order_updated = false; $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 . "'"); $check_status = tep_db_fetch_array($check_status_query); if ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) { tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . (int)$oID . "'"); $customer_notified = '0'; if (isset($HTTP_POST_VARS['notify']) && ($HTTP_POST_VARS['notify'] == 'on')) { $notify_comments = ''; if (isset($HTTP_POST_VARS['notify_comments']) && ($HTTP_POST_VARS['notify_comments'] == 'on')) { $notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments) . "\n\n"; } $email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "\n\n" . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]); tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); $customer_notified = '1'; } tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . (int)$oID . "', '" . tep_db_input($status) . "', now(), '" . tep_db_input($customer_notified) . "', '" . tep_db_input($comments) . "')"); $order_updated = true; } if ($order_updated == true) { $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success'); } else { $messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning'); } tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=edit')); break; case 'deleteconfirm': $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); tep_remove_order($oID, $HTTP_POST_VARS['restock']); tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')))); break; } } Quote Link to comment Share on other sites More sharing options...
Guest Posted October 2, 2006 Share Posted October 2, 2006 that's not all of it, it's just where i think the error may be occuring Quote Link to comment Share on other sites More sharing options...
Guest Posted October 2, 2006 Share Posted October 2, 2006 also appears here: <tr> <td class="main"><b><?php echo ENTRY_IPADDRESS; ?></b></td> <td class="main"><?php echo $order->customer['ipaddy']; ?></td> </tr> <tr> <td class="main"><b><?php echo ENTRY_IPISP; ?></b></td> <td class="main"><?php echo $order->customer['ipisp']; ?></td> </tr> </table></td> Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 2, 2006 Share Posted October 2, 2006 I knew it, just want to make sure. you missed a space after 'from'. Why didn't you just copy and paste my code into your file? This is your code: if (tep_not_null($action)) { switch ($action) { case 'update_order': $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); $status = tep_db_prepare_input($HTTP_POST_VARS['status']); $comments = tep_db_prepare_input($HTTP_POST_VARS['comments']); $order_updated = false; $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 . "'"); $check_status = tep_db_fetch_array($check_status_query); replace with: if (tep_not_null($action)) { switch ($action) { case 'update_order': $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); $status = tep_db_prepare_input($HTTP_POST_VARS['status']); $comments = tep_db_prepare_input($HTTP_POST_VARS['comments']); $order_updated = false; $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 . "'"); $check_status = tep_db_fetch_array($check_status_query); Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
Guest Posted October 2, 2006 Share Posted October 2, 2006 i did, but i also tried without the space... still didn't work. Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 3, 2006 Share Posted October 3, 2006 Did you upload your file to host? Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
Guest Posted October 3, 2006 Share Posted October 3, 2006 lol... yes i did. Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 3, 2006 Share Posted October 3, 2006 No, you didn't upload the order.php to the right place. In the second error message you posted: ipaddy, ipisp orders where orders_id = '15'the missing 'from' is still not there. the SQL query should end with: ipaddy, ipisp from orders where orders_id = '15'; Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
Guest Posted October 3, 2006 Share Posted October 3, 2006 i just triple checked, it's there and it's in the correct place. Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 3, 2006 Share Posted October 3, 2006 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. Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
Guest Posted October 3, 2006 Share Posted October 3, 2006 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' Quote Link to comment Share on other sites More sharing options...
Guest Posted October 3, 2006 Share Posted October 3, 2006 seems the problem could actually be stemming from /admin/includes/classes/orders.php Quote Link to comment Share on other sites More sharing options...
Guest Posted October 3, 2006 Share Posted October 3, 2006 can anyone else help? have tried contacting the person who created this contribution, seems his email address is no longer. Quote Link to comment Share on other sites More sharing options...
Guest Posted October 3, 2006 Share Posted October 3, 2006 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']); Quote Link to comment Share on other sites More sharing options...
rockadrome Posted October 13, 2006 Share Posted October 13, 2006 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? Quote Link to comment Share on other sites More sharing options...
ollyno1uk2 Posted February 13, 2007 Share Posted February 13, 2007 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 Quote Link to comment Share on other sites More sharing options...
knifeman Posted October 28, 2007 Share Posted October 28, 2007 (edited) 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 October 28, 2007 by knifeman Quote Link to comment Share on other sites More sharing options...
none_uk Posted February 9, 2008 Share Posted February 9, 2008 (edited) 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 February 9, 2008 by none_uk Quote Link to comment Share on other sites More sharing options...
syscon Posted April 15, 2008 Share Posted April 15, 2008 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? Quote #Joseph Link to comment Share on other sites More sharing options...
syscon Posted April 17, 2008 Share Posted April 17, 2008 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). Quote #Joseph Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.