Undefined Textarea/Comments Problem After Migration Restore #5213

aljawaid · 2022-05-11T08:14:27Z

aljawaid
May 11, 2022

Checklist

[x ] I verified that Kanboard is correctly installed
[ x] I verified that the problem does not come from a plugin
[ x] I verified that the problem is not already reported
[ x] I understand that Kanboard is in maintenance mode. It doesn't mean it's abandoned, but there is no significant feature development

Actual behaviour

I migrated from one vps to another. Backup website and database, successfully restored database and website, then upgrated 2 minor releases.

Everything works fine as it appears, with files/screenshots loading fine and comments/text showing fine.

The problem is when editing comments or text... Instead of showing the text I can edit, it just says undefined.

In firefox browser console, I get this message: The byte stream was erroneous according to the character encoding that was declared. The character encoding declaration may be incorrect.

After reading online, I checked the template/layout file and it showed the meta tag as utf-8.

My database table structure is:

Table 							Rows 	Type 	Collation 			Size 		Overhead
actions 	  					145 	InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
action_has_params 				256 	InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
bigboard_collapsed 				0 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
bigboard_selected 				19 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
columns 	  	 				123 	InnoDB 	utf8mb4_unicode_ci 	48.0 KiB 	-
column_has_move_restrictions 	0 		InnoDB 	utf8mb4_unicode_ci 	80.0 KiB 	-
column_has_restrictions 	  	0 		InnoDB 	utf8mb4_unicode_ci 	64.0 KiB 	-
comments 	  	 				2,310 	InnoDB 	utf8mb4_unicode_ci 	1.8 MiB 	-
currencies 	  	 				2 		InnoDB 	utf8mb4_unicode_ci 	16.0 KiB 	-
custom_filters 	  	 			0 	 	InnoDB 	utf8mb4_unicode_ci 	48.0 KiB 	-
groups 	  	 					3 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
group_has_users 	  	 		11 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
invites				 	  	 	1 		InnoDB 	utf8mb4_unicode_ci 	16.0 KiB 	-
last_logins 	  			 	116 	InnoDB 	utf8mb4_unicode_ci 	64.0 KiB 	-
links 	 				 	 	51 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
metadata_has_type 	  		 	0 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
metadata_types 	  	 			4 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
multiselect 	  	 			15 		InnoDB 	utf8mb4_unicode_ci 	16.0 KiB 	-
multiselect_has_users 	  	 	4 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
password_reset 	  	 			2 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
plugin_schema_versions 	  	 	16 		InnoDB 	utf8mb4_unicode_ci 	16.0 KiB 	-
predefined_task_descriptions 	5 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
projects 	  	 				26 		InnoDB 	utf8mb4_unicode_ci 	16.0 KiB 	-
project_activities 	  	 		3,867 	InnoDB 	utf8mb4_unicode_ci 	10.9 MiB 	-
project_daily_column_stats 	  	17,717 	InnoDB 	utf8mb4_unicode_ci 	3.8 MiB 	-
project_daily_stats 	  	 	6,755 	InnoDB 	utf8mb4_unicode_ci 	752.0 KiB 	-
project_has_categories 	  	 	38 		InnoDB 	utf8mb4_unicode_ci 	48.0 KiB 	-
project_has_files 	  	 		0 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
project_has_groups 	  	 		11 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
project_has_metadata 	  	 	30 		InnoDB 	utf8mb4_unicode_ci 	16.0 KiB 	-
project_has_notification_types	0 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
project_has_roles 	  	 		0 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
project_has_users 	  	 		55 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
project_role_has_restrictions 	0 		InnoDB 	utf8mb4_unicode_ci 	48.0 KiB 	-
remember_me 	  	 			19 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
schema_version 	  	 			2 		InnoDB 	utf8mb4_unicode_ci 	16.0 KiB 	-
sessions 	  	 				9,256 	InnoDB 	utf8mb4_unicode_ci 	3.5 MiB 	-
settings 	  	 				45 		MyISAM 	utf8mb4_unicode_ci 	10.7 KiB 	-
subtasks 	  	 				358 	InnoDB 	utf8mb4_unicode_ci 	80.0 KiB 	-
subtask_time_tracking 	  	 	251 	InnoDB 	utf8mb4_unicode_ci 	48.0 KiB 	-
swimlanes 	  	 				51 		InnoDB 	utf8mb4_unicode_ci 	48.0 KiB 	-
tags 	  	 					170 	InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
tasks 	  	 					239 	InnoDB 	utf8mb4_unicode_ci 	272.0 KiB 	-
task_has_external_links 	  	108 	InnoDB 	utf8mb4_unicode_ci 	64.0 KiB 	-
task_has_files 	  	 			370 	InnoDB 	utf8mb4_unicode_ci 	96.0 KiB 	-
task_has_links 	  	 			234 	InnoDB 	utf8mb4_unicode_ci 	64.0 KiB 	-
task_has_metadata 	  	 		315 	InnoDB 	utf8mb4_unicode_ci 	16.0 KiB 	-
task_has_tags 	  	 			198 	InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
transitions 	  	 			241 	InnoDB 	utf8mb4_unicode_ci 	96.0 KiB 	-
users 	  	 					15 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
user_has_metadata 	  	 		31 		InnoDB 	utf8mb4_unicode_ci 	16.0 KiB 	-
user_has_notifications 	  	 	6 		MyISAM 	utf8mb4_unicode_ci 	3.1 KiB 	-
user_has_notification_types 	20 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
user_has_unread_notifications 	2,282 	InnoDB 	utf8mb4_unicode_ci 	5.6 MiB 	-
wikipage 	  	 				5 		MyISAM 	utf8mb4_unicode_ci 	6.5 KiB 	-
wikipage_editions 	  	 		0 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
wikipage_has_files 	  	 		0 		InnoDB 	utf8mb4_unicode_ci 	32.0 KiB 	-
57 tables 				Sum 	45,798 	InnoDB 	utf8mb4_unicode_ci 	28.3 MiB 	0 B

