Author Topic: PEAR_Exception: DB Error: unknown error in unknown on line unknown (Read 777 times)

yshah · October 06, 2012, 08:28:21 am

When upgrading to the latest CiviCRM release I get DB Error. Not sure what's going on. No DB error id was given either. The mysql user has all privileges granted to the db, I'm not sure what's happening. Any insight would be helpful.

yshah · October 06, 2012, 10:19:54 am

Ok found a solution. This may be due to WHM and cPanel.

Deploy backup database to start again
From the console I ran: > mysql
(as per solution at http://kb.deru.net/?View=entry&EntryID=142)
> use <databasename>;
> grant SUPER on *.* to '<user>'@'localhost' identified by '<password>'
> flush privileges;
Run the update page again

After that everything worked like a charm. I hope it helps someone else!

CiviCRM Community Forums (archive)

News:

Author Topic: PEAR_Exception: DB Error: unknown error in unknown on line unknown (Read 777 times)

yshah

PEAR_Exception: DB Error: unknown error in unknown on line unknown

yshah

Re: PEAR_Exception: DB Error: unknown error in unknown on line unknown