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 troubleshooting 
  4.  / Can't install ecoTut 1.2
Register
1
deka87
Can't install ecoTut 1.2

  • 2008/11/9 7:41

  • deka87

  • Friend of XOOPS

  • Posts: 1125

  • Since: 2007/10/5


hi,

i have problems installing ecoTut 1.2 module. i get some syntax error. please take a look:
Unable to install ecoTut. Error(s): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mod int(1) NOT NULL default '0', supID int(10) unsigned NOT NULL default '0',' at line 7


i find this module just great, so please help me out guys.
Mind anchors
2
sailjapan
Re: Can't install ecoTut 1.2

Never heard of this module. Where did you find it?

[Edit: Found it in the repository . 2004 vintage. Good luck!]
Never let a man who does not believe something can be done, talk to a man that is doing it.
3
deka87
Re: Can't install ecoTut 1.2

  • 2008/11/9 8:31

  • deka87

  • Friend of XOOPS

  • Posts: 1125

  • Since: 2007/10/5


is there any way to fix that error? or any other ask/answer module? like somebody asks a question and another one answers? i've tried smartfaq but i noticed only Q&A submission =(
Mind anchors
4
sailjapan
Re: Can't install ecoTut 1.2

smartFAQ can have comments activated. Look at the FAQ on this site for an example. Questions can be submitted...
-What's different that you want to do?
-Who do you want to answer the FAQ questions? Moderators/admin or other users?
-How about a forum?

Sorry, I don't really understand what you are trying to do.
Never let a man who does not believe something can be done, talk to a man that is doing it.
5
deka87
Re: Can't install ecoTut 1.2

  • 2008/11/9 10:49

  • deka87

  • Friend of XOOPS

  • Posts: 1125

  • Since: 2007/10/5


I want other users answer the questions. and it's not going to be FAQ it's just gonna be questions regarding terms translation posted by general users. please, take a look here: http://www.proz.com/?sp=k2 - a user asks a question, http://www.proz.com/kudoz - other users anser the questions posted. the reason why i dont want to use general forum for this is because it'd be better to run it as a separate module and i need more complicated ASK QUESTION form.
Mind anchors
6
ghia
Re: Can't install ecoTut 1.2

  • 2008/11/9 11:51

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


'mod' is a reserved word in your mySQL version.
You have to edit the sql file in the sql directory to change mod in modif.
Then you have to lookup in all the files the lines containing xoopsDB. On these lines replace mod by modif.
That should let the module run.
For security: don't use it without Protector!
7
deka87
Re: Can't install ecoTut 1.2

  • 2008/11/9 12:46

  • deka87

  • Friend of XOOPS

  • Posts: 1125

  • Since: 2007/10/5


thanks ghia, i followed your instructions and installed the module succesfully. but now i get a blank page when go to http://mysite/modules/ecoTut/admin/index.php ( other pages of the module seem to work ok. i run XOOPS 2.2
Mind anchors
8
ghia
Re: Can't install ecoTut 1.2

  • 2008/11/9 13:47

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Very odd, because it is such a small function, which is almost a template for faq.php etc. in admin. Does the Navigate Topic button work in category admin?
9
deka87
Re: Can't install ecoTut 1.2

  • 2008/11/9 14:30

  • deka87

  • Friend of XOOPS

  • Posts: 1125

  • Since: 2007/10/5


oh i've tried and found out that none of the scripts from the admin directory work. they all cause blank page.
Mind anchors
10
deka87
Re: Can't install ecoTut 1.2

  • 2008/11/9 14:54

  • deka87

  • Friend of XOOPS

  • Posts: 1125

  • Since: 2007/10/5


I think I've found another module that can help me out in this case. thanks guys
Mind anchors

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

544 user(s) are online (202 user(s) are browsing Support Forums)

Members: 0

Guests: 544

more...

Donat-O-Meter

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

Latest GitHub Commits