Can't edit display after Upgrade from 1.7.9 to 1.8.x

Hello.

I have just done a test upgrade to 1.8 tree (tested 1.8.0,1.8.1,1.8.2).
Update went fine, but when I edit a display (can be one that still was in 1.7 or a newly created one in 1.8) xibo throws the following error message

— Application messages

The separation symbol could not be found The separation symbol could not be found Trailing data


Neither apache log nor xibo log saying something suspicious

Thx
Alex

There was a problem with it, although it should not be there anymore in 1.8.2 (which I’d recommend you try now).

Could you navigate to Display settings page -> Edit display profile assigned to your device -> Check the Download window start/end time please?

Make sure it’s set to 00:00 and 00:00 ie open all the time and save the form

Try to edit the display

failing that, go back to display profile change the download window to something else let’s say 08:00 and 20:00 and save the form

try to edit the display

If successful you can edit it back to 00:00 and 00:00.

Please also let me know what do you have in CMS Settings -> Regional tab (namely in date format).

Failing all of that

Navigate to Report Fault page and go through report fault wizard (in short, enable debugging, recreate problem in another tab, check logs / send them to us, there should be a relevant error to this issue there.

Hello Peter.

Your tipp did it.

But first I can’t put any start/end date into the fields, after thought about the upgrade process I have remembered that I have two faults in the SQL section.
One regarding the pages table


Unable to run upgrade stepId 19. Message = SQLSTATE[HY000]: General error: 1025 Error on rename of ‘./xibo_test/pages’ to ‘./xibo_test/#sql2-8b9-1acf98d’ (errno: 152)

#0 /www/xibo_182/lib/Entity/Upgrade.php(79): PDO->exec(‘ALTER TABLE `pa…’) #1 /www/xibo_182/lib/Controller/Upgrade.php(128): Xibo\Entity\Upgrade->doStep() #2 [internal function]: Xibo\Controller\Upgrade->doStep(‘19’) #3 /www/xibo_182/vendor/akrabat/rka-slim-controller/RKA/Slim.php(79): call_user_func_array(Array, Array) #4 [internal function]: RKA\Slim->RKA{closure}(‘19’) #5 /www/xibo_182/vendor/slim/slim/Slim/Route.php(468): call_user_func_array(Object(Closure), Array) #6 /www/xibo_182/vendor/slim/slim/Slim/Slim.php(1357): Slim\Route->dispatch() #7 /www/xibo_182/vendor/slim/slim/Slim/Middleware/Flash.php(85): Slim\Slim->call() #8 /www/xibo_182/vendor/slim/slim/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call() #9 /www/xibo_182/lib/Middleware/Actions.php(142): Slim\Middleware\MethodOverride->call() #10 /www/xibo_182/lib/Middleware/Theme.php(35): Xibo\Middleware\Actions->call() #11 /www/xibo_182/lib/Middleware/WebAuthentication.php(132): Xibo\Middleware\Theme->call() #12 /www/xibo_182/lib/Middleware/CsrfGuard.php(62): Xibo\Middleware\WebAuthentication->call() #13 /www/xibo_182/lib/Middleware/State.php(117): Xibo\Middleware\CsrfGuard->call() #14 /www/xibo_182/lib/Middleware/Storage.php(47): Xibo\Middleware\State->call() #15 /www/xibo_182/lib/Middleware/Xmr.php(36): Xibo\Middleware\Storage->call() #16 /www/xibo_182/vendor/slim/slim/Slim/Slim.php(1302): Xibo\Middleware\Xmr->call() #17 /www/xibo_182/web/index.php(124): Slim\Slim->run() #18 {main}

Upgrade step skipped. id = 68


and the second one regarding the scheduling tables


Unable to run upgrade stepId 68. Message = SQLSTATE[HY000]: General error: 1025 Error on rename of ‘./xibo_test/schedule_detail’ to ‘./xibo_test/#sql2-8b9-1acfaae’ (errno: 152)

#0 /www/xibo_182/lib/Entity/Upgrade.php(79): PDO->exec(‘ALTER TABLE `sc…’) #1 /www/xibo_182/lib/Controller/Upgrade.php(128): Xibo\Entity\Upgrade->doStep() #2 [internal function]: Xibo\Controller\Upgrade->doStep(‘68’) #3 /www/xibo_182/vendor/akrabat/rka-slim-controller/RKA/Slim.php(79): call_user_func_array(Array, Array) #4 [internal function]: RKA\Slim->RKA{closure}(‘68’) #5 /www/xibo_182/vendor/slim/slim/Slim/Route.php(468): call_user_func_array(Object(Closure), Array) #6 /www/xibo_182/vendor/slim/slim/Slim/Slim.php(1357): Slim\Route->dispatch() #7 /www/xibo_182/vendor/slim/slim/Slim/Middleware/Flash.php(85): Slim\Slim->call() #8 /www/xibo_182/vendor/slim/slim/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call() #9 /www/xibo_182/lib/Middleware/Actions.php(142): Slim\Middleware\MethodOverride->call() #10 /www/xibo_182/lib/Middleware/Theme.php(35): Xibo\Middleware\Actions->call() #11 /www/xibo_182/lib/Middleware/WebAuthentication.php(132): Xibo\Middleware\Theme->call() #12 /www/xibo_182/lib/Middleware/CsrfGuard.php(62): Xibo\Middleware\WebAuthentication->call() #13 /www/xibo_182/lib/Middleware/State.php(117): Xibo\Middleware\CsrfGuard->call() #14 /www/xibo_182/lib/Middleware/Storage.php(47): Xibo\Middleware\State->call() #15 /www/xibo_182/lib/Middleware/Xmr.php(36): Xibo\Middleware\Storage->call() #16 /www/xibo_182/vendor/slim/slim/Slim/Slim.php(1302): Xibo\Middleware\Xmr->call() #17 /www/xibo_182/web/index.php(124): Slim\Slim->run() #18 {main}

Unable to rollback. E = SQLSTATE[HY000]: General error: 1025 Error on rename of ‘./xibo_test/schedule_detail’ to ‘./xibo_test/#sql2-8b9-1acfaae’ (errno: 152)

Upgrade step skipped. id = 68


So I have tried creating a new pages table from source sql. But that doesn’t work, cause the ids from the old table doesn’t match the new ones. So move the old one back
Also and that just was the trick I have altered the scheduling table with the ALTER SQL-Statement from the source.
Now I can edit the start/end dates in “display groups” section and from now on I can edit the display setting again too.

Thx a lot for your help

Greets from Germany
–Alex