sql install scripts do not generate the tables
Brought to you by:
trilexcom
Menu
▾
▴
#27 sql install scripts do not generate the tables
on the latest version of mysql the TYPE=MyISAM syntax is not supported when creating Tables
therefore the phpip.sql does not get applied and the tables and entries do not get created even tho the install page says successfull
i have fixed the file to use the new syntax of ENGINE=MyISAM and then rerun the the install
also as a side note - if you run the install process more than once on the same DB it will create duplicate admin accounts with the same name which will then cause the first login to show a blank page during the validate function and hang
to fix this remove the duplicate row from the users table in the DB
updated phpip.sql file with the correct create table syntax