[CWB] CQPWeb-In-A-Box retrieving metadata from XML

[Hardie, Andrew]

Run upgrade-database.

-----Original Message-----
From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Silvio Fuchs
Sent: 14 October 2015 16:59
To: cwb at sslmit.unibo.it
Subject: Re: [CWB] CQPWeb-In-A-Box retrieving metadata from XML

Thanx Andrew for your quick response. 

I updated cqpweb from the virtual machine using SVN. It says that it updated to revision 687. When I then go to the metadata page of my corpus however, it looks worse than before. This is what I get:

> Describe the contents of the file you have selected
> Choose template for text metadata structure
> (or select "Custom metadata structure" and specify annotations in the boxes below) 	
> 
>  
> 
> A mySQL query did not run successfully!
> 
>  
> 
>  
> 
> Original query: select * from metadata_template_info order by id /* from User: user | Function: list_metadata_templates() | 2015-10-14 15:48:10 */
> 
>  
> 
>  
> 
> Error # 1146: Table 'cqpweb.metadata_template_info' doesn't exist
> 
>  
> PHP debugging backtrace
> 
> array(5) {
>   [1]=>
>   array(4) {
>     ["file"]=>
>     string(40) "/var/www/html/cqpweb/lib/library.inc.php"
>     ["line"]=>
>     int(262)
>     ["function"]=>
>     string(20) "exiterror_mysqlquery"
>     ["args"]=>
>     array(3) {
>       [0]=>
>       &int(1146)
>       [1]=>
>       &string(51) "Table 'cqpweb.metadata_template_info' doesn't exist"
>       [2]=>
>       &string(132) "select * from metadata_template_info order by id 
> 	/* from User: user | Function: list_metadata_templates() | 2015-10-14 15:48:10 */"
>     }
>   }
>   [2]=>
>   array(4) {
>     ["file"]=>
>     string(42) "/var/www/html/cqpweb/lib/templates.inc.php"
>     ["line"]=>
>     int(428)
>     ["function"]=>
>     string(14) "do_mysql_query"
>     ["args"]=>
>     array(1) {
>       [0]=>
>       &string(48) "select * from metadata_template_info order by id"
>     }
>   }
>   [3]=>
>   array(4) {
>     ["file"]=>
>     string(49) "/var/www/html/cqpweb/lib/indexforms-admin.inc.php"
>     ["line"]=>
>     int(785)
>     ["function"]=>
>     string(23) "list_metadata_templates"
>     ["args"]=>
>     array(0) {
>     }
>   }
>   [4]=>
>   array(4) {
>     ["file"]=>
>     string(42) "/var/www/html/cqpweb/lib/queryhome.inc.php"
>     ["line"]=>
>     int(339)
>     ["function"]=>
>     string(21) "printquery_managemeta"
>     ["args"]=>
>     array(0) {
>     }
>   }
>   [5]=>
>   array(4) {
>     ["file"]=>
>     string(34) "/var/www/html/cqpweb/exe/index.php"
>     ["line"]=>
>     int(1)
>     ["args"]=>
>     array(1) {
>       [0]=>
>       string(42) "/var/www/html/cqpweb/lib/queryhome.inc.php"
>     }
>     ["function"]=>
>     string(7) "require"
>   }
> }

I would be very thankful for further help getting this to work. The idea with the Virtual Machine is great for MySQL noobs like me :D

Regards

Silvio

_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
http://devel.sslmit.unibo.it/mailman/listinfo/cwb