Opened 11 years ago
Closed 10 years ago
#11915 closed Bug Report - General (Won't Fix)
tried to delete a couple bogus channels after complete channel scan
| Reported by: | Owned by: | Rob Smith | |
|---|---|---|---|
| Priority: | minor | Milestone: | 0.28 |
| Component: | Plugin - MythWeb | Version: | Master Head |
| Severity: | medium | Keywords: | |
| Cc: | Ticket locked: | no |
Description
datetime: 2013-10-20 00:25:44 (CDT) errornum: 256
error type: User Error
error string: !NoTrans: SQL Error: Incorrect integer value: for column 'finetune' at row 1 #1366!!
filename: /var/www/html/mythweb/classes/Database/Query/mysql.php
error line: 79
==========================================================================
Backtrace:
file: /var/www/html/mythweb/classes/Database/Query/mysql.php line: 79
class:
function: trigger_error
type: args: Array
(
[0] => SQL Error: Incorrect integer value: for column 'finetune' at row 1 #1366 [1] => 256
)
file: /var/www/html/mythweb/classes/Database.php line: 261
class: Database_Query_mysql
function: execute
type: -> args: Array
(
[0] => Array
(
[0] => Array
(
[0] => [1] => 28 [2] => [3] => [4] => 32768 [5] => 32768 [6] => 32768 [7] => 32768 [8] => 0 [9] => -1 [10] => 1 [11] => 1 [12] => 4_1 [13] => WTMJ-DT [14] => WTMJ-DT
)
[1] => 1041
)
)
file: /var/www/html/mythweb/modules/tv/set_channels.php line: 62
class: Database
function: query
type: -> args: Array
(
[0] => UPDATE channel SET xmltvid = ?,
freqid = ?, finetune = ?, videofilters = ?, brightness = ?, contrast = ?, colour = ?, hue = ?, recpriority = ?, commmethod = ?, useonairguide = ?, visible = ?,channum=?,callsign=?,name=? WHERE chanid=?
[1] => Array
(
[0] => [1] => 28 [2] => [3] => [4] => 32768 [5] => 32768 [6] => 32768 [7] => 32768 [8] => 0 [9] => -1 [10] => 1 [11] => 1 [12] => 4_1 [13] => WTMJ-DT [14] => WTMJ-DT
)
[2] => 1041
)
file: /var/www/html/mythweb/modules/settings/handler.php line: 54
class:
function: require_once
type: args: Array
(
[0] => /var/www/html/mythweb/modules/tv/set_channels.php
)
file: /var/www/html/mythweb/mythweb.php line: 35
class:
function: require_once
type: args: Array
(
[0] => /var/www/html/mythweb/modules/settings/handler.php
)
==========================================================================
$_POST: Array (
[channel] => Array
(
[1041] => Array
(
[xmltvid] => [channum] => 4_1 [callsign] => WTMJ-DT [name] => WTMJ-DT [freqid] => 28 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1042] => Array
(
[xmltvid] => [channum] => 4_2 [callsign] => WTMJ-WX [name] => WTMJ-WX [freqid] => 28 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1043] => Array
(
[xmltvid] => [channum] => 4_3 [callsign] => LWNet [name] => LWNet [freqid] => 28 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1061] => Array
(
[xmltvid] => [channum] => 6_1 [callsign] => WITI-DT [name] => 6-1 WITI-DT [freqid] => 33 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1062] => Array
(
[xmltvid] => [channum] => 6_2 [callsign] => WITI-DT [name] => 6-2 WITI-DT [freqid] => 33 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1093] => Array
(
[delete] => true [xmltvid] => [channum] => 8-13 [callsign] => 1093 [name] => [freqid] => 8 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1
)
[1094] => Array
(
[delete] => true [xmltvid] => [channum] => 8-14 [callsign] => 1094 [name] => [freqid] => 8 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1
)
[1101] => Array
(
[xmltvid] => [channum] => 10_1 [callsign] => WMVS HD [name] => WMVS HD [freqid] => 8 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1111] => Array
(
[xmltvid] => [channum] => 10_11 [callsign] => WMVS HD [name] => WMVS HD [freqid] => 36 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1112] => Array
(
[xmltvid] => [channum] => 10_12 [callsign] => WORLD [name] => WORLD [freqid] => 36 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1113] => Array
(
[xmltvid] => [channum] => 10_13 [callsign] => V-me [name] => V-me [freqid] => 36 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1114] => Array
(
[xmltvid] => [channum] => 10_14 [callsign] => Weather [name] => Weather [freqid] => 36 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1102] => Array
(
[xmltvid] => [channum] => 10_2 [callsign] => WORLD [name] => WORLD [freqid] => 8 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1103] => Array
(
[xmltvid] => [channum] => 10_3 [callsign] => V-me [name] => V-me [freqid] => 8 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1104] => Array
(
[xmltvid] => [channum] => 10_4 [callsign] => Weather [name] => Weather [freqid] => 8 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1121] => Array
(
[xmltvid] => [channum] => 12_1 [callsign] => WISN-TV [name] => WISN-TV [freqid] => 34 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1181] => Array
(
[xmltvid] => [channum] => 18_1 [callsign] => CW 18 [name] => CW 18 [freqid] => 18 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1241] => Array
(
[xmltvid] => [channum] => 24_1 [callsign] => My 24 [name] => My 24 [freqid] => 25 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1242] => Array
(
[xmltvid] => [channum] => 24_2 [callsign] => ZUUSc [name] => ZUUSc [freqid] => 25 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1301] => Array
(
[xmltvid] => [channum] => 30_1 [callsign] => WVCY-TV [name] => WVCY-TV [freqid] => 22 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1361] => Array
(
[xmltvid] => [channum] => 36_1 [callsign] => WMVT HD [name] => WMVT HD [freqid] => 35 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1362] => Array
(
[xmltvid] => [channum] => 36_2 [callsign] => WMVS SD [name] => WMVS SD [freqid] => 35 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1363] => Array
(
[xmltvid] => [channum] => 36_3 [callsign] => Create [name] => Create [freqid] => 35 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1364] => Array
(
[xmltvid] => [channum] => 36_4 [callsign] => Classic [name] => Classic [freqid] => 35 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1365] => Array
(
[xmltvid] => [channum] => 36_5 [callsign] => Jazz [name] => Jazz [freqid] => 35 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1366] => Array
(
[xmltvid] => [channum] => 36_6 [callsign] => Traffic [name] => Traffic [freqid] => 35 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1411] => Array
(
[xmltvid] => [channum] => 41_1 [callsign] => WBME [name] => WBME [freqid] => 24 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1491] => Array
(
[xmltvid] => [channum] => 49_1 [callsign] => WMLW [name] => WMLW [freqid] => 48 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1492] => Array
(
[xmltvid] => [channum] => 49_2 [callsign] => Bounce [name] => WMLW-DT2 [freqid] => 48 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1493] => Array
(
[xmltvid] => [channum] => 49_3 [callsign] => MOVIES! [name] => WMLW-DT3 [freqid] => 48 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1494] => Array
(
[xmltvid] => [channum] => 49_4 [callsign] => TeleWI [name] => Wisconsin's Telemundo [freqid] => 48 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1551] => Array
(
[xmltvid] => [channum] => 55_1 [callsign] => ION [name] => WPXE ION [freqid] => 40 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1552] => Array
(
[xmltvid] => [channum] => 55_2 [callsign] => qubo [name] => WPXE qubo [freqid] => 40 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1553] => Array
(
[xmltvid] => [channum] => 55_3 [callsign] => IONLife [name] => WPXE ION Life [freqid] => 40 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1554] => Array
(
[xmltvid] => [channum] => 55_4 [callsign] => Shop [name] => WPXE Shop [freqid] => 40 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1555] => Array
(
[xmltvid] => [channum] => 55_5 [callsign] => QVC [name] => WPXE QVC [freqid] => 40 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1581] => Array
(
[xmltvid] => [channum] => 58_1 [callsign] => WDJT HD [name] => WDJT HD [freqid] => 46 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1582] => Array
(
[xmltvid] => [channum] => 58_2 [callsign] => WBME [name] => ME TV [freqid] => 46 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1583] => Array
(
[xmltvid] => [channum] => 58_3 [callsign] => ThisTV [name] => WDJT DT3 [freqid] => 46 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1584] => Array
(
[xmltvid] => [channum] => 58_4 [callsign] => Touch [name] => TouchVision? [freqid] => 46 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1631] => Array
(
[xmltvid] => [channum] => 63_1 [callsign] => WYTU [name] => Telemundo HD [freqid] => 17 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
[1681] => Array
(
[xmltvid] => [channum] => 68_1 [callsign] => WIWN-TV [name] => WIWN-TV [freqid] => 5 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1
)
)
[save] => Save
)
==========================================================================
$_SESSION: Array (
[language] => English [date_statusbar] => %a %b %e, %Y, %I:%M %p [date_scheduled] => %a %b %e, %Y (%I:%M %p) [date_scheduled_popup] => %a %b %e, %Y [date_recorded] => %a %b %e, %Y (%I:%M %p) [date_search] => %a %b %e, %Y, %I:%M %p [date_listing_key] => %a %b %e, %Y, %I:%M %p [date_listing_jump] => %a %b %e, %Y [date_channel_jump] => %a %b %e, %Y [date_job_status] => %a %b %e, %Y, %I:%M %p [time_format] => %I:%M %p [cache_engine] => Cache_Null [stream] => Array
(
[include_user_and_password] =>
)
[prefer_channum] => 1 [recorded_pixmaps] => 1 [guide_favonly] => [timeslot_size] => 300 [num_time_slots] => 36 [timeslot_blocks] => 3 [timeslotbar_skip] => 10 [max_stars] => 4 [star_character] => ★ [show_popup_info] => 1 [show_channel_icons] => 1 [sortby_channum] => 1 [recorded_paging] => null [genre_colors] => 1 [show_video_covers] => 1 [settings] => Array
(
[screens] => Array
(
[tv] => Array
(
[upcoming recordings] => Array
(
[title] => on [channel] => on [record date] => on [length] => on
)
)
)
[last] => Array
(
)
[host] => mythtv
)
[backend] => Array
(
[timezone] => Array
(
[value] => America/Chicago? [last_check_time] => 1382238158
)
[192.168.3.2] => Array
(
[proto_version] => Array
(
[last_check_version] => 77 [last_check_time] => 1382246645
)
)
)
[tv] => Array
(
[last] => Array
(
[0] => search
)
)
[list_time] => 1382246100 [scheduled_recordings] => Array
(
[disp_scheduled] => 1 [disp_duplicates] => 1 [disp_deactivated] => [disp_conflicts] => 1 [disp_recgroup] => [disp_title] =>
)
[search] => Array
(
[s] => superhero [type] => q [ctype] => Array
(
[0] => [1] => movie [2] => series [3] => sports [4] => tvshow
)
[categories] => Array ( ) [stars_gt] => 0 [stars_lt] => 1 [starttime] => now [endtime] => + 2 weeks [as] => Array
(
[0] => fringe
)
[af] => Array
(
[0] => Array
(
[0] => title
)
)
[aj] => Array
(
[0] => AND
)
[hd] => [commfree] => [unwatched] => [scheduled] => [generic] => [distinctTitle] => [airdate_start] => [airdate_end] =>
)
[scheduled_sortby] => Array
(
[0] => Array
(
[field] => airdate [reverse] =>
)
[1] => Array
(
[field] => title [reverse] =>
)
)
[recorded_sortby] => Array
(
[0] => Array
(
[field] => airdate [reverse] => 1
)
[1] => Array
(
[field] => title [reverse] =>
)
)
[search_sortby] => Array
(
[0] => Array
(
[field] => airdate [reverse] =>
)
[1] => Array
(
[field] => title [reverse] =>
)
)
[video_sortby] => Array
(
[0] => Array
(
[field] => title [reverse] =>
)
)
[video] => Array
(
[browse] => -1 [VideoAdminPassword?] => [path] => /Movies/dvd
)
[schedules_sortby] => Array
(
[0] => Array
(
[field] => airdate [reverse] =>
)
[1] => Array
(
[field] => title [reverse] =>
)
)
[recording_details] => Array
(
[show_Conflict] => 1 [show_PreviousRecording] => 1 [show_EarlierShowing] => 1 [show_CurrentRecording] => 1 [show_WillRecord] => 1
)
[file_url_override] => [recorded_title] => [recorded_recgroup] =>
)
==========================================================================
$_SERVER: Array (
[REDIRECT_STATUS] => 200 [hostname] => mythdvr [include_path] => /usr/share/mythweb [HTTP_HOST] => 192.168.3.2 [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Firefox/24.0 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5 [HTTP_ACCEPT_ENCODING] => gzip, deflate [HTTP_REFERER] => http://192.168.3.2/mythweb/settings/tv/channels [HTTP_COOKIE] => mythweb_id=pqb3j56rar0f26dba60t8v35mp8ajbmq44ipnpd0d05dh59k46u1 [HTTP_CONNECTION] => keep-alive [HTTP_CACHE_CONTROL] => max-age=0 [CONTENT_TYPE] => application/x-www-form-urlencoded [CONTENT_LENGTH] => 21066 [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin [SERVER_SIGNATURE] => <address>Apache/2.4.6 (Linux/SUSE) Server at 192.168.3.2 Port 80</address>
[SERVER_SOFTWARE] => Apache/2.4.6 (Linux/SUSE) [SERVER_NAME] => 192.168.3.2 [SERVER_ADDR] => 192.168.3.2 [SERVER_PORT] => 80 [REMOTE_ADDR] => 192.168.3.200 [DOCUMENT_ROOT] => /var/www/html [REQUEST_SCHEME] => http [CONTEXT_PREFIX] => [CONTEXT_DOCUMENT_ROOT] => /var/www/html [SERVER_ADMIN] => root@mythdvr [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php [REMOTE_PORT] => 53449 [REDIRECT_URL] => /mythweb/settings/tv/channels [GATEWAY_INTERFACE] => CGI/1.1 [SERVER_PROTOCOL] => HTTP/1.1 [REQUEST_METHOD] => POST [QUERY_STRING] => [REQUEST_URI] => /settings/tv/channels [SCRIPT_NAME] => /mythweb/mythweb.php [PATH_INFO] => /settings/tv/channels [PATH_TRANSLATED] => /var/www/html/settings/tv/channels [PHP_SELF] => /mythweb/mythweb.php/settings/tv/channels [REQUEST_TIME_FLOAT] => 1382246744.21 [REQUEST_TIME] => 1382246744 [STATUS] => 200 [URL] => /mythweb/settings/tv/channels [HTTP_PORT] => 80
)
==========================================================================
$constant_listuser?: Array (
[ERROR] => 512 [E_ASSERT_ERROR] => 4096 [FATAL] => 256 [PHP_MIN_VERSION] => 5.3 [WARNING] => 1024 [WebDBSchemaVer] => 4 [error_email] => [form_action] => http://192.168.3.2/mythweb/settings/tv/channels [gb] => 1073741824 [hostname] => mythdvr [http_host] => 192.168.3.2 [kb] => 1024 [max_stars] => 4 [mb] => 1048576 [module] => settings [modules_path] => /var/www/html/mythweb/modules [num_time_slots] => 36 [prefer_channum] => 1 [root] => /mythweb/ [root_auth_url] => http://192.168.3.2/mythweb/ [root_url] => http://192.168.3.2/mythweb/ [skin] => default [skin_img_url] => http://192.168.3.2/mythweb/skins/default/img/ [skin_url] => http://192.168.3.2/mythweb/skins/default/ [star_character] => ★ [stream_url] => http://192.168.3.2:80//mythweb/ [tb] => 1099511627776 [timeslot_blocks] => 3 [timeslot_size] => 300 [timeslotbar_skip] => 10 [tmpl] => default [tmpl_dir] => modules/settings/tmpl/default/
)
Given Mythweb is EOL, I'm closing new features. This should be done via the backend webserver now.