Erruer Mysql aids !!!
abdego
Messages postés
249
Statut
Membre
-
arth Messages postés 10414 Statut Contributeur -
arth Messages postés 10414 Statut Contributeur -
Bonjour,
Bonjour les amis ,
bon voila mon erreur j'arrive pas localiser le problem s quoi ?? Merci de m'aider
Erreur
requête SQL:
_____________________________________________________
UPDATE vicidial_list INNER JOIN vicidial_lists ON vicidial_list.list_id = vicidial_lists.list_id SET vicidial_list.status = 'NEW',
vicidial_list. 'user' = '',
vicidial_list.called_since_last_reset = 'N',
vicidial_list.gender = '',
vicidial_list.called_count = '0',
vicidial_list.comments = '' WHERE vicidial_list.status = 'NA' OR vicidial_list.status = 'A' OR vicidial_list.status = 'DROP' OR vicidial_list.status = 'ERI' OR vicidial_list.status = 'N' OR vicidial_list.status = 'AL' OR vicidial_list.status = 'CALLBK' OR vicidial_list.status = 'AA' AND
vicidial_list.modify_date <=#21/08/2012 21:0:0#) AND ((vicidial_lists.list_id)="4017"));
________________________________________________________
MySQL a répondu:
#1064 - 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 ''user'='', vicidial_list.called_since_last_reset='N', vicidial_list.gender='', v' at line 1
===========
Merci encor Pour votre aide
Bonjour les amis ,
bon voila mon erreur j'arrive pas localiser le problem s quoi ?? Merci de m'aider
Erreur
requête SQL:
_____________________________________________________
UPDATE vicidial_list INNER JOIN vicidial_lists ON vicidial_list.list_id = vicidial_lists.list_id SET vicidial_list.status = 'NEW',
vicidial_list. 'user' = '',
vicidial_list.called_since_last_reset = 'N',
vicidial_list.gender = '',
vicidial_list.called_count = '0',
vicidial_list.comments = '' WHERE vicidial_list.status = 'NA' OR vicidial_list.status = 'A' OR vicidial_list.status = 'DROP' OR vicidial_list.status = 'ERI' OR vicidial_list.status = 'N' OR vicidial_list.status = 'AL' OR vicidial_list.status = 'CALLBK' OR vicidial_list.status = 'AA' AND
vicidial_list.modify_date <=#21/08/2012 21:0:0#) AND ((vicidial_lists.list_id)="4017"));
________________________________________________________
MySQL a répondu:
#1064 - 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 ''user'='', vicidial_list.called_since_last_reset='N', vicidial_list.gender='', v' at line 1
===========
Merci encor Pour votre aide
A voir également:
- Erruer Mysql aids !!!
- Mysql community download - Télécharger - Bases de données
- Could not connect to mysql! please check your database settings! - Forum Redhat
- Phpmyadmin a tenté de se connecter au serveur mysql, et le serveur a rejeté la connexion. merci de vérifier les valeurs de host, username et password dans la configuration et de s'assurer qu'elles correspondent aux informations fournies par l'administrateur du serveur mysql. ✓ - Forum PHP
- Mysql error in file: /engine/classes/mysql.php at line 53 ✓ - Forum Réseaux sociaux
- Xampp mysql ne démarre pas ✓ - Forum MySQL