selin Posted July 17, 2013 Share Posted July 17, 2013 (edited) Hi, I, how do, mysql cache disable ..? Problem: one product, this is price: and w.price = 0 (database). Back Office and Shop price = 160 thank u Edited July 18, 2013 by selin (see edit history) Link to comment Share on other sites More sharing options...
selin Posted July 18, 2013 Author Share Posted July 18, 2013 upp Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted July 18, 2013 Share Posted July 18, 2013 back office-->advanced parms-->performance scroll down to caching turn of caching 1 Link to comment Share on other sites More sharing options...
selin Posted July 18, 2013 Author Share Posted July 18, 2013 back office-->advanced parms-->performance scroll down to caching turn of caching I tried. it did not work ( Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted July 18, 2013 Share Posted July 18, 2013 what do you mean it does not work? Please be specific, i.e. 'it does not work' is not sufficient detail. Note: when you do not get a resolution in a timely fashion, this is generally caused by a lack of detail, ps version, site link, screen captures etc. So, the more detail you supply the better the community can help you. 1 Link to comment Share on other sites More sharing options...
selin Posted July 18, 2013 Author Share Posted July 18, 2013 what do you mean it does not work? Please be specific, i.e. 'it does not work' is not sufficient detail. Note: when you do not get a resolution in a timely fashion, this is generally caused by a lack of detail, ps version, site link, screen captures etc. So, the more detail you supply the better the community can help you. Dear El Patron, I tried. it did not work ( in db: id_product = 4699 - price = 0 w.price = 0 in shop: id_product = 4699 - price = 160 What should I do? :( Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted July 18, 2013 Share Posted July 18, 2013 are you using the default theme? or custom theme....is custom theme what is it's name and where did you get it? it's probably time to supply a url to your shop Link to comment Share on other sites More sharing options...
selin Posted July 18, 2013 Author Share Posted July 18, 2013 theme = default Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted July 18, 2013 Share Posted July 18, 2013 please post your url Link to comment Share on other sites More sharing options...
selin Posted July 18, 2013 Author Share Posted July 18, 2013 answered Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted July 18, 2013 Share Posted July 18, 2013 please post it here..not via pm...this way the entire community can help.... Link to comment Share on other sites More sharing options...
selin Posted July 18, 2013 Author Share Posted July 18, 2013 I, How, Manuel product price update? ( programming = php Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted July 18, 2013 Share Posted July 18, 2013 what is your first language? My suggestion at this point is to post in that portion of the forum for your language. Link to comment Share on other sites More sharing options...
Dh42 Posted July 18, 2013 Share Posted July 18, 2013 Are you on shared hosting or a vps machine? I wouldn't suggest disabling the query cache, but I can tell you how to do it. 1 Link to comment Share on other sites More sharing options...
selin Posted July 18, 2013 Author Share Posted July 18, 2013 Are you on shared hosting or a vps machine? I wouldn't suggest disabling the query cache, but I can tell you how to do it. I have vds. In the vds, share hosting. I, How do ? Link to comment Share on other sites More sharing options...
selin Posted July 18, 2013 Author Share Posted July 18, 2013 (edited) what is your first language? My suggestion at this point is to post in that portion of the forum for your language. I checked in different languages .. Def. lang = Turkish. Edited July 18, 2013 by selin (see edit history) Link to comment Share on other sites More sharing options...
Dh42 Posted July 18, 2013 Share Posted July 18, 2013 If you have shared hosting you are not going to be able to do it. You have to manage your own mysql installation to do it. Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted July 18, 2013 Share Posted July 18, 2013 I checked in different languages .. Def. lang = Turkish. You may also want to post here: http://www.prestashop.com/forums/forum/46-turkce-toplulugu/ it is an active community... Link to comment Share on other sites More sharing options...
selin Posted July 18, 2013 Author Share Posted July 18, 2013 If you have shared hosting you are not going to be able to do it. You have to manage your own mysql installation to do it. Okay, how ? Link to comment Share on other sites More sharing options...
selin Posted July 18, 2013 Author Share Posted July 18, 2013 You may also want to post here: http://www.prestasho...rkce-toplulugu/ it is an active community... view Link to comment Share on other sites More sharing options...
Dh42 Posted July 18, 2013 Share Posted July 18, 2013 Run this from the mysql command line SET GLOBAL query_cache_size = 0; Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted July 18, 2013 Share Posted July 18, 2013 sizin dükkan URL nedir? Link to comment Share on other sites More sharing options...
selin Posted July 18, 2013 Author Share Posted July 18, 2013 Run this from the mysql command line SET GLOBAL query_cache_size = 0; Where ? phpMyadmin ? Link to comment Share on other sites More sharing options...
Dh42 Posted July 18, 2013 Share Posted July 18, 2013 The mysql command line, you will need to ssh into your site and start the command line. Link to comment Share on other sites More sharing options...
selin Posted July 18, 2013 Author Share Posted July 18, 2013 it did not work. back office-> updated product price = db price okay and shop price okay. but manuel db price (0) updated => shop price = before price ( db price = 0 shop price = 160 ( what the problem ? pff :unsure: Link to comment Share on other sites More sharing options...
Dh42 Posted July 18, 2013 Share Posted July 18, 2013 Turn your file system cache off under performance. Something else is wrong, this has nothing to do with your database. Clear your browser cache too. Link to comment Share on other sites More sharing options...
selin Posted July 18, 2013 Author Share Posted July 18, 2013 all cache = disable all browser = the same status Link to comment Share on other sites More sharing options...
selin Posted July 18, 2013 Author Share Posted July 18, 2013 (edited) The problem is solved ! Thank You: #MEG Venture edit-> solved url: http://www.prestashop.com/forums/topic/262230-presta-mysql-cache-sorunu/ Edited July 18, 2013 by selin (see edit history) Link to comment Share on other sites More sharing options...
artemu78 Posted July 21, 2013 Share Posted July 21, 2013 The problem is solved ! Thank You: #MEG Venture edit-> solved url: http://www.prestasho...l-cache-sorunu/ could you please write in english? Link to comment Share on other sites More sharing options...
Perla2018 Posted October 17, 2015 Share Posted October 17, 2015 I tried my sql cache, but when I go back to the file system cache front office white page. How to fix Link to comment Share on other sites More sharing options...
Recommended Posts