Jump to content

Moonlighter

Members
  • Content count

    78
  • Joined

  • Last visited

About Moonlighter

  • Birthday 07/14/1980

Profile Information

  1. Moonlighter

    Unable to Decrypt Certificate ID

    Let me lay out the details of the story for you as succinctly as possible: 1) My SSL certificate expired in October. After much ado about nothing, I finally got it updated and working again. 2) My last successful PayPal order was in November. Went through without a hitch. 3) Time goes by.... nothing is modified with my site, PayPal, or the database. 4) Tonight I get an email from an upset customer wanting to know why PayPal is giving her an error. 5) I change the details of the PayPal IPN installation to the sandbox/testing configuration and give it a whirl. 6) PayPal says: "We were unable to decrypt the certificate ID." 7) 1 hour on the phone with PayPal = waste of time. 8) I discover register_globals had been turned off by my host, so I get them to turn it back on. 9) More time goes by. 10) STILL GETTING THE SAME ERROR! Between November and today I made lots of changes to products, etc., but I have not added any installations or changed any code. I can see why PayPal wouldn't allow me to continue using the expired certificate, but why should I get the same error with the updated certificate? It's baffling, really. Any ideas, anyone????
  2. Moonlighter

    Multi_Vendor_Shipping new thread

    I recently discovered that I had commented out the lines in column_right.php that displayed the bestsellers box... and uncommented them and discovered why: my bestsellers list is blank! I manually updated the products_ordered field in the products database just to get something listed in the infobox, but this can not be a regular activity for me. One would think this should be updated automatically. My question then is: which file should be updating the products_ordered field and where might I look to fix it? I have installed MVS some time ago and I wonder if this may have any effect on the issue at hand. Thoughts?
  3. Moonlighter

    Products_Ordered Not Updating

    I recently discovered that I had commented out the lines in column_right.php that displayed the bestsellers box... and uncommented them and discovered why: my bestsellers list is blank! I manually updated the products_ordered field in the products database just to get something listed in the infobox, but this can not be a regular activity for me. One would think this should be updated automatically. My question then is: which file should be updating the products_ordered field and where might I look to fix it? I have installed MVS some time ago and I wonder if this may have any effect on the issue at hand. Thoughts?
  4. Moonlighter

    [Contribution] phpBB-osCommerce Bridge

    Hey everyone! Finally got this thing working and thrilled to have it! Problem: I noticed in Google that pages in my phpBB directory are being indexed with session ID's! YIKES! Any ideas how I can stop this? I have my OsC pages set correctly where they do not get indexed with SID's, but it's just the phpBB pages now. Any ideas? Please help! Thanks in advance, Isaac
  5. Moonlighter

    Multi_Vendor_Shipping new thread

    CRISES AVERTED!!! The issue with not being able to log in correctly or create accounts was indeed an issue with my host. Something to do with the PHP settings that I do not have access to change. The second crisis averted with the duplicate shipping issue.... well, there was still MORE duplicated code in seo.class.php that I did not find the first time. I had commented out the code but I guess that just wasn't good enough for the phpGods. :-)
  6. Moonlighter

    Multi_Vendor_Shipping new thread

    On a related note, I did find some duplicated code in seo.class.php. I had intended to simply comment out the original code and add the replacement code after it in case it didn't work I would still have the original to revert back. Apparently that idea didn't work. I did the regular PHP block comment and for some reason I have a feeling it did not actually comment out the code. I deleted the "commented code" and then my host had some issue with register_globals being off..... so I got them to fix that. They got this corrected and I went to log in to the store under a test account to see if the deleting of the "duplicated" code corrected the problem. The store is telling me I have the incorrect username and/or password when I know for a fact this is correct. I then attempted to log in under the master password with several of the user accounts and it gave me the same problem. My next step was to try to create a new user account. After filling out the form and clicking "submit", it brought up the same page (create_account.php) with all fields blank. I checked the MySQL database through PHPMyAdmin and saw that all user passwords are still in the database, and no new data has been added for the user that I attempted to create. WTF?!?! Here's the kicker: I did not make any changes to create_account.php between the time that it was working and the time that it broke. Does anyone think this might be an issue with my host, or something else? I'm so completely totally lost it's not even funny anymore! :'(
  7. Moonlighter

    Multi_Vendor_Shipping new thread

    I have compared all of the above-mentioned files with the versions included in the MVS download. This tells me that it is stemming from an edit made to another file. I know that everything used to work once upon a time, and now that those files have been confirmed as unaltered, they are off the suspect list. Now the question remains..... where do I look to find some more suspects? :-)
  8. Moonlighter

    Multi_Vendor_Shipping new thread

    I checked out the database and it is creating two separate orders (with the same order ID!). One of them uses the table rate shipping, and the other is still showing USPS shipping and rates even though none of those modules are installed anywhere. I looked through checkout_process.php as well as all the contributions I've added. Of all of them, MVS was the only contribution that required editing checkout_process.php, and it was working correctly before... so I'm about 99% certain it's NOT this file. I also looked on the admin side at includes/classes/shopping_cart.php and order.php. Same situation with those; MVS was the only alterations to them and it worked properly at one time. Either I unintentionally edited one of these files, or it's a different file. Just to rule it out... if someone has a copy of these files with the MVS edits on a "vanilla" install, I'd much appreciate being able to check it out with WinMerge just to make sure I'm not missing anything here. Other than that.... has anyone got any other ideas? Not a critical error, of course, but definitely confusing to the customers (and to me)! I'd love to be able to restore some files to correct this, but I'm not sure at what point the checkout procedure got wonky on me... so not sure which file(s) to restore. Ugh!
  9. Moonlighter

    Multi_Vendor_Shipping new thread

    One important addendum to my last post: I recently changed from weight-based shipping to the table rate method. I have no other shipping methods installed. I have verified this in both the admin/modules/shipping section as well as with the individual vendors. On this particular vendor, however, USPS is showing a "sort order" of 0 even though the module has literally been uninstalled. One of the "quotes" on the invoice shows shipping with USPS and gives their rate, and then the second "quote" is showing the table rate method (as it should). It feels like OsC and/or MVS seems to think that I still have USPS shipping installed somewhere even though I have double-checked that I do not. Any suggestions....? (*crossed fingers*)
  10. Moonlighter

    Multi_Vendor_Shipping new thread

    I am not entirely certain but I believe this to be an MVS error. I have made a few mods to my store and have only noticed this error recently. After an order is made and when there are attributes attached to the item, the invoice actually lists the product twice like this: Vendor Products Shipper Method Ship Cost Model Tax Price (ex) Price (inc) Total (ex) Total (inc) AzureGreen Shipment Number 1 of 2 Vendor Order Sent: yes USPS Parcel Post 9.5600 - ship tax 0.0000 - - - - 1 x TEST PRODUCT - Size: 1 lb (+$2.00) - - - TEST100 6.25% $12.00 $12.00 $12.00 $12.00 AzureGreen Shipment Number 2 of 2 Vendor Order Sent: yes table Best Way 7.0000 - ship tax 0.0000 - - - - 1 x TEST PRODUCT - Size: 1 lb (+$2.00) - - - TEST100 6.25% $12.00 $12.00 $12.00 $12.00 Sub-Total: $12.00 IL TAX 6.25%: $0.75 Best Way: $7.00 Total: $19.75 I know it's hard to read without the table, but you get the general idea. The grand order total works correctly, it just lists the product as two separate shipments. Anyone have any idea why? If not, does anyone know which file I should look into to correct this? There are no errors that come up during the checkout process. Thanks in advance!!
  11. Moonlighter

    [Contribution] phpBB-osCommerce Bridge

    Okay so I got everything up and running and it's all working great (except for the admin screens, of course). Now, all of a sudden, no matter what username or email address I enter, my forums tell me I have entered an incorrect username or password. I can't get in to the forums at all. Any ideas where I could go to check my coding?
  12. Moonlighter

    [Contribution] phpBB-osCommerce Bridge

    OMG! :D After what feels like twelve lifetimes, I finally got this fixed! The mistake was in the create_account.php file. There is a code block for insertion that reads: // Added for phpBB Intergration // Find if username exists already, append a number if it does. // Username = first name + last initial + number. // This function is repeated in account_edit.php & login.php $new_username = strtolower($firstname) . strtolower(substr($lastname,0,1)); $unQuery = tep_db_query("SELECT count(*) AS count FROM ".TABLE_PHPBB_USERS." WHERE username LIKE '".$new_username."%'"); if($unQuery) { $unResult = tep_db_fetch_array($unQuery); if($unResult['count']>0) { // Username exists; find out how many there are an append the next # to it. $unCount = $unResult['count']; $unCount++; } } else { $unCount = ''; } $new_username = $new_username.$unCount; // This array set is repeated (with some differences) in login.php // We’re only entering the most basic information, relying on // the forum defaults for most things. $sql_data_array2 = array( 'user_id' => $customer_id, 'username' => $new_username, 'user_password' => md5($password), 'user_session_time' => time(), 'user_regdate' => time(), 'user_email' => $email_address, 'user_from' => tep_get_zone_name((int)($country),(int)($zone_id),0) ); tep_db_perform(TABLE_PHPBB_USERS, $sql_data_array2); // Insert our new user into the default group. // If you want your new signups to go to a different group, // change "VALUES ('1'" to the actual user group id. tep_db_query("insert into " . TABLE_PHPBB_USER_GROUPS . " (group_id, user_id, user_pending) VALUES ('1', $customer_id, 0)"); session_begin($customer_id, encode_ip(tep_get_ip_address()), PAGE_INDEX, FALSE, $autologin, 0); $userdata = tep_db_fetch_array($check_bbusers_query); $last_visit = ( $userdata['user_session_time'] > 0 ) ? $userdata['user_session_time'] : $current_time; tep_db_query("UPDATE " . TABLE_PHPBB_USERS . " SET user_session_time = '".$current_time."', user_session_page = '0', user_lastvisit = '".$last_visit."' WHERE user_id ='" . $check_customer['customers_id'] . "'"); $userdata['user_lastvisit'] = $last_visit; // End phpBB-osCommerce Bridge ....whereas it *SHOULD* read: // Added for phpBB Intergration // Find if username exists already, append a number if it does. // Username = first name + last initial + number. // This function is repeated in account_edit.php & login.php $check_bbusers_query = tep_db_query("select * from " . TABLE_PHPBB_USERS . " where user_id = '" . $check_customer['customers_id'] . "'"); $new_username = strtolower($firstname) . strtolower(substr($lastname,0,1)); $unQuery = tep_db_query("SELECT count(*) AS count FROM ".TABLE_PHPBB_USERS." WHERE username LIKE '".$new_username."%'"); if($unQuery) { $unResult = tep_db_fetch_array($unQuery); if($unResult['count']>0) { // Username exists; find out how many there are and append the next # to it. $unCount = $unResult['count']; $unCount++; } } else { $unCount = ''; } $new_username = $new_username.$unCount; // This array set is repeated (with some differences) in login.php // We’re only entering the most basic information, relying on // the forum defaults for most things. $sql_data_array2 = array('user_id' => $customer_id, 'username' => $new_username, 'user_password' => md5($password), 'user_session_time' => time(), 'user_regdate' => time(), 'user_email' => $email_address, 'user_from' => tep_get_zone_name((int)($country),(int)($zone_id),0) ); tep_db_perform(TABLE_PHPBB_USERS, $sql_data_array2); // Insert our new user into the default group. // If you want your new signups to go to a different group, // change "VALUES ('1'" to the actual user group id. tep_db_query("insert into " . TABLE_PHPBB_USER_GROUPS . " (group_id, user_id, user_pending) VALUES ('1', $customer_id, 0)"); session_begin($customer_id, encode_ip(tep_get_ip_address()), PAGE_INDEX, FALSE, $autologin, 0); $userdata = tep_db_fetch_array($check_bbusers_query); $last_visit = ( $userdata['user_session_time'] > 0 ) ? $userdata['user_session_time'] : $current_time; tep_db_query("UPDATE " . TABLE_PHPBB_USERS . " SET user_session_time = '".$current_time."', user_session_page = '0', user_lastvisit = '".$last_visit."' WHERE user_id ='" . $check_customer['customers_id'] . "'"); $userdata['user_lastvisit'] = $last_visit; // End phpBB-osCommerce Bridge ...the only difference being the $check_bbusers_query line. One little simple line broke my store for quite some time, and now it's up and running like a charm!
  13. Moonlighter

    [Contribution] phpBB-osCommerce Bridge

    Has anyone actually got this contribution to work properly?? I have done some research and as it happens, there is some kind of critical error with the MySQL syntax that is generating this error. I'm still working on a fix, but I literally have ZERO knowledge of MySQL so it's definitely slow-going and very much on-the-job training! Anyway I was just wondering if anyone has actually been successful with this contribution as I'm far from even being able to successfully create an account. I would really like to get this thing working correctly soon if at all possible, and it's feeling more and more hopeless. Can anyone give me SOME kind of encouragement (if not a fix *g*)? :)
  14. Moonlighter

    [Contribution] phpBB-osCommerce Bridge

    Was anyone able to come up with a solution to this problem? I'm now stuck with the exact same issue myself! Would greatly appreciate someone posting a fix if they have one. Thanks! :)
  15. Moonlighter

    [Contribution] phpBB-osCommerce Bridge

    Well, Folks. I have installed the bridge contribution and couldn't be more excited.... except for the plethora of errors popping off all over the place! Now when one of my customers clicks the "login" link on the store's main page, the following errors are presented: Warning: main(./webextension.inc) [function.main]: failed to open stream: No such file or directory in /home/moonl/public_html/login.php on line 17 Warning: main(./webextension.inc) [function.main]: failed to open stream: No such file or directory in /home/moonl/public_html/login.php on line 17 Warning: main() [function.include]: Failed opening './webextension.inc' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/moonl/public_html/login.php on line 17 Warning: main(./webcommon.) [function.main]: failed to open stream: No such file or directory in /home/moonl/public_html/login.php on line 18 Warning: main(./webcommon.) [function.main]: failed to open stream: No such file or directory in /home/moonl/public_html/login.php on line 18 Warning: main() [function.include]: Failed opening './webcommon.' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/moonl/public_html/login.php on line 18 Warning: Cannot modify header information - headers already sent by (output started at /home/moonl/public_html/login.php:17) in /home/moonl/public_html/includes/functions/general.php on line 1231 Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/moonl/public_html/login.php:17) in /home/moonl/public_html/includes/functions/sessions.php on line 97 I'm not sure what's going on here. I have nearly ripped out ALL my hair! My login.php file around line 19 reads like this: // Added for phpBB-osCommerce Bridge define("IN_LOGIN", true); define('IN_PHPBB', true); $phpbb_root_path = './web'; include($phpbb_root_path . 'extension.inc'); include($phpbb_root_path . 'common.'.$phpEx); // End phpBB-osCommerce Bridge If anyone has any input, I'd appreciate it! I'm getting desparate at this point! :'(
×