errors when setting up the database for adkats.

[Zoemiej]

were getting errors when setting up the database for adkats.

these are the errors:

ERROR-6600: [Non-Query failed. [Adding AdKats role groups table]: MySql.Data.MySqlClient.MySqlException: Cannot add foreign key constraint
at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlCommand command)
at PRoConEvents.AdKats.SendNonQuery(String desc, String nonQuery, Boolean verbose)]
[15:42:38 65] [AdKats] ERROR-6600: [AdKats tables not present or valid in the database. Have you run the AdKats database setup script yet? If so, are your tables InnoDB?]
[15:42:38 65] [AdKats] INFO: Shutting down AdKats.
[15:42:39 08] [AdKats] SUCCESS: Database timing confirmed.
[15:42:42 67] [AdKats] AdKats 6.6.0.0 Disabled! =(

Its seems there are some restrictions to create either triggers, stored procuderes or both.

Is it possible to gain acces?

[Vanderburg]

Procedures require elevated permissions that we cannot enable on shared MySQL hosting. If procedures are a requisite of the tool you're running, you would need to run a MySQL server on an unmanaged VDS.