Print

[Jobin]

Hello guys!! Sorry but I have a little problem with a site, well I moved the site to a new host some months ago, but the problem is that I saved part of the .sql file, so the comments on the pictures are saved, but I had to upload all the pics again so the names of the pics are not the same! Now I have like 10 comments invisible because I can see them in the in the .sql file but not in the site, I think because the pic of that comment is not named as it was before moving the gallery! I wanted to know if there is a way to know the name of that picture, the name it had, so I can have that comment matched to that picture!

Quite complicated and perhaps I wasn't very clear...I know... but probably you can help me...!

Thanks!!

[Nibbler]

It's not about names but the order you uploaded them. Edit the comments table in phpmyadmin and make sure the pid on the comments table lines up with the pid in the pictures table.

[Jobin]

Uhm sorry but I dind't understand very well...what do you mean with pid?? sorry for my ignorance

[Jobin]

Ok! I found the pid, but I saw that in pictures there is:

     pid     int(11)               No         auto_increment

While in comments:

     pid     mediumint(10)               No     0     

What do I have to do?!

[Nibbler]

Browse through the comments table and make sure the pid in the comments table is pointing to the correct picture. If it is wrong then change it.