home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
HTPC Projects
Software
Tools and other software
[How To] [User Exp] Update MySQL
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="megahorst" data-source="post: 969958" data-attributes="member: 22213"><p>That is strange ...</p><p>This did not work for me.</p><p> </p><p>Did you get an ok message in the log?</p><p> </p><p>Here are my table definitions. Are yours the same?</p><p> </p><p>[code]desc mptvdb.schedule [/code]</p><p><strong>field type null key default</strong></p><p>id_Schedule int(11) NO PRI auto_increment</p><p>idChannel int(11) NO MUL </p><p>scheduleType int(11) NO MUL </p><p>programName varchar(256) NO MUL </p><p>startTime datetime NO MUL </p><p>endTime datetime NO MUL </p><p>maxAirings int(11) NO </p><p>priority int(11) NO </p><p>directory varchar(1024) NO </p><p>quality int(11) NO </p><p>keepMethod int(11) NO </p><p>keepDate datetime NO </p><p>preRecordInterval int(11) NO </p><p>postRecordInterval int(11) NO </p><p>canceled datetime NO </p><p>recommendedCard int(11) NO </p><p>series bit(1) NO </p><p>idParentSchedule int(11) NO 0</p><p> </p><p>[code]desc mptvdb.recording [/code]</p><p><strong>field type null key default</strong></p><p>idRecording int(11) NO PRI auto_increment</p><p>idChannel int(11) NO MUL </p><p>startTime datetime NO </p><p>endTime datetime NO </p><p>title varchar(2000) NO </p><p>description varchar(8000) NO </p><p>genre varchar(200) NO </p><p>fileName varchar(260) NO MUL </p><p>keepUntil int(11) NO </p><p>keepUntilDate datetime NO </p><p>timesWatched int(11) NO </p><p>idServer int(11) NO MUL </p><p>stopTime int(11) NO </p><p>episodeName text NO </p><p>seriesNum varchar(200) NO </p><p>episodeNum varchar(200) NO </p><p>episodePart text NO </p><p>isRecording bit(1) NO b'0'</p><p>idSchedule int(11) NO 0</p></blockquote><p></p>
[QUOTE="megahorst, post: 969958, member: 22213"] That is strange ... This did not work for me. Did you get an ok message in the log? Here are my table definitions. Are yours the same? [code]desc mptvdb.schedule [/code] [B]field type null key default[/B] id_Schedule int(11) NO PRI auto_increment idChannel int(11) NO MUL scheduleType int(11) NO MUL programName varchar(256) NO MUL startTime datetime NO MUL endTime datetime NO MUL maxAirings int(11) NO priority int(11) NO directory varchar(1024) NO quality int(11) NO keepMethod int(11) NO keepDate datetime NO preRecordInterval int(11) NO postRecordInterval int(11) NO canceled datetime NO recommendedCard int(11) NO series bit(1) NO idParentSchedule int(11) NO 0 [code]desc mptvdb.recording [/code] [B]field type null key default[/B] idRecording int(11) NO PRI auto_increment idChannel int(11) NO MUL startTime datetime NO endTime datetime NO title varchar(2000) NO description varchar(8000) NO genre varchar(200) NO fileName varchar(260) NO MUL keepUntil int(11) NO keepUntilDate datetime NO timesWatched int(11) NO idServer int(11) NO MUL stopTime int(11) NO episodeName text NO seriesNum varchar(200) NO episodeNum varchar(200) NO episodePart text NO isRecording bit(1) NO b'0' idSchedule int(11) NO 0 [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
HTPC Projects
Software
Tools and other software
[How To] [User Exp] Update MySQL
Contact us
RSS
Top
Bottom