MadMaxMangos

Hi, I am using a pages database to store member applications in my gaming clan. We log Epic and Steam IDs in a Text type field. Is there anyway of making this field searchable on the database frontend on the website? Right now if a steam 64ID is stored in the field there is no way of easily searching the database for that ID.

I have a cron setup via virtualmin on 3 sites, 2 are fine but one site has issues, my gaming site that is setup as far as i can tell exactly the same seems to have problems consistently running the maintenance task. I have had this problem on and off for a few months and cannot find a single thing wrong. I have removed and re-setup the cron multiple times, checked permissions on folders and files compared to the working sites, they are all the same. Hoping someone at invision will be able to take a look for me, I can see the systems cron log is working and that it shows, i'd share it here but since its public i'll wait until I can share logs etc securely 🙂

I fixed it, it was InnoDB strict mode! Also can you edit my initial post to remove the field prefix and my IP from it as i cannot.

Luckily we host own server. Disable strict mode has fixed the issue 🙂 I noticed my IP in SQL post above so will have to see about getting that removed.

Hi, I moved the site to a new Virtualmin server yesterday and all appears to be working, except users cannot update their profiles and no new users can register. Yesterdays topic I made covers what query we ran to move to InnoDB https://invisioncommunity.com/forums/topic/471639-easiest-way-to-switch-all-tables-to-innodb/ I may need one of the team to login and see if they can fix this. System log shows that the site cannot insert or update member information. INSERT INTO `WePhAz7c_core_members` ( `member_group_id`, `mgroup_others`, `joined`, `ip_address`, `timezone`, `allow_admin_mails`, `pp_photo_type`, `member_posts`, `last_visit`, `pp_main_photo`, `pp_thumb_photo`, `failed_logins`, `mfa_details`, `pp_reputation_points`, `signature`, `members_bitoptions`, `auto_track`, `name`, `members_seo_name`, `email`, `members_pass_hash`, `members_pass_salt`, `language`, `pp_setting_count_comments`, `completed`, `members_bitoptions2` ) VALUES ( 3, '', 1673970016, 'redacted', 'UTC', true, '', 0, 1673970016, NULL, NULL, NULL, NULL, 0, '', 65536, '{"content":0,"comments":0,"method":"immediate"}', 'MadMaxtest', 'madmaxtest', 'removed', 'removed', NULL, 1, '0', true, 16777216 ) IPS\Db\Exception: Field 'twoStep_activation' doesn't have a default value (1364) #0 /home/getmango/public_html/system/Db/Db.php(941): IPS\_Db->preparedQuery() #1 /home/getmango/public_html/system/Patterns/ActiveRecord.php(487): IPS\_Db->insert() #2 /home/getmango/public_html/system/Member/Member.php(428): IPS\Patterns\_ActiveRecord->save() #3 /home/getmango/public_html/applications/core/modules/front/system/register.php(566): IPS\_Member->save() #4 /home/getmango/public_html/applications/core/modules/front/system/register.php(242): IPS\core\modules\front\system\_register::_createMember() #5 /home/getmango/public_html/applications/core/modules/front/system/register.php(176): IPS\core\modules\front\system\_register->_registrationForm() #6 /home/getmango/public_html/system/Helpers/Wizard/Wizard.php(181): IPS\core\modules\front\system\_register->IPS\core\modules\front\system\{closure}() #7 /home/getmango/public_html/applications/core/modules/front/system/register.php(183): IPS\Helpers\_Wizard->__toString() #8 /home/getmango/public_html/system/Dispatcher/Controller.php(118): IPS\core\modules\front\system\_register->manage() #9 /home/getmango/public_html/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #10 /home/getmango/public_html/index.php(13): IPS\_Dispatcher->run() #11 {main} Setting the field to 0 appears to allow registration but I am unsure if this is the correct fix. @Matt maybe you might know or be able to get someone to check?

This worked perfectly for me and admincp now showing no issues, thanks! I'd mark your post as the solution but I dont seem to have the option to, maybe a mod/admin can do that when they see this.

