Asterisk Patch 1.1.0 Crash on logon

[skyracer]

I have TrixBox full updated and PHP aldo updated to 4.4.2 to avoid the bug in users module with Sugar Updated to 4.2.1 and Spanish pack. Works fine,

But when applied the patch (with 4.2.1) : Asterisk Integration Patch patch 1.1.0, the crm login crashes when attempt to logon:

Fatal error: Call to undefined function: requiresingleresult() in /var/www/html/crm/modules/Users/User.php on line 559

This is the log displayed when appy the patch:

Including: /var/www/html/crm/cache/upload//upgrades/temp/15DPh4/scripts/post_install.php 

Adding asterisk_extension column

Running SQL file asterisk_int.sql

Sending query: ALTER TABLE `users` ADD `asterisk_extension` CHAR(25) DEFAULT '' AFTER `portal_only` ;

SQL change succeeded

Processing relationship meta for relationships...done
Processing relationship meta for acl_roles...done
Processing relationship meta for acl_actions...done
Processing relationship meta for leads...done
Processing relationship meta for contacts...done
Processing relationship meta for accounts...done
Processing relationship meta for opportunities...done
Processing relationship meta for cases...done
Processing relationship meta for notes...done
Processing relationship meta for email_templates...done
Processing relationship meta for emailman...done
Processing relationship meta for calls...done
Processing relationship meta for emails...done
Processing relationship meta for meetings...done
Processing relationship meta for iframes...done
Processing relationship meta for tasks...done
Processing relationship meta for users...done
Processing relationship meta for users...done
Processing relationship meta for currencies...done
Processing relationship meta for tracker...done
Processing relationship meta for import_maps...done
Processing relationship meta for files...done
Processing relationship meta for users_last_import...done
Processing relationship meta for config...done
Processing relationship meta for upgrade_history...done
Processing relationship meta for vcals...done
Processing relationship meta for bugs...done
Processing relationship meta for versions...done
Processing relationship meta for releases...done
Processing relationship meta for feeds...done
Processing relationship meta for project...done
Processing relationship meta for project_task...done
Processing relationship meta for roles...done
Processing relationship meta for email_marketing...done
Processing relationship meta for campaigns...done
Processing relationship meta for prospect_lists...done
Processing relationship meta for prospects...done
Processing relationship meta for documents...done
Processing relationship meta for document_revisions...done
Processing relationship meta for fields_meta_data...done
Processing relationship meta for schedulers...done
Processing relationship meta for schedulers_times...done
Processing relationship meta for inbound_email...done
Processing relationship meta for users...done
Processing relationship meta for campaign_log...done
Processing relationship meta for dashboards...done
Processing relationship meta for campaign_trkrs...done
Processing custom relationship meta for relationships...done
Processing custom relationship meta for acl_roles...done
Processing custom relationship meta for acl_actions...done
Processing custom relationship meta for leads...done
Processing custom relationship meta for contacts...done
Processing custom relationship meta for accounts...done
Processing custom relationship meta for opportunities...done
Processing custom relationship meta for cases...done
Processing custom relationship meta for notes...done
Processing custom relationship meta for email_templates...done
Processing custom relationship meta for emailman...done
Processing custom relationship meta for calls...done
Processing custom relationship meta for emails...done
Processing custom relationship meta for meetings...done
Processing custom relationship meta for iframes...done
Processing custom relationship meta for tasks...done
Processing custom relationship meta for users...done
Processing custom relationship meta for users...done
Processing custom relationship meta for currencies...done
Processing custom relationship meta for tracker...done
Processing custom relationship meta for import_maps...done
Processing custom relationship meta for files...done
Processing custom relationship meta for users_last_import...done
Processing custom relationship meta for config...done
Processing custom relationship meta for upgrade_history...done
Processing custom relationship meta for vcals...done
Processing custom relationship meta for bugs...done
Processing custom relationship meta for versions...done
Processing custom relationship meta for releases...done
Processing custom relationship meta for feeds...done
Processing custom relationship meta for project...done
Processing custom relationship meta for project_task...done
Processing custom relationship meta for roles...done
Processing custom relationship meta for email_marketing...done
Processing custom relationship meta for campaigns...done
Processing custom relationship meta for prospect_lists...done
Processing custom relationship meta for prospects...done
Processing custom relationship meta for documents...done
Processing custom relationship meta for document_revisions...done
Processing custom relationship meta for fields_meta_data...done
Processing custom relationship meta for schedulers...done
Processing custom relationship meta for schedulers_times...done
Processing custom relationship meta for inbound_email...done
Processing custom relationship meta for users...done
Processing custom relationship meta for campaign_log...done
Processing custom relationship meta for dashboards...done
Processing custom relationship meta for campaign_trkrs...done
Processing relationship meta for accounts_bugs...done
Processing relationship meta for accounts_cases...done
Processing relationship meta for accounts_contacts...done
Processing relationship meta for accounts_opportunities...done
Processing relationship meta for calls_contacts...done
Processing relationship meta for calls_users...done
Processing relationship meta for cases_bugs...done
Processing relationship meta for contacts_bugs...done
Processing relationship meta for contacts_cases...done
Processing relationship meta for contacts_users...done
Processing relationship meta for custom_fields...done
Processing relationship meta for emails_accounts...done
Processing relationship meta for emails_bugs...done
Processing relationship meta for emails_cases...done
Processing relationship meta for emails_contacts...done
Processing relationship meta for emails_leads...done
Processing relationship meta for emails_opportunities...done
Processing relationship meta for emails_project_task...done
Processing relationship meta for emails_projects...done
Processing relationship meta for emails_prospects...done
Processing relationship meta for emails_tasks...done
Processing relationship meta for emails_users...done
Processing relationship meta for files...done
Processing relationship meta for meetings_contacts...done
Processing relationship meta for meetings_users...done
Processing relationship meta for opportunities_contacts...done
Processing relationship meta for users_feeds...done
Processing relationship meta for prospect_list_campaigns...done
Processing relationship meta for prospect_lists_prospects...done
Processing relationship meta for roles_modules...done
Processing relationship meta for roles_users...done
Processing relationship meta for project_relation...done
Processing relationship meta for acl_roles_actions...done
Processing relationship meta for acl_roles_users...done
Processing relationship meta for InboundEmail_autoreply...done
Processing relationship meta for email_marketing_prospect_lists...done
Processing relationship meta for UserSignature...done
Processing relationship meta for linked_documents...done
Deleting relationship cache file...
Updating the admin warning message...
done


