Easy Update Joomla 2.5

Hi everybody, someday ago i was updating my joomla site with 1.7.3 version to 2.5.1 through the extensions manager > update, but i have an error message :

JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'ordering' SQL=ALTER TABLE `test_languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;
SQL =

ALTER TABLE `#__languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;

Files Update: SQL error file DB function failed with error number 1060
Duplicate column name ‘ordering’ SQL=ALTER TABLE `test_languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;
SQL =

ALTER TABLE `#__languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;

Even my site appearance still working well, but i think this can be a problem. Then i start to googling, with keywords “JInstaller: :Install: Error SQL DB function failed with error number 1060″, lucky me, i found good problem solver in here

The point in that thread is the main problem of these error is because the old sql file in the folder

administrator > components > com_admin > sql > updates > mysql

you must delete all the sql file, of course before you do that, please backup your site first, just in case. Akeeba backup is the best joomla backup component.

after all sql file deleted, just go to joomla back end (administrator page) > extensions manager > update.

If there isn’t any update that show up yet, you need to purge cache and find update, check the joomla 2.5.1 update, and click update of course.

I am very happy that joomla have more easier way to update than before. Through this article, i just want to share about my experience in updating joomla from 1.7.3 to 2.5.1. Hope this post is useful for you.

Update Joomla from 1.7 to 2.5

If you still using 1.7.0, after delete all sql file, and there is has same error when you upgdate to 2.5.1, so you must update it to 1.7.5 first. I suggest you to update using extension manager and Upload Package File. After installation succeeded you can update automatically.

Copied from Webdesign Surabaya

MBReset – Lite Theme on WordPress.org

Last week i was submitted mbreset – lite theme to wordpress.org, but just on 2 days, someone from wp (that i don’t need to say his name) has preliminary review on my theme. How stupid i am, i don’t read all about the licenses (that you can found here http://codex.wordpress.org/Theme_Review#Licensing). I have been use “Bebas Neue Fonts”, they are not GPL-Compatible.

Unfortunately i don’t have time to fix it on that day, so i fixed it on the next day. Just delete the “Bebas Neue Fonts” and replace them with “League Gothic Fonts” which are use SIL Open Font License 1.1. After that, i upload MBReset – Lite, but i forget to check it, the code i stylesheet was’t correct, the font doesn’t show up on my demo site, so i upload it again, after done the small editing.

If you want to see the description of MBReset – Lite at the theme trac :

MBResets-Lite – 1.0.2

A theme specifically built for those who love tweaking their own themes. Open, clean and quick-loading design with a wide sidebar on the right, plus multi widget area and custom template. Options page offering a choice between a dark or light layout, caters for all the post formats and also offers user support via a support forum. Modfied from Tweaker4.

Theme URL -  http://demo.theme-pack.com/
Author URL -  http://pancenjoss.com/

SVN -  http://themes.svn.wordpress.org/mbresets-lite/1.0.2
ZIP -  http://wordpress.org/extend/themes/download/mbresets-lite.1.0.2.zip?nostats=1

Diff with previous version: http://themes.trac.wordpress.org/changeset?old_path=/mbresets-lite/1.0.1&new_path=/mbresets-lite/1.0.2

All previous tickets for this theme: http://themes.trac.wordpress.org/query?col=id&col=summary&col=keywords&col=owner&col=status&col=resolution&keywords=~theme-mbresets-lite&order=id

Copied from Webdesign Surabaya

Meltas – Clean Joomla Template

What do you think about MELTAS, great huh? This Joomla Template is clean and minimalist, with the power of Joomla you can edited, modified, manage this template and content easily. Themesoul has issued 8 templates with Meltas and i love all the design, except anchor of course.

But, that is doesn’t matter, as long as the others templates still have great design, and get a great sales. Furthermore, the sales after support is always ready to answer your problem, don’t say to ask the access to the support forum, even not 24 hours, because the forum moderator is from Indonesia, that some time sing “Meltas Green Balloon”, so you just need to little bit patience.

Ok, lets check the “Meltas – Clean Joomla Template” feature that we take from the themeforest :

Copied from Webdesign Surabaya

Create Animation with Playdough

Hi, how are you folks…

Some days ago my wife has make playdough for my little 2 year old boy. Every day he want me to make him a toy from playdough, wow i feel back in 25 years ago. The most favorite thing he like is police car, when i made it he always sound like siren, and running around the house.

Last night, when i see my google webmaster tools, i am impressed with the number of visitor with “cicak” (in english is gecko or maybe lizard, i don’t know for sure) keywords. So i decided to create animation about “cicak” with my son playdough. But the problem is i don’t have animation software installed in my laptop. I just have CorelDraw Graphics Suite, because i don’t know how and never use it to create an animation, so i asking my Uncle Google “how to create animation with corel draw”.

After i make “cicak” from playdough, i am shot it with my camera and process it on corel. Take a look the result below :

Copied from Webdesign Surabaya

Developing Greenbatikcollection.com

With the spirit to empower the society in Surabaya, Green Batik Collection has grown up together. Just for a few month, Green Batik Collection has many customers trust. Moreover, the design is new, unique, and fresh. Created from East Java Batik, that have great character, not because i am from East Java too.

The simple request from the owner about their website, want to highlight the character and show their product, and give some knowledge about batik. So, take a look on the screenshot and feature of Green Batik Collection below.

Copied from Webdesign Surabaya