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.