errors when deleting all users photos

[7thgencivic.com]

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/civic/public_html/memberrides/adm-cats.php on line 1095

PhotoPost Delete Photos By User

You're about to delete all the photos posted by the user "".

Check to delete all comments by this user

Are you sure you want to do that?

http://www.7thgencivic.com/memberrid...otos&uid=10194

[Chuck S]

Hello yep I see the issue here in admin-cats.php

$querya="SELECT user FROM {$Globals['pp_db_prefix']}photos where userid=$uid ORDER BY date DESC LIMIT 1";
$userq = ppmysql_query($querya, $link);
list( $username ) = mysql_fetch_row($userq);
ppmysql_free_result($userq);


This above you need to replace with this

list( $userid, $username, $email ) = get_userinfo("", $uid);


The current code is only coded to be used with a standalone install

[7thgencivic.com]

So replace all those old lines with that one line?

I did and still get

You're about to delete all the photos posted by the user "".

after delete, i get...
Bad uid for delete photos call.

[Chuck S]

I can suggest you download 5.2 incase your editing it incorrectly but I dont see an issue with the line here is the code block so your still not getting $username defined

$uid is already defined and when I click from a profile delete all photos by this user it works right with the code mentioned.

Content visible to verified customers only.

[7thgencivic.com]

well, i just copied and pasted the code here and I still don't get a user listed. Unfortunately my member area acess ended, so I can't dl 5.2, so I will need to get this fixed somehow.

[Michael P]

Does the top of adm-cats.php have:

Content visible to verified customers only.

Specifically, the uid => INT portion?

[7thgencivic.com]

this is what I have, uid is there, but some others are missing.

Content visible to verified customers only.

[Chuck S]

How about ppaction? is this on your typecast line

'ppaction => STRING

As long as ppaction and uid are on the typecast this is what I have at the bottom of adm-cats.php and the code does work. I am using vb3 just like you

Content visible to verified customers only.

[7thgencivic.com]

Originally Posted by omegatron

How about ppaction? is this on your typecast line

'ppaction => STRING

yes, but STR not STRING

As long as ppaction and uid are on the typecast this is what I have at the bottom of adm-cats.php and the code does work. I am using vb3 just like you

I copied all that code and still same issue.
The hidden uid in the form is not getting populated.

[Michael P]

What version are you running? They should be STRING, but maybe you have a BETA or something where we used STR?

How about copying the typecast as I posted them above and placing that into your file directly.

Also, check member.php and make sure they are set:

Content visible to verified customers only.

[Chuck S]

If he has a beta he might also want to edit pp-inc.php and replace the typecast function also so STRING is usuable right?

But then that also means he would want to edit all the files and replace STR with STRING in the typecasts also.

[7thgencivic.com]

no beta, i have 5.12

I will try changing those typecasts now

[7thgencivic.com]

ok, seems my compare missed some files. seems to be working now ecpt for one issue. I have the option turned on to show photo count and disk usage, but It's not there.

http://www.7thgencivic.com/memberrides/index.php

Is there another option that goes along with this?

[Chuck S]

What page are we talking about?

[7thgencivic.com]

The index page that tells ppl how many photos in the db and the disk space they are consuming.

[Chuck S]

Okay well I dont show any of the stats or sidebar turned on so none will display

[7thgencivic.com]

I don't want the sidebar, just the stats. It used to show above or below all the categories.

[Chuck S]

Right and in the stats bar if its on it will show but it needs to be on and everything else off

if ( $Globals['undercat'] == "yes" ) {
if ($Globals['sidebar_index'] == "no" || $Globals['sidebar'] == "off" ) {
include( "{$Globals['PP_PATH']}/{$Globals['TMPL_PATH']}/undercat.tmpl" );
}
else {
include( "{$Globals['PP_PATH']}/{$Globals['TMPL_PATH']}/undercat-sidebar.tmpl" );
}
}
elseif ( $Globals['statspal'] == "yes" ) {
include( "{$Globals['PP_PATH']}/{$Globals['TMPL_PATH']}/indexstats.tmpl" );
}

[7thgencivic.com]

so the stats bar is not the same as the pal thing?

[7thgencivic.com]

so when I go to
Admin > Index Options > Display photo and diskspace stats on index page? YES

I need to turn something else on? Shouldn't that something else also be in this section if that is the case?