Geeklog Forums

Hi all, using Geeklog 1.4 and running SQL Server 2005.

Upon trying to install the Filemgmt plugin, I get the following error in the log file:

05/09/08 14:44:50 - Attempting to install the filemgmt Plugin
05/09/08 14:44:50 - executing CREATE TABLE gl_filemgmt_category (
cid int(5) unsigned NOT NULL auto_increment,
pid int(5) unsigned NOT NULL default '0',
title varchar(50) NOT NULL default '',
imgurl varchar(150) NOT NULL default '',
`grp_access` mediumint(8) NOT NULL default '0',
PRIMARY KEY (cid),
KEY pid (pid)
) TYPE=MyISAM
05/09/08 14:44:50 - Incorrect syntax near 'unsigned'.: Incorrect syntax near 'unsigned'.. SQL in question:
05/09/08 14:44:50 - Error Creating table
05/09/08 14:44:50 - Attempting to unregister the Forum plugin from Geeklog
05/09/08 14:44:50 - Removing Table gl_filemgmt_category
05/09/08 14:44:50 - Removing Table gl_filemgmt_filedetail
05/09/08 14:44:50 - Removing Table gl_filemgmt_filedesc
05/09/08 14:44:50 - Removing Table gl_filemgmt_broken
05/09/08 14:44:50 - Removing Table gl_filemgmt_votedata
05/09/08 14:44:50 - Removing Table gl_filemgmt_downloadhistory
05/09/08 14:44:50 - Removing filemgmt Admin Group
05/09/08 14:44:50 - Removing root users from Admin Group of filemgmt
05/09/08 14:44:50 - Removing filemgmt User Group
05/09/08 14:44:50 - Removing root users from Users Group of filemgmt
05/09/08 14:44:50 - Removing filemgmt.edit feature and rights to it
05/09/08 14:44:50 - DELETE FROM gl_access WHERE acc_ft_id =
05/09/08 14:44:50 - Removing filemgmt.user feature and rights to it
05/09/08 14:44:50 - DELETE FROM gl_access WHERE acc_ft_id =
05/09/08 14:44:50 - Removing filemgmt.upload feature and rights to it
05/09/08 14:44:50 - DELETE FROM gl_access WHERE acc_ft_id =
05/09/08 14:44:50 - Removing all comments for plugin filemgmt
05/09/08 14:44:50 - Removing block definition for plugin filemgmt
05/09/08 14:44:50 - ...success


Any hints?

From what I can see, the File Management plugin doesn't support MS SQL yet.

bye, Dirk

The only plugin, besides those bundled with the Geeklog distribution, that officially supports MS SQL is Media Gallery. I'm not aware of any others that have added the support.

There may be some that have written their SQL so it will work without modification, but as far as I can tell, only the one for sure is Media Gallery.

I'm willing to look at tweaking CAPTCHA and Chameleon to add MS SQL support, so if you are interested and willing to help me out a bit, we can certainly try to knock it out soon.

Thanks!
Mark

What should a plugin author do so their code works with MS SQL too?

Unfortunately, there isn't a simple list of things. They really must have MS SQL and they must test against it. Without it, they can only guess. The Geeklog MS SQL class can handle 99% of common SQL statements. But those other 1% are usually the important ones for making the plugin shine.