<span class="gmail_quote"></span>Dear All <br>I found the following error in intranet-error log. I was trying to add authorities from GUI:<br><br>[Sat Feb 17 14:06:07 2007] [error] [client <a href="http://127.0.0.1">127.0.0.1
</a>] Q : select distinct m1.authid from auth_header, where m1.authid=auth_header.authid and at c:/usr/koha227/intranet/modules/C4/AuthoritiesMarc.pm line 159., referer: <a href="http://intranet/cgi-bin/koha/authorities/authorities-home.pl">
http://intranet/cgi-bin/koha/authorities/authorities-home.pl</a><br>[Sat Feb 17 14:06:07 2007] [error] [client <a href="http://127.0.0.1">127.0.0.1</a>] DBD::mysql::st execute failed: 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
m1.authid=auth_header.authid and' at line 1 at c:/usr/koha227/intranet/modules/C4/AuthoritiesMarc.pm line 161., referer: <a href="http://intranet/cgi-bin/koha/authorities/authorities-home.pl">http://intranet/cgi-bin/koha/authorities/authorities-home.pl
</a><br>[Sat Feb 17 14:06:07 2007] [error] [client <a href="http://127.0.0.1">127.0.0.1</a>] DBD::mysql::st fetchrow failed: fetch() without execute() at c:/usr/koha227/intranet/modules/C4/AuthoritiesMarc.pm line 164., referer:
<a href="http://intranet/cgi-bin/koha/authorities/authorities-home.pl">http://intranet/cgi-bin/koha/authorities/authorities-home.pl</a><br><br>Note: I am using MySQL 4<br><br>What should i do?<br>
<br>
Ata<br>