[FIXED] Create Event

Tealk

Member
If i try to create a Event i get the this error:
Code:
    XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'latest_comment_ids' in 'field list' src/XF/Db/AbstractStatement.php:217

    Generated by: Tealk Feb 8, 2019 at 12:20 PM

Stack trace

INSERT  INTO `xf_tl_group_event` (`group_id`, `event_name`, `address`, `timezone`, `latitude`, `longitude`, `begin_date`, `end_date`, `created_date`, `user_id`, `username`, `last_comment_date`, `event_id`, `cover_date`, `tags`, `first_comment_id`, `latest_comment_ids`, `comment_count`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(89): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(169): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_tl_group_eve...', Array, false)
#6 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/addons/Truonglv/Groups/Service/Event/Creator.php(106): XF\Mvc\Entity\Entity->save(true, false)
#8 src/XF/Service/ValidateAndSavableTrait.php(40): Truonglv\Groups\Service\Event\Creator->_save()
#9 src/addons/Truonglv/Groups/ControllerPlugin/Comment.php(37): Truonglv\Groups\Service\Event\Creator->save()
#10 src/addons/Truonglv/Groups/Pub/Controller/Event.php(453): Truonglv\Groups\ControllerPlugin\Comment->saveCommentProcess(Object(Truonglv\Groups\Service\Event\Creator), true, 'description')
#11 src/addons/Truonglv/Groups/Pub/Controller/Event.php(179): Truonglv\Groups\Pub\Controller\Event->saveEventProcess(Object(Truonglv\Groups\Entity\Group))
#12 src/XF/Mvc/Dispatcher.php(321): Truonglv\Groups\Pub\Controller\Event->actionAdd(Object(XF\Mvc\ParameterBag))
#13 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('Truonglv\\Groups...', 'Add', Object(XF\Mvc\RouteMatch), Object(Truonglv\Groups\Pub\Controller\Event), NULL)
#14 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Truonglv\Groups\Pub\Controller\Event), NULL)
#15 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#17 src/XF.php(390): XF\App->run()
#18 index.php(20): XF::runApp('XF\\Pub\\App')
#19 {main}

Request state

array(4) {
  ["url"] => string(29) "/groups/events/add?group_id=1"
  ["referrer"] => bool(false)
  ["_GET"] => array(1) {
    ["group_id"] => string(1) "1"
  }
  ["_POST"] => array(17) {
    ["event_name"] => string(5) "Runde"
    ["description_html"] => string(17) "<p>Spielrunde</p>"
    ["attachment_hash"] => string(32) "fa891556f9aa94be8362859b5293f3b7"
    ["attachment_hash_combined"] => string(94) "{"type":"tl_group_comment","context":{"group_id":1},"hash":"fa891556f9aa94be8362859b5293f3b7"}"
    ["tags"] => string(0) ""
    ["begin_date_"] => string(17) "2019-02-10 13:00 "
    ["begin_date"] => string(17) "2019-02-10 13:00 "
    ["end_date_"] => string(17) "2019-02-10 19:00 "
    ["end_date"] => string(17) "2019-02-10 19:00 "
    ["timezone"] => string(16) "Europe/Amsterdam"
    ["address"] => string(0) ""
    ["latitude"] => string(1) "0"
    ["longitude"] => string(1) "0"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(29) "/groups/events/add?group_id=1"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}
 
Can you run this query and give me the results?
Code:
show columns from xf_tl_group_event;
 
:O That was quite weird. What is previous version when you upgrade to this version?
 
Now i get this error:
Code:
Server error log

    ErrorException: Template error: Template public:tlg_alert_item_comment_event_event is unknown src/XF/Template/Templater.php:611

    Generated by: Reinhold Türst Feb 8, 2019 at 4:51 PM

Stack trace

#0 [internal function]: XF\Template\Templater->handleTemplateError(512, 'Template public...', '/var/customers/...', 611, Array)
#1 src/XF/Template/Templater.php(611): trigger_error('Template public...', 512)
#2 src/XF/Template/Templater.php(562): XF\Template\Templater->getTemplateData('public', 'tlg_alert_item_...')
#3 src/XF/Template/Templater.php(1293): XF\Template\Templater->getTemplateCode('public', 'tlg_alert_item_...')
#4 src/addons/AL/ThreadFilter/XF/Template/Templater.php(108): XF\Template\Templater->renderTemplate('tlg_alert_item_...', Array, true)
#5 src/XF/Alert/AbstractHandler.php(80): AL\ThreadFilter\XF\Template\Templater->renderTemplate('public:tlg_aler...', Array)
#6 src/XF/Entity/UserAlert.php(69): XF\Alert\AbstractHandler->render(Object(SV\AlertImprovements\XF\Entity\UserAlert))
#7 [internal function]: XF\Entity\UserAlert->render()
#8 src/XF/Template/Templater.php(978): call_user_func_array(Array, Array)
#9 internal_data/code_cache/templates/l3/s20/public/alert_macros.php(42): XF\Template\Templater->method(Object(SV\AlertImprovements\XF\Entity\UserAlert), 'render', Array)
#10 src/XF/Template/Templater.php(694): XF\Template\Templater->{closure}(Object(BlackTea\SteamAuth\XF\Template\Templater), Array, Array)
#11 internal_data/code_cache/templates/l3/s20/public/account_alerts_popup.php(16): XF\Template\Templater->callMacro('alert_macros', 'row', Array, Array)
#12 src/XF/Template/Templater.php(1294): XF\Template\Templater->{closure}(Object(BlackTea\SteamAuth\XF\Template\Templater), Array)
#13 src/addons/AL/ThreadFilter/XF/Template/Templater.php(108): XF\Template\Templater->renderTemplate('account_alerts_...', Array, true)
#14 src/XF/Template/Template.php(24): AL\ThreadFilter\XF\Template\Templater->renderTemplate('public:account_...', Array)
#15 src/XF/Mvc/Renderer/Json.php(84): XF\Template\Template->render()
#16 src/XF/Mvc/Renderer/Json.php(68): XF\Mvc\Renderer\Json->renderHtmlFallback('XF:Account\\Aler...', 'public:account_...', Array)
#17 src/XF/Mvc/Dispatcher.php(418): XF\Mvc\Renderer\Json->renderView('XF:Account\\Aler...', 'public:account_...', Array)
#18 src/XF/Mvc/Dispatcher.php(400): XF\Mvc\Dispatcher->renderView(Object(XF\Mvc\Renderer\Json), Object(XF\Mvc\Reply\View))
#19 src/XF/Mvc/Dispatcher.php(360): XF\Mvc\Dispatcher->renderReply(Object(XF\Mvc\Renderer\Json), Object(XF\Mvc\Reply\View))
#20 src/XF/Mvc/Dispatcher.php(53): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\View), 'json')
#21 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#22 src/XF.php(390): XF\App->run()
#23 index.php(20): XF::runApp('XF\\Pub\\App')
#24 {main}

Request state

array(4) {
  ["url"] => string(145) "/account/alerts-popup?_xfRequestUri=%2F&_xfWithData=1&_xfToken=1549644682%2C0030eb379350fbcabfedb836c67981ac&_xfResponseType=json&_=1549644683535"
  ["referrer"] => bool(false)
  ["_GET"] => array(5) {
    ["_xfRequestUri"] => string(1) "/"
    ["_xfWithData"] => string(1) "1"
    ["_xfToken"] => string(43) "1549644682,0030eb379350fbcabfedb836c67981ac"
    ["_xfResponseType"] => string(4) "json"
    ["_"] => string(13) "1549644683535"
  }
  ["_POST"] => array(0) {
  }
}

I think it's interrelated?
2959
 
Last edited:
Back
Top