CTA Featured Threads & Portal

CTA Featured Threads & Portal [Paid] 2.17.0

No permission to buy (£40.00)
Overview FAQ Updates (36) Reviews (199) History Discussion
I get this from trying to upgrade from v 2.8;

Code: 
Server Error

mysqli_stmt::execute() [mysqli-stmt.execute]: (42S21/1060): Duplicate column name 'cta_ft_featured'

    XenForo_Application::handlePhpError()
    mysqli_stmt->execute() in Zend/Db/Statement/Mysqli.php at line 208
    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in CTA/FeaturedThreads/Install.php at line 37
    CTA_FeaturedThreads_Install::install()
    call_user_func() in XenForo/Model/AddOn.php at line 215
    XenForo_Model_AddOn->installAddOnXml() in ConvEss/Model/AddOn.php at line 24
    ConvEss_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
    XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 236
    XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 347
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /var/www/vhosts/truckmountforums.com/httpdocs/admin.php at line 13
 
Curious.
It should silently fail if the column already exists.

How many times have you upgraded since installing?
If it has happened this time it should have happened every time.
 
Brogan said:
Curious.
It should silently fail if the column already exists.

How many times have you upgraded since installing?
If it has happened this time it should have happened every time.
Click to expand...
Maybe 3x. Anyways I just tried un-installing it and re-installing, these are the errors it gave me;

Code: 
ErrorException: mysqli::query() [<a href='mysqli.query'>mysqli.query</a>]: (42000/1305): SAVEPOINT xf8fa89079cabefb30dd73dc064a3668e1 does not exist - library/XenForo/Db.php:162
Generated By: admin, 12 minutes ago
Stack Trace

#0 [internal function]: XenForo_Application::handlePhpError(2, 'mysqli::query()...', '/var/www/vhosts...', 162, Array)
#1 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/Db.php(162): mysqli->query('RELEASE SAVEPOI...')
#2 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/Db.php(83): XenForo_Db::_execQuery(Object(Zend_Db_Adapter_Mysqli), 'RELEASE SAVEPOI...')
#3 /var/www/vhosts/truckmountforums.com/httpdocs/library/CTA/FeaturedThreads/Install.php(350): XenForo_Db::commit(Object(Zend_Db_Adapter_Mysqli))
#4 [internal function]: CTA_FeaturedThreads_Install::uninstall(Array)
#5 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/DataWriter/AddOn.php(200): call_user_func(Array, Array)
#6 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/DataWriter.php(1779): XenForo_DataWriter_AddOn->_postDelete()
#7 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/ControllerAdmin/AddOn.php(122): XenForo_DataWriter->delete()
#8 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/FrontController.php(347): XenForo_ControllerAdmin_AddOn->actionDelete()
#9 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /var/www/vhosts/truckmountforums.com/httpdocs/admin.php(13): XenForo_FrontController->run()
#11 {main}

Request State

