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 🙂

Just now, Matt said:

twoStep_activation isn't a standard column, so I'm unsure what the default value is on that.

It might be easily fixed by editing core_members in PhpMyAdmin or similar to ensure the table column has a default value (such as NULL if it's a VARCHAR, or 0 if it's an INT).

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.

15 minutes ago, Nathan Explosion said:

Contact your host and ask them for assistance with disabling strict mode in MySQL/MariaDB

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?

5 minutes ago, teraßyte said:

Try using this query instead (replace DBNAME as needed):

SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' ENGINE=InnoDB ROW_FORMAT=DYNAMIC;') FROM information_schema.TABLES WHERE TABLE_SCHEMA='DBNAME' AND ENGINE = 'MyISAM';

This query doesn't check the table type and also forces the tables to use the DYNAMIC row format (in case your server defaults to Compact).

 

I always use it and once I run all the queries the ACP never complains about tables still being MyISAM.

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 ?

On 5/31/2022 at 11:16 AM, Matt said:

I've raised an internal bug report for this, thanks for reporting.

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"

Just now, devu4 said:

Hi,

I will have a look at this, I currently use steam protocol to ping these servers which is probably why this is occuring.

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.

On 10/5/2021 at 8:11 AM, FZ said:

Well colour me confused, or amused, or both. 

I just got one of my IPS license renewal invoices and I see that it is for 6 months and not the ridiculous, almost 3x the price I was expecting after the last email I got from IPS. Huh? So I come here to try and find out what's going on and I see that 6 month licenses have been restored. Great! 

Question: why didn't you send out an email advising your customers of this reversal? 

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

1 minute ago, Marc Stridgen said:

I have just seen your ticket and responded. You need to respond from your licensed customer email in order for us to assist with this. Then we can certainly sort that out for you

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.

7 hours ago, Marc Stridgen said:

There is already an email sent confirming receipt of a ticket by the system. I can see your ticket relating to email templates if this is what you are referring to?

Priority support adds email support with your license. That includes same-business-day response time and software upgrades performed by us. Priority support is billed at the same rate, annually. This is currently priced at $1250 .

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

On 8/9/2020 at 2:47 PM, Rikki said:

Thanks for the feedback - it's definitely early stages. We'll be looking to improve performance as time goes on, as well as add functionality. There's only one codebase for both iOS/Android, but that is indeed (currently) separate from the main product. It's very much 'work in progress' right now 🙂 

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?