[Xerte] Database problem with 0.9 on LAMP

[Geoff King]

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. 
***************************************************************************