CiviCRM Community Forums (archive)

Starting this past weekend, we have been unable to create or edits Posts and Pages when CiviCRM is activated. When on the New Post/Page page, the text editing menu bars do not appear, and we are unable to enter in text or save in the main text area. At the bottom of the page, WordPress is showing DB Error: no such table.

We have verified that the database exists and that the user has full permissions. We had no issues with this until a few days ago, and no changes that we know of have been made. If we deactivate Civi, we are able to create and edit Posts/Pages again.

When we run a Civi Debug, it shows the following:

#0 /home/indyones/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/indyones/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/indyones/public_html/wp-content/plugins/civicrm/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such table", -18, 16, (Array:2), "\nSELECT id, title\nFROM   civicrm_event\nWHERE  is_active = 1\nAND ( is_temp...")
#4 /home/indyones/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-18, 16, (Array:2), "\nSELECT id, title\nFROM   civicrm_event\nWHERE  is_active = 1\nAND ( is_temp...")
#5 /home/indyones/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -18, NULL, NULL, "\nSELECT id, title\nFROM   civicrm_event\nWHERE  is_active = 1\nAND ( is_temp...", "DB_Error", TRUE)
#6 /home/indyones/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-18, NULL, NULL, NULL, "1146 ** Table 'indyones_civicrm.civicrm_event' doesn't exist")
#7 /home/indyones/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home/indyones/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("\nSELECT id, title\nFROM   civicrm_event\nWHERE  is_active = 1\nAND ( is_temp...")
#9 /home/indyones/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query("\nSELECT id, title\nFROM   civicrm_event\nWHERE  is_active = 1\nAND ( is_temp...")
#10 /home/indyones/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("\nSELECT id, title\nFROM   civicrm_event\nWHERE  is_active = 1\nAND ( is_temp...")
#11 /home/indyones/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query("\nSELECT id, title\nFROM   civicrm_event\nWHERE  is_active = 1\nAND ( is_temp...")
#12 /home/indyones/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(917): CRM_Core_DAO->query("\nSELECT id, title\nFROM   civicrm_event\nWHERE  is_active = 1\nAND ( is_temp...", TRUE)
#13 /home/indyones/public_html/wp-content/plugins/civicrm/civicrm.php(654): CRM_Core_DAO::executeQuery("\nSELECT id, title\nFROM   civicrm_event\nWHERE  is_active = 1\nAND ( is_temp...")
#14 [internal function](): civicrm_add_form_button_html("")
#15 /home/indyones/public_html/wp-includes/plugin.php(406): call_user_func_array("civicrm_add_form_button_html", (Array:1))
#16 /home/indyones/public_html/wp-admin/admin-footer.php(27): do_action("admin_footer", "")
#17 /home/indyones/public_html/wp-admin/post-new.php(55): include("/home/indyones/public_html/wp-admin/admin-footer.php")
#18 {main}

Any idea what may be causing this? Thanks in advance.

Continuing my research. The error says that there is no such table. So, something is missing from the database?

The first debug I ran before Civi completely went under seems to be saying that the error was in a missing "civicrm_event" in the database.

I looked through the civicrm database and, sure enough, there is no civicrm_event table in it.

So - what would happen if I manually added it? And where would I find out exactly what settings the table should have (as far as type/length/etc)?

Google searches haven't come up with much.