Jump to content

Impossible de modifier un prix de produit

chti56
 Share

Recommended Posts

chti56 Collaborator

chti56

Posted
Posted (edited)

Bonjour,

 

Sur ma boutique avec PS 1.6.0.8 je voudrais créer un prix spécifique pour un produit.

Quand j'essaye de le faire une page blanche s'affiche avec le message ERROR en haut à gauche. J'ai utilisé le mode Debug et j'ai le même comportement mais pas plus d'informations sur cette erreur... Où serait-il possible d'avoir des informations sur cette erreur.

 

En fouillant dans les logs j'ai trouvé deux logs à deux dates différentes que voici:

 

*ERROR* 2015/05/16 - 16:40:05: Invalid address at line 362 in file classes/Address.php

 

*ERROR* 2015/05/21 - 13:53:08: Module powatag not found at line 49 in file classes/controller/ModuleAdminController.php
 
et...
 
*ERROR* 2015/03/11 - 10:17:58: Unknown column 'id_shop_group' in 'field list'<br /><br /><pre>SELECT GROUP_CONCAT(id_shop_group) as groupid FROM ps_sendin_newsletter  WHERE email = "[email protected]" GROUP BY email LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/11 - 10:18:48: Unknown column 'id_shop_group' in 'field list'<br /><br /><pre>SELECT GROUP_CONCAT(id_shop_group) as groupid FROM ps_sendin_newsletter  WHERE email = "[email protected]" GROUP BY email LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/11 - 10:18:56: Unknown column 'id_shop_group' in 'field list'<br /><br /><pre>SELECT GROUP_CONCAT(id_shop_group) as groupid FROM ps_sendin_newsletter  WHERE email = "[email protected]" GROUP BY email LIMIT 1</pre> at line 635 in file classes/db/Db.php
 
 
 
Mais rien en date d’aujourd’hui..
 
Quelque'un peut m'aider ??
 
Merci d'avance.
 
JP
Edited by chti56 (see edit history)
Link to comment
Share on other sites
chti56 Collaborator

chti56

Posted
  • Author
Posted (edited)

Je découvre d'autres erreurs antérieures comme ceci:

 

*ERROR* 2015/03/06 - 07:49:38: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 07:19:00'

AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 07:19:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 09:26:01: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 08:56:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 08:56:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 09:26:04: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 08:56:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 08:56:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 09:59:02: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 09:29:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 09:29:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 10:58:37: Unknown column 'id_shop_group' in 'field list'<br /><br /><pre>SELECT GROUP_CONCAT(id_shop_group) as groupid FROM ps_sendin_newsletter  WHERE email = "[email protected]" GROUP BY email LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 11:54:12: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 11:24:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 11:24:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 12:13:14: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 11:43:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 11:43:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 12:13:17: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 11:43:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 11:43:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 12:13:20: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 11:43:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 11:43:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 12:13:23: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 11:43:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 11:43:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 12:13:26: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 11:43:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 11:43:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 12:13:29: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 11:43:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 11:43:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 12:13:32: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 11:43:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 11:43:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 13:08:19: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 12:38:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 12:38:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 13:08:23: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 12:38:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 12:38:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 13:08:26: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 12:38:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 12:38:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 13:08:29: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 12:38:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 12:38:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 14:00:08: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 13:30:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 13:30:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 15:45:57: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 15:15:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 15:15:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 15:46:00: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 15:16:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 15:16:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 15:46:03: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 15:16:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 15:16:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 17:20:12: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 16:50:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 16:50:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 17:20:16: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 16:50:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 16:50:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 17:20:20: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 16:50:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 16:50:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 17:20:23: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 16:50:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 16:50:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 17:29:21: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 16:59:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 16:59:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 17:29:24: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 16:59:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 16:59:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 17:29:28: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 16:59:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 16:59:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
*ERROR* 2015/03/06 - 17:29:31: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `date_add` > '2015-03-06 16:59:00'
AND id_shop IN (1) 
ORDER BY ' at line 3<br /><br /><pre>SELECT `id_connections` FROM `ps_connections`
WHERE ip_address = 
AND `date_add` > '2015-03-06 16:59:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1</pre> at line 635 in file classes/db/Db.php
 
 
ou ceci...
 
*ERROR* 2015/03/05 - 23:27:30: Unknown column 'id_shop_group' in 'field list'<br /><br /><pre>SELECT GROUP_CONCAT(id_shop_group) as groupid FROM ps_sendin_newsletter  WHERE email = "[email protected]" GROUP BY email LIMIT 1</pre> at line 635 in file classes/db/Db.php
 
 
Quelqu'un a une idée sur la possibilité de réparer ces erreurs ?
 
GRAND MERCI...

 

Edited by chti56 (see edit history)
Link to comment
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
 Share
Go to topic listing
×
×
  • Create New...