CiviCRM Community Forums (archive)

Hi all,

I have just moved my CiviCRM installation from a testing machine to a live office server and am running into a couple of issues.
The first time I tried to move to the new machine, everything went wrong. I changed the database name when setting up a new MySQL database on the new machine, the Joomla directory location, and had a different MySQL username/password as well as a different Joomla admin username/pass. Joomla was fine with the change, migrating with Akeeba, but CiviCRM croaked - it seems as though non-relative links were the problem - I tried to fix them but it just got worse and I started over. This time I used exactly the same file paths, database and user settings as were on my testing machine, and CiviCRM as a whole is now working, it seems, quite well.

However I have an issue with reports. I can view the Membership Report (Summary) report, but when I change its criteria and click on Preview Report, or create a report from the "Create Reports from Templates" menu item and click on Preview Report there, I get a Database Error: Unable to connect to the database:Could not connect to MySQL error. I know I could preview reports and make changes to reports on my testing machine, so I can only assume this is related to moving to the server.

Can anyone help me track down what's wrong here? I have Joomla error reporting on maximum and debug mode enabled in CiviCRM, but don't have any clues to go on. I'm running Joomla 1.5.23 and CiviCRM 3.3.6 on PHP 5.2.6, Apache 2.2.8, and MySQL 5.0.51a, running on WAMP, on the new server machine (mostly the same as what I was running on the testing machine)


In addition, as I said I have debug on, and on any CiviReport page, the following shows up as well: Notice: Undefined property: CRM_Report_Form_Member_Summary::$_grandFlag in C:\wamp\www\civicrm\administrator\components\com_civicrm\civicrm\CRM\Report\Form.php on line 1623. I'm not sure this is related to the MySQL error.

Fixed it. I always dislike solving my own support questions - it makes me look impatient...

The CIVICRM_UF_BASEURL settng was set to localhost in the civicrm.settings.php admin and frontend files. Changed the localhost part to the IP of the server on my local network, and it seems to be fine now. Yay!