Answers.Body: <p>I highly doubt that such an old version of CiviCRM would work on a modern version of Joomla.  You'll also want to upgrade for security reasons.  I would recommend upgrading CiviCRM on Drupal before migrating to Joomla, and your "Unknown Error" will likely disappear.</p>
  
  <p>Also, to troubleshoot the "Unknown Error", turn on debug mode and backtraces:  In CiviCRM, please go to <strong>Administer menu > System Settings > Debugging and Error Handling</strong>, select "Yes" to both "Enable Debugging" and "Display Backtrace", and press "Save".  If you're not sure what to do, please update the question with the expanded debugging info.</p>
  
  <p>Demerit is correct about the definer error.  <a href="https://civicrm.stackexchange.com/questions/619/why-do-i-get-access-denied-you-need-at-least-one-of-the-super-privileges-f/620#620">See here</a> to fix that error.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-04T06:51:14.620Z
Answers.LastActivityDate: 2016-08-04T06:51:14.620Z
Answers.LastEditDate: 2017-04-13T12:53:13.017Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>I'm assuming this is a new server as well. The first sounds like a PHP issue - some kind of mismatch for the GD extension in php.ini or php-gd rpm package is not even installed. When I say extension I mean PHP extension, nothing to do with CiviCRM other than GD might be used by CiviCRM, but it's usually installed by default. In joomla admin you can go into site system information and see the output from phpinfo to see if it's installed.</p>
  
  <p>The second is probably a mysql trigger/view issue, where you have a different mysql user for your joomla database than the one that created the original civicrm trigger/view. You can either create and use the same mysql user (civicrm@localhost) for your database, or recreate the trigger/views manually. A third option is start again and edit the sql file and edit the part of the trigger/view creation that sets the definer before you import it to the mysql user that you are actually using.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-04T02:43:29.813Z
Answers.LastActivityDate: 2016-08-04T02:43:29.813Z
Answers.UserDisplayName: Demerit
Body: <p>I have completed the following steps:</p>
  
  <ul>
  <li>sql backup civicrm database from Drupal</li>
  <li>create fresh joomla install (3.6)</li>
  <li>install fresh civicrm (4.2 - same as on drupal install)</li>
  <li>import and replace civicrm tables from sql backup into the Joomla database</li>
  </ul>
  
  <p>all seemed to be going well, but now when I log into the admin area I am getting a white screen stating </p>
  
  <blockquote>
    <blockquote>
      <p>Sorry but we are not able to provide this at the moment. DB Error:
      unknown error Return to home page.</p>
    </blockquote>
  </blockquote>
  
  <p>it then logs me out,</p>
  
  <p>when i check the error_log on the server it states:</p>
  
  <blockquote>
  <pre><code>PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20121212/gd.so' -
  </code></pre>
    
    <p>/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</p>
  </blockquote>
  
  <p>also, in PHPmyadmin when i try to edit a civicrm table i get the following error:</p>
  
  <blockquote>
    <p><strong>#1449 - The user specified as a definer ('civicrm'@'localhost') does not exist</strong></p>
  </blockquote>
  
  <p>if anyone can advise on how to correct please advise :-)</p>
  
  <p>thanks in advance.</p>
  
Tags: <drupal><joomla>
Title: Migrate from Drupal To Joomla
ThreadText: # Migrate from Drupal To Joomla
  
  (Asked by: username_0 on 2016-08-03)
  
  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.
  
  **Tags:** drupal, joomla
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2016-08-04. Score: 1
  
  I highly doubt that such an old version of CiviCRM would work on a modern version of Joomla. You'll also want to upgrade for security reasons. I would recommend upgrading CiviCRM on Drupal before migrating to Joomla, and your "Unknown Error" will likely disappear.
  
  Also, to troubleshoot the "Unknown Error", turn on debug mode and backtraces: In CiviCRM, please go to **Administer menu > System Settings > Debugging and Error Handling**, select "Yes" to both "Enable Debugging" and "Display Backtrace", and press "Save". If you're not sure what to do, please update the question with the expanded debugging info.
  
  username_2 is correct about the definer error. [See here](https://civicrm.stackexchange.com/questions/619/why-do-i-get-access-denied-you-need-at-least-one-of-the-super-privileges-f/620#620) to fix that error.
  
  
  ---
  
  ### Answer by username_2 on 2016-08-04. Score: 1
  
  I'm assuming this is a new server as well. The first sounds like a PHP issue - some kind of mismatch for the GD extension in php.ini or php-gd rpm package is not even installed. When I say extension I mean PHP extension, nothing to do with CiviCRM other than GD might be used by CiviCRM, but it's usually installed by default. In joomla admin you can go into site system information and see the output from phpinfo to see if it's installed.
  
  The second is probably a mysql trigger/view issue, where you have a different mysql user for your joomla database than the one that created the original civicrm trigger/view. You can either create and use the same mysql user (civicrm@localhost) for your database, or recreate the trigger/views manually. A third option is start again and edit the sql file and edit the part of the trigger/view creation that sets the definer before you import it to the mysql user that you are actually using.
  
  
  ---
  
  