SMF Development > Bug Reports

SMF 2.1 RC3 - ExportProfileData error

(1/3) > >>

Massl:
I cannot export my profile data, maybe it's another error due to the conversion from MyBB  ;D


--- Code: ---Type of error: Database
Error message:
Errore del Database: 'user_smf.pm2.from_name' isn't in GROUP BY
File: /home/public_html/Sources/News.php
Line: 2593
URL of page causing the error: https://site.com/cron.php
Backtrace information
#0: smf_db_error()
Called from /home/public_html/Sources/Subs-Db-mysql.php on line 489
#1: smf_db_query()
Called from /home/public_html/Sources/News.php on line 2593
#2: getXmlPMs()
Called from /home/public_html/Sources/tasks/ExportProfileData.php on line 236
#3: exportXml()
Called from /home/public_html/Sources/tasks/ExportProfileData.php on line 459
#4: exportHtml()
Called from /home/public_html/Sources/tasks/ExportProfileData.php on line 117
#5: execute()
Called from /home/public_html/cron.php on line 233
#6: perform_task()
Called from /home/public_html/cron.php on line 127
--- End code ---

shawnb61:
You're on mariadb, correct?

Massl:
Yes, MariaDB 10.4.10 and PHP 7.3.21

shawnb61:
At first glance, this seems like another instance where we were bit by this limitation in MariaDB:
https://jira.mariadb.org/browse/MDEV-11588

We have had others:
https://github.com/SimpleMachines/SMF2.1/issues/6094

Issue logged: https://github.com/SimpleMachines/SMF2.1/issues/6309

Moving this to the Bug Reports board.

shawnb61:
Massl - feel free to report issues directly on GitHub!

A GitHub overview & some instructions for logging defects is here:
https://www.simplemachines.org/community/index.php?topic=570115.0

Not required, but just thought you should know.

Navigation

[0] Message Index

[#] Next page

Go to full version