SMF 2.1 RC3 - ExportProfileData error

Started by Massl, October 19, 2020, 06:06:31 AM

Previous topic - Next topic

Massl

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

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



shawnb61

Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Massl

#2
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.
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

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.
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Massl


shawnb61

Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Massl

Surely!

Always 'smf.memf.real_name' isn't in GROUP BY also with GROUP BY pm2.id_pm, from_name

I don't understand, however, why with this change it worked for once.

shawnb61

Just confirming - so it worked properly this time?
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Massl


shawnb61

Thank you for trying that. 

Could you give this next approach a test?
https://github.com/SimpleMachines/SMF2.1/pull/6319/files

Thanks,

(Sorry, I just don't have a MariaDB environment to test with...)
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Massl

OK now there are no errors and user data to download is generated.
Thanks shawnb61  ;D

Arantor

@Shawn, what development environment do you use? It really would be worth having both a MariaDB and a real MySQL around at this point just because MariaDB is very common in a lot of hosting environments - and until MySQL 8 came out, I could have sworn MariaDB was winning the adoption wars.

Not necessarily sure I'd suggest going full bore into something like Docker but you certainly *can* go there to get Maria/MySQL/Postgres locally without too much pain.

shawnb61

Quote from: Massl on October 26, 2020, 05:46:05 PM
OK now there are no errors and user data to download is generated.
Thanks shawnb61  ;D

Good to hear!  Thank you for helping out.
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Advertisement: