Opened 14 years ago

Closed 14 years ago

#1172 closed defect (worksforme)

mythweb: cancelling an existing custom Power Search recording gives DB error

Reported by: jonese@… Owned by: xris
Priority: minor Milestone: 0.19
Component: mythweb Version:
Severity: low Keywords:
Cc: Ticket locked: no

Description

If I select "Cancel this schedule." on an existing Power Search recroding, I receive the following error:

Fatal Error at /var/www/localhost/htdocs/mythtv/includes/db.php, line 342: Database_Query called with 1 arguments, but requires 0.

Change History (6)

comment:1 Changed 14 years ago by xris

Can you do me a favor and paste the power search sql query?

comment:2 Changed 14 years ago by jonese@…

Resolution: worksforme
Status: newclosed

My appologies, I can unable to recreate the failure again (I tried three different schedules). It must be some combination of options in the schedule that I havn't hit again.

I'll reopen if I should encounter again.

comment:3 Changed 14 years ago by xris

(In [8828]) better attempts to avoid errors about random ? characters causing db.php to freak out, re #1172

comment:4 Changed 14 years ago by xris

Actually, my guess is that you were running into a problem that I probably fixed shortly after your checkout. Anyway, I just committed some changes that will get mythweb to print a full backtrace when it runs into errors like this, so you'll be able to provide much more information if it happens again.

comment:5 Changed 14 years ago by mythtv.cvs@…

Resolution: worksforme
Status: closedreopened

This error occurs whenever I attempt to delete a recording, that is, "Cancel this schedule" in Mythweb. I'm currently using 19fixes @9200. If this is fixed in trunk, is there a way to move this fix to 19fixes?

   datetime:  2006-03-08 12:40:51 (EST)
    errornum:  256
  error type:  User Error
error string:  Database_Query called with 1 arguments, but requires 0.
    filename:  /var/www/mythweb/includes/db.php
  error line:  342

VARIABLES:

GET:
Array
(
    [recordid] => 16
)
POST:
Array
(
    [record] => 0
    [profile] => Default
    [transcoder] => 0
    [recgroup] => Default
    [recpriority] => 0
    [timestretch] => 1.00
    [dupin] => 15
    [dupmethod] => 6
    [autocommflag] => 1
    [autoexpire] => 1
    [maxepisodes] => 0
    [startoffset] => 0
    [endoffset] => 0
    [save] => Update Recording Settings
)
SESSION:
Array
(
    [language] => English
    [Theme] => default
    [Skin] => default
    [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
    [list_time] => 1141838100
    [recorded_title] => 
    [recorded_recgroup] => 
    [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_sortby] => Array
        (
            [0] => Array
                (
                    [field] => airdate
                    [reverse] => 
                )

            [1] => Array
                (
                    [field] => title
                    [reverse] => 
                )

        )

    [search] => Array
        (
            [searchstr] => tommy douglas
            [search_title] => 1
            [search_subtitle] => 1
            [search_description] => 
            [search_category] => 
            [search_category_type] => 
        )

    [scheduled_recordings] => Array
        (
            [disp_scheduled] => 1
            [disp_duplicates] => 1
            [disp_deactivated] => 1
            [disp_conflicts] => 1
        )

    [scheduled_sortby] => Array
        (
            [0] => Array
                (
                    [field] => airdate
                    [reverse] => 
                )

            [1] => Array
                (
                    [field] => title
                    [reverse] => 
                )

        )

)
SERVER:
Array
(
    [REDIRECT_STATUS] => 200
    [HTTP_HOST] => oldbe
    [HTTP_USER_AGENT] => Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.7.12) Gecko/20060207 Debian/1.7.12-1.1
    [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_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://oldbe/mythweb/tv/detail?recordid=16
    [HTTP_COOKIE] => cookies=true; cookies=true; mythweb_id=7bb96667c5afbb06d58b30559bf4a74e; mythweb_id=7bb96667c5afbb06d58b30559bf4a74e
    [CONTENT_TYPE] => application/x-www-form-urlencoded
    [CONTENT_LENGTH] => 205
    [PATH] => /usr/local/bin:/usr/bin:/bin
    [SERVER_SIGNATURE] => <address>Apache/2.0.55 (Debian) PHP/4.4.0-4 Server at oldbe Port 80</address>

    [SERVER_SOFTWARE] => Apache/2.0.55 (Debian) PHP/4.4.0-4
    [SERVER_NAME] => oldbe
    [SERVER_ADDR] => 10.10.10.100
    [SERVER_PORT] => 80
    [REMOTE_ADDR] => 10.10.10.10
    [DOCUMENT_ROOT] => /var/www
    [SERVER_ADMIN] => webmaster@localhost
    [SCRIPT_FILENAME] => /var/www/mythweb/mythweb.php
    [REMOTE_PORT] => 47719
    [REMOTE_USER] => dude
    [AUTH_TYPE] => Basic
    [REDIRECT_QUERY_STRING] => recordid=16
    [REDIRECT_URL] => /mythweb/tv/detail
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => POST
    [QUERY_STRING] => recordid=16
    [REQUEST_URI] => /mythweb/tv/detail?recordid=16
    [SCRIPT_NAME] => /mythweb/mythweb.php
    [PATH_INFO] => /tv/detail
    [PATH_TRANSLATED] => /var/www/tv/detail
    [PHP_SELF] => /mythweb/mythweb.php/tv/detail
    [PHP_AUTH_USER] => dude
    [PHP_AUTH_PW] => thing
    [argv] => Array
        (
            [0] => recordid=16
        )

    [argc] => 1
)


comment:6 Changed 14 years ago by xris

Resolution: worksforme
Status: reopenedclosed

you're obviously not using the latest mythweb.. That error list isn't printing a backtrace, which was added LONG before [9200], and probably means that you didn't get my fix, either.

If you update mythweb to the latest checkout and you're still getting the error, please attach the full backtrace (don't paste it, it's too big) and I'll see what I missed.

Note: See TracTickets for help on using tickets.