BlogCFC will never have an installer. Ever. Until today...
Ok, so the title is a bit misleading. I'm not releasing an installer today in any formal sense, but I do have the bits ready for testing. The installer handles prompting for a DSN, running import scripts (MySQL and SQL Server only, and be warned - this drops tables), and asking for basic settings to help get you started. It also auto-kills itself so it can't be run again. Some screen shots (sorry for how small they are):
Before testing, add the following line (to a virgin BlogCFC install) to your blog.ini.cfm file:
installed=no
Enjoy!
<!--- Do we need to run the installer? --->
<cfif not application.blog.getProperty("installed") is 1>
<cflocation url="./installer/index.cfm?blog=#urlEncodedFormat(blogname)#" addToken="false">
</cfif>
Add this right after this line:
<!--- load and init blog --->
<cfset application.blog = createObject("component","org.camden.blog.blog").init(blogname)>
installed is not a valid property.
The error occurred in D:\www\jacfb\org\camden\blog\utils.cfc: line 62
Called from D:\www\jacfb\org\camden\blog\blog.cfc: line 1867
Called from D:\www\jacfb\Application.cfm: line 42
60 : hint="Throws errors.">
61 : <cfargument name="message" type="string" required="false" default="">
62 : <cfthrow type="blog.cfc" message="#arguments.message#">
63 :
64 : </cffunction>
<cfset instance.installed = variables.utils.configParam(variables.cfgFile, arguments.name, "installed")>
at the end of the init in blog.cfc
Operator error maybe?
Teaches you to try to be helpful, Ray. Maybe you should just release half-built frameworks with no documentation, then, if they get popular, pawn off their maintenance on other...I mean, it works for me :).
never heard that one before....
running the script right out of the box
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
yup, definitely "operator error"
>>Teaches you to try to be helpful, Ray. Maybe you should just release half-built frameworks with no documen...
if you are going to be facetious at least put some effort in to it
@ray, thank you for the offer, i apologize if my previous post came across offensive, but i worked on the install for over an hour and finally gave up, i tried two other potential blogging options and had them both up and running in under 10 minutes, so yea, an hour on just one was frustrating
ran installer
installer/step3_runscripts.cfm
Line 6: Incorrect syntax near 'max'.
in reviewing this it seems the script is MSSQL 2005+, my local test environment is 2003, therefore, the base script is incompatible with my test environment, however the script indicates that it is mssql compliant, sqlserver.sql, perhaps including a 2005+ and an "other" script would be beneficial for those testing on older systems.
manually running the script in 2005 results in no errors.
Edit mssql/script.txt and replace all nvarchar(max) with ntext.
Does that help? I don't have SQL Server 2003 to test on so I need your help here.
eg
CREATE NONCLUSTERED INDEX [tblusers_blogUsers_blog] ON [dbo].[tblusers]
([blog])
WITH (
PAD_INDEX = OFF,
DROP_EXISTING = OFF,
STATISTICS_NORECOMPUTE = OFF,
SORT_IN_TEMPDB = OFF,
ONLINE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
gives error
Line 3: Incorrect syntax near '('.
the samples i have been be to review for this code block do not have a ( after the WITH keyword
http://msdn.microsoft.com/en-us/library/aa258260%2...
again this seems to be an MSSQL 2003 issue as 2005 works
I'm trying to use your installer. CF9 running built in webserver, windows 7. This is my development area. ThenI will move it to HostMySite. The client is installed under the root, ord under client, install under rrot. I create DSN pointing to the MSACCESS you provided. I never get the screnns that you show here. This is the error I'm getting.
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
The error occurred in C:\ColdFusion9\wwwroot\TLQ2010\client\org\camden\blog\page.cfc: line 86
Called from C:\ColdFusion9\wwwroot\TLQ2010\client\includes\pods\pages.cfm: line 11
Called from C:\ColdFusion9\wwwroot\TLQ2010\client\tags\getpods.cfm: line 32
Called from C:\ColdFusion9\wwwroot\TLQ2010\client\tags\layout.cfm: line 121
Called from C:\ColdFusion9\wwwroot\TLQ2010\client\index.cfm: line 315
Called from C:\ColdFusion9\wwwroot\TLQ2010\client\index.cfm: line 31
Called from C:\ColdFusion9\wwwroot\TLQ2010\client\index.cfm: line 1
Called from C:\ColdFusion9\wwwroot\TLQ2010\client\org\camden\blog\page.cfc: line 86
Called from C:\ColdFusion9\wwwroot\TLQ2010\client\includes\pods\pages.cfm: line 11
Called from C:\ColdFusion9\wwwroot\TLQ2010\client\tags\getpods.cfm: line 32
Called from C:\ColdFusion9\wwwroot\TLQ2010\client\tags\layout.cfm: line 121
Called from C:\ColdFusion9\wwwroot\TLQ2010\client\index.cfm: line 315
Called from C:\ColdFusion9\wwwroot\TLQ2010\client\index.cfm: line 31
Called from C:\ColdFusion9\wwwroot\TLQ2010\client\index.cfm: line 1
84 : select id, blog, title, alias, body, showlayout
85 : from tblblogpages
86 : where blog = <cfqueryparam cfsqltype="cf_sql_varchar" value="#variables.blog#" maxlength="50">
87 : order by title asc
88 : </cfquery>
Thanks, Jim
I'm installing blogcfc525. Ran http://localhost:8500/catholicpages/blogcfc5/clien... and got the error:
installed is not a valid property.
The error occurred in C:\ColdFusion8\wwwroot\org\camden\blog\utils.cfc: line 62
Called from C:\ColdFusion8\wwwroot\org\camden\blog\blog.cfc: line 1867
Called from C:\ColdFusion8\wwwroot\catholicpages\blogcfc5\client\Application.cfm: line 42
60 : hint="Throws errors.">
61 : <cfargument name="message" type="string" required="false" default="">
62 : <cfthrow type="blog.cfc" message="#arguments.message#">
63 :
64 : </cffunction>
blog cfc does have the line:
<cfset instance.installed = variables.utils.configParam(variables.cfgFile, arguments.name, "installed")>
at the end of the init, as someone above suggested.
Any ideas?
Cheers,
Paul