CiviCRM Community Forums (archive)

I have been trying to set up and use civimail, but cannot get  either civimail.cronjob.php and EmailProcessor.php to work.  Both jobs, when run from the command line or through the web interface both give the same error:
            (0] => CRM_Core_Error
            (1] => handle
    (code] => -18
    [message] => DB Error: no such table
      where the info from debug line includes: Table 'uacrewor_drp01.users' doesn't exist
    this error makes sense, because the table is not users, but drup_users ; the prefix is set in the drupal setting file as
         $db_prefix = 'drup_';

I am struggling with this and am pretty much stuck.  I have looked through the code but cannot, for example,  find where the .users part of 'uacrewor_drp01.users' table is determined, or where the drupal table prefix might be incorporated into the table name.  

Any help pointing me in the right direction would be greatly appreciated.

         Thanks in advance,
                 Tom G.

Donald,
   That fixes it, of course....
    ( I should remark on my astonishment that your reply came before I even had a chance to correct a typo in my post!!)
     
   I'm pretty tied up now getting things working for a big deadline for using civicrm for our Fall season, but when I have a chance I'll try to have a look regarding your suggestion.  (Though I'm not sure that I can even begin to sort out the Joomla part)
 
         Thanks a ton,
                Tom G.