DragonByte Tech | vBulletin Mods & Addons - Powered by vBulletin





DragonByte Tech Proudly Hosted By Hivelocity.net
Custom Fitted Forum Hosting from Hivelocity

User Tag List

Results 1 to 3 of 3

Thread: Database error when use 'Recalculate User Accounts'


Forum: vBCredits II Deluxe Lite Support

Questions & Answers for vBCredits II Deluxe.
Click here to buy!

  1. #1
    Junior Member
    Level 0 (750 Loyalty Points)

    Total Downloaded
    0
    Gil
    177 (0 Banked)
    Total Downloaded
    0
    User Info Thanks / Tagging Info Gifts / Achievements / Awards Activity Stats
    Join Date
    Feb 2011
    Posts
    23
    Points
    177
    Credits
    21
    Rep Power
    0

    Question Database error when use 'Recalculate User Accounts'

    i get ths error when try to update some user

    Database error in vBulletin 3.8.1:

    Invalid SQL:
    UPDATE user SET creditspermissions = 'a:2:{i:0;a:0:{}i:1;a:0:{}}' WHERE userid = 2810;

    MySQL Error : Unknown column 'creditspermissions' in 'field list'
    Error Number : 1054
    Script : http://********/admincp/credits_admin.php?do=findusers
    Referrer : http://********/admincp/credits_admin.php?do=findusers
    Classname : vB_Database
    MySQL Version : 4.1.22-standard

  2. #2
    Former Developer
    Level 0 (0 Loyalty Points)
    Darkwaltz4's Avatar
    Total Downloaded
    0
    Gil
    6,576 (0 Banked)
    Total Downloaded
    0
    User Info Thanks / Tagging Info Gifts / Achievements / Awards Activity Stats
    Join Date
    Jun 2010
    Age
    27
    Posts
    2,405
    Points
    6,576
    Credits
    14,597
    Rep Power
    12

    Default

    Please import the product file for vbcredits again, with allow overwrite set to yes (no settings or accounts will be lost). That should restore the missing table column. Then try recalculating again.

  3. #3
    Junior Member
    Level 0 (750 Loyalty Points)

    Total Downloaded
    0
    Gil
    177 (0 Banked)
    Total Downloaded
    0
    User Info Thanks / Tagging Info Gifts / Achievements / Awards Activity Stats
    Join Date
    Feb 2011
    Posts
    23
    Points
    177
    Credits
    21
    Rep Power
    0

    Default

    Quote Originally Posted by Darkwaltz4 View Post
    Please import the product file for vbcredits again, with allow overwrite set to yes (no settings or accounts will be lost). That should restore the missing table column. Then try recalculating again.
    still show the same error

    Database error in vBulletin 3.8.1:

    Invalid SQL:
    UPDATE user SET creditspermissions = 'a:2:{i:0;a:0:{}i:1;a:0:{}}' WHERE userid = 2810;

    MySQL Error : Unknown column 'creditspermissions' in 'field list'
    Error Number : 1054
    Request Date : Monday, April 30th 2012 @ 06:52:26 PM
    Error Date : Monday, April 30th 2012 @ 06:52:26 PM
    Script : http://xxxxxxxxx/admincp/credits_admin.php?do=findusers
    Referrer : http://xxxxxxxxx/admincp/credits_admin.php?do=findusers
    Classname : vB_Database
    MySQL Version : 4.1.22-standard

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [vB 3.8.x] Database error when deleting a user via ACP
    By Pandemikk in forum vBShop Lite Support
    Replies: 1
    Last Post: 18th May 2011, 23:57
  2. [vB 4.0.x] Database error when installing
    By Dutch_Boy in forum Forumon RPG Lite Support
    Replies: 4
    Last Post: 2nd February 2011, 11:16
  3. Database error when i was importing xml (sr my english is bad)
    By bvquyen in forum vBCredits II Deluxe Lite Support
    Replies: 0
    Last Post: 18th July 2010, 17:09

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •