#1  
Old 3rd January 2011, 23:06
BorderAmigos BorderAmigos is offline
Senior Member
 
Join Date: Apr 2008
Location: San Diego & Tijuana
Posts: 302
Thanks: 26
Thanked 33 Times in 31 Posts
Send a message via MSN to BorderAmigos Send a message via Yahoo to BorderAmigos
Default ISPConfig 3.0.3.1 Tables?

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.
__________________
System6Hosting.com, ISPConfig 3, Debian.

Last edited by BorderAmigos; 4th January 2011 at 17:46.
Reply With Quote
Sponsored Links
  #2  
Old 4th January 2011, 10:45
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,421
Thanks: 834
Thanked 5,501 Times in 4,330 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
BorderAmigos (4th January 2011)
  #3  
Old 4th January 2011, 17:37
BorderAmigos BorderAmigos is offline
Senior Member
 
Join Date: Apr 2008
Location: San Diego & Tijuana
Posts: 302
Thanks: 26
Thanked 33 Times in 31 Posts
Send a message via MSN to BorderAmigos Send a message via Yahoo to BorderAmigos
Default

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);
__________________
System6Hosting.com, ISPConfig 3, Debian.

Last edited by BorderAmigos; 4th January 2011 at 17:46.
Reply With Quote
  #4  
Old 4th January 2011, 18:08
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,421
Thanks: 834
Thanked 5,501 Times in 4,330 Posts
Default

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/
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 4th January 2011, 18:25
BorderAmigos BorderAmigos is offline
Senior Member
 
Join Date: Apr 2008
Location: San Diego & Tijuana
Posts: 302
Thanks: 26
Thanked 33 Times in 31 Posts
Send a message via MSN to BorderAmigos Send a message via Yahoo to BorderAmigos
 
Default

Found it. Thank you!
__________________
System6Hosting.com, ISPConfig 3, Debian.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig 3.0.3.1 released till General 11 22nd April 2011 12:22
ISPConfig 3.0.0.4 Beta Released till General 54 4th March 2009 09:55
ISPconfig after installation cannot reach www.xyz.de:81 Figth4Linux Installation/Configuration 23 6th March 2008 22:38
SP-Server Setup - Ubuntu 5.10 "Breezy Badger" - Page 6 (changes) LuisC-SM HOWTO-Related Questions 0 21st April 2006 15:16
can ispconfig account tables become corrupted? darthpaul General 3 24th March 2006 18:58


All times are GMT +2. The time now is 23:41.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.