FROM NOVEMBER 1ST TO NOVEMBER 30TH.

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.

 

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, 20232 yr by Adriano Faria

 

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!

 

Info sent through PM

thank you!

Your board is fixed. 👍

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

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.