Probleme De 7.1.1 À 7.2

7 posts in this topic

Posted · Report post

Bonjour, 

 

En regardant les choses a faire pour passer vers la 7.2, a première vue il n'y avais rien a faire a part écrasé les ancien fichier par les nouveaux sauf celui de config et ne pas mettre le dossier d'installation.

 

j'ai vu ceci donc:

- Si vous avez une version entre 7.0.4 et 7.1.4 : contactez-nous ou appliquez tout d'abord
http://forum.peel.fr...opping-vers-71/

et une fois sur cette page, ceci:

 

PREAMBULE :

- faites un backup complet du code de votre boutique
- téléchargez le zip
- dézippez le fichier et supprimez de nouveau dossier : "/lib/setup/info.inc.php" et "/installation/"
- mettez tous ces fichiers à la place de ceux de votre boutique


...


- Si vous avez une version 7.1.0 exécutez le SQL suivant dans phpMyAdmin pour passer en 7.1.1 ou 7.1.2 ou 7.1.3 (pas de SQL à exécuter entre 7.1.1, 7.1.2 et 7.1.3) :

 

Etant deja en 7.1.1 donc rien a faire si je comprend bien...

 

 

Apres avoir fait cela j'ai plus de problème que de chose visible. Voici un aperçu de ma page d'accueil:

 


Notice: 1054 - Unknown column 'c.site_id' in 'field list' - / - IP 91.178.136.140 - SELECT c.site_id, c.string FROM peel_configuration c LEFT JOIN peel_langues l ON l.etat = '1' AND l.url_rewriting LIKE '%.%' AND l.site_id IN (0,0) WHERE c.technical_code='wwwroot' AND (c.string='http://www.designnailart.eu' OR REPLACE(c.string,'www.','')='http://www.designnailart.eu' OR (l.url_rewriting LIKE '%.%' AND (REPLACE(c.string,'www.',l.url_rewriting)='http://www.designnailart.eu' OR l.url_rewriting='http://www.designnailart.eu'))) ORDER BY IF(c.technical_code='wwwroot',1,0) DESC, l.position ASC LIMIT 1 - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: 1054 - Unknown column 'peel_configuration.site_id' in 'where clause' - / - IP 91.178.136.140 - SELECT * FROM peel_configuration WHERE etat='1' AND peel_configuration.site_id IN (0,1) AND lang='' AND technical_code NOT LIKE 'STR_%' ORDER BY IF(site_id=0, 0, 1) ASC, IF(lang='', 0, 1) ASC, technical_code ASC - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: 1054 - Unknown column 'pd.site_id' in 'where clause' - / - IP 91.178.136.140 - SELECT pd.devise, pd.conversion, pd.symbole, pd.symbole_place, pd.code FROM peel_devises pd WHERE pd.id = '0' AND pd.site_id IN (0,1) - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: 1054 - Unknown column 'peel_langues.site_id' in 'where clause' - / - IP 91.178.136.140 - SELECT * FROM peel_langues WHERE (peel_langues.site_id IN (0,1)) ORDER BY IF(etat = '1', 1, 0) DESC, position ASC - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: Undefined index: lang_etat in /home/designna/www/lib/fonctions/fonctions.php on line 1949

Warning: array_keys() expects parameter 1 to be array, null given in /home/designna/www/lib/fonctions/fonctions.php on line 1949

Warning: array_unique() expects parameter 1 to be array, null given in /home/designna/www/lib/fonctions/fonctions.php on line 1955

Warning: array_unique() expects parameter 1 to be array, null given in /home/designna/www/lib/fonctions/fonctions.php on line 1956

Warning: Invalid argument supplied for foreach() in /home/designna/www/lib/fonctions/fonctions.php on line 1961

Warning: Invalid argument supplied for foreach() in /home/designna/www/lib/fonctions/fonctions.php on line 2004

Warning: Invalid argument supplied for foreach() in /home/designna/www/lib/fonctions/fonctions.php on line 1399

Warning: in_array() expects parameter 2 to be array, null given in /home/designna/www/lib/fonctions/fonctions.php on line 1439

Warning: Invalid argument supplied for foreach() in /home/designna/www/lib/fonctions/fonctions.php on line 1442

