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, incluPlease advise.
Thanks
- The topic ‘Database error after clean install’ is closed to new replies.