Kodi Community Forum

Hey All,

I recently installed mysql 5.1 and have everything working well, with the exception of resume/restart.

I see the error in the logs.

11:31:40 T:140525357233920 NOTICE: Universal - An Addons Toolkit: -playbackengine- -playedTime / totalTime : 1212.42004395 / 2523.48022461 = 0.480455536018
11:31:40 T:140525357233920 NOTICE: Universal - An Addons Toolkit: -playbackengine- -Threshold not met. Saving bookmark
11:31:40 T:140526164014976 NOTICE: CDVDPlayer::CloseFile()
11:31:40 T:140526164014976 WARNING: CDVDMessageQueue(player):ut MSGQ_NOT_INITIALIZED
11:31:40 T:140526164014976 NOTICE: DVDPlayer: waiting for threads to exit
11:31:40 T:140526164014976 NOTICE: DVDPlayer: finished waiting
11:31:40 T:140525357233920 ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<--
- NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS!
Error Type: <class 'mysql.connector.errors.OperationalError'>
Error Contents: 1406: Data too long for column 'bookmark' at row 1
Traceback (most recent call last):
File "/home/marty/.xbmc/addons/script.module.universal/lib/universal/playbackengine.py", line 330, in onPlayBackStopped
self.dbcur.execute(sql_insert_or_replace, (self.hash, self.addon_id, self.video_type, self.title, self.season, self.episode, self.year, playedTime))
File "/home/marty/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/cursor.py", line 314, in execute
res = self.db().protocol.cmd_query(stmt)
File "/home/marty/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/protocol.py", line 136, in deco
return func(*args, **kwargs)
File "/home/marty/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/protocol.py", line 479, in cmd_query
return self.handle_cmd_result(self.conn.recv())
File "/home/marty/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/connection.py", line 179, in recv_plain
errors.raise_error(buf)
File "/home/marty/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/errors.py", line 82, in raise_error
raise get_mysql_exception(errno,errmsg)
OperationalError: 1406: Data too long for column 'bookmark' at row 1
-->End of Python script error report<--
11:31:40 T:140525306877696 NOTICE: Thread Jobworker start, auto delete: true
11:31:40 T:140525595883264 NOTICE: Universal - An Addons Toolkit: -playbackengine- -Position tracker ending with lastPos = 1212.42004395
1

Any ideas on a fix? Obviously I could try to resize the column, but I dont know what table it is referring to...

Cheers!

Found it. Resized it and all is well, but curious as to why it was too small? Was varchar 10 - modified to 20 and all is well. Xbmc created the table originally...

Any thoughts?

Steps to resolve:
From mysql terminal, run these
USE XBMC_UNIVERSAL;
ALTER bookmarks MODIFY bookmark VARCHAR(20);