We¹ve been using RefBase 0.95 steadily now for a couple years on small
installations with good results.
However, I¹ve recently noticed that when I try to edit data in existing
records in some fields (author, title, and the like) I¹m getting an SQL
error like this:
> Error 1064 : You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> 'WHERE serial RLIKE ".+" AND (author RLIKE
> "(^|[[:space:][:punct:]])Abari[^[:spa' at line 1
When I go back to the record, RefBase reports:
> Invalid call to script '/refbase/modify.php'!
This doesn¹t happen when I edit/add data to fields like Abstract or Edition.
I¹ve checked our php errors log, and it just reports this at the time of the
> pResults=0) [<a href='function.fopen'>function.fopen</a>]: failed to open
> stream: php_network_getaddresses: getaddrinfo failed: Temporary failure in
> name resolution in
> /Library/WebServer/Documents/cate/zzz/rb_default/includes/include.inc.php on
> line 5213
> [27-Jan-2011 14:18:32] PHP Warning: ereg() [<a
> href='function.ereg'>function.ereg</a>]: REG_EMPTY in
> /Library/WebServer/Documents/cate/zzz/rb_default/record.php on line 1536
Any pointers or suggestions on this will be most welcome!