CiviCRM Community Forums (archive)

Hi!
I'm trying to upgrade civicrm from 4.0.7 to 4.4.2. When I launch the upgrade script I get the following error:
Warning: strpos() [function.strpos]: Empty delimiter in CRM_Utils_System_Drupal::formatResourceUrl() (line 426 of /kunden/251568_1030/webseiten/crmupdate2/sites/all/modules/civicrm/CRM/Utils/System/Drupal.php).I can't find anything on that error, can anyone help me?
Thanks!
Tosca

Hi!
I re-downloaded the files, but I always got that error. I tried another route now and had some success:

1) Upgrade to 4.2.14 (worked!)
2) Backup
3) Attempt upgrade to 4.4.2

However, I got this error during the Upgrade from 4.2.14 to 4.4.2:

[Error: Create financial records for contributions]:
[...]
INSERT INTO civicrm_financial_item (transaction_date, contact_id, amount, currency, entity_table, entity_id, description, status_id, financial_account_id, f_trxn_id) SELECT REPLACE(REPLACE(REPLACE(ft.trxn_date, '-', ''), ':', ''), ' ', ''), con.contact_id, IF(ft.total_amount < 0 AND con.contribution_status_id = 3, -li.line_total, li.line_total) as line_total, con.currency, 'civicrm_line_item', li.id as line_item_id, li.label as line_item_label, IF(con.contribution_status_id = 2, 3, ) as status_id, efa.financial_account_id as financial_account_id, ft.id as f_trxn_id FROM civicrm_line_item li INNER JOIN civicrm_contribution con ON (li.entity_id = con.id AND li.entity_table = 'civicrm_contribution') INNER JOIN civicrm_financial_trxn ft ON (con.id = ft.contribution_id) LEFT JOIN civicrm_entity_financial_account efa ON (li.financial_type_id = efa.entity_id AND efa.entity_table = 'civicrm_financial_type' AND efa.account_relationship = 1) WHERE con.contribution_status_id IN (1, 3) OR (con.is_pay_later = 1 AND con.contribution_status_id = 2) [nativecode=1064 ** 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 ') as status_id, efa.financial_account_id as financial_account_id, ft.id a' at line 7]

We're getting closer though. Thanks for looking into this!

Is this a multi-lingual install? If yes, can you try changing default language to English and then upgrade.

HTh
Kurund

This looks like a bug in upgrade, can you please file a bug report in issue tracker. Ideally upgrade should work for non-english languages too.

Kurund

Can you try this patch: https://github.com/civicrm/civicrm-core/pull/2122 ( i.e apply this patch to 4.4.2 before upgrade )

Let us know if it works for you..

Kurund