HELP! 1.4.3 upgrade didn't take

[Andrewmorrell]

Hi all...

I probably did something stupid, but I proceededwith my 1.4.3 upgrade from 1.4.2 (I've been getting a ton of spam).

I followed all the instructions properly to my knowledge. This is my result:

"Coming Soon! Nothing to show. No image to show here!"

NOTHING changed at all except for the pixelpost.php file and my index.php file. Here is my General Info stuff from my admin page:

Host Information:
PHP-version 4.3.11 (Pixelpost's min requirement: PHP version 4.3.0)
MySQL version 4.0.25-standard (Pixelpost's min requirement: MySQL 3.23.58)

GD-lib bundled (2.0.28 compatible) with JPEG support

Server software Apache/1.3.33 (Unix) DAV/1.0.3 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.11 FrontPage/5.0.2.2635 mod_ssl/2.8.22 OpenSSL/0.9.7a

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


Paths:
Guessed imagepath: /home/admmmb44/public_html/photoblog/images/
Configured Imagepath /home/admmmb44/public_html/photoblog/images/

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

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

Language Directory: OK

Addons Directory: OK

Includes Directory: OK

Templates Directory: OK


What have I done wrong? I've emptied the cache and rebooted Safari...

Thanks in advance...

Andrew

[dkapp]

Were you sure you put the correct info in your pixelpost.php file before uploading?

Dave

[Andrewmorrell]

Were you sure you put the correct info in your pixelpost.php file before uploading?

Dave

I'm pretty sure - I remember reading that once you see the message "Coming Soon! Nothing to show. No image to show here!" then all is configured properly, it's just waiting for images. I have 82 images in a folder already.

[blinking8s]

check the database to see if your data is still there...

[Andrewmorrell]

check the database to see if your data is still there...

Thanks for the quick reply - how do I know where to look? The images are all still in the folders (both thumbs and regular)... my database has this info:

Users in data1:
admmmb44_ (Privileges: ALL PRIVILEGES)

Connection Strings:

Perl:
$dbh = DBI->connect("DBI:mysql:admmmb44_data1:localhost","admmmb44_","<PASSWORD HERE>");

PHP :
$dbh=mysql_connect ("localhost", "admmmb44_", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("admmmb44_data1");

[blinking8s]

well, if its saying coming soon, nothing to show...then its not reading the 82 images in the database...so odds are something in pixelpost.php is not correct

[Andrewmorrell]

well, if its saying coming soon, nothing to show...then its not reading the 82 images in the database...so odds are something in pixelpost.php is not correct

I'm looking this over, up and down and my info is correct in pixelpost.php:

$pixelpost_db_host = "localhost"; // database host, often "localhost"
$pixelpost_db_user = "admmmb44"; // database user
$pixelpost_db_pass = "xxxxxxxxxxx"; // database user password
$pixelpost_db_pixelpost = "admmmb44_data1"; // database

I check my database in my control panel and it all checks out fine:

Checking Database
admmmb44_data1 is now being checked.
admmmb44_data1.pixelpost_ban OK
admmmb44_data1.pixelpost_catassoc OK
admmmb44_data1.pixelpost_categories OK
admmmb44_data1.pixelpost_comments OK
admmmb44_data1.pixelpost_config OK
admmmb44_data1.pixelpost_meta OK
admmmb44_data1.pixelpost_pixelpost OK
admmmb44_data1.pixelpost_stats OK
admmmb44_data1.pixelpost_version OK
admmmb44_data1.pixelpost_visitors OK

This is nuts!

[dkapp]

What value do you have for $pixelpost_db_prefix

Did you change it on the first install from the default value and not change it on the upgraded file?

[tinyblob]

You mentioned "Connection Strings", that sounds like cPanel. Is there a link below for "phpmyadmin"?
If you log into phpmyadmin you can browse your database, and see if all the entries are still in there..

[raminia]

1.4.2 to 1.4.3? no installation just copy paste.....ummm

[Andrewmorrell]

You mentioned "Connection Strings", that sounds like cPanel. Is there a link below for "phpmyadmin"?
If you log into phpmyadmin you can browse your database, and see if all the entries are still in there..

Thanks for that - I went in and it appears to be empty. I have no idea why.

[blinking8s]

contact your host, see if they have a backup of the database

although pixelpost should not write over the data

[Andrewmorrell]

contact your host, see if they have a backup of the database

although pixelpost should not write over the data

Thanks for all of help blinking - I contacted my isp this morning for exactly that reason. I appreciate all of your help.

[Andrewmorrell]

Good news - my ISP restored my db from the previous day. Everything is back to normal. So, I will BACKUP and then try the upgrade again. Thanks all for your help.

[dkapp]

I'm glad its working again. I really wonder what caused the problem during the upgrade?

[tinyblob]

The upgrade process from 1.4.2, to 1.4.3 is literally as follows:

* Download 1.4.3
* Open includes/pixelpost.php
* Edit the database information
* Upload the new includes/pixelpost.php, overwriting the current version
* Upload the new index.php, overwriting the current version

If you ran install.php, i imagine that caused the problem. The update from 1.4.3 to 1.4.2 is a fairly minor change, so you only need to overwrite files. There's no structural database change.

[zac]

I am having a similar problem but I dont think it is my database. I can still see all of the images and access the admin menu but when I try and see the blog itself I only get a white screen.. no text at all. weird. I am sure my database info is correct.. any ideas as to what is happening?

THankks!

Zac

[tinyblob]

Zac, can you go into your admin section, then click on general information and copy/paste the text in these sections:
* Pixelpost Version
* Host Information
* Paths

That might help us :)

[zac]

I tried to switch it back to version 1.4.2 but it is still screwed up :( Here is the current info:


Pixelpost Version
You are running version 1.4.2 of Pixelpost. Released 18 July 2005.
Latest pixelpost version: Check

Looking for help or want to give feedback, please step into pixelpost forum.
www.pixelpost.org/forum/

Host Information
PHP-version 5.0.5 (Pixelpost's min requirement: PHP version 4.3.0)

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

GD-lib bundled (2.0.28 compatible) with JPEG support

Server software Apache/1.3.34 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.25 OpenSSL/0.9.7a PHP-CGI/0.1b

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

Paths
Guessed imagepath: /home/zacfolk/public_html/blog/images/

Configured Imagepath /home/zacfolk/public_html/blog/images/

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

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

Language Directory: OK

Addons Directory: OK

Includes Directory: OK

Templates Directory: OK

[Joe[y]]

(for those with php5 experience.. note that it's present on that setup) - i'm a waste of space when it comes to php5 knowledge.

[tinyblob]

When you upgraded to 1.4.3 did you also copy over the new includes/pixelpost.php ?

If not - do so!

[Joe[y]]

check out: http://forum.pixelpost.org/showpost.php?p=16349&postcount=14
and : http://forum.pixelpost.org/showpost.php?p=16409&postcount=16

[zac]

Hmmm no luck. Yes I tried again and copied those two files over again. I also tried the changes those two posts suggested :( It is weird because I have 3 other versions of PP running and they upgraded no problemo.

[zac]

should I update?

[tinyblob]

Did this pixelpost install ever work Zac?

[zac]

Yea it was totally fine untill I tried this upgrade.

[SteveO]

Hi I have the same problem, my Pixelpost installation was working fine untill i tried 1.4.3, then i got nothing but a blank screen when trying to view the site. All the admin section works perfectly though and it says that the version is 1.4.3 so there must be something wrong in the index.php file.

I have no idea how to fix this so some help would really be appreciated.

[Joe[y]]

did anybody listen to meeee?! helloooooooo.


ask your host if your php version was updated recently? this could have been the problem.

[zac]

Helllooooo Joe[y] I didnt think that was relevant because my other 3 installs took the upgrade to 1.4.3 no problem. I asked my host and they vaguely replied: "within the recent weeks we have updated this server from I believe PHP 4.3.11 to PHP 5.0.5".

[tinyblob]

Argh, everyone seems to be moving to PHP 5. What's wrong with PHP 4.4.1!

[blinking8s]

php5 sucks...not really, but i dont think its solid enough to update unless its personal use...a shared server its just a big headache

[tinyblob]

yeah, which is the reason it's a separate branch of the code. but yet hosting companies are blindly updating to it. *sigh*

[zac]

hmm..yes this sucks... WHat is the damage here? I tried to reinstall the older version of PP and it still didnt seem to work. Does that make any sense? Also, any idea as to why my other PP installs and upgrades worked fine? I am pretty sure that they were upgraded after the php upgrade. Thanks for helping with this.. my host is interested in the outcome but dont know this script so cant do much.

[tinyblob]

If i'm right, the beta of v1.5 is PHP5 compatible, but it's still a couple of bugs away from being ready to release.
For now, try making these changes:
http://forum.pixelpost.org/showpost.php?p=16349&postcount=14
http://forum.pixelpost.org/showpost.php?p=16409&postcount=16