Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Having a lot of touble
Author Message
TriloByte
Junior Member


Posts: 14
Joined: Nov 2008
Reputation: 0
Post: #1
Having a lot of touble
Each time in the Admin Cp I go to activate MyCredits, it comes up with this error all te time:

MyBBMyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1060 - Duplicate column name 'credits'
Query:
ALTER TABLE `mybb_users` ADD `credits` INT NOT NULL ;
Please contact the MyBB Group for support.

I have tried to uninstall it, reinstall it, I have edited the templates and everything. Nothing is working.

Any help?
11-30-2008 09:46 AM
Splappy
Super Moderator


Posts: 432
Joined: Oct 2008
Reputation: 4
Post: #2
RE: Having a lot of touble
Go in PHPMyAdmin, and see if there's a row named "credits" in the "mybb_users" table in your MyBB database. If there is one, delete that row.

[Image: iathesig.png]
11-30-2008 11:22 AM
TriloByte
Junior Member


Posts: 14
Joined: Nov 2008
Reputation: 0
Post: #3
RE: Having a lot of touble
Ok, I will try that later, thanks ;)

Ern... Call me a n00b, but where is my phpAdmin? I can't see it in my CPanel on my hosting place...
(This post was last modified: 11-30-2008 06:13 PM by TriloByte.)
11-30-2008 02:47 PM


polarbear541
BETA Tester

Posts: 165
Joined: Aug 2008
Reputation: 0
Post: #4
RE: Having a lot of touble
If you cannot find it then it may be that they do not provide it. If they do not then you may need to contact your hosting provider.

It should be next to the MySQL Database Wizard!

Thanks Polarbear541! (Polar)

BETA Tester of GameSection and MyBBSource!
11-30-2008 07:15 PM
TriloByte
Junior Member


Posts: 14
Joined: Nov 2008
Reputation: 0
Post: #5
RE: Having a lot of touble
Ah, yeah I found it now. It can't seem to find that error detail things though... hmmm...
12-01-2008 04:53 PM
TriloByte
Junior Member


Posts: 14
Joined: Nov 2008
Reputation: 0
Post: #6
RE: Having a lot of touble
**Bump**

Anyone can help? :S
12-02-2008 05:15 PM


NetSage
Super Moderator


Posts: 282
Joined: Aug 2008
Reputation: 3
Post: #7
RE: Having a lot of touble
Splappy has the correct instructions, did you try those yet?

[Image: netsage.jpg]
I'll be over at the Admin Lounge.
All pms about support or asking me to register will be ignored.
12-03-2008 01:16 PM
Dalton
Super Moderator


Posts: 786
Joined: Aug 2008
Reputation: 3
Post: #8
RE: Having a lot of touble
What did you do to get to this error? (Like deactivate-->upgrade-->reactivate?) What?

Chicago Bears
6-5
12-03-2008 01:45 PM
 


Forum Jump: