Kodi Community Forum
On updating I get Mysql error, resulting in video dbase not upgraded and not used - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: On updating I get Mysql error, resulting in video dbase not upgraded and not used (/showthread.php?tid=335067)

On updating I get Mysql error, resulting in video dbase not upgraded and not used - bartmans - 2018-08-30

Hi,

When upgrading from Kodi 17, to Kodi beta 1 on Windows 10, 64 bit, I still encounter this ticket
https://trac.kodi.tv/ticket/17775

Full log:
https://pastebin.com/b8P0wMYe

I have Kodi 17 installed from Windows 10 Appstore. Concurrently I installed Kodi 18 separately.

In PHPMyAdmin I checked the user 'kodi' has full rights on all dbases. I removed the created video112 dbase and recreated it with a fresh install from Kodi beta. No luck.

Any tips? Or is is a true bug :-).

RE: On updating I get Mysql error, resulting in video dbase not upgraded and not used - Klojum - 2018-08-30

MySQL error #1054 = Unknown column in ...
sql:


CREATE TABLE

  settingsnew

  CHARACTER SET

    utf8 COLLATE utf8_general_ci AS

      SELECT idFile, Deinterlace, ViewMode, ZoomAmount, PixelRatio, VerticalShift, AudioStream, SubtitleStream, SubtitleDelay, SubtitlesOn, Brightness, Contrast, Gamma, VolumeAmplification, AudioDelay, ResumeTime, Sharpness, NoiseReduction, NonLinStretch, PostProcess, ScalingMethod, DeinterlaceMode, StereoMode, StereoInvert, VideoStream

FROM

  settings
I have no idea which is the culprit... Eek

Code:
21:05:24.634 T:1988 NOTICE: Old database found - updating from version 110 to 112
21:05:24.637 T:1988 ERROR: SQL: Can't create database for copy: 'MyVideos110' (1007)
21:05:24.637 T:1988 ERROR: Unable to copy old database MyVideos110 to new version MyVideos112
Are you running MariaDB? Perhaps your database user rights are not adequate?

21:05:24.217 T:1208 NOTICE: Disabled debug logging due to GUI setting. Level 0.
Next time, enable debugging, and restart Kodi.

RE: On updating I get Mysql error, resulting in video dbase not upgraded and not used - bartmans - 2018-09-06

Using MariaDB on a Synology NAS. I checked the user rights and password. User kodi has full rights on this database.

I removed MyVideos112, downloaded latest daily (sept 6). I get the message about migrating databases.

But no luck: https://pastebin.com/gTPn1fLk

I then switched to another NAS running MariaDB which had an older version MyVideos99 of the dbase. It completed the migration to MyVideos112.

When I have time I will try to export 112 from the working dbase to the other one.

Added
I tried to export working version 112 to original dbase-server. That worked.

So problem is perhaps in the upgrading from MyVideos110 to MyVideos112. Because upgrading from 109 worked. Shame that all my 'state' data for videos (like 'watched') is in the 110 version :-(. My wife will not like losing that.

RE: On updating I get Mysql error, resulting in video dbase not upgraded and not used - Klojum - 2018-09-06

I didn't see any problems upgrading from 110 to 112, but I use an old MySQL server 5.5.something...

You have to enable the options for watched state and resume points via the advancedsettings.xml file. After that, re-export your video library and choose the overwrite option.

Can you create a ticket at Kodi's bug tracker and include all possible info and logs?

RE: On updating I get Mysql error, resulting in video dbase not upgraded and not used - bartmans - 2018-09-06

Yes, I have the relevant lines in advancedsettings.xml and this works great in Kodi 17.6:
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>

I meant that the state database is in the 110 version, that is currently being used on my 'productions' 17.6 Kodis.

There is already a ticket that is very similar:
https://trac.kodi.tv/ticket/17775

Do you need a new one?

RE: On updating I get Mysql error, resulting in video dbase not upgraded and not used - Klojum - 2018-09-06

(2018-09-06, 12:54)bartmans Wrote: Do you need a new one?
Yes please, that ticket concerns older databases and a different sql server.

RE: On updating I get Mysql error, resulting in video dbase not upgraded and not used - bartmans - 2018-09-06

Done.

https://trac.kodi.tv/ticket/18024