CiviCRM Community Forums (archive)

Hello,

today I tried to find out why mailings where not sent. I checked Administer > System Setting >Scheduled Jobs and saw, that jobs were not scheduled.

To get possible error messages, I started the jobs from the command line with ...

cd /var/www/drupal/sites/all/modules/civicrm
/usr/bin/php bin/cli.php -j -s default -u returnmail -p xxxxxxxx -e Job -a process_mailing

.. and got his ugly HTML error message that says: Sorry an unrecoverable error occured ... DB Error: no such table

To find out what table, I checked the MySQL tables against the tables of another system where cron jobs are running, but there were no differences.

Now I'm at an end, because I have not the slightest idea what this could be.

The configuration is Debian Squeeze, Drupal 7.14, CiviCRM 4.1.2
In another machine with the same configuration, cron jobs are running well. The only difference is, that this system was setup as a 4.1.2 version from the first day on and CiviCRM is installed in /var/www/drupal/sites/default/modules/civicrm.
The buggy system was upgraded to 4.0.5 about one year ago and upgraded to 4.1.2 a half year ago.

Any help appreceated. Thank you in advance.

Hello Hershel,

thank you very much for your response.

Submitting the URL in the browser shows nothing, even when debugging is set to on.
The URL I tried was: https://www.example.tld/sites/all/modules/civicrm/bin/cron.php?name=civimail&pass=mypw&key=mykey

But then I submitted it from the command line again and got a detailed error description:
 Database Errorcode: Table 'drupal.users' doesn't exist, 1146.
An that's definitely right, because the table names are prefixed by d7_

And now the question is, how can I tell CiviCRM that the Drupal table names are prefixed?
All descriptions I found are telling about the other way round, accessing CiviCRM from Drupal.

The whole error message:

Database Errorcode: Table 'drupal.users' doesn't exist, 1146

Additional Details: Array
(
    [callback] => Array
        (
            [ 0 ] => CRM_Core_Error
            [1] => handle
        )
    [co de] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
SELECT u.*
FROM   users u
WHERE  LOWER(u.name) = 'civimail'
AND    u.status = 1
 [nativecode=1146 ** Table 'drupal.users' doesn't exist]
    [type] => DB_Error
    [user_info] =>
SELECT u.*
FROM   users u
WHERE  LOWER(u.name) = 'civimail'
AND    u.status = 1
 [nativecode=1146 ** Table 'drupal.users' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT u.*
FROM   users u
WHERE  LOWER(u.name) = 'civimail'
AND    u.status = 1
 [nativecode=1146 ** Table 'drupal.users' doesn't exist]"]
)

Hello Hershel,

everything is running now like a charm!
Thank you very much. I wouldn't have fixed this without your help!

Greetings from Bavaria