[Hippy]

Originally Posted by studify

Very well done, Andreas. I just can't understand why those features are not part of the vB 4.2 Core, vB seems to be offering a car w/o tyres...

Nonetheless I get a Database-Error when I want to add a heading oder HTML. I can set it up, but when I click 'Save' I get the following MySQL Error: Unknown column 'exttype' in 'field list'.

Thanks for this mode and for any help in advance.

All the best,
Alex

Originally Posted by Andreas

Hmm ... you learn smth. new every day ... my Installcode Generator doesn't work properly with ENUM fields

[sql]
ALTER TABLE navigation ADD exttype ENUM ('heading', 'html') NULL
[/sql]

should take care of that.

Originally Posted by Boofo

I spoke too soon. I get this db error when trying to add a heading:

Database error in vBulletin 4.2.0:

Invalid SQL:

		REPLACE INTO navigation
		(name, productid, navtype, exttype, html, state, displayorder, parent, 
		scripts, showperm, url, version, username, dateline , includegroups, excludegroups, sections, parents)
		VALUES ('heading_nzg4_407','boofo_user_links','link','heading','',0 | 0,40,'menu_nzg0_544','','','','4.2.0','Boofo',1337880296,
	'', 
	'', 
	'', 
	''
);

MySQL Error   : Unknown column 'exttype' in 'field list'
Error Number  : 1054
Request Date  : Thursday, May 24th 2012 @ 01:24:56 PM
Error Date    : Thursday, May 24th 2012 @ 01:24:57 PM
Script        : http://www.iamgrumpy.com/forums/admincp/navigation.php?do=doaddcustom
Referrer      : http://www.iamgrumpy.com/forums/admincp/navigation.php?do=addcustom&type=heading&navid=78
IP Address    : 173.21.27.150
Username      : Boofo
Classname     : vB_Database
MySQL Version : 5.5.22-cll

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 426
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 444
#2 vB_Database->query_write() called in [path]/admincp/navigation.php(85) : eval()'d code on line 203
#3 eval() called in [path]/admincp/navigation.php on line 85

same thing boofo posted
the fix is posted there from Andreas