Photopost Pro 701 update, SEO Bugs

[macuser]

I applied the 1/7 build, including the newest .htaccess file, and all other files.


1- showmembers.php, it always displays Page 1
2- showphoto.php (comments), it always displays Page 1

Example
gegen den Strom - MacUser.de Community Galerie
gegen den Strom - MacUser.de Community Galerie

3 - I got about 1500 mysql error mails

An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,date,title,description,ismature,
keywords,bigimage,width,height,filesize,views,medwidth,
medheight,medsize,approved,rating,votes,allowprint,numcom,
astposter FROM pp_photos WHERE userid= AND storecat=0
ORDER BY disporder,date DESC

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 'AND storecat=0 ORDER BY disporder,date DESC' at line 1

If you need assistence or feel this is a 'bug'; please report it to our support forums at: Photopost Pro Bug Reports - PhotoPost Community

To turn off these emails, set $debug=0 in your config-inc.php file.

my htaccess

RewriteEngine on
Options +FollowSymLinks

#RewriteCond %{DOCUMENT_ROOT}%{REQUEST_FILENAME} !-f
#RewriteCond %{DOCUMENT_ROOT}%{REQUEST_FILENAME} !-d

RewriteRule ^(.*)/p([0-9]+)-(.*)-cpage([0-9+]).html$ showphoto.php?photo=$2&cpage=$4 [L]
RewriteRule ^(.*)/p([0-9]+)-(.*).html$ showphoto.php?photo=$2 [L]
RewriteRule ^(.*)/p([0-9]+).html$ showphoto.php?photo=$2 [L]

RewriteRule ^g([0-9]+)-(.*)-page([0-9]+).html$ showgallery.php?cat=$1&page=$3 [L]
RewriteRule ^g([0-9]+)-(.*).html$ showgallery.php?cat=$1 [L]

RewriteRule ^(.*)/index([0-9]+)-([0-9]+).html$ index.php?cat=$2&page=$3 [L]
RewriteRule ^(.*)/index([0-9]+).html$ index.php?cat=$2 [L]

RewriteRule ^m([0-9]+)-(.*)-protype([0-9]+).html$ member.php?uid=$1&protype=$3 [L]
RewriteRule ^m([0-9]+)-(.*).html$ member.php?uid=$1 [L]

RewriteRule ^board.html$ board.php [L]
RewriteRule ^b([0-9]+)-(.*).html$ board.php?msg=$1 [L]

RewriteRule ^u([0-9]+)-(.*)-page([0-9]+).html$ showgallery.php?ppuser=$1&page=$3 [L]
RewriteRule ^u([0-9]+)-(.*).html$ showgallery.php?ppuser=$1 [L]

RewriteRule ^s([0-9]+)-(.*)-page([0-9]+).html$ showmembers.php?cat=$1&page=$3 [L]
RewriteRule ^s([0-9]+)-(.*).html$ showmembers.php?cat=$1 [L]

[Chuck S]

Showmembers is easy. two things. At top of that file move the typecast BELOW the path info stuff

Content visible to verified customers only.

Next find this line

Content visible to verified customers only.

Delete that and at the top of the file underneath the line noted add the code in bold

Content visible to verified customers only.

As far as showphoto you would need to post an explicit example because if all the new files are used there should be no issues as this was a reported and fixed bug.

[macuser]

thanks so much

showmembers is ok now

here is the example for the multipage comments

Content visible to verified customers only.

[Chuck S]

Change Line 2287 to this

Content visible to verified customers only.

[jdougher]

Are these bugs that we will all encounter? I'm holding off on this upgrade until I know it works.

[Chuck S]

well the 7.01 upgrades fixes all known issues the ones above where just reported.

[macuser]

Originally Posted by Chuck S

Line 2305 of pp-inc.php try changing to this

Content visible to verified customers only.

i changed the line, but unfortunately nothing happened

[Chuck S]

Thats what I get for starting at code too long. Line 2305 change -cpage back to -page and read my previous post

[jdougher]

Originally Posted by Chuck S

well the 7.01 upgrades fixes all known issues the ones above where just reported.

So a 7.02 will be coming shortly, then?

[macuser]

Originally Posted by Chuck S

Change Line 2287 to this

Content visible to verified customers only.

yeah, thanks

[Chuck S]

Have a good evening

[macuser]

Have a nice weekend

[Chuck S]

I will try

[Michael P]

I'll update the showmembers.php and pp-inc.php in the build to reflect these changes.

[macuser]

Originally Posted by Michael P

I'll update the showmembers.php and pp-inc.php in the build to reflect these changes.

showmembers.php in 1/9 build is ok

you have only update the pp-inc.php

[Michael P]

I did update the pp-inc.php file according to the above.