Havouza

Hi @Mediacom87 I will ask the owner. But unfotunately I think the problem is bigger. He has 2 shops, mostly identical. Same version, same number of products, about 1500 in each, same modules etc. They both resides on the same vps. Jv74.se is horribly slow, jv80.se is much better even if not perfect. I have run out of ideas about what can be wrong. The biggest delay is to load the frontpage. Both shops has memcached installed can you give a hint where to look

I am trying to find why the shop is so slow. this could be one reason to it. The other shop has only 10% of the rows and is also much faster. It seems that the table only holds statistics

I have found a corrupt db table, ps_guest. It contains 2596906 rows. What is this? Result when try to recover Wrong bytesec: 0- 0- 0 at 54229816; Skipped Can the table be emptied

Well our mysql server do that. It only has to do with the bind address. And as said I have already tested the user from remote, the question is if just the username is enoughj because when you test it you use user@ip

Hi! The shop today connect to a local msql server. But we want to change that and connect to a remote one. I have donee all preparations and the user is approved and tested. But how should it look in settings.inc? _DB_SERVER_', 'localhost'); define('_DB_NAME_', 'db_jv74'); define('_DB_USER_', 'jxxxx'); define('_DB_PASSWD_', 'xxxxxxxx');

Hi all! Which is the optimal caching method and best settings? Shop run on Ubuntu 20.04

The only real diff between them is that jv74 is a converted ps from the very early tb days, the other one is created with tb 1.0.2 i think

Its strange because nothing is done to any of the shops more then price uploads. All came when I installed bleeding edge

The other one is jv80.se

Hi We have a vps with 2 shops running. they are really setuop the same way with same modules etc. Both TB 1.4 One of them is for some reason very slow now. jv74.se The other one loads much faster and searches is much faster. is there some way to diagnose what is wrong? They both run on ubuntu First I thought it was my internet here in Cyprus that was slow but the owner in Sweden say the same and he has a 100/100 fiber

What is the best way to migrate a shop from one vps to another?

Hi all! We need to migrate one of our shops to a new vps. The old one runs ubuntu 18.04 so I has snapshots built in but I suspect that it not possible to just take a snapshot and then reload it on another vps. So which way is the best and most secure way to do it. Regards Anders

@datakick Well I dont know why but I decided to switch off the smartycache and clear the cache and now all is back to normal. Dont ask me why

Its very strange. Yesterday it all worked and today not. In one shop the only things that happened overnight was minor price updates and in the other shop nothing. Both stopped working over night. The VPS is not updated either.

@datakick Can this be the problem? [Thu Jul 14 14:53:56.602927 2022] [proxy_fcgi:error] [pid 10370] [client 185.60.237.38:47824] AH01071: Got error 'PHP message: PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/jv74/public_html/classes/module/Module.php(966) : eval()'d code on line 2194PHP message: PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/jv74/public_html/classes/module/Module.php(966) : eval()'d code on line 2194PHP message: PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/jv74/public_html/classes/module/Module.php(966) : eval()'d code on line 2196PHP message: PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/jv74/public_html/classes/module/Module.php(966) : eval()'d code on line 2196PHP message: PHP Deprecated: Unparenthesized `a ? b : c ? d : e` is deprecated. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` in /home/jv74/public_html/classes/module/Module.php(966) : eval()'d code on line 2219', referer: https/index.php?controller=AdminModules&configure=dualpricedisplay&token=ce198036a69a035c871909399e1ec7da

I dont know yet. I have given the developer access and wait for some answers. The module is from 2016 and installed before we migrated to TB 1.0.

We show dual prices for the products, both ex and inc vat. The module we use has stopped working after update to Edge and there seems to be no solution. Is there any other modules that works with TB? If not, can I force the shop to show prices ex VAT?

Ok it explain the different numbers because we have a group of products that is not enabled Thanks

TB 1,4 (bleeding edge) We have a strange indexing problem The customer can search for all products without a problem but when I look for a product in the BO it does not find it When I build a new index in BO i get "The "indexed" products have been analyzed by thirty bees and will appear in the results of a front office search.Indexerad produkter 1096 / 1096." The real number of products is 1522 What can be wrong here.

Hi! We have this constantly in the apache error log. It does not seem to affect anything but I would like to know what it is about [Thu Jul 14 12:32:22.843114 2022] [proxy_fcgi:error] [pid 1733] [client 185.191.171.15:37366] AH01071: Got error 'PHP message: PHP Warning: Creating default object from empty value in /home/jv74/public_html/cache/smarty/compile/87/a4/f5/87a4f5b16ef3376726317ad2fb0f52169b9043ca_0.file.blockcart.tpl.php on line 256'

We upgraded to php 7.4 and missed that the curl packade was not installed

Solved. Missing php package

@datakickcan you tell me what is missconfigured? The message came from TB. And I have 2 shops that is copies and the otherone has no problem

@datakick Hi! Anyone understand what is wrong here Decoded exception Call to undefined function curl_init() in file modules/klarnaofficial/libraries/commonFeatures.php at line 205 Source file: modules/klarnaofficial/libraries/commonFeatures.php 186: $url = $this->getKlarnaUrl(Configuration::get('KCO_TESTMODE')).$endpoint; 187: $headers = $this->getKlarnaHeaders($version); 188: $ch = curl_init($url); 189: curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); 190: curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); 191: curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); 192: curl_setopt($ch, CURLOPT_USERPWD, $mid.':'.$sharedSecret); 193: curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 0); 194: curl_setopt($ch, CURLOPT_HEADER, 0); 195: curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); 196: $contents = curl_exec($ch); 197: curl_close ($ch); 198: return $contents; 199: } 200: 201: public function postToKlarna($data, $mid, $sharedSecret, $version, $endpoint, $patch = false) 202: { 203: $url = $this->getKlarnaUrl(Configuration::get('KCO_TESTMODE')).$endpoint; 204: $headers = $this->getKlarnaHeaders($version); 205: $ch = curl_init($url); 206: if (true === $patch) { 207: curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'PATCH'); 208: } else { 209: curl_setopt($ch, CURLOPT_POST, 1); 210: } 211: curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); 212: curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); 213: curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($data)); 214: curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); 215: curl_setopt($ch, CURLOPT_USERPWD, $mid.':'.$sharedSecret);

@datakick Hi! I tried to upload the module file in BO but get a 500 error I attach the txt file if you can decrypt it please exception_202271019222.txt