Pragmatism in code

Waxing lyrical about life the universe and everything software related since lunchtime 2006.

Jcomment to EasyBlog comment migration

The recent migration from Joomla 1.5 to Joomla 1.7 left me without a comments system for the tutorials section of the site. Previously this was handled by Jcomment, a great component that allows you to easily add commenting to standard Joomla articles, its only drawback, is that the Joomla 1.7 version is still some way from release.

After having taken a look at various options, including several other commenting systems, I decided that the best solution would be to import the tutorial articles into EasyBlog, mostly as this would help keep some continuity on the site. The migration of the posts went flawlessly, as expected, but this still left me with the actual comments to migrate. I briefly considered a manual migration, but then discovered that there are actually quite a few comments on the site.

After a bit of digging around I discovered that EasyBlog creates a table that cross references the old article ID's to the new ID's. This is created during the migration process and the values are stored in the '#__easyblog_migrate_content' table. Perfect for migrating the missing comments across.

Using this table I was able to change the object_id in the original jcomments table to match the new post_id for EasyBlog. I simply ran the following SQL statement from within phpMyAdmin. (You will notice that I've made a copy of the original table into the table h0ahq_oldjcomments, just in case.)

Continue reading
8776 Hits

Exchange Mail And Linux Hosting + EMMA

Some of you may be aware that I've been setting up a new business - Indau Industrial Automation. Before setting up the new website and email servers I decided that I was going to look for exchange based email hosting packaged with a Linux web server. This would allow me to retain the Windows Mobile smart phone that I currently use and utilise it for push email and OWA Calendar and task synchronising. Having used Push based email for the past year it was high on the list of things to have - even though it meant retaining a tie to Micro$oft.

Unfortunately there are no comparible solutions available from the open source community yet, There are a few solutions that offer push email from the Linux platform but none that I wanted to risk trying, and none that are as feature rich as the Exchange + Windows mobile solution.

For the hosting package I looked no further than ComWebHosting my current service providers - although not advertised they were able to sort out a package that included Linux based web hosting with PHP and SQL along with exchange based Email. ComWebHosting come highly reccomended - I've used them for the past 8 or 9 years and have never had a problem - even now I'm based in Australia, using a UK based hosting company is not a problem - even for push email from my smart phone.

One new thing to sort out with the web hosting was the SQL database administration. Normally most web hosts provide phpMyAdmin to administer the database, some use other clients but there is normally a way in which you can upload a database backup or run an SQL query. As the sql database server was not the same as the webserver phpMyAdmin was not available so I needed to find a DB client that could be run remotely from the server - allowing me to install it on my local machine but access and administrate the database located on a different server.

Continue reading
1988 Hits