MS SQL update files posted

[Russ Johnson]

I just uploaded the sql scripts and one file that contains a fix for
sql server. You can find sqlserver-updates.zip in the files section.

There is a script for sqlserver 2000 and sqlserver 2k5. Also, I have
included a fixed copy of the activity.cfc file in the model directory
that had some incompatibilities with sql server.

This should be all you need to run Skweegee on sql server now.

Let me know if you run into any issues.

[Matt Graf]

I just installed Skweegee on my MAC and tried to run it and I get this error
An unhandled exception has occurred. Please look at the diagnostic
information below:
Type Expression
Message Variable GETDATASOURCE is undefined.
Detail
Extended Info
Message Variable GETDATASOURCE is undefined.
Tag Context /Library/WebServer/documents/skweegee/model/user.cfc (229)
/Library/WebServer/documents/skweegee/handlers/Dashboard.cfc (11)
/Library/WebServer/documents/mappings/coldbox/system/controller.cfc (405)
/Library/WebServer/documents/mappings/coldbox/system/coldbox.cfc (153)
/Library/WebServer/documents/skweegee/Application.cfc (38)

[Russ Johnson]

Looks like you dont have the transfer 1.1 release.

The getDatasource() method was added in transfer 1.1

- Russ

[Matt Graf]

yep I figured that out sorry

[Matt Graf]

Now I seem to be getting this error Element PERMISSIONS is undefined in SESSION.

[Russ Johnson]

Can you tell me where you are getting the error? What link are
clicking? Are you able to login and then get the error?

I need some info on the error. Can you send me the error output?

[Matt Graf]

I clicked on new project
An Unhandled Exception Occurred

An unhandled exception has occurred. Please look at the diagnostic
information below:
Type Expression

Message Element PERMISSIONS is undefined in SESSION.
Detail
Extended Info
Message Element PERMISSIONS is undefined in SESSION.
Tag Context /Library/WebServer/documents/skweegee/plugins/Security.cfc (20)
/Library/WebServer/documents/skweegee/views/dashboard/projectSidebar.cfm (5)
/Library/WebServer/documents/mappings/coldbox/system/plugins/renderer.cfc (119)
/Library/WebServer/documents/skweegee/handlers/Project.cfc (8)

/Library/WebServer/documents/mappings/coldbox/system/controller.cfc (405)
/Library/WebServer/documents/mappings/coldbox/system/coldbox.cfc (153)
/Library/WebServer/documents/skweegee/Application.cfc (38)

[Russ Johnson]

In handlers/Project.cfc comment out line 8.

<cfset rc.sideBar = getPlugin("renderer").renderView("dashboard/
projectSidebar")>

This should have been removed from that event, it doesnt belong there.

Im updating SVN and I will put a new release build up that has the sql
server stuff and these few other fixes I have made already.

- Russ