opendcim / openDCIM

An open source (GPL v3) Data Center Inventory Management (DCIM) application.
http://opendcim.org
305 stars 204 forks source link

Error 500 on Disposal of devices #1493

Closed samilliken closed 8 months ago

samilliken commented 8 months ago

No matter what method you choose, the disposal method is broken and throws a 500 error.

PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 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 'set DispositionID='1', DispositionDate=NOW(), DisposedBy='scott@themillikens.com' at line 1 in /var/www/html/classes/DispositionMembership.class.php:41\nStack trace:\n#0 /var/www/html/classes/DispositionMembership.class.php(41): PDOStatement->execute()\n#1 /var/www/html/classes/Device.class.php(675): DispositionMembership->addDevice()\n#2 /var/www/html/storageroom.php(24): Device->Dispose()\n#3 {main}\n thrown in /var/www/html/classes/DispositionMembership.class.php on line 41, referer: https://dcim.cadmuslabs.net/storageroom.php?dc=2