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) »
  • PDF Format Option Group not found in database.
Pages: [1]

Author Topic: PDF Format Option Group not found in database.  (Read 1335 times)

Pelle P

  • I post occasionally
  • **
  • Posts: 58
  • Karma: 0
  • CiviCRM version: CiviCRM 4.1.3
  • CMS version: Joomla 2.5.6
  • MySQL version: 5.1.39
  • PHP version: 5.2.10
PDF Format Option Group not found in database.
June 08, 2011, 07:48:19 am
When I try to edit my mail template I see this message:

Sorry. A non-recoverable error has occurred.
PDF Format Option Group not found in database.

Everything works fine. I can create and send messages with my template. But I cant Edit my template or Add Message Template.

I can edit the template if I open the draft...

Best Regards

Pelle







Marty

  • I post occasionally
  • **
  • Posts: 67
  • Karma: 14
    • Boulder County Arts Alliance
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.26
  • MySQL version: 5.5.37
  • PHP version: 5.4.27
Re: PDF Format Option Group not found in database.
June 10, 2011, 11:12:16 am
Was this after a new install or an upgrade?  If it was an upgrade from a previous version, did you run the upgrade script (http://<your_drupal_home>/civicrm/upgrade?reset=1)?

The install/upgrade process should create the PDF Format Option Group.

patricr

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
Re: PDF Format Option Group not found in database.
June 16, 2011, 02:12:11 am
I am having the same problem. I started in 3.4.1, continued in 3.4.2 and continues in 3.4.3. Anything requiring a pdf gives this error:
==========
Sorry. A non-recoverable error has occurred.
PDF Format Option Group not found in database.

Return to home page.
==========
I looked in the database at this: civicrm_option_group found nothing that says pdf?

Each time I upgraded I did use the

upgrade&reset=1 form during the upgrade, however the hint in this thread says to use upgrade?reset=1 (with a question mark?) not a &.

I have 2 CiviCRM installs, one has this error, one does not. The one that does have the error I had made a custom label format.
In the database the pdf_option_group is missing as well as label_format.

When I try to see those 2 in the Admin dashboard, I get an error that they don't exist.

Can I insert those tables from another CivicCRM database that works?

Thanks!
« Last Edit: June 16, 2011, 05:00:24 am by patricr »

Marty

  • I post occasionally
  • **
  • Posts: 67
  • Karma: 14
    • Boulder County Arts Alliance
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.26
  • MySQL version: 5.5.37
  • PHP version: 5.4.27
Re: PDF Format Option Group not found in database.
June 16, 2011, 09:55:55 am
Upgrading to 3.4.2 should have created three new entries in the Option Group table.  In the name column you should find 'paper_size', 'pdf_format', and 'label_format'.  Do any of these exist in your database?

patricr

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
Re: PDF Format Option Group not found in database.
June 16, 2011, 05:49:49 pm
Quote from: Marty on June 16, 2011, 09:55:55 am
Upgrading to 3.4.2 should have created three new entries in the Option Group table.  In the name column you should find 'paper_size', 'pdf_format', and 'label_format'.  Do any of these exist in your database?

In one of my upgraded Drupal 6.22 and Civicrm 3.42 I have those entries in the options_group. In the other install I do not! Is there a way to copy them and insert them from one to the other?

Thanks for the reply...

Marty

  • I post occasionally
  • **
  • Posts: 67
  • Karma: 14
    • Boulder County Arts Alliance
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.26
  • MySQL version: 5.5.37
  • PHP version: 5.4.27
Re: PDF Format Option Group not found in database.
June 16, 2011, 09:26:44 pm
You can't simply add the missing option group entries because there are other changes in the upgrade process that are probably missing as well.

Perhaps you should backup your database and try running the upgrade script.  Maybe it didn't get run previously.  It will tell you if the database has already been upgraded, so there should be no harm.

If that doesn't help, it might be worth restoring your backup copy of 3.4.1 and then try upgrading again directly to 3.4.3.

patricr

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
Re: PDF Format Option Group not found in database.
June 17, 2011, 04:44:50 am
You said
"If that doesn't help, it might be worth restoring your backup copy of 3.4.1 and then try upgrading again directly to 3.4.3."

To clarify- you mean to restore the database to the 3.4.1 time period, keep the code files for 3.4.3 in the modules/civicrm and run the update again?

I do remember that when I did one of the upgrades to this install, after I did it, it still showed the previous version number at the bottom of the page. I trashed the templates_c folder and ran the update again and then it showed the right version number.

Marty

  • I post occasionally
  • **
  • Posts: 67
  • Karma: 14
    • Boulder County Arts Alliance
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.26
  • MySQL version: 5.5.37
  • PHP version: 5.4.27
Re: PDF Format Option Group not found in database.
June 18, 2011, 07:27:04 am
Quote
To clarify- you mean to restore the database to the 3.4.1 time period, keep the code files for 3.4.3 in the modules/civicrm and run the update again?

Right. Restore the DB to 3.4.1, keep the codebase at 3.4.3, and rerun the upgrade script. The script should run without errors, and you should have the new entries in the Option Group table afterwards.

patricr

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
SOLVED-Re: PDF Format Option Group not found in database.
June 24, 2011, 09:10:42 am
Your last bit of advice worked.

In phpMyadmin, I DROPPED the 3.4.3 database. I then imported the backup 3.4.1 database just before the recent update. (Yes- as directions say- backup, and also NAME it correctly!)

Left the 3.4.3 code files (folders) in place.

I then ran the update command again. The pdf options were then there and I ca now make name tags.

Thanks.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • PDF Format Option Group not found in database.

This forum was archived on 2017-11-26.