Thanks for reporting!
Awesome work guys, thanks!
I'd like to suggest an option to make credits packages giftable.
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'adcredit_shop_postbit_icons' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, A moment ago
Stack Trace
#0 /var/www/twd/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /var/www/twd/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /var/www/twd/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /var/www/twd/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /var/www/twd/library/XenForo/DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
#5 /var/www/twd/library/XenForo/DataWriter.php(1613): XenForo_DataWriter->_insert()
#6 /var/www/twd/library/XenForo/DataWriter.php(1405): XenForo_DataWriter->_save()
#7 /var/www/twd/library/XenForo/ControllerPublic/Register.php(416): XenForo_DataWriter->save()
#8 /var/www/twd/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_Register->actionRegister()
#9 /var/www/twd/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /var/www/twd/index.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
["url"] => string(43) "https://twowheeldemon.com/register/register"
["_GET"] => array(1) {
["/register/register"] => string(0) ""
}
["_POST"] => array(18) {
["username"] => string(0) ""
["7f0aa43b9456dacf8b2ae9458a638c62"] => string(5) "test_user"
["bdefc785e5a2396bf242e16b387bc992"] => string(21) "***************"
["password"] => string(8) "********"
["bd3b73e2639bf341d42ebf18ee21e839"] => string(0) ""
["dob_month"] => string(2) "10"
["dob_day"] => string(2) "22"
["dob_year"] => string(4) "1963"
["4ddf1839303382e4c2ea6578f01d0e54"] => array(12) {
["yrsriding"] => string(1) "D"
["yearmodel"] => string(4) "2005"
["brandbike"] => array(1) {
[0] => string(1) "G"
}
["bikemodel"] => string(6) "ST1300"
["Flickr"] => string(0) ""
["YouTube"] => string(0) ""
["skype"] => string(0) ""
["gtalk"] => string(0) ""
["facebook"] => string(0) ""
["GooglePlus"] => string(0) ""
["twitter"] => string(0) ""
["exjzcmlkaw5n"] => string(0) ""
}
["custom_fields_shown"] => array(19) {
[0] => string(9) "yrsriding"
[1] => string(9) "yearmodel"
[2] => string(9) "brandbike"
[3] => string(9) "bikemodel"
[4] => string(9) "darksider"
[5] => string(3) "hog"
[6] => string(5) "gwrra"
[7] => string(10) "gwta_group"
[8] => string(12) "leather_lace"
[9] => string(12) "patriotguard"
[10] => string(6) "Flickr"
[11] => string(7) "YouTube"
[12] => string(5) "skype"
[13] => string(5) "gtalk"
[14] => string(8) "facebook"
[15] => string(10) "GooglePlus"
[16] => string(7) "twitter"
[17] => string(7) "nsfw_ok"
[18] => string(12) "exjzcmlkaw5n"
}
["321de898ce12727f4235422d8cfdd2e4"] => string(15) "America/Chicago"
["slidercaptcha_validate_time"] => string(10) "1426625000"
["slidercaptcha_validate_hash"] => string(40) "33aacba6ba7c0f6163cb241294e6bd2c1866b30f"
["slidercaptcha_loaded"] => string(4) "true"
["slidercaptcha_fallback"] => string(9) "ReCaptcha"
["agree"] => string(1) "1"
["_xfToken"] => string(8) "********"
["reg_key"] => string(32) "8f6771adb7a7a34fa171ca79f0398bb9"
}
}Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'active' in 'where clause' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Elrod, Today at 1:12 PM
Stack Trace
#0 /var/www/twd/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\tSELECT *\n\t\t...')
#1 /var/www/twd/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\tSELECT *\n\t\t...')
#2 /var/www/twd/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\tSELECT *\n\t\t...')
#3 /var/www/twd/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\n\t\t\tSELECT *\n\t\t...', Array, 2)
#4 /var/www/twd/library/Audentio/Credit/Shop/Model/Category.php(20): XenForo_Model->fetchAllKeyed('\n\t\t\tSELECT *\n\t\t...', 'category_id')
#5 /var/www/twd/library/Audentio/Credit/Shop/ControllerPublic/Category.php(9): Audentio_Credit_Shop_Model_Category->getActiveCategories()
#6 /var/www/twd/library/XenForo/FrontController.php(347): Audentio_Credit_Shop_ControllerPublic_Category->actionIndex()
#7 /var/www/twd/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 /var/www/twd/index.php(13): XenForo_FrontController->run()
#9 {main}
Request State
array(3) {
["url"] => string(50) "https://twowheeldemon.com/adcreditshop-categories/"
["_GET"] => array(1) {
["/adcreditshop-categories/"] => string(0) ""
}
["_POST"] => array(0) {
}
}ErrorException: Undefined index: send_alert - library/Audentio/Credit/Core/Event.php:66
Generated By: Elrod, Today at 10:21 AM
Stack Trace
#0 /var/www/twd/library/Audentio/Credit/Core/Event.php(66): XenForo_Application::handlePhpError(8, 'Undefined index...', '/var/www/twd/li...', 66, Array)
#1 /var/www/twd/library/Audentio/Credit/Core/ControllerPublic/Thread.php(13): Audentio_Credit_Core_Event::run('post', Object(DailyStats_ControllerPublic_Thread), 'after', Array)
#2 /var/www/twd/library/XenForo/FrontController.php(347): Audentio_Credit_Core_ControllerPublic_Thread->actionAddReply()
#3 /var/www/twd/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#4 /var/www/twd/index.php(13): XenForo_FrontController->run()
#5 {main}
Request State
array(3) {
["url"] => string(51) "https://twowheeldemon.com/i-spy-game.t177/add-reply"
["_GET"] => array(1) {
["/i-spy-game_t177/add-reply"] => string(0) ""
}
["_POST"] => array(11) {
["message_html"] => string(28) "<p>Curb</p><p>Canopy<br></p>"
["_xfRelativeResolver"] => string(50) "https://twowheeldemon.com/i-spy-game.t177/page-175"
["_bdSocialShare_enabled"] => array(1) {
["_default"] => string(1) "1"
}
["_bdSocialShare_included"] => string(1) "1"
["attachment_hash"] => string(32) "725f03e597cbd8239db447686cfdfe8a"
["last_date"] => string(10) "1426584303"
["last_known_date"] => string(10) "1426584303"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(25) "/i-spy-game.t177/page-175"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
ALTER TABLE `adcredit_shop_product` ADD `max_active_purchases` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `purchases`;
ALTER TABLE `adcredit_shop_product` ADD `quantity` INT(11) NOT NULL DEFAULT '-1' AFTER `max_active_purchases`;
ALTER TABLE `adcredit_shop_product` ADD `giftable` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `active`;
ALTER TABLE `adcredit_shop_category` ADD `active` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1' ;
ALTER TABLE `adcredit_shop_product` ADD `display_on_postbit` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `active`;
ALTER TABLE `adcredit_shop_product` ADD `display_on_profile_view` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `display_on_postbit`;
ALTER TABLE `xf_user` ADD `adcredit_shop_postbit_icons` BLOB NOT NULL ;
ALTER TABLE `xf_user` ADD `adcredit_shop_profile_icons` BLOB NOT NULL ;
ALTER TABLE `adcredit_action` ADD `send_alert` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
array(3) {
["url"] => string(211) "https://xxxxxx.xxx/members/xxxxxxxxxxxx.59765/recent-content?_xfRequestUri=%2Fmembers%2Fxxxxxxxxxxxxxx.59765%2F&_xfNoRedirect=1&_xfToken=1%2C1426798341%2C68fb83c47bfbd5c08cc191608f5f5592e0a94619&_xfResponseType=json"
["_GET"] => array(4) {
["_xfRequestUri"] => string(26) "/members/xxxxxxxxx.59765/"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(53) "1,1426798341,68fb83c47bfbd5c08cc191608f5f5592e0a94619"
["_xfResponseType"] => string(4) "json"
}
["_POST"] => array(0) {
}
}