cutecat

Hi I have just run a test, with and without CDN with cloudflare. It looks like with CDN, my site load a bit slower. like 5% slower. should CDN help my site to load faster? I also did not enable the cache on my system, as i am on a shared hosting. This is my shopping site

i got it resolved with the help of DH!!! Thanks DH!!! he just enabled layered navigation block and it back online!!! rob what is your issue? follow these steps and you should be good to go. /home/lovelyin/public_html/themes/alysum_2.0/css/product_list.css (any location of the file is ok.) #product_list li .color_picker span { border: 1px solid #C0C0C0; display: inline-block; height: 14px; width: 8px; } /home/lovelyin/public_html/themes/alysum_2.0/product-list.tpl (it should be placed within <div class="center_block">, also I have placed it after the title of the product. I placed it after {if isset($product.new) && $product.new == 1}<span class="new">{l s='New'}</span>{/if}</a> ) <!-- START color picker --> <div class="color_picker"> <!-- disable color, will be using "more colors text" {if isset($product.colors)}{foreach from=$product.colors item=v} <span style="background: {$v.value};" title="{$v.name}"></span>{/foreach} {/if} --> {if !empty($product.colors)} <font color="#9933ff">More Colors</font> {/if} </div> <!-- END color picker --> /home/lovelyin/public_html/modules/blocklayered/blocklayered.php (Place the code after this $products = Product::getProductsProperties((int)$cookie->id_lang, $products); ) //START color picker foreach ($products as $key => $product_item) { $product = new Product($product_item['id_product'], false, $cookie->id_lang); $colors = array(); $attributes_groups = $product->getAttributesGroups($cookie->id_lang); if (is_array($attributes_groups) && $attributes_groups) { foreach ($attributes_groups as $k => $row) { // Color management if ((isset($row['attribute_color']) && $row['attribute_color']) || (file_exists(_PS_COL_IMG_DIR_.$row['id_attribute'].'.jpg'))) { $colors[$row['id_attribute']]['value'] = $row['attribute_color']; $colors[$row['id_attribute']]['name'] = $row['attribute_name']; } } $products[$key]['colors'] = $colors; } } //END color picker

anyone can advise?

these are the only setting I have done Smart cache for CSS Use CCC for CSS. Smart cache for JavaScript Use CCC for JavaScript. Minify HTML Keep HTML as original Compress inline JavaScript in HTML Keep inline JavaScript in HTML as original Apache optimization

he is using prestashop. you can check out my site also. my TTFB is now around 1 sec. I may install cache next time when this really pick up to full stream in the future. but now, I am quite happy with the speed I am getting already. it was like 6 to 10 sec of TTFB and now it is 1 sec to 2.

i just used firebug to check and there is color picker. but it is blank in the div <div class="color_picker"> </div> I had tried on another site with a fresh installation and it can work!!! Not sure what is causing this issue to block the command... anyone got any idea?

i am having a live prestashop now, but after the upgrading, I am getting so much issue that I am thinking of reinstalling the whole shop. I have tested with another sub domain and all the configuration i have done are working perfectly... but not for my current shop. are there any steps? and how do i tie in with my old data base?

anyone tried it with 1.5.5? I need to get this working, as most of my items has quite a lot of color... this is my site

these are the steps I have done. did I missed out anything? /home/mysite/public_html/themes/new_theme/css/product_list.css (any location of the file is ok.) #product_list li .color_picker span { border: 1px solid #C0C0C0; display: inline-block; height: 14px; width: 8px; } /home/mysite/public_html/themes/new_theme/product-list.tpl (it should be placed within <div class="center_block">, also I have placed it after the title of the product. I placed it after {if isset($product.new) && $product.new == 1}<span class="new">{l s='New'}</span>{/if}</a> ) <!-- START color picker --> <div class="color_picker"> <!-- disable color, will be using "more colors text" {if isset($product.colors)}{foreach from=$product.colors item=v} <span style="background: {$v.value};" title="{$v.name}"></span>{/foreach} {/if} --> {if !empty($product.colors)} <font color="#9933ff">More Colors</font> {/if} </div> <!-- END color picker --> /home/mysite/public_html/modules/blocklayered/blocklayered.php (Place the code after this $products = Product::getProductsProperties((int)$cookie->id_lang, $products); ) //START color picker foreach ($products as $key => $product_item) { $product = new Product($product_item['id_product'], false, $cookie->id_lang); $colors = array(); $attributes_groups = $product->getAttributesGroups($cookie->id_lang); if (is_array($attributes_groups) && $attributes_groups) { foreach ($attributes_groups as $k => $row) { // Color management if ((isset($row['attribute_color']) && $row['attribute_color']) || (file_exists(_PS_COL_IMG_DIR_.$row['id_attribute'].'.jpg'))) { $colors[$row['id_attribute']]['value'] = $row['attribute_color']; $colors[$row['id_attribute']]['name'] = $row['attribute_name']; } } $products[$key]['colors'] = $colors; } } //END color picker

just upgraded to 1.5.5 and looks like i am unable to have the more color options...

you have to enable the profiling to see the details. here is the guide http://www.inmotionhosting.com/support/edu/prestashop-15/348-enabling-debug-profiler

How do we tweak the database?

not sure if the server is overloaded. here is the profiling

my current setting have query cache - YES query cache limit - 64 MiB query cache min res unit - 4,096 query cache size - 256 MiB query cache type - ON query cache wlock invalidate - OFF

also here is the result looks like both are doing ok. http://www.webpagetest.org/video/compare.php?tests=130904_B1_10M5,130904_F6_ZYD I think I would need to think of a way to let the SQL load faster without overloading.