Ooops!

[Julian]

Went to look at my sent messages today and got the following warning ....

Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'bioforum.pm.id_pm' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /var/www/biopowered/forum/Sources/PersonalMessage.php
Line: 702

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.11, while your database is at version 2.0.1. The above error might possibly go away if you execute the latest version of upgrade.php.

Not a major issue if its just sent messages, but could the version mismatch start effecting other things?

[Keef]

That's odd, mine are working ok.

[Julian]

Still the same for me, but then one of my few areas excellence is to break things just by looking.

[photoman290]

that reminds me of an old girlfriend who  blamed me when her hairdryer let out the magic smoke whilst i was using it. "it must have been your fault you know about these things " now buy me another one.

[Tony]

Is appears from http://www.biopowered.co.uk/forum/index.php?action=admin;area=maintain;sa=routine;activity=version that we have a mixture of revisions... and applying the latest patch seems to fail.

Sounds like we need to take a backup of the site, then try applying successive patches for each revision and see if we can get it all up to date.

That or apply a clean install and figure out the local modifications we've made over the years.

Might have a crack at that this evening if I get the time.

[Julian]

Tony, you're a star!

[Tony]

Not this evening I'm afraid. My brother is visiting and will be sampling Vince's cider.  If I touch any code after that it could end badly!