Can't add new references

  • Resolved SomniumLucidus

    (@somniumlucidus)


    11 years, 4 months 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/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author zuotian

    (@zuotian)

    11 years, 4 months 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.

    Thread Starter SomniumLucidus

    (@somniumlucidus)

    11 years, 4 months 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.

    Plugin Author zuotian

    (@zuotian)

    11 years, 3 months 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

    Thread Starter SomniumLucidus

    (@somniumlucidus)

    11 years, 3 months ago

    Yay! That worked. Thank you very much!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Can't add new references’ is closed to new replies.