kevin78

Nettoyer le cache et cookies des navigateurs (pour ceux qui sont dans cette galère même si ça date de 3 ans, c'est toujours d'actualité !)

Same problem... any solution today ?

Hello i have the same issue. I think some rules should be included in the htaccess in order to make the good rewritting, but im not sure. Did you solve it in your side please ?

Thnks again. I made this modification only : $query = "LOAD DATA INFILE '".$tablefile."' INTO TABLE "._DB_PREFIX_.$table." CHARACTER SET 'utf8'"; And everything looks like to be ok. Im on multishop. And it is working also, just need to make some settings and everything look like to be ok. Now, i have a "new" 1.5.6.3 without any module, without any template, but with all datas. I will upgrade to 1.6.1.1 tomorrow. Edit : upgrade to 1.6.1.1 perfectly without any problem, and solve some bug i had with the last 1.5.6.3 i will continue my test this week, and go to production next week

Sorry to disturb you... but where should i put these codes ? In your copy_shopdata.php file ? For example, in the line 311 : $query = "LOAD DATA INFILE '".$tablefile."' INTO TABLE "._DB_PREFIX_.$table.""; Or line 347 : $query = "LOAD DATA INFILE '".$tablefile."' INTO TABLE "._DB_PREFIX_.$table."";

Hello Musicmaster, In order to upgrade my shop 1.5.6.3. to the 1.6.1.1 with a "cleaning" step, i am testing your script today, in this way below : 1- i will create a new shop 1.5.6.3. and erase all data (with the native prestashop module "cleaner") 2- i will start the the copy_shopdata.php, without any modules, any themplates. 3- i will have a copy of my 1.5.6.3. - new, without modules, etc. 4- i will upgrade with 1-click Upgrade to 1.6.1.1 5- i will add the new templates and modules But right now, im at the step 2. I have this error : MySQL error 1: Can't create/write to file '/var/www/my-admin/triple/copy_shopdata_address.dtx' (Errcode: 13) I think it is a permission error. Could you tell me which user is used for creating the dtx files please ? Edit : i change the persmissions to 777 (with 775 it was still not enough). It is working. All datas have been correctly transfered but i have one problem : special character has not been applied. Like : é - è - à

PHP 7 apportera-il de grosses améliorations ? Je suis en train de faire un update de tout mon serveur, et cela risque de prendre du temps. Donc je préfère être sûr des versions à installer pour le long terme. Aujourd'hui je suis encore sur du apache 2.2, PHP 4.3 Debian 6 ...

Salut tout le monde qui a déjà testé le php 5.6 avec la dernière version prestashop ? Est-ce bien compatible ?

Ah yes; now i understand It is usefull when the 1-click upgrade doesnt work. I will try a 1-click upgrade. But my original question was to start a new shop v1.6.1.1 and put the tables data from the 1.5.6.3 I think, i will proceed like this : - upgrade my 1.5.6.3 to 1.6.1.1 : i hope it will be OK. If not, i hope it will at least modify correctly the database, in order to export the most important tables (like in your script). - install the new 1.6.1.1 : i clean it. And i import the exported tables before. I think that is like your script, right ?

I checked your script. But i dont really understand what does it bring exactly. On your script, you ask to upgrade the old shop with the PS Autoupgrade. If we use this "normal" upgrade solution, it should upgraded my old shop (1.5.6.3) to the latest version (1.6.1.1). With all my datas. So what your script will do more than the PS Autoupgrade ? I have checked all SQL modification from 1.5.6.3 to the 1.6.1.1 And here some modifications which is affected the important data which i need (like tables orders, users, products, categories) : Most modifications start in 1.6.0.1 and 1.6.0.10 - 1.6.1.x : CREATE TABLE IF NOT EXISTS `PREFIX_order_slip_detail_tax` ALTER TABLE `PREFIX_tax_rules_group` UPDATE `PREFIX_tax_rules_group` ALTER TABLE `PREFIX_order_detail` UPDATE `PREFIX_category` SET `is_root_category` ALTER TABLE `PREFIX_orders` etc.

Table ps_orders look like to be the same. Isn't it ? Other way which could be a solution : - upgrade my 1.5.3 to 1.6.1, then extract only data tables (customers, orders, categories, products, etc.) - make a new installation and import these tables

No, my goal is to not use the 1-click upgrade module. I have too much old modules since prestashop 1.2 And after many upgrades since 1.2, some tables are still existing. And some errors still persists. I want to clean all the databases in order to start with a clean shop.

Hi Music, thanks a lot. You script is working between different prestashop version as well ? I mean, can i use it for exporting date from 1.5.3.1 to 1.6.1.0 ?

Il y a l'import par CSV. Mais le SQL Manager : qu'apporte t il exactement ? J'utilise directement la page d'admin PHP SQL.

Je ne savais pas qu'il y avait un outil d'import sur PS. Je pense faire une install toute neuve, vierge, puis import tables par tables. Travail dantesque puisque j'ai plus de 10k produits et 50k d'utilisateurs. Je ferai une copie en ligne, puis si tout va bien, je ferai tout ça en ligne.