osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

Faster Page Loads, Less DB queries

This is a discussion on Faster Page Loads, Less DB queries within the New osCommerce Contributions forums, part of the osCommerce 2.2 Forums category; While fooling around i found that the modules.php could insert a row in the configurations table with an empty configuration_key, ...


Go Back   osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > New osCommerce Contributions

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Reply

 

LinkBack Thread Tools
  #1  
Old 05-20-2007, 11:59 AM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,330
Thanks: 68
Thanked 322 Times in 305 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Post Faster Page Loads, Less DB queries

While fooling around i found that the modules.php could insert a row in the configurations table
with an empty configuration_key, resulting in the cache function inserted;

define('', '');

Thus the cached config file got currupted and issuing an error both in catalog and admin.

To handle this and to secure other contribs don't imply this error, please replace following line;

$configuration_query = tep_db_query('select configuration_key as cfgKey, configuration_value as cfgValue from ' . TABLE_CONFIGURATION);


With;

$configuration_query = tep_db_query("select configuration_key as cfgKey, configuration_value as cfgValue from " . TABLE_CONFIGURATION . " where configuration_key != ''");

The file to download is just a dummy textfile, containing this text. No more no less.

Best Regards,

Phliplip ;)

More...
__________________
Michael Sasek
osCMax Developer


  • osCMax Templates - Hundreds of premium quality templates. New designs every month!

  • xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.

  • osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host.

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
FAN - Faster Admin Navigation michael_s New osCommerce Contributions 0 02-12-2007 12:02 AM
FAN - Faster Admin Navigation michael_s New osCommerce Contributions 0 02-11-2007 05:01 PM
FAN - Faster Admin Navigation michael_s New osCommerce Contributions 0 02-11-2007 10:21 AM
So Many Queries so little time delphi1 osCMax v2 Customization/Mods 10 11-07-2005 05:02 AM
Custom Queries know osCommerce 2.2 Modification Help 1 10-29-2002 11:14 AM


All times are GMT -8. The time now is 05:06 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax