Support Wanewsletter

SQL query :
UPDATE wa_abo_liste
SET send = 1
WHERE abo_id IN(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, ...................................................
 1920, 1921, 1922, 1923, 1924, 1925, 1926, 1927, 1928, 1929, 1930, 1931, 1932, 1933, 1934, 1935, 1936, 1937, 1938, 1939, 1940, 1941, 1942)
AND liste_id = 3

SQL errno : 2006
SQL error : MySQL server has gone away

Fichier : engine_send.php Ligne : 633

UPDATE wa_abo_liste
SET send = 1
WHERE liste_id = 3

MySQL n'a retourné aucun enregistrement. (traitement: 0.0005 sec.)
requête SQL: SELECT *
FROM `wa_joined_files` 

Textes complets
VERSION()
4.0.25-standard-log

MySQL - 4.0.25-standard-log

    * Version du protocole: 10
    * Serveur: sql8 via TCP/IP
    * Utilisateur: toto@1.1.1.1
    * Créer une base de données: Documentation
      aucun privilège
    * Quitter 

phpMyAdmin - OVH

    * Version du client MySQL: 5.0.18
    * Extensions PHP utilisées: mysql
    *
      Language Info:
    *
      Thème / Style:
    * Documentation de phpMyAdmin
    * Site officiel de phpMyAdmin 

Erreur

requête SQL: Documentation

SELECT COUNT( a.abo_id ) AS num_subscribe
FROM wa_abonnes AS a
WHERE a.abo_id
IN (

SELECT al.abo_id
FROM wa_abo_liste AS al
WHERE al.liste_id
IN ( 2, 4 )
AND al.confirmed =1
)
AND a.abo_status =1

MySQL a répondu:Documentation
#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 'SELECT al.abo_id
   FROM wa_abo_liste AS al
   WHERE al.liste 

SELECT liste_id, abo_id
FROM wa_abo_liste
WHERE liste_id IN ( 2, 4 ) 
                                         liste_id   abo_id

    Modifier     Effacer     2     1
    Modifier     Effacer     4     1
    Modifier     Effacer     2     2
    Modifier     Effacer     4     460
    Modifier     Effacer     4     1603

Erreur

requête SQL: Documentation

SELECT COUNT( abo_id ) AS num_abo, abo_status
FROM wa_abonnes
WHERE abo_id IN (
SELECT abo_id FROM wa_abo_liste
WHERE liste_id IN ( 2, 4 )
)
GROUP BY abo_status

MySQL a répondu:Documentation
#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 'SELECT abo_id  FROM wa_abo_liste  WHERE liste_id  IN ( 2 , 4 ) 

SELECT abo.abo_status, count( DISTINCT abo.abo_id ) AS nb_abo
FROM wa_abonnes abo, wa_abo_liste lis
WHERE abo.abo_id = lis.abo_id
AND lis.liste_id
IN ( 2, 4 )
GROUP BY abo.abo_status

 abo_status       nb_abo
     1                      4

    $sql = "SELECT COUNT(abo_id) AS num_abo, abo_status
        FROM " . ABONNES_TABLE . "
        WHERE abo_id IN($sql_abo_ids)
        GROUP BY abo_status";

    /* Modification SQL Pierre Roger  06/10/2006
    **    Suppression du sous-select avec $sql_abo_ids
        **    Remplacement par une jointure
    **    entre wa_abonnes et wa_abo_liste
    **$sql = "SELECT COUNT(abo_id) AS num_abo, abo_status
        **FROM " . ABONNES_TABLE . "
        **WHERE abo_id IN($sql_abo_ids)
        **GROUP BY abo_status";
    */
    $sql = "SELECT COUNT(abo_id) AS num_abo, abo_status
        FROM " . ABONNES_TABLE . " abo, " . ABO_LISTE_TABLE . " lis
        WHERE abo.abo_id = lis.abo_id
        AND    lis.liste_id IN($sql_liste_ids).
        GROUP BY abo_status";