[Andrew] Moderator Panel 2.0.9

ichpen · Mar 4, 2024

1.9.2 behaving for most of ya

Asking for a friend

Just checking all the noise from yesterday, was about to update from a much older version.

BassMan · Mar 5, 2024

1.9.2 works fine for me.

otto · Mar 6, 2024

Since last update I have several times this errors:

Code:

Fehlermeldung des Servers
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'andrew_reg_country' in 'field list' src/XF/Db/AbstractStatement.php:230
Generiert durch: Unbekanntes Benutzerkonto 6.03.2024 um 19:30 Uhr
Stapelverfolgung
UPDATE  `xf_user` SET `andrew_reg_country` = ? WHERE `user_id` = 4386
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(40): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(323): XF\Db\AbstractAdapter->query('UPDATE  `xf_use...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1362): XF\Db\AbstractAdapter->update('xf_user', Array, '`user_id` = 438...')
#6 src/addons/Andrew/ModeratorPanel/XF/Entity/User.php(602): XF\Mvc\Entity\Entity->fastUpdate('andrew_reg_coun...', 'Germany')
#7 src/XF/Mvc/Entity/Entity.php(1282): Andrew\ModeratorPanel\XF\Entity\User->_postSave()
#8 src/XF/Service/User/Registration.php(306): XF\Mvc\Entity\Entity->save()
#9 src/addons/OzzModz/UserRegistrationRefererLog/XF/Service/User/Registration.php(34): XF\Service\User\Registration->_save()
#10 src/XF/Service/ValidateAndSavableTrait.php(42): OzzModz\UserRegistrationRefererLog\XF\Service\User\Registration->_save()
#11 src/XF/Pub/Controller/Register.php(429): XF\Service\User\Registration->save()
#12 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#13 src/XF/Mvc/Dispatcher.php(258): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(Andy\CountryAccessCheck\XF\Pub\Controller\Register), NULL)
#14 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Andy\CountryAccessCheck\XF\Pub\Controller\Register), NULL)
#15 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#17 src/XF.php(524): XF\App->run()
#18 index.php(20): XF::runApp('XF\\Pub\\App')
#19 {main}
Benötigter Status
array(4) {
  ["url"] => string(18) "/register/register"
  ["referrer"] => string(36) "https://www.zetor-forum.de/register/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(18) {
    ["_xfToken"] => string(8) "********"
    ["username"] => string(0) ""
    ["f30dfb5d03ad4d08cb7da37d18c8b6dde99961da"] => string(6) "Waldi "
    ["32a67aaa97772be4ac0f931f14da3231003dc2b7"] => string(15) "maik.83@gmx.net"
    ["password"] => string(8) "********"
    ["86c7fc90bf9fb225c671b9f8ec35a1106e9640de"] => string(8) "********"
    ["dob_month"] => string(1) "7"
    ["dob_day"] => string(2) "13"
    ["dob_year"] => string(4) "1983"
    ["location"] => string(10) "Hitzacker "
    ["custom_fields"] => array(3) {
      ["rufname"] => string(6) "Waldi "
      ["meinezetor"] => string(15) "Belarus MTS 50 "
      ["anderetechnik"] => string(0) ""
    }
    ["cf-turnstile-response"] => string(581) "0.1Sq1aIo8X-jbNxpMiMYEj6VX-h0A2t9TGkcZOh1NYJNVa5dxY8yULLWPDyCeqELI7EuiFxaBoi0c92JfKiwPLdVtddJAGGeW-qZBbeczQpGz7TRjiVxqPTKD4AADJs8uc9SMzVItNAg7yC7erlDfRXiaHUZSA869oWyoyTwBNHsxBpTJGw0S0KWR0X3FRdrB2K_PsD1_d_0lLRvhAR4iGco8pyUqQhR6HTl-MuhANDp-zsv0k9aIGvbAt5HpnnV6F9rRZEbjVPshMU_RddtBZohYU3ZBkzmISu8YHcxzH9wU233cQiD6RhFf9ghwqtVLimxN-yTYaNoW1TnwzNzu10ejfB7ORSIBVR3bSs9ozsaR-UPsPOWDSDL1xD62sKVHms63lQuq-SNH5TzdLN-b71HtDKPXoNtpiR7bZEcyxpJ2YXUHNQryzWFiRY1J0sQNbLC9OHq5Bh0lFmxKRLQ4ZVUr25K9fhARLLybqSt_dGQ.XBVl4OIZgOyjqjdwg3pbJw.8d764d95aae8b864cefef447be4dcde8627fa6117c81d413f2e298bc5b0ea077"
    ["accept"] => string(1) "1"
    ["reg_key"] => string(16) "JSsPMJIWNV_RGPOD"
    ["e800efe24360821be53677685da82696f0fed100"] => string(16) "Europe/Amsterdam"
    ["_xfRequestUri"] => string(10) "/register/"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

Xenforo 2.2.15, php 8.2.x MariaDB 10.x

Any Ideas to fix that?

AndrewSimm · Mar 6, 2024

otto said:

Since last update I have several times this errors:

Code:

Fehlermeldung des Servers
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'andrew_reg_country' in 'field list' src/XF/Db/AbstractStatement.php:230
Generiert durch: Unbekanntes Benutzerkonto 6.03.2024 um 19:30 Uhr
Stapelverfolgung
UPDATE  `xf_user` SET `andrew_reg_country` = ? WHERE `user_id` = 4386
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(40): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(323): XF\Db\AbstractAdapter->query('UPDATE  `xf_use...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1362): XF\Db\AbstractAdapter->update('xf_user', Array, '`user_id` = 438...')
#6 src/addons/Andrew/ModeratorPanel/XF/Entity/User.php(602): XF\Mvc\Entity\Entity->fastUpdate('andrew_reg_coun...', 'Germany')
#7 src/XF/Mvc/Entity/Entity.php(1282): Andrew\ModeratorPanel\XF\Entity\User->_postSave()
#8 src/XF/Service/User/Registration.php(306): XF\Mvc\Entity\Entity->save()
#9 src/addons/OzzModz/UserRegistrationRefererLog/XF/Service/User/Registration.php(34): XF\Service\User\Registration->_save()
#10 src/XF/Service/ValidateAndSavableTrait.php(42): OzzModz\UserRegistrationRefererLog\XF\Service\User\Registration->_save()
#11 src/XF/Pub/Controller/Register.php(429): XF\Service\User\Registration->save()
#12 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#13 src/XF/Mvc/Dispatcher.php(258): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(Andy\CountryAccessCheck\XF\Pub\Controller\Register), NULL)
#14 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Andy\CountryAccessCheck\XF\Pub\Controller\Register), NULL)
#15 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#17 src/XF.php(524): XF\App->run()
#18 index.php(20): XF::runApp('XF\\Pub\\App')
#19 {main}
Benötigter Status
array(4) {
  ["url"] => string(18) "/register/register"
  ["referrer"] => string(36) "https://www.zetor-forum.de/register/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(18) {
    ["_xfToken"] => string(8) "********"
    ["username"] => string(0) ""
    ["f30dfb5d03ad4d08cb7da37d18c8b6dde99961da"] => string(6) "Waldi "
    ["32a67aaa97772be4ac0f931f14da3231003dc2b7"] => string(15) "maik.83@gmx.net"
    ["password"] => string(8) "********"
    ["86c7fc90bf9fb225c671b9f8ec35a1106e9640de"] => string(8) "********"
    ["dob_month"] => string(1) "7"
    ["dob_day"] => string(2) "13"
    ["dob_year"] => string(4) "1983"
    ["location"] => string(10) "Hitzacker "
    ["custom_fields"] => array(3) {
      ["rufname"] => string(6) "Waldi "
      ["meinezetor"] => string(15) "Belarus MTS 50 "
      ["anderetechnik"] => string(0) ""
    }
    ["cf-turnstile-response"] => string(581) "0.1Sq1aIo8X-jbNxpMiMYEj6VX-h0A2t9TGkcZOh1NYJNVa5dxY8yULLWPDyCeqELI7EuiFxaBoi0c92JfKiwPLdVtddJAGGeW-qZBbeczQpGz7TRjiVxqPTKD4AADJs8uc9SMzVItNAg7yC7erlDfRXiaHUZSA869oWyoyTwBNHsxBpTJGw0S0KWR0X3FRdrB2K_PsD1_d_0lLRvhAR4iGco8pyUqQhR6HTl-MuhANDp-zsv0k9aIGvbAt5HpnnV6F9rRZEbjVPshMU_RddtBZohYU3ZBkzmISu8YHcxzH9wU233cQiD6RhFf9ghwqtVLimxN-yTYaNoW1TnwzNzu10ejfB7ORSIBVR3bSs9ozsaR-UPsPOWDSDL1xD62sKVHms63lQuq-SNH5TzdLN-b71HtDKPXoNtpiR7bZEcyxpJ2YXUHNQryzWFiRY1J0sQNbLC9OHq5Bh0lFmxKRLQ4ZVUr25K9fhARLLybqSt_dGQ.XBVl4OIZgOyjqjdwg3pbJw.8d764d95aae8b864cefef447be4dcde8627fa6117c81d413f2e298bc5b0ea077"
    ["accept"] => string(1) "1"
    ["reg_key"] => string(16) "JSsPMJIWNV_RGPOD"
    ["e800efe24360821be53677685da82696f0fed100"] => string(16) "Europe/Amsterdam"
    ["_xfRequestUri"] => string(10) "/register/"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

Xenforo 2.2.15, php 8.2.x MariaDB 10.x

Any Ideas to fix that?

Upgrade to 1.9.2 and this will be fixed.

otto · Mar 6, 2024

Oh sorry I doesnt see the 1.9.2 just bevore and the AUN addons takes no notice from with a update message for me.
Thanks.

Mxrcy · Mar 9, 2024

Is there a way to change the Primary User Group?

AndrewSimm · Mar 9, 2024

Mxrcy said:
Is there a way to change the Primary User Group?

No within this add-on. What is the use case you are thinking of?

otto · Mar 9, 2024

Add-on 1.9.2 but the same error:

Code:

Fehlermeldung des Servers
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'andrew_reg_country' in 'field list' src/XF/Db/AbstractStatement.php:230
Generiert durch: Unbekanntes Benutzerkonto 9.03.2024 um 14:29 Uhr
Stapelverfolgung
UPDATE  `xf_user` SET `andrew_reg_country` = ? WHERE `user_id` = 4429
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(40): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(323): XF\Db\AbstractAdapter->query('UPDATE  `xf_use...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1362): XF\Db\AbstractAdapter->update('xf_user', Array, '`user_id` = 442...')
#6 src/addons/Andrew/ModeratorPanel/XF/Entity/User.php(602): XF\Mvc\Entity\Entity->fastUpdate('andrew_reg_coun...', 'Germany')
#7 src/XF/Mvc/Entity/Entity.php(1282): Andrew\ModeratorPanel\XF\Entity\User->_postSave()
#8 src/XF/Service/User/Registration.php(306): XF\Mvc\Entity\Entity->save()
#9 src/addons/OzzModz/UserRegistrationRefererLog/XF/Service/User/Registration.php(34): XF\Service\User\Registration->_save()
#10 src/XF/Service/ValidateAndSavableTrait.php(42): OzzModz\UserRegistrationRefererLog\XF\Service\User\Registration->_save()
#11 src/XF/Pub/Controller/Register.php(429): XF\Service\User\Registration->save()
#12 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#13 src/XF/Mvc/Dispatcher.php(258): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(Andy\CountryAccessCheck\XF\Pub\Controller\Register), NULL)
#14 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Andy\CountryAccessCheck\XF\Pub\Controller\Register), NULL)
#15 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#17 src/XF.php(524): XF\App->run()
#18 index.php(20): XF::runApp('XF\\Pub\\App')
#19 {main}
Benötigter Status
array(4) {
  ["url"] => string(18) "/register/register"
  ["referrer"] => string(70) "https://www.zetor-forum.de/themen/kein-hydraulikdruck-zetor-5245.6417/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(19) {
    ["_xfToken"] => string(8) "********"
    ["username"] => string(0) ""
    ["7b9e62259a286d02f4eb835dd7fa965f047394d3"] => string(9) "RostPilot"
    ["31ab999a837996e473466b37b73266bd08883cb4"] => string(24) "theokunick2003@gmail.com"
    ["password"] => string(8) "********"
    ["71f144a176b37b1f6f3ad3822db705c13f24b887"] => string(8) "********"
    ["dob_month"] => string(1) "2"
    ["dob_day"] => string(2) "10"
    ["dob_year"] => string(4) "2003"
    ["location"] => string(19) "Rabenstein/Fläming"
    ["custom_fields"] => array(3) {
      ["rufname"] => string(4) "Theo"
      ["meinezetor"] => string(27) "Zetor 5211
Bautz 300
RS09"
      ["anderetechnik"] => string(0) ""
    }
    ["cf-turnstile-response"] => string(581) "0.YLe3NnCeReYpR_KgBxN6amk9f1UI_i8Ts1psgLx_48j6zhRx4sRmxTwgqLfq88iZnykZu0NgesCxWwVpBE-YARL27uvEnJTNBLaYcsXhtCKZ5H8kMvXyDJnQG8EFOS4PiJV_TDze0w2G197S9pyW2d1PW560N8lUYkhwHTk6dBOIUqQWovMQzYUbFgzM5BEzUCf07SlBKaDY78SFDErzu7XGppEgpwA4ULX4R7tnZCArMRZb7tXSecN-3r0unYdcqM2IHYmt-_w4JSvRBloxFxjC5IrSnBANkrKN5R4pUqw6Ie_5LddX6RffrsEj3QTLgaOGiBVY30ktco4qA8cR7e9BhV_JmMp1aM81GvWuJs68BYuzzfCceYtkySkyMqSPP3XBrLg4NSqGuFKPean1v9NvcQbgPBDAy45K6pAuiEJuWsVPRZCKCCREWg9jFFRG1W_2pIL36yN90vURjReF0TAAPwPlMxTKXv2f2TOPtuI.ZKcfYJvh9clpC0xxOiwR4w.a54f98dbf2bc64e49d10378516016683e70d744ceb72382d2b5b3ab93085b2f9"
    ["email_choice"] => string(1) "1"
    ["accept"] => string(1) "1"
    ["reg_key"] => string(16) "GhqnUwb5IvTQreL4"
    ["1b1c57545393a68b4d32635d8adda23558f7f957"] => string(16) "Europe/Amsterdam"
    ["_xfRequestUri"] => string(44) "/themen/kein-hydraulikdruck-zetor-5245.6417/"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

It seem there is something missing at database:
Unknown column 'andrew_reg_country' in 'field list'
Is there a way to fix it manual ?

AndrewSimm · Mar 9, 2024

otto said:

Add-on 1.9.2 but the same error:

Code:

Fehlermeldung des Servers
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'andrew_reg_country' in 'field list' src/XF/Db/AbstractStatement.php:230
Generiert durch: Unbekanntes Benutzerkonto 9.03.2024 um 14:29 Uhr
Stapelverfolgung
UPDATE  `xf_user` SET `andrew_reg_country` = ? WHERE `user_id` = 4429
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(40): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(323): XF\Db\AbstractAdapter->query('UPDATE  `xf_use...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1362): XF\Db\AbstractAdapter->update('xf_user', Array, '`user_id` = 442...')
#6 src/addons/Andrew/ModeratorPanel/XF/Entity/User.php(602): XF\Mvc\Entity\Entity->fastUpdate('andrew_reg_coun...', 'Germany')
#7 src/XF/Mvc/Entity/Entity.php(1282): Andrew\ModeratorPanel\XF\Entity\User->_postSave()
#8 src/XF/Service/User/Registration.php(306): XF\Mvc\Entity\Entity->save()
#9 src/addons/OzzModz/UserRegistrationRefererLog/XF/Service/User/Registration.php(34): XF\Service\User\Registration->_save()
#10 src/XF/Service/ValidateAndSavableTrait.php(42): OzzModz\UserRegistrationRefererLog\XF\Service\User\Registration->_save()
#11 src/XF/Pub/Controller/Register.php(429): XF\Service\User\Registration->save()
#12 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#13 src/XF/Mvc/Dispatcher.php(258): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(Andy\CountryAccessCheck\XF\Pub\Controller\Register), NULL)
#14 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Andy\CountryAccessCheck\XF\Pub\Controller\Register), NULL)
#15 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#17 src/XF.php(524): XF\App->run()
#18 index.php(20): XF::runApp('XF\\Pub\\App')
#19 {main}
Benötigter Status
array(4) {
  ["url"] => string(18) "/register/register"
  ["referrer"] => string(70) "https://www.zetor-forum.de/themen/kein-hydraulikdruck-zetor-5245.6417/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(19) {
    ["_xfToken"] => string(8) "********"
    ["username"] => string(0) ""
    ["7b9e62259a286d02f4eb835dd7fa965f047394d3"] => string(9) "RostPilot"
    ["31ab999a837996e473466b37b73266bd08883cb4"] => string(24) "theokunick2003@gmail.com"
    ["password"] => string(8) "********"
    ["71f144a176b37b1f6f3ad3822db705c13f24b887"] => string(8) "********"
    ["dob_month"] => string(1) "2"
    ["dob_day"] => string(2) "10"
    ["dob_year"] => string(4) "2003"
    ["location"] => string(19) "Rabenstein/Fläming"
    ["custom_fields"] => array(3) {
      ["rufname"] => string(4) "Theo"
      ["meinezetor"] => string(27) "Zetor 5211
Bautz 300
RS09"
      ["anderetechnik"] => string(0) ""
    }
    ["cf-turnstile-response"] => string(581) "0.YLe3NnCeReYpR_KgBxN6amk9f1UI_i8Ts1psgLx_48j6zhRx4sRmxTwgqLfq88iZnykZu0NgesCxWwVpBE-YARL27uvEnJTNBLaYcsXhtCKZ5H8kMvXyDJnQG8EFOS4PiJV_TDze0w2G197S9pyW2d1PW560N8lUYkhwHTk6dBOIUqQWovMQzYUbFgzM5BEzUCf07SlBKaDY78SFDErzu7XGppEgpwA4ULX4R7tnZCArMRZb7tXSecN-3r0unYdcqM2IHYmt-_w4JSvRBloxFxjC5IrSnBANkrKN5R4pUqw6Ie_5LddX6RffrsEj3QTLgaOGiBVY30ktco4qA8cR7e9BhV_JmMp1aM81GvWuJs68BYuzzfCceYtkySkyMqSPP3XBrLg4NSqGuFKPean1v9NvcQbgPBDAy45K6pAuiEJuWsVPRZCKCCREWg9jFFRG1W_2pIL36yN90vURjReF0TAAPwPlMxTKXv2f2TOPtuI.ZKcfYJvh9clpC0xxOiwR4w.a54f98dbf2bc64e49d10378516016683e70d744ceb72382d2b5b3ab93085b2f9"
    ["email_choice"] => string(1) "1"
    ["accept"] => string(1) "1"
    ["reg_key"] => string(16) "GhqnUwb5IvTQreL4"
    ["1b1c57545393a68b4d32635d8adda23558f7f957"] => string(16) "Europe/Amsterdam"
    ["_xfRequestUri"] => string(44) "/themen/kein-hydraulikdruck-zetor-5245.6417/"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

It seem there is something missing at database:
Unknown column 'andrew_reg_country' in 'field list'
Is there a way to fix it manual ?

Easiest way is to uninstall and then reinstall the addon if your first install was 1.9.1.

otto · Mar 9, 2024

First one was 1.8.0 and works like a charm, then since 1.9.1 the error messages.
I will try to deinstall it and the reinstall. Thanks.

otto · Mar 9, 2024

Its working now. (1.9.2)

A question please - whats the different?

Mxrcy · Mar 9, 2024

AndrewSimm said:
No within this add-on. What is the use case you are thinking of?

We Use Xenforo for a FiveM server, and we need some non admins to be able to edit certain user groups

AndrewSimm · Mar 10, 2024

Mxrcy said:
We Use Xenforo for a FiveM server, and we need some non admins to be able to edit certain user groups

You can accomplish this already for this add-on. Typically primary groups are not changed and secondary groups are used to control permissions.

AndrewSimm · Mar 10, 2024

otto said:
Its working now. (1.9.2)

A question please - whats the different?
View attachment 299398

That is a bug. The first mention should be Search user state. It will be fixed in the next version.

KSA · Mar 10, 2024

I am also getting this error on latest release

Code:

InvalidArgumentException: Attempted to convert NULL to string/binary [andrew_reg_country] src/XF/Mvc/Entity/Entity.php:775
Generated by: . Mar 10, 2024 at 5:45 AM
Stack trace
#0 src/XF/Mvc/Entity/Entity.php(697): XF\Mvc\Entity\Entity->_castValueToType(NULL, 'andrew_reg_coun...', 5, Array)
#1 src/addons/NF/Tickets/ControllerPlugin/Ticket.php(64): XF\Mvc\Entity\Entity->setTrusted('andrew_reg_coun...', NULL)
#2 src/addons/NF/Tickets/Pub/Controller/AbstractTicketController.php(23): NF\Tickets\ControllerPlugin\Ticket->preDispatchForTicket(false, 'Index', Object(XF\Mvc\ParameterBag))
#3 src/XF/Mvc/Controller.php(126): NF\Tickets\Pub\Controller\AbstractTicketController->preDispatchType('Index', Object(XF\Mvc\ParameterBag))
#4 src/XF/Mvc/Dispatcher.php(351): XF\Mvc\Controller->preDispatch('Index', Object(XF\Mvc\ParameterBag))
#5 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('NF\\Tickets:Tick...', 'Index', Object(XF\Mvc\RouteMatch), Object(NF\Tickets\Pub\Controller\Ticket), NULL)
#6 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(NF\Tickets\Pub\Controller\Ticket), NULL)
#7 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#8 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#9 src/XF.php(524): XF\App->run()
#10 index.php(20): XF::runApp('XF\\Pub\\App')
#11 {main}

-------------

Previous InvalidArgumentException: Attempted to convert NULL to string/binary - src/XF/Mvc/Entity/ValueFormatter.php:138
#0 src/XF/Mvc/Entity/Entity.php(771): XF\Mvc\Entity\ValueFormatter->castValueToType(NULL, 5, Array)
#1 src/XF/Mvc/Entity/Entity.php(697): XF\Mvc\Entity\Entity->_castValueToType(NULL, 'andrew_reg_coun...', 5, Array)
#2 src/addons/NF/Tickets/ControllerPlugin/Ticket.php(64): XF\Mvc\Entity\Entity->setTrusted('andrew_reg_coun...', NULL)
#3 src/addons/NF/Tickets/Pub/Controller/AbstractTicketController.php(23): NF\Tickets\ControllerPlugin\Ticket->preDispatchForTicket(false, 'Index', Object(XF\Mvc\ParameterBag))
#4 src/XF/Mvc/Controller.php(126): NF\Tickets\Pub\Controller\AbstractTicketController->preDispatchType('Index', Object(XF\Mvc\ParameterBag))
#5 src/XF/Mvc/Dispatcher.php(351): XF\Mvc\Controller->preDispatch('Index', Object(XF\Mvc\ParameterBag))
#6 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('NF\\Tickets:Tick...', 'Index', Object(XF\Mvc\RouteMatch), Object(NF\Tickets\Pub\Controller\Ticket), NULL)
#7 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(NF\Tickets\Pub\Controller\Ticket), NULL)
#8 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#9 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#10 src/XF.php(524): XF\App->run()
#11 index.php(20): XF::runApp('XF\\Pub\\App')
#12 {main}

AndrewSimm · Mar 10, 2024

KSA said:

I am also getting this error on latest release

Code:

InvalidArgumentException: Attempted to convert NULL to string/binary [andrew_reg_country] src/XF/Mvc/Entity/Entity.php:775
Generated by: . Mar 10, 2024 at 5:45 AM
Stack trace
#0 src/XF/Mvc/Entity/Entity.php(697): XF\Mvc\Entity\Entity->_castValueToType(NULL, 'andrew_reg_coun...', 5, Array)
#1 src/addons/NF/Tickets/ControllerPlugin/Ticket.php(64): XF\Mvc\Entity\Entity->setTrusted('andrew_reg_coun...', NULL)
#2 src/addons/NF/Tickets/Pub/Controller/AbstractTicketController.php(23): NF\Tickets\ControllerPlugin\Ticket->preDispatchForTicket(false, 'Index', Object(XF\Mvc\ParameterBag))
#3 src/XF/Mvc/Controller.php(126): NF\Tickets\Pub\Controller\AbstractTicketController->preDispatchType('Index', Object(XF\Mvc\ParameterBag))
#4 src/XF/Mvc/Dispatcher.php(351): XF\Mvc\Controller->preDispatch('Index', Object(XF\Mvc\ParameterBag))
#5 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('NF\\Tickets:Tick...', 'Index', Object(XF\Mvc\RouteMatch), Object(NF\Tickets\Pub\Controller\Ticket), NULL)
#6 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(NF\Tickets\Pub\Controller\Ticket), NULL)
#7 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#8 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#9 src/XF.php(524): XF\App->run()
#10 index.php(20): XF::runApp('XF\\Pub\\App')
#11 {main}

-------------

Previous InvalidArgumentException: Attempted to convert NULL to string/binary - src/XF/Mvc/Entity/ValueFormatter.php:138
#0 src/XF/Mvc/Entity/Entity.php(771): XF\Mvc\Entity\ValueFormatter->castValueToType(NULL, 5, Array)
#1 src/XF/Mvc/Entity/Entity.php(697): XF\Mvc\Entity\Entity->_castValueToType(NULL, 'andrew_reg_coun...', 5, Array)
#2 src/addons/NF/Tickets/ControllerPlugin/Ticket.php(64): XF\Mvc\Entity\Entity->setTrusted('andrew_reg_coun...', NULL)
#3 src/addons/NF/Tickets/Pub/Controller/AbstractTicketController.php(23): NF\Tickets\ControllerPlugin\Ticket->preDispatchForTicket(false, 'Index', Object(XF\Mvc\ParameterBag))
#4 src/XF/Mvc/Controller.php(126): NF\Tickets\Pub\Controller\AbstractTicketController->preDispatchType('Index', Object(XF\Mvc\ParameterBag))
#5 src/XF/Mvc/Dispatcher.php(351): XF\Mvc\Controller->preDispatch('Index', Object(XF\Mvc\ParameterBag))
#6 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('NF\\Tickets:Tick...', 'Index', Object(XF\Mvc\RouteMatch), Object(NF\Tickets\Pub\Controller\Ticket), NULL)
#7 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(NF\Tickets\Pub\Controller\Ticket), NULL)
#8 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#9 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#10 src/XF.php(524): XF\App->run()
#11 index.php(20): XF::runApp('XF\\Pub\\App')
#12 {main}

Can you explain your version history before 1.9.2?

KSA · Mar 10, 2024

AndrewSimm said:
Can you explain your version history before 1.9.2?

1.8 then upgraded to 1.9.2

AndrewSimm · Mar 10, 2024

KSA said:
1.8 then upgraded to 1.9.2

Can you paste the error message?

Did you receive this after installing or after someone registered?

Also, if when registering, when API are you using if any.

AndrewSimm · Mar 10, 2024

This is my first user from the UK since creating the feature. Looks like I got some work today on layout.

Screen Shot 2024-03-10 at 7.53.06 PM.webp

AndrewSimm · Mar 11, 2024

AndrewSimm updated [Andrew] Moderator Panel with a new update entry:

Version 1.9.3

FIXED: Search user state was named search staff state in permissions
FIXED: Missing drop of andrew_reg_country column on uninstall

Read the rest of this update entry...

[Andrew] Moderator Panel 2.0.9

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Similar threads

We value your privacy