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) »
  • Help upgrading 3.1.5 to 3.4.0
Pages: [1]

Author Topic: Help upgrading 3.1.5 to 3.4.0  (Read 1220 times)

heliosabc

  • I’m new here
  • *
  • Posts: 26
  • Karma: 0
  • CiviCRM version: 3.3
  • CMS version: 6
  • MySQL version: 5
  • PHP version: 5.2
Help upgrading 3.1.5 to 3.4.0
April 28, 2011, 02:51:10 am
Hi!

When upgrading to version 3.4.0 I get the following error message:

Code: [Select]
Database Error Code: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT @option_group_id_act := max(id) from civicrm_option_group where name = 'a' at line 9, 1064
Any help?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Help upgrading 3.1.5 to 3.4.0
April 28, 2011, 04:18:37 am
Can you post your precise MySQL and PHP versions?
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.

heliosabc

  • I’m new here
  • *
  • Posts: 26
  • Karma: 0
  • CiviCRM version: 3.3
  • CMS version: 6
  • MySQL version: 5
  • PHP version: 5.2
Re: Help upgrading 3.1.5 to 3.4.0
April 28, 2011, 06:50:22 am
###### Apache Friends XAMPP Lite (Basis Package) version 1.7.3 ######

  + Apache 2.2.14 (IPV6 enabled)
  + MySQL 5.1.41 (Community Server) with PBXT engine 1.0.09-rc
  + PHP 5.3.1 (PEAR)
  + Miniperl 5.10.1
  + XAMPP Control Version 2.5.8 (ApacheFriends Edition)
  + XAMPP CLI Bundle 1.6
  + XAMPP Port Check 1.5
  + XAMPP Security 1.1
  + SQLite 2.8.17
  + SQLite 3.6.20
  + OpenSSL 0.9.8l
  + phpMyAdmin 3.2.4
  + msmtp 1.4.19 (a sendmail compatible SMTP client)
  + Webalizer 2.21-02 (with GeoIP lite)
  + Ming 0.4.3 for PHP
  + PDF with pdflib lite v7.0.4p4 for PHP

heliosabc

  • I’m new here
  • *
  • Posts: 26
  • Karma: 0
  • CiviCRM version: 3.3
  • CMS version: 6
  • MySQL version: 5
  • PHP version: 5.2
Re: Help upgrading 3.1.5 to 3.4.0
April 29, 2011, 03:29:00 am
Are the versions sufficient for running CiviCRM 3.4.0?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Help upgrading 3.1.5 to 3.4.0
April 29, 2011, 04:43:25 am
Yes, they are. I am not sure about why you get that error. :(
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.

heliosabc

  • I’m new here
  • *
  • Posts: 26
  • Karma: 0
  • CiviCRM version: 3.3
  • CMS version: 6
  • MySQL version: 5
  • PHP version: 5.2
Re: Help upgrading 3.1.5 to 3.4.0
May 02, 2011, 01:56:36 am
Would it be possible to just start of from 3.4.0 and just migrate all the data in the current database?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Help upgrading 3.1.5 to 3.4.0
May 02, 2011, 02:27:06 am
Yes, you can certainly do that--use Export to get the data out of the old and then Import it into the new.
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.

heliosabc

  • I’m new here
  • *
  • Posts: 26
  • Karma: 0
  • CiviCRM version: 3.3
  • CMS version: 6
  • MySQL version: 5
  • PHP version: 5.2
Re: Help upgrading 3.1.5 to 3.4.0
May 04, 2011, 01:27:46 am
Are those functions within CiviCRM?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Help upgrading 3.1.5 to 3.4.0
May 04, 2011, 02:31:53 am
Yes, import and export exist in CiviCRM. See the book http://www.flossmanuals.net/civicrm/ for full details.
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.

heliosabc

  • I’m new here
  • *
  • Posts: 26
  • Karma: 0
  • CiviCRM version: 3.3
  • CMS version: 6
  • MySQL version: 5
  • PHP version: 5.2
Re: Help upgrading 3.1.5 to 3.4.0
May 13, 2011, 05:51:18 am
When I use this method, will the relationships between, for example, a contribution and the contributor stay valid?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Help upgrading 3.1.5 to 3.4.0
May 13, 2011, 06:34:35 am
You should be able to use an identification field and preserve those, yes.
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 »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Help upgrading 3.1.5 to 3.4.0

This forum was archived on 2017-11-26.