Error During 1.5 setup

[PJH]

Hello,

I am trying to deploy v1.5 to my validation server. I have performed
the following steps:

1.) Dropped the uncompressed files into a folder under my domain
/inetpub/wwwroot/myDomain/BugLogHQ

2.) Created a ColdFusion mapping /buglog which points to C:\Inetpub
\wwwroot\myDomain\buglogHQ

3.) Ran the MS2005 scripts to create the database (in MS2008)

4.) This url "http://www.myDomain.com/bugloghq" generates the
following error


Message: Error Executing Database Query.
Type: Database
Details: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect
syntax near '`'.
Tag Context: • C:\Inetpub\wwwroot\pajesoft\BugLogHQ\components\lib\dao
\dbDataProvider.cfc (line 35)
• C:\Inetpub\wwwroot\pajesoft\BugLogHQ\components\lib\dao\DAO.cfc
(line 35)
• C:\Inetpub\wwwroot\pajesoft\BugLogHQ\components
\extensionsService.cfc (line 27)
• C:\Inetpub\wwwroot\pajesoft\BugLogHQ\components
\extensionsService.cfc (line 16)
• C:\Inetpub\wwwroot\pajesoft\BugLogHQ\hq\components\services
\appService.cfc (line 36)
• C:\Inetpub\wwwroot\pajesoft\BugLogHQ\hq\Application.cfc (line 239)
• C:\Inetpub\wwwroot\pajesoft\BugLogHQ\hq\Application.cfc (line 125)
• C:\Inetpub\wwwroot\pajesoft\BugLogHQ\hq\Application.cfc (line 53)

[Oscar Arevalo]

Hi Peter,

Actually bugLog should run on a directory named /bugLog, there is no need for it to be named "/bugloghq" (that was  my fault while creating the archive).  But i'm not sure if that is the cause of the error. It would help if we could see the full error dump, including the actual SQL statement that it was trying to execute.

Try this:

go to /bugLog/hq/handlers/ehGeneral.cfc and change line 54 from:

} catch(any e) {

to

} catch(whatever e) {

and then go to /buglog/hq again. This time the error will not be trapped and then we will be able to see the full error.

Oscar

--
Oscar Arevalo

http://about.me/oarevalo
http://www.coldbricks.com - Content Management System
http://www.oscararevalo.com - My Blog

[Oscar Arevalo]

I think I know what is wrong. Check the file /bugLog/config/buglog-config.xml.cfm

Look for the setting entry for "db.dbtype". The default is "mysql" but since you are on SQL Server, you should change it to be "mssql".

Oscar

On Mon, Feb 21, 2011 at 11:03 AM, PJH <peter.j...@gmail.com> wrote:

OK - so I changed the catch statement in the onRequestStart function
of the BugLog\hq\handlers\ehGeneral.cfc file and the error was still
trapped.  I even cycled the CF service to make sure something was not
cached.  I also updated the location and mapping to buglog instead of
bugloghq.  I am using CF9.

[PJH]

OK - so I changed the catch statement in the onRequestStart function
of the BugLog\hq\handlers\ehGeneral.cfc file and the error was still
trapped. I even cycled the CF service to make sure something was not
cached. I also updated the location and mapping to buglog instead of
bugloghq. I am using CF9.

On Feb 21, 12:58 pm, Oscar Arevalo <oarev...@gmail.com> wrote:

[PJH]

That was the issue. Thanks

[PJH]

Ok - now that I have the database configured the login page paints.
When I enter a id/password the error message below appears with a Stop
icon:

"Element EMAIL is undefined in QRY"

> > > Oscar Arevalohttp://about.me/oarevalohttp://www.coldbricks.com-Content
> > Management Systemhttp://www.oscararevalo.com-My Blog
>

[Oscar Arevalo]

Hey, yeah, this is an issue someone else pointed out on the RIAForge forum this morning. There was stuff missing/incorrect in the sql scripts for MSSQL. I uploaded a new version of buglog to bugloghq.riaforge.org (version 1.5.168) with the correct scripts.

If you don't want to run the script again, just make sure that the bl_user table has an "email" nullable field with type varchar(255)

Oscar

[PJH]

Added the field - Issue Fixed - everything seems to work now. Thank
you.

[Oscar Arevalo]

Excellent!