[TH] Holidays

[TH] Holidays 2.1.3

No permission to download
Overview FAQ Updates (13) Reviews (11) History Discussion
It should be fixed in the next update. However, it's a bit difficult to confirm that it'll be fixed as the developer was not willing or able to provide a development license for that theme. For now I'd recommend disabling the add-on if you are running into issues while the current style is set to none.
 
I'm probably being a little thick here, but I can't find the "holidays" option under "appearance" to disable the bloody snow :S lol

b9f3f7e7-5d22-48ad-99ba-bad3a55116d0.png
 
@Jake B. Getting error from update about Unknown column 'firework_effect' in 'field list'

Code: 
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'firework_effect' in 'field list' in src/XF/Db/AbstractStatement.php at line 212

    XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 174
    XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 35
    XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 46
    XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 74
    XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1381
    XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1113
    XF\Mvc\Entity\Entity->save() in src/addons/ThemeHouse/Holidays/Setup.php at line 94
    ThemeHouse\Holidays\Setup->applyDefaultHolidays() in src/addons/ThemeHouse/Holidays/Setup.php at line 76
    ThemeHouse\Holidays\Setup->postUpgrade() in src/XF/AddOn/AddOn.php at line 579
    XF\AddOn\AddOn->postUpgrade() in src/XF/Admin/Controller/AddOn.php at line 544
    XF\Admin\Controller\AddOn->actionFinalize() in src/XF/Mvc/Dispatcher.php at line 249
    XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
    XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1880
    XF\App->run() in src/XF.php at line 328
    XF::runApp() in admin.php at line 13
 
Nirjonadda said:
@Jake B. Getting error from update about Unknown column 'firework_effect' in 'field list'

Code: 
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'firework_effect' in 'field list' in src/XF/Db/AbstractStatement.php at line 212

    XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 174
    XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 35
    XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 46
    XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 74
    XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1381
    XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1113
    XF\Mvc\Entity\Entity->save() in src/addons/ThemeHouse/Holidays/Setup.php at line 94
    ThemeHouse\Holidays\Setup->applyDefaultHolidays() in src/addons/ThemeHouse/Holidays/Setup.php at line 76
    ThemeHouse\Holidays\Setup->postUpgrade() in src/XF/AddOn/AddOn.php at line 579
    XF\AddOn\AddOn->postUpgrade() in src/XF/Admin/Controller/AddOn.php at line 544
    XF\Admin\Controller\AddOn->actionFinalize() in src/XF/Mvc/Dispatcher.php at line 249
    XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
    XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1880
    XF\App->run() in src/XF.php at line 328
    XF::runApp() in admin.php at line 13
Click to expand...
Posted a quick hotfix, just redownload the add-on and upload the files! I apologize about that!
 
silence said:
Posted a quick hotfix, just redownload the add-on and upload the files! I apologize about that!
Click to expand...

Still are not fixed. Getting same error.

Code: 
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'firework_effect' in 'field list' src/XF/Db/AbstractStatement.php:212

Generated by: Nirjon Dec 23, 2017 at 3:10 AM

Stack trace

INSERT  INTO `xf_th_holiday` (`holiday_name`, `priority`, `active`, `css_template`, `firework_effect`, `start_month`, `start_day`, `end_month`, `end_day`, `snow_effect`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(174): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(35): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(46): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(74): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(150): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1381): XF\Db\AbstractAdapter->insert('xf_th_holiday', Array)
#6 src/XF/Mvc/Entity/Entity.php(1113): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/addons/ThemeHouse/Holidays/Setup.php(94): XF\Mvc\Entity\Entity->save()
#8 src/addons/ThemeHouse/Holidays/Setup.php(76): ThemeHouse\Holidays\Setup->applyDefaultHolidays(1000092)
#9 src/XF/AddOn/AddOn.php(579): ThemeHouse\Holidays\Setup->postUpgrade(1000092, Array)
#10 src/XF/Admin/Controller/AddOn.php(544): XF\AddOn\AddOn->postUpgrade(Array)
#11 src/XF/Mvc/Dispatcher.php(249): XF\Admin\Controller\AddOn->actionFinalize(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Finalize', 'html', Object(XF\Mvc\ParameterBag), 'listAddOns', Object(XF\Admin\Controller\AddOn), NULL)
#13 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(1880): XF\Mvc\Dispatcher->run()
#15 src/XF.php(328): XF\App->run()
#16 admin.php(13): XF::runApp('XF\\Admin\\App')
#17 {main}

Request state

array(4) {
  ["url"] => string(105) "/admin.php?add-ons/ThemeHouse-Holidays/finalize&t=1513977004%2C2c7ebe444af31c5f27f70a2320ab15c4&a=upgrade"
  ["referrer"] => string(50) "/admin.php?tools/run-job"
  ["_GET"] => array(3) {
    ["add-ons/ThemeHouse-Holidays/finalize"] => string(0) ""
    ["t"] => string(43) "1513977004,2c7ebe444af31c5f27f70a2320ab15c4"
    ["a"] => string(7) "upgrade"
  }
  ["_POST"] => array(0) {
  }
}
 
