Jump to content

Pay to Pin Topics


Recommended Posts

  • 2 months later...

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.

Link to comment
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 by Adriano Faria
Link to comment
  • 2 weeks later...
  • 7 months later...

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:

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

Link to comment
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...