Modify

Opened 3 years ago

Closed 3 weeks ago

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

Recommendations not working.

Reported by: staticex@… Owned by: stuarta
Priority: minor Milestone: 0.28.2
Component: Plugin - MythWeb Version: 0.28.0
Severity: medium Keywords: Recomendations
Cc: Ticket locked: no

Description

When trying to use recomendations I get;

datetime: 2015-08-02 15:55:24 (BST) errornum: 256

error type: User Error

error string: !NoTrans: SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY program.title ORDER BY program.starttime' at line 13 #1064!!

filename: /data/srv/httpd/mythweb/classes/Database/Query/mysql.php

error line: 79

==========================================================================

Backtrace:

file: /data/srv/httpd/mythweb/classes/Database/Query/mysql.php line: 79

class:

function: trigger_error

type: args: Array

(

[0] => SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')

GROUP BY program.title ORDER BY program.starttime' at line 13 #1064

[1] => 256

)

file: /data/srv/httpd/mythweb/classes/Database.php line: 261

class: Database_Query_mysql

function: execute

type: -> args: Array

(

[0] => Array ( )

)

file: /data/srv/httpd/mythweb/modules/tv/includes/programs.php line: 140

class: Database

function: query

type: -> args: Array

(

[0] => SELECT program.*,

UNIX_TIMESTAMP(program.starttime) AS starttime_unix, UNIX_TIMESTAMP(program.endtime) AS endtime_unix, IFNULL(programrating.system, "") AS rater, IFNULL(programrating.rating, "") AS rating, channel.callsign, channel.channum

FROM program USE INDEX (id_start_end)

LEFT JOIN programrating USING (chanid, starttime) LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN credits ON (program.chanid = credits.chanid AND program.starttime = credits.starttime) LEFT JOIN people ON (credits.person = people.person)

WHERE program.chanid IN (1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1046,1047,1048,1049,1055,1057,1059,1061,1062,1063,1064,1065,1066,1068,1069,1070,1072,1076,1120,1121,1122,1125,1126,1130,1131,1132,1133,1135,1170,1171,1172,1173,1174,1175,1176,1177,1182,1199,1200,1601,1794) AND (program.endtime > FROM_UNIXTIME('1438527324') AND program.starttime < FROM_UNIXTIME('1441205724') AND program.starttime != program.endtime) AND ()

GROUP BY program.title ORDER BY program.starttime )

file: /data/srv/httpd/mythweb/modules/tv/recommended.php line: 38

class:

function: load_all_program_data

type: args: Array

(

[0] => 1438527324 [1] => 1441205724 [2] => [3] => [4] => () [5] => 1

)

file: /data/srv/httpd/mythweb/modules/tv/handler.php line: 82

class:

function: require_once

type: args: Array

(

[0] => /data/srv/httpd/mythweb/modules/tv/recommended.php

)

file: /data/srv/httpd/mythweb/mythweb.php line: 35

class:

function: require_once

type: args: Array

(

[0] => /data/srv/httpd/mythweb/modules/tv/handler.php

)

==========================================================================

$_SESSION: Array (

[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] => 20 [max_stars] => 4 [star_character] => &#9733; [show_popup_info] => 1 [show_channel_icons] => 1 [sortby_channum] => 1 [recorded_paging] => [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] => mythweb [1] => recommend

)

)

[backend] => Array

(

[timezone] => Array

(

[value] => GB [last_check_time] => 1438527039

)

[192.168.0.11] => Array

(

[proto_version] => Array

(

[last_check_version] => 77 [last_check_time] => 1438527039

)

)

)

[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 [tv] => Array

(

[last] => Array

(

[0] => recommended

)

)

[recorded_recgroup] => LiveTV [recorded_sortby] => Array

(

[0] => Array

(

[field] => airdate [reverse] => 1

)

[1] => Array

(

[field] => title [reverse] =>

)

)

[schedules_sortby] => Array

(

[0] => Array

(

[field] => airdate [reverse] =>

)

[1] => Array

(

[field] => title [reverse] =>

)

)

[search] => Array

(

[type] => q [s] => New Adventures Of Wonder Woman$ [ctype] => Array

(

[0] => movie [1] => series [2] => sports [3] => tvshow

)

[categories] => Array ( ) [stars_gt] => 0 [stars_lt] => 1 [starttime] => now [endtime] => + 2 weeks [as] => Array

(

[0] =>

)

[af] => Array

(

[0] => Array

(

[0] => title

)

)

[aj] => Array

(

[0] => AND

)

)

[search_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

)

[list_time] => 1438526700 [scheduled_recordings] => Array

(

[disp_scheduled] => 1 [disp_duplicates] => [disp_deactivated] => [disp_conflicts] => 1 [disp_recgroup] => [disp_title] =>

)

[scheduled_sortby] => Array

(

[0] => Array

(

[field] => airdate [reverse] =>

)

[1] => Array

(

[field] => title [reverse] =>

)

)

[video_sortby] => Array

(

[0] => Array

(

[field] => title [reverse] =>

)

)

)

==========================================================================

