[CWB] CQPweb installation errors
José Antonio M M
ja.martinezmarin at um.es
Fri Feb 12 02:24:46 CET 2016
Hello,
I am trying to get CQPweb version 3.2.6 revision 755 to work with mysql 5.7.11, PHP 5.6.18 and OS X 10.11. Both database setup and account creation are working properly for Wordpress, of which I’ve done a quick fresh install just to check.
I’m sorry I had previously sent an extract of the debug output. It is complete below.
Regards,
Jose
——
Now finalising setup for this installation of CQPweb....
PHP Notice: Undefined variable: mysql_link in /www/sites/cqpweb/wwwroot/bin/autosetup.php on line 62
Notice: Undefined variable: mysql_link in /www/sites/cqpweb/wwwroot/bin/autosetup.php on line 62
PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 156
Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 156
PHP Notice: Undefined variable: 6 in /www/sites/cqpweb/wwwroot/bin/autosetup.php on line 74
Notice: Undefined variable: 6 in /www/sites/cqpweb/wwwroot/bin/autosetup.php on line 74
Installing database structure; please wait.
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
show tables like "db_%"
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
show tables like "freq_corpus_%"
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
show tables like "freq_sc_%"
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
show tables like "freq_text_index_%"
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
show tables like "temporary_freq_%"
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
show tables like "text_metadata_for_%"
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
show tables like "__freqmake_temptable%"
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists annotation_mapping_tables
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `annotation_mapping_tables` (
`handle` varchar(20) NOT NULL,
`name` varchar(255),
`mappings` text character set utf8,
primary key(`handle`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists annotation_metadata
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `annotation_metadata` (
`corpus` varchar(20) NOT NULL,
`handle` varchar(20) NOT NULL,
`description` varchar(255) default NULL,
`is_feature_set` tinyint(1) NOT NULL default 0,
`tagset` varchar(255) default NULL,
`external_url` varchar(255) default NULL,
primary key (`corpus`, `handle`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists annotation_template_info
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `annotation_template_info` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`description` varchar(255) default NULL,
`primary_annotation` varchar(20) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists annotation_template_content
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `annotation_template_content` (
`template_id` int unsigned NOT NULL,
`order_in_template` smallint unsigned,
`handle` varchar(20) NOT NULL,
`description` varchar(255) default NULL,
`is_feature_set` tinyint(1) NOT NULL default 0,
`tagset` varchar(255) default NULL,
`external_url` varchar(255) default NULL
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists corpus_categories
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `corpus_categories` (
`id` int NOT NULL AUTO_INCREMENT,
`label` varchar(255) DEFAULT '',
`sort_n` int NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists corpus_info
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `corpus_info` (
/*
* General fields: identity, CWB data addresses, && size
*/
`id` int NOT NULL AUTO_INCREMENT,
`corpus` varchar(20) NOT NULL, # NB. This is always 100% the same as the handle in the PHP code.
`cqp_name` varchar(255) NOT NULL default '', # needed because cwb_external might be true.........
`date_of_indexing` timestamp NOT NULL default CURRENT_TIMESTAMP,
`cwb_external` tinyint(1) NOT NULL default 0,
`is_user_corpus` tinyint(1) NOT NULL default 0,
`size_tokens` int NOT NULL DEFAULT 0,
`size_types` int NOT NULL DEFAULT 0,
`size_texts` int NOT NULL DEFAULT 0,
/*
* Licensing and access info
*/
`access_statement` TEXT default NULL,
/*
* Search & analysis settings
*/
`primary_classification_field` varchar(64) default NULL,
`uses_case_sensitivity` tinyint(1) NOT NULL default 0,
/*
* System display: how the corpus is listed / appears in the interface
*/
`visible` tinyint(1) NOT NULL default 1,
`title` varchar(255) default '',
`corpus_cat` int NOT NULL DEFAULT 1,
`external_url` varchar(255) default NULL,
`public_freqlist_desc` varchar(150) default NULL,
`css_path` varchar(255) default '../css/CQPweb.css',
/*
* Annotation (p-attribute) info fields
*/
`primary_annotation` varchar(20) default NULL,
`secondary_annotation` varchar(20) default NULL,
`tertiary_annotation` varchar(20) default NULL,
`tertiary_annotation_tablehandle` varchar(40) default NULL,
`combo_annotation` varchar(20) default NULL,
/*
* Concordance/Context: appearance and visualisation control
* NB. Move viz to separate table?
*/
`main_script_is_r2l` tinyint(1) NOT NULL default 0,
`conc_s_attribute` varchar(64) NOT NULL default '', # default for this + next translates to 12 words.
`conc_scope` smallint NOT NULL default 12,
`initial_extended_context` smallint NOT NULL default 100,
`max_extended_context` smallint NOT NULL default 1100,
`alt_context_word_att` varchar(20) default '',
`visualise_gloss_in_concordance` tinyint(1) NOT NULL default 0,
`visualise_gloss_in_context` tinyint(1) NOT NULL default 0,
`visualise_gloss_annotation` varchar(20) default NULL,
`visualise_translate_in_concordance` tinyint(1) NOT NULL default 0,
`visualise_translate_in_context` tinyint(1) NOT NULL default 0,
`visualise_translate_s_att` varchar(64) default NULL,
`visualise_position_labels` tinyint(1) NOT NULL default 0,
`visualise_position_label_attribute` varchar(64) default NULL,
/*
* Housekeeping
*/
`indexing_notes` TEXT default NULL,
unique key (`corpus`),
primary key (`id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists corpus_metadata_variable
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `corpus_metadata_variable` (
`corpus` varchar(20) NOT NULL,
`attribute` text NOT NULL,
`value` text,
key(`corpus`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists metadata_template_info
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `metadata_template_info` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`description` varchar(255) default NULL,
`primary_classification` varchar(64) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists metadata_template_content
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `metadata_template_content` (
`template_id` int unsigned NOT NULL,
`order_in_template` smallint unsigned,
`handle` varchar(64) NOT NULL,
`description` varchar(255) default NULL,
`datatype` tinyint(2) NOT NULL default 2
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists query_history
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
create table query_history (
`instance_name` varchar(31) default NULL,
`user` varchar(64) default NULL,
`corpus` varchar(20) NOT NULL default '',
`cqp_query` text NOT NULL,
`restrictions` text,
`subcorpus` varchar(200) NOT NULL default '',
`date_of_query` timestamp NOT NULL default CURRENT_TIMESTAMP,
`hits` int(11) default NULL,
`simple_query` text,
`query_mode` varchar(12) default NULL,
KEY `user` (`user`),
KEY `corpus` (`corpus`),
KEY `cqp_query` (`cqp_query`(255))
) ENGINE=InnoDB CHARACTER SET utf8 collate utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists saved_catqueries
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `saved_catqueries` (
`catquery_name` varchar(150) NOT NULL,
`user` varchar(64) default NULL,
`corpus` varchar(20) NOT NULL default '',
`dbname` varchar(150) NOT NULL default '',
`category_list` TEXT,
KEY `catquery_name` (`catquery_name`),
KEY `user` (`user`),
KEY `corpus` (`corpus`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists saved_dbs
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `saved_dbs` (
`dbname` varchar(200) NOT NULL,
`user` varchar(64) default NULL,
`create_time` int(11) default NULL,
`cqp_query` text NOT NULL,
`restrictions` text,
`subcorpus` varchar(200) NOT NULL default '',
`postprocess` text,
`corpus` varchar (20) NOT NULL default '',
`db_type` varchar(15) default NULL,
`colloc_atts` varchar(200) default '',
`colloc_range` int default '0',
`sort_position` int default '0',
`db_size` bigint UNSIGNED default NULL,
`saved` tinyint(1) NOT NULL default 0,
primary key(`dbname`),
key (`user`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists saved_matrix_info
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `saved_matrix_info` (
`id` int NOT NULL AUTO_INCREMENT,
`savename` varchar(200),
`user` varchar(64) default NULL,
`corpus` varchar(20) NOT NULL default '',
`subcorpus` varchar(200) NOT NULL default '',
`unit` varchar(200) default NULL,
`create_time` int(11) default NULL,
primary key(`id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists saved_matrix_features
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `saved_matrix_features` (
`id` int NOT NULL AUTO_INCREMENT,
`matrix_id` int NOT NULL,
`label` varchar(255) NOT NULL,
`source_info` varchar(255) default NULL,
primary key(`id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists saved_freqtables
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `saved_freqtables` (
`freqtable_name` varchar(150) NOT NULL,
`corpus` varchar(20) NOT NULL default '',
`user` varchar(64) default NULL,
`restrictions` text character set utf8 collate utf8_bin,
`subcorpus` varchar(200) NOT NULL default '',
`create_time` int(11) default NULL,
`ft_size` bigint UNSIGNED default NULL,
`public` tinyint(1) default 0,
primary key (`freqtable_name`),
key `subcorpus` (`subcorpus`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists saved_queries
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `saved_queries` (
`query_name` varchar(150) NOT NULL,
`user` varchar(64) default NULL,
`corpus` varchar(20) NOT NULL default '',
`query_mode` varchar(12) default NULL,
`simple_query` text,
`cqp_query` text NOT NULL,
`restrictions` text default NULL,
`subcorpus` varchar(200) NOT NULL default '',
`postprocess` text,
`hits_left` text,
`time_of_query` int(11) default NULL,
`hits` int(11) default NULL,
`hit_texts` int(11) default NULL,
`file_size` int(10) unsigned default NULL,
`saved` tinyint(1) default 0,
`save_name` varchar(200) default NULL,
KEY `query_name` (`query_name`),
KEY `user` (`user`),
KEY `corpus` (`corpus`),
FULLTEXT KEY `restrictions` (`restrictions`),
KEY `subcorpus` (`subcorpus`),
FULLTEXT KEY `postprocess` (`postprocess`(100)),
KEY `time_of_query` (`time_of_query`),
FULLTEXT KEY `cqp_query` (`cqp_query`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists saved_subcorpora
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `saved_subcorpora` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL default '',
`corpus` varchar(20) NOT NULL default '',
`user` varchar(64) default NULL,
`restrictions` text,
`text_list` text,
`numfiles` mediumint(8) unsigned default NULL,
`numwords` bigint(21) unsigned default NULL,
primary key (`id`),
key(`corpus`, `user`),
key(`text_list`(255))
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists system_info
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `system_info` (
setting_name varchar(20) NOT NULL collate utf8_bin,
value varchar(255),
primary key(`setting_name`)
) CHARACTER SET utf8 COLLATE utf8_general_ci
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists system_longvalues
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `system_longvalues` (
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`id` varchar(40) NOT NULL,
`value` text NOT NULL,
primary key(`id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists system_messages
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `system_messages` (
`message_id` varchar(150) NOT NULL,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`header` varchar(150) default '',
`content` text character set utf8 collate utf8_bin,
`fromto` varchar(150) default NULL,
primary key (`message_id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists system_processes
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `system_processes` (
`dbname` varchar(200) NOT NULL,
`begin_time` int(11) default NULL,
`process_type` varchar(15) default NULL,
`process_id` varchar(15) default NULL,
primary key (`dbname`)
) CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists text_metadata_fields
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `text_metadata_fields` (
`corpus` varchar(20) NOT NULL,
`handle` varchar(64) NOT NULL,
`description` varchar(255) default NULL,
`datatype` tinyint(2) NOT NULL default 0, # uses METADATA_TYPE_* constants
# `is_classification` tinyint(1) default 0, # no longer a distinct field, deduced in code from datatype
primary key (`corpus`, `handle`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists text_metadata_values
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `text_metadata_values` (
`corpus` varchar(20) NOT NULL,
`field_handle` varchar(64) NOT NULL,
`handle` varchar(200) NOT NULL,
`description` varchar(255) default NULL,
`category_num_words` int unsigned default NULL,
`category_num_files` int unsigned default NULL,
primary key(`corpus`, `field_handle`, `handle`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists user_captchas
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `user_captchas` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`captcha` char(6),
`expiry_time` int unsigned,
primary key (`id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists user_cookie_tokens
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `user_cookie_tokens` (
`token` bigint UNSIGNED NOT NULL default 0,
`user_id` int NOT NULL,
`creation` int UNSIGNED NOT NULL default 0,
`expiry` int UNSIGNED NOT NULL default 0,
key(`token`, `user_id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists user_grants_to_users
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `user_grants_to_users` (
`user_id` int NOT NULL,
`privilege_id` int NOT NULL,
`expiry_time` int UNSIGNED NOT NULL default 0
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists user_grants_to_groups
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `user_grants_to_groups` (
`group_id` int NOT NULL,
`privilege_id` int NOT NULL,
`expiry_time` int UNSIGNED NOT NULL default 0
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists user_groups
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `user_groups` (
`id` int NOT NULL AUTO_INCREMENT,
`group_name` varchar(20) NOT NULL UNIQUE COLLATE utf8_bin,
`description` varchar(255) NOT NULL default '',
`autojoin_regex` text,
primary key (`id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:43 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 1 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
drop table if exists user_info
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:44 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
The query ran successfully in 0 seconds.
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/library.inc.php on line 535
<pre>
About to run the following MySQL query:
CREATE TABLE `user_info` (
`id` int NOT NULL AUTO_INCREMENT,
`username` varchar(64) NOT NULL,
`realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci default NULL,
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci default NULL,
`affiliation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci default NULL,
`country` char(2) default '00',
`passhash` char(61),
`acct_status` tinyint(1) NOT NULL default 0,
`verify_key` varchar(32) default NULL,
`expiry_time` int UNSIGNED NOT NULL default 0,
`password_expiry_time` int UNSIGNED NOT NULL default 0,
`last_seen_time` timestamp NOT NULL default 0,
`acct_create_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
`conc_kwicview` tinyint(1),
`conc_corpus_order` tinyint(1),
`cqp_syntax` tinyint(1),
`context_with_tags` tinyint(1),
`use_tooltips` tinyint(1),
`css_monochrome` tinyint(1) NOT NULL default 0,
`thin_default_reproducible` tinyint(1),
`coll_statistic` tinyint,
`coll_freqtogether` int,
`coll_freqalone` int,
`coll_from` tinyint,
`coll_to` tinyint,
`max_dbsize` int(10) unsigned default NULL,
`linefeed` char(2) default NULL,
unique key(`username`),
primary key (`id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:44 */
</pre>
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 88
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 88
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 89
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 89
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 91
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 91
<tr><td class="concorderror"><p> </p><p class="errormessage">A mySQL query did not run successfully!</p><p> </p></td></tr>
<tr><td class="concorderror"><p> </p><p class="errormessage">Original query:
CREATE TABLE `user_info` (
`id` int NOT NULL AUTO_INCREMENT,
`username` varchar(64) NOT NULL,
`realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci default NULL,
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci default NULL,
`affiliation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci default NULL,
`country` char(2) default '00',
`passhash` char(61),
`acct_status` tinyint(1) NOT NULL default 0,
`verify_key` varchar(32) default NULL,
`expiry_time` int UNSIGNED NOT NULL default 0,
`password_expiry_time` int UNSIGNED NOT NULL default 0,
`last_seen_time` timestamp NOT NULL default 0,
`acct_create_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
`conc_kwicview` tinyint(1),
`conc_corpus_order` tinyint(1),
`cqp_syntax` tinyint(1),
`context_with_tags` tinyint(1),
`use_tooltips` tinyint(1),
`css_monochrome` tinyint(1) NOT NULL default 0,
`thin_default_reproducible` tinyint(1),
`coll_statistic` tinyint,
`coll_freqtogether` int,
`coll_freqalone` int,
`coll_from` tinyint,
`coll_to` tinyint,
`max_dbsize` int(10) unsigned default NULL,
`linefeed` char(2) default NULL,
unique key(`username`),
primary key (`id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
/* from User: ??? | Function: cqpweb_mysql_total_reset() | 2016-02-12 02:05:44 */
</p><p> </p></td></tr>
<tr><td class="concorderror"><p> </p><p class="errormessage">Error # 1067: Invalid default value for 'last_seen_time' </p><p> </p></td></tr>
PHP Notice: Undefined property: stdClass::$all_users_see_backtrace in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 113
Notice: Undefined property: stdClass::$all_users_see_backtrace in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 113
PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 140
Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 140
</table>
PHP Fatal error: Call to undefined function print_html_footer() in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 159
Fatal error: Call to undefined function print_html_footer() in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 159
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 10 Feb 2016 02:06:34 +0100
> From: Jos? Antonio M M <ja.martinezmarin en um.es>
> To: cwb en sslmit.unibo.it
> Subject: Re: [CWB] CQPweb installation errors
> Message-ID: <2890D2C4-CFAA-4992-AA84-A8DF60C177BD en um.es>
> Content-Type: text/plain; charset=utf-8
>
> Thank you for your reply, Andrew.
>
> I think that if turning only NO_ZERO_DATE off results in error messages, either the code of CQPweb is changed or strict mode has to be disabled globally in mysql.
>
> I have a question and an error to correct in order to continue with this installation.
>
> The question is if the database has to be created as utf8_general_ci or utf8_bin. It seems that autosetup.php creates tables with both collations. The error messages is below.
>
> Thank you so much for your help,
> Jose
>
> <tr><td class="concorderror"><p> </p><p class="errormessage">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 </p><p> </p></td></tr>
>
> PHP Notice: Undefined property: stdClass::$all_users_see_backtrace in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 113
>
> Notice: Undefined property: stdClass::$all_users_see_backtrace in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 113
> PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 140
>
> Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 140
> </table>
> PHP Fatal error: Call to undefined function print_html_footer() in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 159
>
>
> Jos? Antonio
>
>> ------------------------------
>>
>> Message: 2
>> Date: Mon, 8 Feb 2016 12:56:04 +0000
>> From: "Hardie, Andrew" <a.hardie en lancaster.ac.uk>
>> To: Open source development of the Corpus WorkBench
>> <cwb en sslmit.unibo.it>
>> Subject: Re: [CWB] bugs caused by sql-mode issues.
>> Message-ID:
>> <28078EC3FBF1B940A3EF3D0D19BE351D7FAE649B en EX-0-MB1.lancs.local>
>> Content-Type: text/plain; charset="utf-8"
>>
>> There are two bugs here, one is an issue in the error reporting system for that script in 3.2.6, which I've now fixed in that branch (you should svn up); and the other is a more general one stemming from your MySQL setup.
>>
>> The latter was this message: " Invalid default value for 'last_seen_time' ".
>>
>> What this usually indicates is that you have the NO_ZERO_DATE option switched on in the MySQL server (which disallows the use of "0000-00-00" to indicate "never happened"... a convention that CQPweb uses).
>>
>> A quick look at the MySQL manual (see here: http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html ) suggests that NO_ZERO_DATE was switched on by default in MySQL v 5.7 (it was previously not enabled by default).
>>
>> Are you using v 5.7? I can't check this myself because my server and dev boxes all have older versions.
>>
>> If you are, then the solution is to disable NO_ZERO_DATE (or, in some MySQL versions, STRICT; see here: http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-changes )
>>
>> Here's what the manual says about setting the sql mode (of which NO_ZERO_DATE is part)
>>
>>>>
>> To set the SQL mode at server startup, use the --sql-mode="modes" option on the command line, or sql-mode="modes" in an option file such as my.cnf (Unix operating systems) or my.ini (Windows). modes is a list of different modes separated by commas.
>> <<
>>
>> The default sql-mode in 5.5/5.6. is empty. However, in 5.7 the default sql-mode adds a whole lot of "strictness": including NO_ZERO_DATE.
>>
>> So, if you are running v5.7, the mystery is solved.
>>
>> It looks as if MySQL are going in the direction of having strict mode on by default, and having strict mode include or imply NO_ZERO_DATE.
>>
>> I can see 3 longterm possibilities:
>>
>> - Add to the install manual an explanation that NO_ZERO_DATE must be turned off.
>> - Add code to CQPweb to turn off strictness as the first thing it does when it connects to mysql
>> - Take out anything in CQPweb which requires strictness to be turned off.
>>
>> I'm not wholly sure, yet, which of these would make the most sense. I'll have to think about it.
>>
>> best
>>
>> Andrew.
>
>
>
> ------------------------------
>
> Message: 2
> Date: Wed, 10 Feb 2016 04:31:10 +0000
> From: "Hardie, Andrew" <a.hardie en lancaster.ac.uk>
> To: Open source development of the Corpus WorkBench
> <cwb en sslmit.unibo.it>
> Subject: Re: [CWB] CQPweb installation errors
> Message-ID:
> <28078EC3FBF1B940A3EF3D0D19BE351D7FAE72F6 en EX-0-MB1.lancs.local>
> Content-Type: text/plain; charset="utf-8"
>
>>>>
> The question is if the database has to be created as utf8_general_ci or utf8_bin. It seems that autosetup.php creates tables with both collations.
> <<<
>
> You don't need to specify the database collation, only the charset. See manual page 13. The collation is specified at table or column level.
>
> As for the error - I am afraid I have no idea what the problem is here. It's a problem not with database setup, which is complete at this point, but with user account creation. I would need to see the full debug output to know what the issue is. You can get this by editing autosetup to find the line that says,
>
> $Config->print_debug_messages = false;
>
> (somewhere circa line 75) and changing false to true.
>
> best
>
> Andrew.
>
> -----Original Message-----
> From: cwb-bounces en sslmit.unibo.it [mailto:cwb-bounces en sslmit.unibo.it] On Behalf Of Jos? Antonio M M
> Sent: 10 February 2016 01:07
> To: cwb en sslmit.unibo.it
> Subject: Re: [CWB] CQPweb installation errors
>
> Thank you for your reply, Andrew.
>
> I think that if turning only NO_ZERO_DATE off results in error messages, either the code of CQPweb is changed or strict mode has to be disabled globally in mysql.
>
> I have a question and an error to correct in order to continue with this installation.
>
> The question is if the database has to be created as utf8_general_ci or utf8_bin. It seems that autosetup.php creates tables with both collations. The error messages is below.
>
> Thank you so much for your help,
> Jose
>
> <tr><td class="concorderror"><p> </p><p class="errormessage">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 </p><p> </p></td></tr>
>
> PHP Notice: Undefined property: stdClass::$all_users_see_backtrace in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 113
>
> Notice: Undefined property: stdClass::$all_users_see_backtrace in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 113
> PHP Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 140
>
> Notice: Undefined property: stdClass::$debug_messages_textonly in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 140
> </table>
> PHP Fatal error: Call to undefined function print_html_footer() in /www/sites/cqpweb/wwwroot/lib/exiterror.inc.php on line 159
>
>
> Jos? Antonio
>
>> ------------------------------
>>
>> Message: 2
>> Date: Mon, 8 Feb 2016 12:56:04 +0000
>> From: "Hardie, Andrew" <a.hardie en lancaster.ac.uk>
>> To: Open source development of the Corpus WorkBench
>> <cwb en sslmit.unibo.it>
>> Subject: Re: [CWB] bugs caused by sql-mode issues.
>> Message-ID:
>> <28078EC3FBF1B940A3EF3D0D19BE351D7FAE649B en EX-0-MB1.lancs.local>
>> Content-Type: text/plain; charset="utf-8"
>>
>> There are two bugs here, one is an issue in the error reporting system for that script in 3.2.6, which I've now fixed in that branch (you should svn up); and the other is a more general one stemming from your MySQL setup.
>>
>> The latter was this message: " Invalid default value for 'last_seen_time' ".
>>
>> What this usually indicates is that you have the NO_ZERO_DATE option switched on in the MySQL server (which disallows the use of "0000-00-00" to indicate "never happened"... a convention that CQPweb uses).
>>
>> A quick look at the MySQL manual (see here: http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html ) suggests that NO_ZERO_DATE was switched on by default in MySQL v 5.7 (it was previously not enabled by default).
>>
>> Are you using v 5.7? I can't check this myself because my server and dev boxes all have older versions.
>>
>> If you are, then the solution is to disable NO_ZERO_DATE (or, in some MySQL versions, STRICT; see here: http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-changes )
>>
>> Here's what the manual says about setting the sql mode (of which NO_ZERO_DATE is part)
>>
>>>>
>> To set the SQL mode at server startup, use the --sql-mode="modes" option on the command line, or sql-mode="modes" in an option file such as my.cnf (Unix operating systems) or my.ini (Windows). modes is a list of different modes separated by commas.
>> <<
>>
>> The default sql-mode in 5.5/5.6. is empty. However, in 5.7 the default sql-mode adds a whole lot of "strictness": including NO_ZERO_DATE.
>>
>> So, if you are running v5.7, the mystery is solved.
>>
>> It looks as if MySQL are going in the direction of having strict mode on by default, and having strict mode include or imply NO_ZERO_DATE.
>>
>> I can see 3 longterm possibilities:
>>
>> - Add to the install manual an explanation that NO_ZERO_DATE must be turned off.
>> - Add code to CQPweb to turn off strictness as the first thing it does when it connects to mysql
>> - Take out anything in CQPweb which requires strictness to be turned off.
>>
>> I'm not wholly sure, yet, which of these would make the most sense. I'll have to think about it.
>>
>> best
>>
>> Andrew.
>
> _______________________________________________
> CWB mailing list
> CWB en sslmit.unibo.it
> http://devel.sslmit.unibo.it/mailman/listinfo/cwb
>
> ------------------------------
>
> _______________________________________________
> CWB mailing list
> CWB en sslmit.unibo.it
> http://devel.sslmit.unibo.it/mailman/listinfo/cwb
>
>
> End of CWB Digest, Vol 109, Issue 3
> ***********************************
More information about the CWB
mailing list