MyBB Community Forums

Hello,

We are getting this error message when trying to disable MyAwards 1.3 by Labrocca. Basically we had this plugin activated on 1.4, and never deactivated when we upgraded to 1.6, so it's still activated and when we try to deactive, we get this error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1091 - Can't DROP 'awards'; check that column/key exists
Query:
    ALTER TABLE mybb_users DROP `awards` 

Any ideas?

(2010-11-02, 05:50 PM)iGeorge Wrote: [ -> ]Hello,

We are getting this error message when trying to disable MyAwards 1.3 by Labrocca. Basically we had this plugin activated on 1.4, and never deactivated when we upgraded to 1.6, so it's still activated and when we try to deactive, we get this error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1091 - Can't DROP 'awards'; check that column/key exists
Query:
    ALTER TABLE mybb_users DROP `awards` 

Any ideas?

Just delete the plugin files?

It can't drop the table awards. Try uninstalling and reinstalling that specific plugin.

Backup the "awards" database in case you need it and manually drop it via phpmyadmin

(2010-11-02, 05:55 PM)Kyuubi Wrote: [ -> ]It can't drop the table awards. Try uninstalling and reinstalling that specific plugin.

I can't uninstall it, that's the error I get when doing "Deactivate".

---

(2010-11-02, 05:58 PM)weBex Wrote: [ -> ]Backup the "awards" database in case you need it and manually drop it via phpmyadmin

Not using phpmyadmin, and we can't find any record of it.

---

Now getting this error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1091 - Can't DROP 'awards'; check that column/key exists
Query:
    ALTER TABLE mybb_users DROP `awards` 

The error is because you've manually deleted the awards table, and then tried to deactivate the plugin. Now it can't drop the table because you've done it already.

Check in your database that a column named awards exists in the mybb_users table, if it doesn't open the plugin file and delete everything on line 152 and try deactivating again.

Thanks for your help AJS, works now.

+Rep.

---

Now the plugin has deactivated, and we've re-activated it, however now we are getting this, the /awards folder is CHMODD'ed correctly and all the required files are in place.



Any ideas?

Thanks.

download filezilla client it would be easy for you just try deleting all awards file or edit the plugin file you upgraded to 1.6 right? so better edit the word "compatibility" => "16*" or what ever your current version is (for eg for 1.4x its 14*) and try