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

[jonese@…]

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.

[xris]

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

[jonese@…]

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.

[xris]

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

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

[mythtv.cvs@…]

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
)

[xris]

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.