PHP error after Update => 5.x-2.8

Sounds like you never ran update.php. If that doesn't fix it, run it again and ensure to select update 2 from the drop-down list for the 'avatar selection module.

This update just killed my whole site.

I can not access any admin functions after the update.

This is what the users see after the update.

user warning: Unknown column 'access' in 'field list' query: SELECT avatar, access, og_access FROM avatar_selection avs in /home/zoooapo0/public_html/includes/database.mysql.inc on line 174.

I will try to go back to the previous version.

This is what I get when I try to go back to an older version.

Apart from that the function that checks for new version also does not work anymore.

Before you upgraded did you have a table called 'avatar_selection', if so what was its structure and what version of avatar selection module are you upgrading from?

I did have that table on all my seven sites.

I attached the backup from one of the other sites as a zip file.

I also tried deleting the tables from the sql and then reinstalling the new version. The problem remains: when I use the latest version I can not access any admin functions anymore. On top of that I notived now that I can not log out sometimes. As a result my user 1 shows up as being logged in three times even though on all seven sites I am logged out.

Trying to go back did not solve any pronblems. I am still beeing looged in, the check for updates function does not work on any site and I am receiving errors.

P.S. this is gettin better and better, now I am logged in 5 times on the "who is online Block".

Can you try the 5.x-2.x-dev version? I think that will fix the problem, but don't want to cut another release in case it doesn't.

Okay I just tried that.

It is really quite simple:

As soon as any version of "avatar_selection" is loaded into the "sites/all/modules" directory I can not access any administration functions. Every click on any admin function or page will result in an endless loading that will eventually time out.

The dev version should fix it. The problem was that the release was made from an old branch. Installing the dev version and running update.php *should* fix it.

Unfortunately it does not fix the problem.

I tried the 2.8 version, the dev version and the 2.7 version.
As soon as any of these version folders are in the "sites/all/modules" directory and the update.php is run I can not acces any admin functions.
As soon as I delete the "avatar_selection" folder the admin access works again.

Before the update all my seven sites were functioning flawlessly for more than 6 months. The only bug was the fact that you could click on the avatars as an unregistered user resultung in an access denied page.

Now I will have to completely remove the avatar selction from all sites. Unfortuanately the update function is broken too now. All seven sites are "Unable to fetch any information on available new releases and updates." ever since I uploades the update.

How can a simple module do so much damage?

@Frank.dev, @paul_constantine, @Everyone, use the 5.x-2.x-dev version. Ensure you run update.php - you may get some errors, if you ran it before but which can probably be ignored.

@paul_constantine - i admit fault for messing up the release tarball, but this is why all module maintainers recommend testing on a dev site before upgrading live sites.

@paul_constantine - what happens when you upgrade to the dev version? You should definitely no longer be getting the mysql error. You say it's not working, but it's not clear in what way the sites break. Would you mind elaborating?

Hello Stella,

First let me say that I finally got the dev-version to work after I disabled, de-installed and deleted the "Update Status" module on all my sites.
I am not a programmer so I can only tell you what I observed.

After I copied the Avatar Select 2.8 Version into my sites/all/modules directory yesterday morning I could not access any administration pages of functions. The page/function would load and load and eventually time out. After I subsequently deleted the Avatar Select Folder I could access the administration functions again.

I then noticed in the log files that the "Update Status" module was producing loads of errors because it was not able to update. This was happening on all other sites as well. But I did not pay any attention to that because I was so busy installing and de-installing different versions of avatar select until I finally gave up and completely removed the module from all sites and also removed all MYSQL entries concerning that module.

After that I got back to the "Update Status" module and removed that as well just to re-install it to get it to work again. To my surprise the same problem appeared upon re-installing the Update Status: I could again not access any administration functions. Being totally fed up and pissed off I wiped the Update Status off all my sites (folders, SLQ and all).

This morning after reading your comment I gave the Avatar Select another try and now it worked.

So it was the "Update Status" module that broke after I installed the 2.8 Version of the "Avatar Select" module (that’s when the errors on the logs first started) that was somehow responsible.

I decided that I can live with out the Update Status (that got me into this mess in the first place!). The avatar images are still clickable for even if you are not logged in but I can live with that as well.

Thank you for your support,

Paul

I've just released a 5.x-2.9 version - it's the same as the last dev, but unlike 5.x-2.8 it's made on the correct branch. Sorry for the hassle caused.

Cheers,
Stella