<HTML dir=ltr><HEAD><TITLE>[Xerte] Database problem with 0.9 on LAMP</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.16674" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText38789 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Hi Geoff</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Welcome to the list. I am Pat, and its my PHP that is failing :)</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>I believe the problem is a bug with the database name prefix.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Could you go into display library for me and echo out the query?</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Thanks</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Pat</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> xerte-bounces@lists.nottingham.ac.uk on behalf of Geoff King<BR><B>Sent:</B> Mon 08/12/2008 10:53<BR><B>To:</B> xerte@lists.nottingham.ac.uk<BR><B>Subject:</B> [Xerte] Database problem with 0.9 on LAMP<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Hello, I'm new to the Xerte list. :)<BR><BR>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:<BR><BR>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<BR><BR>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<BR><BR>The above appear in the 'my projects' window. I also get further similar errors in the 'create a new project' window:<BR><BR>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<BR><BR>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<BR><BR>***************************************************************************<BR>This e-mail is confidential and privileged. If you are not the intended<BR>recipient do not disclose, copy or distribute information in this e-mail<BR>or take any action in reliance on its content.<BR>***************************************************************************<BR><BR>***************************************************************************<BR>This email has been checked for known viruses.<BR>***************************************************************************<BR>_______________________________________________<BR>Xerte mailing list<BR>Xerte@lists.nottingham.ac.uk<BR><A href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</A><BR></FONT></P></DIV></BODY></HTML>