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.  / Problem installing Publisher, MySQL version?
Register
1
bjuti
Problem installing Publisher, MySQL version?

  • 2012/2/28 13:23

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


Hi there,

I have problem installing Publisher module. The error is:

Quote:
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 18


Debug says:

Quote:
0.000537 - CREATE TABLE publisher_categories ( `categoryid` int(11) NOT NULL auto_increment, `parentid` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `description` text NOT NULL, `image` varchar(255) NOT NULL default '', `total` int(11) NOT NULL default '0', `weight` int(11) NOT NULL default '1', `created` int(11) NOT NULL default '1033141070', `template` varchar(255) NOT NULL default '', `header` text NOT NULL, `meta_keywords` text NOT NULL, `meta_description` text NOT NULL, `short_url` varchar(255) NOT NULL default '', `moderator` int(6) NOT NULL default '0', PRIMARY KEY (`categoryid`), KEY parentid (parentid) ) TYPE=MyISAM
Error number: 1064
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 18


MySQL version is 5.5.x, so what should I change in publisher.sql or wherever it is to have working version of Publisher. The version that I try to install is working version on few live sites.

Tnx.
2
Anonymous
Re: Problem installing Publisher, MySQL version?

  • 2012/2/28 13:55

  • Anonymous

  • Posts: 0

  • Since:


After looking at some older issues I guess changing 'TYPE=MyISAM' to 'ENGINE=MyISAM' in the sql file could do the trick.
3
bjuti
Re: Problem installing Publisher, MySQL version?

  • 2012/2/28 22:18

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


Where to change it? In mysql.sql? I've tried to do it, but it's the same.
4
Anonymous
Re: Problem installing Publisher, MySQL version?

  • 2012/2/28 22:51

  • Anonymous

  • Posts: 0

  • Since:


Which version of xoops and Publisher? For me no problems with xoops 2.5.4 and publisher 1.0.
5
Anonymous
Re: Problem installing Publisher, MySQL version?

  • 2012/2/28 22:55

  • Anonymous

  • Posts: 0

  • Since:


I don't know the exact name of the publisher .sql file... But be aware there could be more instances of 'TYPE=MyISAM' you have to change to 'ENGINE=MyISAM' !
6
Anonymous
Re: Problem installing Publisher, MySQL version?

  • 2012/2/28 23:07

  • Anonymous

  • Posts: 0

  • Since:


TYPE is deprecated and has been removed from MYSQL 5. something.

So replace all TYPE= with ENGINE= in the sql/mysql.sql file. In my opinion this is changed in latest version on sourceforge.

See also This link
7
Mamba
Re: Problem installing Publisher, MySQL version?

  • 2012/2/28 23:09

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


Quote:
Where to change it? In mysql.sql? I've tried to do it, but it's the same.


As Flipse said, there could be more SQL files.

It's always easy to find it with a tool like "Info Rapid Search & Replace".

Just search the Publisher's SQL directory and it will show you where it is. You can then replace it with this tool.

BTW, it seems like you have an old version. The latest version of Publisher has those things fixed. Get the RC1 version from Sourceforge
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
8
Peekay
Re: Problem installing Publisher, MySQL version?

  • 2012/2/28 23:10

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


The solution I find that (normally) works is to get rid of the 'TYPE=MyISAM' entry altogether, but watch that you close the SQL statement correctly.

Publisher is pretty new AFAIK so I would imagine it should work with MySQL 5, but I suppose every incremental version of MySQL will bring it's own incompatibilities.

If it continues to fail, you need to notify the developer.
A thread is for life. Not just for Christmas.
9
Anonymous
Re: Problem installing Publisher, MySQL version?

  • 2012/2/28 23:19

  • Anonymous

  • Posts: 0

  • Since:


That's support!! Within 20 minutes you recieved 5 reply's!
10
bjuti
Re: Problem installing Publisher, MySQL version?

  • 2012/2/29 9:30

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


Hahah really, this is support :)

Tnx all, I\ll test it today and inform you about results :)
(1) 2 3 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

261 user(s) are online (207 user(s) are browsing Support Forums)

Members: 0

Guests: 261

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