ISPConfig 3.0.3.1 Tables?

Discussion in 'Developers' Forum' started by BorderAmigos, Jan 3, 2011.

  1. BorderAmigos

    BorderAmigos New Member

    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.
     
    Last edited: Jan 4, 2011
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  3. BorderAmigos

    BorderAmigos New Member

    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);
     
    Last edited: Jan 4, 2011
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    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/
     
  5. BorderAmigos

    BorderAmigos New Member

    Found it. Thank you!
     

Share This Page