[CWB] CQPWeb 3.2.11 autosetup MySQL error

[Hardie, Andrew]

This is a bug that *really has* been fixed subsequent to the 3.2.11 branch.

Can I suggest you switch to 3.2.14, ie the latest from the subversion trunk?

best

Andrew.

-----Original Message-----
From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Stephen Barrett
Sent: 28 April 2016 12:19
To: 'Open source development of the Corpus WorkBench'
Subject: Re: [CWB] CQPWeb 3.2.11 autosetup MySQL error

Many thanks for this, Andrew. That did the trick and the system is up-and-running. I have come across another issue:

When attempting to use the Word Lookup tool I get a blank screen. Checking the error log I find:
PHP Catchable fatal error:  Object of class DbType could not be converted to string in /var/www/html/corpus/lib/db.inc.php on line 600, referer: http://xxx.xxx.xx.xxx/corpus/dasg/index.php?thisQ=lookup&uT=y

I'm attempting the lookup on an untagged corpus FYI.

Cheers

Stevie

-----Original Message-----
From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Hardie, Andrew
Sent: 27 April 2016 05:28
To: Open source development of the Corpus WorkBench
Subject: Re: [CWB] CQPWeb 3.2.11 autosetup MySQL error

This is a bug which I thought I'd fixed but apparently not! I have added a new fix to both the trunk (v3.2.14) and the most recent branch (v3.2.11) in the svn repo. 

If your copy is not checked out from the branch, then you can fix it manually by changing line 78 of autosetup.php to the following:

$Config->default_colloc_calc_stat = $default_colloc_calc_stat;

best

Andrew.


-----Original Message-----
From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Stephen Barrett
Sent: 26 April 2016 14:21
To: 'Open source development of the Corpus WorkBench'
Subject: [CWB] CQPWeb 3.2.11 autosetup MySQL error

Hi,

I downloaded and installed the most recent version of CQPWeb (3.2.11) from cwb.sourceforge. The autoconfig seemed to run fine but when I run autosetup I get a MySQL error. I turned on print_debug_messages with the output copied below. Can anyone help with what might be causing the problem here, please?
    
Many thanks
    
Stevie
   
 ---
     
INSERT INTO user_info (
                    username,
                    realname,
                    email,
                    passhash,
                    acct_status,
                    expiry_time,
                    acct_create_time,
                    conc_kwicview,
                    conc_corpus_order,
                    cqp_syntax,
                    context_with_tags,
                    use_tooltips,
                    thin_default_reproducible,
                    coll_statistic,
                    coll_freqtogether,

- Ignored:
                    coll_freqalone,
                    coll_from,
                    coll_to,
                    max_dbsize,
                    linefeed
                    )
                    VALUES
                    (
                    'admin',
                    'unknown person',
                    'not-specified at nowhere.net',
                    '$2a$11$......................ZLXvySjf6/.CiTNyQGIjw.wMWUXzaS.',
                    1,
                    0,
                    CURRENT_TIMESTAMP,
                    1,
                    1,
                    0,
                    0,
                    1,
                    1,
                    ,
                    5,
                    5,
                    -3,
                    3,
                    1000000,
                    'au'
                    )
            /* from User: ??? | Function: add_new_user() | 2016-Apr-26 12:45:36 */
    
    
    
    Error # 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
                    5,
                    5,
                    -3,
                    3,
                    1000000,
                    'au'
                    )
            /* from User: ??? | Function: add_' at line 38 _______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
http://devel.sslmit.unibo.it/mailman/listinfo/cwb
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
http://devel.sslmit.unibo.it/mailman/listinfo/cwb
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
http://devel.sslmit.unibo.it/mailman/listinfo/cwb