NicoC

Hi, from the back office/ catalog/ product - I can not see my products , all I get is an error message : Bad SQL query Expression #12 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'easydeal_98x.sav.quantity' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by' from the shop front end, I can see categories but no products either. Asked web hosting, they said there is no SQL changes recently and is more likely to be prestashop issue. Can someone show me a light, please?

Hi, updated my site from 1.6.0.6 to 1.6.1 everything looks fine. but after changing the price on one of the products, I noticed all the products have been duplicated. eg, No.1 products appear 4 times, No.3 product appear 3 times etc. it happens in the back office product view, and the front end looks fine. I have attached a pic here, can anyone please help?

Hi, I think my site has been hacked? stolen? It started when I was maintaining some images on my shop and I found the root address of those images had been changed to someone else's site, and next I found all my shop's root address all become a foreign address. So, I went to check what website it is and surprisingly found it is exactly the same as my site! next, I found this foreign address has got the same IP as my dedicated (Bluehost) IP address. I have a backup, so I quickly delete everything and change all the passwords and restore it. Now, I can see my site seems to be working fine, the root address is showing my own domain not the foreign one. So I guess my site is now clean?? After I restored - I tried the foreign address to see if it was still mirroring my website, and it was still a copy of mine, however the root addresses were showing as mine. We phoned support at Bluehost requesting they change our IP address, but they were not helpful and couldn't do anything to stop the foreign address using the same IP. Has anyone had a similar experience & is it right to say my site is clean now? how to deal with the foreign site pointing to the same IP issue? or is the only option to move to a different host/IP ? I would be very grateful for any suggestions/help

thanks Vekia your reply. that is a useful advise, and I have deleted more than 20 unused modules so far it seems worked. I think, I will also prepare a new install and update my shop to a different web host (as the current one not being very much helpful from day one)

Hi All, after I install a unfit module, I can not see anything under module page in the back office but only this error message: Fatal error: Out of memory (allocated 72613888) (tried to allocate 122880 bytes) in /websites/123reg/LinuxPackage98/homepage/public_html/classes/Module.php(583) : eval()'d code on line 1125 of course I quickly delete this unfit module but still get the same error. I don't know why. I googled all the topic/ posts and all suggest I should increase my memory limit, but as I am on a share host, they would not let me to increase it unless pay for a upgrade. is upgrade the only way? is there any way can work around it ? coz everything in my shop front / back seem running alright, apart from the problem above, can anyone help ?

Hi, I have problem with insert the Sitelock floating badge on the footer, as I am new to prestashop and css, so can not work out where goes wrong. Please be so kind to help me and point out where/how to change my code? below is from the footer.tpl <!-- Right --> <div id="right_column" class="column"> {$HOOK_RIGHT_COLUMN} </div> </div> <hr class="hrline" /> </div><!-- page --> <!-- Footer --> <!--sitelock icon--> <div id="sitelock_shield_logo" class="fixed_btm" style="bottom:0;position:fixed;_position:absolute;right:0;"><a href="https://www.sitelock.com/verify.php?site=mysite.com" onclick="window.open('https://www.sitelock.com/verify.php?site=mysite.com','SiteLock','width=600,height=600,left=160,top=170');return false;" ><img alt="malware removal and website security" title="SiteLock" src="//shield.sitelock.com/shield/mysite.com"/></a></div> <!-- end of sitelock icon--> <div id="footer"> <div id="footershadow"></div> {$HOOK_FOOTER} <p>{l s='Copyright'} © {$smarty.now|date_format:"%Y"} {$shop_name|escape:'htmlall':'UTF-8'}. {l s='All Rights Reserved'}.</p> </div> {/if} </body> </html> and below is from my global /* Footer */ #footer { background-image:url(../img/footershadow.gif); color: #333333; margin: 0 auto 0px auto; padding: 0 0 0px 0; padding-bottom: 15px; clear: both; text-align: center } thanks in advance!! ps. I did follow the step as here but no luck.

as this is tagged as solved topic, i will open a new one. sorry about that.

Hi, I have the same problem with insert the Sitelock floating badge on the footer, as I am new to prestashop and css, so can not work out where goes wrong. Please be so kind to help me and point out where/how to change my code? below is from the footer.tpl <!-- Right --> <div id="right_column" class="column"> {$HOOK_RIGHT_COLUMN} </div> </div> <hr class="hrline" /> </div><!-- page --> <!-- Footer --> <!--sitelock icon--> <div id="sitelock_shield_logo" class="fixed_btm" style="bottom:0;position:fixed;_position:absolute;right:0;"><a href="https://www.sitelock.com/verify.php?site=mysite.com" onclick="window.open('https://www.sitelock.com/verify.php?site=mysite.com','SiteLock','width=600,height=600,left=160,top=170');return false;" ><img alt="malware removal and website security" title="SiteLock" src="//shield.sitelock.com/shield/mysite.com"/></a></div> <!-- end of sitelock icon--> <div id="footer"> <div id="footershadow"></div> {$HOOK_FOOTER} <p>{l s='Copyright'} © {$smarty.now|date_format:"%Y"} {$shop_name|escape:'htmlall':'UTF-8'}. {l s='All Rights Reserved'}.</p> </div> {/if} </body> </html> and below is from my global /* Footer */ #footer { background-image:url(../img/footershadow.gif); color: #333333; margin: 0 auto 0px auto; padding: 0 0 0px 0; padding-bottom: 15px; clear: both; text-align: center } thanks in advance