[LON-CAPA-admin] storing metadata

[Stefan Bisitz]

Hi, 
 
In lonsql.log I can find a lot of entries like this: 
 
-------- begin -------- 
WARNING: Could not retrieve from database: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 ')' at line 1 
-------- end -------- 
 
and also 
 
-------- begin -------- 
WARNING: Could not retrieve from database:Unknown column 'domain' in 'where clause' 
-------- end -------- 
 
YaST says that I have installed mysql 4.0.18-32.1 x86_64 SUSE CORE version 9 
 
Gerd, do you know what´s going on here? 
 
Stefan 
 
 
> --- Ursprüngliche Nachricht --- 
> Von: Gerd Kortemeyer <korte at lite.msu.edu> 
> An: lon-capa-admin at mail.lon-capa.org 
> Betreff: Re: [LON-CAPA-admin] storing metadata 
> Datum: Thu, 26 Jan 2006 12:11:17 -0500 
>  
> Hi Stefan, 
>  
> This means that MySQL is not running properly. I don't know where   
> SLES puts stuff, but it would be good to have a look at the MySQL log   
> files, as well as /home/httpd/perl/logs/lonsql.log 
>  
> - Gerd. 
>  
> On Jan 26, 2006, at 11:53 AM, Stefan Bisitz wrote: 
>  
> > Hi there, 
> > 
> > I´ve trouble with storing metadata. Can someone help? 
> > I´m using LON-CAPA 2.1.1, SLES9 
> > 
> > login as author 
> > Create a new problem 
> > publish this problem 
> > enter metadata 
> > click publish 
> > 
> > -> error message: "Error occured storing new values in metadata   
> > table in LON-CAPA database" 
> > 
> > 
> > Go to Construction Space 
> > Choose the published problem 
> > click "Edit Metadata" 
> > change something, e.g. the title, save 
> > 
> > -> the old value of the title is shown 
> > (but edit shows now the new value) 
> > 
> > -> "Search the datbase of published resources" (SRCH) leads to no   
> > results at all. 
> > 
> > 
> > Does anybody else have/had the same problem? 
> > 
> > Best regards, 
> > Stefan Bisitz