index.php?=showimage0

[dalejason]

I have recently gone through the trauma of moving hosts and learning how to export / import SQL database etc. I was previously using PP1.3. When I installed pp1.3 with the exported DB to my new host everything was fine. Until I started to post images backdated (been off line for almost 2 months) and from yesterday. I found that the links generated by PP between the images & thumnails were not working correctly. I also noticed that when the cursor hovers over the thumbnail or image I get the following url displayed in the bottom left corner of the browser.

http://www.mycameraobscura.com/index.php?=showimage0

It seems all the images I post now have the same url /index.php?=showimage0
If I go into admin and delete 1 of these images it will delete them all.

I have now upgraded to V1.5rc and I still have the same problem. Does anyone know what I can do to put it right?

I have put a fresh install of pp at http://www.swolen.jasondale.com and it seems to work fine so I know the 1.5rc version I have is ok.

I hope this has not already been posted elsewhere (I did have a look) but any help would be very much appreciated ;-)

[Joe[y]]

what is the php version etc (all can be found in your admin) for the server that isnt working?

[dalejason]

From the admin panel this is the info...

Host Information

URL http://www.mycameraobscura.com/admin/index.php
PHP-version 4.3.10 (Pixelpost's min requirement: PHP version: 4.3.0 )

MySQL version 4.0.23-standard (Pixelpost's min requirement: MySQL: 3.23.58 )

GD-lib bundled (2.0.28 compatible) with JPEG support

File Uploads to pixelpost site are possible.

Server Software Apache/1.3.33 (Unix) mod_ssl/2.8.24 OpenSSL/0.9.7a PHP/4.3.10 mod_perl/1.29 FrontPage/5.0.2.2510

EXIF Pixelpost is using exifer v1.5 for EXIF-information.


Paths
Guessed imagepath: /home/jasond/domains/mycameraobscura.com/public_html/images/
Configured Imagepath: /home/jasond/domains/mycameraobscura.com/public_html/images/

Image Directory: OK - Can we write to the directory? YES. CHMOD: 0777

Thumbnails Directory: OK - Can we write to the directory? YES. CHMOD: 0777

Language Directory: OK

Addons Directory: OK

Includes Directory: OK

Templates Directory: OK

[GeoS]

Check which ID is used as last in *_pixelpost table and then check which will be used for next entry (Next Autoindex value in table properties). It should be one bigger then the last used.

[dalejason]

Hi, thanks for the support.. I'm no expert with SQL infact this is the first time I have used it and i'm not really sure what I'm doing.

I managed to edit the entry in table pixelpost_pixelpost for image 503 from 0>503 and now the thumbnail works ok. But I cant find / edit the Autoindex value you mention. Where can I see / find this? I am using php myadmin.

[dalejason]

Well I think it is now. I found ID defult was set to 0 and no auto increment was set. I have changed this to the last posted number (503) and set it to auto increment. The last two posts have worked ok.

Thank's for pointing me in the right direction, I wouldent have had a clue what to do. :-)

[GeoS]

No problem.
Im happy that it solved your problem :)