Welcome to Geeklog, Anonymous Saturday, August 31 2024 @ 11:30 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!
THANKS!
11
12
Quote
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 Wink](https://www.geeklog.net/forum/image_set/pixel.gif)
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:
["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)
}
An error has occurred:
(This text is only displayed to users in the group 'Root'
![Wink Wink](https://www.geeklog.net/forum/image_set/pixel.gif)
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:
Text 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)
}
9
11
Quote
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 Wink](https://www.geeklog.net/forum/image_set/pixel.gif)
256 - An SQL error has occurred. Please see error.log for details. @ (...)\system\databases\mysql.class.php line 260
["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.
on the Maps plugin I get this:
An error has occurred:
(This text is only displayed to users in the group 'Root'
![Wink Wink](https://www.geeklog.net/forum/image_set/pixel.gif)
256 - An SQL error has occurred. Please see error.log for details. @ (...)\system\databases\mysql.class.php line 260
Text 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.
16
12
Quote
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.
12
9
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/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
10
15
Quote
David
Anonymous
Are you using MySQL 5.5 then?
Yes.
12
10
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/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
11
8
Quote
Status: offline
dengen
Site Admin
Admin
Registered: 05/03/07
Posts: 37
Location:Japan
Thank you for reporting.
About this issue, I will fix when the next release.
dengen
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
8
11
Quote
All times are EDT. The time is now 11:30 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