PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '7dtest.heartbeat_messages' doesn't exist: SELECT t__0.* FROM {heartbeat_messages} t__0; Array ( ) in ctools_export_load_object() (line 427 of /modules/all/ctools/includes/export.inc)

CommentFileSizeAuthor
#4 1412142-4-heartbeat-pdoexception.patch1.05 KBpfrenssen

Comments

socialnicheguru’s picture

socialnicheguru commented
Title: PDOException because heartbeat_messages is not created » PDOException because heartbeat_messages is not created - no tables are installed
Priority: Normal » Critical

None of the tables are being installed

Stalski’s picture

Stalski commented
Status: Active » Closed (cannot reproduce)

Tested on a clean install and everything gets installed just fine.
Maybe some of your modules got wrongly installed resulting or something, or maybe heartbeat module got status enabled while not installed.
Really can't reproduce :(

Stalski’s picture

Stalski commented

If you can provide information about how I can reproduce this, you may reopen this issue and I 'll help where I can.

pfrenssen’s picture

pfrenssen
Location Sofia
commented
Status: Closed (cannot reproduce) » Needs review
StatusFileSize
new 1412142-4-heartbeat-pdoexception.patch1.05 KB

This can be reproduced with these steps:

  1. Install Drupal with the minimal install profile.
  2. drush dl ctools heartbeat-7.x-1.x
  3. drush en heartbeat_defaults -y
  4. navigate to /user/1/useractivity

Patch solves it by checking if the comments module is enabled before joining the `comment` table.

pfrenssen’s picture

pfrenssen
Location Sofia
commented
Status: Needs review » Closed (cannot reproduce)

Woops I should learn to read better, this is unrelated to this issue.

mattsmith3’s picture

mattsmith3 commented
Issue summary: View changes
Status: Closed (cannot reproduce) » Needs review

We had the same error, and the patch fixed it.

It's when the module tries to delete rows from 2 tables flag_content and flag_counts, just flag_counts exists. It was also hosing some of the pages on the site that use heartbeat views.

I'm setting back to needs review, since this is in fact an issue, and the patch does in fact fix it. Perhaps this is flag version issue?