Re: [Koha] INTERNAL SYSTEM ERROR - table error
Hi Maybe you did not install an additional language? Regards, Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com Le dim. 10 mars 2019 à 02:43, Sebastian Krieg < sebastian.kr...@tuz-eisenach.de> a écrit : > Hi, > > I found one error: > > "...Table 'koha_kplh.language_descriptions' doesn't exist..." > > in the statement: > > SELECT description FROM language_descriptions WHERE subtag=? AND lang=? > AND type=?" with ParamValues: 0='en', 1='en', 2='language' > > Can you test if the table 'language_description with content exists? > > > > _ > mailto: sebastian.kr...@tuz-eisenach.de > > 9. März 2019 13:15, "Shafendi" schrieb: > > > here is my afew lines of my plack-error log. > > > > DBD::mysql::st execute failed: MySQL server has gone away [for Statement > > "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, > `me`.`explanation`, > > `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` = ? )" > > with ParamValues: 0='template'] at > > /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. > > DBD::mysql::st execute failed: Table 'koha_kplh.language_descriptions' > > doesn't exist [for Statement "SELECT description FROM > language_descriptions > > WHERE subtag=? AND lang=? AND type=?" with ParamValues: 0='en', 1='en', > > 2='language'] at /usr/share/koha/lib/C4/Languages.pm line 383. > > DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for > > Statement "SELECT description FROM language_descriptions WHERE subtag=? > AND > > lang=? AND type=?" with ParamValues: 0='en', 1='en', 2='language'] at > > /usr/share/koha/lib/C4/Languages.pm line 384. > > DBD::mysql::st execute failed: Table 'koha_kplh.language_descriptions' > > doesn't exist [for Statement "SELECT description FROM > language_descriptions > > WHERE subtag=? AND lang=? AND type=?" with ParamValues: 0='en', 1='en', > > 2='language'] at /usr/share/koha/lib/C4/Languages.pm line 389. > > DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for > > Statement "SELECT description FROM language_descriptions WHERE subtag=? > AND > > lang=? AND type=?" with ParamValues: 0='en', 1='en', 2='language'] at > > /usr/share/koha/lib/C4/Languages.pm line 390. > > > > i dont understand.. > > > > -- > > Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html > > ___ > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] INTERNAL SYSTEM ERROR - table error
Hi, I found one error: "...Table 'koha_kplh.language_descriptions' doesn't exist..." in the statement: SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?" with ParamValues: 0='en', 1='en', 2='language' Can you test if the table 'language_description with content exists? _ mailto: sebastian.kr...@tuz-eisenach.de 9. März 2019 13:15, "Shafendi" schrieb: > here is my afew lines of my plack-error log. > > DBD::mysql::st execute failed: MySQL server has gone away [for Statement > "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, `me`.`explanation`, > `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` = ? )" > with ParamValues: 0='template'] at > /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. > DBD::mysql::st execute failed: Table 'koha_kplh.language_descriptions' > doesn't exist [for Statement "SELECT description FROM language_descriptions > WHERE subtag=? AND lang=? AND type=?" with ParamValues: 0='en', 1='en', > 2='language'] at /usr/share/koha/lib/C4/Languages.pm line 383. > DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for > Statement "SELECT description FROM language_descriptions WHERE subtag=? AND > lang=? AND type=?" with ParamValues: 0='en', 1='en', 2='language'] at > /usr/share/koha/lib/C4/Languages.pm line 384. > DBD::mysql::st execute failed: Table 'koha_kplh.language_descriptions' > doesn't exist [for Statement "SELECT description FROM language_descriptions > WHERE subtag=? AND lang=? AND type=?" with ParamValues: 0='en', 1='en', > 2='language'] at /usr/share/koha/lib/C4/Languages.pm line 389. > DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for > Statement "SELECT description FROM language_descriptions WHERE subtag=? AND > lang=? AND type=?" with ParamValues: 0='en', 1='en', 2='language'] at > /usr/share/koha/lib/C4/Languages.pm line 390. > > i dont understand.. > > -- > Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] INTERNAL SYSTEM ERROR
You need to open both logs while reproducing the failure do you can identify the problem El sáb., 9 de marzo de 2019 10:03, Shafendi escribió: > here is my mysql error log > > 2019-03-09 12:00:35 140561744152320 [Note] /usr/sbin/mysqld: Normal > shutdown > 2019-03-09 12:00:36 140561744152320 [Note] Event Scheduler: Purging the > queue. 0 events > 2019-03-09 12:00:36 140561184954112 [Note] InnoDB: FTS optimize thread > exiting. > 2019-03-09 12:00:36 140561744152320 [Note] InnoDB: Starting shutdown... > 2019-03-09 12:00:36 140561744152320 [Note] InnoDB: Waiting for page_cleaner > to finish flushing of buffer pool > 2019-03-09 12:00:38 140561744152320 [Note] InnoDB: Shutdown completed; log > sequence number 12224433643 > 2019-03-09 12:00:38 140561744152320 [Note] /usr/sbin/mysqld: Shutdown > complete > > 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: > innodb_empty_free_list_algorithm has been changed to legacy because of > small > buffer pool size. In order to use backoff, increase buffer pool at least up > to 20MB. > > 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Using mutexes to ref > count buffer pool pages > 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: The InnoDB memory heap > is > disabled > 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Mutexes and rw_locks use > GCC atomic builtins > 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: GCC builtin > __atomic_thread_fence() is used for memory barrier > 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Compressed tables use > zlib 1.2.8 > 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Using Linux native AIO > 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Using generic crc32 > instructions > 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Initializing buffer > pool, > size = 128.0M > 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Completed initialization > of buffer pool > 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Highest supported file > format is Barracuda. > 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: 128 rollback segment(s) > are active. > 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Waiting for purge to > start > 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Percona XtraDB > (http://www.percona.com) 5.6.41-84.1 started; log sequence number > 12224433643 > 2019-03-09 12:00:40 140047420487424 [Note] InnoDB: Dumping buffer pool(s) > not yet started > 2019-03-09 12:00:40 140048342834560 [Note] Plugin 'FEEDBACK' is disabled. > 2019-03-09 12:00:40 140048342834560 [Note] Server socket created on IP: > '0.0.0.0'. > 2019-03-09 12:00:40 140048342834560 [Note] /usr/sbin/mysqld: ready for > connections. > Version: '10.1.37-MariaDB-0+deb9u1' socket: '/var/run/mysqld/mysqld.sock' > port: 3306 Debian 9.6 > 2019-03-09 20:52:15 140048341997312 [Warning] IP address '10.116.12.207' > could not be resolved: Name or service not known > > > > > -- > Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] INTERNAL SYSTEM ERROR
here is my mysql error log 2019-03-09 12:00:35 140561744152320 [Note] /usr/sbin/mysqld: Normal shutdown 2019-03-09 12:00:36 140561744152320 [Note] Event Scheduler: Purging the queue. 0 events 2019-03-09 12:00:36 140561184954112 [Note] InnoDB: FTS optimize thread exiting. 2019-03-09 12:00:36 140561744152320 [Note] InnoDB: Starting shutdown... 2019-03-09 12:00:36 140561744152320 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2019-03-09 12:00:38 140561744152320 [Note] InnoDB: Shutdown completed; log sequence number 12224433643 2019-03-09 12:00:38 140561744152320 [Note] /usr/sbin/mysqld: Shutdown complete 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB. 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: The InnoDB memory heap is disabled 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Using Linux native AIO 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Using generic crc32 instructions 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Completed initialization of buffer pool 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Highest supported file format is Barracuda. 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: 128 rollback segment(s) are active. 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Waiting for purge to start 2019-03-09 12:00:39 140048342834560 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.41-84.1 started; log sequence number 12224433643 2019-03-09 12:00:40 140047420487424 [Note] InnoDB: Dumping buffer pool(s) not yet started 2019-03-09 12:00:40 140048342834560 [Note] Plugin 'FEEDBACK' is disabled. 2019-03-09 12:00:40 140048342834560 [Note] Server socket created on IP: '0.0.0.0'. 2019-03-09 12:00:40 140048342834560 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.1.37-MariaDB-0+deb9u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian 9.6 2019-03-09 20:52:15 140048341997312 [Warning] IP address '10.116.12.207' could not be resolved: Name or service not known -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] INTERNAL SYSTEM ERROR
That looks like your database server el being restarted. What do the db server logs say? El sáb., 9 de marzo de 2019 09:22, Shafendi escribió: > here is my afew lines of my plack-error log. > > DBD::mysql::st execute failed: MySQL server has gone away [for Statement > "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, `me`.`explanation`, > `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` = ? )" > with ParamValues: 0='template'] at > /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. > DBD::mysql::st execute failed: Table 'koha_kplh.language_descriptions' > doesn't exist [for Statement "SELECT description FROM language_descriptions > WHERE subtag=? AND lang=? AND type=?" with ParamValues: 0='en', 1='en', > 2='language'] at /usr/share/koha/lib/C4/Languages.pm line 383. > DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for > Statement "SELECT description FROM language_descriptions WHERE subtag=? AND > lang=? AND type=?" with ParamValues: 0='en', 1='en', 2='language'] at > /usr/share/koha/lib/C4/Languages.pm line 384. > DBD::mysql::st execute failed: Table 'koha_kplh.language_descriptions' > doesn't exist [for Statement "SELECT description FROM language_descriptions > WHERE subtag=? AND lang=? AND type=?" with ParamValues: 0='en', 1='en', > 2='language'] at /usr/share/koha/lib/C4/Languages.pm line 389. > DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for > Statement "SELECT description FROM language_descriptions WHERE subtag=? AND > lang=? AND type=?" with ParamValues: 0='en', 1='en', 2='language'] at > /usr/share/koha/lib/C4/Languages.pm line 390. > > i dont understand.. > > > > > -- > Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] INTERNAL SYSTEM ERROR
here is error log form plack-error.log.1 Use of uninitialized value $password in string ne at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 370. Use of uninitialized value $password2 in string ne at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 370. Use of uninitialized value $password in string eq at /usr/share/koha/lib/Koha/Patron.pm line 657. Use of uninitialized value $password in string eq at /usr/share/koha/lib/Koha/Patron.pm line 657. Use of uninitialized value $password in string ne at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 370. Use of uninitialized value $password2 in string ne at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 370. Use of uninitialized value $password in string eq at /usr/share/koha/lib/Koha/Patron.pm line 657. Use of uninitialized value $password in string eq at /usr/share/koha/lib/Koha/Patron.pm line 657. profile_id is currently undefined. at /usr/share/koha/lib/C4/Creators/Profile.pm line 184. Argument "" isn't numeric in numeric eq (==) at /usr/share/perl5/DBIx/Class/Row.pm line 1018. Argument "Authorities index status" isn't numeric in numeric gt (>) at /usr/share/koha/intranet/cgi-bin/admin/systempreferences.pl line 110. Argument "Biblios index status" isn't numeric in numeric gt (>) at /usr/share/koha/intranet/cgi-bin/admin/systempreferences.pl line 110. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] INTERNAL SYSTEM ERROR
here is my afew lines of my plack-error log. DBD::mysql::st execute failed: MySQL server has gone away [for Statement "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` = ? )" with ParamValues: 0='template'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. DBD::mysql::st execute failed: Table 'koha_kplh.language_descriptions' doesn't exist [for Statement "SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?" with ParamValues: 0='en', 1='en', 2='language'] at /usr/share/koha/lib/C4/Languages.pm line 383. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for Statement "SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?" with ParamValues: 0='en', 1='en', 2='language'] at /usr/share/koha/lib/C4/Languages.pm line 384. DBD::mysql::st execute failed: Table 'koha_kplh.language_descriptions' doesn't exist [for Statement "SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?" with ParamValues: 0='en', 1='en', 2='language'] at /usr/share/koha/lib/C4/Languages.pm line 389. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for Statement "SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?" with ParamValues: 0='en', 1='en', 2='language'] at /usr/share/koha/lib/C4/Languages.pm line 390. i dont understand.. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] INTERNAL SYSTEM ERROR
Hi Shafendi, there will be more useful information about the "Internal server error" in your plack-error-log. It will give us more insight in the nature of the error. Hope this helps, Katrin On 09.03.19 03:12, Shafendi wrote: hi all. im using koha ver 18.05.10 and mariadb 10.3 in my cloud server.(development) i got no problem here until i dump my db to other database at another server (production). when i try to write off or create manual invoice, the transaction succeeded but it lead me to that "internal system error" page. when i hit back button the transaction that i just perform is ok. This process didnt happened at my cloud server. So i wonder why the same database and koha version at my production server give me this error. Can anyone help me on this.. T_T -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] INTERNAL SYSTEM ERROR
hi all. im using koha ver 18.05.10 and mariadb 10.3 in my cloud server.(development) i got no problem here until i dump my db to other database at another server (production). when i try to write off or create manual invoice, the transaction succeeded but it lead me to that "internal system error" page. when i hit back button the transaction that i just perform is ok. This process didnt happened at my cloud server. So i wonder why the same database and koha version at my production server give me this error. Can anyone help me on this.. T_T -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha