Question Invalid Query Exception When Posting

[kenson]

This is a fresh, literal brand new install (only installed it like 20 minutes ago). I've already ran "Rebuild Master Data" and that did not fix it. I am running XenForo 2.2.12.

I get the following error when posting a thread:

XF\Db\InvalidQueryException: MySQL statement prepare error [1064]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-bones = GREATEST(0, dbcredits_dino-bones + ?) WHERE user_id = ?' at line 2
src/XF/Db/AbstractStatement.php:230

Unsure what's causing this. Here's the rest of the error details:

Stack Trace

                    UPDATE xf_user
                    SET dbcredits_dino-bones = GREATEST(0, dbcredits_dino-bones + ?)
                    WHERE user_id = ?
               
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1064, '42000')
#1 src/XF/Db/Mysqli/Statement.php(41): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1064, '42000')
#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/addons/DBTech/Credits/Entity/Transaction.php(197): XF\Db\AbstractAdapter->query('
                    UPDATE xf...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1277): DBTech\Credits\Entity\Transaction->_postSave()
#6 src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php(597): XF\Mvc\Entity\Entity->save(true, false)
#7 src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php(444): DBTech\Credits\EventTrigger\AbstractHandler->trigger(Object(SV\AdvancedBbCodesPack\XF\Entity\User), 202, false, Object(ArrayObject))
#8 src/addons/DBTech/Credits/XF/Service/Post/Preparer.php(275): DBTech\Credits\EventTrigger\AbstractHandler->apply(202, Array, Object(SV\AdvancedBbCodesPack\XF\Entity\User))
#9 src/XF/Service/Thread/Creator.php(497): DBTech\Credits\XF\Service\Post\Preparer->afterInsert()
#10 src/addons/DigitalPoint/Analytics/XF/Service/Thread/Creator.php(9): XF\Service\Thread\Creator->_save()
#11 src/addons/Snog/Actions/XF/Service/Thread/Creator.php(9): DigitalPoint\Analytics\XF\Service\Thread\Creator->_save()
#12 src/XF/Service/ValidateAndSavableTrait.php(42): Snog\Actions\XF\Service\Thread\Creator->_save()
#13 src/XF/Pub/Controller/Forum.php(920): XF\Service\Thread\Creator->save()
#14 src/addons/XFA/ThreadTemplate/XF/Pub/Controller/Forum.php(19): XF\Pub\Controller\Forum->actionPostThread(Object(XF\Mvc\ParameterBag))
#15 src/XF/Mvc/Dispatcher.php(352): XFA\ThreadTemplate\XF\Pub\Controller\Forum->actionPostThread(Object(XF\Mvc\ParameterBag))
#16 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Forum', 'PostThread', Object(XF\Mvc\RouteMatch), Object(SV\StandardLib\XF\Pub\Controller\Forum), NULL)
#17 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\StandardLib\XF\Pub\Controller\Forum), NULL)
#18 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#19 src/XF/App.php(2483): XF\Mvc\Dispatcher->run()
#20 src/XF.php(524): XF\App->run()
#21 index.php(20): XF::runApp('XF\\Pub\\App')
#22 {main}

Request State

array(4) {
  ["url"] => string(34) "/forums/important-info/post-thread"
  ["referrer"] => string(59) "https://mesozoichaven.com/forums/important-info/post-thread"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(15) {
    ["_xfToken"] => string(8) "********"
    ["prefix_id"] => string(1) "0"
    ["title"] => string(23) "How To Earn Dino Bones!"
    ["discussion_type"] => string(7) "article"
    ["message_html"] => string(2280) "<p>We have added a credit system to our site! You can earn Dino Bones just by participating on the site! Every 1000 Bones is worth roughly $1. It takes 5000 Bones to earn 1 month access to our private community game servers. Public ones remain accessible to all.</p><p><br></p><h1 class="bbc-header">Earning Dino Bones</h1><ul><li><strong>Registration:</strong> Earn a bonus of 100 upon Registering</li><li><strong>Avatar Upload:</strong> Earn a bonus of 100 upon updating your avatar (once per month max)</li><li><strong>Daily Login Bonus:</strong> 10</li><li><strong>BDay Bonus:</strong> 1000</li><li style="font-weight: bold;"><strong>Per Post Reply</strong><ul style="font-weight: initial;"><li><strong>To Own Thread:</strong> 1 | 25+ chars: 0.01/char</li><li><strong>To Other Thread:</strong> 2 | 25 chars: 0.02/char</li></ul></li><li><strong>Per Thread:</strong> 10<ul><li>Requires 200 Chars to get—roughly 3 sentences or so.</li></ul></li><li><strong>Media Gallery Upload:</strong> 50<ul><li><strong>Media Gallery Comment:</strong> 5<ul><li>Bonus 0.01/char after 10 chars.</li></ul></li></ul></li><li><strong>Poll Creation (minimum 3 options):</strong> 10<ul><li><strong>Per option after 3:</strong> 2 Bones</li></ul></li><li><strong>Reaction Received (receiver):</strong> 5</li><li><strong>Reaction Sent (sender):</strong> 0</li><li style="font-weight: bold;"><strong>Real Money Purchases (this can allow you to spend $5 USD to get a month without taking the time to post):</strong><ul style="font-weight: initial;"><li>$1 USD - 1,000 Bones</li><li>$5 USD - 5,000 Bones</li><li>$10 USD - 10,000 Bones</li><li>$25 USD - 25,000 Bones</li><li>$50 USD - 50,000 Bones</li><li>$100 USD - 100,000 Bones</li></ul></li></ul><h1 class="bbc-header">Losing Dino Bones</h1><ul><li><strong>Sending Bones To Other Users:<br></strong><ul><li>This can be a nice option for many things, including for getting help with something IRL or in-game. Both parties would have to work out Bones payment details.</li></ul></li><li><strong>Purchasing a month of private game server access:</strong> Send @KensonPlays 5000 Bones and DM with <a href="https://steamidfinder.com/" rel="noopener noreferrer" target="_blank">Steam 64ID</a>/Username (other platforms)/Alderon Games ID (9 digit).</li></ul>"
    ["attachment_hash"] => string(32) "8c2f6ffc360185d75ecc06f88f2a79da"
    ["attachment_hash_combined"] => string(82) "{"type":"post","context":{"node_id":69},"hash":"8c2f6ffc360185d75ecc06f88f2a79da"}"
    ["tags"] => string(0) ""
    ["watch_thread"] => string(1) "1"
    ["watch_thread_email"] => string(1) "1"
    ["_xfSet"] => array(3) {
      ["watch_thread"] => string(1) "1"
      ["discussion_open"] => string(1) "1"
      ["sticky"] => string(1) "1"
    }
    ["sticky"] => string(1) "1"
    ["_xfRequestUri"] => string(34) "/forums/important-info/post-thread"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

Disabling addon until we can get to figuring this out, so I can still post on my own site.

 

[Fillip H.]

This is because you created your currency column with a dash in it. You have to change it to an underscore.

 

[kenson]

AH, cause normally I'll name things like this:

"test-name_date-here" and similar. That's how I normally name things so I tried it the way I normally do. Thanks.

 

[DragonByte Technologies]

Hello @kenson,

We hope your ticket regarding DragonByte Credits 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 @kenson,

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