Opened 10 years ago

Closed 10 years ago

#12139 closed Bug Report - General (Invalid)

Mythweb Listings mysql error

Reported by: majorbullet@… Owned by: Rob Smith
Priority: minor Milestone: unknown
Component: Plugin - MythWeb Version: 0.27-fixes
Severity: medium Keywords:
Cc: Ticket locked: no

Description

Mythweb Listings does not display after current daily upgrade. Listing works on all Front Ends:

Error message: Fatal Error !NoTrans: SQL Error: 'mythconverg.channel.chanid' isn't in GROUP BY #1055!!

installed version: mythweb:

Installed: 2:0.27.0+fixes.20140508.9f353cc-0ubuntu0mythbuntu1

Attachments (1)

backtrace.txt​ (12.0 KB) - added by majorbullet@… 10 years ago.
backtrace

Download all attachments as: .zip

Change History (3)

Changed 10 years ago by majorbullet@…

Attachment: backtrace.txt​ added

backtrace

comment:1 Changed 10 years ago by majorbullet@…

Please close ticket. The issue was due to using the percona configuration optimization wizard for mysql. I reverted back to my previous my.conf and the error resolved.

comment:2 Changed 10 years ago by Jonatan Lindblad

Resolution: → Invalid
Status: new → closed

Closing on user's request.

Note: See TracTickets for help on using tickets.