search

etsy / 411

An Alert Management Web Application
https://demo.fouroneone.io
MIT License
971 stars 112 forks source link

PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1 duplicate column name: source_id in /var/www/411/phplib/DB.php:81 #175

Closed papaharry closed 6 years ago

papaharry commented 6 years ago

The latest version gives the following error upon running the migration.php script:

PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1 duplicate column name: source_id in /var/www/411/phplib/DB.php:81
Stack trace:
#0 /var/www/411/phplib/DB.php(81): PDO->prepare('ALTER TABLE `al...')
#1 /var/www/411/bin/migration.php(85): FOO\DB::query('ALTER TABLE `al...')
#2 {main}
  thrown in /var/www/411/phplib/DB.php on line 81

By excluding the lines 84-87 on the migration.php file, the error does not appear and the application runs ok (more like work around rather than fix.