DBD::SQLite::db do failed: Safety level may not be changed inside a transaction at (eval 1940) line 37

0.- Instalación de PERL en Debian

$ wget -L http://xrl.us/installperlnix | bash

Desde la línea de comandos:
$ perl --version

This is perl 5, version 24, subversion 1 (v5.24.1) built for x86_64-linux-gnu-thread-multi
(with 85 registered patches, see perl -V for more detail)

Copyright 1987-2017, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on this system using "man perl" or "perldoc perl".  If you have access to the Internet, point your browser at http://www.perl.org/, the Perl Home Page.


1. Instalación de Padre

Update /etc/apt/sources.list, e.g. as follows:

deb http://mirror.isoc.org.il/pub/debian/ stable main
deb-src http://mirror.isoc.org.il/pub/debian/ stable main
Then update the package list

$ sudo apt update

$ sudo apt install cpanminus [¿¿quizá convenía instalar cpanplus??]
$ sudo apt install debaux

$ cpan Padre
yes
sudo
...
...
Warning: Prerequisite 'Alien::wxWidgets => 0.62' for 'PLAVEN/Padre-1.00.tar.gz' failed when processing 'MDOOTSON/Alien-wxWidgets-0.69.tar.gz' with 'make => NO'. Continuing, but chances to succeed are limited.
Configuring P/PL/PLAVEN/Padre-1.00.tar.gz with Makefile.PL
Can't locate Alien/wxWidgets.pm in @INC (you may need to install the Alien::wxWidgets module) (@INC contains: inc privinc /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.24.1 /usr/local/share/perl/5.24.1 /usr/lib/x86_64-linux-gnu/perl5/5.24 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.24 /usr/share/perl/5.24 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base .) at Makefile.PL line 52.
BEGIN failed--compilation aborted at Makefile.PL line 52.
Warning: No success on command[/usr/bin/perl Makefile.PL INSTALLDIRS=site]
  PLAVEN/Padre-1.00.tar.gz
  /usr/bin/perl Makefile.PL INSTALLDIRS=site -- NOT OK


$ sudo apt install libgtk-3-dev
$ cpan -i Wx
$ sudo cpanm Alien::wxWidgets::Utility
$ sudo apt install libwx-scintilla-perl

$ sudo cpanm -i --force Alien::wxWidgets::Utility
--> Working on Alien::wxWidgets::Utility
Fetching http://www.cpan.org/authors/id/M/MD/MDOOTSON/Alien-wxWidgets-0.69.tar.gz ... OK
Configuring Alien-wxWidgets-0.69 ... OK
Building and testing Alien-wxWidgets-0.69 ... OK
Successfully reinstalled Alien-wxWidgets-0.69
1 distribution installed

$ sudo cpanm Padre
Result: FAIL
Failed 27/62 test programs. 19/1637 subtests failed.
Makefile:2092: fallo en las instrucciones para el objetivo 'test_dynamic'
make: *** [test_dynamic] Error 255
  PLAVEN/Padre-1.00.tar.gz
3 dependencies missing (ORLite,ORLite::Migrate,Debug::Client); additionally test harness failed
  /usr/bin/make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
  reports PLAVEN/Padre-1.00.tar.gz

$ sudo cpanm -i inc::Module::Install
$ sudo cpanm -i --force ORLite
$ sudo cpanm -i --force ORLite::Migrate
$ sudo cpanm -i --force Debug::Client
$ sudo cpanm -i Term::ReadLine::Gnu
Could not find neither libtermcap.a, libncurses.a, or libcurses.

$ sudo apt install libcurses-perl
$ sudo apt install libcurses-widgets-perl
$ sudo apt install libncurses5-dev
$ sudo apt install libterm-readline-gnu-perl
$ sudo cpanm -i --force Padre--> Working on Padre
Fetching http://www.cpan.org/authors/id/P/PL/PLAVEN/Padre-1.00.tar.gz ... OK
Configuring Padre-1.00 ... OK
Building and testing Padre-1.00 ... FAIL
! Testing Padre-1.00 failed but installing it anyway.
Successfully installed Padre-1.00
1 distribution installed

$ padre
Gtk-Message: Failed to load module "canberra-gtk-module"
23:52:00: Warning: Cannot set locale to language "English (U.K.)".
23:52:00: Error: locale 'en_GB' cannot be set.
DBD::SQLite::db do failed: Safety level may not be changed inside a transaction at (eval 1906) line 37.
Perl exited with active threads:
 1 running and unjoined
 0 finished and unjoined
 0 running and detached

Claro, los locale los tengo para en_US  y es_MX
$ sudo apt install libcanberra-gtk-module libcanberra-gtk3-module
23:55:35: Warning: Cannot set locale to language "English (U.K.)".
23:55:35: Error: locale 'en_GB' cannot be set.
DBD::SQLite::db do failed: Safety level may not be changed inside a transaction at (eval 1906) line 37.
Perl exited with active threads:
 1 running and unjoined
 0 finished and unjoined
 0 running and detached

