[Xerte] Database problem with 0.9 on LAMP

[Patrick Lockley]

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