Warning: current() expects parameter 1 to be array, null given in /home/designna/www/lib/fonctions/fonctions.php on line 1448

Notice: SQL error 1054 - Unknown column 'peel_configuration.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_configuration WHERE etat='1' AND peel_configuration.site_id IN (0,1) AND (lang = 'en' OR lang='') ORDER BY IF(site_id=0, 0, 1) ASC, IF(lang='', 0, 1) ASC, technical_code ASC - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'c.site_id' in 'field list' - Page: / - IP 91.178.136.140 - SELECT c.site_id, c.string FROM peel_configuration c LEFT JOIN peel_langues l ON l.etat = '1' AND l.url_rewriting LIKE '%.%' AND l.site_id IN (0,1) WHERE c.technical_code='wwwroot' AND (c.string='http://www.designnailart.eu' OR REPLACE(c.string,'www.','')='http://www.designnailart.eu' OR (l.url_rewriting LIKE '%.%' AND (REPLACE(c.string,'www.',l.url_rewriting)='http://www.designnailart.eu' OR l.url_rewriting='http://www.designnailart.eu'))) ORDER BY IF(c.technical_code='wwwroot',1,0) DESC, l.position ASC LIMIT 1 - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'peel_configuration.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_configuration WHERE etat='1' AND peel_configuration.site_id IN (0,1) AND lang='' AND technical_code NOT LIKE 'STR_%' ORDER BY IF(site_id=0, 0, 1) ASC, IF(lang='', 0, 1) ASC, technical_code ASC - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Warning: in_array() expects parameter 2 to be array, null given in /home/designna/www/lib/fonctions/fonctions.php on line 1439

Warning: Invalid argument supplied for foreach() in /home/designna/www/lib/fonctions/fonctions.php on line 1442

Warning: current() expects parameter 1 to be array, null given in /home/designna/www/lib/fonctions/fonctions.php on line 1448

Notice: Undefined index: lang_names in /home/designna/www/lib/templateEngines/SmartyEngine.php on line 94

Notice: SQL error 1054 - Unknown column 'c.nom_' in 'field list' - Page: / - IP 91.178.136.140 - SELECT c.id, c.nom_ AS categorie, c.image_ AS image FROM peel_categories c WHERE c.etat = "1" AND c.on_special = "1" AND c.nom_!="" AND c.site_id IN (0,1) ORDER BY c.position - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'c.nom_' in 'field list' - Page: / - IP 91.178.136.140 - SELECT SQL_CALC_FOUND_ROWS p.*, c.id AS categorie_id, c.nom_ AS categorie FROM peel_produits p INNER JOIN peel_produits_categories pc ON pc.produit_id = p.id INNER JOIN peel_categories c ON pc.categorie_id = c.id AND c.etat=1 AND c.site_id IN (0,1) WHERE p.etat = "1" AND p.site_id IN (0,1) AND p.nom_ != "" AND (p.on_top='1') GROUP BY p.id ORDER BY `position` ASC LIMIT 0, 12 - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: Undefined index: lang_names in /home/designna/www/lib/templateEngines/SmartyEngine.php on line 94

Notice: SQL error 1054 - Unknown column 'c.nom_' in 'field list' - Page: / - IP 91.178.136.140 - SELECT SQL_CALC_FOUND_ROWS p.*, c.id AS categorie_id, c.nom_ AS categorie FROM peel_produits p INNER JOIN peel_produits_categories pc ON pc.produit_id = p.id INNER JOIN peel_categories c ON pc.categorie_id = c.id AND c.etat=1 AND c.site_id IN (0,1) WHERE p.etat = "1" AND p.site_id IN (0,1) AND p.nom_ != "" AND (p.on_special='1') GROUP BY p.id ORDER BY `position` ASC LIMIT 0, 12 - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: Undefined index: lang_names in /home/designna/www/lib/templateEngines/SmartyEngine.php on line 94

Notice: SQL error 1054 - Unknown column 'c.nom_' in 'field list' - Page: / - IP 91.178.136.140 - SELECT SQL_CALC_FOUND_ROWS p.*, c.id AS categorie_id, c.nom_ AS categorie FROM peel_produits p INNER JOIN peel_produits_categories pc ON pc.produit_id = p.id INNER JOIN peel_categories c ON pc.categorie_id = c.id AND c.etat=1 AND c.site_id IN (0,1) WHERE p.etat = "1" AND p.site_id IN (0,1) AND p.nom_ != "" AND (p.on_new='1') GROUP BY p.id ORDER BY `position` ASC LIMIT 0, 12 - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: Undefined index: lang_names in /home/designna/www/lib/templateEngines/SmartyEngine.php on line 94