Upgrade applied successfully!

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

and this is the list of patch applied:

 Name Type Version Date Installed Description Action 
 Asterisk Integration Patch patch 1.1.0 2006-07-06 00:41 Patches 4.2 to allow user to dial contacts from SugarCRM Not Available 
 SugarSuite patch 4.2.1 2006-07-06 00:37 None Not Available 
 Asterisk Integration Patch patch 1.0.0 2006-06-13 17:14 Patches 4.2 to allow user to dial contacts from SugarCRM Not Available 
 LDAP User Auth Patch patch 0.8.1 2006-06-13 17:04 Patches 4.2 to allow authentication of users against a LDAP store Not Available

[Grinspun]

i got the same problem( using also trixbox and sugarcrm)....

[beedsley]

what Trixbox iso are you folks using, 1.0 or 1.1???

[skyracer]

I´m TrixBox 1.1,

I have PHP updated to 4.4.2, because a error when attemp to edit or add users, it´s works fine until apply the patch.

[beedsley]

Found a fix for this:

Just Download the 1.0 version of this Asterisk patch, unzip, and copy the User.php file over the 1.1 version, correct the permissions and the ownership.

Then you are good to go!

Hope that helps.

[skyracer]

Available for download a new patch at http://www.sugarforge.org/frs/downlo...k4.2.1_1.2.zip

I just download and install, may be work....

[beedsley]

Yup, installing the 1.2 asterisk patch worked just swell.

Thanks for the fix guys.