AlexJ

How can i move sub categories to top level in menu? Ex: I would like to move Leaderboard to another top level.  How to? 

@Michael.J - Awaiting for more payment options i.e. Stripe and others with subscription option. Awaiting since last 1-2 years 😞 

Can you please add those at your earliest convenience? 

11 hours ago, bfarber said:

Do you have any custom applications or plugins?

Yes. I have custom applications and plugins. I had even tried disabling plugin and applications and it didn't help. So I thought they are not causing the issue, I could be wrong. 

11 hours ago, bfarber said:

What email handling are you using? Are there a lot of followers to the topic or forum that is being posted in? Does the author who is posting have many followers?

I am using amazon ses. 4$/month - much better then maintaining my postfix. In majority topics - we have like 5 followers or some just none. In those topics also, it takes time.

11 hours ago, bfarber said:

What are you using for search?

Nothing special, just MySQL stock set up. Anything special should I try? Back in the days, you had suggested to use combo of memory + MyISAM tables and now most of them are converted to InnoDB now.  Anything, I should use? 

Thanks. 

Anyone facing slowness while submitting post? I constantly face that issue on our site. Anything that can be done to resolve it? I have plenty of CPU and RAM available. Here is my mysqltuner results. Using MySQL 5.7. php 7.4.x and Apache. 

-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 6d 7h 4m 43s (38M q [71.579 qps], 954K conn, TX: 485G, RX: 37G)
[--] Reads / Writes: 51% / 49%
[--] Binary logging is disabled
[--] Physical Memory     : 62.7G
[--] Max MySQL memory    : 22.0G
[--] Other process memory: 0B
[--] Total buffers: 14.6G global + 75.2M per thread (100 max threads)
[--] P_S Max memory usage: 72B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 16.7G (26.61% of installed RAM)
[OK] Maximum possible memory usage: 22.0G (35.04% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (319/38M)
[OK] Highest usage of available connections: 28% (28/100)
[OK] Aborted connections: 0.00%  (22/954913)
[!!] Query cache may be disabled by default due to mutex contention.
[!!] Query cache efficiency: 0.1% (20K cached / 19M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 4% (103K temp sorts / 2M sorts)
[!!] Joins performed without indexes: 305485
[OK] Temporary tables created on disk: 16% (65K on disk / 406K total)
[OK] Thread cache hit rate: 99% (28 created / 954K connections)
[!!] Table cache hit rate: 0% (2K open / 246K opened)
[OK] table_definition_cache(3000) is upper than number of tables(1308)
[OK] Open file limit used: 5% (263/5K)
[OK] Table locks acquired immediately: 99% (15M immediate / 15M locks)

-------- Performance schema ------------------------------------------------------------------------
[--] Memory used by P_S: 72B
[--] Sys schema is installed.

-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is disabled.

-------- MyISAM Metrics ----------------------------------------------------------------------------
[!!] Key buffer used: 26.2% (1B used / 6B cache)
[OK] Key buffer size / total MyISAM indexes: 6.0G/1.9G
[OK] Read Key buffer hit rate: 99.4% (2B cached / 12M reads)
[!!] Write Key buffer hit rate: 3.1% (208M cached / 6M writes)

-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[--] InnoDB Thread Concurrency: 0
[OK] InnoDB File per table is activated
[OK] InnoDB buffer pool / data size: 8.0G/4.6G
[OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 1.0G * 2/8.0G should be equal to 25%
[OK] InnoDB buffer pool instances: 8
[--] Number of InnoDB Buffer Pool Chunk : 64 for 8 Buffer Pool Instance(s)
[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
[OK] InnoDB Read buffer efficiency: 100.00% (11252173170 hits/ 11252300777 total)
[OK] InnoDB Write log efficiency: 94.19% (48990375 hits/ 52010341 total)
[OK] InnoDB log waits: 0.00% (0 waits / 3019966 writes)

-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is disabled.

-------- TokuDB Metrics ----------------------------------------------------------------------------
[--] TokuDB is disabled.

-------- XtraDB Metrics ----------------------------------------------------------------------------
[--] XtraDB is disabled.

-------- Galera Metrics ----------------------------------------------------------------------------
[--] Galera is disabled.

-------- Replication Metrics -----------------------------------------------------------------------
[--] Galera Synchronous replication: NO
[--] No replication slave(s) for this server.
[--] Binlog format: ROW
[--] XA support enabled: ON
[--] Semi synchronous replication Master: Not Activated
[--] Semi synchronous replication Slave: Not Activated
[--] This is a standalone server

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Control warning line(s) into /var/log/mysql/error.log file
    Control error line(s) into /var/log/mysql/error.log file
    We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found.
             See https://dev.mysql.com/doc/internals/en/join-buffer-size.html
             (specially the conclusions at the bottom of the page).
    Increase table_open_cache gradually to avoid file descriptor limits
    Read this before increasing table_open_cache over 64: https://bit.ly/2Fulv7r
    Read this before increasing for MariaDB https://mariadb.com/kb/en/library/optimizing-table_open_cache/
    This is MyISAM only table_cache scalability problem, InnoDB not affected.
    See more details here: https://bugs.mysql.com/bug.php?id=49177
    This bug already fixed in MySQL 5.7.9 and newer MySQL versions.
    Beware that open_files_limit (5000) variable
    should be greater than table_open_cache (2445)
Variables to adjust:
    query_cache_size (=0)
    query_cache_type (=0)
    query_cache_limit (> 2M, or use smaller result sets)
    join_buffer_size (> 4.0M, or always use indexes with JOINs)
    table_open_cache (> 2445)

22 minutes ago, Adriano Faria said:

I just renamed the table there. Try it.

Just tested and I can read PMs on your board.

Thank you bud for quick fix!

1 hour ago, Adriano Faria said:

Send URL and a user with ACP access via private message, pleaes.

Nevermind. I'll submit a fix.

Thanks. I send you PM. Can you fix on my site or send me fix if possible? Thank you!

2 minutes ago, Adriano Faria said:

Are you using latest version? Upgrade changes the name of table to this one.

Yes. I had to disable plugin because I can't use PM's with it enabled. 

SELECT * FROM `ipb_convertmessagestotopics_data` AS `convertmessagestotopics_data` WHERE message_id=132707
Table 'xxx.ipb_convertmessagestotopics_data' doesn't exist

#0 /home/xxxx/public_html/system/Db/Select.php(383): IPS\_Db->preparedQuery()
#1 /home/xxxx/public_html/system/Db/Select.php(441): IPS\Db\_Select->runQuery()
#2 /home/xxxx/public_html/system/Db/Select.php(365): IPS\Db\_Select->rewind()
#3 /home/xxxx/public_html/init.php(893) : eval()'d code(18): IPS\Db\_Select->first()
#4 /home/xxxx/public_html/uploads/template_26_42c9757c3d7c0f3a9bc1d72bde21c644_messaging.php(192): IPS\core\Messenger\hook889->msgIsConverted()
#5 /home/xxxx/public_html/system/Theme/SandboxedTemplate.php(61): IPS\Theme\Cache\class_core_front_messaging->conversation()
#6 /home/xxxx/public_html/uploads/template_26_42c9757c3d7c0f3a9bc1d72bde21c644_messaging.php(1936): IPS\Theme\_SandboxedTemplate->__call()
#7 /home/xxxx/public_html/system/Theme/SandboxedTemplate.php(61): IPS\Theme\Cache\class_core_front_messaging->template()
#8 /home/xxxx/public_html/applications/core/modules/front/messaging/messenger.php(456): IPS\Theme\_SandboxedTemplate->__call()
#9 /home/xxxx/public_html/system/Dispatcher/Controller.php(101): IPS\core\modules\front\messaging\_messenger->manage()
#10 /home/xxxx/public_html/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute()
#11 /home/xxxx/public_html/applications/core/modules/front/messaging/messenger.php(71): IPS\Content\_Controller->execute()
#12 /home/xxxx/public_html/system/Dispatcher/Dispatcher.php(152): IPS\core\modules\front\messaging\_messenger->execute()
#13 /home/xxxx/public_html/index.php(13): IPS\_Dispatcher->run()
#14 {main}

5 minutes ago, Adriano Faria said:

Can you provide the content of the log error?

When I try to open the PM  - i get that error. When you mention content, what do you mean? Like error or something?

@Adriano Faria Getting error - 

[[Template core/front/messaging/conversation is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

Just now, Adriano Faria said:

One last question: do you have departments and aren’t selecting one or you doesn’t even have departments?

I am not selecting one and I do have 1 department from commerce. 

2 minutes ago, Adriano Faria said:

Do you have Commerce installed? This column shouldn’t be NULL, if you don’t have it.

Run this query in your SQL Toolbox:

ALTER TABLE ipb_cjcontact_departments MODIFY COLUMN  departments_support_department INT(10) NOT NULL DEFAULT 0;

I’ll have to release a new version to fix it but try the above first. 

Yes, I have commerce installed. I run the query and I still get same error when I try to save the contact us dept.

@Adriano Faria - When I try to edit department, I am getting below error:

UPDATE `ipb_cjcontact_departments` cjcontact_departments  SET `departments_support_department`=NULL,`departments_forums`=236,`departments_member`=9099 WHERE departments_id=1 
IPS\Db\Exception: Column 'departments_support_department' cannot be null (1048)
#0 /home/xxxx/public_html/system/Db/Db.php(1161): IPS\_Db->preparedQuery()
#1 /home/xxxx/public_html/system/Patterns/ActiveRecord.php(520): IPS\_Db->update()
#2 /home/xxxx/public_html/system/Node/Model.php(2389): IPS\Patterns\_ActiveRecord->save()
#3 /home/xxxx/public_html/init.php(893) : eval()'d code(257): IPS\Node\_Model->save()
#4 /home/xxxx/public_html/system/Node/Model.php(3314): IPS\Node\radtags_hook_C_NodeModel->save()
#5 /home/xxxx/public_html/init.php(893) : eval()'d code(184): IPS\Node\_Model->saveForm()
#6 /home/xxxx/public_html/applications/cjcontact/sources/Departments/Departments.php(307): IPS\Node\radtags_hook_C_NodeModel->saveForm()
#7 /home/xxxx/public_html/system/Node/Controller.php(413): IPS\cjcontact\_Departments->saveForm()
#8 /home/xxxx/public_html/system/Dispatcher/Controller.php(90): IPS\Node\_Controller->form()
#9 /home/xxxx/public_html/system/Node/Controller.php(62): IPS\Dispatcher\_Controller->execute()
#10 /home/xxxx/public_html/applications/cjcontact/modules/admin/departments/departments.php(20): IPS\Node\_Controller->execute()
#11 /home/xxxx/public_html/system/Dispatcher/Dispatcher.php(152): IPS\cjcontact\modules\admin\departments\_departments->execute()
#12 /home/xxxx/public_html/admin/index.php(14): IPS\_Dispatcher->run()
#13 {main}

Also when I migrated, I am seeing all prefixes goes to advanced option:

Can we have basic configuration option available? 

Hello,

I see Prefix is disabled when I try to edit it.

@Paul E. - Thanks for suggestion but don't need 2 addons doing something similar. Plus, I have seen Makoto work since years. So I am going to stick with him. 

@Makoto - Possible to add option so that if IP is proxy it blocks user or registering the user? 

Sometimes DDoS can do that. Just make sure you are not getting random DDoS. Check connection usage. 

@Daniel F Can you please help with above request? Thank you.

On 11/17/2020 at 1:55 AM, Daniel F said:

Check your purchases page where you should see the already existing renewals invoice. 
https://invisioncommunity.com/clients/purchases/

their is no option to renew 😞

On 11/15/2020 at 12:48 PM, devu4 said:

I can see you in list of downloaders on 03/25/2020. Did you forget to renew since it's been more than 6 months. Otherwise you will have to check with the IPS support team since I can't see anything else or give you access to the download.

I don't see renewal option. 😞 In some addons, I see it but for this one, I don't. So i am not sure how to renew. Can you please help? 

3 hours ago, Ehren said:

For any of my other customers with the same issue as Alex, add this to custom.css and I'll patch it in a future theme update.

The awardsHr code helps with dark themes, so feel free to leave that out if you like.

[data-role="awards"] > .ipsDataItem{
	display: block;
}

hr.awardsHr {
	border-color: rgba(var(--theme-text_light),.3);
}

 

@Ehren Need fix for main page too -  it breaks more after the custom css addition.

@InvisionHQ How can fix layout for @Ehren custom theme? 

@devu4 - Why do I need to purchase the application again when I had it purchased? Some error. Can you please check? Thanks

On 10/29/2020 at 12:40 PM, Maxtor said:

im getting this error while trying to edit a prefix:

Purchase another application by @Makato and migrate your prefixes and such.