Authorization problems between Koha and Mysql
My apologies if this issue has been addressed previously, I didnt find it in the archives. After logging into Koha the login screen keeps appearing again after clicking on a new link. We where able to add a branch but no books or new users. The Mysql Koha tables are empty. Any help would be beneficial. We are running: http://localhost:8080/cgi-bin/koha/about.pl Koha version: 2.0.1RC1 OS version (from 'uname -a'): OpenBSD 3.4 GENERIC#18 i386 Perl version: 5.008 MySQL version: 3.23.58 Apache version: Apache/1.3.28 (Unix) mod_ssl/2.8.15 OpenSSL/0.9.7b bash-2.05b# less /usr/local/koha/log/koha-error_log [Thu Oct 28 00:08:20 2004] [error] [client ###.###.###.###] File does not exist: /usr/local/koha/intranet/htdocs/favicon.ico DBD::mysql::st execute failed: Unknown column 'password' in 'field list' at /usr/local/koha/intranet/modules/C4/Auth.pm line 351. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 353. DBD::mysql::st execute failed: Unknown column 'password' in 'field list' at /usr/local/koha/intranet/modules/C4/Auth.pm line 359. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 361. DBD::mysql::db selectrow_array failed: Table 'Koha.sessions' doesn't exist at /usr/local/koha/intranet/modules/C4/Auth.pm line 224. DBD::mysql::st execute failed: Unknown column 'password' in 'field list' at /usr/local/koha/intranet/modules/C4/Auth.pm line 351. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 353. DBD::mysql::st execute failed: Unknown column 'password' in 'field list' at /usr/local/koha/intranet/modules/C4/Auth.pm line 359. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 361. DBD::mysql::db do failed: Table 'Koha.sessions' doesn't exist at /usr/local/koha/intranet/modules/C4/Auth.pm line 281. DBD::mysql::db do failed: Table 'Koha.sessions' doesn't exist at /usr/local/koha/intranet/modules/C4/Auth.pm line 283. DBD::mysql::st execute failed: Unknown column 'userid' in 'where clause' at /usr/local/koha/intranet/modules/C4/Auth.pm line 400. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 401. DBD::mysql::st execute failed: Unknown column 'flags' in 'field list' at /usr/local/koha/intranet/modules/C4/Auth.pm line 385. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 386. DBD::mysql::st execute failed: Table 'Koha.userflags' doesn't exist at /usr/local/koha/intranet/modules/C4/Auth.pm line 388. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 389. DBD::mysql::st execute failed: Unknown column 'userid' in 'where clause' at /usr/local/koha/intranet/modules/C4/Auth.pm line 426. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 428. =-=-=-=-=-=-= Chris Gilbert Kennesaw State University -------------------------------------------------
On 2004-10-28 16:42:33 +0100 csg7142@students.kennesaw.edu wrote:
DBD::mysql::st execute failed: Unknown column 'password' in 'field list' at /usr/local/koha/intranet/modules/C4/Auth.pm line 351.
My first thought is that the database did not install completely. There should be 60 or so tables. Can you check whether there are in your copy? (Connect to mysql and enter "show tables;" IIRC) -- MJR/slef My Opinion Only and not of any group I know Creative copyleft computing - http://www.ttllp.co.uk/ Will HLF fund tree-killings? http://www.thewalks.co.uk/
participants (2)
-
csg7142@students.kennesaw.edu -
MJ Ray