We've just set up a RefBase installation just a few weeks ago. Up until a few days ago, I was able to add and edit records normally. But now whenever I click on the Edit icon, I get an error message with a SQL statement that says, for example:
The Query:
SELECT author, title, type, year, publication, abbrev_journal, volume, issue, pages, keywords, abstract, address, corporate_author, thesis, publisher, place, editor, language, summary_language, orig_title, series_editor, series_title, abbrev_series_title, series_volume, series_issue, edition, issn, isbn, medium, area, expedition, conference, notes, approved, location, contribution_id, online_publication, online_citation, created_date, created_time, created_by, modified_date, modified_time, modified_by, call_number, serial, marked, copy, selected, user_keys, user_notes, user_file, user_groups, cite_key, related, orig_record, serial, file, url, doi FROM refs LEFT JOIN user_data ON serial = record_id AND user_id =7 WHERE serial RLIKE "^(10198)$"
caused an error:
Error 0 :
This is happening on every record, including ones I've added through batch import and singly through the web interface.
Another, possibly related problem I'm experiencing: when I'm logged in as an admin user, I see two records for every entry when I search for records. If I just click "Show All" I see every article once and the total number of records is correct. But if I execute a search for a particular article, two results are returned instead of one. If I do the same search when I'm not logged in, I get one result as expected. in other words, the records are not atctually duplicated, but something about the user login is causing this duplication.
Do you have any troubleshooting advice?
Thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I haven't seen any reports of errors similar to the one you're experiencing when adding or modifying records. The error output isn't very helpful. Can you the increase the logging level and inspect your logs.
What OS and versions of apache/mysql/php/refbase are you using and has any of these been upgraded recently? Have you modified refbase in anyway?
We have had reports of the duplicate display. Let's try to tackle the other error first, though.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
MySQL(from phpmyadmin):
- Server: Localhost via UNIX socket
- Server type: Percona Server
- Server version: 5.5.31-30.3-log - Percona Server (GPL), Release
rel30.3, Revision 520
- Protocol version: 10
The installation of RefBase we are using has been modified fairly extensively -- however, most of the modifications came from another installation of RB that is still working normally. In our installation I edited the common.inc files and advanced_search.php. I am pretty sure that's all I've done -- and in any case I was trying only to affect display options, but I have to admit that I'm pretty shaky with PHP so I could have done something inadvertantly.
Thanks for your assistance!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The most important thing is to get a better idea of what the specific error is. It seems likely that increasing the loglevel will lead to more useful information. Is there more information in your server logs?
One additional thing you might try is to install a stock copy of refbase (the bleeding-edge branch is suggested) alongside your current customized version (in a separate directory). Then modify ONLY the initialize/db.inc.php file. This would confirm that any issues you're experiencing are due to either a LAMP issue or a refbase bug & are not limited to the customizations that you have made.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We've just set up a RefBase installation just a few weeks ago. Up until a few days ago, I was able to add and edit records normally. But now whenever I click on the Edit icon, I get an error message with a SQL statement that says, for example:
Another, possibly related problem I'm experiencing: when I'm logged in as an admin user, I see two records for every entry when I search for records. If I just click "Show All" I see every article once and the total number of records is correct. But if I execute a search for a particular article, two results are returned instead of one. If I do the same search when I'm not logged in, I get one result as expected. in other words, the records are not atctually duplicated, but something about the user login is causing this duplication.
Do you have any troubleshooting advice?
Thanks!
I haven't seen any reports of errors similar to the one you're experiencing when adding or modifying records. The error output isn't very helpful. Can you the increase the logging level and inspect your logs.
What OS and versions of apache/mysql/php/refbase are you using and has any of these been upgraded recently? Have you modified refbase in anyway?
We have had reports of the duplicate display. Let's try to tackle the other error first, though.
Thanks for the response. Here's our info:
RefBase: 0.9.6
PHP 5.5.9-1ubuntu4.16 (cli) (built: Apr 20 2016 14:31:27)
Zend Engine v2.5.0
with Zend OPcache v7.0.3
MySQL(from phpmyadmin):
- Server: Localhost via UNIX socket
- Server type: Percona Server
- Server version: 5.5.31-30.3-log - Percona Server (GPL), Release
rel30.3, Revision 520
- Protocol version: 10
The installation of RefBase we are using has been modified fairly extensively -- however, most of the modifications came from another installation of RB that is still working normally. In our installation I edited the common.inc files and advanced_search.php. I am pretty sure that's all I've done -- and in any case I was trying only to affect display options, but I have to admit that I'm pretty shaky with PHP so I could have done something inadvertantly.
Thanks for your assistance!
The most important thing is to get a better idea of what the specific error is. It seems likely that increasing the loglevel will lead to more useful information. Is there more information in your server logs?
One additional thing you might try is to install a stock copy of refbase (the bleeding-edge branch is suggested) alongside your current customized version (in a separate directory). Then modify ONLY the initialize/db.inc.php file. This would confirm that any issues you're experiencing are due to either a LAMP issue or a refbase bug & are not limited to the customizations that you have made.