Notice: SQL error 1054 - Unknown column 'p.on_reseller' in 'field list' - Page: / - IP 91.178.136.140 - SELECT p.id, p.on_reseller, p.surtitre_, p.titre_, p.chapo_, p.texte_, p.image1, p.on_special, p.date_maj FROM peel_articles p WHERE p.on_special = "1" AND p.etat = "1" AND p.site_id IN (0,1) ORDER BY p.date_maj DESC LIMIT 0,1 - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'peel_html.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_html WHERE etat="1" AND peel_html.site_id IN (0,1) AND (lang="" OR lang="") AND emplacement="home" ORDER BY LENGTH(emplacement) DESC, a_timestamp DESC - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'peel_html.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_html WHERE etat="1" AND peel_html.site_id IN (0,1) AND (lang="" OR lang="") AND emplacement="home_bottom" ORDER BY LENGTH(emplacement) DESC, a_timestamp DESC - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'peel_modules.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_modules WHERE peel_modules.site_id IN (0,1) AND (1 AND location="center_middle_home") AND etat="1" ORDER BY position, id - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: Undefined index: site_index_page_columns_count in /home/designna/www/index.php on line 78

Warning: Cannot modify header information - headers already sent by (output started at /home/designna/www/lib/fonctions/database.php:239) in /home/designna/www/lib/fonctions/fonctions.php on line 1316

Notice: Undefined index: lang_names in /home/designna/www/lib/templateEngines/SmartyEngine.php on line 94

Notice: Undefined index: lang_names in /home/designna/www/lib/templateEngines/SmartyEngine.php on line 94

Notice: SQL error 1054 - Unknown column 'peel_modules.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_modules WHERE peel_modules.site_id IN (0,1) AND (1 AND location="header") AND etat="1" ORDER BY position, id - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'peel_html.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_html WHERE etat="1" AND peel_html.site_id IN (0,1) AND (lang="" OR lang="") AND emplacement="header" ORDER BY LENGTH(emplacement) DESC, a_timestamp DESC - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'peel_html.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_html WHERE etat="1" AND peel_html.site_id IN (0,1) AND (lang="" OR lang="") AND emplacement="scrolling" ORDER BY LENGTH(emplacement) DESC, a_timestamp DESC - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'peel_modules.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_modules WHERE peel_modules.site_id IN (0,1) AND (1 AND location="above_middle") AND etat="1" ORDER BY position, id - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'peel_modules.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_modules WHERE peel_modules.site_id IN (0,1) AND (1 AND location="top_middle") AND etat="1" ORDER BY position, id - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: Undefined index: lang_names in /home/designna/www/lib/templateEngines/SmartyEngine.php on line 94

Notice: Undefined index: lang_names in /home/designna/www/lib/templateEngines/SmartyEngine.php on line 94

Notice: SQL error 1054 - Unknown column 'peel_meta.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_meta WHERE technical_code="http://www.designnailart.eu/" OR technical_code="/" AND peel_meta.site_id IN (0,1) - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'peel_meta.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_meta WHERE technical_code="index" AND peel_meta.site_id IN (0,1) - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'peel_meta.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_meta WHERE "http://www.designnailart.eu/" LIKE CONCAT(technical_code, "%") OR "/" LIKE CONCAT(technical_code, "%") AND peel_meta.site_id IN (0,1) ORDER BY LENGTH(technical_code) DESC LIMIT 1 - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: Undefined index: lang_names in /home/designna/www/lib/templateEngines/SmartyEngine.php on line 94
administrateur@designnailart.be 

Notice: Undefined index: lang_names in /home/designna/www/lib/templateEngines/SmartyEngine.php on line 94

