search

mtierltd / timetracker

GNU Affero General Public License v3.0
82 stars 27 forks source link

[V0.0.60] Cannot add new project #128

Closed Gsyltc closed 3 years ago

Gsyltc commented 3 years ago

Hi,

Since the new version, it's not possible to add a new project :

Nextcloud version : 22.0.0 Time tracker version : 0.0.60

Thanks

Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_by_user_uid' in 'field list'
/var/www/html/3rdparty/doctrine/dbal/src/Connection.php - line 1728:

Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Doctrine\DBA ... {}, Doctrine\DBAL\Query {})

/var/www/html/3rdparty/doctrine/dbal/src/Connection.php - line 1667:

Doctrine\DBAL\Connection->handleDriverException(Doctrine\DBA ... {}, Doctrine\DBAL\Query {})

/var/www/html/3rdparty/doctrine/dbal/src/Statement.php - line 179:

Doctrine\DBAL\Connection->convertExceptionDuringQuery(Doctrine\DBA ... {}, "INSERT INTO ... )", { 1: "Hors p ... 2}, { 1: 2,2: 2,3: 1,4: 2,5: 1})

/var/www/html/lib/private/DB/PreparedStatement.php - line 87:

Doctrine\DBAL\Statement->execute(null)

/var/www/html/lib/public/AppFramework/Db/Mapper.php - line 252:

OC\DB\PreparedStatement->execute()

/var/www/html/lib/public/AppFramework/Db/Mapper.php - line 127:

OCP\AppFramework\Db\Mapper->execute("INSERT INTO ... )", [ "Hors proj ... 2])

/var/www/html/custom_apps/timetracker/lib/Controller/AjaxController.php - line 562:

OCP\AppFramework\Db\Mapper->insert(OCA\TimeTrac ... l})

/var/www/html/lib/private/AppFramework/Http/Dispatcher.php - line 217:

OCA\TimeTracker\Controller\AjaxController->addProject("Hors projet")

/var/www/html/lib/private/AppFramework/Http/Dispatcher.php - line 126:

OC\AppFramework\Http\Dispatcher->executeController(OCA\TimeTrac ... {}, "addProject")

/var/www/html/lib/private/AppFramework/App.php - line 156:

OC\AppFramework\Http\Dispatcher->dispatch(OCA\TimeTrac ... {}, "addProject")

/var/www/html/lib/private/Route/Router.php - line 301:

OC\AppFramework\App::main("OCA\\TimeTr ... r", "addProject", OC\AppFramew ... {}, { name: "Hor ... "})

/var/www/html/lib/base.php - line 1000:

OC\Route\Router->match("/apps/timet ... t")

/var/www/html/index.php - line 36:

OC::handleRequest()

Causé par Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_by_user_uid' in 'field list'
/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 84:

Doctrine\DBAL\Driver\PDO\Exception::new(PDOException ... ]})

/var/www/html/3rdparty/doctrine/dbal/src/Statement.php - line 175:

Doctrine\DBAL\Driver\PDO\Statement->execute(null)

/var/www/html/lib/private/DB/PreparedStatement.php - line 87:

Doctrine\DBAL\Statement->execute(null)

/var/www/html/lib/public/AppFramework/Db/Mapper.php - line 252:

OC\DB\PreparedStatement->execute()

/var/www/html/lib/public/AppFramework/Db/Mapper.php - line 127:

OCP\AppFramework\Db\Mapper->execute("INSERT INTO ... )", [ "Hors proj ... 2])

/var/www/html/custom_apps/timetracker/lib/Controller/AjaxController.php - line 562:

OCP\AppFramework\Db\Mapper->insert(OCA\TimeTrac ... l})

/var/www/html/lib/private/AppFramework/Http/Dispatcher.php - line 217:

OCA\TimeTracker\Controller\AjaxController->addProject("Hors projet")

/var/www/html/lib/private/AppFramework/Http/Dispatcher.php - line 126:

OC\AppFramework\Http\Dispatcher->executeController(OCA\TimeTrac ... {}, "addProject")

/var/www/html/lib/private/AppFramework/App.php - line 156:

OC\AppFramework\Http\Dispatcher->dispatch(OCA\TimeTrac ... {}, "addProject")

/var/www/html/lib/private/Route/Router.php - line 301:

OC\AppFramework\App::main("OCA\\TimeTr ... r", "addProject", OC\AppFramew ... {}, { name: "Hor ... "})

/var/www/html/lib/base.php - line 1000:

OC\Route\Router->match("/apps/timet ... t")

/var/www/html/index.php - line 36:

OC::handleRequest()

Causé par PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_by_user_uid' in 'field list'
/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 82:

PDOStatement->execute(null)

/var/www/html/3rdparty/doctrine/dbal/src/Statement.php - line 175:

Doctrine\DBAL\Driver\PDO\Statement->execute(null)

/var/www/html/lib/private/DB/PreparedStatement.php - line 87:

Doctrine\DBAL\Statement->execute(null)

/var/www/html/lib/public/AppFramework/Db/Mapper.php - line 252:

OC\DB\PreparedStatement->execute()

/var/www/html/lib/public/AppFramework/Db/Mapper.php - line 127:

OCP\AppFramework\Db\Mapper->execute("INSERT INTO ... )", [ "Hors proj ... 2])

/var/www/html/custom_apps/timetracker/lib/Controller/AjaxController.php - line 562:

OCP\AppFramework\Db\Mapper->insert(OCA\TimeTrac ... l})

/var/www/html/lib/private/AppFramework/Http/Dispatcher.php - line 217:

OCA\TimeTracker\Controller\AjaxController->addProject("Hors projet")

/var/www/html/lib/private/AppFramework/Http/Dispatcher.php - line 126:

OC\AppFramework\Http\Dispatcher->executeController(OCA\TimeTrac ... {}, "addProject")

/var/www/html/lib/private/AppFramework/App.php - line 156:

OC\AppFramework\Http\Dispatcher->dispatch(OCA\TimeTrac ... {}, "addProject")

/var/www/html/lib/private/Route/Router.php - line 301:

OC\AppFramework\App::main("OCA\\TimeTr ... r", "addProject", OC\AppFramew ... {}, { name: "Hor ... "})

/var/www/html/lib/base.php - line 1000:

OC\Route\Router->match("/apps/timet ... t")

/var/www/html/index.php - line 36:

OC::handleRequest()

Thanks

mtierltd commented 3 years ago

This is now fixed in version 0.0.60 and 0.0.61.