annotation instalation error

[leeni]

Hello,
I tring install the annotation plugin. Put all dowloadid files on catalog, so I can see the plugin under plugin manager, but when I try to install them I got message - Critical Error Database Query Error occur.
version 1.5.38 and plugin v3.0

Is there some of files missing or am I missing something?

Thanks

[Αndré]

Please enable debug mode in the Coppermine config and try again to get an extended error message.

[leeni]

While executing query '


CREATE TABLE IF NOT EXISTS `pcan_plugin_annotate` (
  nid smallint(5) unsigned NOT NULL auto_increment,
  pid mediumint( unsigned NOT NULL,
  posx smallint(5) unsigned NOT NULL,
  posy smallint(5) unsigned NOT NULL,
  width smallint(5) unsigned NOT NULL,
  height smallint(5) unsigned NOT NULL,
  note text NOT NULL,
  user_id smallint(5) unsigned NOT NULL,
  PRIMARY KEY  (nid)
) TYPE=MyISAM  COMMENT='Contains the data for the annotate plugin'' in plugins/annotate/codebase.php on line 328

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM  COMMENT='Contains the data for the annotate plugin'' at line 11

Fail: /data01/virt49169/domeenid/www.ajatunnetus.ee/malestused/fotod/include/functions.inc.php - Row: 272

[Αndré]

In codebase.php, find and remove

Code Select Expand

TYPE=MyISAM  COMMENT='Contains the data for the annotate plugin'
and try to install again.

[leeni]

No such text on this file.

In codebase.php, find and remove

Code Select Expand

TYPE=MyISAM  COMMENT='Contains the data for the annotate plugin'
and try to install again.

[Krys]

Hello,

I would suggest to replace "TYPE" by "ENGINE", this keyword is deprecated since a long time now.

[Αndré]

The code is in schema.sql, sorry.

[leeni]

Thank you. Now works.