Welcome to Geeklog Tuesday, October 15 2019 @ 11:01 pm EDT

Geeklog Forums

Downloads Plugin Error


David

Anonymous
On Install I get a sql error at line 260. Says there is a problem with the syntax. I posted the exact error in the comments section under downloads, but I suppose the moderator has to approve it. In the meantime, has anyone run into this, and what can I do about it?

THANKS!

David

Anonymous
I just tried to install the navigation plugin and got the same error as witht the downloads plugin. It seems whenever I install DENGEN's plugins I receive the same sort of error. (SEE BELOW)

An error has occurred:
(This text is only displayed to users in the group 'Root'Wink

256 - An SQL error has occurred. Please see error.log for details. @ (geeklog location)\system\databases\mysql.class.php line 260

Then it produces the following:

PHP Formatted Code
array(3) {
  ["sql"]=>
  string(997) "
CREATE TABLE gl_navmmenus (
  nid varchar(40) NOT NULL default '',
  gid tinyint(1) NOT NULL default '1',
  name varchar(48) default NULL,
  is_enabled tinyint(1) unsigned NOT NULL default '1',
  php_function varchar(48) default NULL,
  tid varchar(20) NOT NULL default 'all',
  class_name varchar(48) default NULL,
  template_name varchar(48) default 'default',
  var_name tinyint(1) NOT NULL default '0',
  navorder smallint(5) unsigned NOT NULL default '1',
  pattern varchar(255) default NULL,
  render tinyint(1) NOT NULL default '0',
  render_for tinyint(1) NOT NULL default '0',
  opt_match tinyint(1) NOT NULL default '0',
  owner_id mediumint(8) unsigned NOT NULL default '1',
  group_id mediumint(8) unsigned NOT NULL default '1',
  perm_owner tinyint(1) unsigned NOT NULL default '3',
  perm_group tinyint(1) unsigned NOT NULL default '2',
  perm_members tinyint(1) unsigned NOT NULL default '2',
  perm_anon tinyint(1) unsigned NOT NULL default '2',
  PRIMARY KEY (nid)
) TYPE=MyISAM
"

  ["ignore_errors"]=>
  int(0)
  ["result"]=>
  bool(false)
}

David

Anonymous
Now I am thinking the issue has something to do with my MYSQL version (latest version)

on the Maps plugin I get this:

An error has occurred:
(This text is only displayed to users in the group 'Root'Wink

256 - An SQL error has occurred. Please see error.log for details. @ (...)\system\databases\mysql.class.php line 260

PHP Formatted Code
array(3) {
  ["sql"]=>
  string(201) "
CREATE TABLE gl_maps_geo (
  gid INT NOT NULL AUTO_INCREMENT,
  geo varchar(255) NOT NULL default '',
  lat FLOAT( 10, 6 ) NOT NULL ,
  lng FLOAT( 10, 6 ) NOT NULL ,
  PRIMARY KEY (gid)
) TYPE=MyISAM
"

  ["ignore_errors"]=>
  int(0)
  ["result"]=>
  bool(false)
}


I hope someone can help I am at a loss.

David

Anonymous
So it seems the "TYPE=" declaration in the latest version of MySQL is no longer supported. You must edit your code to say ENGINE=MyISAM.

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
Quote by: David

So it seems the "TYPE=" declaration in the latest version of MySQL is no longer supported. You must edit your code to say ENGINE=MyISAM.


Thanks for tracking down the problem. Are you using MySQL 5.5 then?

FWIW, we already switched to using ENGINE for the core Geeklog code and bundled plugins. We may be able to change that on the fly for plugins that are installed via upload in Geeklog - have to look into that.

bye, Dirk

David

Anonymous
Are you using MySQL 5.5 then?


Yes.

Status: offline

::Ben

Forum User
Full Member
Registered: 14/01/05
Posts: 1569
Location:la rochelle, France
ENGINE=MyISAM

Is it compatible with old mysql versions?

::Ben
I'm available to customise your themes or plugins for your Geeklog CMS

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
ENGINE is the preferred term, but cannot be used before MySQL 4.0.18.

http://dev.mysql.com/doc/refman/4.1/en/storage-engines.html

MySQL 4.0.18 also happens to be the minimum supported version for Geeklog now (and that is no coincidence).

bye, Dirk

Status: offline

dengen

Site Admin
Admin
Registered: 03/05/07
Posts: 37
Location:Japan
Thank you for reporting.

Quote by: David

So it seems the "TYPE=" declaration in the latest version of MySQL is no longer supported. You must edit your code to say ENGINE=MyISAM.



About this issue, I will fix when the next release.

dengen

All times are EDT. The time is now 11:01 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content