Page 1 of 1

[SOLVED] Having problems saving to old databases

Posted: Wed Oct 06, 2010 11:21 pm
by DEAPNESS
Hello,

Hope the title describes my situation.

I have an unmanaged VPS where I did the worst typo possible (chown -R username:www-data / <-- I accidently hit enter after that / :banghead: :banghead: :banghead: :banghead: :banghead: ) so I've had to completely rebuild my server and reinstall PHP.

Anyway, I got everything working and I just went into my old servers mysql folder, copied just the database folders, and then added them to my new servers mysql folder. Everything seemed to work fine, all my sites loaded as they should and all the data from the databases transfered over.

But here is the problem: I cannot change anything. IE: If I go into Wordpress and create a new post, when I hit publish, it just sends me back to the posts page with nothing changed This same thing happens if I try to save settings, install new applications, etc. Anything that involves changing info on the databases.

I also have tried to make a new database and install vBulletin to it but it is having the same issue. However there is a whole bunch of "Deprecated" errors on the install page and this error also shows up after I try and go to the next page:

Warning: Cannot modify header information - headers already sent by (output started at /install/init.php:44) in /install/authenticate.php on line 55

And here is one of the deprecated errors:

Deprecated: Assigning the return value of new by reference is deprecated in /install/init.php on line 44

I've tried to search for answers but I don't really even know what to look for. I think the error happened when I was installing php. I first started to install php and fastcgi and installed it but when I tried to turn on fastcgi it gave me an error. So I decided to go to another tutorial (I am pretty newb at this stuff tbh. I completed pretty much everything on here using the vps bible if that helps) that was installed PHP-FPM (Separate) Installed from Source and everything installed fine there.

Thanks in advance for any help!

Re: Reinstalled PHP and it connects but doesn't update

Posted: Wed Oct 06, 2010 11:28 pm
by requinix
DEAPNESS wrote:I just went into my old servers mysql folder, copied just the database folders
Did you change the ownership on those files to belong to the MySQL daemon? Set the right permissions?

The other errors are faults with WordPress. I recommend you just leave them alone - it was working fine before, right?

Re: Reinstalled PHP and it connects but doesn't update

Posted: Thu Oct 07, 2010 10:59 am
by DEAPNESS
tasairis wrote: Did you change the ownership on those files to belong to the MySQL daemon? Set the right permissions?

The other errors are faults with WordPress. I recommend you just leave them alone - it was working fine before, right?
I totally thought this was the problem but, unless I didn't switch everything over right which could very well be the case, it wasn't. I set the files for the mysql file to mysql:mysql (user and group). Still same problem.

I'm not sure what you mean about the Wordpress errors, I think you meant to say vBulletin in that line. Am I correct?

Re: Reinstalled PHP and it connects but doesn't update

Posted: Thu Oct 07, 2010 1:24 pm
by DEAPNESS
Ok so I decided to recreate the server again and I made sure everything installed correctly and I got rid of idea that it might be because I tried installing both FPM and FastCGI (read above) because I only did the first route this time.

I am still having the problems though. Another thing to note: If I go into Wordpress and change a setting, at the top it will say "Setting changed successfully" but when I reload the page the setting is the same. Seems like it is accessing the table, changing the info, but it isn't saving. Sounds like a permissions thing to me but I triple checked and the chown is set to mysql:mysql and the chmod is set it 700 (which is what new databases are set to when I create them). The user I am using also has all privileges.

I have also set up a new site, new database, new wordpress install, new everything. And everything works fine so it is definitely an issue with how things are interacting with the old databases. Any ideas?

[SOLUTION!] I FIXED EVERYTHING!! :D :D :D :D :D

So for the FOLDER in the mysql folder it needs to be chmod to 700 and the FILES inside need to be set to 660.

Finally everything is back to normal!! :drunk: