Bug You have 1 new Award

[Slugga]

Invalid SQL:
SELECT * FROM customprofile WHERE userid='0' ORDER BY title
/**customprofile- member**/;

MySQL Error : Unknown column 'title' in 'order clause'

When I click my new award in notifications,this is what happens.

Also on top of that in my admincp my options seem to be doubled.
"

DBTech - vBActivity
Manage Achievements
Manage Categories
Manage Criteria
Maintenance
Repair Cache
Settings
DBTech - vBShout
DBTech - Post Thanks
DBTech - vBActivity
Manage Achievements
Manage Categories
Manage Criteria
Manage Awards
Award Requests / Nominations
Maintenance
Repair Cache
Points Settings
Permissions
Settings
"

 

[Ozzy47]

Did you upgrade from a older version recently? If so follow the instructions in the readme file vBActivity v2.1.3 Upgrade Notes.txt

 

[Slugga]

That fixed my duplicate problem,any idea on the database one

 

[Ozzy47]

I don't but Fillip H. will be able to answer that one as soon as he has a chance.

 

[Fillip H.]

That looks like an issue with the Profile Customisation feature in vBulletin. It looks like your "customprofile" database table is corrupt.

You'll need to contact vBulletin Support with the query from the OP and ask them for advice on how to proceed.

 

[Slugga]

It didnt do this until i installed VBActivity & Awards

 

[Ozzy47]

Of course it would not happen before you had the mod installed as there was no new award notifications to click on.

 

[Slugga]

Of course it would not happen before you had the mod installed as there was no new award notifications to click on.

Exactly.

 

[Fillip H.]

What do you mean, exactly?

The query mentioned in the OP is not ran anywhere in vBActivity, just because it revealed itself when you performed that specific action doesn't mean the fault lies with vBAA

 

[Slugga]

What do you mean, exactly?

The query mentioned in the OP is not ran anywhere in vBActivity, just because it revealed itself when you performed that specific action doesn't mean the fault lies with vBAA

"Exactly" Man,This didnt happen until i installed this,is all im saying.

 

[Slugga]

Im now getting this

"
Invalid SQL:
SELECT * FROM customprofile WHERE userid='1'
/**customprofile- member**/;

MySQL Error : Table 'earkandy_vb.customprofile' doesn't exist
Error Number : 1146
Request Date : Saturday, November 10th 2012 @ 04:26:40 PM
Error Date : Saturday, November 10th 2012 @ 04:26:40 PM
Script : EarKandy
Referrer : EarKandy
IP Address : 72.184.38.98
Username : Slugga
Classname : vB_Database
MySQL Version : 5.5.23-55
"

I forgot i had a custom entry for custom profile,i removed it. now i get this

 

[Fillip H.]

Do you use a table prefix (defined in config.php)?

There's a limited amount of assistance we are able to provide with issues in the core vBulletin software.

 

[Slugga]

Do you use a table prefix (defined in config.php)?

There's a limited amount of assistance we are able to provide with issues in the core vBulletin software.

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';

I understand.