uploaded 5.12 to upgrade.... parse error

[rcsmith]

Parse error: parse error, unexpected ')', expecting ';' in /web/docs/www.mysite.com/photos/showgallery.php on line 505

Main index.php gives this error
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /web/docs/www.mysite.com/photos/forums/vb3.php on line 608

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /web/docs/www.mysite.com/photos/forums/vb3.php on line 563

[rcsmith]

I also get this in the admin CP

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /web/docs/www.mysite.com/photos/adm-misc.php on line 1045

[Michael P]

I'm not sure why you are getting the parse error, did you upload the files properly? I changed line 502-505 to read:

Content visible to verified customers only.

which might help on some systems.

The adm-misc.php error, what version were you running?

[rcsmith]

so i just renamed my photo folder something else, made a new photo folder and uploaded the files. copied over the config files and still same problems. I believe I was running version 5.11 before.

[rcsmith]

my 502-505 is

$mcats = null;
if ( isset($_POST['mcats']) ) {
if ( is_array($mcats) ) {
for ( $i = 0, $i < count($mcats), $i++ ) {

[Michael P]

If you want to PM me your site FTP info and Admin userid, I'll login and try it out myself.

[rcsmith]

Here is the sniplet.

$catcheck = null;

$mcats = null;
if ( isset($_POST['mcats']) ) {
if ( is_array($mcats) ) {
for ( $i = 0, $i < count($mcats), $i++ ) {
if ( $mcats != null ) $mcats .= ",";
$mcats .= (int)$POST['mcats'][$i];
}
}
else {
typecast($_POST, array('mcats' => STRING));
}
}


thanks
ryan

[Michael P]

Yes, I changed it to:

Content visible to verified customers only.

[rcsmith]

I changed the code to that on the showgallery.php. It works now. I'm going to pm you the info. for some reason there are other errors.

[Michael P]

I looked and the issue is trhis query:

$onlinequery = "SELECT item, count(*) FROM {$Globals['pp_db_prefix']}iponline GROUP BY item";

which refers to the iponline table - why its returning an error is beyond me. I'd need to look at your iponline table; but if you were running 5.11, this shouldnt be a problem as nothing changed between versions.

[rcsmith]

I actually had the error on 5.11 on the main page. I didn't have it at first. I thought maybe I might have edited a file and it was messing it up. So I saw 5.12 and upgraded. That's when i started getting the showgallery.php problem which is a major one.

I'm not familiar with the IPonline table

[rcsmith]

i checked the iponline. maybe it got corrupted or never installed correctly.

Can't open file: 'iponline.MYI'. (errno: 145)

Error
SQL-query:

SHOW KEYS FROM `iponline` ;


MySQL said:

#1016 - Can't open file: 'iponline.MYI'. (errno: 145)

[Chuck S]

Yep you need to run a repair on that table or recreate it

[Michael P]

I ran a REPAIR TABLE iponline; and it fixed the problem.

[rcsmith]

Great work guys! I appreciate it!