Rivmedia said:
I'm probably being a little thick here, but I can't find the "holidays" option under "appearance" to disable the bloody snow :S lol

b9f3f7e7-5d22-48ad-99ba-bad3a55116d0.png
Click to expand...
Do you have the add-on enabled as I am unsure why it isn't showing under Widgets? You should see Holidays under Widgets under Appearance.
 
Nirjonadda said:
Still are not fixed. Getting same error.

Code: 
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'firework_effect' in 'field list' src/XF/Db/AbstractStatement.php:212

Generated by: Nirjon Dec 23, 2017 at 3:10 AM

Stack trace

INSERT  INTO `xf_th_holiday` (`holiday_name`, `priority`, `active`, `css_template`, `firework_effect`, `start_month`, `start_day`, `end_month`, `end_day`, `snow_effect`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(174): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(35): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(46): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(74): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(150): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1381): XF\Db\AbstractAdapter->insert('xf_th_holiday', Array)
#6 src/XF/Mvc/Entity/Entity.php(1113): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/addons/ThemeHouse/Holidays/Setup.php(94): XF\Mvc\Entity\Entity->save()
#8 src/addons/ThemeHouse/Holidays/Setup.php(76): ThemeHouse\Holidays\Setup->applyDefaultHolidays(1000092)
#9 src/XF/AddOn/AddOn.php(579): ThemeHouse\Holidays\Setup->postUpgrade(1000092, Array)
#10 src/XF/Admin/Controller/AddOn.php(544): XF\AddOn\AddOn->postUpgrade(Array)
#11 src/XF/Mvc/Dispatcher.php(249): XF\Admin\Controller\AddOn->actionFinalize(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Finalize', 'html', Object(XF\Mvc\ParameterBag), 'listAddOns', Object(XF\Admin\Controller\AddOn), NULL)
#13 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(1880): XF\Mvc\Dispatcher->run()
#15 src/XF.php(328): XF\App->run()
#16 admin.php(13): XF::runApp('XF\\Admin\\App')
#17 {main}

Request state

array(4) {
  ["url"] => string(105) "/admin.php?add-ons/ThemeHouse-Holidays/finalize&t=1513977004%2C2c7ebe444af31c5f27f70a2320ab15c4&a=upgrade"
  ["referrer"] => string(50) "/admin.php?tools/run-job"
  ["_GET"] => array(3) {
    ["add-ons/ThemeHouse-Holidays/finalize"] => string(0) ""
    ["t"] => string(43) "1513977004,2c7ebe444af31c5f27f70a2320ab15c4"
    ["a"] => string(7) "upgrade"
  }
  ["_POST"] => array(0) {
  }
}
Click to expand...
I apologize, the upgrade process isn't firing since it bumped the add-on to the new version, so I have released a patched version. Could you upgrade with that?
 
I'm still getting errors:

[TH] Holidays 1.0.0 Patch Level 2

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'firework_effect' in 'field list' in src/XF/Db/AbstractStatement.php at line 212

  1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 174
  2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 35
  3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 46
  4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 74
  5. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
  6. XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1381
  7. XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1113
  8. XF\Mvc\Entity\Entity->save() in src/addons/ThemeHouse/Holidays/Setup.php at line 94
  9. ThemeHouse\Holidays\Setup->applyDefaultHolidays() in src/addons/ThemeHouse/Holidays/Setup.php at line 76
  10. ThemeHouse\Holidays\Setup->postUpgrade() in src/XF/AddOn/AddOn.php at line 579
  11. XF\AddOn\AddOn->postUpgrade() in src/XF/Admin/Controller/AddOn.php at line 544
  12. XF\Admin\Controller\AddOn->actionFinalize() in src/XF/Mvc/Dispatcher.php at line 249
  13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
  14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
  15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1880
  16. XF\App->run() in src/XF.php at line 328
  17. XF::runApp() in admin.php at line 13
 
silence said:
I apologize, the upgrade process isn't firing since it bumped the add-on to the new version, so I have released a patched version. Could you upgrade with that?
Click to expand...

Still can not update. Please update new version with 1.0.1 Patch Level 1, So we can update.
 
You must log in or register to reply here.

Similar threads

Veer
[XenCustomize] Holidays Manager: Vacations, Trips & Travel-related CMS [Paid]
Replies
12
Views
851
Veer
Veer
N
[TH] Donate - FRENCH translation
Replies
1
Views
544
Nicolas FR
N
DemoTiger
Vanillicon Integration for XenForo - Set Avatars Automatically or by default [Paid]
Replies
2
Views
555
DemoTiger
DemoTiger
Veer
[XenCustomize] Limit Resource Downloads [Paid]
2
Replies
35
Views
2K
Veer
Veer
AndyB
Forum cookie [Paid]
Replies
4
Views
721
AndyB
AndyB
Top Bottom