Thom Tyler
Well-known member
Wow - amazed there's no patch for this yet. I guess I'll be waiting until this matures a little.
Can you release an update?
<?php
class Audentio_Credit_Shop_DataWriter_User extends XFCP_Audentio_Credit_Shop_DataWriter_User
{
protected function _getFields()
{
$fields = parent::_getFields();
$fields['xf_user']['adcredit_shop_postbit_icons'] = array('type' => self::TYPE_SERIALIZED, 'default' => 'a:0:{}');
$fields['xf_user']['adcredit_shop_profile_icons'] = array('type' => self::TYPE_SERIALIZED, 'default' => 'a:0:{}');
return $fields;
}
public function setInventoryIconCache(array $cache)
{
foreach ($cache as $key=>$value)
{
$this->set($key, @serialize($value));
}
}
}
Wow - amazed there's no patch for this yet. I guess I'll be waiting until this matures a little.
I'm not able to replicate the issue. I sent @SneakyDave a possible fix, but haven't gotten a response yet. Are you getting this error also? If so try replacing library/Audentio/Credit/Core/DataWriter/User.php with the following:
Code:<?php class Audentio_Credit_Shop_DataWriter_User extends XFCP_Audentio_Credit_Shop_DataWriter_User { protected function _getFields() { $fields = parent::_getFields(); $fields['xf_user']['adcredit_shop_postbit_icons'] = array('type' => self::TYPE_SERIALIZED, 'default' => 'a:0:{}'); $fields['xf_user']['adcredit_shop_profile_icons'] = array('type' => self::TYPE_SERIALIZED, 'default' => 'a:0:{}'); return $fields; } public function setInventoryIconCache(array $cache) { foreach ($cache as $key=>$value) { $this->set($key, @serialize($value)); } } }
There are no errors that I am able to replicate in the current release. Can't fix an issue I'm unable to replicate, and that only a single user has reported .
- Jake
Added compatability with [AD] Notifications for Product Purchases
Mysqli prepare error: 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 'UdataNSIGNED NOT NULL DEFAULT '0' AFTER `active`' at line 1
- Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
- Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
- Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
- Zend_Db_Adapter_Abstract->query() in Audentio/Credit/Shop/Listener/Install/1000501.php at line 22
- Audentio_Credit_Shop_Listener_Install_1000501::run() in Audentio/Credit/Shop/Listener/Install.php at line 30
- Audentio_Credit_Shop_Listener_Install::run()
- call_user_func() in XenForo/Model/AddOn.php at line 215
- XenForo_Model_AddOn->installAddOnXml() in Waindigo/CustomFields/Extend/XenForo/Model/AddOn.php at line 114
- Waindigo_CustomFields_Extend_XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
- XenForo_Model_AddOn->installAddOnXmlFromFile() in AddOnInstaller/ControllerAdmin/AddOn.php at line 272
- AddOnInstaller_ControllerAdmin_AddOn->actionInstallUpgrade() in XenForo/FrontController.php at line 347
- XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
- XenForo_FrontController->run() in /var/www/kinmunity.com/admin.php at line 13
Mysqli statement execute error : Duplicate column name 'display_on_profile_inventory'
Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Audentio/Credit/Shop/Listener/Install/1000472.php at line 16
Audentio_Credit_Shop_Listener_Install_1000472::run() in Audentio/Credit/Shop/Listener/Install.php at line 30
Audentio_Credit_Shop_Listener_Install::run()
call_user_func() in XenForo/Model/AddOn.php at line 215
XenForo_Model_AddOn->installAddOnXml() in ConvEss/Model/AddOn.php at line 24
ConvEss_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 236
XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /var/www/vhosts/wweforums.net/httpdocs/admin.php at line 13
I can't update again,
Code:Mysqli statement execute error : Duplicate column name 'display_on_profile_inventory' Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297 Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479 Zend_Db_Adapter_Abstract->query() in Audentio/Credit/Shop/Listener/Install/1000472.php at line 16 Audentio_Credit_Shop_Listener_Install_1000472::run() in Audentio/Credit/Shop/Listener/Install.php at line 30 Audentio_Credit_Shop_Listener_Install::run() call_user_func() in XenForo/Model/AddOn.php at line 215 XenForo_Model_AddOn->installAddOnXml() in ConvEss/Model/AddOn.php at line 24 ConvEss_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169 XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 236 XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 347 XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134 XenForo_FrontController->run() in /var/www/vhosts/wweforums.net/httpdocs/admin.php at line 13
I can't update again,
Code:Mysqli statement execute error : Duplicate column name 'display_on_profile_inventory' Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297 Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479 Zend_Db_Adapter_Abstract->query() in Audentio/Credit/Shop/Listener/Install/1000472.php at line 16 Audentio_Credit_Shop_Listener_Install_1000472::run() in Audentio/Credit/Shop/Listener/Install.php at line 30 Audentio_Credit_Shop_Listener_Install::run() call_user_func() in XenForo/Model/AddOn.php at line 215 XenForo_Model_AddOn->installAddOnXml() in ConvEss/Model/AddOn.php at line 24 ConvEss_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169 XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 236 XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 347 XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134 XenForo_FrontController->run() in /var/www/vhosts/wweforums.net/httpdocs/admin.php at line 13
I still get this exact error trying to update from 1.0.4 P1.
Mysqli prepare error: 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 '-20, 20' at line 6
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in Audentio/Credit/Core/Model/ActionLog.php at line 24
Audentio_Credit_Core_Model_ActionLog->getLog() in Audentio/Credit/Core/ControllerAdmin/ActionLog.php at line 19
Audentio_Credit_Core_ControllerAdmin_ActionLog->actionIndex() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/path/public_html/site/admin.php at line 13
I also had the error so uninstalled and reinstalled both core and shop with the latest versions, but on the action log page I still get that:
ThanksCode:Mysqli prepare error: 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 '-20, 20' at line 6 Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115 Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381 Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478 Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219 XenForo_Model->fetchAllKeyed() in Audentio/Credit/Core/Model/ActionLog.php at line 24 Audentio_Credit_Core_Model_ActionLog->getLog() in Audentio/Credit/Core/ControllerAdmin/ActionLog.php at line 19 Audentio_Credit_Core_ControllerAdmin_ActionLog->actionIndex() in XenForo/FrontController.php at line 347 XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134 XenForo_FrontController->run() in /home/path/public_html/site/admin.php at line 13
We use essential cookies to make this site work, and optional cookies to enhance your experience.