I upgraded to ISPConfig 3.0.3.1 from svn. When I click on the Help>FAQ functions I get some table missing errors... Code: Table 'dbispconfig.help_faq' doesn't exist Table 'dbispconfig.help_faq_sections' doesn't exist ... Is there a script or instructions on what tables need to be created and their fields? Thanks.
I just looked into svn trunk and the tables are there in the full sql file and also in the patch sql files. Seems as if your install does not use the latest table definitions or a database from a older ispconfig release.
I've just run updates and not full re-installs so I don't know. Apparently the tables did not get updated. How do I download just the svn sql version or patch so I can fix that? PS - I checked all the ISPConfig-3.0.3.2-rc1 install/sql files and the only occurrence of the string 'help' is in the tabs (line 1348 shown below), no help_faq found anywhere. Code: INSERT INTO `sys_user` (`userid`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `username`, `passwort`, `modules`, `startmodule`, `app_theme`, `typ`, `active`, `language`, `groups`, `default_group`, `client_id`) VALUES (1, 1, 0, 'riud', 'riud', '', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'dashboard,admin,client,mail,monitor,sites,dns,tools,help', 'dashboard', 'default', 'admin', 1, 'en', '1,2', 1, 0);
You mix up the svn branches here. ISPConfig-3.0.3.2-rc1 is not the SVN version and it does not contain the FAQ functions, so these tables are not in the sql files of this version. The FAQ module will be released with ispconfig 3.0.4 amd is currently in the svn trunk. To get the code from svn trunk, use the command: svn export svn://svn.ispconfig.org/ispconfig3/trunk/