CiviCRM Community Forums (archive)

Hi everybody!

I've just installed latest CiviCRM 3.1.4 with Drupal 6.16
My hosting meets all requirements (all items were in green on pre-installation screen).
I've configured outbound mail via SMTP on google apps and sent testing email, and it all works.

Problems appeared when I tried to create mailing. Neither scheduled mailing nor 'send immediately' option does not work.
I configured cron jobs as described here.

For descriptive reasons I have opened this URL in my browser (I get the same result when running wget script in shell):

http://<site>/sites/all/modules/civicrm/bin/civimail.cronjob.php?name=adminname&pass=adminpass&key=keystring
and got this screen:

Sorry. A non-recoverable error has occurred.


DB Error: no such table

Database Error Code: Table 'crm.users' doesn't exist, 1146

Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT u.* FROM users u WHERE LOWER(u.name) = 'service' AND u.pass = '2ec475dd31fa63d76352c42c749ac758' AND u.status = 1 [nativecode=1146 ** Table 'crm.users' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT u.* FROM users u WHERE LOWER(u.name) = 'service' AND u.pass = '2ec475dd31fa63d76352c42c749ac758' AND u.status = 1 [nativecode=1146 ** Table 'crm.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) = 'service' AND u.pass = '2ec475dd31fa63d76352c42c749ac758' AND u.status = 1 [nativecode=1146 ** Table 'crm.users' doesn't exist]"]
)
If I try to trigger mailing with this url http://<site>/index.php?q=civicrm/mailing/queue&reset=1
then
mailing status changes from 'Scheduled' to 'Complete' but nothing is being sent
recipient's email status turns to 'On hold'
and Bounce record is created (type 'Invalid', reason 'Unknown bounce type: Could not parse bounce email')

Can anyone suggest a solution?[/code]