Showing posts with label joomla. Show all posts
Showing posts with label joomla. Show all posts

Friday, September 09, 2011

Error 500 installing Joomla on OVH

I have not deployed / moved joomla we site since a while. Zipping and unzipping to another host put me in a permanent http 500 error. My hoster is OVH (very famous in France and Belgium).

The solution:  php script but be readable not writable, the administrator directory must be configured with chmod 755.

Sunday, May 15, 2011

DocMan - Nooku - Joomla

As we are preparing a new release of our web site, I found a small post about DocMan a simple but well integrated document management for Joomla.
http://blog.joomlatools.eu/2011/04/sneak-peek-into-docman2-development.html

From there I discovered http://www.nooku.org the new Joomla extension framework. We are not migrating to 1.6 but of course we keep an eye at it.
As we are preparing a new release of our web site, I found a small post about DocMan a simple but well integrated document management for Joomla.
http://blog.joomlatools.eu/2011/04/sneak-peek-into-docman2-development.html

From there I discovered http://www.nooku.org the new Joomla extension framework. We are not migrating to 1.6 but of course we keep an eye at it.

Monday, February 21, 2011

Joomla 1.6 - mxed feeling

Joomla 1.6 is finally released. I will not comment on the API changes, I had no time to look at it. For the web site designers two things are important: improved granularity for the access security. And the removal of the section/category classifcation by an unlimited levels of categories.

The last one is great. Things that are so limited (2 levels) are usually poor design. They however usually have their origin in the difficulty to maintain a  tree in SQL.

On the other side, this was not the major issue with Joomla classification. The key issues remain: an article is only in one category and categories applies to article, nothing else...

Modularity is great, but key supporting features need to be in the kernel. Joomla is moving to the right direction but slowly !

Wednesday, October 13, 2010

Joomla - sh404sef - Joomfish - images

########## Begin - Joomla! core SEF Section

#
RewriteRule ^(.*)/images/stories(.*)$ /images/stories/$2 [NC]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} !^/index.php
RewriteCond %{REQUEST_URI} (/|\.php|\.html|\.htm|\.feed|\.pdf|\.raw|/[^.]*)$  [NC]
RewriteRule (.*) index.php

Well may be the first RewriteRule in the .htaccess file will help somebody trying to get nice URL no ? or param=xx, Joomfish and images on all their articles. Provided you put all your images under /images/stories that should do the trick for today...

Wednesday, October 06, 2010

Joomla some problems with sh404sef and Joom!Fish

We are doing good progress with our new site. But I realized that the translation (I think language switching is more appropriate) does not work as expected. Typically the home page which is a category view does not translate...

I immediately suspected the combination of Joom!Fish and sh404sef as they both manipulate and interpret URL... Indeed to be compatible with another sef plugins you have to turn off the Joom!Fish plugins 'JFRouter'...

Everything is now back to normal.

Thursday, September 30, 2010

Joomla - sh404sef - .htaccess - on Ubuntu 10

I am preparing our new web site for ADINS. We are migrating to a more recent Joomla version, plan to use Docman (document manager), Community builders (registration framework), FlexiContent (Content construction, tags etc) JoomFish (mult-language) and Kunena Forum.

Yesterday we started working with an external consultant for improving our Google rating.

