Here is a screenshot of how settings “Hide / Show” buttons might show:

This can be fixed easily:

Edit the file:

 JOOMLA_ROOT/administrator/templates/isis/js/template.js 

Change the line (around 35) from:

 $(".btn-group input[checked=checked]").each(function() 

to

 $(".btn-group input:checked").each(function() 

Here is what you will have once you reload your admin page:

The issue resides in the method the function checks if a radio button is checked or not. This update is needed in Joomla ISIS template so that the “:checked” selector is used.

If you want to benefit from the “awaited” great performance boosts with APC, you need to disable Zend and Ioncube extension and enable APC.

Enable APC on Godaddy.com Hosting

Here is how to do it:

Open your working php.ini/php5.ini file (it might be in a subfolder or on your root folder)

If you have Zend or Ioncube extensions enabled, and you are sure your sites will work without them, disable these extensions by putting a semicolon (;) in front of each line about them.

If you see “apc.enabled=0″ somewhere, comment this line with a semicolon (;) too.

Godaddy Optimized php(5).ini

Here is a nice PHP5.INI (for Godaddy Linux hosting plans using FastCGI PHP 5.3)

Save it as php5.ini and place it in the public root of your server (/html folder). Careful to backup your current php5.ini.

cgi.fix_pathinfo = 1
cgi.check_shebang_line = 0
;register_argc_argv = false
default_charset= "UTF-8"

; Enable GZIP compression at the default level
zlib.output_compression = On
zlib.output_compression_level = 6

; Disable PHP magic quotes
;magic_quotes_gpc = Off
;magic_quotes_runtime = Off
;magic_quotes_sybase = Off

register_globals = off
allow_url_fopen = on

max_upload_filesize = 6M
upload_max_filesize=6M
memory_limit=48M
max_execution_time=30

expose_php = Off
max_input_time = 60
variables_order = "EGPCS"
extension_dir = ./
upload_tmp_dir = /tmp
precision = 12
SMTP = relay-hosting.secureserver.net
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=,fieldset="

date.timezone="Europe/Paris"

allow_call_time_pass_reference = on

; Load PDO MySQL extension
extension=pdo.so
extension=pdo_mysql.so

;APC
extension="apc.so"
apc.enabled=1
apc.shm_segments=1
apc.shm_size=128
apc.ttl=7200
apc.user_ttl=7200
apc.num_files_hint=1024
apc.enable_cli=1

; Only uncomment zend optimizer lines if your application requires Zend Optimizer support
[Zend]
;zend_optimizer.optimization_level=15
;zend_extension_manager.optimizer=/usr/local/Zend/lib/Optimizer-3.3.3
;zend_extension_manager.optimizer_ts=/usr/local/Zend/lib/Optimizer_TS-3.3.3
;zend_extension=/usr/local/Zend/lib/Optimizer-3.3.3/ZendExtensionManager.so
;ZEND GUARD (because we use PHP 5.3)
;zend_extension=/usr/local/Zend/lib/Guard-5.5.0/php-5.3.x/ZendGuardLoader.so
;zend_extension_ts=/usr/local/Zend/lib/Optimizer_TS-3.3.3/ZendExtensionManager_TS.so
; -- Be very careful to not to disable a function which might be needed!
; -- Uncomment the following lines to increase the security of your PHP site.
;disable_functions = "highlight_file,ini_alter,ini_restore,openlog,passthru,
; phpinfo, exec, system, dl, fsockopen, set_time_limit,
; popen, proc_open, proc_nice,shell_exec,show_source,symlink"

Now you have APC enabled by default!

Check if APC is installed on your Godaddy account

You can check it by opening a php file containing phpinfo() function.

Here is an example:

Save the code below in a file named: phpinfo.php

<?php
// Show all information, defaults to INFO_ALL
phpinfo();
?>

Now you can put this file next to your websites files (careful not to overwrite existing files) and browse to this file with your web browser. Search in the page for “APC”, you will know now…

Keep in mind that these settings apply if you have your hosting with any of Godaddy Resellers, like “DomainsPricedRight.com”

Faster websites get better SEO scores and get better indexes in search engines, a Google employee once said “Website should be fast”, your visitors will agree, trust me.

Faster and optimized eCommerce websites do sell +40% more than slower ones, just because they are faster. You “will” agree once you see the money come  trust me.

In the continuity of my “Website optimization” posts, this time we will see how to optimize CS-Cart, but hints and methods written here are useful for all other platforms, just you will need to adapt, easily.

E-Commerce Optimization

I assume you already know about the ROCK SOLID eCommerce software “CS-Cart”, if not, you are missing BIG!

odience.net|works sponsored this post and asked me to optimize their online marketplace which is based on CS-Cart.

The outcome? A faster CS-Cart store which loads in less than 5 seconds and gets a performance grade of 94/100 and on some pages 99/100 (check for yourself at Pingdom), this literally “ROCKS”.

UPDATE: Based on my work , odience.net|works made a package that CS-Cart users can use to speed-up their stores. Will be available soon!

Now we will see in this post, how you can optimize your site load times and speed.

A little bit more than “few” technical knowledge is required if you want to read on, but you never know, maybe you will learn on the way

I will expose different steps and aspects of optimization which are also applicable with other websites as we saw in my previous posts.

Time Matters

From an optimization point of view, even 0.1 second in load time matters so let’s get started.

Optimize Cache, Server side:

CS-Cart integrates a built-in cache, but that needs lots of modifications to be “robust” and “reliable”.

Here are some issues with CS-Cart’s cache:

• It “kind of” compresses the JavaScript files but doesn’t combine them! So you find your self serving multiple files which is BAD for load time.
• It does not cache external JS files you include with the {script} tag. OK, this might be “over doing” but it might be interesting as for serving “hosted” Google Analytics JS on CS-Cart…
• It “combines” the CSS files but does not compress them, so you will be sending the user a quite BIG file; and that is BAD for page speed too.
• It does not compress nor clean the HTML output, and again, BAD for speed.
• It does not serve files with the right expires header so no one know when to refresh the content! How a browser is supposed to know what and when to cache?

Well, what to do, is to optimize this caching to the maximum and make the page generation faster and faster.

So for example the same time CS-Cart “combines” CSS files, let’s tell it to “compress” the output CSS file. When it compresses JavaScript files “independently” let’s ask for a combined and compressed output file, in the mean while, cache external JS files to limit multi-domain requests for the user.

These steps are quite complex, and need core modification, so you must be careful when updating/upgrading your CS-Cart installation to keep a backup of your MODs.

SMARTY

If you don’t know it already, CS-Cart runs Smarty for its template engine. Smarty is basically great from an ease of use point of view, but unfortunately, Smarty v2 is not optimized for speed. Well, Smarty did great on its Smarty v3 on speed optimization, and included multiple cache handlers like eAccelerator, APC and others.

APC

I have to mention that APC caching improves A LOT your site performance, but, Smarty v2 does not contain an APC cache handler, so I made an APC cache handler for Smarty v2, and thus for CS-Cart 3, which makes your content load directly from “RAM” instead of Hard Drive. This means “very fast”.

CS-Cart Core Optimizers

You can download these “Optimizers” from my Downloads page  odience Market, instructions included.

Optimize Cache, Client side:

To tell the browser which files to cache and which ones to not, your server must send correct “Expires headers”.

Unfortunately CS-Cart does not set theme correctly. This causes your client’s browser NOT to cache and ask for every page element at each request. Seriously, you DO NOT WANT THIS, because, wait for it…. BAD for speed!

You will need to edit your HTACCESS file(s) to send correct “cache” headers to the user directly from your server.

CS-Cart Optimized HTACCESS

You can download a sample of the “CS-Cart Optimized HTACCESS” from my Downloads page and for the full version, check odience Market, instructions included.

Combine JavaScript files:

As I wrote before, CS-Cart just “compresses” JavaScript files and it does NOT combine the files. You need to combine the compressed JavaScript files to use less bandwidth and send the file FASTER to the user, because JavaScript files are “VERY DANGEROUS” for page speed.

A JavaScript file  literally blocks all other elements from loading until itself gets fully loaded, so you want it to be “alone” and to finish loading, wait for it …. …. …. FAST!

CS-Cart JS Optimizer

Get the “JavaScript Combine&Compress Smarty output filter”; that I wrote; from odience Market, instructions included.

Compress CSS files:

There are lots of great Open Source projects (ex. Minify) which allow great CSS optimization, combination and compression. I don’t know why CS-Cart does not integrate one such library?

Well, all that said, you need to compress CSS files, and more precisely, Minify them to let users receive just what they need to “style”, nothing more nothing less.

Use less files, Use more SPRITES:

CS-Cart uses a lot of small icons for its base skin.

If your current skin is using more than 20 different icons (not product images, just icons, ex. account icon, cart icon, live help icon, menu drop down arrows,…) you should think about combining them into a single file to decrease the number of requests a visitor’s browser makes to your server. This combination reduces significantly your page load time and speeds up your CS-Cart store. So, go ahead  and combine your small icons into one or two bigger image sprites to reduce file requests as these requests are BAD for speed.

There are some free tools which help you automate and simplify sprites generation:

• I recommend: http://spritegen.website-performance.org/
• Easy to use on running site: http://spriteme.org/
• Get coordinates of elements in your sprite: http://www.floweringmind.com/sprite-creator/
• To be tested: http://css-sprit.es/

CS-Cart Sprites based Basic skin

Still not finished, but I am working on creating a sprites based “Basic” skin for CS-Cart, help is much appreciated.

Use a CDN for your static contents:

CDN, CDN, CDN! (It stands for Content Delivery Network if your are new )

If you got the $$$ to run with the big guys, go with AKAMAI, Amazon and other big Content Delivery Networks.

But! You can set your FREE CDN too! just serve your static content from a different sub-domain (or domain), for exemple:

Serve images from

https://staticimg.yourdomain.com/images/

while serving your mains website from

https://www.yourdomain.com/

This allows “parallel” downloads which will increase significantly page speed.

Well, serving JavaScript and CSS files from a CDN is something to think twice about, because CS-Cart generates your CSS and JS files every time you refresh the cache so if you are on a CDN, that would happen slower than you expect.

To make CS-Cart “CDN-compatible” you will need to make few changes to your skin’s files. If you focus on moving only your images to the CDN, it would be quite easy, though you should also think about the Addons and their images.

Basically, by overriding the $images_dir SMARTY variable at the right moment, you can tell CS-Cart to go get the images from a CDN, though some minor modifications should be done on core smarty plugin files to let CSS files compile correctly.

Another great idea to setup a CDN for CS-Cart is to mount your CDN space as a partition (mount point) on your server and symlink your static directories (images, css, js, cache) to the mount point, this reduces all synchronisation lags, and saves you from changing core files.

But, a better idea, is to use a “Mirror CDN” like CDN77.com!

I already tested CDN77.com and the service is great. They offer a 14 days free trial, which lets you know if you are ready for CDN.

I really recommend them because of the number of pops (servers worldwide) and their affordable price ($4.90 /100GB of data, THIS IS VERY LOW!). So, if you need a CDN, sign up for CDN77.com and make your CS-Cart s

ite faster!

Let me explain on how to use a mirror CDN for your CS-Cart ecommerce software:

1. Open an account on CDN77.com
2. Create a new CDN
3. If you need SSL (I recommend it if you have a secure store)
4. Choose Free SSL (shared)
5. or choose a custom SSL (ex.: “https://cdn1.gibni.com/” for 39$/month)
6. Let 4 minutes pass by, for the CDN to be setup of course!
7. Modify your CS-Cart store to serve images (you can do it even for CSS and JS, but not really needed, as you would have less than 5 JS and CSS files; it’s up to you!)
8. Enjoy your Free CDN! (Yes, as simple as that, weird huh?)

Use a cookie-less domain for static components:

Sites setting cookies will send/set the cookie file (0.8 – 1.5 KB) for each requested component (even for static images and css/js files).

These static contents do not require a cookie file, so by using a subdomain, or another domain (like a CDN), you will be able to get this point fixed and make your static components “cookie-less”, i.e. about 1K size reduction per element, so again, read the previous section about CDN to setup one for your images (at least).

Optimize your server with HTACCESS and PHP.INI tweaks:

To oil the gears of your server, you might need to have a look at your .htaccess and php.ini (php5.ini) files.

Some stuff you could do:

• Set Expires headers based on file types,
• Tell the browser to cache CSS and JS files,
• Unset ETags,
• Set Gzip/Deflate compression for your HTML/PHP files,
• Secure access to your server and store,
• Secure file requests and prevent file request attacks
• Make sure downloadable files are downloadable! weird, huh?!
• Add the “missing” trailing slash in your URLs,
• Rewrite requests to WWW,
• Force secure connections through HTTPS
• Install a Virtualized Software Firewall through HTACCESS to protect yourself from hackers
• Protect  your server and store from unauthorized queries and requests
• Speed up the server with the PageSpeed Apache module
• and so on…

Specially with PHP.INI (PHP5.INI) you could:

• Set a default FROM address directly on the server to get your emails “delivered”
• Increase execution times and upload file sizes to optimize performance and ease file uploads
• Activate ZEND extensions to boost your server
• and so on…

CS-Cart optimized PHP.INI & HTACCESS

Check the optimized PHP5.INI file (created and tested on Godaddy.com’s Shared hosting) and a tweaked (basic) HTACCESS for CS-Cart at my Downloads page.

Conclusions

There is a lot to do for a better web, by optimizing your websites and e-shops, you use less bandwidth and energy. Apart from making better sales and getting better SEO scores, you make a greener world. Do not hesitate about optimization.

Today I got and email from Godaddy saying that Godaddy.com is implementing APC cache from 1st October 2012. APC cache helps your pages load a lot faster, but it is not always easy to implement it into your software. Smarty, the template engine, implements the APC cache from its version 3, but the older versions of Smarty, are a bit trickier to master.

Finding a good way of implementing APC cache to your Smarty 2 is a challenge, but don’t worry, I am here .

Here is a method to implement APC cache to your CS-Cart eCommerce software, which is using Smarty 2 as its templating engine:

You need to:

1. Create a SMARTY cache handler for handling APC cache. Be careful that your APC cache handler must be compatible with SMARTY 2, as of CS-Cart 3 is concerned.Here is the APC cache handler code for Smarty 2:

   Save this code as “cache.apc.php” and place it in your Smarty’s “plugins_dir” folder. (for CS-Cart, save it in:

   <CS-Cart ROOT>/core/smarty_plugins/

   Download APC Cache handler for Smarty 2, useful for CS-Cart 3 from my Downloads page

2. Modify the CS-Cart core files to initialize APC caching (careful with this step as it requires core modifications)For instructions about the CS-Cart modifications, please contact me.
3. Enjoy faster loading CS-Cart store!

1. Edit the file :

<CS-CART_ROOT>/core/fn.common.php

1. Around lines 2035 to 2044, you will find the fn_set_cookie() function,
2. Modify the last line of this function from:

 return setcookie($var, $value, $expiry, $current_path);

to

 $current_domain = (defined('HTTPS')) ? Registry::get('config.https_path') : Registry::get('config.http_path');
 if ($current_domain != ''){
    return setcookie($var, $value, $expiry, $current_path, $current_domain);
 }else{
    return setcookie($var, $value, $expiry, $current_path);
 }

Happy creating!

People hosting their websites on Godaddy.com servers, and its resellers, lost lots of money in this outage.

“Over 50 local Myrtle Beach hotels that use GoDaddy services through Fuel Interactive could be impacted by as much as $30,000 an hour, collectively, for each hour the sites are down.” says Wmbfnews. (1)

On the other hand, Disa Johnson says that Godaddy didn’t resolve the issue by themselves. It was the hacker who “had a heart” and let go!!!! (2)

How can making troubles for others be called “having a heart”??

Just search about this outage on Google News and Twitter (@Godaddy) and you will see that millions of websites were affected…

1- http://www.wmbfnews.com/story/19505927/hack-of-godaddy-sites-impacts-myrtle-beach-area-businesses
2 – http://airdisa.tumblr.com/post/31297877089/godaddy-dns-tangodown

When trying to log into my PrestaShop backoffice, the page was reloading / refreshing without any errors!
After much investigations (3hours non stop!) I found out this solution:
In the file “” under your backoffice’s folder,
on line 55, you have:

 $cookie = new Cookie('psAdmin', substr($_SERVER['PHP_SELF'], strlen(__PS_BASE_URI__), -10));

where the “-10″ value corresponds to the number of letters of “prestashop”, set it to the number of letters of your store’s subdirectory name and your will be back to the business again.

For exemple:
if your store is located at:
http://www.yourdomain.com/store/
the word “store” contains 5 letters, so the line 55 in login.php should become:

$cookie = new Cookie('psAdmin', substr($_SERVER['PHP_SELF'], strlen(__PS_BASE_URI__), -5));

What I found out again, is that Prestashop is a very bad done software and not ready for business. I will switch to a better e-commerce solution!

I’m give you a little trick to speed up your Joomla website and optimize its loading time.

If you are using the JoomlArt.com’s JA T3 Framework, which is really great, you might experience slow joomla website and long wainting times until something shows up!

Pages being slow are a pain for the visitors and might make them go away from your website.

I found out that if you enable the CSS and JS optimise options from your template’s settings page, the requests made to the optimised CSS and JS files are redirected multiple times which causes serious performance issues and slows down your pages! Strange huh??

That is because of a bug in the JAT3 base system plugin. Here is the fix:

Open the file:

<JOOMLA_ROOT>/plugins/system/jat3/head.php

Replace the “buildURL” function (from line 814 until 835) with the following:

    function buildURL($url)

    {

        if (JPluginHelper::isEnabled('system', 'languagefilter')) {

            $lang_codes = JLanguageHelper::getLanguages('lang_code');

            $default_lang = JComponentHelper::getParams('com_languages')->get('site', 'en-GB');

            $default_sef = $lang_codes[$default_lang]->sef;

            $app = JFactory::getApplication();

            $router = $app->getRouter();

            if ($router->getMode() == JROUTER_MODE_SEF) {

                if ($app->getCfg('sef_rewrite')) {

                    $url = JURI::base(true) . "/" .$default_sef. "/?$url";

                } else {

                    $url = JURI::base(true) . "/index.php" . "/" .$default_lang. "/?$url";

                }

            } else {

                $url = JURI::base(true) . "/index.php?lang=$default_sef&$url";

            }

        } else {

            $url = JURI::base(true) . "/index.php?$url";

        }

        return $url;

    }

Why upgrade MacBook’s RAM?

The main reason to upgrade is that  4GB RAM is not enough on a MacBook Pro if you run a virtual machine with Windows and want to do an RAM intensive work with your Mac. With a total of 8GB RAM, the MacBook Pro runs very smooth, even when running a virtual machine with 1.5GB RAM allocated to Windows 7.

I upgraded my MacBook Pro (early 2011) RAM from 4GB with 2 new CORSAIR 4GB modules, so a total of 8GB  of RAM. I recommend you upgrade your MacBook to 8GB of RAM to enjoy a lot smoother Mac!

The built-in RAM modules from Apple’s MacBook Pro were 2 HYNIX 2GB modules so a total of 4GB RAM.

WARNING: The tests and procedures in this article are for informative purposes only. Gibni.com and its authors take absolutely no responsibility for the damages, errors and troubles you may cause to your devices. Use at your own risk.

RAM issue or not?

Until now, it happened 3 times:

While using my Mac, the screen froze and horizontal lines appeared on the screen. The only way out is to “hard shutdown” the mac by holding down the power button for 7 seconds. From my IT experience, this relates some times to the Graphical Procession Unit (GPU) and some times to the RAM. So either the Graphics card is buggy or the new CORSAIR RAM modules.

Solving : Mac freeze, horizontal lines…

RAM stress test for Mac:

To test the RAM on the Mac, you should run some stress tests to find if any errors lay in the RAM. Sometimes the RAM behaves good in normal conditions but may throw errors on heavy computation. It is recommended to stress the RAM specially if it is new. One of the best tools is MemTest.

Here’s how to use MemTest on Mac:

( I recommend using MemTest on Single User mode to be able to test more memory as in Single User mode the system occupies very few RAM.)

1. Restart your Mac and hold “Command + S” to go in Single User mode,
2. A black screen appears with lots of text and after a few moments you will get a prompt,
3. Type in : memtest all 4
4. Wait about 1 hour! Remove the 3 to make it just about 20 minutes, but less reliable…
5. If everything gets passed, your RAM is probably OK
6. Else, proceed:
7. The first thing to do is to put back the own Apple’s RAM and run the stress tests again to see if the issue happens or not.

If the new CORSAIR RAM modules are having errors, I should find out which one is messy. I put only one CORSAIR 4GB RAM on the Mac, leaving the other RAM slot empty. Once I find which one is damaged, I will send it back to where I bought it from (RueDuCommerce.com), so they can change it for me.

CPU and GPU stress test for Mac:

If the problem is not with the RAM, it is probably with the GPU, or the way the GPU deals with the RAM (as it shares the system’s RAM)

Start your Mac normally, and use “smallLux GPU” (a tool I used and recommend it) to stress the GPU:

1. Download SmallLuxGPU
2. Install and run it
3. On the top left side, in the interactive modes section, Select “Instances 130Mil Scene”
4. Set the resolution to the maximum available,
5. Select GPU + 4 CPU threads
6. Hit “Run Interactive Mode”
7. Wait…

Your Mac will run and run and will heat up. If everything goes fine for about 20 minutes, your GPU is OK, else if you get errors, freeze or horizontal/vertical lines on screen, there is an issue either with your GPU or the way it handles its memory.

If your GPU passes the tests above, BUT you still have freeze/horizontal or vertical lines issues, then the problem might be software or something very complicated which is not in the scope of this article. You should call an Apple Authorized Repair expert in your area.

In case you have an issue with the GPU, RAM, CPU or any hardware on your Mac, call an Apple specialist as soon as possible. Don’t try to open up you Mac because there is nothing you can do.

Some tools for your Mac:

Mac RAM Stress test:

Memory Tester from diglloydTools

MemTest for Mac

Mac CPU stress test:

Simple Terminal: open up 8 terminal windws and enter (no quotes) ‘yes > /dev/null’

MySQL stress Test on Mac

Stress CPU from Folding@Home

CPU / GPU stress test:

SmallLuxGPU

CPU, RAM, Hard drive,… Temperature Monitor for Mac:

TemperatureMonitor

Fan speed Control for Mac:

smcFanControl

If you are running a Joomla! website, you’ve already heard about the Joomla 1.7 upgrade. It’s recommended to upgrade to this version specially if you run Joomla 1.6.

Basic steps to update/upgrade to Joomla 1.7:

• How to Upgrade 1.6 to 1.7 http://docs.joomla.org/Upgrade_1.6.5_to_1.7
• How to Upgrade 1.5 to 1.7 http://docs.joomla.org/Upgrade_1.5_to_1.7
• How to Install 1.7 http://docs.joomla.org/Install_1.7

In some situtations, you might have trouble upgrading Joomla with the built-in “Joomla Updater”.

Joomla 1.7 Upgrade errors:

• “Update: :Collection: Could not open http://update.joomla.org/core/list.xml”

  To solve this errror, you need to “allow fopen” on your server:

  1. Create a php.ini file in your Joomla site’s root. This file should contain the following line:
        

     allow_url_fopen = on

  2. Make sure that the file is having the 644 permissions at least.
  3. Check if fopen is allowed by running a simple php file inside your Joomla root directory containing the following line:

     <?php phpinfo(); ?>

     and look for “allow_url_fopen”, it should say “ON”

  To upgrade to Joomla 1.7 on a Godaddy hosting running PHP5, you should create a “php5.ini” instead of the php.ini stated above.

• Joomla updates do not appear, and Joomla says there is no upgrade available at the moment?

  If you run Joomla 1.6.x,

  1. Go to the “Extension Manager”, hit the “Manage” tab, click the “Refresh Cache” button.
  2. Go back to “Update” tab, click “Purge Cache”
  3. Click on the “Find updates” button,
  4. Joomla should appear as an update option, check it and click the “Update” button.

• Fatal error: Cannot instantiate abstract class JDatabaseQuery in mysite/plugins/system/jat3/jat3/core/joomla/modulehelper.php on line 292

  When you run a JoomlaArt template, as of today, you will get an error after upgrading to Joomla 1.7.

  As the error message says it, the error is on line 292 of the above file. With your FTP client, or web file manager, navigate to the file mentioned above and edit the file.

  On line 292, comment out this:

  $query = new JDatabaseQuery;

  and insert this line below it:

  $query = $db->getQuery(true);

  so the final result at lines 292 and 293 looks like this:

  //$query = new JDatabaseQuery;
  $query = $db->getQuery(true);

• Fatal error: Cannot instantiate abstract class JDatabaseQuery in mysite/plugins/system/jat3/jat3/core/menu/base.class.php on line 329

  If you use the mega menu of JoomlaArt, you need to do the same proccess for the file base.class.php

  That is, the lines 329 and 330 should be as follows:

  //$query = new JDatabaseQuery;$query = $db->getQuery(true);