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 »
  • Installing CiviCRM »
  • CiviMail installation and configuration (Moderator: Donald Lobo) »
  • Database error when triggering civimail
Pages: [1]

Author Topic: Database error when triggering civimail  (Read 1765 times)

solardude

  • Guest
Database error when triggering civimail
March 27, 2009, 11:03:14 am
I'm trying still to send out a mail to my employees. Now it won't send without the cron job. After MUCH searching I found the civicrm.settings.php file and set my key. (BTW: the documentation gives a place to look for it in Joomla but not drupal IT is: <root>/sites/default/civicrm.settings.php)
 when I paste my string in the browser to trigger the civimail I get:

DB Error: no such table

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

which is essentially correct. Drupal doesn't create a table called xxxx_drp.users, it creates a table called: xxxx_drp.drup_users
This is a problem. Can it be reset? or re-defined or whatever so that this beefy system of checks and balances can balance?
Thanks in advance

solardude

  • Guest
Re: Database error when triggering civimail
March 27, 2009, 01:11:13 pm
well, I created a new table in my drupal database and (tried to) populated it with a username and a password. The database error went away, but the username and password are incorrect. Does anyone know how to set up the fields and encoded them so that the program will recognize them as a password and username. Note: I used the correct password and username for that installation.
Failing that. A CORRECT fix of the initial problem, i.e. getting the mailer to query the correct data table, would be best.
Thanks

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Database error when triggering civimail
March 27, 2009, 02:06:37 pm

u can set the table name at this url: index.php?q=civicrm/admin/setting/uf&reset=1

check:

http://drupal.demo.civicrm.org/civicrm/admin/setting/uf?reset=1

for what the page looks like

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

solardude

  • Guest
Re: Database error when triggering civimail
March 30, 2009, 07:32:16 am
That was it!
Thanks soooo much
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • CiviMail installation and configuration (Moderator: Donald Lobo) »
  • Database error when triggering civimail

This forum was archived on 2017-11-26.