Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
January 17, 20232 yr 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.
January 17, 20232 yr Author 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, 20232 yr by Adriano Faria
January 17, 20232 yr 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!
January 18, 20232 yr Author 12 hours ago, misfit76 said: Info sent through PM thank you! Your board is fixed. 👍
January 29, 20231 yr @Adriano Faria would love to use this but a quick question would this work for clubs forums as well?
September 15, 20231 yr Author 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.
