Jack_mcs Posted May 14, 2018 Author Share Posted May 14, 2018 I have the files and instructions changed but there are a few code changes I wanted to make first. I'll upload a new version this week, without those additional changes if I can't finish them in time. valquiria23 1 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 15, 2018 Author Share Posted May 15, 2018 A new version has been uploaded. The changes are only for the Bootstrap version and maybe some later versions of 2.3.4. If your shop is a different version, there's no need to bother with this update. Here are the changes made: Added a clear command on the sitemap page to keep continue button in place - found by member 14steve14. Added index modules (BS and some later 2.3.4 versions only). Added hook for the product page (BS and some later 2.3.4 versions only). Fixed some security issues. Removed the install instructions that referenced database tables and filenames for the BS version - found by member valquiria23. Please be sure to read the install file since the procedure has changed. valquiria23 1 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
valquiria23 Posted May 15, 2018 Share Posted May 15, 2018 Dear Jack @Jack_mcs Just try the new version and I had some problems: The first problem occurred after the installation I had the following error: 1146 - Table 'oscnt235.sitemap_seo_settings' doesn't exist select * from sitemap_seo_settings where language_id = '2' LIMIT 1 [TEP STOP] which I solved by executing: http:// YOUR DOMAIN NAME /sitemap_seo_install.php?reset The second problem is that the sitemap page do not Display the Manufacturers or other information only the categories (without its title) . Any idea what can it be? Best regards Valqui Quote Community Oscommerce fan You'll find the latest osC community version here. Link to comment Share on other sites More sharing options...
valquiria23 Posted May 15, 2018 Share Posted May 15, 2018 Dear Jack @Jack_mcs I add screenshot Quote Community Oscommerce fan You'll find the latest osC community version here. Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 16, 2018 Author Share Posted May 16, 2018 Per the instructions - "Change the settings in admin->Sitemap SEO->Settings Control." If you don't enter a heading for a section, that section won't display. valquiria23 1 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
valquiria23 Posted May 16, 2018 Share Posted May 16, 2018 Dear Jack @Jack_mcs You're a genius!!! thank you very much for your help!!!! Best regards Valqui Quote Community Oscommerce fan You'll find the latest osC community version here. Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 16, 2018 Author Share Posted May 16, 2018 I'm glad it worked for you. :) valquiria23 1 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Demitry Posted May 20, 2018 Share Posted May 20, 2018 @Jack_mcs hi Jack, I tried to install this addon and am not able to get the database tables set up. I've installed and uninstalled via sitemap_seo_install.php and sitemap_seo_uninstall.php with no luck. I initially replaced all the deprecated <font> tags from the install file with <span> tags and thought that I may have made an error, so I uninstalled and installed the original file from your package (the one with the <font> tags). That did not work either. I looked at my database and there are no sitemap tables installed. Could you take a look at that install file and see if anything sticks out? sitemap_seo_install.php Quote osCommerce: made for programmers, ...because store owners do not want to be programmers. https://trends.google.com/trends/explore?date=all&geo=US&q=oscommerce Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 20, 2018 Author Share Posted May 20, 2018 When you run the install file, add the reset parameter if it is already installed, like this: http://....com/sitemap_seo_install.php?reset Though that should only be needed if the database changes have already been made. If you use the uninstall script then you don't need to do that. I have used both of those files recently when installing the addon so they do work. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Demitry Posted May 21, 2018 Share Posted May 21, 2018 (edited) yeah, there is nothing in my error log either. I personally prefer the manual SQL installs rather than running an auto-install script, but I understand the need for it. I'll try and see if I can add these SQL commands manually. Jack, do you have a notepad version of this SQL install? Edited May 21, 2018 by Demitry Quote osCommerce: made for programmers, ...because store owners do not want to be programmers. https://trends.google.com/trends/explore?date=all&geo=US&q=oscommerce Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 21, 2018 Author Share Posted May 21, 2018 The older versions of the addon have sql files. I don't recall when I switched but you can go through them to see. If there are any additional database changes made after the switch, they will be documented in the upgrade files. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Demitry Posted May 21, 2018 Share Posted May 21, 2018 Jack, I went back to version 1.7 ..according to the history log v1.8 is when you took out the sql file. I'm not great with sql and that version was dated back to 12/23/2009. Since that time MySQL has changed and osC now requires utf8 encoding compliance. Could you take a look and see if it is compatible with the latest version of osC and MySQL? I've attached that sql file from the v1.7 release. I just want to make sure it's all correct and not missing anything before installing it. Thanks. sitemap_seo.sql Quote osCommerce: made for programmers, ...because store owners do not want to be programmers. https://trends.google.com/trends/explore?date=all&geo=US&q=oscommerce Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 21, 2018 Author Share Posted May 21, 2018 It is OK to run. It adds a few settings that were later removed but I don't think those will cause any issues. They were removed so they could be handled in the settings section for multi-language shops. If your shop has more than one language, then you may want to remove them too (should be in the update docs). Otherwise it doesn't matter. Also, If the sitemap tables already exist, that script will remove them and add them back in. But it won't remove the configuration settings so you could end up with two of the same settings if they already exist. The commands to add to the configuration tables assumes a group ID of 545. If that group, in the configuration_group table, already exists the scrip will not work correctly so you should change that number, if necessary. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Demitry Posted May 22, 2018 Share Posted May 22, 2018 (edited) @Jack_mcs Jack, that may have been the issue with the auto install. I checked and the Featured Products addon has that 545 group ID. So, should I just change all the 545 to NULL? Update: my mistake that was configuration_id Edited May 22, 2018 by Demitry Quote osCommerce: made for programmers, ...because store owners do not want to be programmers. https://trends.google.com/trends/explore?date=all&geo=US&q=oscommerce Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 22, 2018 Author Share Posted May 22, 2018 The install file uses code to get the next ID from the database so it shouldn't clash with what you have. Although, I haven't tested it with php 7 so maybe that has something to do with it. As for the manual install, the first command will create an entry in the configuration_group table. That is required. Whatever ID is used there need to be changed for the rest of the options. So if 545 is already in but 546 isn't, then just do a search and replace in the MySQL file and replace all instances of '545' with '546' (apostrophes required). Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Demitry Posted May 22, 2018 Share Posted May 22, 2018 ok, cool. thank you, Quote osCommerce: made for programmers, ...because store owners do not want to be programmers. https://trends.google.com/trends/explore?date=all&geo=US&q=oscommerce Link to comment Share on other sites More sharing options...
Demitry Posted May 23, 2018 Share Posted May 23, 2018 (edited) To adapt this addon for the responsive BS version so that the left and right columns do not mesh together on smaller screens, do the following: catalog/sitemap.php FIND this code: $leftWidth = (tep_not_null($rightColDisplay) ? 'style="float:left; vertical-align:top; width:50%"' : 'style="float:left; vertical-align:top; width:100%"'); $rightWidth = (tep_not_null($leftColDisplay) ? 'style="float:right; vertical-align:top; width:50%"' : 'style="float:right; vertical-align:top; width:100%"'); and REPLACE IT with this: $leftWidth = (tep_not_null($rightColDisplay) ? 'class="pull-left col-xs-12 col-sm-6"' : 'class="pull-left col-xs-12"'); $rightWidth = (tep_not_null($leftColDisplay) ? 'class="push-right col-xs-12 col-sm-6"' : 'class="push-right col-xs-12"'); Edited May 23, 2018 by Demitry Quote osCommerce: made for programmers, ...because store owners do not want to be programmers. https://trends.google.com/trends/explore?date=all&geo=US&q=oscommerce Link to comment Share on other sites More sharing options...
valquiria23 Posted May 24, 2018 Share Posted May 24, 2018 Dear Jack @Jack_mcs Just try the new version and I have the next problem : The Related Categories appear, but the Related Products and Related Manufacturers do not appear. In the admin I have the Show Related Products and Show Related Products by Manufacturer in true. Any idea what can it be? Best regards Valqui Quote Community Oscommerce fan You'll find the latest osC community version here. Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 25, 2018 Author Share Posted May 25, 2018 No, I'm sorry but I don't. Unfortunately, it might be a while before I can get back to this addon, though I will as soon as I can. valquiria23 1 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Demitry Posted May 25, 2018 Share Posted May 25, 2018 @valquiria23 Valqui, Setting those to view in the Configuration page is not enough. You have to go into Admin > Sitemap SEO > Settings Control and add the Heading Text into the input boxes for the sections you want to display. Quote osCommerce: made for programmers, ...because store owners do not want to be programmers. https://trends.google.com/trends/explore?date=all&geo=US&q=oscommerce Link to comment Share on other sites More sharing options...
valquiria23 Posted May 25, 2018 Share Posted May 25, 2018 Dear @Demitry and Jack @Jack_mcs The Related Categories appear, but the Related Products and Related Manufacturers do not appear. please see the example image: Another problem is that I can not enable the options in the Admin: Enable Articles Manager, Enable InfoPages and Enable Page Manager. please see the example image: Please I need help my friends !!! Best regards. Valqui Quote Community Oscommerce fan You'll find the latest osC community version here. Link to comment Share on other sites More sharing options...
Demitry Posted May 26, 2018 Share Posted May 26, 2018 @valquiria23 Valqui, I think the reason you cannot enable Articles Manager, InfoPages and Page Manager.. is because I you have to have those addons installed first. I have the same thing on my BS Edge install. As for the manufacturers and related pages on the product_info.php page, I just noticed that I have the same issue. I actually have not seen that Related Categories menu on the product_info.php page, until you brought it up. I'll look into it on my end and see if I can come up with anything. valquiria23 1 Quote osCommerce: made for programmers, ...because store owners do not want to be programmers. https://trends.google.com/trends/explore?date=all&geo=US&q=oscommerce Link to comment Share on other sites More sharing options...
Demitry Posted May 26, 2018 Share Posted May 26, 2018 @Jack_mcs Jack, Valqui is right, there is a problem with these two modules displaying. I'm not sure if it's the javascript, the hook file, or the modules. And, the modules' html needs to be restructured. I looked at the source code and there are partial html table structures inside div tags,.. and that's just for the Categories module that displays. valquiria23 1 Quote osCommerce: made for programmers, ...because store owners do not want to be programmers. https://trends.google.com/trends/explore?date=all&geo=US&q=oscommerce Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 26, 2018 Author Share Posted May 26, 2018 I know. It works fine in previous versions. I will fix it once I have time. valquiria23 1 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
valquiria23 Posted May 26, 2018 Share Posted May 26, 2018 Dear Jack @Jack_mcs We will be waiting anxiously for the fix. From already thank you very much!! Kiss Valqui Quote Community Oscommerce fan You'll find the latest osC community version here. 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.