Show Posts
1
Users / Mythweb Error 710 RC
« on: May 01, 2008, 06:51:55 am »
Newly upgraded 710 RC. With Beta 4, I had lost the ability to add images to scheduled recordings (although I never got it working). It's back now, but attempting to use a URL for a schedule gives this mySQL error in Mythweb (below.) I'm wondering if this is because of the URL I used for the image? (the dashes or some special character issue?) Is there a size restriction? Thanks!
----------------------------------
Fatal Error at /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php, line 73:
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 'AND UNIX_TIMESTAMP(starttime)=' at line 1 [#1064]
If you choose to submit a bug report, please make sure to include a
brief description of what you were doing, along with the following
backtrace as an attachment (please don't paste the whole thing into
the ticket).
Backtrace:
datetime: 2008-04-30 23:44:06 (CDT)
errornum: 256
error type: User Error
error string: 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 'AND UNIX_TIMESTAMP(starttime)=' at line 1 [#1064]
filename: /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php
error line: 73
==========================================================================
Backtrace:
file: /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php
line: 73
class:
function: trigger_error
type:
args: Array
(
)
file: /usr/share/mythtv/mythweb/extra/showpic.php
line: 145
class: Database
function: query
type: ->
args: Array
(
)
file: /usr/share/mythtv/mythweb/extra/showpic.php
line: 113
class:
function: get_program_data
type:
args: Array
(
[err] =>
[errno] =>
[last_sh] => Database_Query_mysql Object
(
[dbh] => Resource id #104
[query] => Array
(
)
[last_query] => SELECT * FROM program WHERE chanid= AND UNIX_TIMESTAMP(starttime)=
[num_args_needed] => 0
[db] => Database_mysql Object
*RECURSION*
[sh] =>
)
[fatal_errors] => 1
[limit_regex] => /((.*)\sLIMIT\s+\d+(?:\s*(?:,|OFFSET)\s*\d+)?)?
((?:\s+PROCEDURE\s+\w+\(.+?\))?
(?:\s+FOR\s+UPDATE)?
(?:\s+LOCK\s+IN\s+SHARE\s+MODE)?
)
\s*$/xe
[global_name] =>
[destruct_handlers] => Array ( )
[limit_regex_replace] => "$2"." LIMIT 1 "."$3"
)
)
file: /usr/share/mythtv/mythweb/extra/showpic.php
line: 24
class:
function: update_pic
type:
args: Array
(
(
[dbh] => Resource id #104
[error] =>
[err] =>
[errno] =>
[last_sh] => Database_Query_mysql Object
(
[dbh] => Resource id #104
[query] => Array
(
)
[last_query] => SELECT * FROM program WHERE chanid= AND UNIX_TIMESTAMP(starttime)=
[num_args_needed] => 0
[db] => Database_mysql Object
*RECURSION*
[sh] =>
)
[fatal_errors] => 1
[limit_regex] => /((.*)\sLIMIT\s+\d+(?:\s*(?:,|OFFSET)\s*\d+)?)?
((?:\s+PROCEDURE\s+\w+\(.+?\))?
(?:\s+FOR\s+UPDATE)?
(?:\s+LOCK\s+IN\s+SHARE\s+MODE)?
)
\s*$/xe
[global_name] =>
[destruct_handlers] => Array ( )
[limit_regex_replace] => "$2"." LIMIT 1 "."$3"
)
[1] => Database_mysql Object
(
[dbh] => Resource id #105
[error] =>
[err] =>
[errno] =>
[last_sh] =>
[fatal_errors] => 1
[limit_regex] => /((.*)\sLIMIT\s+\d+(?:\s*(?:,|OFFSET)\s*\d+)?)?
((?:\s+PROCEDURE\s+\w+\(.+?\))?
(?:\s+FOR\s+UPDATE)?
(?:\s+LOCK\s+IN\s+SHARE\s+MODE)?
)
\s*$/xe
[global_name] =>
[destruct_handlers] => Array ( )
[limit_regex_replace] => "$2"." LIMIT 1 "."$3"
)
[2] => Database_mysql Object
(
[dbh] => Resource id #106
[error] =>
[err] =>
[errno] =>
[last_sh] =>
[fatal_errors] => 1
[limit_regex] => /((.*)\sLIMIT\s+\d+(?:\s*(?:,|OFFSET)\s*\d+)?)?
((?:\s+PROCEDURE\s+\w+\(.+?\))?
(?:\s+FOR\s+UPDATE)?
(?:\s+LOCK\s+IN\s+SHARE\s+MODE)?
)
\s*$/xe
[global_name] =>
[destruct_handlers] => Array ( )
[limit_regex_replace] => "$2"." LIMIT 1 "."$3"
)
)
file: /usr/share/mythtv/mythweb/modules/tv/tmpl/default/detail.php
line: 504
class:
function: require
type:
args: Array
(
)
file: /usr/share/mythtv/mythweb/modules/tv/detail.php
line: 243
class:
function: require_once
type:
args: Array
(
)
file: /usr/share/mythtv/mythweb/modules/tv/handler.php
line: 64
class:
function: require_once
type:
args: Array
(
)
file: /usr/share/mythtv/mythweb/mythweb.php
line: 24
class:
function: require_once
type:
args: Array
(
)
==========================================================================
$_GET: Array
(
[recordid] => 3
)
==========================================================================
$_POST: Array
(
[cpicURL] => http://artfiles.art.com/images/-/Family-Guy---Cast-Poster-C11790610.jpeg
[upload] => Update
)
==========================================================================
$_SESSION: Array
(
[language] => English_GB
[tmpl] => default
[skin] => default
[prefer_channum] => 1
[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<br />(%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
[time_format] => %I:%M %p
[recorded_pixmaps] => 1
[guide_favonly] =>
[timeslot_size] => 300
[num_time_slots] => 36
[timeslot_blocks] => 3
[timeslotbar_skip] => 20
[max_stars] => 4
[star_character] => ♦
[recorded_title] =>
[recorded_recgroup] =>
[recorded_sortby] => Array
(
(
[field] => airdate
[reverse] => 1
)
[1] => Array
(
[field] => file_size
[reverse] =>
)
[2] => Array
(
[field] => title
[reverse] =>
)
)
[schedules_sortby] => Array
(
(
[field] => airdate
[reverse] =>
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
)
==========================================================================
$_SERVER: Array
(
[REDIRECT_STATUS] => 200
[HTTP_HOST] => 192.168.x.x
[HTTP_USER_AGENT] => Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
[HTTP_ACCEPT] => text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_LANGUAGE] => en-gb,en;q=0.5
[HTTP_ACCEPT_ENCODING] => gzip,deflate
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_KEEP_ALIVE] => 300
[HTTP_CONNECTION] => keep-alive
[HTTP_REFERER] => http://192.168.x.x/mythweb/tv/detail?recordid=3
[HTTP_COOKIE] => mythweb_id=7
[CONTENT_TYPE] => multipart/form-data; boundary=---------------------------16575125343
[CONTENT_LENGTH] => 469
[PATH] => /usr/local/bin:/usr/bin:/bin
[SERVER_SIGNATURE] => <address>Apache/2.2.4 (Ubuntu) PHP/5.2.3-1ubuntu6 Server at 192.168.x.x Port 80</address>
[SERVER_SOFTWARE] => Apache/2.2.4 (Ubuntu) PHP/5.2.3-1ubuntu6
[SERVER_NAME] => 192.168.x.x
[SERVER_ADDR] => 192.168.x.x
[SERVER_PORT] => 80
[REMOTE_ADDR] => 192.168.x.x
[DOCUMENT_ROOT] => /var/www
[SERVER_ADMIN] => webmaster@localhost
[SCRIPT_FILENAME] => /var/www/mythweb/mythweb.php
[REMOTE_PORT] => 22743
[REDIRECT_QUERY_STRING] => recordid=3
[REDIRECT_URL] => /mythweb/tv/detail
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => POST
[QUERY_STRING] => recordid=3
[REQUEST_URI] => /mythweb/tv/detail?recordid=3
[SCRIPT_NAME] => /mythweb/mythweb.php
[PATH_INFO] => /tv/detail
[PATH_TRANSLATED] => /var/www/tv/detail
[PHP_SELF] => /mythweb/mythweb.php/tv/detail
[REQUEST_TIME] => 1209617046
[argv] => Array
(
)
[argc] => 1
[STATUS] => 200
[URL] => /mythweb/tv/detail
)
----------------------------------
Fatal Error at /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php, line 73:
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 'AND UNIX_TIMESTAMP(starttime)=' at line 1 [#1064]
If you choose to submit a bug report, please make sure to include a
brief description of what you were doing, along with the following
backtrace as an attachment (please don't paste the whole thing into
the ticket).
Backtrace:
datetime: 2008-04-30 23:44:06 (CDT)
errornum: 256
error type: User Error
error string: 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 'AND UNIX_TIMESTAMP(starttime)=' at line 1 [#1064]
filename: /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php
error line: 73
==========================================================================
Backtrace:
file: /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php
line: 73
class:
function: trigger_error
type:
args: Array
(
- => 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 'AND UNIX_TIMESTAMP(starttime)=' at line 1 [#1064] [1] => 256
- => Array ( )
)
file: /usr/share/mythtv/mythweb/includes/objects/Database.php
line: 270
class: Database_Query_mysql
function: execute
type: ->
args: Array
(
)
file: /usr/share/mythtv/mythweb/extra/showpic.php
line: 145
class: Database
function: query
type: ->
args: Array
(
- => SELECT * FROM program WHERE chanid= AND UNIX_TIMESTAMP(starttime)=
)
file: /usr/share/mythtv/mythweb/extra/showpic.php
line: 113
class:
function: get_program_data
type:
args: Array
(
- => [1] =>
[2] => Database_mysql Object
(
[dbh] => Resource id #104
[err] =>
[errno] =>
[last_sh] => Database_Query_mysql Object
(
[dbh] => Resource id #104
[query] => Array
(
- => SELECT * FROM program WHERE chanid= AND UNIX_TIMESTAMP(starttime)=
)
[last_query] => SELECT * FROM program WHERE chanid= AND UNIX_TIMESTAMP(starttime)=
[num_args_needed] => 0
[db] => Database_mysql Object
*RECURSION*
[sh] =>
)
[fatal_errors] => 1
[limit_regex] => /((.*)\sLIMIT\s+\d+(?:\s*(?:,|OFFSET)\s*\d+)?)?
((?:\s+PROCEDURE\s+\w+\(.+?\))?
(?:\s+FOR\s+UPDATE)?
(?:\s+LOCK\s+IN\s+SHARE\s+MODE)?
)
\s*$/xe
[global_name] =>
[destruct_handlers] => Array ( )
[limit_regex_replace] => "$2"." LIMIT 1 "."$3"
)
)
file: /usr/share/mythtv/mythweb/extra/showpic.php
line: 24
class:
function: update_pic
type:
args: Array
(
- => Database_mysql Object
(
[dbh] => Resource id #104
[error] =>
[err] =>
[errno] =>
[last_sh] => Database_Query_mysql Object
(
[dbh] => Resource id #104
[query] => Array
(
- => SELECT * FROM program WHERE chanid= AND UNIX_TIMESTAMP(starttime)=
)
[last_query] => SELECT * FROM program WHERE chanid= AND UNIX_TIMESTAMP(starttime)=
[num_args_needed] => 0
[db] => Database_mysql Object
*RECURSION*
[sh] =>
)
[fatal_errors] => 1
[limit_regex] => /((.*)\sLIMIT\s+\d+(?:\s*(?:,|OFFSET)\s*\d+)?)?
((?:\s+PROCEDURE\s+\w+\(.+?\))?
(?:\s+FOR\s+UPDATE)?
(?:\s+LOCK\s+IN\s+SHARE\s+MODE)?
)
\s*$/xe
[global_name] =>
[destruct_handlers] => Array ( )
[limit_regex_replace] => "$2"." LIMIT 1 "."$3"
)
[1] => Database_mysql Object
(
[dbh] => Resource id #105
[error] =>
[err] =>
[errno] =>
[last_sh] =>
[fatal_errors] => 1
[limit_regex] => /((.*)\sLIMIT\s+\d+(?:\s*(?:,|OFFSET)\s*\d+)?)?
((?:\s+PROCEDURE\s+\w+\(.+?\))?
(?:\s+FOR\s+UPDATE)?
(?:\s+LOCK\s+IN\s+SHARE\s+MODE)?
)
\s*$/xe
[global_name] =>
[destruct_handlers] => Array ( )
[limit_regex_replace] => "$2"." LIMIT 1 "."$3"
)
[2] => Database_mysql Object
(
[dbh] => Resource id #106
[error] =>
[err] =>
[errno] =>
[last_sh] =>
[fatal_errors] => 1
[limit_regex] => /((.*)\sLIMIT\s+\d+(?:\s*(?:,|OFFSET)\s*\d+)?)?
((?:\s+PROCEDURE\s+\w+\(.+?\))?
(?:\s+FOR\s+UPDATE)?
(?:\s+LOCK\s+IN\s+SHARE\s+MODE)?
)
\s*$/xe
[global_name] =>
[destruct_handlers] => Array ( )
[limit_regex_replace] => "$2"." LIMIT 1 "."$3"
)
)
file: /usr/share/mythtv/mythweb/modules/tv/tmpl/default/detail.php
line: 504
class:
function: require
type:
args: Array
(
- => /usr/share/mythtv/mythweb/extra/showpic.php
)
file: /usr/share/mythtv/mythweb/modules/tv/detail.php
line: 243
class:
function: require_once
type:
args: Array
(
- => /usr/share/mythtv/mythweb/modules/tv/tmpl/default/detail.php
)
file: /usr/share/mythtv/mythweb/modules/tv/handler.php
line: 64
class:
function: require_once
type:
args: Array
(
- => /usr/share/mythtv/mythweb/modules/tv/detail.php
)
file: /usr/share/mythtv/mythweb/mythweb.php
line: 24
class:
function: require_once
type:
args: Array
(
- => /usr/share/mythtv/mythweb/modules/tv/handler.php
)
==========================================================================
$_GET: Array
(
[recordid] => 3
)
==========================================================================
$_POST: Array
(
[cpicURL] => http://artfiles.art.com/images/-/Family-Guy---Cast-Poster-C11790610.jpeg
[upload] => Update
)
==========================================================================
$_SESSION: Array
(
[language] => English_GB
[tmpl] => default
[skin] => default
[prefer_channum] => 1
[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<br />(%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
[time_format] => %I:%M %p
[recorded_pixmaps] => 1
[guide_favonly] =>
[timeslot_size] => 300
[num_time_slots] => 36
[timeslot_blocks] => 3
[timeslotbar_skip] => 20
[max_stars] => 4
[star_character] => ♦
[recorded_title] =>
[recorded_recgroup] =>
[recorded_sortby] => Array
(
- => Array
(
[field] => airdate
[reverse] => 1
)
[1] => Array
(
[field] => file_size
[reverse] =>
)
[2] => Array
(
[field] => title
[reverse] =>
)
)
[schedules_sortby] => Array
(
- => Array
(
[field] => airdate
[reverse] =>
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
)
==========================================================================
$_SERVER: Array
(
[REDIRECT_STATUS] => 200
[HTTP_HOST] => 192.168.x.x
[HTTP_USER_AGENT] => Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
[HTTP_ACCEPT] => text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_LANGUAGE] => en-gb,en;q=0.5
[HTTP_ACCEPT_ENCODING] => gzip,deflate
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_KEEP_ALIVE] => 300
[HTTP_CONNECTION] => keep-alive
[HTTP_REFERER] => http://192.168.x.x/mythweb/tv/detail?recordid=3
[HTTP_COOKIE] => mythweb_id=7
[CONTENT_TYPE] => multipart/form-data; boundary=---------------------------16575125343
[CONTENT_LENGTH] => 469
[PATH] => /usr/local/bin:/usr/bin:/bin
[SERVER_SIGNATURE] => <address>Apache/2.2.4 (Ubuntu) PHP/5.2.3-1ubuntu6 Server at 192.168.x.x Port 80</address>
[SERVER_SOFTWARE] => Apache/2.2.4 (Ubuntu) PHP/5.2.3-1ubuntu6
[SERVER_NAME] => 192.168.x.x
[SERVER_ADDR] => 192.168.x.x
[SERVER_PORT] => 80
[REMOTE_ADDR] => 192.168.x.x
[DOCUMENT_ROOT] => /var/www
[SERVER_ADMIN] => webmaster@localhost
[SCRIPT_FILENAME] => /var/www/mythweb/mythweb.php
[REMOTE_PORT] => 22743
[REDIRECT_QUERY_STRING] => recordid=3
[REDIRECT_URL] => /mythweb/tv/detail
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => POST
[QUERY_STRING] => recordid=3
[REQUEST_URI] => /mythweb/tv/detail?recordid=3
[SCRIPT_NAME] => /mythweb/mythweb.php
[PATH_INFO] => /tv/detail
[PATH_TRANSLATED] => /var/www/tv/detail
[PHP_SELF] => /mythweb/mythweb.php/tv/detail
[REQUEST_TIME] => 1209617046
[argv] => Array
(
- => recordid=3
)
[argc] => 1
[STATUS] => 200
[URL] => /mythweb/tv/detail
)