{"id":5657161,"date":"2015-01-10T22:13:10","date_gmt":"2015-01-10T22:13:10","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-error-after-clean-install\/"},"modified":"2016-08-22T15:16:30","modified_gmt":"2016-08-22T15:16:30","slug":"database-error-after-clean-install","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-error-after-clean-install\/","title":{"rendered":"Database error after clean install"},"content":{"rendered":"

Hello<\/p>\n

After a clean install of Zotpress 5.3.1 on WP 4.1 I am experiencing the following problem:<\/p>\n

Zotpress cannot download library, stays “stuck” at downloading 1-50<\/p>\n

An inspection of php error logs shows:<\/p>\n

2015\/01\/10 21:51:12 [error] 29088#0: *3 FastCGI sent in stderr: “PHP message: WordPress database error Table ‘ls_dev_wp.wpls_zotpress_zoteroItems’ doesn’t exist for query
\n ALTER TABLE wpls_zotpress_zoteroItems DROP PRIMARY KEY;
\n made by require_once(‘wp-load.php’), require_once(‘\/var\/www\/www.mydomain.org\/shared\/wp-config.php’), require_once(‘wp-settings.php’), include_once(‘\/plugins\/zotpress\/zotpress.php’), include(‘\/plugins\/zotpress\/lib\/admin\/admin.install.php’), Zotpress_install
\nPHP message: WordPress database error Table ‘ls_dev_wp.wpls_zotpress_zoteroItems’ doesn’t exist for query
\n DELETE u1 FROM wpls_zotpress_zoteroItems u1, wpls_zotpress_zoteroItems u2
\n WHERE u1.id < u2.id
\n AND (u1.item_key = u2.item_key AND u1.api_user_id = u2.api_user_id);
\n made by require_once(‘wp-load.php’), require_once(‘\/var\/www\/www.mydomain.org\/shared\/wp-config.php’), require_once(‘wp-settings.php’), include_once(‘\/plugins\/zotpress\/zotpress.php’), include(‘\/plugins\/zotpress\/lib\/admin\/admin.install.php’), Zotpress_install
\nPHP message: WordPress database error Multiple primary key defined for query ALTER TABLE wpls_zotpress_zoteroItemImages ADD PRIMARY KEY (api_user_id, item_key) made by require_once(‘wp-load.php’), require_once(‘\/var\/www\/www.mydomain.org\/shared\/wp-config.php’), require_once(‘wp-settings.php’), include_once(‘\/plugins\/zotpress\/zotpress.php’), include(‘\/plugins\/zotpress\/lib\/admin\/admin.install.php’), Zotpress_install, dbDelta
\nPHP message: WordPress database error Table ‘ls_dev_wp.wpls_zotpress_zoteroRelItemColl’ doesn’t exist for query
\n ALTER TABLE wpls_zotpress_zoteroRelItemColl DROP PRIMARY KEY;
\n made by require_once(‘wp-load.php’), require_once(‘\/var\/www\/www.mydomain.org\/shared\/wp-config.php’), require_once(‘wp-settings.php’), include_once(‘\/plugins\/zotpress\/zotpress.php’), include(‘\/plugins\/zotpress\/lib\/admin\/admin.install.php’), Zotpress_install
\nPHP message: WordPre
\n2015\/01\/10 21:53:16 [error] 29088#0: *3 FastCGI sent in stderr: “PHP message: WordPress database error Table ‘ls_dev_wp.wpls_zotpress_zoteroItems’ doesn’t exist for query
\n ALTER TABLE wpls_zotpress_zoteroItems DROP PRIMARY KEY;
\n made by activate_plugin, include_once(‘\/plugins\/zotpress\/zotpress.php’), include(‘\/plugins\/zotpress\/lib\/admin\/admin.install.php’), Zotpress_install
\nPHP message: WordPress database error Table ‘ls_dev_wp.wpls_zotpress_zoteroItems’ doesn’t exist for query
\n DELETE u1 FROM wpls_zotpress_zoteroItems u1, wpls_zotpress_zoteroItems u2
\n WHERE u1.id < u2.id
\n AND (u1.item_key = u2.item_key AND u1.api_user_id = u2.api_user_id);
\n made by activate_plugin, include_once(‘\/plugins\/zotpress\/zotpress.php’), include(‘\/plugins\/zotpress\/lib\/admin\/admin.install.php’), Zotpress_install
\nPHP message: WordPress database error Table ‘ls_dev_wp.wpls_zotpress_zoteroRelItemColl’ doesn’t exist for query
\n ALTER TABLE wpls_zotpress_zoteroRelItemColl DROP PRIMARY KEY;
\n made by activate_plugin, include_once(‘\/plugins\/zotpress\/zotpress.php’), include(‘\/plugins\/zotpress\/lib\/admin\/admin.install.php’), Zotpress_install
\nPHP message: WordPress database error Table ‘ls_dev_wp.wpls_zotpress_zoteroRelItemColl’ doesn’t exist for query
\n DELETE u1 FROM wpls_zotpress_zoteroRelItemColl u1, wpls_zotpress_zoteroRelItemColl u2
\n WHERE u1.id < u2.id
\n AND (u1.item_key = u2.item_key AND u1.collection_key = u2.collection_key AND u1.api_user_id = u2.api_user_id);
\n made by activate_plugin, include_once(‘\/plugins\/zotpress\/zotpress.php’), include(‘\/plugins\/zotpress\/lib\/admin\/admin.install.php’), Zotpress_install
\nPHP message: WordPress database error Table ‘ls_dev_wp.wpls_zotpress_zoteroRelItemTags’ doesn’t exist for query
\n ALTER TABLE wpls_zotpress_zoteroRelItemTags DROP PRIMARY KEY;
\n made by activate_plugin, inclu<\/p>\n

Please advise.<\/p>\n

Thanks<\/p>\n

https:\/\/wordpress.org\/plugins\/zotpress\/<\/p>\n","protected":false},"template":"","class_list":["post-5657161","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5657161","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\/5657161\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=5657161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}