$ sudo cpanm -i local::lib
sudo gedit /usr/share/perl5/local/lib.pm


$ sudo cpanm -i --force Padre
...
Checking prerequisites...
  recommends:
    *  Devel::CallChecker is not installed

ERRORS/WARNINGS FOUND IN PREREQUISITES.  You may wish to install the versions
of the modules indicated above before proceeding with this installation

Created MYMETA.yml and MYMETA.json
Creating new 'Build' script for 'Params-Classify' version '0.015'
  ZEFRAM/Params-Classify-0.015.tar.gz
  /usr/bin/perl Build.PL --installdirs site -- OK
Running Build for Z/ZE/ZEFRAM/Params-Classify-0.015.tar.gz
---- Unsatisfied dependencies detected during ----
----    ZEFRAM/Params-Classify-0.015.tar.gz   ----
    Devel::CallChecker [requires,optional]
Building Params-Classify
x86_64-linux-gnu-gcc -I/usr/lib/x86_64-linux-gnu/perl/5.24/CORE -DVERSION="0.015" -DXS_VERSION="0.015" -fPIC -c -D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fwrapv -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -o lib/Params/Classify.o lib/Params/Classify.c
ExtUtils::Mkbootstrap::Mkbootstrap('blib/arch/auto/Params/Classify/Classify.bs')
x86_64-linux-gnu-gcc -shared -L/usr/local/lib -fstack-protector-strong -o blib/arch/auto/Params/Classify/Classify.so lib/Params/Classify.o
  ZEFRAM/Params-Classify-0.015.tar.gz
  ./Build -- OK
Running Build test
t/blessed.t ...... ok       
t/blessed_pp.t ... ok       
t/check.t ........ ok         
t/check_pp.t ..... ok         
t/classify.t ..... ok       
t/classify_pp.t .. ok       
t/error.t ........ ok       
t/error_pp.t ..... ok       
t/pod_cvg.t ...... ok   
t/pod_cvg_pp.t ... ok   
t/pod_syn.t ...... ok   
t/ref.t .......... ok       
t/ref_pp.t ....... ok       
All tests successful.
Files=13, Tests=4749,  3 wallclock secs ( 0.58 usr  0.06 sys +  2.63 cusr  0.18 csys =  3.45 CPU)
Result: PASS
  ZEFRAM/Params-Classify-0.015.tar.gz
  ./Build test -- OK
Running Build install
Building Params-Classify
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/local/lib/x86_64-linux-gnu/perl/5.24.1/auto/Params/Classify/Classify.so
Installing /usr/local/lib/x86_64-linux-gnu/perl/5.24.1/auto/Params/Classify/Classify.bs
Installing /usr/local/lib/x86_64-linux-gnu/perl/5.24.1/Params/Classify.pm
Installing /usr/local/man/man3/Params::Classify.3pm
  ZEFRAM/Params-Classify-0.015.tar.gz
  ./Build install  -- OK


$ sudo cpan -i Devel::CallChecker

$ sudo locale
LANG=es_MX.UTF-8
LANGUAGE=
LC_CTYPE="es_MX.UTF-8"
LC_NUMERIC="es_MX.UTF-8"
LC_TIME="es_MX.UTF-8"
LC_COLLATE="es_MX.UTF-8"
LC_MONETARY="es_MX.UTF-8"
LC_MESSAGES="es_MX.UTF-8"
LC_PAPER="es_MX.UTF-8"
LC_NAME="es_MX.UTF-8"
LC_ADDRESS="es_MX.UTF-8"
LC_TELEPHONE="es_MX.UTF-8"
LC_MEASUREMENT="es_MX.UTF-8"
LC_IDENTIFICATION="es_MX.UTF-8"
LC_ALL=

$ sudo locale-gen "en_GB.UTF-8"
Generating locales (this might take a while)...
  es_MX.UTF-8... done
Generation complete.

$ sudo dpkg-reconfigure locales
Generating locales (this might take a while)...
  en_GB.UTF-8... done
  es_MX.UTF-8... done
Generation complete.


$ sudo gedit /usr/share/perl5/DebianLinux.pm

** (gedit:8666): WARNING **: Set document metadata failed: Establecer el atributo metadata::gedit-position no está soportado

$ cpanm --local-lib=~/perl5 local::lib && eval $(perl -I ~/perl5/lib/perl5/ -Mlocal::lib) 

$ sudo apt install libclass-dbi-sqlite-perl libcpan-sqlite-perl

$ padre
DBD::SQLite::db do failed: Safety level may not be changed inside a transaction at (eval 1940) line 37.
Perl exited with active threads:
 1 running and unjoined
 0 finished and unjoined
 0 running and detached

$ sudo find / -name Locker.pm

$ sudo gedit /usr/local/share/perl/5.24.1/Padre/Locker.pm
Locker.pm fixed
Fix (explained): Padre complains about an sqlite database issue

$ padre


¡Por fin! Aunque he leído que Padre se cae cada cierto tiempo y pierdes tu trabajo.