DragonByte Tech | vBulletin Mods & Addons - Powered by vBulletin



DragonByte Tech Proudly Hosted By Hivelocity.net
Cloud Servers from HiVelocity Hosting / Sparknode

View Issue Info: Database error when use 'Recalculate User Accounts'

Category:
"How Do I?"
Status:
Answered
Priority:
N/A
Forum Version:
Enter the forum version you are running.
3.8.1
Support Agent:
Darkwaltz4, Belazor

User Tag List

  • Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Drunk
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Godly
  • Happy
  • Hateful
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • Wtf
  • Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Drunk
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Godly
  • Happy
  • Hateful
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • Wtf
  • Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Drunk
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Godly
  • Happy
  • Hateful
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • Wtf
  • Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Drunk
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Godly
  • Happy
  • Hateful
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • Wtf
  • Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Drunk
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Godly
  • Happy
  • Hateful
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • Wtf
  • Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Drunk
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Godly
  • Happy
  • Hateful
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • Wtf
  • Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Drunk
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Godly
  • Happy
  • Hateful
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • Wtf
  • 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)
      This user has no status.
       
      I am:
      ----
       




      Gil
      364 (0 Banked)
      Total Contributions For

      PapaQ      $ 5.00
      Thanks / Tagging Info Gifts / Achievements / Awards Activity Stats User Info
      Post Thanks / Like
      Mentioned
      0 Post(s)
      Tagged
      0 Thread(s)
      Quoted
      1 Post(s)

      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
      Development Team
      Level 0 (0 Loyalty Points)
      is settling in with a new baby!
       
      I am:
      Tired
       
      Darkwaltz4's Avatar
      Gil
      10,731 (0 Banked)
      Total Contributions For

      Darkwaltz4      $ 0.00
      Thanks / Tagging Info Gifts / Achievements / Awards Activity Stats User Info
      Post Thanks / Like
      Mentioned
      408 Post(s)
      Tagged
      68 Thread(s)
      Quoted
      239 Post(s)

      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)
      This user has no status.
       
      I am:
      ----
       




      Gil
      364 (0 Banked)
      Total Contributions For

      PapaQ      $ 5.00
      Thanks / Tagging Info Gifts / Achievements / Awards Activity Stats User Info
      Post Thanks / Like
      Mentioned
      0 Post(s)
      Tagged
      0 Thread(s)
      Quoted
      1 Post(s)

      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
    •