Anyone know how to manually remove these so I can install again?
Code:
Database error in vBulletin 4.1.8:
Invalid SQL:
ALTER TABLE award ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_pointvalue TINYINT( 3 ) DEFAULT 0 NOT NULL;
MySQL Error : Duplicate column name 'award_allowrecommend'
Error Number : 1060
Request Date : Friday, January 6th 2012 @ 03:28:17 AM
Error Date : Friday, January 6th 2012 @ 03:28:18 AM
Script : http://***.***.***/***/plugin.php?do=productimport
Referrer : http://***.***.***/***/plugin.php?do=productadd
IP Address : ***.***.***.***
Username : ***
Classname : vB_Database
MySQL Version : 5.0.91mm-log
I managed to manually remove everything and install this again.
So back to the original problem
When someone requests awards this happens:
Code:
The following errors occurred with your submission
There's some error when sending your award request.
Please contact site's administrator for assistant.
Code:
The following errors occurred with your submission
The following users were not found: 1
Then there is the problem with the award tables and tab.
1. This is how the left side looked before the user 1 got an award (I know it isn't pretty but I haven't been able to get that double border at the bottom changed).
2. This is how the same location looks after they have got one award.
3. This is where that strange tab ends up when the Awards tab link is clicked.
4. This is how the tabs look when there is no reward given. It's just the row of tabs with no box or anything under it. Looks strange. Note that the Awards tab has been clicked in this picture and then an other tab thus creating a border and box with the right design. Not like the un-clicked one in image 7.
5. Here I've clicked the Awards tab after an award has been given out and the strange tab in image 2 have moved up under the normal row of tabs creating a gap. Clicking the other tabs does not make this happen, only the Awards tab.
6. Here the Awards tab has been clicked for a user with awards. The tab background and border is correct but the gap is present.
7. This is how the Awards tab look when a user's profile is first entered.
So what should I do to get this sorted?