Hello, I have some problems with searching. Why is it using /root/tmp ? from opac-error_log DBD::mysql::st execute failed: Can't create/write to file '/root/tmp/#sql10ab_c5_0.MYI' (Errcode: 13) at /var/www/html/koha/intranet/modules/C4/Search.pm line 707, <KC> line 9. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /var/www/html/koha/intranet/modules/C4/Search.pm line 711, <KC> line 9. Ville Huhtala
On Mon, 2002-07-08 at 01:43, Ville Huhtala wrote:
Hello,
I have some problems with searching. Why is it using /root/tmp ?
from opac-error_log DBD::mysql::st execute failed: Can't create/write to file '/root/tmp/#sql10ab_c5_0.MYI' (Errcode: 13) at /var/www/html/koha/intranet/modules/C4/Search.pm line 707, <KC> line 9. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /var/www/html/koha/intranet/modules/C4/Search.pm line 711, <KC> line 9.
Bula Ville Thats actually a mysql error you are seeing there. MySQL is needing to write a temporary file to accomplish the search, and is trying to write to /root/tmp/ Id expect it to try to write to just /tmp Im not sure if there is a MySQL configuration option you can set to change where it stores its temporary files, or whether you need to reinstall MySQL. What you could do to get it running is make a dir in /root writable by the user that mysql runs as. But it would be better to get it using /tmp. Perhaps have a look at www.mysql.com to see whether they have any documentation that can help. Ill see if I can find anything as well. Chris -- Chris Cormack chris@katipo.co.nz Programmer 025 500 789 Katipo Communications www.katipo.co.nz
On 08 Jul 2002 10:31:36 +1200 Chris Cormack <chris@katipo.co.nz> wrote:
What you could do to get it running is make a dir in /root writable by the user that mysql runs as.
But it would be better to get it using /tmp. Perhaps have a look at www.mysql.com to see whether they have any documentation that can help. Ill see if I can find anything as well.
This error comes from starting mysql from command line as user root. Error goes away If I use Mandrake control center to start mysql. Genuine bugs: INTRANET 1.2.1 advanced search -> subject: mammoth -> subject: <mammoth (woolly - extinct)> -> author: <Sanford, William R.> --> You searched on author Sanford, WilliamR., 0 results found Search removed one white space from query: Sanford,%20WilliamR. Manually correcting this to Sanford,%20William%20R. gives expected results. This bug affects also http://opac.library.org.nz OPAC 1.2.1 advanced search -> subject: mammoth -> subject: <MAMMOTH (WOOLLY - EXTINCT)> --> The requested URL /cgi-bin/koha/subjectsearch.pl was not found on this server. Ville Huhtala
On Mon, 8 Jul 2002, Ville Huhtala wrote:
OPAC 1.2.1 advanced search -> subject: mammoth -> subject: <MAMMOTH (WOOLLY - EXTINCT)> --> The requested URL /cgi-bin/koha/subjectsearch.pl was not found on this server.
You can resolve this problem by copying subjectsearch.pl from the intranet cgi-bin directory to the opac cgi-bin directory. They are the same script. I'll fix this in the buildrelease script. Steve.
On Mon, 8 Jul 2002, Ville Huhtala wrote:
Genuine bugs:
INTRANET 1.2.1 advanced search -> subject: mammoth -> subject: <mammoth (woolly - extinct)> -> author: <Sanford, William R.> --> You searched on author Sanford, WilliamR., 0 results found
Search removed one white space from query: Sanford,%20WilliamR. Manually correcting this to Sanford,%20William%20R. gives expected results.
This bug affects also http://opac.library.org.nz
Bug confirmed and fixed in CVS. I think this is the first bug report that actually used the sample data! Steve.
participants (3)
-
Chris Cormack -
Tonnesen Steve -
Ville Huhtala