Installation
So I'm beginning to think about the install process for BlogCFC. I will admit that Mango (as reviewed by Brian here) is what I consider to be the minimum standard for V6. Now I can handle creating DSNs and a multistep process. What I'm curious about though is how to create the database. Creating tables is easy enough. But given a valid DSN (and assuming you have permissions), is it relatively easy to create the initial database? (I'm just concerned about SQL Server and MySQL for now.)
And if folks want to help out - this would be an area where you could help right now. You could write a script that has a hard coded DSN on top (again, assume the DSN is valid), and that then reads in a file for SQL commands to create the DB and tables. All I ask is that if you want to do this - "claim" it with a blog comment so we don't duplicate efforts. (And if you are late and want to help another commenter, just say so.)
1) Will BlogCFC6 migrate BlogCFC 5.9.
Probably not. With V6 being VERY different, I'm assuming it won't be possible. Obviously I'll include docs.
2) Will BlogCFC6 have an installer.
Yes
3) Will future versions have migration scripts?
Yes, for post 6.0 releases I want to make things as easy as possible for updates. My dream is 'one click via admin' updates.
Cheers.
Run it;
http://code.mrbuzzy.biz/blogcfc/database.cfm
View source;
http://code.mrbuzzy.biz/blogcfc/database.cfm?sauce
Now you've seen this. What did you really have in mind? :)
The user has full system privileges, but because the database is missing the dsn doesn't work.
You might be able to add a new database if you have an entirely active dsn connection, but its probably more work than it worth when you could just set up a new db with a suitable username and password and plug them into the installer. I think thats the tack I'd probably take.
If I follow you - this is *exactly* why I thought up my "dsn-less" cfquery tag:
http://cfsilence.com/blog/client/index.cfm/2007/11...
But after talking to Ray I tested creating a DSN without pointing to a database and it seemed to work with MS SQL 2000. Are you saying it doesn't work?
Use Master
Create Database 'foo' .....
Master is SQL server specific, but all DBMS must have some equivalent, no?
RE: "master" database - mysql has a "mysql" database, but you'd have to set up a dsn entry that points to it and has access, which brings you back around to creating an empty DB with an appropriate user assigned to it. But I'll have a play with the DNSLess cfquery later tonight
Will BlogCFC run on a Windows 2K3 - IIS 6 platform as it does on a UNIX /Linux Apache 2 ?
My h osting account offers only Windows pared to CF MX 6.1 and CF MX 7.
I actually was looking into something like : http://www.revolutiontheme.com/purchase
but instead using the BlogCFC.
The following is the internal exception message: access denied (java.io.FilePermission E:\foodgurus.net\wwwroot\Application.cfm execute)
I cannot seem to get your blog going .. any idea what the message above means?
kind regards
Anthony
any thing in particular that my webhost should look at? I have de luxe semi VPS hosting plan with my webhost but I do not have admin rights on the server or OS.
where I can find the BlogCFC v6 or 5.9? On the website the download area does not function any more!!
Can you help me please?
;-)
I have some questions about installation on my Windows 2003 / MS SQL Server 2005 / CF 8 server.
For example: "If your web site will only contain the blog, then obviously this folder will be your web root..."
This instruction confuses me. The instruction seems to instruct me to replace, on my Windows server, c:\Inetpub\wwwroot\ with the folder \client\ from the BlogCFC download package. Obviously that can't be right, but I am not sure exactly where to place the \client\ folder.
I have other questions too. I'm studying the BlogCFC.doc instructions to attempt to answer them for myself.
Where's a good place to pose those questions?
I'm really grateful for any assistance and look forward to using this great application.
Peace.
Eric
Kind regards,
Eric