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) »
  • Can't Rebuild Schema, CiviCRM 3.1.3
Pages: [1]

Author Topic: Can't Rebuild Schema, CiviCRM 3.1.3  (Read 731 times)

cadams

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
  • CiviCRM version: 3.4.2
  • CMS version: Drupal 6.22
  • MySQL version: 5.5
  • PHP version: 5.2.17
Can't Rebuild Schema, CiviCRM 3.1.3
May 24, 2011, 09:31:15 am
Hello all,


I am having trouble rebuilding the Schema for my database.  I am following the instructions from the CiviCRM website.  When I go to import the datafile, i get this:

ERROR 1054 (42S22) at line 434: Unknown column 'loc_block_id' in 'field list'


I am trying to rebuild it because I want to upgrade, and when I try to upgrade to anything past 3.1.6, I get some foreign key constraint errors.

I have custom fields, and the structure for those imported fine.

Any ideas?

Thanks,
Chris

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: Can't Rebuild Schema, CiviCRM 3.1.3
June 02, 2011, 02:54:32 pm
By instructions I am assuming you mean:
http://wiki.civicrm.org/confluence/display/CRMDOC33/Ensuring+Schema+Integrity+on+Upgrades

if you are using PHPmyAdmin this can be troublesome, databases are best manipulated through the command line.

loc_block_id exists in two tables:

civicrm_domain
civicrm_event

My guess is that your domain_id may not be 1 (it should be) or there is some confusion about this.   If you haven't figured it out PM and maybe I can help
Try CiviTeacher: the online video tutorial CiviCRM learning library.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Can't Rebuild Schema, CiviCRM 3.1.3

This forum was archived on 2017-11-26.