News: April 7th, 2019, The Tinyportal team is pleased to announce the release of ~~ TinyPortal 1.6.3! GET IT NOW!!!

Login  |  Register
HTML5 Icon HTML5 Icon
TP on Social Media
Welcome, Guest. Please login or register.
Did you miss your activation email?

July 23, 2019, 12:06:24 PM

Login with username, password and session length

Recent

Members
Stats
  • Total Posts: 188522
  • Total Topics: 20737
  • Online Today: 43
  • Online Ever: 629
  • (November 08, 2018, 01:36:54 PM)
Users Online
Users: 0
Guests: 27
Total: 27

Author Topic: Database error  (Read 328 times)

0 Members and 1 Guest are viewing this topic.

Offline Lesmond

  • Do what you have to!
  • Administrator
  • *
  • Posts: 3121
    • Buildz Hosting
Database error
« on: April 15, 2019, 11:47:29 AM »
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. :dontknow


Code: [Select]
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]
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
« Last Edit: April 15, 2019, 01:44:32 PM by Lesmond »
Please don't PM me for support without an invitation.


Offline lurkalot

  • Administrator
  • *
  • Posts: 6075
    • Camera Craniums
Re: Database error
« Reply #1 on: April 15, 2019, 11:51:16 AM »
Les. Versions SMF and TP ? Other mods installed etc? just in case.

Offline Lesmond

  • Do what you have to!
  • Administrator
  • *
  • Posts: 3121
    • Buildz Hosting
Re: Database error
« Reply #2 on: April 15, 2019, 12:06:36 PM »
SMF 2.0.15
Please don't PM me for support without an invitation.


Offline tino

  • Developer
  • *
  • Posts: 1574
Re: Database error
« Reply #3 on: April 15, 2019, 12:13:33 PM »
This was fixed in TinyPortal 1.6.x

Offline Lesmond

  • Do what you have to!
  • Administrator
  • *
  • Posts: 3121
    • Buildz Hosting
Re: Database error
« Reply #4 on: April 15, 2019, 12:21:46 PM »
This was fixed in TinyPortal 1.6.x
Maybe it was, but strange it just appeared now!
Please don't PM me for support without an invitation.


Offline lurkalot

  • Administrator
  • *
  • Posts: 6075
    • Camera Craniums
Re: Database error
« Reply #5 on: April 15, 2019, 12:24:47 PM »
Think a update of TP is well over due there Les. It's about eight versions behind now.

Like tino said this was fixed in 1.6.x so hopefully that's the answer to the problem.

Let us know how it goes, they should notice some big changes from that version to now.

Offline @rjen

  • Support Team
  • *
  • Posts: 1695
    • FJR-club Nederland
Re: Database error
« Reply #6 on: April 15, 2019, 12:33:10 PM »
I believe the group_by errors starts appearing with a certain MySQL version and strict mode... could it be the host has upgrade the MySQL version on the server in the meantime?

(they may have forgotten to mention it to the users...)

that might explain why the errors did not show up before...
Running TP1.6.3 on SMF2.0 at: www.fjr-club.nl

Testing TP on SMF2.0
Testing TP on SMF2.1 RC2
Want to check what php version I am testing on? See: PHP Info

Offline Lesmond

  • Do what you have to!
  • Administrator
  • *
  • Posts: 3121
    • Buildz Hosting
Re: Database error
« Reply #7 on: April 15, 2019, 01:19:09 PM »
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 Guys
Please don't PM me for support without an invitation.


Offline lurkalot

  • Administrator
  • *
  • Posts: 6075
    • Camera Craniums
Re: Database error
« Reply #8 on: April 15, 2019, 01:53:19 PM »
 :hmm: Strange, not sure why that is Les.  The text shouldn't be any different unless someone Re-saves the articles with the new editor active. I haven't noticed any difference in any of mine.