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 »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • DB error synchronizing users. CiviCRM 4.0.4 J!1.7.0 [SOLVED]
Pages: [1]

Author Topic: DB error synchronizing users. CiviCRM 4.0.4 J!1.7.0 [SOLVED]  (Read 1274 times)

Dylan

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.0.4
  • CMS version: Joomla 1.7
  • MySQL version: 5.1.53
  • PHP version: 5.3.4
DB error synchronizing users. CiviCRM 4.0.4 J!1.7.0 [SOLVED]
August 03, 2011, 06:32:50 am
When I try to synchronize joomla users with contacts I get a database error, table not found. It's looking for jos_users but the tables in my db don't have jos prefix.

Is it possible to change the prefix civicrm is looking for?
« Last Edit: August 04, 2011, 02:31:00 am by Dylan »

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: DB error synchronizing users. CiviCRM 4.0.4 J!1.7.0
August 03, 2011, 01:57:46 pm
Yes. Go to administrator/index2.php?option=com_civicrm&task=civicrm/admin/setting/uf&reset=1 to fix that.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Dylan

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.0.4
  • CMS version: Joomla 1.7
  • MySQL version: 5.1.53
  • PHP version: 5.3.4
Re: DB error synchronizing users. CiviCRM 4.0.4 J!1.7.0 [SOLVED]
August 04, 2011, 02:32:20 am
Thanks for that. All working now.  :)

diegov

  • I post occasionally
  • **
  • Posts: 63
  • Karma: 0
    • dotPro Tecnologia e Comunicação
  • CiviCRM version: 4.3.5
  • CMS version: Joomla! 3.1.x
  • MySQL version: 5.3
  • PHP version: 5.3
Re: DB error synchronizing users. CiviCRM 4.0.4 J!1.7.0 [SOLVED]
August 30, 2011, 08:39:59 pm
Worked for me too. Maybe the trick should be included in the error message somehow. :)

neherp

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
Re: DB error synchronizing users. CiviCRM 4.0.4 J!1.7.0 [SOLVED]
December 25, 2011, 11:16:50 am
This didn't work for me....  I received an error that "You do not have permission to access this page" when attempting to use the link provided.

My fix was easy, and I thought it might help others:

Rather than using the direct link, navigate to the appropriate entry screen from CiviCRM Home by clicking Administer>Configure>Global Settings>CMS Integration

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • DB error synchronizing users. CiviCRM 4.0.4 J!1.7.0 [SOLVED]

This forum was archived on 2017-11-26.