Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 14th January 2013, 10:02
mare mare is offline
Junior Member
 
Join Date: Mar 2011
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Creating custom DB tables in new module

Hello I created a new module following the basics described here (http://docs.ispconfig.org/development/interface/)

The docu said that all tables will be created automatically but this will result in the following error.

mysqli_query CREATE command denied to user 'ispconfig'@'localhost' for table 'myaddon_support_messages'.

I could ship around this with adding create right to the user ispconfig@localhost but it's confusing. So may adding a hint into the docu will be helpfull.
Reply With Quote
Sponsored Links
  #2  
Old 14th January 2013, 14:36
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,177
Thanks: 829
Thanked 5,414 Times in 4,257 Posts
Default

Thanks for the info, I will add a note in the tutorial.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 14th January 2013, 15:34
mare mare is offline
Junior Member
 
Join Date: Mar 2011
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

There is also a typo in tform.php

- $form['auth_preset']['groupid'] = 0; user
+ $form['auth_preset']['groupid'] = 0;

and in tolist.php
+ /* Database table
- // Datbase table

Last edited by mare; 14th January 2013 at 15:37.
Reply With Quote
  #4  
Old 28th March 2013, 21:55
bvbmedia bvbmedia is offline
Junior Member
 
Join Date: Apr 2012
Location: Netherlands
Posts: 9
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via Skype™ to bvbmedia
Default Another issue

I confirm both bugs are still existing in 3.0.5.2.

Also when you make a module and you directly create a custom TPL file, ISPConfig won't create the database table on the fly. After removing the TPL file temporary and re-opening the form in the browser the CREATE table executed.
__________________
Best regards,

Bas van Beek
BVB Media / TYPO3 Multishop

http://www.bvbmedia.nl
http://www.typo3multishop.com
Reply With Quote
  #5  
Old 2nd April 2013, 10:04
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,177
Thanks: 829
Thanked 5,414 Times in 4,257 Posts
 
Default

Quote:
There is also a typo in tform.php

- $form['auth_preset']['groupid'] = 0; user
+ $form['auth_preset']['groupid'] = 0;

and in tolist.php
+ /* Database table
- // Datbase table
Which exact file and line numbers do you refer to?

Quote:
Also when you make a module and you directly create a custom TPL file, ISPConfig won't create the database table on the fly. After removing the TPL file temporary and re-opening the form in the browser the CREATE table executed.
Yes, thats intended.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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
Freeradius and Mysql uvstudios HOWTO-Related Questions 4 19th February 2014 12:11
Proftpd + MySQL virtual users, can't connect geekman HOWTO-Related Questions 28 27th September 2010 18:03
FreeRadius + MySQL working, but I don't know how to customise SQL queries awe Installation/Configuration 4 4th April 2010 23:28
ffmpeg Video support for ubuntu 7.10 [suphp-ispconfig] amaurib Installation/Configuration 13 16th February 2010 17:26
Webmin docs missing namit Server Operation 11 5th January 2006 09:51


All times are GMT +2. The time now is 00:53.


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