database error

onegear · Post by **onegear** » Fri Feb 17, 2006 12:35 pm

not sure if this is a bug but it's very frustrating, nonetheless.

sometimes, after i make a change in the control panel or even when i create a new post, i'll receive a "database error". what i found is that the dbuser in my "serendipity_config_local.inc.php" file will change. The dbuser id that it changes to is an id that, i believe, was an id that i used quite a while ago but have since changed. if i go to the file on the server and change the id back to my current id, the issue is then resolved with no loss of data. i have no idea why this could be happening. is this a permissions issue? what should the permissions be set to on this file?

thanks for your help.
-chad

Post by **garvinhicking** » Fri Feb 17, 2006 1:02 pm

Please check your serendipity configuration and see if the username and password there match the real ones you use.

You might also want to check your serendipity_config database table and see what 'dbUser' etc. are set to. s9y uses the values of the database to recreate that file...

HTH,
Garvin

onegear · Post by **onegear** » Fri Feb 17, 2006 2:27 pm

cool! i think that was it. i looked in the configuration and the userid was set to the wrong one.

thanks!

onegear · Post by **onegear** » Fri Feb 17, 2006 2:31 pm

yikes! after changing the userid in the configuration, i can now no longer log into the control panel.

uh-oh........

Post by **garvinhicking** » Fri Feb 17, 2006 2:33 pm

What exactly did you change in the DB?

Regards,
Garvin

onegear · Post by **onegear** » Fri Feb 17, 2006 2:37 pm

didn't change anything in the mysql database. i did, however, change the userid in the serendipity administration panel. now, when i try to log into the administration panel with the new id and password, it errors out. i tried the old userid and password and it fails, as well. should i have actually made the changes to the database and the serendipity admin panel?

i think i really screwed something up.......

thanks.

judebert · Post by **judebert** » Sun Feb 19, 2006 4:47 am

Maybe. Maybe not.

Use your provider's database tool to check out serendipity_config database table and see what 'dbUser' is set to, like Garvin said. Make sure it's the same as your current user.

If necessary, back up your old files, export your database, and reinstall from scratch. Then repopulate your database, and verify any changes to the config files. (You can even edit your database backup, so you don't overwrite the serendipity_config table.)

With the backup, of course, you're protected if something terrible happens.

database error

database error

Re: database error