Recap - 6.02 To 6.1 My Upgrade Issues & Fixes

[TEAMBAJAMARINE]

Issue: templates/vb3enhanced/register.tmpl This file in the 6.1 release package is not there when you download it. But, it shows it as a updated file in the release post.

Resolution: So if you use PhotoPost with vB3 enhanced mode, there is no register.tmpl script used; all registrations occur through vBulletin, so there is no need to worry about this missing file in the doiwnload package.

Issue: Some user avatars do not show up, but others do.

Resolution: In forum/vb3.php find this code: if ( $hasav ) and replace with this code: if ( $hasav != "" ) then find this code: elseif ( $vboptions['usefileavatar'] && $hasav == 1 ) and replace with this code:
elseif ( $vboptions['usefileavatar'] && $hasav != "" )

Issue: Upon uploading of photos you may see this error sent via email: An error was encountered during execution of the query:
UPDATE pp_categories SET thumbnail= WHERE id=34
The query returned with an errorcode of:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id=34' at line 1

Resolution: In adm-misc.php Line 560 find this code: ppmysql_query("UPDATE {$Globals['pp_db_prefix']}categories SET thumbnail=$lastphotoid WHERE id=$origcat", $link); and replace with this code: ppmysql_query("UPDATE {$Globals['pp_db_prefix']}categories SET thumbnail=$pid WHERE id=$origcat", $link);

Issue: If you get this error sent to your email address, An error was encountered during execution of the query:

SELECT * FROM pp_photos WHERE cat IN (****,Array) ORDER BY date DESC LIMIT 50

The query returned with an errorcode of:

Unknown column 'Array' in 'where clause'

Resolution: There is a code fix needed for the external.php, find this code:
if ( $ppuser )
{
$cats = "WHERE userid=$ppuser";
}
else
{
if ( $cat )
{
$children = ppmysql_query_one("SELECT children FROM {$Globals['pp_db_prefix']}categories WHERE id=$cat LIMIT 1", $link);

if ( $children )
{
$cat = "$cat,$children";
}

$cats = ( $cat ? "WHERE cat IN ($cat)" : null );
}
}
and replace with this code:
if ( $ppuser )
{
$cats = "WHERE userid=$ppuser";
}
else
{
if ( $cat )
{
list( $children ) = ppmysql_query_onerow("SELECT children FROM {$Globals['pp_db_prefix']}categories WHERE id=$cat LIMIT 1", $link);

if ( $children )
{
$cat = "$cat,$children";
}

$cats = "WHERE cat IN ($cat)";
}
}

[Chuck S]

Thanks I do beleive we have responded to this in other support threads.

[TEAMBAJAMARINE]

Chuck, Yes both you and Michael have been great with support and I just wanted to compress these issues into one thread. Thought it would be helpful for others.

[Chuck S]

Got ya have a good weekend.