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
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
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
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 <shaffendi@gmail.com> 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
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
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 <shaffendi@gmail.com> 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
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.krieg@tuz-eisenach.de 9. März 2019 13:15, "Shafendi" <shaffendi@gmail.com> 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
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.krieg@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.krieg@tuz-eisenach.de
9. März 2019 13:15, "Shafendi" <shaffendi@gmail.com> 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
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
participants (5)
-
Alvaro Cornejo -
Katrin Fischer -
Sebastian Krieg -
Shafendi -
Tomas Cohen Arazi