tchmnkyz Posted August 17, 2006 Share Posted August 17, 2006 i have a problem when using the Ultimate SEO Mod. it is giving an order number of 0 to all orders not the correct order number. --jeremy Quote Link to comment Share on other sites More sharing options...
Guest Posted August 17, 2006 Share Posted August 17, 2006 check your orders table with phpmyadmin. Ensure the orders_id is has the autoincrement extra set. Quote Link to comment Share on other sites More sharing options...
tchmnkyz Posted August 17, 2006 Author Share Posted August 17, 2006 i have a problem when using the Ultimate SEO Mod. it is giving an order number of 0 to all orders not the correct order number.--jeremy it does infact have that. it is like it is not pulling that id or something. i dont know what. just not putting the id in the emails and for some reason it dont display in my admin side either... Quote Link to comment Share on other sites More sharing options...
Guest Posted August 17, 2006 Share Posted August 17, 2006 are you filtering the order_id with the seo module? Do you have a sample link as shows in the email? Quote Link to comment Share on other sites More sharing options...
safoo Posted August 17, 2006 Share Posted August 17, 2006 try this: set pconnect to false in both admin/includes/configure.php and catalog/includes/configure.php Quote Link to comment Share on other sites More sharing options...
tchmnkyz Posted August 17, 2006 Author Share Posted August 17, 2006 "Music Is Elementary ------------------------------------------------------ Order Number: 0 Detailed Invoice: https://musiciselementary.com/account_histo....php?order_id=0 Date Ordered: Thursday 17 August, 2006" --jeremy Quote Link to comment Share on other sites More sharing options...
safoo Posted August 17, 2006 Share Posted August 17, 2006 "Music Is Elementary------------------------------------------------------ Order Number: 0 Detailed Invoice: https://musiciselementary.com/account_histo....php?order_id=0 Date Ordered: Thursday 17 August, 2006" --jeremy is that after setting pconnect to false in both admin/includes/configure.php and catalog/includes/configure.php? Quote Link to comment Share on other sites More sharing options...
tchmnkyz Posted August 17, 2006 Author Share Posted August 17, 2006 It is already set to normal connections and not persistant. it works great aslong as i remove the SEO mod. Quote Link to comment Share on other sites More sharing options...
Guest Posted August 17, 2006 Share Posted August 17, 2006 goto your checkout_process.php where it sends the mail few lines above is where it sets up the url EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $insert_id, 'SSL', false) . "\n" . so change it to see if the tep_href_link causes it just to be sure EMAIL_TEXT_INVOICE_URL . ' ' . $insert_id . "\n" . place a test order is the order id still 0? Quote Link to comment Share on other sites More sharing options...
tchmnkyz Posted August 17, 2006 Author Share Posted August 17, 2006 yes it still does. it also dont display in my admin orders report. so why dont it display there either? Quote Link to comment Share on other sites More sharing options...
Guest Posted August 17, 2006 Share Posted August 17, 2006 (edited) in that checkout_process.php there is a line of code $insert_id = tep_db_insert_id(); comment it out then just below add: $tmp_query = tep_db_query("select MAX(orders_id) as last_id from " . TABLE_ORDERS . ""); $tmp_array = tep_db_fetch_array($tmp_query); $insert_id = $tmp_array['last_id']; Does the insert_id now non-zero? If so check if it is valid and represents the last order you made. If that works there is something with the database I would suspect persistent connections but you already tried that as you said. Edited August 17, 2006 by enigma1 Quote Link to comment Share on other sites More sharing options...
Tony Malone Posted September 12, 2006 Share Posted September 12, 2006 try this: set pconnect to false in both admin/includes/configure.php and catalog/includes/configure.php I had exactly the same problem described here and this did fix it.. Not for existing orders in the system, but for all new orders entered. Quote Link to comment Share on other sites More sharing options...
Tony Malone Posted September 12, 2006 Share Posted September 12, 2006 ...so thanks safoo! :D Quote Link to comment Share on other sites More sharing options...
New 
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.