1
melsen
Can't install the TeamSpeak module on 2.2.3? Weird error....
  • 2005/12/16 21:33

  • melsen

  • Just popping in

  • Posts: 97

  • Since: 2003/6/22


This doesn't work for me on XOOPS 2.2.3.


When I install it I get this error:

Quote:
Unable to install xoops_teamspeak. Error(s):
Duplicate column name 'user_id'


Does anyone know how to fix that?
Allan Melsen
[size=x-small]Founder of R.I.A.[/size]

Renegade Insane Asylum

2
Bananadude
Re: Can't install the TeamSpeak module on 2.2.3? Weird error....
  • 2005/12/16 21:55

  • Bananadude

  • Not too shy to talk

  • Posts: 155

  • Since: 2005/9/16


It seems to be an error in the sql-file.

Open modules\xoops_teamspeak\sql\xoops_teamspeak.sql
go to line 146 and and find
Quote:

PRIMARY KEY (user_id, user_id),
KEY detail_id (user_id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


delete one of the user_id like this:
Quote:
PRIMARY KEY (user_id),
KEY detail_id (user_id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


Do the same to line 186 with server_id:
Quote:

server_timestamp varchar(255) NOT NULL default '',
PRIMARY KEY (server_id, server_id),
KEY id (server_id)


Best Regards,
Bananadude
--- censored by Bananadude ---

Login

Who's Online

156 user(s) are online (102 user(s) are browsing Support Forums)


Members: 0


Guests: 156


more...

Donat-O-Meter

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

Latest GitHub Commits