Title: Database error after clean install
Last modified: August 22, 2016

---

# Database error after clean install

 *  Resolved [fcrick](https://wordpress.org/support/users/fcrick/)
 * (@fcrick)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/database-error-after-clean-install/)
 * Hello
 * After a clean install of Zotpress 5.3.1 on WP 4.1 I am experiencing the following
   problem:
 * Zotpress cannot download library, stays “stuck” at downloading 1-50
 * An inspection of php error logs shows:
 * 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
    ALTER TABLE wpls_zotpress_zoteroItems DROP PRIMARY 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
   PHP message: WordPress database error Table ‘ls_dev_wp.wpls_zotpress_zoteroItems’
   doesn’t exist for query DELETE u1 FROM wpls_zotpress_zoteroItems u1, wpls_zotpress_zoteroItems
   u2 WHERE u1.id < u2.id AND (u1.item_key = u2.item_key AND u1.api_user_id = u2.
   api_user_id); 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 PHP 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 PHP message: WordPress database
   error Table ‘ls_dev_wp.wpls_zotpress_zoteroRelItemColl’ doesn’t exist for query
   ALTER TABLE wpls_zotpress_zoteroRelItemColl DROP PRIMARY 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 PHP
   message: WordPre 2015/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 ALTER TABLE wpls_zotpress_zoteroItems DROP PRIMARY KEY;
   made by activate_plugin, include_once(‘/plugins/zotpress/zotpress.php’), include(‘/
   plugins/zotpress/lib/admin/admin.install.php’), Zotpress_install PHP message:
   WordPress database error Table ‘ls_dev_wp.wpls_zotpress_zoteroItems’ doesn’t 
   exist for query DELETE u1 FROM wpls_zotpress_zoteroItems u1, wpls_zotpress_zoteroItems
   u2 WHERE u1.id < u2.id AND (u1.item_key = u2.item_key AND u1.api_user_id = u2.
   api_user_id); made by activate_plugin, include_once(‘/plugins/zotpress/zotpress.
   php’), include(‘/plugins/zotpress/lib/admin/admin.install.php’), Zotpress_install
   PHP message: WordPress database error Table ‘ls_dev_wp.wpls_zotpress_zoteroRelItemColl’
   doesn’t exist for query ALTER TABLE wpls_zotpress_zoteroRelItemColl DROP PRIMARY
   KEY; made by activate_plugin, include_once(‘/plugins/zotpress/zotpress.php’),
   include(‘/plugins/zotpress/lib/admin/admin.install.php’), Zotpress_install PHP
   message: WordPress database error Table ‘ls_dev_wp.wpls_zotpress_zoteroRelItemColl’
   doesn’t exist for query DELETE u1 FROM wpls_zotpress_zoteroRelItemColl u1, wpls_zotpress_zoteroRelItemColl
   u2 WHERE u1.id < u2.id AND (u1.item_key = u2.item_key AND u1.collection_key =
   u2.collection_key AND u1.api_user_id = u2.api_user_id); made by activate_plugin,
   include_once(‘/plugins/zotpress/zotpress.php’), include(‘/plugins/zotpress/lib/
   admin/admin.install.php’), Zotpress_install PHP message: WordPress database error
   Table ‘ls_dev_wp.wpls_zotpress_zoteroRelItemTags’ doesn’t exist for query ALTER
   TABLE wpls_zotpress_zoteroRelItemTags DROP PRIMARY KEY; made by activate_plugin,
   inclu
 * Please advise.
 * Thanks
 * [https://wordpress.org/plugins/zotpress/](https://wordpress.org/plugins/zotpress/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Katie](https://wordpress.org/support/users/kseaborn/)
 * (@kseaborn)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/database-error-after-clean-install/#post-5657370)
 * Is this error still occurring in 5.3.2? If so, please contact me: [http://katieseaborn.com/contact](http://katieseaborn.com/contact)
 *  Plugin Author [Katie](https://wordpress.org/support/users/kseaborn/)
 * (@kseaborn)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/database-error-after-clean-install/#post-5657658)
 * I believe this has been resolved in 5.3.3. The script now checks to see if the
   table exists before trying to modify it. Feel free to re-open if the error persists.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database error after clean install’ is closed to new replies.

 * ![](https://ps.w.org/zotpress/assets/icon-256x256.png?rev=1995512)
 * [Zotpress](https://wordpress.org/plugins/zotpress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/zotpress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/zotpress/)
 * [Active Topics](https://wordpress.org/support/plugin/zotpress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/zotpress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/zotpress/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Katie](https://wordpress.org/support/users/kseaborn/)
 * Last activity: [11 years, 4 months ago](https://wordpress.org/support/topic/database-error-after-clean-install/#post-5657658)
 * Status: resolved