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) »
  • Can't Access CiviCRM
Pages: [1]

Author Topic: Can't Access CiviCRM  (Read 392 times)

dlpittman

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CiviCRM version: 4.4
  • CMS version: Joomla
  • MySQL version: 5.1.72
  • PHP version: 5.3.27
Can't Access CiviCRM
January 19, 2015, 08:52:28 am
I mistakenly changed the resource url and cannot login to joomla admin panel or access any civiccrm functions without this error.  Any suggestions for a fix?

Warning: mysqli_error() expects parameter 1 to be mysqli, resource given in /home/acommuni/public_html/joomla16/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php on line 224
Sorry but we are not able to provide this at the moment.
DB Error: no such table

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: Can't Access CiviCRM
January 19, 2015, 09:23:15 am
I'm assuming you mean that you changed the Resource URL in Administer Menu > System Settings > Resource URLs.  However, your error suggests maybe you changed civicrm.settings.php?

If you have a backup, I'd restore from backup.  Otherwise, you can log into MySQL (via PHPMyAdmin, if you don't have or don't like command line access) and find the civicrm_settings table.  If you do something like:
Code: [Select]
SELECT group_name, name, value FROM civicrm_setting WHERE group_name = 'URL Preferences' you should see the value you changed.  If you change it manually, be sure to change the number of characters (the number after the "s:") since these are serialized arrays.
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Can't Access CiviCRM

This forum was archived on 2017-11-26.