[Swedie]

Originally Posted by Lionel

here, all the ones in that series were wrong:
INSERT INTO `setting` VALUES ('allowguestbook', '1', 'yesno', 10, 'guestbookwebpage', '1', 0, 1);

the value 'guestbookwebpage' for example should have been the second one. The yesno is wrong etc...

Thing is that I've done a simple SQL dump and copied the INSERT's that PHPMYADMIN created for me for re-creating the database. I can't see how it would create the fields wrongly.

The fields goes like this:
varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile
the order in the INSERT CODE is correct... if you look at above line

Also when I am executing the SQL file and I'm looking at the database for any wrong inputs I can't see any wrongs. Everything is where it should be.

The .SQL file that you downloaded was saved incorrectly and had messed up line brakes. Maybe that is what caused it.

Sorry if I'm blind to see the problem, but I'm sitting here re-creating the database structure with my last .SQL file and everything is the way it should be.