Welcome to Geeklog, Anonymous Saturday, June 22 2024 @ 05:00 am EDT

Geeklog Forums

Filemgmt install error with MSSQL


Chewie

Anonymous
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?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
From what I can see, the File Management plugin doesn't support MS SQL yet.

bye, Dirk
 Quote

Status: offline

mevans

Forum User
Full Member
Registered: 02/08/04
Posts: 393
Location:Texas
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

 Quote

Chewie

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

Status: offline

jmucchiello

Forum User
Full Member
Registered: 08/29/05
Posts: 985
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.
 Quote

All times are EDT. The time is now 05:00 am.

  • 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