Hi,
I was having trouble setting up foreign keys, subform to parent form. And After doing some research I found that tables created in nuBuilder forte are made in MyISAM storage engine by default. I have done a re-install of nuBuilder once already, and I believe the first time I installed it, new tables WERE defaulting to InnoDB. But MyISAM doesn't support foreign keys. To fix, I went into phpMyadmin, select a table, click "Operations" at the top and change the storage engine. Then you can setup foreign keys with an sql statement or phpMyadmin gives you a handy GUI for it under table structure/relation view.
Welcome to the nuBuilder Forums!
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
New Tables default to MyISAM
Re: New Tables default to MyISAM
ben,
nuBuilder allows you to use any field as a foreign key even if it is not recognised as so by the Mysql database.
In other words, you don't need to create foreign keys within MySQL/PHPMyAdmin for nuBuilder to work.
Steven
nuBuilder allows you to use any field as a foreign key even if it is not recognised as so by the Mysql database.
In other words, you don't need to create foreign keys within MySQL/PHPMyAdmin for nuBuilder to work.
Steven