Hi and thanks for this mod - If I can get it working, I'll be a local hero :)

Putting this in as a bug report, but fully admit it's probably something on my end - I'm no coder.

  • Drupal 6.24
  • PHP 5.2.17
  • Certify 6x-2.0

When I create a new certificate I get the following warnings.

  • user warning: Table 'ljburton_drp1.dr_certify_book_viewlog' doesn't exist query: SELECT nid FROM dr_certify_book_viewlog WHERE uid = 1 AND bid = 310 in /home1/ljburton/public_html/sites/all/modules/certify/certify_book/certify_book.classes.inc on line 105.
  • user warning: Table 'ljburton_drp1.dr_certify_book_viewlog' doesn't exist query: INSERT IGNORE INTO dr_certify_book_viewlog (bid, nid, uid) VALUES (310, 310, 1) in /home1/ljburton/public_html/sites/all/modules/certify/certify_book/certify_book.module on line 61.

In addition, the certificate doesn’t recognize when I’ve viewed Book pages … which makes sense, as it looks to me like the table for that isn’t being created? I seriously know nothing :P

I did look at:

http://drupal.org/node/1491546
Solution here doesn’t seem to apply as I am not getting the Fatal Error portion of this issue … just the subsequent user warnings. Though I did update certify.module line 681 as instructed with no change

http://drupal.org/node/1339546
Solution here doesn’t seem to apply as I did not update from 6.x-1

Any help would be very much appreciated - thanks in advance - Lisa

Comments

fuzzy76’s picture

fuzzy76 commented

Ouch. I really don't see why this bug hasn't been discovered until now :o Basically the book condition is unusable for anyone installing a fresh install of Certify 2.x. If you have the devel module installed, running this through it should help:

drupal_install_schema('certify_book');

I'll do a bugrelease within the next hour or two.

fuzzy76’s picture

fuzzy76 commented
Assigned: Unassigned » fuzzy76
fuzzy76’s picture

fuzzy76 commented
Status: Active » Fixed

Part of v2.1 which should be out in a couple of minutes :)

fuzzy76’s picture

fuzzy76 commented

Just to clarify: If you are experiencing this bug, after upgrading the module you should disable, uninstall and reinstall the certify_book module. Do not do this if you are not affected by the bug, or you will loose your currently tracked book page views.

wcDogg’s picture

wcDogg commented

Thanks Fuzzy76 - for the quick reply and fix!

Uninstall of certify_book threw the following error but seems to have worked. After reinstalling, I have no errors when creating new certificates or editing existing ones, and book page viewing is tracked as expected.

  • user warning: Unknown table 'dr_certify_book_viewlog' query: DROP TABLE dr_certify_book_viewlog in /home1/ljburton/public_html/includes/database.mysql-common.inc on line 269.

Now I'm gonna go bug you with a couple of support requests :)

fuzzy76’s picture

fuzzy76 commented

Yeah, the last error was because it tried to remove its tables, which weren't created to begin with. You should be all set now. :)

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.