Bug Incorrect column name

[DimitryMarvel]

From server error log.

XF\Db\InvalidQueryException: xf_user: MySQL query error [1166]: Incorrect column name '' src/XF/Db/AbstractStatement.php:228

ALTER TABLE `xf_user`
ADD `` DECIMAL(65,8) NOT NULL DEFAULT '0'
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException()
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException()
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/Schema/AbstractDdl.php(151): XF\Db\AbstractAdapter->query()
#4 src/XF/Db/SchemaManager.php(149): XF\Db\Schema\AbstractDdl->apply()
#5 src/addons/DBTech/Shop/Entity/Currency.php(364): XF\Db\SchemaManager->alterTable()
#6 src/XF/Mvc/Entity/Entity.php(1355): DBTech\Shop\Entity\Currency->_preSave()
#7 src/XF/Mvc/FormAction.php(51): XF\Mvc\Entity\Entity->preSave()
#8 src/XF/Mvc/FormAction.php(168): XF\Mvc\FormAction->XF\Mvc\{closure}()
#9 src/addons/DBTech/Shop/Admin/Controller/Currency.php(149): XF\Mvc\FormAction->run()
#10 src/XF/Mvc/Dispatcher.php(350): DBTech\Shop\Admin\Controller\Currency->actionSave()
#11 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass()
#12 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch()
#13 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop()
#14 src/XF/App.php(2300): XF\Mvc\Dispatcher->run()
#15 src/XF.php(465): XF\App->run()
#16 admin.php(13): XF::runApp()
#17 {main}

array(4) {
  ["url"] => string(40) "/admin.php?dbtech-shop/currencies/0/save"
  ["referrer"] => string(53) "***/admin.php?dbtech-shop/currencies/add"
  ["_GET"] => array(1) {
    ["dbtech-shop/currencies/0/save"] => string(0) ""
  }
  ["_POST"] => array(23) {
    ["title"] => string(7) "Dollars"
    ["description_html"] => string(0) ""
    ["display_order"] => string(2) "10"
    ["active"] => string(1) "1"
    ["credits_currency_id"] => string(0) ""
    ["column"] => string(0) ""
    ["decimals"] => string(1) "0"
    ["privacy"] => string(1) "2"
    ["prefix"] => string(0) ""
    ["suffix"] => string(0) ""
    ["sidebar"] => string(1) "1"
    ["postbit"] => string(1) "1"
    ["can_bank"] => string(1) "1"
    ["interest"] => string(1) "0"
    ["can_steal"] => string(1) "1"
    ["can_trade"] => string(1) "1"
    ["customshops"] => string(1) "1"
    ["per_thread"] => string(1) "5"
    ["per_reply"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(37) "/admin.php?dbtech-shop/currencies/add"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

 

[Fillip H.]

Did you forget to add a column when submitting the form?

I'll add protection from this in a future version.

 

[DimitryMarvel]

I don't know, this was other admin. I've seen it in server error log.

 

[Fillip H.]

User error on the admin's part

For the future, can you please post the error message in the post rather than the title? The title should be a very short summary of the issue, and the post body should contain the error message.

 

[DragonByte Technologies]

Thank you for reporting this issue, it has now been resolved. We are aiming to include any changes that have been made in a future release (6.4.2).

Change log:

Fix: Made the "Currency column" field required in the templates to prevent a server error from being logged

 

[DragonByte Technologies]

Hello @DimitryMarvel,

We hope your ticket regarding DragonByte Shop has been addressed to your satisfaction. This ticket has now been scheduled to be 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.


- DragonByte Technologies, Ltd.

 

[DragonByte Technologies]

Hello @DimitryMarvel,

As we have not heard back from you, your ticket regarding DragonByte Shop 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.


- DragonByte Technologies, Ltd.