Here's what i got:
Database error in vBulletin 3.0.3:
Invalid SQL: insert into cms_pages (page_name,page_var,page_content,page_content_un,c at) values ('Kaufberatung','kaufberatung','HALLO!!!<b>dsadd</b>','HALLO!!!<b>dsadd</b>','1')
mysql error: Unknown column 'page_var' in 'field list'
mysql error number: 1054
Date: Tuesday 27th of July 2004 08:30:45 PM
Script: .../admincp/admin_cms.php
Referer:
Username: d.Hahn
IP Address: xxx
The following modified query did the trick
Code:
CREATE TABLE `cms_pages` (
`pid` int(15) NOT NULL auto_increment,
`page_name` varchar(255) NOT NULL default '',
`page_var` varchar(255) NOT NULL default '',
`page_content` text NOT NULL default '',
`page_content_un` text NOT NULL default '',
`cat` int(15) NOT NULL default '0',
PRIMARY KEY (`pid`)
) TYPE=MyISAM;
Here's a
demo of a modified version of this script.
Layout is the same, the code changed a bit
http://www.pagodentreff.de/artikel/testbericht.html (german)