WordPress.org

Ready to get started?Download WordPress

Forums

Enhanced BibliPlug
[resolved] Can't add new references (5 posts)

  1. SomniumLucidus
    Member
    Posted 1 year ago #

    Hi people. First of all, thanks for this wonderful plugin; it seems to be the only one capable of keeping a proper database of scholarly articles linked to a nice, profiled author database.
    On installing this plugin, I noticed that just by activating it, it had already added a couple of journal references on its own, possibly by reading the info embedded into the PDF files in my media library. (Very impressive!)

    Problem is, when I try to manually add some more references, I get the following error text at the top of the page:

    exception 'Exception' with message 'Cannot add or update a child row: a foreign key constraint fails (soci94c_sarem/wp_bibliplug_bibliography, CONSTRAINTwp_bibliplug_bibliography_ibfk_1FOREIGN KEY (type_id) REFERENCESwp_bibliplug_types(id))' in /home2/soci94c/public_html/wp-content/plugins/enhanced-bibliplug/bibliplug_query.php:508 Stack trace: #0 /home2/soci94c/public_html/wp-content/plugins/enhanced-bibliplug/bibliplug_edit.php(127): bibliplug_query->insert_bibliography(Array, Array, Array, Array) #1 /home2/soci94c/public_html/wp-admin/admin.php(167): include('/home2/soci94c/...') #2 {main}

    ...and and error message that seems to be saying essentially the same thing:

    Cannot add or update a child row: a foreign key constraint fails (soci94c_sarem/wp_bibliplug_bibliography, CONSTRAINTwp_bibliplug_bibliography_ibfk_1FOREIGN KEY (type_id) REFERENCESwp_bibliplug_types(id))

    Curiously, I have an offline version of the blog and I can add new references there. The error happens only on the online version.

    And that's it. What to do?

    http://wordpress.org/extend/plugins/enhanced-bibliplug/

  2. zuotian
    Member
    Plugin Author

    Posted 1 year ago #

    Can you check the database version on the bibliplug options page? It is most likely that you have an out dated database schema. A manual schema upgrade should fix the issue.

  3. SomniumLucidus
    Member
    Posted 1 year ago #

    Thanks, zuotian.

    However, that did not fix the problem. My database version was 1.3.8. After upgrading it manually it's still v. 1.3.8 (I guess that is the last version), and I'm still getting the error message when trying to add references.

    In the offline, locally installed, version of the blog, I have db version 1.3.8 too, yet I can add references with no problems.

  4. zuotian
    Member
    Plugin Author

    Posted 1 year ago #

    Can you try the following?
    1. back up your data by going to bibliplug->export, and download all references in the ris format.
    2. go to settings->bibliplug, set debug to true, save it.
    3. on the same page, first delete all references, and then upgrade the schema.

    If the above does not solve your problem, can you give me access to your database?

    Thanks,
    Zuotian

  5. SomniumLucidus
    Member
    Posted 1 year ago #

    Yay! That worked. Thank you very much!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic