1
Xetox
XM-Memberstats 2.0e Install Error.
  • 2005/11/17 17:12

  • Xetox

  • Just popping in

  • Posts: 71

  • Since: 2005/10/28


I was wanting to install the cool whos online mod...which I think is XM-Memberstats correct?

Well when I go to install it I get error..

Unable to install xmmemberstats. 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 'ENGINE=MyISAM' at line 8

2
Bender
Re: XM-Memberstats 2.0e Install Error.
  • 2005/11/17 19:52

  • Bender

  • Home away from home

  • Posts: 1899

  • Since: 2003/3/10


Let me guess:

The MySQL version on your server is older than 4.0.18?

Quote:

ENGINE is the preferred term, but cannot be used before MySQL 4.0.18. TYPE is available beginning with MySQL 3.23.0, the first version of MySQL for which multiple storage engines were available.




In theory it should work fine if you open the sql/mysql.sql file and change it to TYPE=MyISAM;

Quote:

CREATE TABLE iptoc (
id int(25) NOT NULL default '0',
ipfrom double(15,0) NOT NULL default '0',
ipto double(15,0) NOT NULL default '0',
country2 char(2) NOT NULL default '',
country3 char(3) NOT NULL default '',
country varchar(35) NOT NULL default ''
) TYPE=MyISAM;
Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...

3
suico
Re: XM-Memberstats 2.0e Install Error.
  • 2007/3/27 0:35

  • suico

  • Friend of XOOPS

  • Posts: 374

  • Since: 2003/7/24


Thanks bender, this old post of you still helps a lot !
Yogurt Social Network Service
Visit: http://www.marcellobrandao.eti.br/

Login

Who's Online

305 user(s) are online (228 user(s) are browsing Support Forums)


Members: 0


Guests: 305


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