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) »
  • Seems awhile back an upgrade went wrong and I did not notice it
Pages: [1]

Author Topic: Seems awhile back an upgrade went wrong and I did not notice it  (Read 1795 times)

alfred_nutile

  • Ask me questions
  • ****
  • Posts: 464
  • Karma: 14
    • River Valley Tech Collective
Seems awhile back an upgrade went wrong and I did not notice it
March 04, 2008, 05:08:17 am
is there a way to say reupgrade without losing the data I have now?
For example I am at ver  1.9.11960
can I go a version above that and have that fix the problem without losing data?
Or would going to version 2 do it?
Or can I just do
mysqldump -u civicrm_db_username -pcivicrm_db_password -c -e -n -t civicrm_db > dumpFile
And then start with a new install and then
mysql -u civicrm_db_username -pcivicrm_db_password civicrm18 < dumpFile
back?
Saving all original Contact ID's which we are using Civinode to connect to drupal nodes?
Thanks

alfred_nutile

  • Ask me questions
  • ****
  • Posts: 464
  • Karma: 14
    • River Valley Tech Collective
Re: Seems awhile back an upgrade went wrong and I did not notice it
March 04, 2008, 06:14:46 am
So I did this as a test
dumped the db to a file like the install notes mention
mysqldump -u civicrm_db_username -pcivicrm_db_password -c -e -n -t civicrm_db > dumpFile

then created a db called civicrm19
ran
mysql -u civicrm_db_username -pcivicrm_db_password civicrm19 < civicrm_41.mysql

then import dump file
 mysql -u civicrm_db_username -pcivicrm_db_password civicrm18 < dumpFile
But go this error after a few minutes (large file)
ERROR 1054 (42S22) at line 804: Unknown column 'activity_tag1_id' in 'field list'

Any thoughts?

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: Seems awhile back an upgrade went wrong and I did not notice it
March 04, 2008, 07:13:00 am
Not sure what you're trying to achieve. From what I understand, you're trying to import 2.0 data only dump into 1.9 schema, is this correct? Didn't you miss upgrade step after creating 1.9 database?

activity_tag1_id is 2.0 specific column, so if you're missing it, you probably have data following 2.0 format, but the schema itself following 1.9 format.

Thx,
m
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Seems awhile back an upgrade went wrong and I did not notice it

This forum was archived on 2017-11-26.