Having nice url with the subject keyword is a first things to do. Joomla in standard helps a bit but the required component remains sh404sef (http://dev.anything-digital.com/sh404SEF/). With this component you can twist and maps url easily. sh404sef has also an inclusion of Google analytics (not tested yet).

On Apache (see for info http://httpd.apache.org/docs/2.2/), proper URL relies on .htaccess. Joomla comes with a htaccess.txt file, renaming to .htacess should do the trick.
 
Publier le message

However I continued to get the 404 errors...

I checked, indeed sh404sef must be enabled with standard Joomla sef option.

I configured BaseRewrite to map my sub-directory with the being built web site.

I checked the presence of the mod_rewrite module (easy with webmin)...

Untill I found that the default site configured by the Ubuntu install does not let the distributed .htaccess file to be used.

The solution :


go to "/etc/apache2/sites-available".

- locate your site config file - in my case "default"
- change the AllowOverride None to AllowOverride All.
- restart Apache and you are done...


 
                Options FollowSymLinks
                AllowOverride All
       

       
                Options Indexes FollowSymLinks MultiViews
                AllowOverride All
                Order allow,deny
                allow from all

Thursday, August 19, 2010

How to reset a user's Joomla password

 Using the following sql script will reset the password of admin to '1234'

UPDATE `jos_users` SET `password` = MD5( '1234' ) WHERE `jos_users`.`username` = "admin"

Sunday, July 11, 2010

Welcome to the Online Joomla Community Magazine & What is typekit

A new place to look at for those interested in Joomla : http://magazine.joomla.org/.

It is just started and already plenty of well presented resources about web-design and my still favorite CMS for small to medium business.

Yet a good thing I learn via the magazine - Typekit a solution to embed legally and precisely fonts and thus use great typography on your web site - this is not only for Joomla - find the idea behind it on the typekit web site : http://typekit.com/about. Not only it solves a need, it is also a great web based business model.

Monday, April 05, 2010

Extensibility Part II - Hot properties

After my look at the past, let’s go back to day to day operations, I closed a deal a few weeks ago for a real estate web site based on Joomla. We build ‘cheap’ here using one of these little extensions that are  on the Joomla market place: Hot Property (HP).

For each property, HP provides a limited number of fields. Each one is implemented as a column in the real estate properties table. Yet the developer had the idea to make the software extensible, so you can add more fields to your properties descriptions. Surprisingly all these fields go in a separate table…  where you find fields id and values and the id off the real estate property.

Obviously, SQL querying on these is a nightmare... (I exaggerate again, at least we can say things are more complicated and imply joins that are source of performance drops and misunderstanding - e.g when customers attempt to build their own reports).

As you can see, values are stored as text (why the hell have they invented all these data types – may be a precursor of XML). I am putting here the layout of the values table. Another table contains the definition of the extra-fields. Strangely, while we have just a foreign key between the extra fields and the property, HP lets only one field (of a given type) per property.

It is difficult to know why a developer took a path or another. This is not a criticism on HP -It is a very affordable and workable Joomla component. I see anyway, a few reasons…

  1. Very few people like programming the DDL (Data Definition Language). 
  2. Attempting to shield from the database, HP is written with a framework including a primitive (sorry to say) persistence layer. Yet if PHP is dynamic the PHP model is statically linked with MySQL using PHP definitions.  
  3. Finally reflection is something that many programmers do not envisage – among the reason is that again DDL and meta-schema is not that standard… 

All that can be combined in one  DDL+Reflexion+Persistence layer (ORM) is still a problem. Choosing at which moment you decide in your layers to be static is a tough decision…

In the case of HP, extensibility could be much higher since the application is basically a CRUD thing. The gotcha in DB application design is there : when adding processing, logic well you are obliged to statically bind your code (even if you don’t realize it, just a reference in  the code and the magic of dynamic reflection is broken) and the persistent DB model.

I like this subject that much that I am afraid… it will be continued again!

Saturday, February 20, 2010

How Open Source Development is Funded

Open ERP which I discuss at length is commercial open source sofware.

Many other open source projects are non-commercial (at least this is how they like to be advertised). Yet money remains necessary and it seems the Joomla community is having some troubles here, so they surveyed how other projects find resources:
 
http://community.joomla.org/blogs/community/1117-how-open-source-development-is-funded.html

Enjoy and think... can it be open, free, sustainable ?

Tuesday, September 22, 2009

Ockham's razor - Joomla - CakePHP - Jake -jQuery

As explained earlier, I am trying to integrate a small app built with jQuery and CakePHP in Joomla.

My first idea was to use Jake - http://dev.sypad.com/projects/jake/. This is a generic Joomla component capable of calling a CakePHP application. I remember to have tried it more than a year ago.
Probably something changed in my settinggs (in fact the config - os /PH¨P/ Joomla is entirely different....) all I get is:

"Fatal error: session_start() [function.session-start]: Failed to initialize storage module: user (path: C:\xampp\tmp) in C:\xampp\htdocs\www\DiagTools\cake\libs\session.php on line 553"

I tried tweaking PHP sesson config, checked permissions (actually sessions files are created there). On the net, I found a few posts seeking for support about the same concern but no answer.

I remarked that Jake is still in beta since 2007. I think that's indication of at least future troubles...

A second option was not to integrate them, but to make them similar enough. I found a few posts proposing to recycle Joomla thems into a CakePHP theme so the two components would work side by side. I think this is a poor man integration, my customer will not be able to use the Joomla admin to administer the site or change security settings etc The worst being that I will have to rechange it if we go for another design.

Considering that CakePHP is used only for structuring the application, validating a single basic form and calling a web service (a feature that sits there but that nobody uses), why not getting it out and keep just the jQuery stuff?

So I started this third solution which is creating a fresh Joomla component.

One more time the Joomla community amazed me by its vitality and by the high number of good quality components and plugins available. SC jQuery is a plugin that makes installing jQuery a single click operation. In the confiiguration you may choose the themes for the user interface widget - really cool : http://extensions.joomla.org/extensions/core-enhancements/scripts/7230.

I have not done serious things with jQuery since a while, this theme concept is great and you can see it in action here : http://jqueryui.com/themeroller/.

So at the end of the day I got the kernel of the app running in Joomla. The layout still requires adaptation and I have to simulate the screens built with CakePHP...

Yet I am sure to have done the right choice, removing one technology, avoiding a bridge. This will  provide the best integration for the users and the most flexible options for the administrators of the web site.

Monday, September 21, 2009

Back to Joomla - Cake -PHP

So after a long Open ERP period I am back to the Joomla world.

Almost a year ago I setup for one customer an application built around JQuery and Cake PHP. A bit later the customer asked for a web site which has been built with Joomla. It would be perfect if the the web site and the application could share the same look and feel. I feel a bit faulty : at that time using Cake was for the simplest way (for me) to structure a small PHP app... but I did not plan anything concerning the web site - at that time his web site was made (by somebody else) with Wordpress - excellent for making a blog but terrible for making a web site...

My first steps today are basically to get back a development environment, the web site, (joomla,db...) the app etc. As usual I use Netbeans, here 6.7 - the PHP support is now stable and official.

Following Netbeans recommendation, I picked XAMPP (http://www.apachefriends.org) to install PHP and MySQL - I am working on my HP XP portable (Paddle).

After having transferred the web site I got an error message in a few modules positions. I then restarted a fresh Joomla install - same result.



Warning: Parameter 1 to modMainMenuHelper::buildXML() expected to be a reference, value given in C:\xampp\htdocs\joomla\libraries\joomla\cache\handler\callback.php on line 99

Basically Joomla 1.15.xx is not compatible with PHP 5.30 (which comes with the currently latest XAMPP 1.7.2). So you need to get an older PHP version, thus an older XAMPP. Older release are not on the same site, so you need to go to http://sourceforge.net/projects/xampp/files/ to find what you need. I decided to go for 1.6.8 to be sure to get rid of PHP 5.30. Unfortunately I then hitted another issue with phpMyAdmin the MySQL tool I cannot live without...


Too bad. I did not investigate that one, I de-installed XAMPP again. So I moved to 1.7.1 which installed PHP 5.2.9. Proceeding with dichotomy for finding release that's the job I am in...

It is now working (after a small battle for setting up a user and a password).


The rumor says that this will be fixed with Joomla 1.5.15 to be released soon (october).

One more time, I regret the Java platform. Some so called Agile programmers believe that their productivity decrease because of compile cycles, I am laughing at that. These compile times represent little amounts of time for most programming jobs. For me, the Netbeans background compiler removed this concern entirely.

The key point for the pro-compiler camp is this for me : the semantic analysis is a job for developers not for users. When a code is compiled with Java 1.4 it runs on 1.6 just because the VM are backward compatible at the VM level and in spite the language continues to evolve. Language changes do not impact the compiled and so you can keep your olfd stuff working as designed on a recent platform.

At this stage the two interpreted language that I used exhibited the same poor facilities to handle changes in the language itself  : PHP & PYTHON.

So I move back to my stuff and still continue dreaming of the perfect environment for my job...

Tuesday, September 08, 2009

Open ERP plugins - Open source business model - does it work or not

Today I wanted to spend a bit of time on the extensions - plug-ins of Open ERP. I wanted to check Outlook - and Excel.

Integrating e-mails in the ERP makes sense for the CRM part. Reporting etc with Excel makes also sense...

I like to insist that these plug-ins are commonly demonstrated and advertised by Tiny. This is my number one source of frustration...

However searching for them on their web site... nearly nothing - nada - rien !

Finally I found using Google : http://openobject.com/wiki/index.php/Open_Report:Others_Plugins

Well, that page leads to pages that do not exist.

However a hint is given. These have been developed by Axelor - www.axelor.com. Axelor is the developer of the web client of Open ERP. A nice piece of software, their web site however is the paradise of the 404 error.

Here there is no indication of a way to buy or download these plug-ins. the Open ERP forum is filled with messages of people searching the addons software.

With the common reply message from the moderator, pointing to the 404 page of Axelor...

So, I sent an-email to Axelor asking information about these plugins.

Beyond the practical aspect, I see here a major difficulty for the Open ERP model.

The open source approach has a lot of positive aspects however in some cases it prevents the development of finished affordable products.

  • Suppliers are waitting for the customer willing to pay some functionnality.
  • Customers are waitting in the hope somebody else will pay for them.

Between the virtuous open world of cooperation and the static 'je te tiens tu me tiens par la barbichette' -(sorry I don't know the name of that kids game in english - the first one to laugh loose the point... ). The gap is really small. This is attested in my opinion by the small amount (1 project) of modules developed under the concept of shared funding by Tiny.

On that subject I regret that Open ERP is not following the path of the Joomla community where small extensions are available at a very affordable price...

May be is this because the Joomla plug-in model requires less integration or may be because the user base is bigger, may be simply said Joomla users are so happy to find a solution for their web sites for a few dollars that they don't spend time argumenting on the price or the open-source, free aspect.

Anyway I am waiting for Chris Anderson 'Free' its new book about free business models with attention and some scepticism... Because there is nothing free like a free lunch !

Wednesday, August 26, 2009

DOCLink for DOCMan on Joomla

a year ago, I built a small website for one of our customer. It is built with Joomla 1.5xx. One of the key compoent is DOCman. A small document manager that ease uploading, building a directory tree of documents etc

DOCman is ideal for small corporate web sites, loading brochures, manuals etc But watch out to the size limit (php settings) set by your hoster !

Strangely the menu system enables only to point to a category in the tree - not a document leaf.

What my customer wanted - which is basic I must admit was a simple way to make links from an article to some content in the DOCMan tree. I though I could find the URL of each individual document and create the links manually. I did not succeed - well there is no easy way to find the id of the items.

Finally I found an extension that adds an button on the defaut editor - TinyMCE -and that helps finding the right resourcee and link it. Really easy.

My only regret is that it is not standard and I searched for it during at least one hour...

Also the tip for the day don't forget to go to Extensions/Plugin manager, locate DOCLink and enable it then the button will show up ev ery time you edit an article (rows of buttons under the text area).

Thursday, July 23, 2009

Time for summer holidays

It is time for holidays. So a bit of desk cleaning and that's it. Two weeks for giving up with databases, Java, Python... projects, plannings and budgets. I am taking my portable of course, but that's basically for emergency only...

I finished my first Tony Buzan book. This was a bit general - the french title 'une tête bien faite', I think the original title is 'use your head', the book goes over fast reading, memory and mind-mappings (a subject I like more and more).

There is a lot to say about these subjects and Tony Buzan has written books dedicated to each of them -- I will continue investigating.

Following Tony Buzan recommendations, mind-maps should be graphical (including graphic but also being smartly shaped) and coloured. It is a shame that all software tools that I have see currently are implementing very regular organisation pattern and don't promote that much colors and graphics. Anyway, I recommend you this book.

On the Open ERP front line, I finished a small doc concerning Initial Analysis - see previous post and what to prepare to have good, constructive interviews sessions with business processes owners. Tiny provided me three mind-maps. A good start but I will try to develop mine for the next project...

I have done a bit of testing with Python, but I had not time to finish my test software - submitting HTML forms to a Joomla web site. Hm that will be for August I guess...

Finally I am taking with me 'Everything is Miscellaneous' - ' The power of the new digital disorder' from David Weinberger. Social aspects of the web is fascinating and I hope to work more on it later this year...




So I hope to come back rested and a bit smarter - what a plan !

Monday, April 14, 2008

Netbeans 6.x as a PHP IDE

As I am currently working with a PHP written CMS - Joomla - I tried the new beta plugin for Netbeans. With this extension you can create PHP projects and get code completion. Debugging in the IDE is possible provided you install the xdebug extension on the server.

As usual the Linux distribution is done through source code, it tooks me around 20 minutes to get the build process up and running. Debugging worked fine for simple application but for Joomla the debugger started but the resulting page was always blank.

I finally give up and used Wamp server on windows, there is worked perfectly. I still don't know why I can't get it up and running on my Linux machine. Among the difference : wamp comes with php 5 per default.

Links
The extension for PHP editing in Netbeans : php.netbeans.org.
Debugger for PHP : www.xdebug.org.
Apache + PHP + MySQL : www.wampserver.com.