{"id":16310560,"date":"2022-12-21T16:35:24","date_gmt":"2022-12-21T16:35:24","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/oops-database-not-found\/"},"modified":"2022-12-21T16:35:24","modified_gmt":"2022-12-21T16:35:24","slug":"oops-database-not-found","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/oops-database-not-found\/","title":{"rendered":"Oops &#8211; Database not found"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">I installed wp guppy lite but I&#8217;m getting error &#8220;oops&#8221; when sending message. Message doesn&#8217;t send and popup &#8220;oops&#8221; error message.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I checked error log: here are details<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#091;21-Dec-2022 16:33:07 UTC] WordPress database error Table 'oyguhpck_wp91.wprp_wpguppy_message' doesn't exist for query ALTER TABLE wprp_wpguppy_message \t\tADD  <code>sp_sender_id<\/code> varchar(255) DEFAULT NULL COMMENT 'guest \/ registered user id' AFTER <code>receiver_id<\/code>, ADD INDEX (<code>sp_sender_id<\/code>); made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, upgradeWPGuppy_DB, WPGuppy_Model-&gt;updateMessageColumns\n&#091;21-Dec-2022 16:33:07 UTC] WordPress database error Table 'oyguhpck_wp91.wprp_wpguppy_message' doesn't exist for query ALTER TABLE wprp_wpguppy_message \t\tADD  <code>sp_rec_id<\/code> varchar(255) DEFAULT NULL COMMENT 'guest \/ registered user id' AFTER <code>sp_sender_id<\/code>, \tADD INDEX (<code>sp_rec_id<\/code>); made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, upgradeWPGuppy_DB, WPGuppy_Model-&gt;updateMessageColumns\n&#091;21-Dec-2022 16:33:07 UTC] WordPress database error Table 'oyguhpck_wp91.wprp_wpguppy_message' doesn't exist for query ALTER TABLE wprp_wpguppy_message \t\tADD  <code>sp_member_id<\/code> int(20) DEFAULT '0' COMMENT 'support member id' AFTER <code>sp_rec_id<\/code>, ADD INDEX (<code>sp_member_id<\/code>); made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, upgradeWPGuppy_DB, WPGuppy_Model-&gt;updateMessageColumns\n&#091;21-Dec-2022 16:33:07 UTC] WordPress database error Specified key was too long; max key length is 1000 bytes for query CREATE TABLE wprp_wpguppy_guest_account (\n\t\t\t\t\tguest_id \t\t\tvarchar (255)  NOT NULL,\n\t\t\t\t\tname \t\t\t\tvarchar (255)  NOT NULL,\n\t\t\t\t\temail \t\t\t\tvarchar (255)  NOT NULL,\n\t\t\t\t\tip_address\t\t\tvarchar (255)  NOT NULL,\n\t\t\t\t\tuser_agent\t\t\tvarchar (255)  NOT NULL,\n\t\t\t\t\tPRIMARY KEY (guest_id),\n\t\t\t\t\tINDEX index_column (email)                           \n\t\t\t\t\t) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, upgradeWPGuppy_DB, WPGuppy_Model-&gt;createGuestAccountTable, dbDelta<\/code><\/pre>\n","protected":false},"template":"","class_list":["post-16310560","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16310560","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16310560\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=16310560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}