Error After Server Change

[Blitz]

I recently changed servers for my hosting to allow for more space. Soon after the switch was done I realized I was getting this error on my photoblog:

Connect DB Error: Access denied for user: 'blitz_Blitz@localhost' (Using password: YES) Cause #2

Cause #2:There might be a database connection problem that prevent this website to work properly. This can be caused by wrong db configuration in the admin side (file: includes/pixelpost.php) or the MySQL server might not reponding to Pixelpost's requests. Make sure that you have followed installation procedure in setting up database connection for Pixelpost.

I have no idea what to do! I've searched the forums and couldn't find anything (but the problem is probably that I don't really know what keywords to search for, I tried all the obvious ones :P).

My photoblog is at http://www.mediasoldier.net/photography


Thanks in advance,

Trevor

[Dennis]

Ok. I'll try to explain.


There might be a database connection problem that prevent this website to work properly.

Well, there might be a database connection problem that prevents your website to work properly.


This can be caused by wrong db configuration in the admin side (file: includes/pixelpost.php)

Well, it seems Pixelpost stores its configuration to access this database thingie in a file located in the includes folder and named pixelpost.php

or the MySQL server might not reponding to Pixelpost's requests.
Basically what this says if you provided the correct information you should be able to connect to this database. If not, your hoster has some issue to fix.


Make sure that you have followed installation procedure in setting up database connection for Pixelpost.
Aha, there seems to be an installation procedure you have to follow.

Now on to my educated guesswork: you moved hosts. It is not unlikely that the user of the database is different in your new setup compared to the old setup. It is also likely (but not sure) that the database name has changed.

So, what I would do is update the includes/pixelpost.php file with the new information (e.g. database user and databasename.) If you don't have this information I would suggest to contact your hoster.

[Blitz]

This has been really frustrating. I'm absolutely sure everything is correct, i tried making a new database/user etc and using that and it worked fine (minus the fact I don't want to reinstall pixelpost, but the blog itself was working with the other username etc.)

I did everything you said and my host says everything should be fine. I have no idea whats wrong but this will probably help:

I get this error when I try to access the admin control panel:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'blitz_Blitz@localhost' (Using password: YES) in /home/blitz/public_html/photography/includes/functions.php on line 228

One problem, line 228 for me is a blank line, just a space between two others. And each of this look fine, nothing to do with usernames, databases or anything... I'd really love to get my blog back up and running.

Any help would be appreciated

[dakwegmo]

What version of PP are you running? If you're running 1.6, you should have something on line 228 of the functions.php file. You may want to try re-uploading the file.