BlogCFC 3.5.2

If you are on MySql and updating to Rays new blog code the following SQL statement should help you:
ALTER TABLE `tblblogcategories` ADD `blog` VARCHAR(50) NOT NULL;
\nALTER TABLE `tblblogcomments` ADD `subscribe` TINYINT(1) NOT NULL;
\nALTER TABLE `tblblogentries` ADD `alias` VARCHAR(100) default NULL;
\nALTER TABLE `tblblogentries` ADD `username` VARCHAR(50) default NULL;
\nALTER TABLE `tblblogentries` ADD `blog` VARCHAR(50) NOT NULL;
This helps you set up the structure, if you really want to set up the DB to for your blog ammend the following SQL
ALTER TABLE `tblblogcategories` ADD `blog` VARCHAR(50) default 'your blog name' NOT NULL;
\nALTER TABLE `tblblogcomments` ADD `subscribe` TINYINT(1) NOT NULL;
\nALTER TABLE `tblblogentries` ADD `alias` VARCHAR(100) default 'your alias name';
\nALTER TABLE `tblblogentries` ADD `username` VARCHAR(50) default 'your login username';
\nALTER TABLE `tblblogentries` ADD `blog` VARCHAR(50) default 'your blog name' NOT NULL;
You can get "your blog name" from the .ini file in the square brackets[] e.g. [default]
"Your alias name" is the name you want to be associated with the post. For me it's Andy Jarrett
"Your login username" is what you login in with.

You still need to do a little work though, but the migration3.5.2.txt will help you there.
comments powered by Disqus