DragonByte Tech | vBulletin Mods & Addons - Powered by vBulletin





User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
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)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Feb 2011
    Posts
    23
    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
    0 0 0
     
    Database error when use 'Recalculate User Accounts' Send PM  

  2. #2
    Former Developer
    Level 0 (0 Loyalty Points)
    Darkwaltz4's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Jun 2010
    Age
    29
    Posts
    2,312
    Rep Power
    13

    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.
    0 0 0
     
    Database error when use 'Recalculate User Accounts' Send PM  

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

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Feb 2011
    Posts
    23
    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
    0 0 0
     
    Database error when use 'Recalculate User Accounts' Send PM  

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
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.