Credits Premium [Paid] [Deleted]

Status
Not open for further replies.
Appears brc_points is breaking the ability for people to register

Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'brc_points' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, 1 minute ago
Stack Trace
#0 /var/www/vhosts/website.com/httpdocs/website.com/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /var/www/vhosts/website.com/httpdocs/website.com/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /var/www/vhosts/website.com/httpdocs/website.com/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /var/www/vhosts/website.com/httpdocs/website.com/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /var/www/vhosts/website.com/httpdocs/website.com/library/XenForo/DataWriter.php(1612): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
#5 /var/www/vhosts/website.com/httpdocs/website.com/library/XenForo/DataWriter.php(1601): XenForo_DataWriter->_insert()
#6 /var/www/vhosts/website.com/httpdocs/website.com/library/XenForo/DataWriter.php(1393): XenForo_DataWriter->_save()
#7 /var/www/vhosts/website.com/httpdocs/website.com/library/*******/Credits/DataWriter/User.php(18): XenForo_DataWriter->save()
#8 /var/www/vhosts/website.com/httpdocs/website.com/library/XenForo/ControllerPublic/Register.php(294): *******_Credits_DataWriter_User->save()
#9 /var/www/vhosts/website.com/httpdocs/website.com/library/Tac/FoolBotHoneyPot/ControllerPublic/Register.php(720): XenForo_ControllerPublic_Register->actionRegister()
#10 /var/www/vhosts/website.com/httpdocs/website.com/library/Nobita/AccountDetection/XenForo/ControllerPublic/Register.php(11): Tac_FoolBotHoneyPot_ControllerPublic_Register->actionRegister()
#11 /var/www/vhosts/website.com/httpdocs/website.com/library/*******/Credits/ControllerPublic/Register.php(18): Nobita_AccountDetection_XenForo_ControllerPublic_Register->actionRegister()
#12 /var/www/vhosts/website.com/httpdocs/website.com/library/XenForo/FrontController.php(337): *******_Credits_ControllerPublic_Register->actionRegister()
#13 /var/www/vhosts/website.com/httpdocs/website.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#14 /var/www/vhosts/website.com/httpdocs/website.com/index.php(13): XenForo_FrontController->run()
#15 {main}
Request State
array(3) {
["url"] => string(41) "http://www.website.com/register/register"
["_GET"] => array(0) {
}
["_POST"] => array(39) {
["bd2525260362111487"] => string(0) ""
["917f3526036212935b"] => string(6) "TestMe"
["79c475260362129b34"] => string(0) ""
["c9da05260362112bf8"] => string(0) ""
["username"] => string(6) "TestMe"
["3f6b252603621162a6"] => string(16) "testMe@yahoo.com"
["d73385260362114366"] => string(0) ""
["c90ed5260362113b98"] => string(0) ""
["3042e5260362130892"] => string(0) ""
["email"] => string(16) "testMe@yahoo.com"
["296c052603621283b9"] => string(0) ""
["cb56f526036211a126"] => string(0) ""
["password"] => string(8) "********"
["password_confirm"] => string(8) "********"
["005eb526036211ef4d"] => string(0) ""
["dfd2b526036211b0c5"] => string(0) ""
["4f8d25260362114b38"] => string(8) "testme11"
["94752526036211d00d"] => string(8) "testme11"
["cae46526036212e951"] => string(0) ""
["bf9cf526036212d1e2"] => string(0) ""
["dob_month"] => int(1)
["dob_day"] => int(1)
["dob_year"] => int(1980)
["400775260362121e2b"] => string(4) "male"
["gender"] => string(4) "male"
["9810e52603621254db"] => string(0) ""
["1cfb0526036210e5a9"] => string(0) ""
["0147b526036212453b"] => string(0) ""
["custom_fields_shown"] => array(1) {
[0] => string(16) "profanity_filter"
}
["timezone"] => string(14) "Asia/Hong_Kong"
["5d816526036211d7dd"] => string(14) "Asia/Hong_Kong"
["caa33526036212165d"] => string(14) "Pacific/Midway"
["330765260362111c58"] => string(14) "Pacific/Midway"
["f726f52603621206cd"] => string(14) "Pacific/Midway"
["recaptcha_challenge_field"] => string(185) "03AHJ_VutAcInRqoj9bNwtm7Jcc2SrT4mSMCQllbCAn5EQrT65jNjUdEjjvBy8iwyP4j8eGf2e5Xcn0XyG9lY36WUDVVRWYpbxVrmLoBmt9GrKweUbIrc-USJubjWtwJgnZKN0v-S9V4SM-p9LZpOo4QPpqog-G5g37TfhF9mx_vgcUUh7KYyePik"
["recaptcha_response_field"] => string(13) "58446995 1740"
["agree"] => string(1) "1"
["_xfToken"] => string(8) "********"
["reg_key"] => string(32) "af22b58336af80f99039acd4cb7cc0a8"
}
}
 
