So you found two entries in the settinggroup table called 'viPortfolio Settings'. One of those settinggroupids you used to assign to the settings in the setting table.
I am going to pick 46 for this example. That would make 45 an extra row.
delete from settinggroup where settinggroupid = 45
This will get rid of the extra row.
This presents me with a question though. How are you getting the settings in the table but not able to create other tables? Is there a permission problem or something that you have on your database? I am guessing you have already validated that. How are you getting the settings into the database. executing something like below:
\. install_settings.sql
from a mysql prompt or
mysqladmin install_settings.sql
from a command prompt?
Either way, I have attached the new install file with the addtional debug messages in it. We should now exactly what, were, why, and who to shoot after you run this.
Thanks
|