I have been using the acl module for a while with no problem until I started getting these ugly error messages sometimes filling the page! :( Here is a small fraction of what i got on the page:

# user warning: Table './xprt007_orbit2/acl' was created with a different version of MySQL and cannot be read query: SELECT n.*, 'acl' AS realm, n.acl_id AS gid, a.module FROM acl_node n INNER JOIN acl a ON n.acl_id = a.acl_id WHERE nid = 1 in /home/xprt007/public_html/orbit2/includes/database.mysql.inc on line 172.
# user warning: Table './xprt007_orbit2/acl' was created with a different version of MySQL and cannot be read query: SELECT n.*, 'acl' AS realm, n.acl_id AS gid, a.module FROM acl_node n INNER JOIN acl a ON n.acl_id = a.acl_id WHERE nid = 2 in /home/xprt007/public_html/orbit2/includes/database.mysql.inc on line 172.
# user warning: Table './xprt007_orbit2/acl' was created with a different version of MySQL and cannot be read query: SELECT n.*, 'acl' AS realm, n.acl_id AS gid, a.module FROM acl_node n INNER JOIN acl a ON n.acl_id = a.acl_id WHERE nid = 3 in /home/xprt007/public_html/orbit2/includes/database.mysql.inc on line 172.
# user warning: Table './xprt007_orbit2/acl' was created with a different version of MySQL and cannot be read query: SELECT n.*, 'acl' AS realm, n.acl_id AS gid, a.module FROM acl_node n INNER JOIN acl a ON n.acl_id = a.acl_id WHERE nid = 4 in

I am using MySQL database: 4.1.22
PHP: 5.2.4 on the server.

I was originally having the latest stable version, but the dev. version also generates the same error.
No idea what could have triggered this. I'm not sure the host changed cthe mysql version.

What to do?

Regards

Comments

salvis’s picture

salvis
he/his
commented

Ouch! I have no idea what has happened to your acl table.

Do you have phpMyAdmin or some similar tool that lets you access your database? Can you list the acl contents

SELECT * FROM acl

using that tool? Can you copy them to a new table and swap the tables?

I find it very odd that this could have happened to the acl table only and to none of the others. Be sure to secure a backup, if you have one!

Also, try to contact your hosting provider and ask them, whether they've upgraded MySQL, and what they suggest to deal with the situation.

lionheart8’s picture

lionheart8 commented

Hi
thanks for responding.
It seems the problem is related to some ongoing Mysql server related problems.
Yes, of the several dozen modules I have, somehow only ACL was affected, no idea why. It is also ridiculous after months of peaceful co-existence suddenly this module could start causing problems.
What made me think it is server-related is a new Joomla installation which was working with no problem, also had the site not loading sighting(?) ;) a similar error, of an older Mysql version used for the installation than the current one.

The Drupal & Joomla sites have however at times been functioning with no problem.
I will try to get some feedback from the host as suggested.

Meanwhile, I just found this on the Phpmyadmin page:

Your PHP MySQL library version 4.1.22 differs from your MySQL server version 5.0.45. This may cause unpredictable behavior.

.. which I think shows it is related to a recent Mysql version upgrade.
Thanks & regards

salvis’s picture

salvis
he/his
commented

Ok, thanks, please let us know how this goes on...

lionheart8’s picture

lionheart8 commented

Hey, that was really fast or too fast ;).
I thought this info I added after editing my previous posting could be missed as you had already read it.
I saw it after looking at the Phpmyadmin page.

Your PHP MySQL library version 4.1.22 differs from your MySQL server version 5.0.45. This may cause unpredictable behavior.

salvis’s picture

salvis
he/his
commented
Category: bug » support
Status: Active » Closed (fixed)

Ah, yes, I would have missed it indeed, thanks!

I hope you / your hoster will be able to clean it up. I'm closing this issue now -- don't hesitate to reactivate it if necessary.