API tools faq
paste
Advertisement
Guest User

Mythweb recommended programs SQL error backtrace

a guest
Oct 8th, 2013
133
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.69 KB | None | 0 0
raw download clone embed print report
  1. datetime: 2013-10-08 09:15:57 (PDT)
  2. errornum: 256
  3. error type: User Error
  4. 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 ')
  5. GROUP BY program.title ORDER BY program.starttime' at line 13 [#1064]!!
  6. filename: /var/www/localhost/htdocs/mythweb/classes/Database/Query/mysql.php
  7. error line: 79
  8.  
  9. ==========================================================================
  10.  
  11. Backtrace:
  12.  
  13. file: /var/www/localhost/htdocs/mythweb/classes/Database/Query/mysql.php
  14. line: 79
  15. class:
  16. function: trigger_error
  17. type:
  18. args: Array
  19. (
  20. [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 ')
  21. GROUP BY program.title ORDER BY program.starttime' at line 13 [#1064]
  22. [1] => 256
  23. )
  24.  
  25. file: /var/www/localhost/htdocs/mythweb/classes/Database.php
  26. line: 261
  27. class: Database_Query_mysql
  28. function: execute
  29. type: ->
  30. args: Array
  31. (
  32. [0] => Array ( )
  33. )
  34.  
  35. file: /var/www/localhost/htdocs/mythweb/modules/tv/includes/programs.php
  36. line: 140
  37. class: Database
  38. function: query
  39. type: ->
  40. args: Array
  41. (
  42. [0] => SELECT program.*,
  43. UNIX_TIMESTAMP(program.starttime) AS starttime_unix,
  44. UNIX_TIMESTAMP(program.endtime) AS endtime_unix,
  45. IFNULL(programrating.system, "") AS rater,
  46. IFNULL(programrating.rating, "") AS rating,
  47. channel.callsign,
  48. channel.channum
  49. FROM program USE INDEX (id_start_end)
  50. LEFT JOIN programrating USING (chanid, starttime)
  51. LEFT JOIN channel ON program.chanid = channel.chanid
  52. LEFT JOIN credits ON (program.chanid = credits.chanid AND program.starttime = credits.starttime)
  53. LEFT JOIN people ON (credits.person = people.person)
  54. WHERE program.chanid IN (1001,1002,1003,1004,1005,1006,1007,2008,1009,1012,1013,1014,1015,1016,2017,1018,1019,1020,2021,1022,1025,1029,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1049,1050,1995,2051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1990,1072,1073,1074,1081,2104,1107,2108,1109,1110,2111,1119,1120,1996,1121,1993,1123,1126,1128,1130,1135,3000,1146,1149,1150,1159,1160,1161,1877,1166,1167,2175,2180,2181,1182,1183,1185,2186,2188,2189,2190,1192,1193,2195,1196,2202,1204,1205,1215,1216,1220,1222,1228,1229,1230,1231,1234,1270,1271,1272,1273,1274,1275,1276,1292,1402,1406,1408,1409,1412,1416,1417,1418,1419,1420,1471,1472,1473,1474,1476,2478,2480,1482,1483,1484,1486,1500,1501,1502,1503,1504,1505,1513,1514,1516,1518,1520,1522,1524,1528,1530,1534,1536,1537,1538,1539,1540,1550,1551,1553,1555,1557,1559,1560,1997,1998,1992,1606,1607,1748,1871,1872,1873,1901,1902,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1946,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,2999) AND (program.endtime > FROM_UNIXTIME('1381248957') AND program.starttime < FROM_UNIXTIME('1383930957') AND program.starttime != program.endtime) AND ()
  55. GROUP BY program.title ORDER BY program.starttime
  56. )
  57.  
  58. file: /var/www/localhost/htdocs/mythweb/modules/tv/recommended.php
  59. line: 38
  60. class:
  61. function: load_all_program_data
  62. type:
  63. args: Array
  64. (
  65. [0] => 1381248957
  66. [1] => 1383930957
  67. [2] =>
  68. [3] =>
  69. [4] => ()
  70. [5] => 1
  71. )
  72.  
  73. file: /var/www/localhost/htdocs/mythweb/modules/tv/handler.php
  74. line: 82
  75. class:
  76. function: require_once
  77. type:
  78. args: Array
  79. (
  80. [0] => /var/www/localhost/htdocs/mythweb/modules/tv/recommended.php
  81. )
  82.  
  83. file: /var/www/localhost/htdocs/mythweb/mythweb.php
  84. line: 35
  85. class:
  86. function: require_once
  87. type:
  88. args: Array
  89. (
  90. [0] => /var/www/localhost/htdocs/mythweb/modules/tv/handler.php
  91. )
  92.  
  93.  
  94. ==========================================================================
  95.  
  96. $_SESSION: Array
  97. (
  98. [language] => English
  99. [tmpl] => default
  100. [skin] => default
  101. [prefer_channum] => 1
  102. [date_statusbar] => %a %b %e, %Y, %I:%M %p
  103. [date_scheduled] => %a %b %e, %Y (%I:%M %p)
  104. [date_scheduled_popup] => %a %b %e, %Y
  105. [date_recorded] => %a %b %e, %Y (%I:%M %p)
  106. [date_search] => %a %b %e, %Y, %I:%M %p
  107. [date_listing_key] => %a %b %e, %Y, %I:%M %p
  108. [date_listing_jump] => %a %b %e, %Y
  109. [date_channel_jump] => %a %b %e, %Y
  110. [time_format] => %I:%M %p
  111. [recorded_pixmaps] => 1
  112. [guide_favonly] =>
  113. [timeslot_size] => 300
  114. [num_time_slots] => 36
  115. [timeslot_blocks] => 3
  116. [timeslotbar_skip] => 20
  117. [max_stars] => 4
  118. [star_character] => &diams;
  119. [siunits] => YES
  120. [scheduled_recordings] => Array
  121. (
  122. [disp_scheduled] => 1
  123. [disp_duplicates] =>
  124. [disp_deactivated] =>
  125. [disp_conflicts] => 1
  126. [disp_recgroup] =>
  127. [disp_title] =>
  128. )
  129.  
  130. [scheduled_sortby] => Array
  131. (
  132. [0] => Array
  133. (
  134. [field] => airdate
  135. [reverse] =>
  136. )
  137.  
  138. [1] => Array
  139. (
  140. [field] => title
  141. [reverse] =>
  142. )
  143.  
  144. )
  145.  
  146. [recorded_title] =>
  147. [recorded_recgroup] => Default
  148. [recorded_sortby] => Array
  149. (
  150. [0] => Array
  151. (
  152. [field] => airdate
  153. [reverse] => 1
  154. )
  155.  
  156. [1] => Array
  157. (
  158. [field] => title
  159. [reverse] =>
  160. )
  161.  
  162. )
  163.  
  164. [list_time] => 1380727800
  165. [search_sortby] => Array
  166. (
  167. [0] => Array
  168. (
  169. [field] => airdate
  170. [reverse] =>
  171. )
  172.  
  173. [1] => Array
  174. (
  175. [field] => title
  176. [reverse] =>
  177. )
  178.  
  179. )
  180.  
  181. [schedules_sortby] => Array
  182. (
  183. [0] => Array
  184. (
  185. [field] => airdate
  186. [reverse] =>
  187. )
  188.  
  189. [1] => Array
  190. (
  191. [field] => title
  192. [reverse] =>
  193. )
  194.  
  195. )
  196.  
  197. [date_job_status] => %a %b %e, %Y, %I:%M %p
  198. [show_popup_info] => 1
  199. [show_channel_icons] => 1
  200. [sortby_channum] => 1
  201. [show_video_covers] => 1
  202. [remote] => Array
  203. (
  204. [frontends] => Array ( )
  205. [type] => keys
  206. )
  207.  
  208. [tv] => Array
  209. (
  210. [last] => Array
  211. (
  212. [0] => recommended
  213. )
  214.  
  215. [show_advanced_schedule] => 1
  216. )
  217.  
  218. [settings] => Array
  219. (
  220. [last] => Array
  221. (
  222. [0] => video
  223. [1] => settings
  224. )
  225.  
  226. [host] => homeroom
  227. [screens] => Array
  228. (
  229. [tv] => Array
  230. (
  231. [upcoming recordings] => Array
  232. (
  233. [title] => on
  234. [original airdate] => on
  235. [channel] => on
  236. [recording group] => on
  237. [record date] => on
  238. [length] => on
  239. )
  240.  
  241. )
  242.  
  243. )
  244.  
  245. )
  246.  
  247. [recording_details] => Array
  248. (
  249. [show_Conflict] => on
  250. [show_PreviousRecording] =>
  251. [show_EarlierShowing] =>
  252. [show_CurrentRecording] => on
  253. [show_WillRecord] => on
  254. )
  255.  
  256. [video_sortby] => Array
  257. (
  258. [0] => Array
  259. (
  260. [field] => title
  261. [reverse] =>
  262. )
  263.  
  264. )
  265.  
  266. [weather] => Array
  267. (
  268. [active] => Array
  269. (
  270. [0] => 25
  271. [1] => 26
  272. [2] => 27
  273. )
  274.  
  275. [inactive] => Array
  276. (
  277. [0] => 18 Hour Forecast
  278. [1] => Animated Map
  279. [2] => Current Conditions
  280. [3] => Six Day Forecast
  281. [4] => Static Map
  282. [5] => Three Day Forecast
  283. )
  284.  
  285. )
  286.  
  287. [] => Array ( )
  288. [recorded_paging] =>
  289. [genre_colors] => 1
  290. [backend] => Array
  291. (
  292. [192.168.1.5] => Array
  293. (
  294. [proto_version] => Array
  295. (
  296. [last_check_version] => 77
  297. [last_check_time] => 1381248697
  298. )
  299.  
  300. )
  301.  
  302. [timezone] => Array
  303. (
  304. [value] => America/Los_Angeles
  305. [last_check_time] => 1381248697
  306. )
  307.  
  308. )
  309.  
  310. [cache_engine] => Cache_Null
  311. [stream] => Array
  312. (
  313. [include_user_and_password] =>
  314. )
  315.  
  316. [show] => Array
  317. (
  318. [state] => recorded
  319. )
  320.  
  321. [previous_recorded_title] => A-Team
  322. [previous_recorded_sortby] => Array
  323. (
  324. [0] => Array
  325. (
  326. [field] => airdate
  327. [reverse] =>
  328. )
  329.  
  330. [1] => Array
  331. (
  332. [field] => title
  333. [reverse] =>
  334. )
  335.  
  336. )
  337.  
  338. [episode_sortby] => Array
  339. (
  340. [0] => Array
  341. (
  342. [field] => airdate
  343. [reverse] =>
  344. )
  345.  
  346. [1] => Array
  347. (
  348. [field] => title
  349. [reverse] =>
  350. )
  351.  
  352. )
  353.  
  354. [episodes] => Array
  355. (
  356. [allepisodes] => all
  357. )
  358.  
  359. [search] => Array
  360. (
  361. [showstr] => Modern Family
  362. [showname] => Modernfamily
  363. [longshow] => Modern Family
  364. [type] => q
  365. [as] => Array
  366. (
  367. [0] => star trek
  368. )
  369.  
  370. [af] => Array
  371. (
  372. [0] => Array
  373. (
  374. [0] => title
  375. )
  376.  
  377. )
  378.  
  379. [aj] => Array
  380. (
  381. [0] => AND
  382. )
  383.  
  384. [ctype] => Array
  385. (
  386. [0] => movie
  387. [1] => series
  388. [2] => sports
  389. [3] => tvshow
  390. )
  391.  
  392. [categories] => Array
  393. (
  394. [0] => All
  395. )
  396.  
  397. [hd] =>
  398. [commfree] =>
  399. [unwatched] =>
  400. [scheduled] =>
  401. [generic] =>
  402. [distinctTitle] =>
  403. [stars_gt] => 0
  404. [stars_lt] => 1
  405. [airdate_start] =>
  406. [airdate_end] =>
  407. [starttime] => now
  408. [endtime] => + 2 weeks
  409. [s] => ^Cloudy With a Chance of Meatballs$
  410. )
  411.  
  412. )
  413.  
  414. ==========================================================================
  415.  
  416. $_SERVER: Array
  417. (
  418. [REDIRECT_STATUS] => 200
  419. [HTTP_HOST] => www.migratingcoconuts.com
  420. [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Firefox/24.0
  421. [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
  422. [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
  423. [HTTP_ACCEPT_ENCODING] => gzip, deflate
  424. [HTTP_REFERER] => http://www.migratingcoconuts.com/mythweb/status
  425. [HTTP_COOKIE] => mythweb_id=frcrs58hv121tcuff101f4eqc1
  426. [HTTP_CONNECTION] => keep-alive
  427. [PATH] => /bin:/sbin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin
  428. [SERVER_SIGNATURE] => <address>Apache Server at www.migratingcoconuts.com Port 80</address>
  429.  
  430. [SERVER_SOFTWARE] => Apache
  431. [SERVER_NAME] => www.migratingcoconuts.com
  432. [SERVER_ADDR] => 192.168.1.5
  433. [SERVER_PORT] => 80
  434. [REMOTE_ADDR] => 76.191.138.114
  435. [DOCUMENT_ROOT] => /var/www/localhost/htdocs
  436. [REQUEST_SCHEME] => http
  437. [CONTEXT_PREFIX] =>
  438. [CONTEXT_DOCUMENT_ROOT] => /var/www/localhost/htdocs
  439. [SERVER_ADMIN] => root@localhost
  440. [SCRIPT_FILENAME] => /var/www/localhost/htdocs/mythweb/mythweb.php
  441. [REMOTE_PORT] => 51806
  442. [REMOTE_USER] => newmka
  443. [AUTH_TYPE] => Digest
  444. [REDIRECT_URL] => /mythweb/tv/recommended
  445. [GATEWAY_INTERFACE] => CGI/1.1
  446. [SERVER_PROTOCOL] => HTTP/1.1
  447. [REQUEST_METHOD] => GET
  448. [QUERY_STRING] =>
  449. [REQUEST_URI] => /tv/recommended
  450. [SCRIPT_NAME] => /mythweb/mythweb.php
  451. [PATH_INFO] => /tv/recommended
  452. [PATH_TRANSLATED] => /var/www/localhost/htdocs/tv/recommended
  453. [PHP_SELF] => /mythweb/mythweb.php/tv/recommended
  454. [PHP_AUTH_USER] => newmka
  455. [PHP_AUTH_DIGEST] => username="newmka", realm="MythTV", nonce="xdwFET3oBAA=15a2302491c87f1e755dc03e066dd6a90460ca5c", uri="/mythweb/tv/recommended", algorithm=MD5, response="0d55d6769991c477046ef2bc674eae0b", qop=auth, nc=00000013, cnonce="7d016a763eebe8ae"
  456. [REQUEST_TIME] => 1381248954
  457. [STATUS] => 200
  458. [URL] => /mythweb/tv/recommended
  459. [HTTP_PORT] => 80
  460. )
  461.  
  462. ==========================================================================
  463.  
  464. $constant_list["user"]: Array
  465. (
  466. [ERROR] => 512
  467. [E_ASSERT_ERROR] => 4096
  468. [FATAL] => 256
  469. [PHP_MIN_VERSION] => 5.3
  470. [WARNING] => 1024
  471. [WebDBSchemaVer] => 4
  472. [dupsin_all] => 15
  473. [dupsin_newepisodes] => 16
  474. [dupsin_oldrecorded] => 2
  475. [dupsin_recorded] => 1
  476. [error_email] =>
  477. [gb] => 1073741824
  478. [hostname] => homeroom
  479. [http_host] => www.migratingcoconuts.com
  480. [kb] => 1024
  481. [max_stars] => 4
  482. [mb] => 1048576
  483. [module] => tv
  484. [modules_path] => /var/www/localhost/htdocs/mythweb/modules
  485. [num_time_slots] => 36
  486. [prefer_channum] => 1
  487. [rectype_always] => 4
  488. [rectype_daily] => 2
  489. [rectype_dontrec] => 8
  490. [rectype_findone] => 6
  491. [rectype_once] => 1
  492. [rectype_override] => 7
  493. [rectype_template] => 11
  494. [rectype_weekly] => 5
  495. [root] => /mythweb/
  496. [root_auth_url] => http://www.migratingcoconuts.com/mythweb/
  497. [root_url] => http://www.migratingcoconuts.com/mythweb/
  498. [searchtype_keyword] => 3
  499. [searchtype_manual] => 5
  500. [searchtype_people] => 4
  501. [searchtype_power] => 1
  502. [searchtype_title] => 2
  503. [skin] => default
  504. [skin_img_url] => http://www.migratingcoconuts.com/mythweb/skins/default/img/
  505. [skin_url] => http://www.migratingcoconuts.com/mythweb/skins/default/
  506. [star_character] => &diams;
  507. [stream_url] => http://www.migratingcoconuts.com:80//mythweb/
  508. [tb] => 1099511627776
  509. [timeslot_blocks] => 3
  510. [timeslot_size] => 300
  511. [timeslotbar_skip] => 20
  512. [tmpl] => default
  513. [tmpl_dir] => modules/tv/tmpl/default/
  514. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!