Guest Posted March 5, 2005 Share Posted March 5, 2005 Hi, i just installed this contribution and it's sort of works. When i made a test purchase and check-out successfully, at the bottom it said your IP been recorded for security purposes. When i log into admin/order i got an error: 1054 - Unknown column 'accountholder' in 'field list' 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, accountholder, bankname, routingnumber, accountnumber, checknumber, currency, currency_value, date_purchased, orders_status, last_modified, customers_id, payment_id, ipaddy, ipisp from orders where orders_id = '14' [TEP STOP] Thanks in advance. Hope someone can help. Regards, Kevin Quote Link to comment Share on other sites More sharing options...
bglkk Posted March 9, 2005 Share Posted March 9, 2005 Hi SteveThank you for your kind coorporation effort, but last night I found the error in my code. Due to the "reverse" explanation in the install instruction I left out this line: $ip = $HTTP_SERVER_VARS["REMOTE_ADDR"]; in the catalog/checkout_process.php and thereby also missed out the recording of the IP-address. I also had to make some other small addjustments to the code in order to get the right looks, but theese were mainly of the typograpfical kind. Would be nice if someone dit a work-over of the install instruction, but at least now the things work for me. Rgds. Bent Bj?rnskov <{POST_SNAPBACK}> Same thing happened to me, due to that confusing line of the instructions. All was fine after putting back $ip = $HTTP_SERVER_VARS["REMOTE_ADDR"]; Contribution -> good, instructions -> weak. Quote "Buy the ticket, take the ride..." -HST Link to comment Share on other sites More sharing options...
PVK Posted March 18, 2005 Share Posted March 18, 2005 All seems to work as supposed to untill i try to do a status update. Then i am presented with the following error: 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 'from orders where orders_id = '59808'' at line 1 select customers_name, customers_email_address, orders_status, date_purchased, ipaddy, from orders where orders_id = '59808' [TEP STOP] I also saw that in the contribution section someone had the same problem, but he did not put it here. Anyway, does anyone know what i have to do to remove the error as now i can not update any orders without this error. I am running a live shop so anay fast reply would be greatly appreciated Quote Link to comment Share on other sites More sharing options...
Guest Posted March 25, 2005 Share Posted March 25, 2005 Hi I have the install working okay except for one thing. The ISP just comes up with the domain extension i.e: "co.uk" with no other information. Is this correct? Quote Link to comment Share on other sites More sharing options...
Baby Boy Posted March 27, 2005 Share Posted March 27, 2005 How can I get the ISP to be viewable. I see the IP, just cannot find the stupid ISP. Grrrrr, help. Quote Installed Contributions: AJAX Menu, AJAX Attributed Manager, AP URL ReWriting, Credit Class and Gift Vouchers, CCGV Report, Date of Birth PullDown, FCKEditor for Product Desc., Monthly Installment Payments, More Pictures 6, MSRP Savings, Must Agree to Terms on Checkout, Order Editor, Payment Method Fee, PopUp Promo, Private Messages, Purchase Order, Purchase Order Application, Secure Admin Login-Logout, STS Plus, SugarCRM Integration, Supertracker, Tax Exempt and Organization Discounts, Your Recent History. 23 Total Contributions Installed :) Link to comment Share on other sites More sharing options...
Guest Posted April 25, 2005 Share Posted April 25, 2005 Anyone got a fix for this contribution if you have PayPal IPN installed? I have traced 'why' the IP and ISP don't get recorded in the database, I just haven't figured out how to fix it. The line of code in checkout_process that screws it up is : $payment_modules->before_process(); Everything after this line does not get executed as the PayPal IPN takes over. It calls the before_process() function in paypal.php, which in turn includes the file checkout_process.inc.php- this is where order information is stored. I tried putting code in both these files to get the IP and ISP, but nothing gets returned as the files are being called from a script and not from the web. Could someone with a little more knowledge of PHP figure out a way to pass the variables so they can be stored? (I tried making them global, but didn't work... although I could have done it wrong). Thanks. Paul. Quote Link to comment Share on other sites More sharing options...
Guest Posted April 25, 2005 Share Posted April 25, 2005 OK, for anyone even remotely cares, I have found a better solution... I think. All you need to do is add these lines of code to get the IP and ISP- $ip_query = tep_db_query("select ip_address from " . TABLE_WHOS_ONLINE . " where customer_id = " . $customer_id); $ip_check = tep_db_fetch_array($ip_query); $isp=gethostbyaddr($ip_check['ip_address']); This assumes that the customer is 'online' when making the order ;) Why I didn't think of this before, I don't know. ARE THERE ANY DRAWBACKS? I haven't looked into this much but assume that 'customer_id' is a primary key in the table? Does oscommerce allow a customer to be logged in at more than one computer? Hopefully someone can work with this and make a much easier contribution? Quote Link to comment Share on other sites More sharing options...
SambaMambo Posted June 6, 2005 Share Posted June 6, 2005 All seems to work as supposed to untill i try to do a status update. Then i am presented with the following error: 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 'from orders where orders_id = '59808'' at line 1 select customers_name, customers_email_address, orders_status, date_purchased, ipaddy, from orders where orders_id = '59808' [TEP STOP] <{POST_SNAPBACK}> Hi, i have the same problem 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 'where orders_id ='239'' at line 1 select customers_name, customers_email_address, orders_status, date_purchased, ipaddy, ipisp, fromorders where orders_id ='239' [TEP STOP] if someone could help us ... Quote Link to comment Share on other sites More sharing options...
SambaMambo Posted June 8, 2005 Share Posted June 8, 2005 All seems to work as supposed to untill i try to do a status update. Then i am presented with the following error: 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 'from orders where orders_id = '59808'' at line 1 select customers_name, customers_email_address, orders_status, date_purchased, ipaddy, from orders where orders_id = '59808' [TEP STOP] I also saw that in the contribution section someone had the same problem, but he did not put it here. Anyway, does anyone know what i have to do to remove the error as now i can not update any orders without this error. I am running a live shop so anay fast reply would be greatly appreciated <{POST_SNAPBACK}> ok i find out the prob $order_updated = false; $check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, ipaddy, ipisp, date_purchased from " . TABLE_ORDERS . " where orders_id ='" . (int)$oID . "'"); $check_status = tep_db_fetch_array($check_status_query); NOTE : NO ',' between 'date_purchased' and 'from' and u must put 'date_purchased' just before 'from' not as u mentionned : select customers_name, customers_email_address, orders_status, date_purchased, ipaddy, from orders where orders_id = '59808' Quote Link to comment Share on other sites More sharing options...
mr_absinthe Posted August 12, 2005 Share Posted August 12, 2005 Hi I installed this contribution and found a bug. If you use Paypal IPN or 3rd party CC processor, the IP address & ISP will not be recorded. Any ideas to solve this problem? <{POST_SNAPBACK}> Did anybody manage to figure out how to display IP and ISP in admin? It works fine if Money order is selected. With PayPal and 3rd party CC, it is displayed on checkout page but not on individual order in admin. Quote Absinthe Original Liquor Store Link to comment Share on other sites More sharing options...
Irin Posted February 24, 2006 Share Posted February 24, 2006 Hello, I?ve installed ?Order IP Recorder? contribution. First of all, thanks to Acheron for the great contribution. Now, my problem is that it doesn't support ?PayPal IPN Shopping Cart v3.1.5?. It shows fine when customer is paying by Check/Money Order, but not with ?PayPal IPN Shopping Cart v3.1.5?. Every time somebody orders through PayPal, IP Address and ISP are just blank in admin/orders. Has anybody figured out how to implement this contrib with PayPal IPN Shopping Cart? Any help would be greatly appreciated. Thanks in advance, Irina. Quote Link to comment Share on other sites More sharing options...
adauktion Posted April 6, 2006 Share Posted April 6, 2006 very nice contri still running BUT: i have a lot of: Ihr Provider: 113.164 Ihr Provider: 113.178 Ihr Provider: 112.120 Nice, but witch provider is that ? *g* Quote Link to comment Share on other sites More sharing options...
Amar_Guerfi Posted April 27, 2006 Share Posted April 27, 2006 Hi, I have exactly the same issue with Order IP Recorder not storing the IP & ISP in the database when using PayPal IPN. :blink: Any ideas? Sincerely, Amar Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted April 27, 2006 Share Posted April 27, 2006 the IP Order Recorder needs extra modifications to work with osc PayPal IPN module. For the osC IPN module do all the database functions by itself, you need to modify the osC IPN module to log the IP in database. Check this link http://www.oscommerce.com/forums/index.php?s=&...ndpost&p=732450 to make Ip Order Recorder works with osC IPN module 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...
Amar_Guerfi Posted April 27, 2006 Share Posted April 27, 2006 Hi Alex Li, Thanks so much ! It works like a charm. Sincerely, Amar Quote Link to comment Share on other sites More sharing options...
Irin Posted April 27, 2006 Share Posted April 27, 2006 Hello, I have a problem with "Order IP recorder" and "Authorize.net SIM" payment method. It always captures an Authorize.net's IP & ISP instead of real customer's. May be somebody came up with the fix for this inaccuracy? I'll appreciate any ideas. Thanks, Irin. Quote Link to comment Share on other sites More sharing options...
uncle mike Posted May 21, 2006 Share Posted May 21, 2006 (edited) This is just a mess, can somebody post a cleaned up version of this? :rolleyes: I know it works because I used it a few months ago on another cart that I don't have access to now. I don't remember how I got it working properly now that I need to add it to another cart. :blush: Edited May 21, 2006 by uncle mike Quote Link to comment Share on other sites More sharing options...
uncle mike Posted May 24, 2006 Share Posted May 24, 2006 This is just a mess, can somebody post a cleaned up version of this? :rolleyes: I know it works because I used it a few months ago on another cart that I don't have access to now. I don't remember how I got it working properly now that I need to add it to another cart. :blush: If I said please would that help? PLEASE :D Quote Link to comment Share on other sites More sharing options...
Guest Posted October 2, 2006 Share Posted October 2, 2006 (edited) have an error coming up when i try and access the individual orders from the admin panel. this is what i'm seeing: 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' have dropped the ipaddy and ipisp from the SQL database and reloaded them with no joy. PLEASE HELP! Edited October 2, 2006 by LOSHANNESSY Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 2, 2006 Share Posted October 2, 2006 have an error coming up when i try and access the individual orders from the admin panel.this is what i'm seeing: 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' have dropped the ipaddy and ipisp from the SQL database and reloaded them with no joy. PLEASE HELP! You missed a comma in your script. 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' 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 only thing is it doesn't give me any indication of where that code actually is. Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 2, 2006 Share Posted October 2, 2006 only thing is it doesn't give me any indication of where that code actually is. Look at the URL line in your browser, in the page you got this error message from, that's the file you need to fix. 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 yeah it thinks it's in my catelog/admin/order.php but i can't find any reference Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 2, 2006 Share Posted October 2, 2006 yeah it thinks it's in my catelog/admin/order.php but i can't find any reference just search for ipaddy and ipisp in your code. 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 this is the only relative instance: $check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased, ipaddy, ipisp". TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'"); Quote 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.