[LON-CAPA-admin] storing metadata

Guy Albertelli II guy at albertelli.com
Thu Jan 26 15:12:12 EST 2006


Hi Stefan,

> 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 

Hrrm, I think we are going to need more diagnostic information to
figure out what's up.

Could you send me (guy at albertelli.com) a complete lonsql.log ?

Also could you do:

$ mysql -u www -p loncapa

(password is localhostkey)

and then the sql queris:

show tables;

and

describe metadata;

And send me that output?

-- 
guy at albertelli.com   0-7-1-8-27,137



More information about the LON-CAPA-admin mailing list