MySQL requirements

Re: http://www.villacompeta.com/openresort

Hi

I recently installed Openresort but have encountered a MySQL bug recently.

After contacting my host they've said the SQL requirements of openresort might be different to what they provide. (I was dubious about this as I'd had openresort installed and setup businesses/units with it before the error though - so couldn't see why it had suddenly become an issue!)

Could someone confirm what the MySQL requirements of Openresort are please?

The hosting I am using provides - MySQL version 5.0.27 - should this be enough??

I've pasted the error below for reference (this seems to crop up when I try and navigate to edit a unit - I also get a strange effect of being logged out when I click on the booking section of the site i'm making, but i'm logged back in when i navigate away from the section...)

Also click on 'check availability' on the right hand menu to see another bug that's been cropping up...

Would an overwrite of the basic openresort module be an idea do you think?

-----------------------------

* warning: Invalid argument supplied for foreach() in /home/nowaks/public_html/openresort/modules/node/node.module on line 521.
* warning: implode() [function.implode]: Bad arguments. in /home/nowaks/public_html/openresort/modules/node/node.module on line 525.
* user warning: 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 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /home/nowaks/public_html/openresort/includes/database.mysql.inc on line 172.