Looks like Andy wasn't running MySQL 4.1.21 (that was his client), his server version was 4.0.27.

So at the moment the two outstanding issues are now both linked to 4.0 - which doesn't support the query used in this mod.

I had a friend of mine build a completely different query. However, the new one doesn't work on mysql 4.0 either.

I've therefore updated the xml installer so that it requires mysql 4.1. Sorry to all those 4.0 users out there (I guess there are still a small number), but unless you upgrade to at least 4.1 you won't be able to use this mod.

The minimum version requirement should cut down on the number of new cases reporting this error, since they won't be able to install it.

I get this:

Is there a way to upgrade sql without messing things up? I really don't know, never upgraded

Excellent, then that little version check has saved another SQL syntax error being posted in here :-)

I'm afraid I can't give you any advice on upgrading your version of mysql - I've never done it myself either so I don't know what the issues are. I'd suggest trying to locate another thread or using google to try and figure that out.

Installed.

Hey there, thanks for making this neat mod.

I'm having trouble. I have the settings set to:

Force unique avatars? no
Display number of times used? yes
Hide used avatars? no


however when I used an avatar it still hides it and doesn't say "used x times"

I would love some help! :)

maybe it was because I was an admin? I had a normal user use one and while it did NOT disappear it also didn't say "Used 1 time" or anything.

:(

You won't have much luck if you set this setting to "no" because then it will disable the mod. The whole point of this mod is to force unique avatars, so by setting it to no you can't be surprised if nothing happens!

Mark

Upgraded MySQL and the mod is working perfectly! Thanks again, mfyvie.

moved hosts and all is working fine thanks

it`s showing me this any idea how to solve this problem. Other than upgrading my SQL version.......