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.  / Xoops 2.5.3 and xhelp 0.7.8 SQL error
Register
1
AHLIS
Xoops 2.5.3 and xhelp 0.7.8 SQL error

  • 2011/10/8 0:53

  • AHLIS

  • Not too shy to talk

  • Posts: 189

  • Since: 2004/12/12


Hi there,

I'm doing a test and I'm using Wamp 2.2 64-bit and I'm trying to install xhelp 0.7.8 but after install I get this error message:

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 'TYPE=MyISAM' at line 6.

The module never shows up.

I guess this is an old module but I didn't find anyother help desk modul for xoops. Maybe you know a newer module or have an answere about this error

Best Regards
Ahlis

2
trabis
Re: Xoops 2.5.3 and xhelp 0.7.8 SQL error

  • 2011/10/8 2:06

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


Use 'ENGINE=MyISAM' instead. Look inside the sql folder.
3
AHLIS
Re: Xoops 2.5.3 and xhelp 0.7.8 SQL error

  • 2011/10/8 13:09

  • AHLIS

  • Not too shy to talk

  • Posts: 189

  • Since: 2004/12/12


Thanks.

Now I get this error:

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 'CREATE TABLE xhelp_department_mailbox ( id int(11) NOT NULL auto_increment, ' at line 8
4
AHLIS
Re: Xoops 2.5.3 and xhelp 0.7.8 SQL error

  • 2011/10/8 13:23

  • AHLIS

  • Not too shy to talk

  • Posts: 189

  • Since: 2004/12/12


Ups. Hade to change all 'TYPE=MyISAM' to 'ENGINE=MyISAM'. Changed only the first one.

The module installed as i should now.

Thanks for the help.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

367 user(s) are online (284 user(s) are browsing Support Forums)

Members: 0

Guests: 367

more...

Donat-O-Meter

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

Latest GitHub Commits