I’ve got the folde structure sorted i think, and it doesnt look anyhtng like 1.7.
how do i upgrade to 1.8.13?
I’ve set that up and put the settings file in, that when i got the last error.
You’d take a backup of your database with mysqldump first. Then you would take a backup of your existing settings.php file.
Then you’d rename your existing Xibo installation directory, and then make a new directory with the old name to extract the new CMS in to.
Then you would download and extract 1.8.13 CMS release in to that new directory, replacing settings.php that you backed up earlier in to web/settings.php.
If your CMS library lives inside your old CMS install folder (and it shouldn’t) then copy or move that in to the library folder, otherwise leave that where it was.
Then make the necessary changes to IIS to support a version 1.8 CMS (see https://xibo.org.uk/docs/setup/prepare-your-environment) but note that the IIS site’s webroot should be the web folder inside the Xibo install and not the directory a level up as it was for 1.7.
Then you should access the CMS as normal and it will prompt you to upgrade.
If you still get the same error as before, check your MySQL log file as the error “MySQL server went away” means it closed the connection on you - which might mean it’s restarting over and over.
You would make the changes required to IIS so that only web of the 1.8.13
Restoring the entire data folder of MySQL on the SQL server.
I have already made the changes to IIS to support 1.8 ( i think as the new install of 2.3 was working, (so far as I can see making sure that the root is www, not Xibo)
I assume I can use PHP 7.2 in 1.8.13?
Once the files are restored I will start the MySQL service and check it stays running.
My library is located at c:\XiboLib - so I don’t need to do anything there.
Thanks for your help. I’ll update soon.
1 Like
I’ve set up 1.8.13, and configured it to use php 5.3.28
In my php error log, i can see the following three errors occurring, the content length in the last line changes sometimes.
[06-Mar-2020 09:38:19] PHP Parse error: parse error in C:\inetpub\wwwroot\Xibo\web\xmds.php on line 39
and
[06-Mar-2020 09:38:53] PHP Parse error: parse error in C:\inetpub\wwwroot\Xibo\web\index.php on line 44
and
[06-Mar-2020 09:39:20] PHP Warning: Unknown: POST Content-Length of 655 bytes exceeds the limit of 0 bytes in Unknown on line 0
5.3 is too old. For Xibo 1.8 we shipped PHP 5.5 or 5.6 depending on the exact version. I would aim for a 5.6 version of PHP.
ok. I’ll go to 5.6.
Thanks.
Now I have the same SQL error I had late last night:
Fatal Error - sorry this shouldn't happen. SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'value' cannot be null
This is what i have in my General Log file:
TCP Port: 3306, Named Pipe: XIBO
Time Id Command Argument
2020-03-06T11:49:38.652189Z 1 Query SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE CREATE_OPTIONS LIKE '%partitioned%';
2020-03-06T11:50:06.012292Z 3 Connect root@localhost on using TCP/IP
2020-03-06T11:50:06.031620Z 3 Init DB mysql
2020-03-06T11:50:08.188688Z 3 Query set global general_log=on
2020-03-06T11:50:16.092835Z 4 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T11:50:16.092835Z 4 Query SET NAMES 'utf8'
2020-03-06T11:50:16.092835Z 4 Query SELECT `setting`, `value` FROM `setting`
2020-03-06T11:50:16.231360Z 4 Query SELECT app_ver, XlfVersion, XmdsVersion, DBVersion FROM version
2020-03-06T11:50:16.262541Z 5 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T11:50:16.278174Z 5 Query SET NAMES 'utf8'
2020-03-06T11:50:16.278174Z 5 Query SELECT `session_data`, `isexpired`, `useragent`, `session_expiration`, `userId`
FROM `session`
WHERE `session_id` = 'irreep2mll5o0t8830ll4ekbbh'
2020-03-06T11:50:16.293802Z 4 Query START TRANSACTION
2020-03-06T11:50:16.293802Z 4 Query UPDATE `setting` SET `value` = NULL WHERE `setting` = 'audit'
2020-03-06T11:50:16.293802Z 5 Query START TRANSACTION
2020-03-06T11:50:16.309422Z 5 Query UPDATE `session` SET
session_data = 'init|s:1:\"1\";',
session_expiration = '1583496856',
LastAccessed = '2020-03-06 11:50:16',
userID = '0',
IsExpired = '1'
WHERE session_id = 'irreep2mll5o0t8830ll4ekbbh'
2020-03-06T11:50:16.309422Z 5 Query COMMIT
2020-03-06T11:50:16.309422Z 5 Quit
2020-03-06T11:50:16.309422Z 4 Query ROLLBACK
2020-03-06T11:50:16.309422Z 4 Quit
2020-03-06T11:50:30.794137Z 6 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T11:50:30.794137Z 6 Query SET NAMES 'utf8'
2020-03-06T11:50:30.794137Z 6 Query SELECT `setting`, `value` FROM `setting`
2020-03-06T11:50:30.903713Z 6 Query SELECT app_ver, XlfVersion, XmdsVersion, DBVersion FROM version
2020-03-06T11:50:30.919083Z 6 Query START TRANSACTION
2020-03-06T11:50:30.919083Z 6 Query UPDATE `setting` SET `value` = NULL WHERE `setting` = 'audit'
2020-03-06T11:50:30.919083Z 6 Query ROLLBACK
2020-03-06T11:50:30.919083Z 6 Quit
2020-03-06T11:50:43.125346Z 3 Query set global general_log=off
Running this command:
update setting set value="emergency" where setting="audit";
has allowed Xibo to load to the update screen, but the start button wouldn’t do anything in Chrome, it is running through in edge though at the moment.
Now stuck at 104 “Update all Videos with their real duration” been there for about fifteen / twenty minutes so far.
eventually this error came up:
SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
If i enable the general SQL log I can see the following events:
2020-03-06T13:09:01.091453Z 2170 Query SELECT ModuleID,
Module,
Name,
Enabled,
Description,
render_as,
settings,
RegionSpecific,
ValidExtensions,
ImageUri,
PreviewEnabled,
assignable,
SchemaVersion
,
viewPath,
`class`
FROM `module`
WHERE 1 = 1
AND module = 'image' ORDER BY Module
2020-03-06T13:09:01.107071Z 2170 Quit
2020-03-06T13:09:01.107071Z 2171 Query START TRANSACTION
2020-03-06T13:09:01.107071Z 2171 Query UPDATE `session` SET
session_data = 'init|s:1:\"1\";csrfToken|s:40:\"f0e46ada1cb1928b7cabc0a5d41d728839700b32\";slim.flash|a:0:{}userid|i:1;',
session_expiration = '1583500453',
LastAccessed = '2020-03-06 13:09:01',
userID = '1',
IsExpired = '0'
WHERE session_id = 'oavu39onfg23sovmk32i2tnlj3'
2020-03-06T13:09:01.107071Z 2171 Query COMMIT
2020-03-06T13:09:01.107071Z 2171 Quit
2020-03-06T13:09:05.307370Z 2061 Query UPDATE `media`
SET `name` = 'Kings Hill School Playground.mp4',
duration = '1616',
retired = '0',
moduleSystemFile = '0',
editedMediaId = '0',
isEdited = '0',
userId = '1',
released = '1',
apiRef = NULL
WHERE mediaId = '26190'
2020-03-06T13:09:05.307370Z 2061 Query SELECT ModuleID,
Module,
Name,
Enabled,
Description,
render_as,
settings,
RegionSpecific,
ValidExtensions,
ImageUri,
PreviewEnabled,
assignable,
SchemaVersion
,
viewPath,
`class`
FROM `module`
WHERE 1 = 1
AND module = 'video' ORDER BY Module
2020-03-06T13:09:06.184756Z 2172 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:06.184756Z 2172 Query SET NAMES 'utf8'
2020-03-06T13:09:06.184756Z 2172 Query SELECT `setting`, `value` FROM `setting`
2020-03-06T13:09:06.278460Z 2172 Query SELECT app_ver, XlfVersion, XmdsVersion, DBVersion FROM version
2020-03-06T13:09:06.356650Z 2172 Query SELECT ModuleID,
Module,
Name,
Enabled,
Description,
render_as,
settings,
RegionSpecific,
ValidExtensions,
ImageUri,
PreviewEnabled,
assignable,
SchemaVersion
,
viewPath,
`class`
FROM `module`
WHERE 1 = 1
ORDER BY Module
2020-03-06T13:09:06.403515Z 2172 Query SELECT version() AS v
2020-03-06T13:09:06.403515Z 2172 Query SELECT display.displayId,
display.display,
display.defaultLayoutId,
layout.layout AS defaultLayout,
display.license,
display.licensed,
display.licensed AS currentlyLicensed,
display.loggedIn,
display.lastAccessed,
display.auditingUntil,
display.inc_schedule AS incSchedule,
display.email_alert AS emailAlert,
display.alert_timeout AS alertTimeout,
display.clientAddress,
display.mediaInventoryStatus,
display.macAddress,
display.macAddress AS currentMacAddress,
display.lastChanged,
display.numberOfMacAddressChanges,
display.lastWakeOnLanCommandSent,
display.wakeOnLan AS wakeOnLanEnabled,
display.wakeOnLanTime,
display.broadCastAddress,
display.secureOn,
display.cidr,
ST_X(display.GeoLocation) AS latitude,
ST_Y(display.GeoLocation) AS longitude,
display.client_type AS clientType,
display.client_version AS clientVersion,
display.client_code AS clientCode,
display.displayProfileId,
display.screenShotRequested,
display.storageAvailableSpace,
display.storageTotalSpace,
displaygroup.displayGroupId,
displaygroup.description,
`display`.xmrChannel,
`display`.xmrPubKey,
`display`.lastCommandSuccess,
`display`.deviceName,
`display`.timeZone,
`display`.overrideConfig
FROM `display`
INNER JOIN `lkdisplaydg`
ON lkdisplaydg.displayid = display.displayId
INNER JOIN `displaygroup`
ON displaygroup.displaygroupid = lkdisplaydg.displaygroupid
AND `displaygroup`.isDisplaySpecific = 1
LEFT OUTER JOIN layout
ON layout.layoutid = display.defaultlayoutid
WHERE 1 = 1 AND display.license = 'b5b490efd94c8fef32c215378619c395' ORDER BY display
2020-03-06T13:09:06.419088Z 2173 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:06.419088Z 2173 Query SET NAMES 'utf8'
2020-03-06T13:09:06.419088Z 2173 Query INSERT INTO log (runNo, logdate, channel, type, page, function, message, userid, displayid)
VALUES ('88bb8ee', '2020-03-06 13:09:06', 'XMDS', 'ERROR', 'NotifyStatus', 'POST', 'SQLSTATE[42S22]: Column not found: 1054 Unknown column \'display.auditingUntil\' in \'field list\'', '0', '0')
2020-03-06T13:09:06.434780Z 2173 Quit
2020-03-06T13:09:06.434780Z 2172 Quit
2020-03-06T13:09:10.701724Z 2174 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:10.701724Z 2174 Query SET NAMES 'utf8'
2020-03-06T13:09:10.701724Z 2174 Query SELECT `setting`, `value` FROM `setting`
2020-03-06T13:09:10.795495Z 2174 Query SELECT app_ver, XlfVersion, XmdsVersion, DBVersion FROM version
2020-03-06T13:09:10.873603Z 2174 Query SELECT ModuleID,
Module,
Name,
Enabled,
Description,
render_as,
settings,
RegionSpecific,
ValidExtensions,
ImageUri,
PreviewEnabled,
assignable,
SchemaVersion
,
viewPath,
`class`
FROM `module`
WHERE 1 = 1
ORDER BY Module
2020-03-06T13:09:10.904869Z 2174 Query SELECT version() AS v
2020-03-06T13:09:10.904869Z 2174 Query SELECT display.displayId,
display.display,
display.defaultLayoutId,
layout.layout AS defaultLayout,
display.license,
display.licensed,
display.licensed AS currentlyLicensed,
display.loggedIn,
display.lastAccessed,
display.auditingUntil,
display.inc_schedule AS incSchedule,
display.email_alert AS emailAlert,
display.alert_timeout AS alertTimeout,
display.clientAddress,
display.mediaInventoryStatus,
display.macAddress,
display.macAddress AS currentMacAddress,
display.lastChanged,
display.numberOfMacAddressChanges,
display.lastWakeOnLanCommandSent,
display.wakeOnLan AS wakeOnLanEnabled,
display.wakeOnLanTime,
display.broadCastAddress,
display.secureOn,
display.cidr,
ST_X(display.GeoLocation) AS latitude,
ST_Y(display.GeoLocation) AS longitude,
display.client_type AS clientType,
display.client_version AS clientVersion,
display.client_code AS clientCode,
display.displayProfileId,
display.screenShotRequested,
display.storageAvailableSpace,
display.storageTotalSpace,
displaygroup.displayGroupId,
displaygroup.description,
`display`.xmrChannel,
`display`.xmrPubKey,
`display`.lastCommandSuccess,
`display`.deviceName,
`display`.timeZone,
`display`.overrideConfig
FROM `display`
INNER JOIN `lkdisplaydg`
ON lkdisplaydg.displayid = display.displayId
INNER JOIN `displaygroup`
ON displaygroup.displaygroupid = lkdisplaydg.displaygroupid
AND `displaygroup`.isDisplaySpecific = 1
LEFT OUTER JOIN layout
ON layout.layoutid = display.defaultlayoutid
WHERE 1 = 1 AND display.license = 'b5b490efd94c8fef32c215378619c395' ORDER BY display
2020-03-06T13:09:10.920478Z 2175 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:10.920478Z 2175 Query SET NAMES 'utf8'
2020-03-06T13:09:10.920478Z 2175 Query INSERT INTO log (runNo, logdate, channel, type, page, function, message, userid, displayid)
VALUES ('bf667a2', '2020-03-06 13:09:10', 'XMDS', 'ERROR', 'RegisterDisplay', 'POST', 'SQLSTATE[42S22]: Column not found: 1054 Unknown column \'display.auditingUntil\' in \'field list\'', '0', '0')
2020-03-06T13:09:10.936123Z 2175 Quit
2020-03-06T13:09:10.936123Z 2174 Quit
2020-03-06T13:09:11.326751Z 2176 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:11.326751Z 2176 Query SET NAMES 'utf8'
2020-03-06T13:09:11.326751Z 2176 Query SELECT `setting`, `value` FROM `setting`
2020-03-06T13:09:11.436112Z 2176 Query SELECT app_ver, XlfVersion, XmdsVersion, DBVersion FROM version
2020-03-06T13:09:11.498609Z 2176 Query SELECT ModuleID,
Module,
Name,
Enabled,
Description,
render_as,
settings,
RegionSpecific,
ValidExtensions,
ImageUri,
PreviewEnabled,
assignable,
SchemaVersion
,
viewPath,
`class`
FROM `module`
WHERE 1 = 1
ORDER BY Module
2020-03-06T13:09:11.545475Z 2176 Query SELECT version() AS v
2020-03-06T13:09:11.545475Z 2176 Query SELECT display.displayId,
display.display,
display.defaultLayoutId,
layout.layout AS defaultLayout,
display.license,
display.licensed,
display.licensed AS currentlyLicensed,
display.loggedIn,
display.lastAccessed,
display.auditingUntil,
display.inc_schedule AS incSchedule,
display.email_alert AS emailAlert,
display.alert_timeout AS alertTimeout,
display.clientAddress,
display.mediaInventoryStatus,
display.macAddress,
display.macAddress AS currentMacAddress,
display.lastChanged,
display.numberOfMacAddressChanges,
display.lastWakeOnLanCommandSent,
display.wakeOnLan AS wakeOnLanEnabled,
display.wakeOnLanTime,
display.broadCastAddress,
display.secureOn,
display.cidr,
ST_X(display.GeoLocation) AS latitude,
ST_Y(display.GeoLocation) AS longitude,
display.client_type AS clientType,
display.client_version AS clientVersion,
display.client_code AS clientCode,
display.displayProfileId,
display.screenShotRequested,
display.storageAvailableSpace,
display.storageTotalSpace,
displaygroup.displayGroupId,
displaygroup.description,
`display`.xmrChannel,
`display`.xmrPubKey,
`display`.lastCommandSuccess,
`display`.deviceName,
`display`.timeZone,
`display`.overrideConfig
FROM `display`
INNER JOIN `lkdisplaydg`
ON lkdisplaydg.displayid = display.displayId
INNER JOIN `displaygroup`
ON displaygroup.displaygroupid = lkdisplaydg.displaygroupid
AND `displaygroup`.isDisplaySpecific = 1
LEFT OUTER JOIN layout
ON layout.layoutid = display.defaultlayoutid
WHERE 1 = 1 AND display.license = 'b5b490efd94c8fef32c215378619c395' ORDER BY display
2020-03-06T13:09:11.561202Z 2177 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:11.561202Z 2177 Query SET NAMES 'utf8'
2020-03-06T13:09:11.561202Z 2177 Query INSERT INTO log (runNo, logdate, channel, type, page, function, message, userid, displayid)
VALUES ('f59e1ca', '2020-03-06 13:09:11', 'XMDS', 'ERROR', 'SubmitLog', 'POST', 'SQLSTATE[42S22]: Column not found: 1054 Unknown column \'display.auditingUntil\' in \'field list\'', '0', '0')
2020-03-06T13:09:11.576738Z 2177 Quit
2020-03-06T13:09:11.576738Z 2176 Quit
2020-03-06T13:09:14.686099Z 2178 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:14.686099Z 2178 Query SET NAMES 'utf8'
2020-03-06T13:09:14.686099Z 2178 Query SELECT `setting`, `value` FROM `setting`
2020-03-06T13:09:14.795528Z 2178 Query SELECT app_ver, XlfVersion, XmdsVersion, DBVersion FROM version
2020-03-06T13:09:14.811153Z 2179 Connect xiboweb@SVRV-WEB-01.KINGSHILL.NETWORK on Xibo using TCP/IP
2020-03-06T13:09:14.811153Z 2179 Query SET NAMES 'utf8'
2020-03-06T13:09:14.811153Z 2179 Query SELECT `session_data`, `isexpired`, `useragent`, `session_expiration`, `userId`
FROM `session`
WHERE `session_id` = 'l4q87u481735s0csqmpkmpnpr2'
2020-03-06T13:09:14.811153Z 2178 Query SELECT app_ver, XlfVersion, XmdsVersion, DBVersion FROM version
2020-03-06T13:09:14.920526Z 2178 Query SELECT ModuleID,
Module,
Name,
Enabled,
Description,
render_as,
settings,
RegionSpecific,
ValidExtensions,
ImageUri,
PreviewEnabled,
assignable,
SchemaVersion
,
viewPath,
in the xibo log file:
+-------+---------+---------------------+---------+-------+-----------------+----------+------------------------------------------------------------------------------------------------+--------+-----------+
| logid | runNo | logdate | channel | type | page | function | message | userID | displayID |
+-------+---------+---------------------+---------+-------+-----------------+----------+------------------------------------------------------------------------------------------------+--------+-----------+
| 1 | 101140e | 2020-03-06 13:36:48 | XMDS | ERROR | SubmitLog | POST | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'display.auditingUntil' in 'field list' | 0 | 0 |
| 2 | 2717eec | 2020-03-06 13:36:48 | XMDS | ERROR | RegisterDisplay | POST | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'display.auditingUntil' in 'field list' | 0 | 0 |
| 3 | 8403bf4 | 2020-03-06 13:36:50 | XMDS | ERROR | GetResource | POST | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'display.auditingUntil' in 'field list' | 0 | 0 |
| 4 | 09e4ed7 | 2020-03-06 13:36:53 | XMDS | ERROR | NotifyStatus | POST | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'display.auditingUntil' in 'field list' | 0 | 0 |
| 5 | 9a70955 | 2020-03-06 13:36:57 | XMDS | ERROR | Schedule | POST | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'display.auditingUntil' in 'field list' | 0 | 0 |
| 6 | f5ba752 | 2020-03-06 13:36:57 | XMDS | ERROR | RequiredFiles | POST | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'display.auditingUntil' in 'field list' | 0 | 0 |
+-------+---------+---------------------+---------+-------+-----------------+----------+------------------------------------------------------------------------------------------------+--------+-----------+Update videos will take a long time, so you may need to roll back and then increase your PHP timeout setting.
I really would urge you to swap to a Docker based setup on a Linux server. I’m afraid I can’t offer you any more support on a custom installation as there’s just too many variables.
I appreciate your help, I’m running docker on my home setup.
I can increase my php timeout that isn’t an issue, do all of those errors above point to an error with the video processing?
The first one doesn’t no, but without some context as to where that error comes from I’ve no idea what it relates to I’m afraid.
The last ones are normal - that’s just displays trying to access the system while it’s being upgraded.
Changed the max_execution_time on php to 1200, and within a few minutes it moved on! the upgrade is complete!
I really appreciate you helping me out so much.
can i upgrade to 2.3 from 1.8,13? or should I upgrade to an “inbetween” version first?
I updated to 2.0 then to 2.3
All working fine now. Thank you. Just need to update the players now.
I’m having an issue registering a new client:
I’m getting the generic message on the client:
“There has been an unknown error with XMDS”
but the Xibo logs shows:
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘’ for column ‘defaultlayoutid’ at row 1
Any advice @alex?
Thanks.
This fixed the issue.
You need to set a global default layout in the main CMS settings.
Sorry the format was wrong in the settings:
Should have been:
d-M-Y H:i:s
1 Like
I’d recommend using the default which is Y-m-d H:i
Just updated that. Thanks.
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.