Skip to content

DROP conso_tmp Error : Exception: [MySQL] Error code : 42S02 (1051) #43

@ghost

Description

Bonjour,

J'ai une erreur avec le Plugin Suvi Conso, en effet celui-ci empêche la sauvegarde de jeedom à cause d'une table en erreur -> conso_tmp

J'ai tenté un reset de la BDD du plugin avec les outils fourni mais voici les messages d'erreurs 👍

0075|[2023-07-11 10:16:43]DEBUG : ===> Suppression des tables 0076|[2023-07-11 10:16:43]DEBUG : DROP conso_abo 0077|[2023-07-11 10:16:44]DEBUG : DROP conso_current 0078|[2023-07-11 10:16:44]DEBUG : DROP conso_current Error : Exception: [MySQL] Error code : 42S02 (1051). Unknown table 'jeedom.conso_current' : DROP TABLE conso_current; in /var/www/html/core/class/DB.class.php:102 Stack trace: #0 /var/www/html/plugins/conso/core/ajax/reset.ajax.php(119): DB::Prepare() #1 /var/www/html/plugins/conso/core/ajax/reset.ajax.php(46): resetDB() #2 {main} 0079|[2023-07-11 10:16:45]DEBUG : DROP conso_groupe 0080|[2023-07-11 10:16:46]DEBUG : DROP conso_jour 0081|[2023-07-11 10:16:47]DEBUG : DROP conso_periode 0082|[2023-07-11 10:16:48]DEBUG : DROP conso_periode_groupe 0083|[2023-07-11 10:16:49]DEBUG : DROP conso_price 0084|[2023-07-11 10:16:50]DEBUG : DROP conso_taxe 0085|[2023-07-11 10:16:51]DEBUG : DROP conso_teleinfo 0086|[2023-07-11 10:16:52]DEBUG : DROP conso_teleinfo_save 0087|[2023-07-11 10:16:52]DEBUG : DROP conso_teleinfo_save Error : Exception: [MySQL] Error code : 42S02 (1051). Unknown table 'jeedom.conso_teleinfo_save' : DROP TABLE conso_teleinfo_save; in /var/www/html/core/class/DB.class.php:102 Stack trace: #0 /var/www/html/plugins/conso/core/ajax/reset.ajax.php(199): DB::Prepare() #1 /var/www/html/plugins/conso/core/ajax/reset.ajax.php(46): resetDB() #2 {main} 0088|[2023-07-11 10:16:53]DEBUG : DROP conso_tmp **_0089|[2023-07-11 10:16:53]DEBUG : DROP conso_tmp Error : Exception: [MySQL] Error code : 42S02 (1051). Unknown table 'jeedom.conso_tmp' : DROP TABLE conso_tmp; in /var/www/html/core/class/DB.class.php:102 Stack trace: #0_** /var/www/html/plugins/conso/core/ajax/reset.ajax.php(209): DB::Prepare() #1 /var/www/html/plugins/conso/core/ajax/reset.ajax.php(46): resetDB() #2 {main} 0090|[2023-07-11 10:16:54]DEBUG : DROP conso_tva

J'ai contacté le support Jeedom qui m'a informé de vous contacter à ce propos.

Voici les logs d'erreurs lors de la sauvegarde jeedom :
0006|jeedom.conso_tmp 0007|Error : Table 'jeedom.conso_tmp' doesn't exist 0008|jeedom.conso_tmp 0009|Error : Table 'jeedom.conso_tmp' doesn't exist 0010|OK 0011|Backing up database... 0012|mysqldump: Got error: 1146: "Table 'jeedom.conso_tmp' doesn't exist" when using LOCK TABLES 0013|Error during backup: Backing up database failed. Check mysqldump installation. Code: 2Details : Array 0014|( 0015|) 0016|[END BACKUP ERROR] 0017|PHP Fatal error: Uncaught Exception: Backing up database failed. Check mysqldump installation. Code: 2 in /var/www/html/install/backup.php:104 0018|Stack trace: 0019|#0 {main} 0020|thrown in /var/www/html/install/backup.php on line 104

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions