weird problems when scanning database.

[Mamma]

hi there, i do have a problem similar to the described in this thread:

Error: scan database, rebuild

some of the thumbnails rebuild correctly, and then

Content visible to verified customers only.

and so on, some of the pics process, some fail for some reason. look at this also

Content visible to verified customers only.

[Chuck S]

All of your data directories are not 777

You need to ensure that the data directory at every level in every numeric catid and every thumbs medium mini directory is at 777.

[Mamma]

Chuck,

sorry, but did this first time seeing this error. the dirs ARE writeable by the apache user, there is no problem with that (drwxrwxrwx, actually i've did [root@reply data]# find . -type d -exec chmod a+rwx \{\} \;
[root@reply data]# find . -type f -exec chmod a+rw \{\} \;
[root@reply data]# chown -R apache *
[root@reply data]#
just to be sure)

before posting here.

please take a closer look to the errors - i'm too tired to look at it in detail, but you'll notice "small" mis-something. in the cat numbers. actually, this posts are moved between cats, and maybe somewhat the ppc is trying to do something nasty - it tries to use different path, for example
it says that will create thumb

data/29/thumbs/IMG_0011.jpg

and barfs at

data/34/thumbs/

[Mamma]

more info, this is the line barfing:

Content visible to verified customers only.

i've put some debug echo just above the 'switch' containing some debug echo:

Content visible to verified customers only.

and got something - this one is good

Content visible to verified customers only.

and this one is angry

Content visible to verified customers only.