array(3) {
  ["url"] => string(62) "http://www.truckmountforums.com/admin.php?add-ons/CtaFt/delete"
  ["_GET"] => array(1) {
    ["add-ons/CtaFt/delete"] => string(0) ""
  }
  ["_POST"] => array(2) {
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}

Delete... Close
Code: 
Server Error Log
Error Info
ErrorException: mysqli::prepare() [<a href='mysqli.prepare'>mysqli.prepare</a>]: (42S02/1146): Table 'xenforo.cta_ft_featured_threads' doesn't exist - library/Zend/Db/Statement/Mysqli.php:70
Generated By: Unknown Account, 3 minutes ago
Stack Trace

#0 [internal function]: XenForo_Application::handlePhpError(2, 'mysqli::prepare...', '/var/www/vhosts...', 70, Array)
#1 /var/www/vhosts/truckmountforums.com/httpdocs/library/Zend/Db/Statement/Mysqli.php(70): mysqli->prepare('?????SELECT thr...')
#2 /var/www/vhosts/truckmountforums.com/httpdocs/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?????SELECT thr...')
#3 /var/www/vhosts/truckmountforums.com/httpdocs/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?????SELECT thr...')
#4 /var/www/vhosts/truckmountforums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?????SELECT thr...')
#5 /var/www/vhosts/truckmountforums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(791): Zend_Db_Adapter_Abstract->query('?????SELECT thr...', 1406718956)
#6 /var/www/vhosts/truckmountforums.com/httpdocs/library/CTA/FeaturedThreads/Model/Featured.php(394): Zend_Db_Adapter_Abstract->fetchCol('?????SELECT thr...', 1406718956)
#7 /var/www/vhosts/truckmountforums.com/httpdocs/library/CTA/FeaturedThreads/CronEntry/Unfeature.php(7): CTA_FeaturedThreads_Model_Featured->unfeatureExpiredThreads()
#8 [internal function]: CTA_FeaturedThreads_CronEntry_Unfeature::updateFeaturedThreads(Array)
#9 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/Model/Cron.php(356): call_user_func(Array, Array)
#10 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#11 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/Model/Deferred.php(256): XenForo_Deferred_Cron->execute(Array, Array, 7.9999940395355, '')
#12 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/Model/Deferred.php(390): XenForo_Model_Deferred->runDeferred(Array, 7.9999940395355, '', false)
#13 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/Model/Deferred.php(335): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#14 /var/www/vhosts/truckmountforums.com/httpdocs/deferred.php(23): XenForo_Model_Deferred->run(false)
#15 {main}

Request State

array(3) {
  ["url"] => string(44) "http://www.truckmountforums.com/deferred.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(3) {
    ["_xfRequestUri"] => string(53) "/threads/crazy-dog-took-off-with-my-sick-kicks.32412/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}
Code: 
ErrorException: mysqli_stmt::execute() [<a href='mysqli-stmt.execute'>mysqli-stmt.execute</a>]: (42000/1091): Can't DROP 'user_id'; check that column/key exists - library/Zend/Db/Statement/Mysqli.php:208
Generated By: admin, 2 minutes ago
Stack Trace

#0 [internal function]: XenForo_Application::handlePhpError(2, 'mysqli_stmt::ex...', '/var/www/vhosts...', 208, Array)
#1 /var/www/vhosts/truckmountforums.com/httpdocs/library/Zend/Db/Statement/Mysqli.php(208): mysqli_stmt->execute()
#2 /var/www/vhosts/truckmountforums.com/httpdocs/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#3 /var/www/vhosts/truckmountforums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /var/www/vhosts/truckmountforums.com/httpdocs/library/CTA/FeaturedThreads/Install.php(74): Zend_Db_Adapter_Abstract->query('???????ALTER TA...')
#5 [internal function]: CTA_FeaturedThreads_Install::install(false, Array, Object(SimpleXMLElement))
#6 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/Model/AddOn.php(215): call_user_func(Array, false, Array, Object(SimpleXMLElement))
#7 /var/www/vhosts/truckmountforums.com/httpdocs/library/ConvEss/Model/AddOn.php(24): XenForo_Model_AddOn->installAddOnXml(Object(SimpleXMLElement), false)
#8 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/Model/AddOn.php(169): ConvEss_Model_AddOn->installAddOnXml(Object(SimpleXMLElement), false)
#9 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/ControllerAdmin/AddOn.php(187): XenForo_Model_AddOn->installAddOnXmlFromFile('/tmp/phpb8evsO')
#10 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/FrontController.php(347): XenForo_ControllerAdmin_AddOn->actionInstall()
#11 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#12 /var/www/vhosts/truckmountforums.com/httpdocs/admin.php(13): XenForo_FrontController->run()
#13 {main}

Request State

array(3) {
  ["url"] => string(57) "http://www.truckmountforums.com/admin.php?add-ons/install"
  ["_GET"] => array(1) {
    ["add-ons/install"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["server_file"] => string(0) ""
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}
 
As it has only just started happening and the code related to this has never changed since the first release, this points to potential problems with your server/database.

What status is it at now?
Is it installed or uninstalled?

What about the related templates/phrases, etc?

I can resolve it but I first need to know what the current status is.
 
Brogan said:
As it has only just started happening and the code related to this has never changed since the first release, this points to potential problems with your server/database.

What status is it at now?
Is it installed or uninstalled?

What about the related templates/phrases, etc?

I can resolve it but I first need to know what the current status is.
Click to expand...
I dont see it in the installed addons anymore, I do see it in the templates still though. I do have to run out but ill be back this evening, thanks brogan.
 
If you can give me phpMyAdmin access I can check the db status and see which tables and columns have been dropped correctly.

It sounds though as if it needs to be reinstalled or uninstalled properly due to the template system being in an incorrect state.
 
Sorry if this is not the right place to post this question.
my forum logo links now to my portal,( I think this happens after the installation of CTA, but I'm not sure), How can I make it link the the forum page?
 
sami simo said:
Sorry if this is not the right place to post this question.
my forum logo links now to my portal,( I think this happens after the installation of CTA, but I'm not sure), How can I make it link the the forum page?
Click to expand...
I've noticed that too. I guess it just works like that, but I would like to have an option to link my logo to forum list.
 
That is default XenForo behaviour.
The logo links to the index page route.

If you have the page set as the index route, why would your main site logo link to a page other than the index/home page?
 
Brogan said:
That is default XenForo behaviour.
The logo links to the index page route.

If you have the page set as the index route, why would your main site logo link to a page other than the index/home page?
Click to expand...
That is logical, However 33% of my visitors still looking for this small tab to access my forums, and many of them, expect the logo to link to forums, as this was the default behavior in vbulletin even with a portal installed.

I think , I just have to make the forum tab bigger, or more obvious, to avoid clicks by error.
 
Is there any setting that allows the thread title not to be cut off with ..., but instead be shown in several lines instead if necessary?


Skærmbillede 2014-07-31 kl. 21.29.24.webp

In this image with icons, there are still space in the container to show more of the thread title
 
Yes.
I do it on my own site.

Just remove this from Style Properties: CTA Featured Threads Page -> Thread Title

upload_2014-7-31_20-34-28.webp

P.S. That looks great! (y)
 
Brogan said:
So far there has been very little interest in that feature so it's not high on the list of things I am looking at.
Click to expand...
Just because I'm not badgering you about it, doesn't mean I'm not interested in it. It would be high on my list of new features, probably first in fact. Should I pester you more often about it so you won't say there's "very little interest" in it? ;)
 
petertdavis said:
Just because I'm not badgering you about it, doesn't mean I'm not interested in it. It would be high on my list of new features, probably first in fact. Should I pester you more often about it so you won't say there's "very little interest" in it? ;)
Click to expand...
That would only change it from "very little interest" to "very little interest from someone who's on moderation" ;)
 
see in picture below it shows x2 .secondarycontent anyway of removing the bottom one?
 

Attachments

  • pic.webp
    pic.webp
    54.1 KB · Views: 22
You must log in or register to reply here.

Similar threads

Hristo Avramov
  • Question Question
XF 2.3 Featured threads images enlarged
Replies
0
Views
30
Hristo Avramov
Hristo Avramov
Russ
Featured threads showing "Thread" / "Resource" before title
Replies
0
Views
55
Russ
Russ
Russ
Unread status not available for featured threads
Replies
0
Views
26
Russ
Russ
Hristo Avramov
  • Question Question
XF 2.3 Featured threads template on "above nodes"
Replies
1
Views
21
Deleted member 184953
D
AndyB
Featured threads lite [Paid]
Replies
1
Views
78
mrdoitnyce
mrdoitnyce
Back
Top Bottom