Project

General

Profile

Bug #8461

Fatal error in TICKET plugin

Added by Andre Boivin almost 3 years ago. Updated over 2 years ago.

Status:
Needs testing
Priority:
Normal
Assignee:
-
Category:
Plugins
Target version:
Start date:
12/10/2016
Due date:
% Done:

80%

Estimated time:
Complexity:
Normal
SCRUM pts - complexity:
?

Description

Si on demande une confirmation, on obtient ce message d'erreur:
Unknown column 'ticket_id' in 'where clause

Associated revisions

Revision 92816c36 (diff)
Added by jmontoyaa almost 3 years ago

Fix replace id with ticket_id see #8461

History

#1

Updated by Yannick Warnier almost 3 years ago

  • Status changed from New to Needs more info
  • Assignee set to Andre Boivin

Dans une version 1.10 ou 1.11? (je pose la question parce que Julio a fait beaucoup de corrections pour la 1.11)

#2

Updated by Julio Montoya almost 3 years ago

mmm mais il est ou le fatal error? :) (le message de PHP avec le nom de fichier et la ligne)

#3

Updated by Andre Boivin almost 3 years ago

  • Assignee changed from Andre Boivin to Julio Montoya

Sur la version 1.11x du 9 oct
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ticket_id' in 'where clause'' in D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:104 Stack trace: #0 D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php(104): PDO->query('UPDATE ticket_t...') #1 D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(833): Doctrine\DBAL\Driver\PDOConnection->query('UPDATE ticket_t...') #2 D:\usbw\root\chamilo1.11\main\inc\lib\database.lib.php(360): Doctrine\DBAL\Connection->executeQuery('UPDATE ticket_t...') #3 D:\usbw\root\chamilo1.11\main\inc\lib\TicketManager.php(680): Database::query('UPDATE ticket_t...') #4 D:\usbw\root\chamilo1.11\main\ticket\ticket_details.php(421): TicketManager::insert_message('1', 'Re:: blabla', '<p>gfghf</p>??', Array, 1, 'NOL', true) #5 {main} Next exception 'Doctrine\DBAL\Driver\PDOException' with message 'SQLSTATE[42S22]: Column not found: 105 in D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php on line 71

#4

Updated by Julio Montoya almost 3 years ago

  • Assignee deleted (Julio Montoya)
#5

Updated by Yannick Warnier almost 3 years ago

André, à partir de maintenant, ce serait plus simple à gérer pour nous si tu pouvais enregistrer les nouveaux rapports d'erreur sur https://github.com/chamilo/chamilo-lms/issues/
Nous avons annoncé sur la liste de développement, il y a environ 2 mois, que nous passerions progressivement à ce système sur l'espace d'un an, donc tu as encore le temps, mais comme tu en enregistres à un rythme assez régulier, ce serait sympa si tu pouvais être un "early adopter" :-)

Les tâches déclarées ici jusqu'à présent resteront ici.

#6

Updated by Yannick Warnier almost 3 years ago

  • Status changed from Needs more info to Needs testing
  • Assignee set to Andre Boivin
  • % Done changed from 0 to 80
#7

Updated by Andre Boivin almost 3 years ago

  • Assignee changed from Andre Boivin to Julio Montoya

J'ai maintenant ce message si je demande une confirmation, (fichiers 1.11 release du 14 oct.):
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE23000: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`chamilo111`.`ticket_ticket`, CONSTRAINT `FK_EDE2C7686BF700BD` FOREIGN KEY (`status_id`) REFERENCES `ticket_status` (`id`))' in D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:104 Stack trace: #0 D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php(104): PDO->query('UPDATE ticket_t...') #1 D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(833): Doctrine\DBAL\Driver\PDOConnection->query('UPDATE ticket_t...') #2 D:\usbw\root\chamilo1.11\main\inc\lib\database.lib.php(360): Doctrine\DBAL\Connection->executeQuery('UPDATE ticket_t...') #3 D:\usbw\root\chamilo1.11\main\inc\lib\TicketManager.php(679): Database::query('UPDATE ticket_t...') #4 D:\usbw\root\chamilo1.11\main\ticket\ticket_details.php(421): TicketManager::insert_message('2', 'Re:: new t in D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php on line 60

#8

Updated by Yannick Warnier over 2 years ago

Julio, je te laisse ce lundi mâtin pour y jeter un oeil, mais si ça va pour toi dans 1.11.x, je fais la release stable dans l'après-midi.

#9

Updated by Julio Montoya over 2 years ago

  • Assignee deleted (Julio Montoya)

Andre Boivin wrote:

J'ai maintenant ce message si je demande une confirmation, (fichiers 1.11 release du 14 oct.):
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE23000: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`chamilo111`.`ticket_ticket`, CONSTRAINT `FK_EDE2C7686BF700BD` FOREIGN KEY (`status_id`) REFERENCES `ticket_status` (`id`))' in D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:104 Stack trace: #0 D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php(104): PDO->query('UPDATE ticket_t...') #1 D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(833): Doctrine\DBAL\Driver\PDOConnection->query('UPDATE ticket_t...') #2 D:\usbw\root\chamilo1.11\main\inc\lib\database.lib.php(360): Doctrine\DBAL\Connection->executeQuery('UPDATE ticket_t...') #3 D:\usbw\root\chamilo1.11\main\inc\lib\TicketManager.php(679): Database::query('UPDATE ticket_t...') #4 D:\usbw\root\chamilo1.11\main\ticket\ticket_details.php(421): TicketManager::insert_message('2', 'Re:: new t in D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php on line 60

Je viens de corriger ca.

Also available in: Atom PDF