SpeedyCat

When can we expect the updated version? 

Perfect, I am excited for the new release. Thanks for your work.

Great, thank you. So both errors includes the queue error and the topics throphy issues?

Any updates?

There is also another issue:

Quote

Maintenance tasks

The following tasks appear to be locking frequently: queue.
Please run them manually. If you require assistance with any errors shown please contact technical support.

I have asked for help in the IPS Support area and they answered:

Quote

Hello,

Unfortunately it seems to be an issue with the trophies application you have on there. I would highly suggest contacting the author of that application for support there, as whilst its disabled, it still seems to be causing issues. Alternatively, it may be worth uninstalling it completely if you are not using it.

Kind Regards,
Marc Stridgen

So the script causing issues even when it is disabled. So even if you get access to the ACP it won't fix the core issues that the script has.

So I would appreciate it, if you try to update this application for the new 4.18.2 version. 

To make things clear: there are some conditions which works brilliant. Like user is administrator, moderator, user has avatar and some more. It does not work for downloads, topics, posts.

I just created a trophy with the conditions: user has to create 50 topics.

After saving every user receives a notification- you have unlocked a trophy - blablablatrophyname.

So even if I set the conditions everything will unlock. So overall I am not very impressed but maybe I am doing something wrong. Using the last IPB version. Thanks

best regards

I will. Thanks for the fast and great support. Did not know that such a good support still exists. No words! Thanks mate!

Will try and edit this comment

Does not work:

Shows this in ACP:

UPDATE `tutorials_cats` tutorials_cats  SET `c_order`=1,`c_id`=9,`c_name_seo`='test',`c_parent`=0,`c_icon`=NULL,`c_artorder`='title',`c_artsort`='DESC',`c_rating`=false,`c_sharing`=false,`c_log`=false,`c_log_days`=-1,`c_log_author`=NULL,`c_article_moderation`=false,`c_desc_required`=false,`c_allow_comments`=false,`c_comments_moderation`=false,`c_tags_disabled`=false,`c_tags_noprefixes`=false,`c_def_title`=NULL,`c_def_desc`='',`c_forum_on`=false,`c_forum`=0,`c_prefix`=NULL,`c_suffix`=NULL,`c_isopen`=true,`c_ispinned`=NULL,`c_delete_topic`=true,`c_forum_support_on`=false,`c_forum_support`=0 WHERE c_id=9 
IPS\Db\Exception: Column 'c_log_author' cannot be null (1048)
#0 /var/www/html/system/Db/Db.php(991): IPS\_Db->preparedQuery('/*IPS\\Node\\_Mod...', Array)
#1 /var/www/html/system/Patterns/ActiveRecord.php(491): IPS\_Db->update('`tutorials_cats...', '`c_order`=?,`c_...', 'WHERE c_id=?')
#2 /var/www/html/system/Node/Model.php(2014): IPS\Patterns\_ActiveRecord->save()
#3 /var/www/html/system/Node/Model.php(2691): IPS\Node\_Model->save()
#4 /var/www/html/applications/tutorials/sources/Category/Category.php(468): IPS\Node\_Model->saveForm(Array)
#5 /var/www/html/system/Node/Controller.php(383): IPS\tutorials\_Category->saveForm(Array)
#6 /var/www/html/applications/tutorials/modules/admin/tutorials/categories.php(36): IPS\Node\_Controller->form()
#7 [internal function]: IPS\tutorials\modules\admin\tutorials\_categories->form()
#8 /var/www/html/system/Dispatcher/Controller.php(85): call_user_func(Array)
#9 /var/www/html/system/Node/Controller.php(63): IPS\Dispatcher\_Controller->execute()
#10 /var/www/html/applications/tutorials/modules/admin/tutorials/categories.php(31): IPS\Node\_Controller->execute()
#11 /var/www/html/system/Dispatcher/Dispatcher.php(129): IPS\tutorials\modules\admin\tutorials\_categories->execute()
#12 /var/www/html/acp/index.php(14): IPS\_Dispatcher->run()
#13 {main}

It should redirect me to the permission page after creating a category. But it does not. So I have to set them manually and then the category appears. I also can submit tutorials as I already said, but not without receiving warnings over warnings.

Thank you very much!

I think it has nothing to do with PHP7. Everything worked fine until I have created a forum named "HTML". Now everytime I want to create a tutorial category it shows me this error but the category is created and then I have to manually add permissions. The same happens when I want to submit a tutorial. It shows me an error message again but the tutorial was created. 

How is it possible that an "HTML" as a category name, can destroy the whole application (for me). Maybe it was just random but as I already said - it was running great before.

I can offer you access to my forum if you want to take a look into it. But all you will see are just the warnings that I have already added in the attachment in my previous post.

When I want to submit a tutorial it gives me this error:

SELECT COUNT(DISTINCT(follow_member_id)) FROM( ( SELECT core_follow.* FROM `core_follow` WHERE follow_app='tutorials' AND follow_area='category' AND follow_rel_id=6 AND ( follow_notify_freq IN('immediate') ) AND follow_added<1486398243 ) UNION ( SELECT core_follow.* FROM `core_follow` WHERE follow_app='core' AND follow_area='member' AND follow_rel_id=1 AND ( follow_notify_freq IN('immediate') ) AND follow_added<1486398243 )) derivedTable  GROUP BY follow_member_id ORDER BY follow_added
IPS\Db\Exception: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'derivedTable.follow_added' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (1055)
#0 /var/www/html/system/Db/Select.php(356): IPS\_Db->preparedQuery('/*IPS\\tutorials...', Array, true)
#1 /var/www/html/system/Db/Select.php(418): IPS\Db\_Select->runQuery()
#2 /var/www/html/system/Db/Select.php(339): IPS\Db\_Select->rewind()
#3 /var/www/html/applications/tutorials/sources/Article/Article.php(837): IPS\Db\_Select->first()
#4 /var/www/html/system/Content/Content.php(1454): IPS\tutorials\_Article->notificationRecipients(NULL, NULL, true)
#5 /var/www/html/system/Content/Item.php(422): IPS\_Content->sendNotifications()
#6 /var/www/html/applications/tutorials/sources/Article/Article.php(1039): IPS\Content\_Item::createFromForm(Array, Object(IPS\tutorials\Category), true)
#7 /var/www/html/system/Content/Item.php(87): IPS\tutorials\_Article::createFromForm(Array, Object(IPS\tutorials\Category))
#8 /var/www/html/applications/tutorials/modules/front/tutorials/submit.php(133): IPS\Content\_Item::create(Object(IPS\tutorials\Category))
#9 [internal function]: IPS\tutorials\modules\front\tutorials\_submit->submit()
#10 /var/www/html/system/Dispatcher/Controller.php(85): call_user_func(Array)
#11 /var/www/html/applications/tutorials/modules/front/tutorials/submit.php(38): IPS\Dispatcher\_Controller->execute()
#12 /var/www/html/system/Dispatcher/Dispatcher.php(129): IPS\tutorials\modules\front\tutorials\_submit->execute()
#13 /var/www/html/index.php(13): IPS\_Dispatcher->run()
#14 {main}

After creating a tutorial categorie named "HTML" the whole tutorial system is down for me now. Even after trying to uninstall and reinstall it: nothing works.

I can't create categories without receiving this message.

IPS Version: v4.1.18.1

VPS with Ubuntu 16.04 - PHP 7, MYSQL 5.6+ (recommended they said)