Awards Plugin Getting Fatal Error On Install

cpositive

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

peregrine

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

businessdad

Another useful guide to troubleshoot such kind of errors: MySQL Error Number 1005 Can’t create table ‘.\mydb#sql-328_45.frm’ errno: 150.

cpositive

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.

businessdad

Well done! (voilà)

SouLPrisoner

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!

R_J

1. Download and install "Logger" plugin: http://vanillaforums.org/addon/logger-plugin
2. Download and install "Aelia Foundation Classes" plugin: http://vanillaforums.org/addon/logger-plugin

businessdad

@R_J said:
2. Download and install "Aelia Foundation Classes" plugin: http://vanillaforums.org/addon/logger-plugin

Thanks for answering on my behalf. Just a minor issue, the orrect link for AFC is http://vanillaforums.org/addon/aeliafoundationclasses-plugin

R_J

Oops... at least I've spelled "Aelia" correct...

businessdad

@R_J said:
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".

peregrine

I chose it because it's so easy for me, coming from Latin, and it's short too. For the record, it means "sun".

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.

R_J

Pronouncing is no problem for me: we even have a dedicated letter for "ae". Though I'm not sure if "Älia" would be right...

businessdad

@R_J said:
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).