you see, in second case (i've got several, maybe more than 10, like this) ppc is trying to create thumbnail with path containging only dir name, and even then this is the wrong dir, and w/o filename!.

[Chuck S]

Warning: imagejpeg(): Unable to open '/home/prodavalnik/public_html/ppc/data/43/thumbs/' for writing in /home/prodavalnik/public_html/ppc/image-inc.php on line 143
failed!

Check those specific directories which have the error. it is telling me the thumbs directories either do not exist or are not 777

[Mamma]

Chuck, i've already told you, they are checked. And specifically showed you the dirs in my first post. And i've specifically showed you the commands i've used to chmod all of the dirs in data subdir to 777, and all of the files to 666. and just to be pretty sure i've chowned them agan to apache, altoug all of the data dir was preivously owned by the same user which the httpd is running as.

Please, it is not the permissions, and, please, read my post carefully, the ppc is trying to write to file with path only with directory name, (and it is different dir).

trying to write file with name /home/prodavalnik/public_html/ppc/data/43/thumbs/ istead of /home/prodavalnik/public_html/ppc/data/43/thumbs/file.jpg is resulting an error, so this error is the symptom not the cause. the cause is mis-computed or whatever destination, please take a look at the debug echoing, and you will understand.

[Chuck S]

If the issue is as you say then it would not work for any images it would try writing to a directory not file name so what is the special case on those images in question you have links you have something to assist in diagnosing this.

I suggest the first thing you do is make sure your using the current download and we can go from there as this is nothing I can replicate.

[Mamma]

Chuck, i will report when i do solve my problem with this issue.

[Chuck S]

Are you going to give more info here so we can try to assist like urls to the images that have trouble etc or are you going to try solving this yourself.

Are you using the latest downloadable code or old code?

That is basically what my last post was saying to post more info.

[Mamma]

chuck, during the investigation i've hit a major problem, maybe related with this issue.

if there are two posts in two categories, containing photos with same filename, it is ok.

but if you do move one of the ads in the same category as the other one, the filenames do conflict and one of the ads ends up with other ad picture.

if the ads are in the same category when posted first time, there is no problem if the names are identical, only when moving.

please, confirm. my site is already launched and i do need quick fixes.

edi

Originally Posted by Chuck S

Are you going to give more info here so we can try to assist like urls to the images that have trouble etc or are you going to try solving this yourself.

Are you using the latest downloadable code or old code?

That is basically what my last post was saying to post more info.

[Chuck S]

You must have a very old classifieds again so I ask what version you running.

Our classifieds code for some time has image check that is not dependent on category so this would never happen. There is no easy fix that I can provide on this as it is going to take awhile to track down the old code retrofix a backwards code fix for you.

My suggestion has been update to the latest code which should mean your scan database should run fine and as far as the image move the classifieds content is very temporary and the sendnotice.php script expires ads. This issue is only seen using old code so the new code should for new ads when moving them work fine.

[Mamma]

hm, let's see.

Current Version 2.5

from the Statistics on the running forum.

i've started with 2.5, 1709626 Jun 22 00:00 pp-classifieds25.zip
right now i'm using 1710774 Aug 29 00:27 pp-classifieds25a.zip
renamed it to 25a cause the zips was different by size but with same filenames.


by the way what's the way to check the real version and build time in pp?


so it does not seem to be very old version.

sending you a link to my image-inc.php, there is only one line different,and right now it is commented out:

Content visible to verified customers only.

Originally Posted by Chuck S

You must have a very old classifieds again so I ask what version you running.

Our classifieds code for some time has image check that is not dependent on category so this would never happen. There is no easy fix that I can provide on this as it is going to take awhile to track down the old code retrofix a backwards code fix for you.

My suggestion has been update to the latest code which should mean your scan database should run fine and as far as the image move the classifieds content is very temporary and the sendnotice.php script expires ads. This issue is only seen using old code so the new code should for new ads when moving them work fine.

[Chuck S]

adm-misc.php is the proper file that handles that and since I can not duplicate this I suggest if you want assistance to send server info

[Mamma]

chuck,

i've managed to cut some time and tried with fresh install, and fresh ppc downloaded. unfortunately, i guess i've confirmed the bug, see below how to reproduce:

Content visible to verified customers only.

in phpmyadmin:

MySQL - 4.1.20-standard-log
created database pptest collation latin1_general_ci
added user pptest with pass testpp and host "localhost"
did give it some privileges on the database:

GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX , ALTER , CREATE TEMPORARY TABLES ON `pptest` . * TO

'pptest'@'localhost';


and started with the install.

Welcome to the PhotoPost Classifieds Installation console!

You are only minutes away from having PhotoPost Classifieds up and running on your server. This installation will take you through a few steps

to get everything configured and running smoothly. Make sure to take the time to verify your settings so that once installation is complete, you

will be ready to launch PhotoPost!

The next step will test your server to ensure that it has the necessary modules installed to run PhotoPost Classifieds and it will also set up your

database for use.

Click here to start a fresh install -->

et cetera, i do have screenshots of all steps.

after the install:

Content visible to verified customers only.

then, created a second sub-category of the default Main category, called 'test' with default options, just pressed the button, acepting the options.

in phpmyadmin added lock table privilege, just to make it easier to dump sql.

------
REVOKE ALL PRIVILEGES ON `pptest` . * FROM 'pptest'@'localhost';

GRANT SELECT ,
INSERT ,

UPDATE ,
DELETE ,
CREATE ,
DROP ,
INDEX ,
ALTER ,
CREATE TEMPORARY TABLES ,
LOCK TABLES ON `pptest` . * TO 'pptest'@ 'localhost';

-----------


[root@echo pptest]# mysqldump -u pptest -p pptest >dump0.sql
Enter password:
[root@echo pptest]#

we've prepared 6 images, 3 sets of two images, in 3 different dirs in the user pc, with almost all filenames duplicate, but with different iamge -

text "adp1" "ad1p2" "ad2p1" et cetera:

ad1/photo1.jpg text ad1p1
ad1/photo2.jpg text ad1p2
ad2/photo1.jpg text ad2p1
ad2/photo2.jpg text ad2p2
ad3/photo1.jpg text ad3p1
ad3/photo3.jpg text ad3p2

added ad 1 with two pictures from dir ad1 in the first subcat, dumped and ls -laR:

Content visible to verified customers only.

added ad #2 in the second subcat and after that:

Content visible to verified customers only.

everything seems to be ok - ad1 has their two pictures, ad2 - the appopriate for the ad 2 ones.

then, suddenly, we move ad2 from the second subcat to the first subcat. let's make dump and ls -laR

Content visible to verified customers only.

and now we have some pretty deep **** - in the first cat there are the two ads, but ad number one is shown the pictures from ad number two. ad

number two show correctly.

let's upload ad number 3 - it will have two images, but only the first image will be with the same filename, dump to dump4.sql and ls -laR to

ls-laR4:

Content visible to verified customers only.

the 3th ad is okay, so let's move it too to the first subcat....
and, suprise!

ad1 now has "ad3 photo1" and "ad2 photo2"
ad2 now has "ad3 photo1" and "ad2 photo2"
ad3 has "ad3 photo1" and "ad3 photo2"

ergo - there is a problem with same filenames.

lets shot it:

Content visible to verified customers only.

that's all folks.

Chuck, i'm sending you links with the files in PM, they're zipped.

edi.
PS tried on 2 centos machines and one fresh debian. guess you can reproduce the bug in "the lab" now...
PPS

md5sum pp-classifieds25-8-16-06-1-39PM.zip
95e89020e7a3b9b7f2c46f86f3a71213 pp-classifieds25-8-16-06-1-39PM.zip

Originally Posted by Chuck S

adm-misc.php is the proper file that handles that and since I can not duplicate this I suggest if you want assistance to send server info

[Chuck S]

http://www.reeftalk.com/classifieds/showcat.php?cat=2

We check for image name for original image and removed the check to be global but I see two places where it only does it per userid so any works with a tweak there.

If you post or PM me an email I can sent you a file to try to see if you upload the same files are they renamed

[Mamma]

right now.

Originally Posted by Chuck S

http://www.reeftalk.com/classifieds/showcat.php?cat=2

We check for image name for original image and removed the check to be global but I see two places where it only does it per userid so any works with a tweak there.

If you post or PM me an email I can sent you a file to try to see if you upload the same files are they renamed

[Chuck S]

Sent the file its the one I used shown in my test using the exact steps you outlined and there is no issue using that file