[mtha]

Originally Posted by ChrisBaktis

I just changed from 3.0.7 to 3.5.1 and resintalled your hack - the awards that were present prior to the conversion still show up - but in the admincp area if I click on Manger or any of the items I get the following error:

Database error in vBulletin 3.5.1:

PHP Code:

Invalid SQL:

            SELECT aw_c.*, COUNT(aw.award_id) AS items
            FROM award_cat AS aw_c
            LEFT JOIN award AS aw USING(award_cat_id)
            GROUP BY award_cat_id
            ORDER BY award_cat_displayorder;

MySQL Error  : Unknown column 'award_cat_displayorder' in 'order clause'
Error Number : 1054
Date         : Wednesday, November 30th 2005 @ 09:01:03 AM
Script       : http://rustysoaptraders.com/forums/admincp/award_cat.php?do=modifycat 


HMM, was you able to reorder award cat prior to your upgrade?
award_cat_displayorder was present in the database since after version 1.0

maybe you did not upgrade your award hack since 1.0 to the latest version for vB 3.0.7, or you missed one step to fix database?

anyway, check your database and see if you have table award_cat, and if there's a field called award_cat_displayorder in there.

or you may need to run the queries (add prefix if you need to):

this query will drop award_cat table. so becareful. if you already have the award cat table, want to keep it, you can look over the next query and see if there is anything wrong. with your current award_cat table.
[sql]DROP TABLE IF EXISTS award_cat
[/sql]

[sql] CREATE TABLE award_cat (
award_cat_id mediumint(8) unsigned NOT NULL auto_increment,
award_cat_title varchar(100) NOT NULL default '',
award_cat_desc varchar(250) NOT NULL default '',
award_cat_displayorder mediumint(8) unsigned NOT NULL default '0',
award_cat_parentid mediumint(8) NOT NULL default '-1',
PRIMARY KEY (award_cat_id),
KEY award_cat_order (award_cat_displayorder)
) TYPE=MyISAM[/sql]

[sql]
INSERT INTO " . TABLE_PREFIX . "award_cat
(award_cat_id, award_cat_title, award_cat_desc, award_cat_displayorder, award_cat_parentid)
VALUES (1, 'Default', 'Default category', 1, -1)[/sql]