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 »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Missing Preference Table
Pages: [1]

Author Topic: Missing Preference Table  (Read 1529 times)

Shadow

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 1
Missing Preference Table
September 30, 2007, 06:45:17 pm
I just installed 1.8 and configured my installation to use PHP 5.2.  When I attempt to configure CivicMail, I get the following error about a missing table in the CivicSpace database:

civicrm_preferences' doesn't exist

Where can I find info on the missing table - should I just create it and what is the structure of the database table.  Also, If anyone knows, how can I find info on any missing table???  I looked through the forum and found nothing.

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: Missing Preference Table
September 30, 2007, 07:37:59 pm

I suspect if you have a missing civicrm_preference table, you have a bad install. You might want to reinstall again. Also 1.9 has lots of CiviMail related improvements, so you might want to try the 1.9 alpha download. Please read the civimail install page and ensure you can meet the requirements

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

Shadow

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 1
Re: Missing Preference Table
September 30, 2007, 07:40:50 pm
I ran the 1.7 -> 1.8 SQL script when I installed the new version - do I just re-run the script or do I have to back it out? 

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: Missing Preference Table
September 30, 2007, 07:54:29 pm

You might want to back out and go back to your 1.7 db and start the process again. Ensure that there are no errors when you upgrade the 1.7 database

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

Shadow

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 1
Re: Missing Preference Table
September 30, 2007, 07:59:13 pm
I discovered the error - it was my fault.  There was an old db installation that I ran the script against - totally my fault for not looking more carefully - thanks for your help anyway :-[
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Missing Preference Table

This forum was archived on 2017-11-26.