CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • mySQL says table doesn't exist when trying to run civimail.cronjob.php
Pages: [1]

Author Topic: mySQL says table doesn't exist when trying to run civimail.cronjob.php  (Read 692 times)

marieeka

  • I’m new here
  • *
  • Posts: 6
  • Karma: 1
mySQL says table doesn't exist when trying to run civimail.cronjob.php
January 21, 2010, 12:42:28 pm
I'm trying to set up a CiviMail cron. I created a CiviMail user name and password, created a CiviCRM key, and entered that relevant information into the URL below to see if it works.

Code: [Select]
http://www.example.com/sites/all/modules/civicrm/bin/civimail.cronjob.php?name=<name>&pass=<pass>&key=<key>
I'm confident that I'm entering the correct information into the URL pattern, substituting <name> with the username with CiviMail access, <pass> with the appropriate password and <key> from my civicrm.settings.php.

I get the following error:

Code: [Select]
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) = 'civimail' AND u.pass = 'f777fea9784e0208f970fb281ed8e8d4' AND u.status = 1 [nativecode=1146 ** Table 'preservation_civicrm.users' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT u.* FROM users u WHERE LOWER(u.name) = 'civimail' AND u.pass = 'f777fea9784e0208f970fb281ed8e8d4' AND u.status = 1 [nativecode=1146 ** Table 'preservation_civicrm.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.pass = 'f777fea9784e0208f970fb281ed8e8d4' AND u.status = 1 [nativecode=1146 ** Table 'preservation_civicrm.users' doesn't exist]"]
)

Not sure what other information I can provide, but clearly I've got something configured incorrectly.

I'm running CiviCRM 3.0.3 on Drupal 6.15.[/code]

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: mySQL says table doesn't exist when trying to run civimail.cronjob.php
January 29, 2010, 03:42:05 am
Please check if you have provided correct 'CIVICRM_UF_DSN' in civicrm.settings.php

Kurund
Found this reply helpful? Support CiviCRM

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • mySQL says table doesn't exist when trying to run civimail.cronjob.php

This forum was archived on 2017-11-26.