[LON-CAPA-admin] storing metadata

[Michael W Edwards]

The SQL statement below is the one that actually worked, not the broken original one that was in the docs, I stole it from my .mysql_history file.  We're also running mysql 4.0.18-32.1 on X86_64.

Mike

> -----Original Message-----
> From: lon-capa-admin-admin at mail.lon-capa.org [mailto:lon-capa-admin-
> admin at mail.lon-capa.org] On Behalf Of Michael W Edwards
> Sent: Thursday, January 26, 2006 12:56 PM
> To: lon-capa-admin at mail.lon-capa.org
> Subject: RE: [LON-CAPA-admin] storing metadata
> 
> Not sure if this will help, I've always done the installs manually since I
> pre-date the rpm's for SLES9.  We're running 2.0.2 and every time I've
> created the mysql DB I had to add 2-3 additional 'Y's to the sql
> statement:
> 
> INSERT INTO db VALUES ('localhost','loncapa','www',
> 'Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y');
> 
> I can't find the manual installation page on install.lon-capa.org anymore
> so I can't remember how many I actually had to add.
> 
> Mike
> 
> > -----Original Message-----
> > From: lon-capa-admin-admin at mail.lon-capa.org [mailto:lon-capa-admin-
> > admin at mail.lon-capa.org] On Behalf Of Stefan Bisitz
> > Sent: Thursday, January 26, 2006 11:35 AM
> > To: lon-capa-admin at mail.lon-capa.org
> > Subject: Re: [LON-CAPA-admin] storing metadata
> >
> > 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
> >
> >
> > _______________________________________________
> > LON-CAPA-admin mailing list
> > LON-CAPA-admin at mail.lon-capa.org
> > http://mail.lon-capa.org/mailman/listinfo/lon-capa-admin
> 
> _______________________________________________
> LON-CAPA-admin mailing list
> LON-CAPA-admin at mail.lon-capa.org
> http://mail.lon-capa.org/mailman/listinfo/lon-capa-admin