[CWB] [CQPweb] Install error: sql-definitions.inc.php nowhere to be found

[Uhrig, Peter]

Hi Andrew,

it still breaks in the current trunk. At least two reasons:

  1.  The line “//TODO actually, the tertiary can only be 40” is not a valid SQL comment. It has to be “/*TODO actually, the tertiary can only be 40*/”
  2.  There is something wrong in the following statement after DEFAULT:

        $create_statements['user_colleague_grants'] =
                "CREATE TABLE `user_colleague_grants` (
                        `corpus_id` $type_foreign_key_id,
                        `grantee_id` $type_foreign_key_id,
                        `comment` varchar($strlen_general) NOT NULL DEFAULT '
                        key(`grantee_id`)
                ) $engine CHARACTER SET utf8 COLLATE utf8_bin";

Best wishes,
Peter

Von: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> Im Auftrag von Hardie, Andrew
Gesendet: Mittwoch, 8. Mai 2019 18:34
An: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Betreff: Re: [CWB] [CQPweb] Install error: sql-definitions.inc.php nowhere to be found

Ah yes – this is due to a security check I added which autosetup didn’t know about. Fixed in latest commit to repo.

Andrew.



From: Scott Sadowsky <ssadowsky at gmail.com<mailto:ssadowsky at gmail.com>>
Sent: 08 May 2019 09:56
To: Hardie, Andrew <a.hardie at lancaster.ac.uk<mailto:a.hardie at lancaster.ac.uk>>
Cc: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it<mailto:cwb at sslmit.unibo.it>>
Subject: Re: [CWB] [CQPweb] Install error: sql-definitions.inc.php nowhere to be found

On Wed, May 8, 2019 at 1:55 AM Hardie, Andrew <a.hardie at lancaster.ac.uk<mailto:a.hardie at lancaster.ac.uk>> wrote:

That’s very peculiar… I’m not aware of any script that references that file. Certainly I don’t believe it’s mentioned in autosetup. Is there any more to the error message?

It's gone now, happily. I was getting strange svn errors for a while ("Malformed HTML entity", for example, plus aborted downloads), so who knows what happened. But I do have another question for you (and I apologize in advance for asking so many of them).

I'm at the very last step of installing CQPweb, and I'm getting the following error:

/var/www/html/cqpweb/bin $ sudo php autosetup.php

Now finalising setup for this installation of CQPweb.....

Installing database structure; please wait.
PHP Fatal error: Uncaught Error: Call to a member function is_admin() on null in /var/www/html/cqpweb/lib/sql-definitions.php:44
Stack trace:
#1 /var/www/html/cqpweb/bin/autosetup.php(87): do_mysql_total_reset()
#1 (main)
  thrown in /var/www/html/cqpweb/lib/sql-definitions.php on line 44

Any idea where I went wrong here?

Assuming it's relevant, here's the contents of my config.inc.php file (minus the comments):

<?php
$superuser_username = 'cqpweb';

$mysql_webuser = 'cqpweb';
$mysql_webpass = 'hunter2';
$mysql_schema  = 'cqpweb';
$mysql_server  = 'localhost';

$cqpweb_tempdir   = '/usr/local/share/cqpweb/cache';
$cqpweb_uploaddir = '/usr/local/share/cqpweb/upload';
$cwb_datadir      = '/usr/local/share/cqpweb/data';
$cwb_registry     = '/usr/local/share/cqpweb/registry';
?>

These four directories are owned by www-data, and their permissions are all drwsrws---. I've gotten the same error when using a different $superuser_username value, for what that's worth.

Thanks in advance!
Scott

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20190508/65af408c/attachment-0001.html>