4 Aug 2019 Edited #1

MySQL ONLY_FULL_GROUP_BY option breaks BankPipe

Ultimate subscriber
Fatal error: Uncaught Error: Call to undefined function Symfony\Polyfill\Mbstring\iconv_substr() in /home/cracffasdasdysik/public_html/bankpipe/Omnipay/symfony/polyfill-mbstring/Mbstring.php:568
Stack trace:  /home/cracysik/public_html/bankpipe/Omnipay/symfony/polyfill-mbstring/bootstrap.php(38): Symfony\Polyfill\Mbstring\Mbstring::mb_substr('contact.php', 0, 1, 'UTF-8') #1
/home/cracffasdasdysik/public_html/inc/functions.php(5770): mb_substr('contact.php', 0, 1) #2
/home/cracffasdasdysik/public_html/inc/functions.php(8897): my_substr('contact.php', 0, 1) #3
/home/cracffasdasdysik/public_html/global.php(1034): my_validate_url('contact.php', true) #4
/home/cracffasdasdysik/public_html/index.php(18): require_once('/home/cracffasdasdysik/...') Flyover 2.3 {main} thrown in
/home/cracffasdasdysik/public_html/bankpipe/Omnipay/symfony/polyfill-mbstring/Mbstring.php on line 568
  • 1
  • 2
Shade 4 Aug 2019
Looks like a faulty environment. Can you follow the instructions suggested here? https://stackoverflow.com/questions/4218...ack-public
ZIZ likes this post
ZIZ 4 Aug 2019
i did but same prblm :(
Shade 4 Aug 2019
Can you post your PHP configuration please?
ZIZ likes this post
ZIZ 4 Aug 2019 Edited
Your host does not seem to support mbstring. This may cause problems with UTF-8.

Here original PHP configuration

display_errors = Off
max_execution_time = 30
max_input_time = 60
max_input_vars = 1000
memory_limit = 32M
post_max_size = 8M
session.gc_maxlifetime = 1440
session.save_path = "/var/cpanel/php/sessions/ea-php71"
upload_max_filesize = 2M
zlib.output_compression = Off
Shade 4 Aug 2019
mbstring is indeed necessary. Ask your host to activate it.
ZIZ likes this post
ZIZ 4 Aug 2019
@Shade seems like I didn't activated mbstring for PHP 7 version. Installed it now. All good.
Shade 5 Aug 2019
Glad you sorted it quickly. Keep me up to date with eventual bugs!
ZIZ likes this post
ZIZ 5 Aug 2019 Edited
when visit usercp.php?action=purchases&env=bankpipe
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cracysik_ziz.mybb_bankpipe_payments.pid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT *, GROUP_CONCAT(bid, '|', price, '|', pid) concat FROM mybb_bankpipe_payments WHERE type NOT IN (1,0,6) AND uid = '2' GROUP BY invoice ORDER BY date DESC

Also when setup Wallets for TEMS MANAGEMENT
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'Coinbase' in 'field list'
INSERT INTO mybb_bankpipe_wallets (`Coinbase`,`uid`) VALUES ('000000000000',4072)
Shade 5 Aug 2019 Edited
Which SQL engine do you use? Also, I’d suggest to uninstall and reinstall the plugin. It is possible that during the first failed install due to mbstring missing, the db environment has been somehow corrupted.