if you have this problem and you don't have another option change the engine to any other engine like 'myisam', then try to create the table.
disclaimer: it is not the valid answer as you may have foreign key constraints which will not be supported by another storage engine. Every storage engine has their own specialty to store and access data, these points also to be taken in account.