Hi Sorry, after deleting the koha db you should run "koha-create" not koha-upgrade-scheme this will create all tables for the version you are running.
Check command info to see the parameters you need. ( https://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages#koha-create ) You might also need to enable the newly created instance with "koha-enable library" where library is the name of your instance. Regards, Alvaro |----------------------------------------------------------------------------------------| *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le mar. 10 mars 2020 à 10:55, Dwight Tuinstra <[email protected]> a écrit : > I tried the steps you suggested: > > > # sudo su > > mysql -uroot -p [Enter the MySQL Root password] > > drop database koha_library; > > create database koha_library; > > quit; > > > > # sudo koha-upgrade-schema library > > This resulted in a large number of error messages returned on the command > line, about tables not existing. The koha-upgrade-schema program assumes > that tables already exist. > > --Dwight > > On Mon, Mar 9, 2020 at 11:32 AM Alvaro Cornejo <[email protected]> > wrote: > >> Hi >> >> Both possibilities you refer end on the same. database is not >> ready/complete for the next processes to take place. Therefore I guess >> there is actually a race condition. >> >> Have you tried to manually create the DB? >> >> # sudo su >> mysql -uroot -p [Enter the MySQL Root password] >> drop database koha_library; >> create database koha_library; >> quit; >> >> # sudo koha-upgrade-schema library >> >> BTW, I'm not aware that calling "opac" to your instance might cause a >> problem, but I guess since "opac" is a sort of keyword in the system, I'll >> avoid using that word as my instance. >> >> Hope that helps >> >> Alvaro >> >> >> >> |----------------------------------------------------------------------------------------| >> *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et >> à mesure. >> *q *Recycle always / Recicla siempre / Recyclez toujours >> P Print only if absolutely necessary / Imprime solo si es necesario / >> Imprimez seulement si nécessaire >> >> >> Le lun. 9 mars 2020 à 00:09, Dwight Tuinstra <[email protected]> >> a écrit : >> >>> Hello all -- >>> >>> I'm volunteering some IT consulting at a small research library in >>> Oaxaca, >>> Mexico, that wishes to use koha. To start the project I'm trying to >>> install >>> a test instance of koha 19.11 on a fresh install of Debian 9, which the >>> documentation suggests is one of the preferred platforms. >>> >>> I've carefully followed the wiki document "Koha on Debian" ( >>> https://wiki.koha-community.org/wiki/Koha_on_Debian), performing all >>> steps >>> in the order indicated. So far I found one (known but unfixed) >>> documentation bug and applied the workaround -- one needs to add a >>> backports repository -- but this time I'm running up against something >>> that >>> isn't so easy. >>> >>> The problem manifests as the web UI seeming to hang after going through >>> all >>> the configuration screens and clicking on the button to create the >>> database >>> tables. After several minutes of no activity, the brower reports >>> "Gateway Timeout" The gateway did not receive a timely response from the >>> upstream server or application. >>> >>> There are two possible causes that I've been able to see so far: >>> >>> POSSIBILITY 1: >>> There is an indexer problem that occurs even before the point where the >>> web >>> installer is run. The file /var/log/koha/opac (I'm calling my instance >>> "opac") begins to fill up with error messages. The first few are: >>> >>> DBD::mysql::db do failed: Table 'koha_opac.systempreferences' doesn't >>> exist >>> [for Statement " >>> SELECT * FROM systempreferences WHERE 1 = 0 "] at >>> /usr/share/koha/lib/Koha/Database.pm line 114. >>> DBD::mysql::st execute failed: Table 'koha_opac.systempreferences' >>> doesn't >>> exist [for Statement "SELECT `me`.`variable`, `me`.`value`, >>> `me`.`options`, >>> `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( >>> `me`.`variable` = ? )" with ParamValues: 0='casauthentication'] at >>> /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. >>> DBD::mysql::st execute failed: Table 'koha_opac.systempreferences' >>> doesn't >>> exist [for Statement "SELECT `me`.`variable`, `me`.`value`, >>> `me`.`options`, >>> `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( >>> `me`.`variable` = ? )" with ParamValues: 0='caslogout'] at >>> /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. >>> DBD::mysql::st execute failed: Table 'koha_opac.systempreferences' >>> doesn't >>> exist [for Statement "SELECT `me`.`variable`, `me`.`value`, >>> `me`.`options`, >>> `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( >>> `me`.`variable` = ? )" with ParamValues: 0='casserverurl'] at >>> /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. >>> DBD::mysql::db selectall_arrayref failed: Table >>> 'koha_opac.marc_subfield_structure' doesn't exist [for Statement " >>> SELECT * >>> FROM marc_subfield_structure >>> WHERE frameworkcode = ? >>> AND kohafield > '' >>> ORDER BY frameworkcode,tagfield,tagsubfield >>> "] at /usr/share/koha/lib/C4/Biblio.pm line 1013. >>> DBD::mysql::st execute failed: Table 'koha_opac.zebraqueue' doesn't exist >>> [for Statement "SELECT COUNT(*) FROM zebraqueue WHERE done = 0;"] at >>> /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 324. >>> DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() [for >>> Statement "SELECT COUNT(*) FROM zebraqueue WHERE done = 0;"] at >>> /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 325. >>> >>> After this, the log continues to grow with the last two lines constantly >>> added over and over. Curiously, though, this seems to stop about the time >>> that the web installer is run. >>> >>> POSSIBILITY 2: >>> The creation of database tables takes so long that the browser or >>> installer >>> times out, or race conditions arise. I watched table creation in another >>> window as the web installer was running. Table creation seemed to go slow >>> (roughly a table every second) even though there was plenty of free >>> memory, >>> free disk space (with low disk activity), and the CPUs were over 95% >>> idle. >>> Table creation stopped at 162 tables, at almost the exact same moment >>> that >>> the browser gave the timeout message, so I'm not sure if that's all the >>> tables or if there are supposed to be more. >>> >>> What's odd here is that the web installer writes a good number of >>> messages >>> to /var/log/koha/opac/intranet-error.log, each saying that one of these >>> database tables do not exist: language_descriptions, >>> language_subtag_registry, or systempreferences. However, all of these >>> tables *do* exist in the database when one examines it later, which >>> suggests a race condition. >>> >>> OTHER INFO: >>> - Virtualization: VirtualBox 5.2.34_Ubuntu r133883, 2 i7 CPUs, >>> pre-allocated fixed disk (32Gb), 2GB RAM >>> - Debian version: 4.9.0-12-686-pae #1 SMP Debian 4.9.210-1 (2020-01-20) >>> i686 >>> - Koha version: 19.11 >>> - Following: stable >>> - Database: mariadb, on same host as koha >>> - During WebUI installer: >>> - All Perl dependencies installed and OK >>> - All DB settings look reasonable, connection established, and >>> database >>> koha_opac exists and can be accessed >>> >>> Please help! I've spent hours upon hours doing the installation over and >>> over, making sure everything is clean and updated, and all changes and >>> actions are exactly as the documentation requests. I've kept >>> configuration >>> changes to the minimum required by the documentation in order to avoid >>> complications. What do I need to do to get koha installed? >>> >>> --Dwight (Memo) >>> _______________________________________________ >>> >>> Koha mailing list http://koha-community.org >>> [email protected] >>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >>> >> _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
