PC33 Posted June 25, 2013 Share Posted June 25, 2013 I think i posted this problem on the wrong section of the forum so here it cames: Hello everyone, recently on my prestashop 1.4.9.0 i had to install Backward Compability because paypal module stoped working and after that i figure it right after thar some things on backoffice stoped working currectly. I made some search on my store and seems that something somehow mixed with the mysql DB and now for example, i cannot see modules positions, live edit also cannot see, also i cannot transplant any module, but the worst one is that after that the default referral prestashop system stoped working correctly aswell. Customers that came from referral sites are not tracked and i cannot pay my affiliates because nothing is working. Since this problem happend with a module provided by prestashop, can anyone from prestashop support help me debugging the problems i have? It will be hard for me install a new shop and migrate customers and template and orders and all the important part because im affraid to lose something. Kind Regards to all and hope someone can really help me on this! Link to comment Share on other sites More sharing options...
benjamin utterback Posted June 25, 2013 Share Posted June 25, 2013 Hi PC33, thank you for the message and welcome to the forum! First, I want to make sure that you read the rules and advices found here, http://www.prestashop.com/forums/topic/256751-read-first-forum-rules-and-best-practices/ This topic title really does not give much information, which leads to people skipping over it. Even during issues like this, you wouldn't need to create a whole new store. Could you use your backup database and files to get it back to when the only issue was the your PayPal transactions? Link to comment Share on other sites More sharing options...
Dh42 Posted June 25, 2013 Share Posted June 25, 2013 What 3rd party modules are you running on your shop? You might try to uninstall backward compatibility and roll back to the the version of paypal that came with prestashop version 1.4.8.3. That would be the first thing I tried. Link to comment Share on other sites More sharing options...
PC33 Posted June 25, 2013 Author Share Posted June 25, 2013 Dh42 i did that, no success, and Benjamin Utterback sorry for the wrong part and no i dont have backups from that part. If at least i could find a way to backup customers, orders and products i would start a store from scratch and upload back only that part and the template, i think that would fix my problem. The thing is i really cant find a good way to backup exacly what i need, all customers informations, all orders informations and products, all the rest i can manage myselft i think. Kind Regards. Link to comment Share on other sites More sharing options...
Dh42 Posted June 25, 2013 Share Posted June 25, 2013 So you have no change when you uninstalled the backward compatibility module? Link to comment Share on other sites More sharing options...
PC33 Posted June 25, 2013 Author Share Posted June 25, 2013 No, all stay the same ( with the current problem ) i think that backward compability somehow changed mysql but i really cant debug it, is there anyway to see backoffice errors with some debugging mode or something maybe it can help us better. But i think evan that wont fix Prestasho referral system problem that i have now. Best Regards. Link to comment Share on other sites More sharing options...
Dh42 Posted June 25, 2013 Share Posted June 25, 2013 You can turn error reporting on, also there should be an error log in your admin folder that you can ftp and see. Link to comment Share on other sites More sharing options...
benjamin utterback Posted June 25, 2013 Share Posted June 25, 2013 If the database is throwing errors, then it's not recommended that you use that to backup, since it's not working. Remember to make sure you have a backup of your database and PrestaShop folders before you install additional modules/themes or change server/configuration settings. It will make things a lot easier for everybody, most importantly you! Also, follow what Dh42 suggested and get the Error logs from your hosting provider. Also, turn on errors in your backoffice ftp under config/config.inc.php - around line 29 look for "display errors" and make sure it says "on instead of "off" Link to comment Share on other sites More sharing options...
PC33 Posted June 25, 2013 Author Share Posted June 25, 2013 Ok so i turned errors on and this is what i got and now we know its backward compability fault Warning : require(/home/gamekeys/public_html/modules/themeinstallator/backward_compatibility/backward.php) [ function.require ]: failed to open stream: No such file or directory in /home/gamekeys/public_html/modules/themeinstallator/themeinstallator.php on line 94 Fatal error : require() [ function.require ]: Failed opening required '/home/gamekeys/public_html/modules/themeinstallator/backward_compatibility/backward.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/gamekeys/public_html/modules/themeinstallator/themeinstallator.php on line 94 Can anyone help on this? Best regards. Link to comment Share on other sites More sharing options...
Dh42 Posted June 25, 2013 Share Posted June 25, 2013 Do you have the theme installation module installed on your site? Link to comment Share on other sites More sharing options...
PC33 Posted June 25, 2013 Author Share Posted June 25, 2013 yes, i already check that also themeinstallator.php is there. Im a bit lost but i want to thank you all of you that are trying to help me on this matter Best Regards. Link to comment Share on other sites More sharing options...
Dh42 Posted June 25, 2013 Share Posted June 25, 2013 Roll back the theme installer to the version that comes with 1.4.8.3 also. that should clear up the problem. Link to comment Share on other sites More sharing options...
PC33 Posted June 25, 2013 Author Share Posted June 25, 2013 Hello again Theme problem is now fixed, i just replaced the old ones from the 1.4.9.0 version and now its fully working. Now the big problem which i really cant figure and i already told here aslo is the Referral system, before backward compability it was working all ok after that it stop tracking clicks, registrations and fees, so i dont know what do i have to pay to my affiliates Note: no errors on backoffice for this one, all seem to be working except the tracking for clicks, registrations etc. Best Regards. Link to comment Share on other sites More sharing options...
benjamin utterback Posted June 25, 2013 Share Posted June 25, 2013 Cool, that is good to hear. Which module are you using? Maybe if you reinstall or reconfigure it will start working again. Link to comment Share on other sites More sharing options...
Dh42 Posted June 25, 2013 Share Posted June 25, 2013 Try re-installing the module and see if it helps. Also clear your caches both the site and the computer you are on and see if that makes a difference. Link to comment Share on other sites More sharing options...
PC33 Posted June 25, 2013 Author Share Posted June 25, 2013 (edited) Well my friends thats the problem, if it was a module i should fixed like that i think. The thing is that this is the Default Prestashop referral system under Stats - Referrers on backpanel, its verry simple and works like a charm, maybe if someone could tell me which tables i should replace on mysql i could install the default ones, not sure if that fix the problem... Best Regards. Edited June 25, 2013 by PC33 (see edit history) Link to comment Share on other sites More sharing options...
Dh42 Posted June 25, 2013 Share Posted June 25, 2013 I don't know what you are asking for. Link to comment Share on other sites More sharing options...
PC33 Posted June 25, 2013 Author Share Posted June 25, 2013 Maybe this image help. http://postimg.org/image/b0t2w3nht/ Thats the referral default system for prestashop, sudenly stops tracking clicks and all the rest, the visits you see there are nothing compared with the ones i have from the affiliate site. Also if that helps, when i had to install backward compability i also had to update Paypal module and on orders page i cant no longer see the paypal transaction which before that i was able to see and also i was able to see where the customer came from to make his purchase. Link to comment Share on other sites More sharing options...
benjamin utterback Posted June 25, 2013 Share Posted June 25, 2013 I think he is saying that he can't reinstall the module because the Stats>referrers is not under the Modules tab. First, try and reset and refresh and cache. Link to comment Share on other sites More sharing options...
PC33 Posted June 25, 2013 Author Share Posted June 25, 2013 Already made that also like 100+ times, i have a backup of the full db before this problems but i dont want to full restore it because i will lose orders and customers accounts. Maybe only restoring this tables and make a new installation on Paypal Module i dont know if that could work. Link to comment Share on other sites More sharing options...
PC33 Posted June 26, 2013 Author Share Posted June 26, 2013 Any more ideas guys?? Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts