Upgraded from 4.8 to 5.2 - No pictures there even though they are still on the server

[fonzerelli_79]

i upgraded my forum to 3.5 the other day. The gallery didnt integrate with it so i renewed my members area here, downloaded 5.2.

I also have reviewpost on my forums. I backed up all files and the databases for my gallery and my review sections.

The installation method for both pieces of software is identical. Review post upgraded with no problems

Photopost upgraded fine as well however i noticed that thumbnails were not being generated and an error occured (saying line 912 in showphoto.php isnt working - is_wysiwyg_compatible() )

So i scanned the database and selected regenerate thumbnails

Now as it stands i have comments and posts showing on the gallery homepage but no pictures.....no thumbnails either. It says there are no pictures at all in the database


Now i know this will be resolved. I have a backup of the database before the upgrade, i have the old 4.8 files and the pictures are still on my server and on my pc.

This is my 4th or 5th upgrade. I vaguely remember this happening before. Its clearly got to do with photopost not knowing where the pics are....but i cant recall how i resolved the issue


Any help on this matter would be greatly appreciated

Kind Regards,

Kevin

[fonzerelli_79]

just searched my own posts

this is how i resolved it before (Taken from here)

This may help some of you

for those of you stuck at step 2, you need to make sure all files are set to 777

use this

chmod 777 -R data


ok - i had accidently ran step 3 twice as well
when this happens it screws up the location of the images and makes an image filename-003003 instead of filename003

to fix it drop your photopost gallery and restore it and then run through the upgrade again - making sure that the permissions etc i mentioned in my above post are sorted

[fonzerelli_79]

unfortunately, this isnt resolving it

i dropped the database and reuploaded the 4.85 database, all files are chmodded correctly too.

when i run the upgrade i get this error at step 1 (which ive noticed a lot of members have)

Preparing to update 4.8.5 database...
Error performing MySQL command: ALTER TABLE photos ADD numcom INT(8) DEFAULT '0' NOT NULL , ADD lastposter VARCHAR(255), ADD lastpid INT(8) DEFAULT '0' NOT NULL
Error: Duplicate column name 'numcom'

Error performing MySQL command: ALTER TABLE categories ADD maximages INT(12) default '0' NOT NULL, ADD canzip VARCHAR(3) DEFAULT 'no' NOT NULL, ADD frames VARCHAR(32) NULL
Error: Duplicate column name 'maximages'

Error performing MySQL command: ALTER TABLE categories ADD numextra INT(3) default '0' NOT NULL
Error: Duplicate column name 'numextra'

Error performing MySQL command: ALTER TABLE categories ADD intro VARCHAR(3) default 'no' NOT NULL, ADD introtitle VARCHAR(128) DEFAULT NULL, ADD introcopy TEXT DEFAULT NULL, ADD moderators TEXT DEFAULT NULL
Error: Duplicate column name 'intro'

Error performing MySQL command: ALTER TABLE categories ADD ratingtype INT(1) DEFAULT '0' NOT NULL, ADD takevotes INT(1) DEFAULT '0' NOT NULL
Error: Duplicate column name 'ratingtype'

Error performing MySQL command: CREATE TABLE photoviews (photoid mediumint(9) NOT NULL default '0') TYPE=HEAP
Error: Table 'photoviews' already exists

Error performing MySQL command: CREATE TABLE extrafields (id INT(12) NOT NULL AUTO_INCREMENT, cat INT(12), fieldname VARCHAR(255), fieldtype VARCHAR(2), fieldoptions TEXT, PRIMARY KEY (id) )
Error: Table 'extrafields' already exists

Error performing MySQL command: CREATE TABLE photoextras (id INT(12) NOT NULL AUTO_INCREMENT, photo INT(12), extraid INT(12), selection TEXT, PRIMARY KEY (id) )
Error: Table 'photoextras' already exists

