Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Create project generates error #155

Open
okko7 opened this issue Nov 11, 2021 · 5 comments
Open

Create project generates error #155

okko7 opened this issue Nov 11, 2021 · 5 comments

Comments

@okko7
Copy link

okko7 commented Nov 11, 2021

When I try to create a project, I get a simple "error" message. See attached screenshot.

Running nextcloud 21.0.5 with time tracker 0.0.72.
@okko7
Copy link
Author

okko7 commented Nov 11, 2021

Here's the screenshot. As I'm using a hosted instance, I don't have access to the server itself to give you details the server configurations etc.

image

@mtierltd
Copy link
Owner

Hello

What database backend are you using?

@okko7
Copy link
Author

okko7 commented Jan 12, 2022

I have to admit that I don't know. I just rent that from a specialised nextcloud hosting provider.
Should I ask him what database backend he uses?

@mtierltd
Copy link
Owner

Please provide the nextcloud logfile from the time this error happened.

@wiedi
Copy link

wiedi commented Feb 2, 2022

I believe I can reproduce the same issue with the mysql dbtype.

Relevant parts of the stack trace:

{
	"level": 3,
	"user": "sewie",
	"app": "index",
	"method": "POST",
	"url": "/apps/timetracker/ajax/add-project/test-sw",
	"message": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'color' in 'field list'",
	"version": "23.0.0.10",
	"exception": {
		"Exception": "Doctrine\\DBAL\\Exception\\InvalidFieldNameException",
		"Message": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'color' in 'field list'",
		"Code": 1054,
		"Trace": [
			{
				"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
				"line": 1780,
				"function": "convert",
				"class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
				"type": "->",
				"args": [
					{
						"__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
					},
					{
						"__class__": "Doctrine\\DBAL\\Query"
					}
				]
			},
			{
				"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
				"line": 1719,
				"function": "handleDriverException",
				"class": "Doctrine\\DBAL\\Connection",
				"type": "->",
				"args": [
					{
						"__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
					},
					{
						"__class__": "Doctrine\\DBAL\\Query"
					}
				]
			},
			{
				"file": "/var/www/html/3rdparty/doctrine/dbal/src/Statement.php",
				"line": 193,
				"function": "convertExceptionDuringQuery",
				"class": "Doctrine\\DBAL\\Connection",
				"type": "->",
				"args": [
					{
						"__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
					},
					"INSERT INTO `oc_timetracker_project`(`name`,`color`,`created_at`,`created_by_user_uid`,`client_id`) VALUES(?,?,?,?,?)",
					{
						"1": "test-sw",
						"2": "#34495e",
						"3": 1643834410,
						"4": "sewie",
						"5": 26
					},
					{
						"1": 2,
						"2": 2,
						"3": 1,
						"4": 2,
						"5": 1
					}
				]
			},
			{
				"file": "/var/www/html/lib/private/DB/PreparedStatement.php",
				"line": 87,
				"function": "execute",
				"class": "Doctrine\\DBAL\\Statement",
				"type": "->",
				"args": [
					null
				]
			},
			{
				"file": "/var/www/html/lib/public/AppFramework/Db/Mapper.php",
				"line": 252,
				"function": "execute",
				"class": "OC\\DB\\PreparedStatement",
				"type": "->",
				"args": [

				]
			},
			{
				"file": "/var/www/html/lib/public/AppFramework/Db/Mapper.php",
				"line": 127,
				"function": "execute",
				"class": "OCP\\AppFramework\\Db\\Mapper",
				"type": "->",
				"args": [
					"INSERT INTO `*PREFIX*timetracker_project`(`name`,`color`,`created_at`,`created_by_user_uid`,`client_id`) VALUES(?,?,?,?,?)",
					[
						"test-sw",
						"#34495e",
						1643834410,
						"sewie",
						26
					]
				]
			},
			{
				"file": "/var/www/html/custom_apps/timetracker/lib/Controller/AjaxController.php",
				"line": 569,
				"function": "insert",
				"class": "OCP\\AppFramework\\Db\\Mapper",
				"type": "->",
				"args": [
					{
						"__class__": "OCA\\TimeTracker\\Db\\Project",
						"id": null,
						"name": "test-sw",
						"color": "#34495e",
						"clientId": 26,
						"createdByUserUid": "sewie",
						"createdAt": 1643834410,
						"locked": null,
						"archived": null
					}
				]
			},
			{
				"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
				"line": 217,
				"function": "addProject",
				"class": "OCA\\TimeTracker\\Controller\\AjaxController",
				"type": "->",
				"args": [
					"test-sw"
				]
			},
			{
				"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
				"line": 126,
				"function": "executeController",
				"class": "OC\\AppFramework\\Http\\Dispatcher",
				"type": "->",
				"args": [
					{
						"__class__": "OCA\\TimeTracker\\Controller\\AjaxController"
					},
					"addProject"
				]
			},
			{
				"file": "/var/www/html/lib/private/AppFramework/App.php",
				"line": 157,
				"function": "dispatch",
				"class": "OC\\AppFramework\\Http\\Dispatcher",
				"type": "->",
				"args": [
					{
						"__class__": "OCA\\TimeTracker\\Controller\\AjaxController"
					},
					"addProject"
				]
			},
			{
				"file": "/var/www/html/lib/private/Route/Router.php",
				"line": 302,
				"function": "main",
				"class": "OC\\AppFramework\\App",
				"type": "::",
				"args": [
					"OCA\\TimeTracker\\Controller\\AjaxController",
					"addProject",
					{
						"__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
					},
					{
						"name": "test-sw",
						"_route": "timetracker.ajax.add_project"
					}
				]
			},
			{
				"file": "/var/www/html/lib/base.php",
				"line": 1006,
				"function": "match",
				"class": "OC\\Route\\Router",
				"type": "->",
				"args": [
					"/apps/timetracker/ajax/add-project/test-sw"
				]
			},
			{
				"file": "/var/www/html/index.php",
				"line": 36,
				"function": "handleRequest",
				"class": "OC",
				"type": "::",
				"args": [

				]
			}
		],
		"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
		"Line": 65,
		"Previous": {
			"Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
			"Message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'color' in 'field list'",
			"Code": 1054,
			"Trace": [
				{
					"file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
					"line": 94,
					"function": "new",
					"class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
					"type": "::",
					"args": [
						{
							"__class__": "PDOException",
							"errorInfo": [
								"42S22",
								1054,
								"Unknown column 'color' in 'field list'"
							]
						}
					]
				},
				{
					"file": "/var/www/html/3rdparty/doctrine/dbal/src/Statement.php",
					"line": 189,
					"function": "execute",
					"class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
					"type": "->",
					"args": [
						null
					]
				},
				{
					"file": "/var/www/html/lib/private/DB/PreparedStatement.php",
					"line": 87,
					"function": "execute",
					"class": "Doctrine\\DBAL\\Statement",
					"type": "->",
					"args": [
						null
					]
				},
				{
					"file": "/var/www/html/lib/public/AppFramework/Db/Mapper.php",
					"line": 252,
					"function": "execute",
					"class": "OC\\DB\\PreparedStatement",
					"type": "->",
					"args": [

					]
				},
				{
					"file": "/var/www/html/lib/public/AppFramework/Db/Mapper.php",
					"line": 127,
					"function": "execute",
					"class": "OCP\\AppFramework\\Db\\Mapper",
					"type": "->",
					"args": [
						"INSERT INTO `*PREFIX*timetracker_project`(`name`,`color`,`created_at`,`created_by_user_uid`,`client_id`) VALUES(?,?,?,?,?)",
						[
							"test-sw",
							"#34495e",
							1643834410,
							"sewie",
							26
						]
					]
				},
				{
					"file": "/var/www/html/custom_apps/timetracker/lib/Controller/AjaxController.php",
					"line": 569,
					"function": "insert",
					"class": "OCP\\AppFramework\\Db\\Mapper",
					"type": "->",
					"args": [
						{
							"__class__": "OCA\\TimeTracker\\Db\\Project",
							"id": null,
							"name": "test-sw",
							"color": "#34495e",
							"clientId": 26,
							"createdByUserUid": "sewie",
							"createdAt": 1643834410,
							"locked": null,
							"archived": null
						}
					]
				},
				{
					"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
					"line": 217,
					"function": "addProject",
					"class": "OCA\\TimeTracker\\Controller\\AjaxController",
					"type": "->",
					"args": [
						"test-sw"
					]
				},
				{
					"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
					"line": 126,
					"function": "executeController",
					"class": "OC\\AppFramework\\Http\\Dispatcher",
					"type": "->",
					"args": [
						{
							"__class__": "OCA\\TimeTracker\\Controller\\AjaxController"
						},
						"addProject"
					]
				},
				{
					"file": "/var/www/html/lib/private/AppFramework/App.php",
					"line": 157,
					"function": "dispatch",
					"class": "OC\\AppFramework\\Http\\Dispatcher",
					"type": "->",
					"args": [
						{
							"__class__": "OCA\\TimeTracker\\Controller\\AjaxController"
						},
						"addProject"
					]
				},
				{
					"file": "/var/www/html/lib/private/Route/Router.php",
					"line": 302,
					"function": "main",
					"class": "OC\\AppFramework\\App",
					"type": "::",
					"args": [
						"OCA\\TimeTracker\\Controller\\AjaxController",
						"addProject",
						{
							"__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
						},
						{
							"name": "test-sw",
							"_route": "timetracker.ajax.add_project"
						}
					]
				},
				{
					"file": "/var/www/html/lib/base.php",
					"line": 1006,
					"function": "match",
					"class": "OC\\Route\\Router",
					"type": "->",
					"args": [
						"/apps/timetracker/ajax/add-project/test-sw"
					]
				},
				{
					"file": "/var/www/html/index.php",
					"line": 36,
					"function": "handleRequest",
					"class": "OC",
					"type": "::",
					"args": [

					]
				}
			],
			"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
			"Line": 26,
			"Previous": {
				"Exception": "PDOException",
				"Message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'color' in 'field list'",
				"Code": "42S22",
				"Trace": [
					{
						"file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
						"line": 92,
						"function": "execute",
						"class": "PDOStatement",
						"type": "->",
						"args": [
							null
						]
					},
					{
						"file": "/var/www/html/3rdparty/doctrine/dbal/src/Statement.php",
						"line": 189,
						"function": "execute",
						"class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
						"type": "->",
						"args": [
							null
						]
					},
					{
						"file": "/var/www/html/lib/private/DB/PreparedStatement.php",
						"line": 87,
						"function": "execute",
						"class": "Doctrine\\DBAL\\Statement",
						"type": "->",
						"args": [
							null
						]
					},
					{
						"file": "/var/www/html/lib/public/AppFramework/Db/Mapper.php",
						"line": 252,
						"function": "execute",
						"class": "OC\\DB\\PreparedStatement",
						"type": "->",
						"args": [

						]
					},
					{
						"file": "/var/www/html/lib/public/AppFramework/Db/Mapper.php",
						"line": 127,
						"function": "execute",
						"class": "OCP\\AppFramework\\Db\\Mapper",
						"type": "->",
						"args": [
							"INSERT INTO `*PREFIX*timetracker_project`(`name`,`color`,`created_at`,`created_by_user_uid`,`client_id`) VALUES(?,?,?,?,?)",
							[
								"test-sw",
								"#34495e",
								1643834410,
								"sewie",
								26
							]
						]
					},
					{
						"file": "/var/www/html/custom_apps/timetracker/lib/Controller/AjaxController.php",
						"line": 569,
						"function": "insert",
						"class": "OCP\\AppFramework\\Db\\Mapper",
						"type": "->",
						"args": [
							{
								"__class__": "OCA\\TimeTracker\\Db\\Project",
								"id": null,
								"name": "test-sw",
								"color": "#34495e",
								"clientId": 26,
								"createdByUserUid": "sewie",
								"createdAt": 1643834410,
								"locked": null,
								"archived": null
							}
						]
					},
					{
						"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
						"line": 217,
						"function": "addProject",
						"class": "OCA\\TimeTracker\\Controller\\AjaxController",
						"type": "->",
						"args": [
							"test-sw"
						]
					},
					{
						"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
						"line": 126,
						"function": "executeController",
						"class": "OC\\AppFramework\\Http\\Dispatcher",
						"type": "->",
						"args": [
							{
								"__class__": "OCA\\TimeTracker\\Controller\\AjaxController"
							},
							"addProject"
						]
					},
					{
						"file": "/var/www/html/lib/private/AppFramework/App.php",
						"line": 157,
						"function": "dispatch",
						"class": "OC\\AppFramework\\Http\\Dispatcher",
						"type": "->",
						"args": [
							{
								"__class__": "OCA\\TimeTracker\\Controller\\AjaxController"
							},
							"addProject"
						]
					},
					{
						"file": "/var/www/html/lib/private/Route/Router.php",
						"line": 302,
						"function": "main",
						"class": "OC\\AppFramework\\App",
						"type": "::",
						"args": [
							"OCA\\TimeTracker\\Controller\\AjaxController",
							"addProject",
							{
								"__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
							},
							{
								"name": "test-sw",
								"_route": "timetracker.ajax.add_project"
							}
						]
					},
					{
						"file": "/var/www/html/lib/base.php",
						"line": 1006,
						"function": "match",
						"class": "OC\\Route\\Router",
						"type": "->",
						"args": [
							"/apps/timetracker/ajax/add-project/test-sw"
						]
					},
					{
						"file": "/var/www/html/index.php",
						"line": 36,
						"function": "handleRequest",
						"class": "OC",
						"type": "::",
						"args": [

						]
					}
				],
				"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
				"Line": 92
			}
		},
		"CustomMessage": "--"
	},
}

@cfgardiner cfgardiner mentioned this issue Jun 27, 2022
Open
@cfgardiner cfgardiner mentioned this issue Jul 5, 2022
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@wiedi @okko7 @mtierltd