CiviCRM Community Forums (archive)

I have news! The error I reported above happened when I tried to run Civicrm, I mean, after I had clicked away the db error that resulted from the failing upgrade script. Now I have reproduced the latter and paste it below. So this is the real error that results from the upgrade script. I can only hope it means something to you. Many thanks

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</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] => 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';

Server version: 5.0.67-community

Hi... did you delete the old civicrm folder from your site before upgrading?
As per http://wiki.civicrm.org/confluence/display/CRMDOC40/Upgrade+Drupal+Sites+to+3.4

6. Backup and then delete all previous version code files

CiviCRM will not run properly if files from previous version are present after the upgrade. Make sure you have a good backup of your complete previous version installation and then delete /sites/all/modules/civicrm.

Can you post the full text of the error?

Your error is indeed the same as before:
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
Here is the SQL:

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';
I do not see why it should fail with that error. I would suggest you run this directly against the DB yourself, to see if it gives a different error.

That's what I got also. We are making progress--that I think is the correct error message. Can you clarify what version you have and what version you are trying to upgrade to?

There is no "3.4" Perhaps you mean 3.4.0?

I installed a fresh 3.4.0 and ran your SQL and it works fine. Seems this line actually

ALTER TABLE `civicrm_dashboard` ADD `fullscreen_url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'fullscreen url for dashlet';
is failing. Can you run that manually? It works fine for me manually.