Can't Access CiviCRM

[dlpittman]

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]

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.