Table 'tblblogpagescategories' doesn't exist

Trying to add pages in BlogCFC 5.9.8.012 throws the error.

The reason is there was a table added in 5.9.8.11, but the readme.txt doesn't tell you which table was added. It also says the SQL files were updated for the new table BUT it fails to mention the installer was not updated. This means you have to get the error before you know to fix it. Once you figure all that out....

Just run the SQL for the new table, tblblogpagescategories:

Now you can add pages!

We moved a site off of the BlueOnyx box to a wordpress site, but wanted to continue using the BlueOnyx server for mail and mailing list management. I went into my domain registrar and reset the DNS servers to the new ones outside of my hosting provider's.

When sending an email to one of the mailing lists on this domain, I received the following error:

An error occurred while sending mail. The mail server responded:
5.0.0 rewrite: excessive recursion (max 50), ruleset canonify. Please check the message recipient
touchplayers@dallastouch.org and try again.

In the BlueOnyx GUI, I changed the Host Name for the domain from "www" to "mail". I ensured that the site was not managing any domains. Under DNS, the Selected domains box was empty. I restarted sendmail

Testing the email list produced this error on a returned email:

----- The following addresses had permanent fatal errors -----

(reason: 553 5.3.5 system config error)
----- Transcript of session follows -----
553 5.3.5 mail.mydomain.org. config error: mail loops back to me
(MX problem?)
554 5.3.5 Local configuration error

I made sure we had a 2 A records in the new DNS server. An A record that generated mail.mydomain.org and an MX record that pointed to that A record.

Testing the email server after that produced the same loop back error.

Changed the the Host name back to "www" from "mail" and restarted sendmail. Definition of insanity - same result. Recursion error. Changed the Host name, once again, to "mail".

Back to BlueOnyx GUI. Under "Services" on the left menu, clicked Web, checked to make sure the domain was a web server alias - mydomain.org. Checking just below on the menu, Email, and made sure that the Email Server Aliases were there - mydomain.org & mail.mydomain.org. Saved.

Went to /etc/mail/local-host-names and made sure that mydomain.org & mail.mydomain.org were present and www.mydomain.org was NOT present.

Restarted sendmail.

Here's the checklist:

1. Change the Host name from "www" to "mail".
2. Add A record for mail.mydomain.org and an MX record to point to it.
3. In BO, make sure the domain, mydomain.org, is a Web Server Alias, under Web Settings
4. In BO, make sure that mydomain.org & mail.mydomain.org are Email Server Aliases under Email Settings
5. Check /etc/mail/local-host-names - mydomain.org & mail.mydomain.org present, www.mydomain.org absent
6. Restart sendmail

Can't install MySQL Workbench on LinuxMint 12? Can't find MySQL Workbench in the Software Manager or Synaptic? Here's all you have to do:

Add a repostitory that has MySQL Workbench, update and then apt-get install.

Check your LInuxMint menu under Development and you have MySQL Workbench!

Once Railo is installed and configured on BlueOnyx, make sure you have a MySQL database created and have all the connection info, like username, database name, user password. Create the datasource in Railo Admin.

Download Mura Standard from www.getmura.com/download/mura-downloads/ to your local machine. Unzip or extract the .ZIP file. FTP all files up to your sites /web/ directory. I deleted everything in the /web/ folder EXCEPT /WEB-INF/. These files were created with the Railo install and left from the BO initial site creation.

In your browser, go to http:///index.cfm

I received this error:

Railo 3.3.1.000 Error (application) Message can't copy file [/home/.sites/33/site22/web/config/templates/settings.template.cfm] to [/home/.sites/33/site22/web/config/settings.ini.cfm] Detail Permission denied Stacktrace The Error Occurred in /home/.sites/33/site22/web/config/applicationSettings.cfm: line 88 86: 87: 88: 89: 90: called from/home/.sites/33/site22/web/Application.cfc: line 48 46: ---> 47: 48: 49: 50: We need to add Tomcat to the site's group and change permissions to write for the group on the /web/config/ directory and contents.

We need to adjust permissions

Then recursively add write permissions for the /web/config/ directory. Once you are in the /web/ directory.

This will allow site members to FTP files.

This will fix the permission denied for the config stuff

Navigate up a level and change ownership of /web/ to tomcat.

Next to run the SEO URL query strings for Mura, you'll have to modify the /web/WEB-INF/web.xml file to allow the wildcards:

add the following lines:

Restart tomcat.

You should be able to run your Mura site without issue. If you do, please comment here and I'll look into it.

Yikes! I forgot my Mura Admin Login Password!

Hey, it happens! Well forget retrieving it, reset the password instead.

In the tusers table update the password back to 'admin'. The hash equivalent is '21232F297A57A5A743894A0E4A801FC3'.

Go back to the Mura Admin Login screen and use 'admin' as username and password. Then go to Edit Profile within Mura and correct your password.

On a fresh install of FileZilla on LinuxMint12 throught the Software Manager, transferring files causes FileZilla to immediately close.

Even after installing curl, wxwidgets and associated python tools and libraries through the Software Manager and Update Manager, FileZilla still crashes upon dragging files over to the server window.

Here is the solution: Linux Mint 12 causing Filezilla to crash

Apparently there is a bug? in LinuxMint12 in which FileZilla requires curl and the wxWidgets library to be installed manually through apt-get. Here are the instructions.

In a terminal,

In the Software Manager's Edit Sources add the following:

Go back to the terminal,

Hopefully, this will be fixed later, but for now.....

ZIP

To compress a directory with zip do the following:

Here's how you extract a zip archive:

TAR

Tar is a very commonly used archiving format on Linux systems. The advantage with tar is that it consumes very little time and CPU to compress files, but the compression isn't very much either. Here's how you compress a directory:

And to extract the archive:

This will extract the files in the my_archive_name.tar archive into the current directory. Like with the tar format you can optionally extract the files to a different directory:

TAR.GZ

To compress a directory utilizing TAR.GZ use the following syntax:

To decompress an archive use the following syntax:

This will extract the files in the archive_name.tar.gz archive in the current directory. Like with the tar format you can optionally extract the files to a different directory:

TAR.BZ2

This format has the best level of compression among all of the formats. But this comes at a cost – in time and in CPU. Here's how you compress a directory using tar.bz2:

This will extract the files in the archive_name.tar.bz2 archive in the current directory. To extract the files to a different directory use:

Use the mysqldump command to back up your MySQL databases.

You cannot use the mysqldump command to restore the database. Use the mysql command instead.

To backup multiple databases:

To back up all of your databases:

And to restore all of your databases just omit the database name:

This will work if you have multiple databases in your mysqldump file too.

Mura, unsuccessfully trying to do a Multi-Site Version Update with Core Version 5.4.4602 and Site Version 5.4.4602 just after updating the core files from Core Version 5.3.3088 and Site Version 5.3.3675.

Cannot reload application. It results in the following error: Unknown column 'draft.changesetID' in 'field list'

Also, cannot edit pages in the Site Manager, they will not open.

Mura on Ubuntu, Railo and MySQL.

Error: