1. Server error
   Code:
   
   XF\Db\InvalidQueryException: Template public:approval_item_user error: MySQL statement prepare error [1176]: Key 'user_id_log_date' doesn't exist in table 'xf_ip' src/XF/Db/AbstractStatement.php:230
   In table xf_ip, the column user_id_log_date exists, but it is set as INT(11) with a default value of null. Can someone please confirm how this column should be configured?
2. The...

Requirements:
XF 2.2+

Description:
Ensure important conversations are never lost – stick them!

With this add-on, users with permission can pin their crucial conversations to ensure they're always within reach.
Keep important discussions easily accessible, reducing the risk of overlooking or forgetting them.

Features:

• ...

Click to expand...

Нажмите, чтобы раскрыть...

• PHP 7+ (with respecting modern development standards)
• MySQL
• Little bit front-end Javascript, HTML, CSS/LESS.
• Git basics
• Mind mapping

• Custom add-on development or improving the existing add-ons (if that possible)
• Database schema design, query optimization (slightly)