$_SERVER: Array (

[TERM] => linux [PATH] => /usr/local/bin:/usr/bin [PWD] => /etc/sv/lighttpd [LANG] => en_US.UTF-8 [SHLVL] => 0 [PHP_FCGI_CHILDREN] => 1 [ORIG_PATH_TRANSLATED] => /data/srv/httpd/mythwebtv/recommended [ORIG_SCRIPT_FILENAME] => /data/srv/httpd/mythwebmythweb.php/tv/recommended [DB_PASSWORD] => mythtv [DB_LOGIN] => mythtv [DB_NAME] => mythconverg [DB_SERVER] => localhost [HTTP_CONNECTION] => keep-alive [HTTP_COOKIE] => mythweb_id=vor195stvhrr5d5jui098hk5f7 [HTTP_REFERER] => http://192.168.0.11/mythweb/status [HTTP_DNT] => 1 [HTTP_ACCEPT_ENCODING] => gzip, deflate [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 [HTTP_USER_AGENT] => Mozilla/5.0 (X11; Linux x86_64; rv:39.0) Gecko/20100101 Firefox/39.0 [HTTP_HOST] => 192.168.0.11 [SERVER_PROTOCOL] => HTTP/1.1 [REDIRECT_STATUS] => 200 [REQUEST_METHOD] => GET [QUERY_STRING] => [REDIRECT_URI] => /mythweb/mythweb.php/tv/recommended [REQUEST_URI] => /tv/recommended [DOCUMENT_ROOT] => /data/srv/httpd/mythweb [SCRIPT_FILENAME] => /data/srv/httpd/mythwebmythweb.php [PATH_TRANSLATED] => /data/srv/httpd/mythweb/tv/recommended [PATH_INFO] => /tv/recommended [SCRIPT_NAME] => /mythweb/mythweb.php [REMOTE_ADDR] => 192.168.0.10 [REMOTE_PORT] => 59491 [SERVER_ADDR] => 192.168.0.11 [SERVER_PORT] => 80 [GATEWAY_INTERFACE] => CGI/1.1 [SERVER_NAME] => 192.168.0.11 [SERVER_SOFTWARE] => lighttpd/1.4.35 [FCGI_ROLE] => RESPONDER [PHP_SELF] => /mythweb/mythweb.php/tv/recommended [REQUEST_TIME_FLOAT] => 1438527323.7843 [REQUEST_TIME] => 1438527323 [STATUS] => 200 [URI] => /mythweb/mythweb.php/tv/recommended [HTTP_PORT] => 80

)

==========================================================================

$constant_listuser?: Array (

[ERROR] => 512 [E_ASSERT_ERROR] => 4096 [FATAL] => 256 [PHP_MIN_VERSION] => 5.3 [WARNING] => 1024 [WebDBSchemaVer] => 4 [dupsin_all] => 15 [dupsin_newepisodes] => 16 [dupsin_oldrecorded] => 2 [dupsin_recorded] => 1 [error_email] => [gb] => 1073741824 [hostname] => mythtv [http_host] => 192.168.0.11 [kb] => 1024 [max_stars] => 4 [mb] => 1048576 [module] => tv [modules_path] => /data/srv/httpd/mythweb/modules [num_time_slots] => 36 [prefer_channum] => 1 [rectype_always] => 4 [rectype_daily] => 2 [rectype_dontrec] => 8 [rectype_findone] => 6 [rectype_once] => 1 [rectype_override] => 7 [rectype_template] => 11 [rectype_weekly] => 5 [root] => /mythweb/ [root_auth_url] => http://192.168.0.11/mythweb/ [root_url] => http://192.168.0.11/mythweb/ [searchtype_keyword] => 3 [searchtype_manual] => 5 [searchtype_people] => 4 [searchtype_power] => 1 [searchtype_title] => 2 [skin] => default [skin_img_url] => http://192.168.0.11/mythweb/skins/default/img/ [skin_url] => http://192.168.0.11/mythweb/skins/default/ [star_character] => &#9733; [stream_url] => http://192.168.0.11:80//mythweb/ [tb] => 1099511627776 [timeslot_blocks] => 3 [timeslot_size] => 300 [timeslotbar_skip] => 20 [tmpl] => default [tmpl_dir] => modules/tv/tmpl/default/

)

usting linHES 8.3 (Myth)

Attachments (1)

fix_12482_mythweb_recommend_enabled.patch (841 bytes) - added by Patrick Mansfield <patman@…> 15 months ago.
Patch to fix the problem.

Download all attachments as: .zip

Change History (5)

Changed 15 months ago by Patrick Mansfield <patman@…>

Patch to fix the problem.

comment:1 Changed 15 months ago by Patrick Mansfield <patman@…>

My patch fixes the problem where trying to enable recommended videos via mythweb fails.

It's hard to tell from the initial report if it's the same thing I was hitting and that the attached patch fixes.

I'm using current mythweb, git branch fixes/0.28 but the fix applies cleanly to master.

I'm running on an up to date Fedora 23 system, with mariadb, and mythtv built from git branch fixes/0.28

To reproduce, got to mythweb settings, "MythWeb", tab "Recommend Videos", uncheck "Enable" and click save.

comment:2 Changed 15 months ago by stuarta

  • Component changed from MythTV - General to Plugin - MythWeb
  • Milestone changed from unknown to 0.28.1
  • Owner set to stuarta
  • Version changed from Unspecified to 0.28.0

I can get this put in to fix the mythweb error, but I don't think the actual service is running anymore.

comment:3 Changed 13 months ago by stuarta

  • Milestone changed from 0.28.1 to 0.28.2

Moving remaining open 0.28.1 tickets to 0.28.2

comment:4 Changed 3 weeks ago by stuarta

  • Resolution set to Won't Fix
  • Status changed from new to closed

Closing any remaining tickets for 0.28, if the issue persists, feel free to reopen and align to v29 or master

Add Comment

Modify Ticket

Action
as closed The owner will remain stuarta.
The resolution will be deleted. Next status will be 'new'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.