NineChime forum

Ashass · 06-21-2008 19:03:06

I am currently using Wacintaki v 1.3.14 alpha

When I try to archive a drawing I get the following error:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/override/public_html/lawlsuit.com/oekakidoodle/functions.php on line 1531

Warning: Cannot modify header information - headers already sent by (output started at /home/override/public_html/lawlsuit.com/oekakidoodle/functions.php:1531) in /home/override/public_html/lawlsuit.com/oekakidoodle/common.php on line 220

ShiPainter was used to create this image.

The curious thing is that it does still archive/unarchive the file, i just have to hit back and refresh the page.

The first error references this code segment:

Code:

// Archive picture
if ($mode == 'archive') {
    $picid = w_gpc('picid', 'i');

    if ($flags['admin']) {
        // Get archive flag
        $result = mysql_query ("SELECT archive, usrname FROM {$OekakiPoteto_Prefix}oekakidta WHERE PIC_ID=$picid");

        if ($result) {
            $row = mysql_fetch_array ($result);

            // Toggle archive status
            $archive = (int) $row['archive'];
            $archive ? $archive = 0 : $archive = 1;

            $result = mysql_query ("UPDATE {$OekakiPoteto_Prefix}oekakidta SET archive=$archive WHERE PIC_ID=$picid");

            // Reversed already!
            $archive ? $a_status = 'archive' : $a_status = 'unarchive';
            w_log(WLOG_ARCHIVE, $a_status.': '.$picid, mysql_result ($result, 0));
        }

        all_done('index.php'.$pic_redirect.'#'.$picid);
    } else {
        report_err($langop_functions_err3);
    }
}

The second error references this one:

Code:

<html>
<head>
    <title>Redirect</title>
    <meta http-equiv="refresh" content="3;url={$url}">
</head>
<body>
    <p style="text-align: center; padding: 15px; border: 2px black solid;">
        <strong>{$mess}</strong><br /><br /> {$langop_common['redirect']} <a href="{$url}"> {$langop_common['here']} </a>.
    </p>
</body>
</html>
EOF;
            w_exit();
        }
    }

    header('Location: '.$url);
    w_exit();
}

Waccoon · 06-22-2008 21:20:27

Very dumb bug.

Code:

w_log(WLOG_ARCHIVE, $a_status.': '.$picid, mysql_result ($result, 0));

CHANGE TO

w_log(WLOG_ARCHIVE, $a_status.': '.$picid, $row['usrname']);

Here is the new 1.3.14 beta, for testing purposes only.

NineChime forum

#1 06-21-2008 19:03:06

Archive/unarchive SQL problem

Code:

Code:

#2 06-22-2008 21:20:27

Re: Archive/unarchive SQL problem

Code:

Board footer