Status
Not open for further replies.

Home Alone

Customer
Users are not receiving credits after upgrading from 2.00 to 2.1.0. A new user registered on September 1. He created 87 posts and two threads. He should have received 5,000 points per post and 50,000 points per thread. Other members have also donated more than 1,000,000 points but his profile shows 0 points. He has no transactions in the credits_pending table. The transaction log shows that he is receiving credits, they are just not being deposited to the credits field in the user table. I had to manually calculate his credits and enter them via his profile in the Admin control panel. Other users have also complained that they are not receiving credits. I tested this on myself and I also did not receive credits for new posts or threads and have no transactions in the credits_pending table.

Here are my currency settings:

credits.png
 
Are you sure these users are not marked as unable to receive credits? Locate them with the recalculate user amounts tool under the vbcredits menu in the admincp, and see if any of the checkboxes are unchecked.

Do you have Welcome, Post and Thread events still active? Are they restricting usergroups which exclude the users which have issues?

The credits_pending table clears out when transactions are finalized, so seeing that empty doesnt mean that vbcredits didnt determine those users should not have gotten anything due to various settings.
 
Are you sure these users are not marked as unable to receive credits? Locate them with the recalculate user amounts tool under the vbcredits menu in the admincp, and see if any of the checkboxes are unchecked.

Do you have Welcome, Post and Thread events still active? Are they restricting usergroups which exclude the users which have issues?

The credits_pending table clears out when transactions are finalized, so seeing that empty doesnt mean that vbcredits didnt determine those users should not have gotten anything due to various settings.

Welcome, Post and Thread events are still active. The only excluded usergroups are unregistered and banned usergroups.

When I try to update the transactions via the Update Counters section the following mysql error is returned:

Database error in vBulletin 3.8.7:

Invalid SQL:
;

MySQL Error : Query was empty
Error Number : 1065
Request Date : Monday, October 8th 2012 @ 11:46:16 AM
Error Date : Monday, October 8th 2012 @ 11:46:17 AM
Script : http://www.domain.com/admincp/credits_admin.php?do=process_transactions
Referrer : http://www.domain.com/admincp/misc.php?do=chooser
IP Address : 123.456.789.9
Username : The Admin
Classname : vB_Database
MySQL Version : 5.5.27-cll

Does this mean there are no pending transactions even though the credits_pending table has about 9,000 entries?
 
No, it means theres something wrong with your vbulletin that the query it tried to send was somehow replaced with blank. The thing causing that could also be causing your other issues, but I will need admin and ftp access to find out what.


Could you please create and PM me with a temporary FTP and AdminCP account? For security reasons, we recommend you create a new FTP account only for DBTech support, then disable or delete it after we have both confirmed the issue has been solved and there are no further issues. The same applies to AdminCP accounts; they should ideally be temporary accounts created for us only. If we have created an account on your site already, you can optionally boost that account to Administrator and then de-admin this account once the issue has been solved. If you use a .htaccess password protection for your AdminCP directory, it is recommended that you create a new authorised user for DBTech and remove this user once the issue has been solved. Please test any temporary accounts you create to ensure that the FTP account has access to the forum files, and that the AdminCP account can access the administrative controls for the product we are assisting you with. Ensuring this is all in order before submitting the information will significantly speed up the process of assisting you. We will alert you via PM if there's any issues with the login information you have provided. When sending the PM, for your security you should also un-tick the "Save a copy in my Sent Items folder" checkbox. When the access details have been received, we will delete the PM from our inbox. Ensuring you have not kept a copy of the PM reduces the risk of security breaches. Thank you for helping us debug our products and allowing us to assist you, we appreciate it :D
 
Welcome, Post and Thread events are still active. The only excluded usergroups are unregistered and banned usergroups.

When I try to update the transactions via the Update Counters section the following mysql error is returned:

Database error in vBulletin 3.8.7:

Invalid SQL:
;

MySQL Error : Query was empty
Error Number : 1065
Request Date : Monday, October 8th 2012 @ 11:46:16 AM
Error Date : Monday, October 8th 2012 @ 11:46:17 AM
Script : http://www.domain.com/admincp/credits_admin.php?do=process_transactions
Referrer : http://www.domain.com/admincp/misc.php?do=chooser
IP Address : 123.456.789.9
Username : The Admin
Classname : vB_Database
MySQL Version : 5.5.27-cll

Does this mean there are no pending transactions even though the credits_pending table has about 9,000 entries?

I too have this exact issue but on 4.2.0. It worked fine before I upgraded to the newest version of vBcredits.

I get this error when trying to update transactions manually via ACP:
Code:
Processing Pending Transactions

Processing: 1
Warning: Missing argument 1 for vB_Database::query_first(), called in [path]/admincp/credits_admin.php on line 2020 and defined in [path]/includes/class_core.php on line 500

Code:
Database error in vBulletin 4.2.0:

Invalid SQL:
;

MySQL Error   : Query was empty
Error Number  : 1065
Request Date  : Tuesday, October 9th 2012 @ 04:43:50 PM
Error Date    : Tuesday, October 9th 2012 @ 04:43:50 PM

This is after recalculating my members' points. It asks me to update counters and this is what I get.
 
Thanks for waiting guys, this was a typo.

Edit (forums)/(admincp)/credits_admin.php

find and REMOVE

PHP:
$trans = $vbulletin->db->query_first();

not sure how that got left in there.
 
Status
Not open for further replies.

Legacy vBCredits II Deluxe

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
845
Customer rating
0.00 star(s) 0 ratings
Back
Top