What's new

Welcome!

By registering with us, you'll be able to buy addons, discuss your problems and get support.

SignUp Now!

Bug XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'at_glw_display' in 'field list'

Status
Not open for further replies.
Forum version
XenForo 2.1.x

Speddy20537

Group Legend Widget
Last Member Online
Matomo Analytics
Joined
Oct 15, 2019
Messages
7
PHP:
F\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'at_glw_display' in 'field list' src/XF/Db/AbstractStatement.php:217
Generiert durch: webmaster 25 Oktober 2019 um 16:33 Uhr
Stapelverfolgung
UPDATE  `xf_user_group` SET `at_glw_display` = ? WHERE `user_group_id` = 2
------------

#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(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(326): XF\Db\AbstractAdapter->query('UPDATE  `xf_use...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1457): XF\Db\AbstractAdapter->update('xf_user_group', Array, '`user_group_id`...')
#6 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/XF/Mvc/FormAction.php(69): XF\Mvc\Entity\Entity->save(true, false)
#8 src/XF/Mvc/FormAction.php(187): XF\Mvc\FormAction->XF\Mvc\{closure}(Object(XF\Mvc\FormAction))
#9 src/XF/Admin/Controller/UserGroup.php(120): XF\Mvc\FormAction->run()
#10 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\UserGroup->actionSave(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:UserGroup', 'Save', Object(XF\Mvc\RouteMatch), Object(AnzahTools\GroupLegendWidget\XF\Admin\Controller\UserGroup), NULL)
#12 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(AnzahTools\GroupLegendWidget\XF\Admin\Controller\UserGroup), NULL)
#13 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#15 src/XF.php(390): XF\App->run()
#16 admin.php(13): XF::runApp('XF\\Admin\\App')
#17 {main}


