I have completed the following steps:
- sql backup civicrm database from Drupal
- create fresh joomla install (3.6)
- install fresh civicrm (4.2 - same as on drupal install)
- import and replace civicrm tables from sql backup into the Joomla database
all seemed to be going well, but now when I log into the admin area I am getting a white screen stating
Sorry but we are not able to provide this at the moment. DB Error: unknown error Return to home page.
it then logs me out,
when i check the error_log on the server it states:
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20121212/gd.so' -
/usr/local/lib/php/extensions/no-debug-non-zts-20121212/gd.so: cannot open shared object file: No such file or directory in Unknown on line 0
also, in PHPmyadmin when i try to edit a civicrm table i get the following error:
#1449 - The user specified as a definer ('civicrm'@'localhost') does not exist
if anyone can advise on how to correct please advise :-)
thanks in advance.