Notice: SQL error 1054 - Unknown column 'peel_modules.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_modules WHERE peel_modules.site_id IN (0,1) AND (1 AND location="bottom_middle") AND etat="1" ORDER BY position, id - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'peel_modules.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_modules WHERE peel_modules.site_id IN (0,1) AND (1 AND location="below_middle") AND etat="1" ORDER BY position, id - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'peel_html.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_html WHERE etat="1" AND peel_html.site_id IN (0,1) AND (lang="" OR lang="") AND emplacement="home_bottom" ORDER BY LENGTH(emplacement) DESC, a_timestamp DESC - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'peel_html.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_html WHERE etat="1" AND peel_html.site_id IN (0,1) AND (lang="" OR lang="") AND emplacement="footer" ORDER BY LENGTH(emplacement) DESC, a_timestamp DESC - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: SQL error 1054 - Unknown column 'peel_modules.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_modules WHERE peel_modules.site_id IN (0,1) AND (1 AND location="footer") AND etat="1" ORDER BY position, id - Error number in /home/designna/www/lib/fonctions/database.php on line 239

Notice: Undefined index: lang_names in /home/designna/www/lib/templateEngines/SmartyEngine.php on line 94

Notice: Undefined index: lang_names in /home/designna/www/lib/templateEngines/SmartyEngine.php on line 94

Notice: Undefined index: lang_names in /home/designna/www/lib/templateEngines/SmartyEngine.php on line 94

Notice: Undefined index: lang_names in /home/designna/www/lib/templateEngines/SmartyEngine.php on line 94

Notice: SQL error 1054 - Unknown column 'peel_html.site_id' in 'where clause' - Page: / - IP 91.178.136.140 - SELECT * FROM peel_html WHERE etat="1" AND peel_html.site_id IN (0,1) AND (lang="" OR lang="") AND emplacement="footer_link" ORDER BY LENGTH(emplacement) DESC, a_timestamp DESC - Error number in /home/designna/www/lib/fonctions/database.php on line 239
 
Legal information
Terms and conditions
Created by PEEL creating eCommerce Site

Je vais donc remettre ma sauvegarde dans l'attente de savoir comment passé sans soucis de la 7.1.1 vers la 7.2.

Merci

1 person likes this

Share this post


: post
Share on other sites

Posted · Report post

Bonjour,

 

Avez-vous vu la partie "Si vous avez une version 7.1.4 exécutez le SQL suivant dans phpMyAdmin pour passer en 7.2.0 :" sur le sujet

Share this post


: post
Share on other sites

Posted · Report post

Bonjour, Oui mais j'ai pas la version 7.1.4 mais 7.1.1...

 

Je sais pas si c'est la même choses entre 7.1.1, 7.1.2, 7.1.3 et 7.1.4...

 

 

Je doit doit appliquer les choses comme si j'etait en 7.1.4 alors que je suis en 7.1.1?

 

le model graphique reste valable également?

 

 

Merci

Share this post


: post
Share on other sites

Posted · Report post

Bonjour,

 

Je doit doit appliquer les choses comme si j'etait en 7.1.4 alors que je suis en 7.1.1?

 

oui vous pouvez appliquer le SQL sur votre 7.1.1. Le SQL s'est-il exécuté jusqu'au bout ? Pour information il y a certaines lignes qui concerne des modules que vous n'avez peut-être pas sur votre installation. Si vous avez fait un copier/coller de l'intégralité du SQL il est possible qu'une erreur se soit produite, et empêcher l’exécution de la suite du script.

Je vous laisse lire les commentaires dans le script et supprimer les lignes SQL qui ne concerne pas votre cas.

Share this post


: post
Share on other sites

Posted · Report post

Bonjour,,

 

J'ai malheureusement pas eu le temps de faire cela mais je reviens vers vous dés que c'est fait ;)

Share this post


: post
Share on other sites

Posted · Report post

Effectivement avec les SQL de mis pas de soucis...

 

par contre lors de l'inscription d'un client il met "Vous n'avez pas précisé votre société." alors que c'est pas obligatoire...

 

une fois tous les champ rempli ca ne fonctionne toujours pas, message d'erreur mais pas de detail d'erreur meme avec tous les champs rempli.

 

Je vais voir si je trouve quelque chose sur le forum sur le probleme.

Share this post


: post
Share on other sites

Posted · Report post

Sujet ouvert pour le problème d'inscription :

Share this post


: post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

Twitter Advisto ecommerce

Facebook PEEL Shopping