Andy Jarrett // Code. Develop. Create.

BlogCFC 3.5.2

If you are on MySQL and updating to Ray's new blog code, the following SQL statement should help you:

ALTER TABLE `tblblogcategories` ADD `blog` VARCHAR(50) NOT NULL;
ALTER TABLE `tblblogcomments` ADD `subscribe` TINYINT(1) NOT NULL;
ALTER TABLE `tblblogentries` ADD `alias` VARCHAR(100) default NULL;
ALTER TABLE `tblblogentries` ADD `username` VARCHAR(50) default NULL;
ALTER TABLE `tblblogentries` ADD `blog` VARCHAR(50) NOT NULL;

This helps you set up the structure. If you really want to set up the DB for your blog, amend the following SQL:

ALTER TABLE `tblblogcategories` ADD `blog` VARCHAR(50) default 'your blog name' NOT NULL;
ALTER TABLE `tblblogcomments` ADD `subscribe` TINYINT(1) NOT NULL;
ALTER TABLE `tblblogentries` ADD `alias` VARCHAR(100) default 'your alias name';
ALTER TABLE `tblblogentries` ADD `username` VARCHAR(50) default 'your login username';
ALTER 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 log in with.

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

I’m here, learning and working away. If you liked this content and want to keep me going, consider buying me a coffee. Your support keeps this site running and the coffee brewing! ☕️