I disabled credits premium and it's fixed. Need this fixed. Luckily our site is in Beta right now.
 
Wesker said:
I disabled credits premium and it's fixed. Need this fixed. Luckily our site is in Beta right now.
Click to expand...
I have no idea why the brc_points field is missing in xf_user table but you might try going to edit the points currency and it says when saved it will create the field
brcp.webp
 
Just uncheck 'active' on the points currency. As an example of how multiple currencies are useful, I can use credits to sell resources and have users purchase credits with cash. Then I can use the points currency for non-cash based transactions like activity rewards. Which I can use for things like stock trader. Or I could have a currency just for stock trader. With cash based credits separated from non-cash currencies, I can allow users to sell resources and make cash withdrawals on credits, but not on points. And I can charge different interest rates and commissions on different currencies however I want.
 
SignTorch said:
Just uncheck 'active' on the points currency. As an example of how multiple currencies are useful, I can use credits to sell resources and have users purchase credits with cash. Then I can use the points currency for non-cash based transactions like activity rewards. Which I can use for things like stock trader. Or I could have a currency just for stock trader. With cash based credits separated from non-cash currencies, I can allow users to sell resources and make cash withdrawals on credits, but not on points. And I can charge different interest rates and commissions on different currencies however I want.
Click to expand...

Yes I understand. However with Points enabled it broke the registration process. I'm not sure how to go about fixing that.
 
I'm guessing it's because the 'brc_points' field is missing in your 'xf_user' table

if it is missing, all you have to do is go to the credits tab, then list-currency, then points, and hit save, and it will add the missing field, just make sure the column parameter is set to 'brc_points' as shown in the image above

I can confirm that registration fails if a currency exists and the field for it is missing....
 
Simple wishes.
BRC_transaction_list page improvement:
- To hide actionSelectors'Actions if the user cannot use them.
- To hide inactive currencySelector currencies.
- To hide private for special usergroups only currencySelector currencies.
- When filter currencies via currencySelector to hyde Actions in actionSelector if they are not participated in event for this currency.

Improvement: To hide sidebar links for a user that cannot use them.

Request:
The ability to name currencies with phrases.
New action: User gets points for each X number of likes of each individual message (as example 40, but not for the every one).

Selection problem:
When I open /index.php?credits/ the Top statistics of Credit is displayed. When I choose in currencySelector Credit or Point or just created currency the forum main page loads (Forums is my homepage).

BRC_transaction_list page - List transactions:
When I try to sort transactions by Action nothing happens if there is only 1 currency. When there is more than one currency if I filter individual currency and try to sort, the sort happens for all currencies but not for the selected individual one.
When I press "Go" button the <dl class="choosers"> of footer dissapears, now nobody can switch the forum language.
Nothing happens when I click to filter List Transactions with User Action, Status and Comment.
 
Last edited:
I totally like having the ability for users to transfer credits to other users, so users can pay each other in credits, so users can buy and sell content, but what's missing is a way for the seller to designate a reason and price within a link that initiates a transfer, as it is the buyer has to go make a separate transfer and note what it's for, and the seller has to solicit the buyer to do all that correctly

a initiate-credit-transfer-link would make it much simpler for users to solicit credit payments for various reasons
 
Can this work with the trophies system? I want to give trophies to people who reaches 1 million posts for example.
 
How do you turn off the option where it provides ALERTS every time you receive a credit added to your account for doing something?
 
I got a blank page when I tried to import from trophy point. Do I need to do anything else before importing?
 
I got this:
Code: 
ErrorException: Fatal Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) - library/Zend/Db/Statement/Mysqli.php:294
Generated By: xxx
Stack Trace
#0 [internal function]: XenForo_Application::handleFatalError()
#1 {main}
Request State
array(3) {
  ["url"] => string(70) "http://xxx/community/admin.php?credits/import-trophy-points"
  ["_GET"] => array(1) {
    ["credits/import-trophy-points"] => string(0) ""
  }
  ["_POST"] => array(4) {
    ["currency_id"] => string(1) "1"
    ["type"] => string(5) "merge"
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}
Tried to change memory_limit to 256M and still got the same error.
 
Hello @MrC

We checked again and we using only one query for import credits from trophy points. We advice that you can optimize DB again, increase memory_limit and import again.

Regards,
 
Status
Not open for further replies.

Similar threads

Sonia
  • Locked
  • Question Question
XF 1.5 credits premium
Replies
1
Views
453
Paul B
Paul B
Top Bottom