Pay to Pin Topics

[Adriano Faria]

FROM NOVEMBER 1ST TO NOVEMBER 30TH.

[2002faq]

I am getting the following erro when trying to run the Pay to Pin task. inision also lists the task as "locked"

SELECT * FROM `paytopintopics_topics`  LEFT JOIN `forums_topics` ON paytopintopics_topics.ptpt_topic_id=forums_topics.tid WHERE pinned=1 AND ptpt_status='pinned' AND ptpt_limit<1673917196 ORDER BY tid DESC LIMIT 25
IPS\Db\Exception: Column 'ptpt_status' in where clause is ambiguous (1052)
#0 /var/www/html/107601/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*p322958::p322...', Array, true)
#1 /var/www/html/107601/system/Db/Select.php(582): IPS\Db\_Select->runQuery()
#2 /var/www/sitefiles/p322958/applications/paytopintopics/tasks/pinRequest.php(42): IPS\Db\_Select->count()
#3 /var/www/html/107601/system/Task/Task.php(375): IPS\paytopintopics\tasks\_pinRequest->IPS\paytopintopics\tasks\{closure}()
#4 /var/www/sitefiles/p322958/applications/paytopintopics/tasks/pinRequest.php(66): IPS\_Task->runUntilTimeout(Object(Closure))
#5 /var/www/html/107601/system/Task/Task.php(274): IPS\paytopintopics\tasks\_pinRequest->execute()
#6 /var/www/html/107601/applications/core/modules/admin/settings/advanced.php(751): IPS\_Task->run()
#7 /var/www/html/107601/system/Dispatcher/Controller.php(107): IPS\core\modules\admin\settings\_advanced->runTask()
#8 /var/www/html/107601/applications/core/modules/admin/settings/advanced.php(38): IPS\Dispatcher\_Controller->execute()
#9 /var/www/html/107601/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\settings\_advanced->execute()
#10 /var/www/html/107601/admin/index.php(13): IPS\_Dispatcher->run()
#11 {main}

Thanks for the help,

Steve K.

[Adriano Faria]

8 hours ago, misfit76 said:

I am getting the following erro when trying to run the Pay to Pin task. inision also lists the task as "locked"

SELECT * FROM `paytopintopics_topics`  LEFT JOIN `forums_topics` ON paytopintopics_topics.ptpt_topic_id=forums_topics.tid WHERE pinned=1 AND ptpt_status='pinned' AND ptpt_limit<1673917196 ORDER BY tid DESC LIMIT 25
IPS\Db\Exception: Column 'ptpt_status' in where clause is ambiguous (1052)
#0 /var/www/html/107601/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*p322958::p322...', Array, true)
#1 /var/www/html/107601/system/Db/Select.php(582): IPS\Db\_Select->runQuery()
#2 /var/www/sitefiles/p322958/applications/paytopintopics/tasks/pinRequest.php(42): IPS\Db\_Select->count()
#3 /var/www/html/107601/system/Task/Task.php(375): IPS\paytopintopics\tasks\_pinRequest->IPS\paytopintopics\tasks\{closure}()
#4 /var/www/sitefiles/p322958/applications/paytopintopics/tasks/pinRequest.php(66): IPS\_Task->runUntilTimeout(Object(Closure))
#5 /var/www/html/107601/system/Task/Task.php(274): IPS\paytopintopics\tasks\_pinRequest->execute()
#6 /var/www/html/107601/applications/core/modules/admin/settings/advanced.php(751): IPS\_Task->run()
#7 /var/www/html/107601/system/Dispatcher/Controller.php(107): IPS\core\modules\admin\settings\_advanced->runTask()
#8 /var/www/html/107601/applications/core/modules/admin/settings/advanced.php(38): IPS\Dispatcher\_Controller->execute()
#9 /var/www/html/107601/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\settings\_advanced->execute()
#10 /var/www/html/107601/admin/index.php(13): IPS\_Dispatcher->run()
#11 {main}

Thanks for the help,

Steve K.

It seems you still have the columns in topics table. Send a message with URL and ACP credentials so I can fix it.

First check if you still have the old plugin installed. Uninstall it if so.

Edited January 17, 2023 by Adriano Faria

[2002faq]

14 hours ago, Adriano Faria said:

It seems you still have the columns in topics table. Send a message with URL and ACP credentials so I can fix it.

First check if you still have the old plugin installed. Uninstall it if so.

Info sent through PM

thank you!

[Adriano Faria]

12 hours ago, misfit76 said:

Info sent through PM

thank you!

Your board is fixed. 👍

[Mutterz]

@Adriano Faria would love to use this but a quick question would this work for clubs forums as well?

[Adriano Faria]

Thank you so much for being a client!

The Invision Community Marketplace is closing on October 30, 2023, so I am moving all of my files over to my personal site www.sosinvision.com.br.

You will find information on my website www.sosinvision.com.br:

• You can redeem the marketplace purchase keys provided by IPS in order to keep getting updates and support for the applications/plugins you purchased.
• You can purchase files directly on my marketplace.
• You can get support for your purchased applications/plugins directly on their new support topics.
• You can request a custom application/plugin or service.

Bookmark https://www.sosinvision.com.br/ and the new Marketplace Directory www.Invisioneer.org.