Opened 6 years ago

Closed 5 years ago

#11915 closed Bug Report - General (Won't Fix)

tried to delete a couple bogus channels after complete channel scan

Reported by: spamme@… 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

(

[0] => tv [1] => channels

)

[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] => &#9733; [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/

)

Change History (1)

comment:1 Changed 5 years ago by Rob Smith

Resolution: Won't Fix
Status: newclosed

Given Mythweb is EOL, I'm closing new features. This should be done via the backend webserver now.

Note: See TracTickets for help on using tickets.