Code:
array(4) {
  ["url"] => string(41) "/admin.php?user-groups/mietglieder.2/save"
  ["referrer"] => string(82) "https://www.gameserversupport.de/admin.php?user-groups/mietglieder.2/edit"
  ["_GET"] => array(1) {
    ["user-groups/mietglieder_2/save"] => string(0) ""
  }
  ["_POST"] => array(13) {
    ["title"] => string(11) "Mietglieder"
    ["display_style_priority"] => string(1) "0"
    ["user_title_override"] => string(1) "0"
    ["username_css"] => string(10) "color:blue"
    ["dbtech_membermap_pin"] => string(8) "blue-dot"
    ["banner_text"] => string(11) "Mietglieder"
    ["banner_css_class"] => string(27) "userBanner userBanner--blue"
    ["at_glw_display"] => string(1) "1"
    ["permissions"] => array(55) {
      ["general"] => array(47) {
        ["view"] => string(5) "allow"
        ["viewNode"] => string(5) "allow"
        ["viewMemberList"] => string(5) "allow"
        ["viewProfile"] => string(5) "allow"
        ["snog_flags_view"] => string(5) "unset"
        ["usePush"] => string(5) "allow"
        ["sv_searchOptions"] => string(5) "allow"
        ["maxMentionedUsers"] => string(1) "5"
        ["search"] => string(5) "allow"
        ["createTag"] => string(5) "allow"
        ["bypassUserTagLimit"] => string(5) "unset"
        ["editProfile"] => string(5) "allow"
        ["editCustomTitle"] => string(5) "unset"
        ["requireTfa"] => string(5) "unset"
        ["submitWithoutApproval"] => string(5) "unset"
        ["bypassFloodCheck"] => string(4) "deny"
        ["bypassSpamCheck"] => string(4) "deny"
        ["report"] => string(5) "allow"
        ["useContactForm"] => string(5) "allow"
        ["viewIps"] => string(5) "unset"
        ["bypassUserPrivacy"] => string(5) "unset"
        ["cleanSpam"] => string(5) "unset"
        ["viewWarning"] => string(5) "unset"
        ["warn"] => string(5) "unset"
        ["prevent_warning"] => string(5) "unset"
        ["warn_mod"] => string(5) "unset"
        ["warn_admin"] => string(5) "unset"
        ["manageWarning"] => string(5) "unset"
        ["manageWarning_mod"] => string(5) "unset"
        ["manageWarning_admin"] => string(5) "unset"
        ["editBasicProfile"] => string(5) "unset"
        ["approveRejectUser"] => string(5) "unset"
        ["banUser"] => string(5) "unset"
        ["canUseLau"] => string(5) "unset"
        ["acpeCanViewPollVoters"] => string(5) "unset"
        ["editSignature"] => string(5) "allow"
        ["viewReports"] => string(5) "unset"
        ["replyReport"] => string(5) "unset"
        ["replyReportClosed"] => string(5) "unset"
        ["updateReport"] => string(5) "unset"
        ["assignReport"] => string(5) "unset"
        ["viewReporterUsername"] => string(5) "unset"
        ["reportLike"] => string(5) "unset"
        ["viewReportUser"] => string(5) "unset"
        ["isASeller"] => string(5) "unset"
        ["canViewAllSales"] => string(5) "unset"
        ["canManageAllLicenses"] => string(5) "unset"
      }
      ["avatar"] => array(1) {
        ["allowed"] => string(5) "allow"
      }
    
}
 

Speddy20537

Group Legend Widget
Last Member Online
Matomo Analytics
Joined
Oct 15, 2019
Messages
7
Hi
This error occurs when I change the group setting and go to save.

I do not know if it has anything to do with it, but I use php 7.3
 
Last edited:

Speddy20537

Group Legend Widget
Last Member Online
Matomo Analytics
Joined
Oct 15, 2019
Messages
7
Stop has done it Uninstalled and then reinstalled and lo and behold, it works now.
 

Speddy20537

Group Legend Widget
Last Member Online
Matomo Analytics
Joined
Oct 15, 2019
Messages
7
PHP:
ParseError: syntax error, unexpected 'public' (T_PUBLIC), expecting end of file src/addons/AnzahTools/GroupLegendWidget/Setup.php:33
Generiert durch: webmaster 26 Oktober 2019 um 12:16 Uhr

PHP:
#0 src/vendor/composer/ClassLoader.php(322): Composer\Autoload\includeFile('/var/www/virtua...')
#1 [internal function]: Composer\Autoload\ClassLoader->loadClass('AnzahTools\\Grou...')
#2 src/XF/AddOn/AddOn.php(442): spl_autoload_call('AnzahTools\\Grou...')
#3 src/XF/Admin/Controller/AddOn.php(772): XF\AddOn\AddOn->checkRequirements(Array, Array)
#4 src/XF/Admin/Controller/AddOn.php(544): XF\Admin\Controller\AddOn->getAddOnWarningsAndErrors(Object(XF\AddOn\AddOn))
#5 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\AddOn->actionUpgrade(Object(XF\Mvc\ParameterBag))
#6 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Upgrade', Object(XF\Mvc\RouteMatch), Object(TickTackk\DeveloperTools\XF\Admin\Controller\AddOn), NULL)
#7 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(TickTackk\DeveloperTools\XF\Admin\Controller\AddOn), NULL)
#8 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#9 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#10 src/XF.php(390): XF\App->run()
#11 admin.php(13): XF::runApp('XF\\Admin\\App')
#12 {main}


PHP:
array(4) {
  ["url"] => string(185) "/admin.php?add-ons/AnzahTools-GroupLegendWidget/upgrade&_xfRequestUri=%2Fadmin.php%3Fadd-ons%2F&_xfWithData=1&_xfToken=1572088573%2C022fdcd2dc294ee9092459e5a2c7df64&_xfResponseType=json"
  ["referrer"] => string(60) "https://www.gameserversupport.de/admin.php?add-ons/"
  ["_GET"] => array(5) {
    ["add-ons/AnzahTools-GroupLegendWidget/upgrade"] => string(0) ""
    ["_xfRequestUri"] => string(19) "/admin.php?add-ons/"
    ["_xfWithData"] => string(1) "1"
    ["_xfToken"] => string(43) "1572088573,022fdcd2dc294ee9092459e5a2c7df64"
    ["_xfResponseType"] => string(4) "json"
  }
  ["_POST"] => array(0) {
  }
}





update a 1.3.1 of 1.3.2
 

Speddy20537

Group Legend Widget
Last Member Online
Matomo Analytics
Joined
Oct 15, 2019
Messages
7
PHP:
ParseError: syntax error, unexpected 'public' (T_PUBLIC), expecting end of file in src/addons/AnzahTools/GroupLegendWidget/Setup.php at line 33
Composer\Autoload\includeFile() in src/vendor/composer/ClassLoader.php at line 322
Composer\Autoload\ClassLoader->loadClass()
spl_autoload_call() in src/XF/AddOn/AddOn.php at line 442
XF\AddOn\AddOn->checkRequirements() in src/XF/Job/AddOnInstallBatch.php at line 235
XF\Job\AddOnInstallBatch->stepPreAction() in src/XF/Job/AddOnInstallBatch.php at line 86
XF\Job\AddOnInstallBatch->run() in src/XF/Job/Manager.php at line 253
XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 195
XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 111
XF\Job\Manager->runByIds() in src/XF/Admin/Controller/Tools.php at line 120
XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 321
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in admin.php at line 13
 

Draupnir

One of the many
Joined
May 29, 2019
Messages
74
Hello Speddy20537,

We hope your ticket regarding Group Legend Widget has been addressed to your satisfaction. This ticket has now been closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.
AnzahTools
 

Draupnir

One of the many
Joined
May 29, 2019
Messages
74
Hello Speddy20537,

As we have not heard back from you, your ticket regarding Group Legend Widget has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

If you have time, please leave a review on XenForo.com's Resource Manager.

Thank you.
AnzahTools
 
Status
Not open for further replies.

Group Legend Widget

Seller
Draupnir
Release date
Last update
Total downloads
32
Customer rating
0.00 star(s) 0 ratings
Top