CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • DB_DataObject Error: DB Error: insufficient permissions
Pages: [1]

Author Topic: DB_DataObject Error: DB Error: insufficient permissions  (Read 2044 times)

conductorchris

  • I post frequently
  • ***
  • Posts: 167
  • Karma: 9
    • Vermont Rail Action Network
  • CiviCRM version: 4.5.0
  • CMS version: Joomla 3.2.7
  • MySQL version: 5.5.32
  • PHP version: 5.3.26
DB_DataObject Error: DB Error: insufficient permissions
January 22, 2010, 02:20:15 pm
I'm upgrading from 3.0, alpha 3 to 3.1 beta 6 in Joomla
I ran the installer and it said it was a success
I went to the database upgrade script and got this error message:
DB_DataObject Error: DB Error: insufficient permissions

What does this mean and what should I do?

I have installed the civiCRM db tools referred to in the troubleshooting section of documentation but am unable to run them as I do not have shell access.

My host advised me that it is not a mySQL message but an error message from civiCRM itself.
I (and my host) looked at both settings.php files and I believe them to be correct (which doesn't mean they actually are . . . ).

possible clues are that two or three weeks ago I brought this civiCRM instillation over from another server.  It was quite a job.  Perhaps I missed some setting, somewhere and the upgrade script is trying to use the old database name or the old user name?  Also I changed the key used by cron jobs.  However civiCRM was working fine after these jobs until the upgrade.

Thank you!
Christopher
Thanks to those who help create and enhance civiCRM!

conductorchris

  • I post frequently
  • ***
  • Posts: 167
  • Karma: 9
    • Vermont Rail Action Network
  • CiviCRM version: 4.5.0
  • CMS version: Joomla 3.2.7
  • MySQL version: 5.5.32
  • PHP version: 5.3.26
Re: DB_DataObject Error: DB Error: insufficient permissions
January 25, 2010, 12:05:34 pm
It seems there were error(s) on my settings file.  My server needs the database path to be written mysqli instead of mysql.

I remember changing this, but I think that the upgrade deleted and replaced my settings file and I did not catch it.  When I realized the issue I used the settings files that my host (civihosting, which is great) corrected instead of those installed with the regular civicrm upgrade.
Thanks to those who help create and enhance civiCRM!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • DB_DataObject Error: DB Error: insufficient permissions

This forum was archived on 2017-11-26.