[CWB] Getting error on autosetup

[Hardie, Andrew]

Hi Andrés,

This is due to a change in the default behaviour of the MySQL server which affect what is and is not accepted as a valid time value.

To fix it, I added a workaround to the function mysql_global_connect(). IE this line:

do_mysql_query("set sql_mode = \"\"");

As for the other error messages, 3.2.6 is now very old and I am afraid I can’t go ddigging for the bugs it has that are now fixed…

best

Andrew.

From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of "Andrés Chandía"
Sent: 12 May 2017 14:43
To: Open source development of the Corpus WorkBench
Subject: Re: [CWB] Getting error on autosetup

I decided to try the stable branch:
http://svn.code.sf.net/p/cwb/code/gui/cqpweb/branches/3.2.11
but still I get an error that was present also at the 3.2.6 version:

A mySQL query did not run successfully!
Original query:
CREATE TABLE `user_info` (
......
Error # 1067: Invalid default value for 'last_seen_time'



El Vie, 12 de Mayo de 2017, 14:30, "Andrés Chandía" escribió:
It only solved the first line of the problem, that one saying "PHP Notice: Undefined variable: 6 in ...bin/autosetup.php on line 75"
the rest remains the same

El Vie, 12 de Mayo de 2017, 14:23, "Andrés Chandía" escribió:
Well, I have found that line 75 of autosetup.php is like this:

$Config->default_calc_stat = $$default_colloc_calc_stat;

I think the double $ is the problem


El Vie, 12 de Mayo de 2017, 14:18, "Andrés Chandía" escribió:
CQPweb v3.2.6

PHP Notice: Undefined variable: 6 in ...bin/autosetup.php on line 75

Installing database structure; please wait.
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in ...lib/exiterror.inc.php on line 88
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in ...lib/exiterror.inc.php on line 89
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in ...lib/exiterror.inc.php on line 91
A mySQL query did not run successfully!

Original query:

CREATE TABLE `user_info .......
.....
Error # 1067: Invalid default value for 'last_seen_time'


PHP Notice: Undefined property: stdClass::$all_users_see_backtrace in ...lib/exiterror.inc.php on line 113
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in ...lib/exiterror.inc.php on line 140
PHP Fatal error: Uncaught Error: Call to undefined function print_html_footer() in ...lib/exiterror.inc.php:159
Stack trace:
#0 ...lib/exiterror.inc.php(300): exiterror_endpage()
#1 ...lib/library.inc.php(262): exiterror_mysqlquery(1067, 'Invalid default...', 'CREATE TABLE `u...')
#2 ...lib/admin-lib.inc.php(1170): do_mysql_query('CREATE TABLE `u...')
#3 ...bin/autosetup.php(82): cqpweb_mysql_total_reset()
#4 {main}
thrown in ...lib/exiterror.inc.php on line 159

Any advice?

_______________________
andrés chandía
[chandia.net]<http://www.chandia.net>[X]<https://twitter.com/andreschandia>
NMT<http://chandia.net/content/nmt> | Dungupeyem<http://chandia.net/content/dungupeyem> | Corlexim<http://corlexim.cl>

administrador de:
Parles.upf<http://parles.upf.edu> | Amind terapia<http://amindterapia.com> | Mapuche koyaktu<http://koyaktumapuche.net> | Nocando<http://parles.upf.edu/llocs/nocando> |
mail: ONG Mapuche koyaktu<http://mail.corporacionkoyaktu.net> | Psicoaching<http://mail.psicoaching.net> |
P No imprima innecesariamente. ¡Cuide el medio ambiente!


_______________________
andrés chandía
[chandia.net]<http://www.chandia.net>[X]<https://twitter.com/andreschandia>
NMT<http://chandia.net/content/nmt> | Dungupeyem<http://chandia.net/content/dungupeyem> | Corlexim<http://corlexim.cl>

administrador de:
Parles.upf<http://parles.upf.edu> | Amind terapia<http://amindterapia.com> | Mapuche koyaktu<http://koyaktumapuche.net> | Nocando<http://parles.upf.edu/llocs/nocando> |
mail: ONG Mapuche koyaktu<http://mail.corporacionkoyaktu.net> | Psicoaching<http://mail.psicoaching.net> |
P No imprima innecesariamente. ¡Cuide el medio ambiente!


_______________________
andrés chandía
[chandia.net]<http://www.chandia.net>[X]<https://twitter.com/andreschandia>
NMT<http://chandia.net/content/nmt> | Dungupeyem<http://chandia.net/content/dungupeyem> | Corlexim<http://corlexim.cl>

administrador de:
Parles.upf<http://parles.upf.edu> | Amind terapia<http://amindterapia.com> | Mapuche koyaktu<http://koyaktumapuche.net> | Nocando<http://parles.upf.edu/llocs/nocando> |
mail: ONG Mapuche koyaktu<http://mail.corporacionkoyaktu.net> | Psicoaching<http://mail.psicoaching.net> |
P No imprima innecesariamente. ¡Cuide el medio ambiente!


_______________________
            andrés chandía
[chandia.net]<http://www.chandia.net>[http://mail.chandia.net/images/ico_tw.png]<https://twitter.com/andreschandia>
NMT<http://chandia.net/content/nmt> | Dungupeyem<http://chandia.net/content/dungupeyem> | Corlexim<http://corlexim.cl>

administrador de:
Parles.upf<http://parles.upf.edu> | Amind terapia<http://amindterapia.com> | Mapuche koyaktu<http://koyaktumapuche.net> | Nocando<http://parles.upf.edu/llocs/nocando> |
mail: ONG Mapuche koyaktu<http://mail.corporacionkoyaktu.net> | Psicoaching<http://mail.psicoaching.net> |
P No imprima innecesariamente. ¡Cuide el medio ambiente!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20170512/8f90235e/attachment-0001.html>