Database error [Solved]

[lesmond]

A site I help maintain, has a DB error showing on the front home page, from what I can see it may be something to do with his tinyportal, I have checked all running block and turned them off one by one.

Code Select Expand

Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxxx_0725607345.a.id_attach' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /home/xxxxx/public_html/forums/Sources/TPortal.php
Line: 1685
here is a couple of errors from the log

Code Select Expand

8: Undefined index: tp_panels
File: /home/xxxx/public_html/forums/Themes/default/languages/TPShout.english.php (tp_below sub template - eval?)
Line: 133

2: in_array() expects parameter 2 to be array, null given
File: /home/xxxx/public_html/forums/Themes/default/languages/TPShout.english.php (tp_below sub template - eval?)
Line: 123

[lurkalot]

Les, can you post this over at our support forum, see if the guys can find the cause.

[lesmond]

I have done, but I think it maybe they need an TP update, They only call me in when they have an error, which is not often.

[lurkalot]

Yeah just seen you've posted there. Sorry.

Just asked about SMF / TP versions etc in that post.

[lurkalot]

Hopefully tino put you on the right track over there.  That TP version is a tad old which is probably the reason for the problem.

[lesmond]

Updated his TP to the latest, went OK, some of the text is a bit bigger in the articles, but thats there problem now.

Thanks Mate

[lurkalot]

Updated his TP to the latest, went OK, some of the text is a bit bigger in the articles, but thats there problem now.

Thanks Mate

Hmm, shouldn't have changed the articles, unless they get resaved. I would turn the editor off in article settings , because of the different editors between those versions, and advise only to turn it on for new articles. 

Saving articles created with the old editor might (will) change the format slightly.

Articles created from scratch using the new editor should be fine.

[Bigguy]

Sounds like this has been taken care of

[lesmond]

Marked has Solved