And -30% database queries
What does it mean for us?
Posted 10 April 2008 - 11:14 AM #21
And -30% database queries
Posted 10 April 2008 - 11:25 AM #22
I used Install Manager but first I backed up whole store and then upgraded. It went very smooth, though sometimes my FTP got stuck and got warning, but clicked RETRY and it continued. It only happened during skins installations. Now I have to go to CPanel on my server and again get rid of skins I will never use. Besides, everything went smooth and my shop seems to work, at least I tried to make order and no problem with that. Visual changes are not seen, other ones are not visible for me either. My currency exchange mod works fine too. As long as CSC Team did something to improve cart I`m fine with that. All I want yet, is faster loading.
What does it mean for us?
Posted 10 April 2008 - 11:27 AM #23
Posted 10 April 2008 - 02:43 PM #24
Posted 10 April 2008 - 05:45 PM #25
Posted 10 April 2008 - 06:31 PM #26
Posted 10 April 2008 - 10:43 PM #27
Posted 11 April 2008 - 03:46 AM #28
Posted 11 April 2008 - 11:11 AM #29
BarryH
CS-Cart v4.4.3 (Plus one being developed v4.5.2 SP2)
UK User
Posted 11 April 2008 - 09:52 PM #30
Posted 11 April 2008 - 10:12 PM #31
ALTER TABLE cscart_product_prices DROP COLUMN KEY `src_k`; ALTER TABLE cscart_product_prices DROP COLUMN KEY `unique_key`; ALTER TABLE cscart_product_prices DROP ADD UNIQUE KEY `unique_key` (`lower_limit`,`membership_id`,`product_id`);
Posted 11 April 2008 - 11:15 PM #32
Posted 11 April 2008 - 11:37 PM #33
I have never used 1.3.4 SP3 so I do not know.
------------------------------------
I assume your first error came when trying to duplicate the original database?
Not sure why that happened.
If you're trying to import the database.sql from the "cscart_v1.3.5-sp3.zip" file don't. Use the one from the "upgrade-134sp3-135sp3.tgz". Import that one into the duplicate of the original database.
As for your second error, not sure why it happened to that either. My upgrade script (from 1.3.5 SP2) had the same exact queries and it worked just fine.
Don't know about the SSL, as I don't use it either. See if it has been enabled in the Admin->Settings.
About the 208, JLS must have added some tables, because I only have 206. And I added one for a mod, so 205 is correct.
Posted 11 April 2008 - 11:45 PM #34
Posted 11 April 2008 - 11:52 PM #35
Thanks for the reply..
I dont have a live store (only testing) so i just applied the database/sql from the upgrade-134sp3-135sp3.tgz after backup and came up with that error first, as i said the entry in my db matched the info of the query that was trying to run so i left it.
am i right in saying that these lines are just trying to drop those column keys? if so is it worth just deleting them via phpmyadmin?
Weired thing is.. In IE7 I get 404!
Posted 13 April 2008 - 03:33 PM #37
BarryH
CS-Cart v4.4.3 (Plus one being developed v4.5.2 SP2)
UK User
Posted 14 April 2008 - 12:35 AM #38
ALTER TABLE cscart_product_prices DROP COLUMN KEY `src_k`; ALTER TABLE cscart_product_prices DROP COLUMN KEY `unique_key`; ALTER TABLE cscart_product_prices DROP ADD UNIQUE KEY `unique_key` (`lower_limit`,`membership_id`,`product_id`);
Posted 14 April 2008 - 12:53 AM #39