[Xerte] Database problem with 0.9 on LAMP

[Geoff King]

Yes. It's fixed that problem.

----- "Patrick Lockley" <Patrick.Lockley at nottingham.ac.uk> wrote:

> Thanks Geoff,
> 
> Does the system now display what you where expecting?
> 
> I've not had chance to check here and fix yet 
> 
> -----Original Message-----
> From: xerte-bounces at lists.nottingham.ac.uk
> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Geoff King
> Sent: 08 December 2008 12:24
> To: Xerte discussion list
> Subject: Re: [Xerte] Database problem with 0.9 on LAMP
> 
> Here you go.
> 
> line 130:
> 
> select folder_id, folder_name from folderdetails where login_id
> ="118"
> and folder_parent="777" order by date_created DESC
> 
> line 188:
> 
> select template_name, template_id from templatedetails where
> template_id
> in ( select templaterights.template_id from templaterights where
> user_id
> ="119" and folder="778") order by templatedetails.date_created DESC
> 
> line 241:
> 
> select * from originaltemplatesdetails where access_rights="*" order
> by
> date_uploaded DESC
> 
> line 311:
> 
> select * from originaltemplatesdetails where access_rights!="*" order
> by
> date_uploaded DESC
> 
> Additionally, I tried removing the db prefix from the config.php and
> manually renaming the db tables in the xerte db to remove the prefix
> I
> had set from them. After doing this, the errors disappear.
> 
> ----- "Patrick Lockley" <Patrick.Lockley at nottingham.ac.uk> wrote:
> 
> > [Xerte] Database problem with 0.9 on LAMP
> > 
> > Hi Geoff
> > 
> > Welcome to the list. I am Pat, and its my PHP that is failing :)
> > 
> > I believe the problem is a bug with the database name prefix.
> > 
> > Could you go into display library for me and echo out the query?
> > 
> > Thanks
> > 
> > Pat
> > 
> > 
> > From: xerte-bounces at lists.nottingham.ac.uk on behalf of Geoff King
> > Sent: Mon 08/12/2008 10:53
> > To: xerte at lists.nottingham.ac.uk
> > Subject: [Xerte] Database problem with 0.9 on LAMP
> > 
> > 
> > 
> > 
> > Hello, I'm new to the Xerte list. :)
> > 
> > I've installed Xerte 0.9 from scratch on our LAMP server. It's 64bit
> 
> > Ubuntu 6.06 LTS running MySQL 5.0.22, PHP 5.1.2 and Apache 2.0.55.
> > Apache is configured with IP based vhosts. I have setup Xerte using
> 
> > the XAMPP instructions as a guide. However after renaming the
> demo.php
> 
> > I get errors relating to MySQL. The exact messages are:
> > 
> > Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
> 
> > result resource in 
> >
> /var/www/xerte.carrhill.lancs.sch.uk/toolkits/website_code/php/display
> > _library.php
> > on line 130
> > 
> > Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
> 
> > result resource in 
> >
> /var/www/xerte.carrhill.lancs.sch.uk/toolkits/website_code/php/display
> > _library.php
> > on line 188
> > 
> > The above appear in the 'my projects' window. I also get further 
> > similar errors in the 'create a new project' window:
> > 
> > Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
> 
> > result resource in 
> >
> /var/www/xerte.carrhill.lancs.sch.uk/toolkits/website_code/php/display
> > _library.php
> > on line 241
> > 
> > Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
> 
> > result resource in 
> >
> /var/www/xerte.carrhill.lancs.sch.uk/toolkits/website_code/php/display
> > _library.php
> > on line 311
> > 
> >
> **********************************************************************
> > ***** This e-mail is confidential and privileged. If you are not the
> 
> > intended recipient do not disclose, copy or distribute information
> in 
> > this e-mail or take any action in reliance on its content.
> >
> **********************************************************************
> > *****
> > 
> >
> **********************************************************************
> > ***** This email has been checked for known viruses.
> >
> **********************************************************************
> > ***** _______________________________________________
> > Xerte mailing list
> > Xerte at lists.nottingham.ac.uk
> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> > 
> > _______________________________________________
> > Xerte mailing list
> > Xerte at lists.nottingham.ac.uk
> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> 
> ************************************************************************
> ***
> This e-mail is confidential and privileged.  If you are not the
> intended
> recipient do not disclose, copy or distribute information in this
> e-mail
> or take any action in reliance on its content.
> ************************************************************************
> ***
> 
> ************************************************************************
> ***
> This email has been checked for known viruses. 
> ************************************************************************
> ***
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte

***************************************************************************
This e-mail is confidential and privileged.  If you are not the intended
recipient do not disclose, copy or distribute information in this e-mail
or take any action in reliance on its content.
***************************************************************************

***************************************************************************
This email has been checked for known viruses. 
***************************************************************************