Edit: I used this script SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME,' ENGINE=InnoDB;') FROM Information_schema.TABLES WHERE TABLE_SCHEMA = 'DBNAME' AND ENGINE = 'MyISAM' AND TABLE_TYPE = 'BASE TABLE' Which then generated a list of commands and tables I just ran the output as a new query and all tables show InnoDB. However, the admincp still says I have MyISAM tables🤔

Is there a script or quick way to switch all the DB tables to InnoDB ?

Also seeing this after moving the website from cpanel to virtualmin. In my case opening the admin login page immediately told me a database table core_theme_settings_fields relating to was missing and somehow throwing this error exact message in the php error logs! So something to note as an indirect cause of that error message I guess. I've put the error log message below (that is now resolved), in case line 205 is another bug that needs fixing (or not). [14-Jan-2023 22:34:32 UTC] PHP Fatal error: Uncaught Error: Attempt to assign property "timezone" on null in /home/markstreeton/public_html/system/Member/Member.php:205 Stack trace: #0 /home/markstreeton/public_html/system/Log/Log.php(107): IPS\_Member::loggedIn() #1 /home/markstreeton/public_html/init.php(1034): IPS\_Log::log() #2 [internal function]: IPS\IPS::exceptionHandler() #3 {main} thrown in /home/markstreeton/public_html/system/Member/Member.php on line 205

Interestingly, grabbing the latest GameQ off the above github and copying that over the one that ships with the application has fixed a lot of my issues. https://github.com/Austinb/GameQ/releases The files in that under the GameQ folder overwrite the folder in applications/gflcore/interface/GameQ

@devu4 Also getting this error when adding my Mordhau server "LGSL PROBLEM: INVALID TYPE 'mordhau' FOR 198.244.207.53, 7777, 27777, 0"

Thanks, battlemetrics had the same issue but they added support for EGS at some point for RS2 🙂

This still needs detection for Epic games users. I have a rising storm 2 server and it only lists steam players in the player count. No epic users are counted even though the server is full. Any idea why this might be?

The snow flake settings is not working on my site 😞 I had to use a plugin for now. Let us know if this is fixed.

Agree, a mass email sent out advising all customers of the current change and update of things should be done reflecting @Matt post.

I just replied from the licensed email 🙂

I would like to remove an application, please let me know when this has been made into a support ticket as i do not want to post this to the forums. Thanks.

My users do not get a "sign out" option but admins do, any idea how i can fix this?

Hi, Currently getting "Gateway Email Mismatch" on my payment logs, what could cause this? I am still getting the donations but they don't get listed. Edit: I i change the gateway email to the primary email on the paypal account it works fine. If its set to a secondary email i get the gateway mismatch error.

Will the "New support request" button be remaining in the admin panel past Jan 1st? And will that have the same functionality past then? Have you also considered allowing users to mark forum posts as sensitive or private so only staff can see those?

Getting to many action required emails from FB as of late. Today we have entirely removed the FB login and app from their developer side at their insistence we provide a way for users to delete accounts. While i know apps exist for letting users delete their accounts, I'm not prepared to pay for what should technically be standard functionality these days. Until that gets added in the base app I will not be looking at FB again and recommending anyone stay away from that FB login headache.

Hi, Having an issue where the "sign out" option is not appearing on certain users account settings page. Have a user wanting to change their signed in discord account but there is no way I can see to do that. If i login to my own account I have the signout button but not for this one user?

My Rising Storm 2: Vietnam servers always show as only half full, even though they are nearly at full player count. Tripwire recently added the game to the Epic store and players from Epic have a Epic ID which I think its not being seen by this application at the moment. @devu4 is it possible to get support for Epic players added so they can be counted with the steam players? Battlemetrics recently added support to include players from both platforms, you can see the live playercount here : https://www.battlemetrics.com/servers/rs2vietnam/7698226 Our servers page: https://www.phantomrebels.com/servers/server/?id=1

How does one actually get their site added to this?

@devu4 Thanks for letting us know and sorry to hear you had some issues, hope all is ok now. Regarding the game "Rising Storm 2: Vietnam" they have added epic game store, so now only steam players are showing using this application currently, our servers are often full but show only half most of the time. Can you add support for EGS players?