shags38:
Firstly I loaded 2.110 because I had it in my hard drive from previous installations
smiles Glad it was not because of a broken / missing feature or installation problems :)
Less than 30% of the code from legacy versions is still present and the legacy code has some known issues with newer versions of MySQL and PHP. For the most part I am only providing support for the updated versions.
If you install version 2.212, make sure you look at this patch and the first post in this thread.
shags38:
I have downloaded 2.212 and read the readme.txt So where do I turn off Zencart SQL Cache.
By default the SQL Cache is not enabled. You can check the setting of "SQL_CACHE_METHOD" in your "configure.php" files.
The main reason I do not recommend using "Ultimate SEO URLs" with the SQL Cache enabled under Zen Cart 1.3 is the plugin will utilize the SQL Cache (if enabled). Doesn't sound like a bad thing.... But there were some minor issues (the last time I tested) with the results returned by the database abstraction layer (when the SQL Cache is enabled) in the Zen Cart 1.3 & 1.5 branches. These minor issues become major when the cache was used for every URI generated on a page ;)
I've included a pre-release of the database abstraction layer (including fixes) from the Zen Cart 1.6 branch which can be used on Zen Cart 1.5 branch and takes care of the issues. I have not tested the changes merged into the Zen Cart 1.3 branch (they might work, or they might break things).
The query_cache add-on (compared to the Zen Cart SQL Cache) typically provides a greater performance enhancement in most situations (but not all). If you were using the Zen Cart SQL Cache, I would highly recommend the query_cache add-on by data-diggers. This awesome add-on is included with Zen Cart 1.5.1 out-of-box.
shags38:
replacing the old version? and how would I recognize the files in the database to delete? what files would they be?
Three parts of the legacy versions of "Ultimate SEO URLs" you should remove.
- The configuration. There was a function included in the old version to remove any configuration settings in the database and also the seo_cache table. This should be run first. I cannot remember how to call the function, but you can take a look in the seo.url.install.php... and then run those SQL Queries in the uninstall function against the database.
- The files. Any files you added or changed to install the old version.
On versions newer than 2.150 you should always use the included uninstall instructions! Do not use the above instructions!
shags38:
I haven't yet upgraded to v1.5 as when I read the instructions just after it was released I found it too complicated - I must try it again I know but I heed to keep the site working efficiently until I do :smile:
Completely understandable. Best wishes when you get time to undertake the adventure!
I found it less intimidating once I understood you could skip all the overwrite and merge. When I do an upgrade now I just install a new clean copy (setup script)... Then copy the old db over the new db... then run the setup script again ONLY updating the database... After that it's just pick a template, add necessary plugins, and make any needed changes. Plus this process allows you to retain your old working installation - just to be on the safe side.