Articles - Joomla Web Development Articles

Some errors occurred while populating the database: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MEMORY'

The problem could be solved with two alternative ways:

1. install stable version of mysql, for example 5.1.52 (add library plugins as necessary for wampserver or xamp)
2. replace the TYPE=MEMORY with ENGINE=MEMORY (make a backup copy first, then try a global and replace for example with notepad or any editor)

Articles - Drupal Web Development Articles

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 54 bytes). Drupal errors on Openpublic distro profile installer: Fatal error: Maximum execution time of xxx seconds exceeded

set as necessary in php.ini

• max execution
• max execution time
• ini_set('memory_limit', '-1'); this will override the default PHP memory limit.

Sorry guys just a note... Friday night, will sort this out later, hope this helps!

Articles - Web Resources

Business and Corporate Branding / Identity

Your hotel business, travel and online booking company will have credibility and business identity with its own official website, readily found on the internet by anyone all over the globe.

Information

Useful information to would be travelers and clients are available. These contents will mostly include but are not limited to the following:

• Photographs
• Maps
• Services
• Rates and Promotions
• Advertisements
• and a lot more!

Searcheability

At this very moment, someone or a group of individuals are searching for "Hotel in the Philippines" or "Hotels in Manila", and if you are not with a bandwagon yet of hotels with their own websites you may be losing a great deal of income!

Hotel Bookings online / Online Reservations

Travelers are very appreciative of online bookings as this saves time from all the fuss of looking for numbers, calling travel agents and receptions, etc. This is obviously the faster and cheaper way of booking!

Portal

• Intranet
  
  The same website can function also a an intranet securely accessible by a login page for management and staff to access internal information (memos, downloadable files, etc) that are otherwise not available for public viewing.
  
  
• Links to partner sites and resources
  This feature will be most beneficial for client information and for advertisers alike. 

Content Management System

With a CMS type of website, the hotel website is fully manageable by the hotel staff who can regularly update information and images in minutes, with little or with no technical help at all!

Articles - Joomla Web Development Articles

Trying to install a Joomla 1.5.15 version, at step Database, at Install sample data, error appears:

The page at localhost says: Error: the XML response that was returned from the server is invalid.

Solution/Workaround:

1. Install without the sample data
2. Install sample data (...\yourjoomla\installation\sql\mysql\sample_data.sql) manually for example in phpmyadmin - navigate to your target database
3. Delete installation folder, then refresh frontend, now with the sample data installed

Additionally, turning off temporarily your php errors in php.ini might help to proceed with the installation.

1. Find your php.ini (root directory)
2. Search for this line in php.ini that says
   error_reporting = E_ALL
3. Uncomment then replace with this line
   error_reporting = E_ALL & ~E_NOTICE
4. Restore this setting as needed

Hope this helps, please let us know how it goes and your workaround and fixes if you have any differently.

Articles - Joomla Web Development Articles

How to increase and override the maximum search word character limit in Joomla 1.5 to search for 21 characters or more. Reposting this very useful tip for hacking a common, default search limitation in Joomla 1.5... follow completely and in detail. Before doing below steps always ensure you have a backup of the files to be edited for easy restoration and recovery to default settings. Of course, numeric values will depend as desired.

1. Edit this file '/modules/mod_search.php'

Delete this line:

$maxlength = $width > 20 ? $width : 20;

Add this line:

$maxlength = $width > 50 ? $width : 50;

2. Edit this file '/components/com_search/views/search/tmpl/default_form.php'

Delete this line:

<input id=”search_searchword” maxlength=”20″ name=”searchword” size=”30″ value=”<?php echo $this->escape($this->searchword); ?>” type=”text”>

Add this line:

<input id=”search_searchword” maxlength=”50″ name=”searchword” size=”30″ value=”<?php echo $this->escape($this->searchword); ?>” type=”text”>

3. Edit this file '/administrator/components/com_search/helpers/search.php'

Remove these lines:

// limit searchword to 20 characters
if ( JString::strlen( $searchword ) > 20 ) {
$searchword = JString::substr( $searchword, 0, 20 );

Add these lines:

// limit searchword to 50 characters
if ( JString::strlen( $searchword ) > 50 ) {
$searchword = JString::substr( $searchword, 0, 49 );

4. Edit this file '/language/en-GB/en-GB.com_search.ini'

Delete this line:

SEARCH_MESSAGE=Search term must be a minimum of 3 characters and a maximum of 20 characters.

Add this line:

SEARCH_MESSAGE=Search term must be a minimum of 3 characters and a maximum of 50 characters.

Remember to save all your files then reupload. Clear browser cache and refresh your Joomla website and your search character restriction should have increased to 50 characters.

Articles - Joomla Web Development Articles

Phoca Gallery error when creating / saving a new category - "Save failed with the following error: Category must have title" Phoca and Joomla versions used: Phoca Gallery 3.1.1 and Joomla 1.7

Followed the threads and discussions to date, but this seems to be a bug at least for the versions used. Workaround seems to be a manual database install of Phoca Gallery tables...

1. http://www.phoca.cz/forum/viewtopic.php?t=10083
2. http://www.phoca.cz/forum/viewtopic.php?t=12731

Will update this with developments...

UPDATE:

Weird, re-installing the same Phoca version used did not work. I tried downloading a fresh copy of Phoca Gallery 3.1.1 (the same version used) and reintsalled it on the same Joomla 1.7 website, and it worked this time.

The only other difference is while creating the Category, I left out (did not specify anything) on the following and it got saved:

• Access Rights
• Upload Rights
• Delete Rights
• Owner
• Category Folder

I then entered the above, and then saved the settings again. This seemed to work. If you have similar experiences and different workarounds, please post here to help others.