CiviCRM Community Forums (archive)

I ran that line manually and it gave no problems. That does in fact mean that I can run the upgrade script doest it?

If I do that I get a the old error again, but now it says:

[debug_info] => UPDATE `civicrm_dashboard` SET fullscreen_url='civicrm/dashlet/activity&reset=1&snippet=4&context=dashletFullscreen' WHERE url='civicrm/dashlet/activity&reset=1&snippet=4';
UPDATE `civicrm_dashboard` SET fullscreen_url='civicrm/dashlet/myCases&reset=1&snippet=4&context=dashletFullscreen' WHERE url='civicrm/dashlet/myCases&reset=1&snippet=4';
UPDATE `civicrm_dashboard` SET fullscreen_url='civicrm/dashlet/allCases&reset=1&snippet=4&context=dashletFullscreen' WHERE url='civicrm/dashlet/allCases&reset=1&snippet=4';

Should I first run  the entire block below CRM 7796 in the 3.4.1. file manually, and then delete these lines (including the CRM-7796 line?) from that file?

I did so, but again got a non recoverable error. If I follow the same recipe I should delete a lot more from that 3.4.1.mysql.tpl. See below a part of the source code:
div class="crm-accordion-body">
                                        <div class="crm-section">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 'DELETE FROM civicrm_navigation where name = 'Survey Types';
DELETE FROM civicrm' at line 2, 1064</div>
                                        <div class="crm-section">Additional Details: <p><pre>Array
(
    [callback] =&gt; Array
        (
           

• =&gt; CRM_Core_Error
[1] =&gt; handle
        )

   

=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => DELETE FROM civicrm_navigation where name = 'CiviCampaign';
DELETE FROM civicrm_navigation where name = 'Survey Types';
DELETE FROM civicrm_navigation where name = 'Campaign Types';
DELETE FROM civicrm_navigation where name = 'Campaign Status';
DELETE FROM civicrm_navigation where name = 'Engagement Index';

SELECT @administerID    := MAX(id) FROM civicrm_navigation where name = 'Administer';
SELECT @adminCampaignWeight := MAX(weight)+1 FROM civicrm_navigation where parent_id = @administerID;

INSERT INTO civicrm_navigation
    ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
VALUES     
    ( 1, NULL, 'CiviCampaign', 'CiviCampaign', 'administer CiviCampaign,administer CiviCRM', 'AND', @administerID, '1', NULL, @adminCampaignWeight );

SET @adminCampaignID:=LAST_INSERT_ID();

INSERT INTO civicrm_navigation
    ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
VALUES     
    ( 1, 'civicrm/admin/campaign/surveyType&reset=1',                            'Survey Types',  'Survey Types', 'administer CiviCampaign',    '', @adminCampaignID, '1', NULL, 1 ),
    ( 1, 'civicrm/admin/options/campaign_type&group=campaign_type&reset=1',      'Campaign Types',  'Campaign Types', 'administer CiviCampaign',    '', @adminCampaignID, '1', NULL, 2 ),
    ( 1, 'civicrm/admin/options/campaign_status&group=campaign_status&reset=1',  'Campaign Status',  'Campaign Status', 'administer CiviCampaign',    '', @adminCampaignID, '1', NULL, 3 ),
    ( 1, 'civicrm/admin/options/engagement_index&group=engagement_index&reset=1','Engagement Index',  'Engagement Index', 'administer CiviCampaign', '', @adminCampaignID, '1', NULL, 4 );


Allright. Thanks so far. I would like to try to install then Civicrm 3.4.1. now and do it another way, in sofar that up till now I ftp the decompressed Civicrm files to the civicrm-folder. This is 50 mb and takes many hours, so now I would now do it the recommended way, upload the compressed file and decompress on the site.
The upgrade manual says:

Unpack the files into <drupal home>/sites/all/modules/.

// Modify this line to use your real drupal root cd <drupal home>/sites/all/modules // Modify this line with the actual downloaded package file name tar -xzf civicrm_download_file.tgz

But to begin with I have no idea how to get this files there if i do not use Dreamweaver. I know a tiny bit about how to use putty. Is there some sort of dummy guide for this?
I suppose I should first go to /sites/all/modules?
Then upload the package (with which command?)
Then unpack it with the command: 'tar -xzf civicrm_download_file.tgz' ??

I have uploaded Civicrm 3.4.1, uploaded the backup of the 3.4.0 tables and tried to run the upgrade script which immediately ended with 4 instances of:

user warning: Smarty error: unable to read resource: "CRM/common/jquery.files.tpl" in /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/Smarty/Smarty.class.php on line 1093.

Thanks. That was indeed the problem. Since I couldnt make the filemanager in my control panel working (but that is another story) I plainly decompressed the Civicrm files locally and then uploaded the whole thing (50 mb) with FTP. Although I have a reliable connection, this upload always stopped somewhere in the TinyMCE directory and the rest of the files would have to be put afterwards. This time I had the impression that everything had gone well, but it hadnt. I uploaded the missing files and Civcirm runs again. I understand that uploading 50 mb in individual files can pose problems, but the number of times Civicrm failed in this respect is really exceptional.
Anyway, many thanks for your help, without it this problem wouldnt have been solved.

I was a bit too early alas. Since the smarty error meant that the upgrade wasnt terminated properly, I decided to deleted the tables, reupload the backup and run the upgade script again. It ended with the familiar non recoverable db error. This time I didnt have to open the page source, the error is clearly displayed, here the upper part:
-----------------------------
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 'UPDATE `civicrm_dashboard` SET fullscreen_url='civicrm/dashlet/activity&reset=1&' at line 3, 1064
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => ALTER TABLE `civicrm_dashboard` ADD `fullscreen_url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'fullscreen url for dashlet';

UPDATE `civicrm_dashboard` SET fullscreen_url='civicrm/dashlet/activity&reset=1&snippet=4&context=dashletFullscreen' WHERE url='civicrm/dashlet/activity&reset=1&snippet=4';
UPDATE `civicrm_dashboard` SET fullscreen_url='civicrm/dashlet/myCases&reset=1&snippet=4&context=dashletFullscreen' WHERE url='civicrm/dashlet/myCases&reset=1&snippet=4';
UPDATE `civicrm_dashboard` SET fullscreen_url='civicrm/dashlet/allCases&reset=1&snippet=4&context=dashletFullscreen' WHERE url='civicrm/dashlet/allCases&reset=1&snippet=4';

DELETE FROM civicrm_navigation where name = 'CiviCampaign';
DELETE FROM civicrm_navigation where name = 'Survey Types';
DELETE FROM civicrm_navigation where name = 'Campaign Types';
DELETE FROM civicrm_navigation where name = 'Campaign Status';
DELETE FROM civicrm_navigation where name = 'Engagement Index';

-------------------------------------------

Afterwards I managed to add the field 'fullscreen url' manually but it is of not much use I think.
This is an upgrade from 3.4.0 to 3.4.1


No that doesnt work: Error

SQL query:

INSERT INTO civicrm_navigation(
domain_id,
url,
label,
name,
permission,
permission_operator,
parent_id,
is_active,
has_separator,
weight
)
VALUES (
{$domainID}, NULL , '{ts escape="sql" skip="true"}CiviCampaign{/ts}', 'CiviCampaign', 'administer CiviCampaign,administer CiviCRM', 'AND', @administerID , '1', NULL , @adminCampaignWeight
);

MySQL said: Documentation
#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 '}, NULL, '{ts escape=&quot;sql&quot; skip=&quot;true&quot;}CiviCampaign{/ts}', 'CiviCampaign', 'admi' at line 4