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 »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • No update of phonenumbers
Pages: [1]

Author Topic: No update of phonenumbers  (Read 622 times)

guertel68

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.4.3
  • CMS version: Joomla 2.5.17
  • MySQL version: 5.1.72-2
  • PHP version: PHP Version 5.3.3-7+squeeze17 LINUX
No update of phonenumbers
February 03, 2014, 09:22:23 am
When i Editing and Saving contact's phone number it returns "Network Error
Unable to reach the server. Please refresh this page in your browser and try again."

On using the contact regular edit (not inline) it returns DB Error as follows.
"Sorry but we are not able to provide this at the moment.
DB Error: insufficient permissions

Return to home page."

I searched the Forum and found a link to upgrade the db:
http://www.kolping-heustreu/administrator/index.php?option=com_civicrm&task=civicrm/upgrade&reset=1

But there is also an error "CiviCRM-001"

Any Help?

CiviCRM 4.4.3 first Instalation/ no update
Joomla 2.5.17

@edit Also import phonenumbers from .csv dont work  :-[

« Last Edit: February 03, 2014, 09:25:37 am by guertel68 »

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: No update of phonenumbers
February 03, 2014, 09:39:41 am
It sounds like your sql is slightly misconfigured - your sql user does not have permission to create triggers or functions.
Try asking your question on the new CiviCRM help site.

guertel68

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.4.3
  • CMS version: Joomla 2.5.17
  • MySQL version: 5.1.72-2
  • PHP version: PHP Version 5.3.3-7+squeeze17 LINUX
Re: No update of phonenumbers
February 06, 2014, 08:33:37 am
Now my Provider update me to creat triggers, but not to create functions. :-(
Is the a way to use CiviCrm? maybe in a older version?

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: No update of phonenumbers
February 06, 2014, 10:06:06 am
Sounds like it's time for a new host.
Seriously, life is too short to put up with bad hosting.
Try asking your question on the new CiviCRM help site.

nealbaker

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
Re: No update of phonenumbers
February 10, 2014, 08:54:43 am
I'm having the same issue. I do have permissions to create triggers and functions. This is with the latest version 4.4.4 on Joomla. All other edits and adds seem to work fine, just not phone numbers. THis is the case with both the quick add function as well as the full edit function. Neither one will take phone numbers.  Any other things I should take a look at?

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: No update of phonenumbers
February 10, 2014, 09:32:52 am
Turn on debug backtrace in the civi admin settings and then try saving a phone number again. You'll get a nice backtrace that tells what happened. Most likely a mysql permission error.
Try asking your question on the new CiviCRM help site.

nealbaker

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
Re: No update of phonenumbers
February 10, 2014, 12:40:58 pm
Strangely enough, the log was showing that my db user didn't have rights to drop the routine. I confirmed in cpanel that I did have. I removed all of my rights for that db user account and then restored them. Thanks for the help!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • No update of phonenumbers

This forum was archived on 2017-11-26.