Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Awards Plugin Getting Fatal Error On Install
This discussion is related to the Awards Plugin addon.

I have followed all steps in regards to installing the Awards Plugin using Vanilla 2.0 and every time I try to enable the plugin the following error is received...any ideas?
The addon could not be enabled because it generated a fatal error:
Can't create table 'i196507_vf1.#sql-1319_502291' (errno: 150)|Gdn_Database|Query|
ALTER TABLE vf_UserAwards
ADD CONSTRAINT FK_UserAwards_User
FOREIGN KEY (UserID)
REFERENCES vf_User
(UserID)
ON DELETE NO ACTION
ON UPDATE NO ACTION
Tagged:
0
Comments
maybe these will help give you some insights.
try googling "errno: 150 myql"
http://dev.mysql.com/doc/refman/5.6/en/innodb-foreign-key-constraints.html
http://stackoverflow.com/questions/4061293/mysql-cant-create-table-errno-150
http://forums.devarticles.com/mysql-development-50/mysql-foreign-key-problem-errno-150t-7704.html
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
Another useful guide to troubleshoot such kind of errors: MySQL Error Number 1005 Can’t create table ‘.\mydb#sql-328_45.frm’ errno: 150.
My shop | About Me
Thank you all, I figured out the issue and the plugin is now enabled. vf_User needed to be changed to innodb mode in Mysql and then I manually added the relationship info and viola! Such a simple fix yet it took me 3 hours...I am a tad rusty on my "Mysql" techniques. Thanks again ya'll.
Well done! (voilà)
My shop | About Me
Please Help!
I'm getting this error * Awards is missing the following requirement(s): Logger 12.10.28, AeliaFoundationClasses 13.04.26. *
What do i do?? Please explain step-by-step. Thanks!
Thanks for answering on my behalf. Just a minor issue, the orrect link for AFC is http://vanillaforums.org/addon/aeliafoundationclasses-plugin
My shop | About Me
Oops... at least I've spelled "Aelia" correct...
Off topic: I noticed that "Aelia" is surprising difficult for many people to spell, let alone pronounce. I chose it because it's so easy for me, coming from Latin, and it's short too. For the record, it means "sun".
My shop | About Me
I would have called it Peregrine.
Some day - maybe in our lifetime (or possibly the Sun's lifetime) - People will read the directions in the read me and the documentation. and description, and the requirements. step by step.
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
Pronouncing is no problem for me: we even have a dedicated letter for "ae". Though I'm not sure if "Älia" would be right...
It would, that's precisely the pronunciation (I know because half of my family is German).
My shop | About Me