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 »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • CiviDRM DB Tools error
Pages: [1]

Author Topic: CiviDRM DB Tools error  (Read 703 times)

jobewan

  • I post occasionally
  • **
  • Posts: 79
  • Karma: 0
CiviDRM DB Tools error
December 09, 2012, 08:43:31 am
I am running Civi 4.1.1, and seem to have some database issue(s).

CiviCRM DB Tools v1.2 is indicated as being the correct utility version for Civi 4.1.

After installing, I ran the following command in ssh from the DB Tools directory, replacing the variables w/the correct values:

./civicrm_db_integrity.php [-u username] -p[password] [-h hostname] databasename

What came back is this:


PHP Warning:  Directive 'safe_mode' is deprecated in PHP 5.3 and greater in Unknown on line 0
CiviCRM DB Tools Version 1.2

PHP Notice:  Undefined index: USER in /CiviCRM DB Tools Directory/civicrm_db_utils.php on line 2164

Notice: Undefined index: USER in /CiviCRM DB Tools Directory/civicrm_db_utils.php on line 2164
unrecognized arguments after database name

Anyone know what's up with this?  How to fix?

Anyone know of any other utility that will check out a Civi DB structure?

Thanks in advance!

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: CiviDRM DB Tools error
December 09, 2012, 12:04:03 pm
I'm not sure of the answer to your basic question. I'm not even 100% sure this tool is still supported.

Anyway AFAIK it's only meant to be used on upgraded sites, to insure that DB structure was preserved/upgraded correctly. I don't think it's necessary at all to run this on a fresh install.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

jobewan

  • I post occasionally
  • **
  • Posts: 79
  • Karma: 0
Re: CiviDRM DB Tools error
December 09, 2012, 12:07:12 pm
Thanks Hershel,

The site was upgraded from 3.x some time ago.  I don't know if the tool is supported either.  I do know that the DB is exhibiting some strange behavior, and given the core importance of Civic in my venue, a functional db checking tool would be a great asset.

Best,

J

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: CiviDRM DB Tools error
December 09, 2012, 12:09:17 pm
OK I see now. What I can suggest for a slightly lower-tech DB schema tool would be to

1. Dump structure only from your DB
2. Install the same version of CiviCRM in a fresh, empty DB
3. Dump structure only from that DB
4. diff the two dumps, i.e. compare the two dump files to see if they have any differences.

If you find differences, post them here.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • CiviDRM DB Tools error

This forum was archived on 2017-11-26.