Unable to connect to the database:The MySQL adapter “mysql” is not available.

Solution :

Go to C:\program files\mysql\bin\

Copy this file libmysql .dll to C:\windows\system32\

System:

Windows XP

Why it occurred:

You originally installed a previous version of MySQL probably 4.+++ and then tried to install a new version MYSQL version 5++

Symptoms:

When you run your apache server you see this error in the error.log file of your Apache server

PHP Warning:¬† PHP Startup: Unable to load dynamic library ‘C:/Program Files/PHP/ext\\php_mysql.dll’ – The specified module could not be found.\r\n in Unknown on line 0

… and it happened¬† despite php_mysql.dll already being in place

Problems integrating SWFupload with Joomla

I am currently working on integrating the SWFUpload library with Joomla 1.5. All seems to be working well except till the portion whereby the file is uploaded.

I get the response by the system to do a login and this response is returned to me via uploadSuccess(file, serverData) method in the SWFupload handlers.js file. The session is not maintained apparently when I do the post.

I am currently referencing http://docs.joomla.org/Creating_a_file_uploader_in_your_component for possible resolutions to this bug.

Now I am heading off to work as the Dancing Christmas tree. Hopefully I would solve it when I get back in the evening.

Getting Google Friends Connect to Work with FaceBook Connect

It seeems getting facebook connect to work with google friends connect has been a issue on the minds of most developers and not many of them has came up with an idea solution for it.

After having attended the google hackathon last month and witnessing how patrick got it the two of them to work it got me experimenting with bringing facebook connect and google friends connect to work together for a while now. The site I am working on is Thing To Do Singapore.

Last night I was finally successful at getting the two of them to work together in a somewhat weird kind of way.

Bascially Pages with GFC elements should not be introduced with FBML elements and vice a vice. Such a way would cause it to clash. However since authentication for facebook results in a session storing on the server, one possible method for implementing the two on the same system could be via ajax.

On Things to Do Singapore the default log in is Google Friends Connect. On another page http://thingstodosingapore.com/facebook/ user can log into their facebook accounts using facebook connect.

So once both of these are done, in the event the user generates some contents on the default page, 3 things will happen.

  • their facebook status will be updated
  • their google friend’s connect activity will be updated
  • the twitter main account ThingsToDoSg will be updated.

Additional events that might happen. Suppose the user declares that this entry has more details in a specific blog. The server will automatically do a ping back once the on the server with the blog entry.

In short I am attempting to position Things To Do Singapore as both and aggregator and a disseminator.

PHP set to be the disruptive innovation in the ERP arena

Cited from WikiPedia ;

“A disruptive technology or disruptive innovation is an innovation that improves a product or service in ways that the market does not expect, typically by being lower priced or designed for a different set of consumers.

Disruptive innovations can be broadly classified into low-end and new-market disruptive innovations. A new-market disruptive innovation is often aimed at non-consumption (i.e., consumers who would not have used the products already on the market), whereas a lower-end disruptive innovation is aimed at mainstream customers for whom price is more important than quality.

Disruptive technologies are particularly threatening to the leaders of an existing market, because they are competition coming from an unexpected direction. A disruptive technology can come to dominate an existing market by either filling a role in a new market that the older technology could not fill (as cheaper, lower capacity but smaller-sized flash memory is doing for personal data storage in the 2000s) or by successively moving up-market through performance improvements until finally displacing the market incumbents (as digital photography has largely replaced film photography).”

Currently when talking about large scale corporate used systems in the commercial arena, the first thing that comes to mind is either Java Enterprise Systems from Sun MicroSystems or Share Point from Microsoft Systems.

While the LAMP stack (Linux, Apache, MySql, Php) has been the main market technology used by SMEs and web hosting server, no big firms thus far has yet been braved enough to take the next big step into to the new frontier which is often the large scale extensive use of this open source technology.

Cited from my interview session with a developer from National Computer Systems the number biggest IT company in Singapore

“Yes it is the truth, no big companies has yet attempted to launch PHP as a platform for large scale enterprise use. However as soon as one of the big boys in the market does so the rest will soon follow.”

What he says can indeed be explained via the use of institutional theory. Assume a big company after going through a normative processes decides to adopt PHP on a large scale basis and successfully does so, others companies compelled by mimetic processes will follow along too.

Also due to the fact that this company might be a dominant supplier or client of other companies, they might via coercive forces be forced to adopt the same technology.

Another company CBS an MNC advertising firm which I went for interview the yesterday does has indeed developed a large scale system based on PHP with built in extensive workflow controls.

As commented by Senior Manager e-marketing for Sanofi Aventis Mr Bernard Grellier

“We are now looking at building sites that can be rapid, easily deployable, with low investment cost and discardable. That is why PHP might be a viable solution for this arena as compared to solutions from other vendors.”

So what is it that is preventing from big companies from hoping on to the PHP bandwagon?

Accountability is Key!

Big firms have a need for stability more so than small firms. They require that a party be accountable for technical support should an adopted technology malfunction during operations.

This is not simply possible when dealing with open source technology. What revolves around PHP is a community of people and not a single firm. In the event of a malfunction problem, the adoptee has no one to turn to for the solution.

However the day might not be long before big firms has a finger to point to.

Microsoft seeing the potential of tapping on the PHP community is already in the process of adopting it as a viable technology and attempting to scale it up. The day might not be long before big firms start seeing PHP as a viable technology for their operations as well thereby displacing mainstream technologies used in large scale corporate environments.

Massive Community sustains Technology

Yes Php as a programming language is really cool.

While it may not be as powerful as its substitues like JSP and ASP.net, there is actually a very large community of developers working on the PHP language. Lots of free open source applications have been developed for industrial use that a person with some background in programming could easily configure to his own needs.

A great example is WordPress a blogging software. I have been using it for quite a few years on friendster for personal blogging. Recently I setup my own new blogging site at a new location blog.name1price.com but still using the same open source software WordPress. Now with FTP access to my wordpress script, I could easily extend my WordPress blog to include more impressive features.

If you are a technie, without hosting space or domain name but would really like a playground to test out these open source system., I could easily provide you with one free of charge.

Another cool system which I have been using for quite a while is Joomla. It has already reached version 1.5. I consider it to be quite a mature content management technology by now. You could also have it downloaded free off the net. All you need is just a hosting space to test it out. Samething if you need a play ground to test out this site tell me about it.

Recently I was out with my friend who is a trader. Apparently he was having problems keep tracking of his stocks. So I thought I should help him out by creating a online inventory system. However rather than creating one from scratch I just searched on google and found once again a free fully running inventory management system that is written in PHP.

That is the cool thing about PHP there is such a large community working on it that you can easily find an already written software system in that language to fit your needs with just slight modifications.