Expected behaviour

When the task description or comment is in 'edit' form/mode, the contents should display... instead of undefined

Steps to reproduce

Click on 'edit' for task description or comment. The box says undefined yet in view mode, the comment exists.

Screenshots

VIEW COMMENT:

EDIT COMMENT:

Logs

Configuration

Kanboard version: 1.2.22
Database type and version: MySQL 5.7.36
PHP version: 7.4.3
OS: Ubuntu 20.04
Browser: Firefox

aljawaid · 2022-05-11T09:43:23Z

aljawaid
May 11, 2022
Author

I made sure the files are saved in UTF-8 in Sublime Editor.. I dont think the problem is the character encoding as the characters and symbols now display correctly and the byte stream error has gone.

The undefined problem of editing comments/descriptions seems to be the MAIN issue which I cannot find the solution for.

Kindly help.

0 replies

aljawaid · 2022-05-11T15:41:34Z

aljawaid
May 11, 2022
Author

Debug Log

[2022-05-11 16:38:59] [debug] ###############################################
[2022-05-11 16:39:04] [debug] Kanboard\Core\Controller\Runner::executeMiddleware
[2022-05-11 16:39:04] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
[2022-05-11 16:39:04] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware
[2022-05-11 16:39:04] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\PostAuthenticationMiddleware
[2022-05-11 16:39:04] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ApplicationAuthorizationMiddleware
[2022-05-11 16:39:04] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ProjectAuthorizationMiddleware
[2022-05-11 16:39:04] [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\AuthController::logout
[2022-05-11 16:39:04] [debug] Subscriber executed: Kanboard\Subscriber\AuthSubscriber::afterLogout
[2022-05-11 16:39:04] [debug] SQL: SELECT `version` FROM `plugin_schema_versions`   WHERE `plugin` = ?    LIMIT 1
[2022-05-11 16:39:04] [debug] SQL: query_duration=0.0030190944671631
[2022-05-11 16:39:04] [debug] SQL: total_execution_time=0.0030190944671631
[2022-05-11 16:39:04] [debug] SQL: SELECT `option`, `value` FROM `settings`
[2022-05-11 16:39:04] [debug] SQL: query_duration=0.004209041595459
[2022-05-11 16:39:04] [debug] SQL: total_execution_time=0.0072281360626221
[2022-05-11 16:39:04] [debug] SQL: SELECT `version` FROM `plugin_schema_versions`   WHERE `plugin` = ?    LIMIT 1
[2022-05-11 16:39:04] [debug] SQL: query_duration=0.0019590854644775
[2022-05-11 16:39:04] [debug] SQL: total_execution_time=0.0091872215270996
[2022-05-11 16:39:04] [debug] SQL: SELECT `version` FROM `plugin_schema_versions`   WHERE `plugin` = ?    LIMIT 1
[2022-05-11 16:39:04] [debug] SQL: query_duration=0.0039360523223877
[2022-05-11 16:39:04] [debug] SQL: total_execution_time=0.013123273849487
[2022-05-11 16:39:04] [debug] SQL: SELECT `version` FROM `plugin_schema_versions`   WHERE `plugin` = ?    LIMIT 1
[2022-05-11 16:39:04] [debug] SQL: query_duration=0.002208948135376
[2022-05-11 16:39:04] [debug] SQL: total_execution_time=0.015332221984863
[2022-05-11 16:39:04] [debug] SQL: SELECT `version` FROM `plugin_schema_versions`   WHERE `plugin` = ?    LIMIT 1
[2022-05-11 16:39:04] [debug] SQL: query_duration=0.0028319358825684
[2022-05-11 16:39:04] [debug] SQL: total_execution_time=0.018164157867432
[2022-05-11 16:39:04] [debug] SQL: SELECT `data` FROM `sessions`   WHERE `id` = ?    LIMIT 1
[2022-05-11 16:39:04] [debug] SQL: query_duration=0.0043809413909912
[2022-05-11 16:39:04] [debug] SQL: total_execution_time=0.022545099258423
[2022-05-11 16:39:04] [debug] SQL: SELECT projects.id, projects.name FROM `projects` LEFT JOIN `project_has_users` ON `project_has_users`.`project_id`=`projects`.`id`  WHERE project_has_users.user_id = ? AND projects.is_active IN (?)
[2022-05-11 16:39:04] [debug] SQL: query_duration=0.0024199485778809
[2022-05-11 16:39:04] [debug] SQL: total_execution_time=0.024965047836304
[2022-05-11 16:39:04] [debug] SQL: SELECT projects.id, projects.name FROM `projects` LEFT JOIN `project_has_groups` ON `project_has_groups`.`project_id`=`projects`.`id` LEFT JOIN `group_has_users` ON `group_has_users`.`group_id`=`project_has_groups`.`group_id`  WHERE group_has_users.user_id = ? AND projects.is_active IN (?)
[2022-05-11 16:39:04] [debug] SQL: query_duration=0.0027401447296143
[2022-05-11 16:39:04] [debug] SQL: total_execution_time=0.027705192565918
[2022-05-11 16:39:04] [debug] SQL: SELECT * FROM `actions`   WHERE `project_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2022-05-11 16:39:04] [debug] SQL: query_duration=0.002593994140625
[2022-05-11 16:39:04] [debug] SQL: total_execution_time=0.030299186706543
[2022-05-11 16:39:04] [debug] SQL: SELECT * FROM `action_has_params`   WHERE `action_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2022-05-11 16:39:04] [debug] SQL: query_duration=0.0037109851837158
[2022-05-11 16:39:04] [debug] SQL: total_execution_time=0.034010171890259
[2022-05-11 16:39:04] [debug] SQL: SELECT 1 FROM `users`  WHERE `id` = ? AND `is_active` = ? AND `role` = ?
[2022-05-11 16:39:04] [debug] SQL: query_duration=0.0027470588684082
[2022-05-11 16:39:04] [debug] SQL: total_execution_time=0.036757230758667
[2022-05-11 16:39:04] [debug] SQL: SELECT * FROM `remember_me`   WHERE `token` = ? AND `sequence` = ? AND `expiration` > ?    LIMIT 1
[2022-05-11 16:39:04] [debug] SQL: query_duration=0.0025739669799805
[2022-05-11 16:39:04] [debug] SQL: total_execution_time=0.039331197738647
[2022-05-11 16:39:04] [debug] SQL: DELETE FROM `remember_me`  WHERE `id` = ?
[2022-05-11 16:39:04] [debug] SQL: query_duration=0.0043089389801025
[2022-05-11 16:39:04] [debug] SQL: total_execution_time=0.04364013671875
[2022-05-11 16:39:04] [debug] SQL: DELETE FROM `sessions`  WHERE `id` = ?
[2022-05-11 16:39:04] [debug] SQL: query_duration=0.0045821666717529
[2022-05-11 16:39:04] [debug] SQL: total_execution_time=0.048222303390503
[2022-05-11 16:39:04] [debug] APP: nb_queries=15
[2022-05-11 16:39:04] [debug] APP: rendering_time=0.14181804656982
[2022-05-11 16:39:04] [debug] APP: memory_usage=2.08M
[2022-05-11 16:39:04] [debug] APP: uri=/logout
[2022-05-11 16:39:04] [debug] ###############################################
[2022-05-11 16:39:05] [debug] Kanboard\Core\Controller\Runner::executeMiddleware
[2022-05-11 16:39:05] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
[2022-05-11 16:39:05] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware
[2022-05-11 16:39:05] [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\AuthController::login
[2022-05-11 16:39:05] [debug] SQL: SELECT `version` FROM `plugin_schema_versions`   WHERE `plugin` = ?    LIMIT 1
[2022-05-11 16:39:05] [debug] SQL: query_duration=0.0070121288299561
[2022-05-11 16:39:05] [debug] SQL: total_execution_time=0.0070121288299561
[2022-05-11 16:39:05] [debug] SQL: SELECT `option`, `value` FROM `settings`
[2022-05-11 16:39:05] [debug] SQL: query_duration=0.0065171718597412
[2022-05-11 16:39:05] [debug] SQL: total_execution_time=0.013529300689697
[2022-05-11 16:39:05] [debug] SQL: SELECT `version` FROM `plugin_schema_versions`   WHERE `plugin` = ?    LIMIT 1
[2022-05-11 16:39:05] [debug] SQL: query_duration=0.003972053527832
[2022-05-11 16:39:05] [debug] SQL: total_execution_time=0.017501354217529
[2022-05-11 16:39:05] [debug] SQL: SELECT `version` FROM `plugin_schema_versions`   WHERE `plugin` = ?    LIMIT 1
[2022-05-11 16:39:05] [debug] SQL: query_duration=0.0035970211029053
[2022-05-11 16:39:05] [debug] SQL: total_execution_time=0.021098375320435
[2022-05-11 16:39:05] [debug] SQL: SELECT `version` FROM `plugin_schema_versions`   WHERE `plugin` = ?    LIMIT 1
[2022-05-11 16:39:05] [debug] SQL: query_duration=0.0022001266479492
[2022-05-11 16:39:05] [debug] SQL: total_execution_time=0.023298501968384
[2022-05-11 16:39:05] [debug] SQL: SELECT `version` FROM `plugin_schema_versions`   WHERE `plugin` = ?    LIMIT 1
[2022-05-11 16:39:05] [debug] SQL: query_duration=0.0022070407867432
[2022-05-11 16:39:05] [debug] SQL: total_execution_time=0.025505542755127
[2022-05-11 16:39:05] [debug] SQL: SELECT `data` FROM `sessions`   WHERE `id` = ?    LIMIT 1
[2022-05-11 16:39:05] [debug] SQL: query_duration=0.0023119449615479
[2022-05-11 16:39:05] [debug] SQL: total_execution_time=0.027817487716675
[2022-05-11 16:39:05] [debug] SQL: SELECT * FROM `actions`
[2022-05-11 16:39:05] [debug] SQL: query_duration=0.00360107421875
[2022-05-11 16:39:05] [debug] SQL: total_execution_time=0.031418561935425
[2022-05-11 16:39:05] [debug] SQL: SELECT * FROM `action_has_params`
[2022-05-11 16:39:05] [debug] SQL: query_duration=0.0028679370880127
[2022-05-11 16:39:05] [debug] SQL: total_execution_time=0.034286499023438
[2022-05-11 16:39:05] [debug] SQL: SELECT 1 FROM `sessions`  WHERE `id` = ?
[2022-05-11 16:39:05] [debug] SQL: query_duration=0.0026569366455078
[2022-05-11 16:39:05] [debug] SQL: total_execution_time=0.036943435668945
[2022-05-11 16:39:05] [debug] SQL: INSERT INTO `sessions` (`id`, `expire_at`, `data`) VALUES (:id, :expire_at, :data)
[2022-05-11 16:39:05] [debug] SQL: query_duration=0.0066280364990234
[2022-05-11 16:39:05] [debug] SQL: total_execution_time=0.043571472167969
[2022-05-11 16:39:05] [debug] APP: nb_queries=11
[2022-05-11 16:39:05] [debug] APP: rendering_time=0.1632399559021
[2022-05-11 16:39:05] [debug] APP: memory_usage=2.1M
[2022-05-11 16:39:05] [debug] APP: uri=/login
[2022-05-11 16:39:05] [debug] ###############################################

I noticed the question marks.... not sure if that is where the problem is or even what the solution is.

Can anybody help?

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Kanboard

Undefined Textarea/Comments Problem After Migration Restore #5213

{{title}}

Replies: 2 comments

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

Select a reply

Kanboard

Undefined Textarea/Comments Problem After Migration Restore #5213

aljawaid May 11, 2022

Checklist

Actual behaviour

Expected behaviour

Steps to reproduce

Screenshots

Logs

Configuration

Replies: 2 comments

aljawaid May 11, 2022 Author

aljawaid May 11, 2022 Author

aljawaid
May 11, 2022

aljawaid
May 11, 2022
Author

aljawaid
May 11, 2022
Author