Anti-SOPA/PIPA Campaign

Stop Censorship, Web Developer - Joomla, Drupal, Wordpress

Drupal Camp Manila 2012

Drupal web developer, Metro Manila, Philippines, I'm going, are you? Drupal Camp Manila: February 25, 2012

Problem in Joomla 2.5 comments and messaging and mailer for JDContact, K2 Comment, and Contact module (in Contact page), messaging and comments not working/sending

Articles - Joomla Web Development Articles

Share/Save/Bookmark

I have the following modules and features installed in a website: JDContact, K2 Comment, Contact module (in Contact page), but had been encountering problems in sending messages. Checked the mail settings in Joomla administration and tested the following settings:

PHPMail

  • works intermittently, always ok with Contact module but does not work for JD Contact

SMTP

  • SMTP Error! Data not accepted. SMTP Error: Could not authenticate
  • SMTP Header missing errors

Fix: In Joomla > Configuration > Server > Mail Settings

I've set Sendmail as default Mailer instead of PHPMail and SMTP. No configurations or changes were made from CPanel. Troubleshooting has been limited to Joomla settings only. Seems to work!

Seems to work, let me know how it goes from your end and share for the benefit of those having similar issues.

 

 

Joomla 1.7 update to 2.5 error JInstaller: :Install: Error SQL DB function failed with error

Articles - Joomla Web Development Articles

User Rating: / 1
PoorBest 

When I did Extension Manager > Update from the backend to update a Joomla 1.7 website to Joomla 2.5, the following errors occurred:

JInstaller: :Install: Error SQL DB function failed with error number 1054
Unknown column 'sitename' in 'prefix_languages' SQL=ALTER TABLE `prefix_languages` CHANGE `sitename` `sitename` VARCHAR( 1024 ) NOT NULL DEFAULT '';
SQL =
ALTER TABLE `#__languages` CHANGE `sitename` `sitename` VARCHAR( 1024 ) NOT NULL DEFAULT '';
Files Update: SQL error file DB function failed with error number 1054
Unknown column 'sitename' in 'prefix_languages' SQL=ALTER TABLE `prefix_languages` CHANGE `sitename` `sitename` VARCHAR( 1024 ) NOT NULL DEFAULT '';
SQL =
ALTER TABLE `#__languages` CHANGE `sitename` `sitename`

VARCHAR( 1024 ) NOT NULL DEFAULT '';

Checked and found database errors as well (Extension Manager > Update > Database)

Database schema version (1.7.3-2011-11-10) does not match CMS version (2.5.3).
Table 'prefix_languages' does not have column 'sitename'. (From file 1.7.3-2011-10-19.sql.)
Table 'prefix_languages' does not have column 'sitename' with type 'VARCHAR(1024)'. (From file 2.5.0-2012-01-14.sql.)

 

Best Practices for Joomla Installation/Startups - Joomla 2.5 onwards

Articles - Joomla Web Development Articles

User Rating: / 1
PoorBest 
Share/Save/Bookmark

A simple yet proven and practical list of Joomla best practices, recommended steps and tips for Joomla installation and startups for Joomla version 2.5 and onwards.

  1. Backup your website immediately after a good Joomla installation (especially if running on template-provided quickstarts and sample/demo content).
  2. Check for updates immediately. In cases of issues due to core or component, module, plugin or template upgrades you have a good restoration point.
  3. Allow or disallow user registration, New User Registration Group, Set User Group, etc. as necessary
  4. more to come...
 

check manual that corresponds to your MySQL server version for right syntax to use near TYPE=MEMORY

Articles - Joomla Web Development Articles

Share/Save/Bookmark

 

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)
 

[SOLVED] Error: the XML response that was returned from the server is invalid, installing Joomla

Articles - Joomla Web Development Articles

User Rating: / 2
PoorBest 
Share/Save/Bookmark

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.

   

How to increase and override the maximum search word character limit in Joomla 1.5

Articles - Joomla Web Development Articles

User Rating: / 2
PoorBest 
Share/Save/Bookmark

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.

   

Save failed with the following error: Category must have title, Phoca Gallery Error in Joomla 1.7

Articles - Joomla Web Development Articles

User Rating: / 3
PoorBest 
Share/Save/Bookmark

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.

   

Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\phpMyAdmin\libraries\dbi\mysql.dbi.lib.php on line 175

Articles - Joomla Web Development Articles

Share/Save/Bookmark

Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\phpMyAdmin\libraries\dbi\mysql.dbi.lib.php on line 175

XAMPP apps versions

XAMPP version 1.7.7
+ Apache 2.2.21
+ MySQL 5.5.16 (Community Server)
+ PHP 5.3.8 (VC9 X86 32bit thread safe) + PEAR
+ XAMPP Control Panel Version 2.5 from www.nat32.com

  1. Find in C:\xampp\php\php.ini below line / setting and change the 30 to a higher value as needed and required:

    max_execution_time = 30
  2. Find the line in C:\xampp\phpMyAdmin\config.inc.php, or C:\xampp\phpMyAdmin\config-inc.php, and change setting / value as required: 

    $cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit)

    If config-inc.php file is missing the above line or missing altogether then the file config.default.php in C:\xampp\phpMyAdmin\libraries folder is used, edit value in below block

    /** 
    * maximum execution time in seconds (0 for no limit)

    * @global integer $cfg['ExecTimeLimit']
    */ 
    $cfg['ExecTimeLimit'] = 300;

  3. Try also adjusting maximum execution time in C:\xampp\apache\bin\php.ini 

    ini_set('max_execution_time', 0)

  4. Create your own php.ini and put the first line below and save it and put the file in your root folder of your application: max_execution_time=0

Use and apply above setting changes if managing your own server. Increasing the max exec time for loading and running scripts more than the usual, required time increases the risks of running malicious codes and scripts.

 

   

Page 1 of 5

Joomla, Drupal and CMS seminars, training courses, Metro Manila, Philippines

ACE IT Learning Solutions offers affordable, practical Joomla and Drupal hands-on trainings and courses, as well as SEO / Analytics seminars conducted regularly at the training center in Cubao, Quezon City, Philippines. Visit ACE IT training website to learn more.

smart-traffic
SEO company - Increase organic search engine rankings. Increase your sales. Increase your profits. The UK's leading SEO company. Please visit Smart Traffic United Kingdom and SEO Service Australia for more information.

TPC Events hosts Joomla, Drupal and other CMS seminars and workshops in Ortigas, Pasig, Metro Manila, Philippines

Seminars and workshops are also being offered at TipidPC Events in Ortigas, Pasig City and at Buendia, Makati, Metro Manila, Philippines. Please visit the TPC Events.Org website for more information.

free-seo-company

Get up to £3500 of completely FREE SEO Services to help your business compete online. We will take you well on your way to ranking success! For more information, please visit the Free SEO Company and Services website.

binary-republic

Binary Republic is your online source of computer tutorials on programming, software and computer-related topics on .Net, ASP.net, Database, Java, Linux, Microcontrollers, Open Source, Photoshop, PHP, Tech News, Web Design, Web Development, Wireless technology, among others. Visit the website blog at BinaryRepublic.com.

net-worx

Pay on results guaranteed, cheap SEO and campaigns. Networx is UK'S leading affordable SEO company. Call us on 0207 193 5342 or visit the Networx website.

Joomla Blog Articles and Notes

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7

Drupal Blog Articles and Notes

Web / Internet Resources

  • 1
  • 2
  • 3

Latest Comments

Web hosting

Archived blogs (CMS Experiences, Blogger/Blogspot)

Archived blogs (Joomla Experiences, Blogger/Blogspot)