XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module usage questions 
  4.  / Custom module installation problem
Register
11
culex
Re: Custom module installation problem

  • 2009/7/14 19:15

  • culex

  • Module Developer

  • Posts: 711

  • Since: 2004/9/23


Tg you came alon Ghia :)

Ok so also I learn something, wich is nice. Was a little on the deep end here. :)
Programming is like sex:
One mistake and you have to support it for the rest of your life.
12
flymirco
Re: Custom module installation problem

  • 2009/7/15 2:24

  • flymirco

  • Just popping in

  • Posts: 42

  • Since: 2006/9/20


Thank you so much ghia,

I put your hack in sqlutility.php file and added alter table instructions for all foreign key and index to create, instead of putting it in table creation.

Thank you culix as well to make me reasoning on some stuff.

This is how I create index and foreign key:
Quote:
ALTER TABLE svy_domande ADD UNIQUE INDEX idxAttributi (attributi_id);
ALTER TABLE svy_domande ADD CONSTRAINT fk_attributi_domande FOREIGN KEY (attributi_id) REFERENCES svy_attributi(id) ON DELETE NO ACTION ON UPDATE CASCADE ;



flymirco
13
ghia
Re: Custom module installation problem

  • 2009/7/15 8:52

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Don't forget to explain the innoDB requirement and this hack in the installation notes to the future users of your module!
14
culex
Re: Custom module installation problem

  • 2009/7/15 8:59

  • culex

  • Module Developer

  • Posts: 711

  • Since: 2004/9/23


God idea about the readme text. Imagine novices in innodb like me will have to know what to do :)
Programming is like sex:
One mistake and you have to support it for the rest of your life.
15
flymirco
Re: Custom module installation problem

  • 2009/7/16 22:43

  • flymirco

  • Just popping in

  • Posts: 42

  • Since: 2006/9/20


I don't think that module users known what a reference key is. They just answer to a simple survey and I am building the infrastructure to allow them to choose between alternatives.

flymirco
« 1 (2)

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

255 user(s) are online (170 user(s) are browsing Support Forums)

Members: 0

Guests: 255

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits