Monthly Archives: April 2012

Simple Joomla/MySQL Setup Issue

Recently I had someone contact me about receiving an error message from a Joomla installation. The receiving the following error:

Error creating data base: Table ‘myjoomladatabase.v96bu_menu’

 

After some research I found the issue was a combination of:

1) Joomla’s table creation statements do not include a storage engine.

2) The MySQL server is defaulted to utilize the “InnoDB” storage engine.

 

When trying to create the “_menu” table manually I received the following from MySQL:

ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.

This can be remedied easily by either:

 1) Adding “SET default_storage_engine=MYISAM;” to the top of any sql files creating tables in the installation.
 2) Adding ” STORAGE ENGINE=MYISAM ” to each table creation statement where the table will not create.
In looking at Joomla’s website I have yet to find any easy way to contact anyone without registering for their website first. I would suggest they change their table creation statements to include a storage engine as follows:
STORAGE ENGINE=MYISAM

 

Joomla can be found at http://www.joomla.org/

MySQL can be found at http://www.mysql.com/

Doctor Who / Law & Order: Special Victims Unit Crossover

Currently I’ve been rewatching all of Law & Order: Special Victims Unit from the beginning to the end on Netflix.

During my watching I’ve noticed a defense attorney played by actress Alex Kingston. The same Alex Kingston who plays River Song in Doctor Who.

What makes this more interesting is that the character River Song in Doctor Who has a mother who’s name is Amy Pond and her characters name in Law & Order:SVU is named Miranda Pond!

Coincidence? Or maybe River Song did a stint as a legal defense attorney in New York?

Is it possible that Doctor Who and Law & Order are not linked? Either by River Song workings on a defense attorney or could Law & Order just be called an alternate reality?

You decide.