Widget Threads Enhancement [Paid] 3.0.2

[shaunj66]

Would it be possible for embedded videos (Youtube etc) to have an image in the article mode?

 

[Truonglv]

Would it be possible for embedded videos (Youtube etc) to have an image in the article mode?

shaunj66Yes it's possible.

 

[john917]

I'm getting this error when uninstalling please help!
Truonglv

XF\Db\Exception: MySQL statement prepare error [1146]: Table 'bsi.xf_wte_widget_cache' doesn't exist in src/XF/Db/AbstractStatement.php at line 230
[LIST=1]
[*]XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
[*]XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 41
[*]XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 56
[*]XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
[*]XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 291
[*]XF\Db\AbstractAdapter->delete() in src/addons/Truonglv/WidgetThreadEnhance/Repository/Cache.php at line 96
[*]Truonglv\WidgetThreadEnhance\Repository\Cache->invalidate() in src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php at line 314
[*]Truonglv\WidgetThreadEnhance\Widget\Threads->postDelete() in src/XF/Entity/Widget.php at line 123
[*]XF\Entity\Widget->_postDelete() in src/XF/Mvc/Entity/Entity.php at line 1659
[*]XF\Mvc\Entity\Entity->delete() in src/XF/Entity/WidgetDefinition.php at line 166
[*]XF\Entity\WidgetDefinition->_postDelete() in src/XF/Mvc/Entity/Entity.php at line 1659
[*]XF\Mvc\Entity\Entity->delete() in src/XF/AddOn/DataType/AbstractDataType.php at line 124
[*]XF\AddOn\DataType\AbstractDataType->deleteEntity() in src/XF/AddOn/DataType/AbstractDataType.php at line 110
[*]XF\AddOn\DataType\AbstractDataType->deleteAddOnData() in src/XF/Job/AddOnUninstallData.php at line 52
[*]XF\Job\AddOnUninstallData->run() in src/XF/Job/Manager.php at line 260
[*]XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 202
[*]XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 118
[*]XF\Job\Manager->runByIds() in src/XF/Admin/Controller/Tools.php at line 122
[*]XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 352
[*]XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
[*]XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
[*]XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
[*]XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
[*]XF\App->run() in src/XF.php at line 524
[*]XF::runApp() in admin.php at line 13
[/LIST]

 

[john917]

I'm getting this error when uninstalling please help!
Truonglv

XF\Db\Exception: MySQL statement prepare error [1146]: Table 'bsi.xf_wte_widget_cache' doesn't exist in src/XF/Db/AbstractStatement.php at line 230
[LIST=1]
[*]XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
[*]XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 41
[*]XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 56
[*]XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
[*]XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 291
[*]XF\Db\AbstractAdapter->delete() in src/addons/Truonglv/WidgetThreadEnhance/Repository/Cache.php at line 96
[*]Truonglv\WidgetThreadEnhance\Repository\Cache->invalidate() in src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php at line 314
[*]Truonglv\WidgetThreadEnhance\Widget\Threads->postDelete() in src/XF/Entity/Widget.php at line 123
[*]XF\Entity\Widget->_postDelete() in src/XF/Mvc/Entity/Entity.php at line 1659
[*]XF\Mvc\Entity\Entity->delete() in src/XF/Entity/WidgetDefinition.php at line 166
[*]XF\Entity\WidgetDefinition->_postDelete() in src/XF/Mvc/Entity/Entity.php at line 1659
[*]XF\Mvc\Entity\Entity->delete() in src/XF/AddOn/DataType/AbstractDataType.php at line 124
[*]XF\AddOn\DataType\AbstractDataType->deleteEntity() in src/XF/AddOn/DataType/AbstractDataType.php at line 110
[*]XF\AddOn\DataType\AbstractDataType->deleteAddOnData() in src/XF/Job/AddOnUninstallData.php at line 52
[*]XF\Job\AddOnUninstallData->run() in src/XF/Job/Manager.php at line 260
[*]XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 202
[*]XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 118
[*]XF\Job\Manager->runByIds() in src/XF/Admin/Controller/Tools.php at line 122
[*]XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 352
[*]XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
[*]XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
[*]XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
[*]XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
[*]XF\App->run() in src/XF.php at line 524
[*]XF::runApp() in admin.php at line 13
[/LIST]

john917Bro... Can I get a refund at least? Or please help? Truonglv

 

[Truonglv]

Bro... Can I get a refund at least? Or please help? Truonglv

john917Do you install new or upgrade it?

 

[Truonglv]

Do you install new or upgrade it?

TruonglvCan you manual run this query:

CREATE TABLE `xf_wte_widget_cache` (
  `cache_id` varbinary(32) NOT NULL,
  `data` mediumblob NOT NULL,
  `widget_id` int(10) unsigned NOT NULL DEFAULT 0,
  `cached_date` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`cache_id`),
  KEY `widget_id` (`widget_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 

[john917]

Can you manual run this query:

CREATE TABLE `xf_wte_widget_cache` (
  `cache_id` varbinary(32) NOT NULL,
  `data` mediumblob NOT NULL,
  `widget_id` int(10) unsigned NOT NULL DEFAULT 0,
  `cached_date` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`cache_id`),
  KEY `widget_id` (`widget_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

TruonglvIt's already there so it won't accept that query.

 

[john917]

Can you manual run this query:

CREATE TABLE `xf_wte_widget_cache` (
  `cache_id` varbinary(32) NOT NULL,
  `data` mediumblob NOT NULL,
  `widget_id` int(10) unsigned NOT NULL DEFAULT 0,
  `cached_date` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`cache_id`),
  KEY `widget_id` (`widget_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

TruonglvIt's empty though

 

[Truonglv]

It's empty though View attachment 6223

john917It's weird cause your error told it does not exists.

 

[Truonglv]

Yes, something wrong with the addon. I reinstalled the addon too to try and fix it.

john917Do you have limit database to create new table? Can you check privileges of your current database user?

 

[john917]

Do you have limit database to create new table? Can you check privileges of your current database user?

TruonglvPrivileges are all there. Is there a way I can make sure it doesn't check for database user when uninstalling? I noticed it says BSI bsi.xf_wte_widget_cache which is weird since that's my other database user on my test environment. Can you make it so when I rebuild the addon it updates correct database user?

 

[Kairete]

Good!