Jump to content

Demitry

Members
  • Content count

    352
  • Joined

  • Last visited

  • Days Won

    8

Everything posted by Demitry

  1. Demitry

    Database Optimizer

    I checked again, and I did download the latest version (V 1.6) that was from Jan 15th this year. Does keeping the ON/OFF setting to ON in configuration, automatically make it a cron job? In other words, if I only wanted to run it manually, would I have to keep that setting turned off and only turn it on when I wanted to run the optimization?
  2. Demitry

    Database Optimizer

    Actually, that center yellow button link issue is likely due to the TEXT_VERSION_CHECK_UPDATES_UNRELEASED variable being undefined. If you cannot replicate this issue, then it is probably that long variable name that is pushing the buttons to a smaller width and thereby, the link of the center button onto the next line.
  3. Demitry

    Database Optimizer

    Hi Jack, Phil, Thank you for pointing out the configuration settings. I did not even realize they were there! I was focused on the /admin/Tools/Database Optimizer. I figured that the undefined variable was for Version Checker, which I don't have installed,.. but thought I'd mention it anyway for those folks that don't have Version Checker either. As far as the form issue, I do believe it is a W3C validation issue and like I mentioned, that the forms likely function properly. I looked at the code in FF and it points out all the html errors in red, which helps me locate and fix them. I placed the form tags around the table on both forms and the error went away. On the second one the opening form tag is inside a closed <td></td> tag (line 187) and the closing one is outside of a closing </tr> tag, which does not follow the form rules you listed above. Please don't take it the wrong way,.. my understanding is that you're more of a back-end developer and your php & other code is fantastic! I just try to keep the code as clean as I can, which is probably a waste of time and a bit overkill. As for adding the file name definition to /admin/includes/filenames.php, ..that was something I did to stay consistent with the osC file structure. My current version is MS2.2 (though I'm about to make the latest BS Edge leap) and my site does have a defined file structure. I did have a look at osC 2.3.4 and it does have the /admin/includes/filenames.php file, so maybe I'm misunderstanding your reply on this because the filename definitions do exist in the newer version as well as in mine. Regardless, it was a minor tweak that does not affect anything in terms of the add-on's functionality... other than stroke my OCD, lol I included a screenshot of the buttons without the inline css for nowrap that I added and you can see the issue with the center button link. I don't think I downloaded an old version of the add-on. I always try to get the complete & latest contribution that fits my needs. However, I will go back and look to see if this was the most recent one. Any suggestions on the javascript error for the buttons from the screenshot above? It's not a big deal if I cannot get them working. I included that language definitions file and echoed the descriptions variable below the output message. So, I have all the descriptions on the same page. I ran the optimization last night and it was amazing!!! reduced my database by 86.74% Thank you!!! Works Awesome!
  4. Demitry

    Database Optimizer

    I'm also getting javascript errors (see screenshot below) from the yellow buttons and there is nothing that displays when I click on them. The first error in the screenshot is on page load and the second, when I click on any of the three javascript buttons. I'm not good with javascript, so any help would be greatly appreciated. Thanks.
  5. Demitry

    Database Optimizer

    Hi Jack, Thank you for this great add-on,.. I just installed it and have not run it yet, but I found several minor html issues with a couple of the files and listed them below. These issues seem to be the same for both Before_2.3 and After_2.3 folders in related files. I also have some concerns regarding how will clearing the database of older customer tracking information affect reporting? If you plan on doing another release of this add-on, it would be good to have some admin-controlled additional selection of how far back to go to remove such records (..and specifically for customer data), or even a checklist of options based on certain customer criteria that an admin could select to further filter the purge. My understanding is that this add-on (with the particular checkbox selection) will remove ALL customer records from the database that have not purchased or logged-in in the last 300 days. So, if a customer made a purchase prior to that 300 day mark and has not bought anything since, I would not want them deleted. However, this is the current configuration of this add-on, is that correct? Or, I may want to remove all customer record’s whose email is bouncing after a certain amount of time, regardless of the time passed since their last purchase or login. /Before_2.3/New_Files_Only/admin/database_optimizer.php On line 160, TEXT_VERSION_CHECK_UPDATES_UNRELEASED is not defined anywhere. Line 173 is missing the closing </div></td> tags Line 189 and line 205, there are duplicate border=”0” attributes within the same <table> opening tag Line 197, there is an extra semicolon “;” at the end of the input tag for each of the checkboxes Line 205, the nested table is not necessary, I removed it and added colspan=”3” and 25px padding to that <td> for the Update button Line 155, the tep_draw_form() should open and close around the <table> tag: open before the table tag on line 158 and closed on line 161. There is an html error with it being placed between the two </tr> tags,.. though I’m sure the form functions properly. Similar issue on the second tep_draw_form() instance. /Before_2.3/New_Files_Only/admin/includes/languages/english/database_optimizer.php Line 21, where it say “Need An Addon?” ..needs to be either “Need&nbsp;An&nbsp;Addon?” or have an in-line css for white-space:nowrap; in the link because right now, it forces “Addon?” to the next line below the yellow button. Aside from making those changes, I also defined the database_optimizer.php file in /admin/includes/filenames.php to stay consistent with the osC structure: // Database Optimizer define('FILENAME_DATABASE_OPTIMIZER', 'database_optimizer.php'); And then changed that variable name in /admin/includes/boxes/tools.php and for the two tep_draw_form() instances in /admin/database_optimizer.php And,.. I added a label to the “Select ALL” checkbox on /Before_2.3/New_Files_Only/admin/database_optimizer.php (line 192): <td colspan="2" class="smallText">Select ALL</td> </tr>
  6. Hi, I could not find any forum on here that deals specifically with MySQL security. And, since I do have this add-on installed, I figured I would ask here. My site is an older version MS2.2 I recently noticed the STORE_ZONE field in MySQL was altered. The hack came from outside the site’s admin panel. I have several security layers to secure access to that admin area. The added entry was not a selection from the drop-down menu used to edit that field, which is based on my country’s code. I’m now looking for a solution to patch that hole. So,.. I thought about revoking the rights to insert, update, delete that configuration table from the public. However, I am not sure if that will be enough or the right way to go, or if there is a better alternative. I’d love to know how the hack was executed and if I missed securing a form or some other entry point. However, at this time I think blocking all write access to that configuration table would likely work. Any help on this would be greatly appreciated.
  7. Demitry

    New UPS XML Shipping Module available

    Cool, thanks Jim, I tried to use the other debugging method too, by adding the value of "1" to use_exec on line 70 of upsxml.php, but when I ran the test checkout, I got no shipping rates or anything at all displaying below the shipping section heading. I don't know if perhaps I missed doing something, but figured I would stick with resolving the cURL error issues first. Demitry
  8. Demitry

    New UPS XML Shipping Module available

    Thank John, I completely agree that this cURL option should not be set as default considering that the TLS version setting will vary from one hosting company to another. However, I think it should probably be added and commented out same as the cURL [60] error, in case someone finds this in their upsxml.log Along with the details of what number to use for each of the specific TLS versions. My initial issue was that UPS deleted my account for inactivity. After reviewing the upsxml.log I found that it was using my UPS login info to communicate with the UPS gateway. So, I thought this was the problem. However, after creating a new UPS account, I was still getting that error. So, I went back into that upsxml.log and found the cURL [35] error, ..and well, you know the rest. The weird thing too is that every once in a while, the UPS rates would display. So, this "Rating and Service" error was not consistent. Demitry
  9. Demitry

    Multi_Vendor_Shipping new thread

    Hi, If you’re getting the following error at checkout for UPS, ... Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway : Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway Then you should read this post: http://forums.oscommerce.com/topic/49382-new-ups-xml-shipping-module-available/?p=1743950 Demitry
  10. Demitry

    New UPS XML Shipping Module available

    Hi, I want to share my trouble shooting & solution for the dreaded UPS “Rating and Service” error. It could actually be one, or several different issues. I hope this helps others because I spent a lot of time trying to resolve this problem and could not find much on the Internet. If you’re getting the following error at checkout for UPS, then you should read this post. Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway : Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway The first and easiest step is to check if your UPS User ID and Password still work on the UPS site. UPS deletes non-active accounts after 18 months. So, if you’re using drop-shipping and not shipping anything yourself via UPS, but only providing the UPS rates on your site as a courtesy to the customer, you must log into your UPS account via their site once a year to keep it active. If your account was deleted, you will need to create a new one. The UPS tech support will guide you through it. If there are no issues with your UPS account & login info, then the next step is to run the debugging script. To do this you have to follow the steps in one of the following files. /includes/modules/shipping/upsxml.php If you’re using the Multi-Vendor Shipping (MVS) contribution: /includes/modules/vendors_shipping/upsxml.php Search the contents of the upsxml.php file for “upsxml.log” and follow the directions to create a log file and set file permissions. Then run a test checkout (partial - only to the checkout_shipping.php page). The details of this are explained in this older thread. Much respect goes to Jan Zonjee for his help there. http://forums.oscommerce.com/topic/248356-ups-xml-rates-services-v124-error/ Download the log file and search it for errors. You are likely to have cURL errors. cURL is a command line tool for getting or sending files using URL syntax. It is used by the UPS API gateway in providing real time rates to your store site. If there are no cURL errors, you should call your hosting company’s tech support and ask them if cURL is compiled into PHP for your account. If it is not, then search the upsxml.php file for “when cURL is not compiled into PHP” and follow those directions to test further. If you get the cURL [60] error, then there is a line in the upsxml.php file that you can uncomment (on or around line 736 or 811, see below), then save, upload, and do a partial test checkout again. That line is: curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); If you get the cURL Error [35]: SSL connect error, then you have entered my world. I contacted UPS tech support and sent them the upsxml.log file, and this was their response: “The UPS API's no longer support SSL. The UPS API's now support TLS 1.0, 1.1 and 1.2. If your solution is browser based, make sure that TLS 1.2 is enabled in the security settings. If your solution is server based, you will need to write the necessary code to make this change to your security protocol.” So, if you have an SSL certificate installed for your store, you would have to call your hosting company’s tech support and find out what version of TLS is enabled in the server security settings. Right now, I have an SSL certificate by COMODO and my hosting company has the TLS 1.2 enabled. Based on that information I found a link that provided the one-line solution that finally fixed my UPS module problem and got rid of that pesky “Rating and Service” error. Here it is: https://stackoverflow.com/questions/30145089/tls-1-2-not-working-in-curl And here is the line I had to add to upsxml.php I added it with the other curl_setopt options. You can just search for “curl_setopt” in the upsxml.php curl_setopt($ch, CURLOPT_SSLVERSION, 6); // Integer NOT string TLS v1.2 Please note: the "6" is relevant to TLS 1.2 ...other versions of TLS require a different number. See the stackoverflow.com link above for what number correlates to your TLS version. I hope that helps and prevents most of you from wasting as much time as I did in trying to resolve this issue. UPS “Rating and Service” ERROR SOLUTION SUMMARY: 1) Login to the UPS site to make sure your account is active and do this at least once a year. 2) Follow the directions in the upsxml.php file to run a debugging script to write to a log file. 3) Review the log file for errors: If cURL error [60] – uncomment related line (736 or 811) in upsxml.php file If cURL error [35] SSL connect – call your hosting company to find out the version of TLS enabled and then add curl_setopt($ch, CURLOPT_SSLVERSION, 6); to the rest of the curl_setopt options in upsxml.php file. Then change the “6” to the number that correlates with your enabled version of TLS. Demitry
  11. Demitry

    Multi_Vendor_Shipping new thread

    Hi Jim, I looked at doing that re-install of MVS and it is a major undertaking for me because my site has a lot of customization and there are a lot of files to make changes to. However, after a long struggle with this dreaded UPS error (see below), I was able to find a solution. And it is one that is not in the MVS V1.3 though it does involve the /includes/modules/vendors_shipping/upsxml.php file. Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway : Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway I'd like to share my resolution to help others with this issue. Please let me know if this thread is the right place for it or if I should do that on the New UPSXML thread, or both. The issue deals with cURL [35] SSL connectivity error and UPS chances with using SSL with their API. The solution is just one line. Let me know. Thanks. Demitry
  12. Demitry

    Multi_Vendor_Shipping new thread

    ok, thanks
  13. Demitry

    Multi_Vendor_Shipping new thread

    ok, thank Jim. I'll look at the code for MVS V1.3 and possibly install that one. To test for compatibility is there anything I need to do other than run a test checkout for domestic, international, and shipping with different weights? Are there any other metrics I should be testing for? Demitry
  14. Demitry

    Multi_Vendor_Shipping new thread

    Hi Jim, I'm getting another UPS error and in the process of trying to figure it out, I realized that I need to upgrade the contribution. So, I have MS2.2 that I upgraded to PHP5.3 and I only use MVS instead of the standard shipping modules that are part of OSC. I looked at the latest MVS V1.3 add-on on OSC contributions and it says that it is for OSC 2.3.4 Could I use this version or should I look for an older one to use with my MS2.2 shop? Thanks. Demitry
  15. Demitry

    New UPS XML Shipping Module available

    @kymation Jim, You're Awesome!!! That was the solution I was looking for! I just installed and tested and there are no UPS errors. The UPS rates are displaying as they should for a delivery to Maryland, USA. Thank you, ...and I had no idea about osCMax infringement of OSC copyright laws. I always thought them and ZenCart were just an evolved extension of OSC. Demitry
  16. Demitry

    Multi_Vendor_Shipping new thread

    Hi Jim, I've got another challenge and hope you could help me solve it. I posted this issue on the New UPS XML Shipping Module available thread since it deals with the UPS module and so far, there has been no viable solution. Because I'm using this MVS contribution, I figured I'd try my luck here. I added the contributions for Country-State Selector and World Zones, which cover pretty much every place in the world. And I started getting a UPS error at checkout with the following message: 111286: ML is not a valid state for the specified shipment. After some troubleshooting I discovered that there are 2 records for Maryland in the database. Apparently there is a Maryland, Liberia as well, and it precedes Maryland, USA in the database and has the "ML" as the abbreviated State/Province. So in /includes/modules/vendors_shipping/upsxml.php what the script is doing, is searching the zones database table for the first instance of "Maryland" and using that record's State/Province 2-letter code for the shipping calculations. When instead, it should be looking for that match based on the zone_country_id. I can probably fix this problem for the Maryland, Liberia issue by changing the name of that province in the database to "Mary-land" but I would rather get a more valid code solution because there may be other duplicate instances and there are over 4K records in that zones table. If anyone has a solution, I would greatly appreciate it. Demitry PS: I later found the following forum thread that deals with this problem but does not provide a code solution and mentions that there are other potential problems like this that exist. http://www.oscmax.com/forums/bugs-and-problems/27232-upsxml-wont-calculate-maryland-detects-abbrev-ml.html
  17. Demitry

    New UPS XML Shipping Module available

    John, I know, I'm from Maryland and the test-checkout I was running was using my old Maryland address. However, the UPS module is searching out the first instance of that state name in the database and this is why (ML) is displayed in the error. This is also why there are no shipping rates because there is no ML as a US state. After I posted this here, I did some more searching and found this for osCMax. Apparently this is a problem and there are more duplicates in that zones table for Florida and other states. http://www.oscmax.com/forums/bugs-and-problems/27232-upsxml-wont-calculate-maryland-detects-abbrev-ml.html Demitry
  18. Demitry

    New UPS XML Shipping Module available

    Hi, I'm hoping someone has a solution for the following issue. I added the contributions for Country-State Selector and World Zones, which cover pretty much every place in the world. And I started getting a UPS error at checkout with the following message: 111286: ML is not a valid state for the specified shipment. After some troubleshooting I discovered that there are 2 records for Maryland in the database. Apparently there is a Maryland, Liberia as well, and it precedes Maryland, USA in the database and has the "ML" as the abbreviated State/Province. So what the script is doing, is searching the zones database table for the first instance of "Maryland" and using that record's State/Province 2-letter code for the shipping calculations. When instead, it should be looking for that match based on the zone_country_id. I can probably fix this problem for the Maryland, Liberia issue by changing the name of that province in the database to "Mary-land" but I would rather get a more valid code solution because there may be other duplicate instances and there are over 4K records in that zones table. If anyone has a solution, I would greatly appreciate it. Demitry
  19. Demitry

    UPS XML Rates & Services v1.2.4 Error

    I just came across this same issue with the UPS module displaying the following error instead of rates: Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway : Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway I tried to log into the UPS site but my UPS User ID and Password were not working. And when I tried to retrieve my password by having their system send me a password reset email, my email was not in their system. I contacted UPS tech support and it turns out that if you do not log into your account within 18 months, they delete your email and account. So, if you have a drop shipping scenario set up and you don't ship via UPS but only use their rates API as a courtesy to the customer, then you need to log into your UPS account once a year to avoid losing it. I followed Jan Zonjee's advice from a few posts above and the log file showed me that it was using my UPS ID and Password to log into UPS API. Hence, this is where that error is coming from. If you are getting this error, try logging into the UPS site. If you cannot login and they don't have your email, then this is likely the problem. Demitry
  20. Demitry

    Country-State Selector

    is Steve or anyone else supporting this thread?? There is an issue with the address_book_process.php when editing an existing address or adding a new address. The problem is with error checking the states drop down menu selection on submit. When submitting that form with the states menu displaying "Please Select" the system will not display a state error because its value is the primary address state. Anyone have a solution for this? Thanks in advance. Demitry
  21. Demitry

    Country-State Selector

    ok, I've got a new challenge with saving the user-selected state in a session for error checking. I have the user-selected country saved in their session but cannot figure out how to get the state saved as well. So, when a user enters their information, selects a country and a state from the drop-down menus, then clicks Continue, the error checking brings back the same page (if there are errors) and the states drop-down menu displays "Please Select" ...what I want it to do is display the user's state selection instead. Here is the code I came up with for the country, and it works great. This is for the order_info.php page, but you can use it on create_account.php or any other page that requires the country & state selection. if (isset($_SESSION['order_info']['country']) && $_SESSION['order_info']['country'] != STORE_COUNTRY) { $country = $_SESSION['order_info']['country']; } else { $country = STORE_COUNTRY; } Does anyone have a code solution for retaining the user-selected state on page reload? Any and all help would be greatly appreciated. Thanks. Demitry
  22. Demitry

    Country-State Selector

    @dennish Dennis, I just wanted to thank you for your post on here. I spent hours and hours trying different ways to get the countries to pull up the correct states. It was working in my mobile_create_account page from an earlier install, but I could not figure out why it would not work in any other place on my site. The key was the <div id="indicator"> tag. I did not want another image on my site so I completely overlooked that div tag, and omitting it was causing the problem. Here is the thing though, you don't have to have the actual image, but you do need that div tag for the countries to pull up the correct states. So, I just added the div tag itself and everything works! <div id="indicator"></div> Demitry
  23. Demitry

    Multi_Vendor_Shipping new thread

    ok, thank Jim. I'll check it out. Demitry
  24. Demitry

    Multi_Vendor_Shipping new thread

    Jim, Old code does not mean that it's bad code. MVS contribution is one of the better ones on OSC. It's functional and I think most if not all of the bugs have been worked out. It is the only solution I know of for managing drop shipping vendors. As for upgrading to a newer version of OSC, I am really not looking forward to that nightmare with so many customized scripts. I'm not a developer so I still struggle with div tag structures and am not at all a fan of heavy javascript use, which is a big part of the new OSC platform. Plus, I am not sure if the new version of OSC is mobile responsive or not. The last time I looked, it was not, which means duplicate files for the mobile version - that is what I am doing now with MS2.2. When the time comes to upgrade, I will look at another ecom platform with my long-list of must-haves and evaluate the amount of subbed developer work required to complete that list. Demitry
  25. Demitry

    Multi_Vendor_Shipping new thread

    come to think of it, I don't even really need that conditional "if" statement for the shipping module error.
×