kenson
Customer
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:
Unsure what's causing this. Here's the rest of the error details:
Stack Trace
Request State
Disabling addon until we can get to figuring this out, so I can still post on my own site.
I get the following error when posting a thread:
Code:
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
Code:
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
Code:
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.