Error performing MySQL command: ALTER TABLE users ADD cellphone VARCHAR( 255 )
Error: Duplicate column name 'cellphone'

step 2 goes fine. Step 3 (which i know can only be run once) has errors too.

This is a common error ive noticed among the forums too. Its the one that starts

Warning: unlink(/home/mysitelocation/gallery/dcfp_auth_lib.php): Permission denied in /home/mysitelocation/gallery/upgrade.php on line 1936

at step 1 of 5.0 i get this error

Warning: unlink(/home/mysitelocation/gallery/adm-userg.php): Permission denied in /home/mysitelocation/gallery/upgrade.php on line 2097

Warning: unlink(/home/mysitelocation/gallery/adm-approve.php): Permission denied in /home/mysitelocation/gallery/upgrade.php on line 2098

Warning: unlink(/home/mysitelocation/gallery/adm-db.php): Permission denied in /home/mysitelocation/gallery/upgrade.php on line 2099

Warning: unlink(/home/mysitelocation/gallery/adm-menu.php): Permission denied in /home/mysitelocation/gallery/upgrade.php on line 2100

after this, each step goes without any errors

After the installation im back to my original problem. ie. no thumbnails for every image and when you click on it you get this error

Fatal error: Call to undefined function: is_wysiwyg_compatible() in /home/mysitelocation/gallery/showphoto.php on line 912

do you know what causes all this. I know that the errors are messing up the filenames so the database doesnt know where the pics are....but im not sure why these errors are occuring and i dont know how to resolve them

[fonzerelli_79]

could a photopost staff member please get back to me on this within the next 24 hours

[Chuck S]

Well unlink issues on files are of no concern since you already deleted them or your server does not allow you to delete them by script at any rate you can delete them normally.

Now duplicate mysql errors saying field already exists are of no concern either. Your fields already exist cause you already ran that upgrade.

You only need to ensure to properly restore just the photos table and rerun the upgrades making sure in 485-486 upgrade is ONLY RAN ONCE. you should be fine after that

[fonzerelli_79]

Originally Posted by Chuck S

Well unlink issues on files are of no concern since you already deleted them or your server does not allow you to delete them by script at any rate you can delete them normally.

Now duplicate mysql errors saying field already exists are of no concern either. Your fields already exist cause you already ran that upgrade.

You only need to ensure to properly restore just the photos table and rerun the upgrades making sure in 485-486 upgrade is ONLY RAN ONCE. you should be fine after that

I understand you guys are busy but i am very busy as well, which is why i took the time to write down every single detail and the errors that are occuring. If you read through my posts above you will see that is exactly what i have been doing - and it is not fine.

i have only run the upgrade script once each time....after it doesnt work i drop the photo tables and restore them to the way they were before the upgrade (the tables that work perfectly with the 4.85 files) and try from the beginning.

If, as you say, the errors are of no concern, then what is causing the no thumbnail problem and error when i click on the image link?

As mentioned, ive had photopost for over a year however the steps i took to resolve this issue when i upgraded to 4.85 do not seem to be fixing it.

I am not alone in this.....im usually reluctant to post queries such as this. I searched through the forums and saw that no one has had this resolved as yet...which is why im posting this.

Is it possible to talk via msn messenger or something similar....i can show you exactly what is happening and you can go through the upgrade yourself if you wish.

In short, the upgrade does work...however the path of all files etc get messed up. How do i resolve this??

[Chuck S]

You only brought up 3 issues and I answered all 3. Duplicate mysql issues and unlink for files are not an issue. It means as I stated you have already ran those upgrades and as far as the files you can delete those by hand as your server does not allow them to be deleted by the script.

The upgrade does clearly work.

Every single post on the issue of losing thumbnails after the 4.85 is because the upgrade last step was run more than once resulting in the userid being prepended on the photos more than once.

If you email me your site and login I can take a look to see what your issue is and get you setup

[fonzerelli_79]

ive sent the details to the email you have in your sig