Page 1 of 1

database error

Posted: Fri Feb 17, 2006 12:35 pm
by onegear
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

Re: database error

Posted: Fri Feb 17, 2006 1:02 pm
by garvinhicking
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

Posted: Fri Feb 17, 2006 2:27 pm
by onegear
cool! i think that was it. i looked in the configuration and the userid was set to the wrong one.

thanks!

Posted: Fri Feb 17, 2006 2:31 pm
by onegear
yikes! after changing the userid in the configuration, i can now no longer log into the control panel.

uh-oh........

Posted: Fri Feb 17, 2006 2:33 pm
by garvinhicking
What exactly did you change in the DB?

Regards,
Garvin

Posted: Fri Feb 17, 2006 2:37 pm
by onegear
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.

Posted: Sun Feb 19, 2006 4:47 am
by judebert
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.