osCommerce News
Recent posts
post item
Managing FedEx Shipping
March 28, 2024
Managing FedEx Shipping ...
post item
Managing DHL Shipping
March 27, 2024
Managing DHL Shipping ...
post item
Managing Search Plus
March 26, 2024
Managing Search Plus ...
post item
Managing Universal Log Report
March 25, 2024
Managing Universal Log Report ...
post item
Managing Temporary Stock Report
March 21, 2024
Managing Temporary Stock Report ...
post item
Updating Opayo Server Module
March 20, 2024
Updating Opayo Server Module ...
post item
Updating Opayo Pi Module
March 19, 2024
Updating Opayo Pi Module ...
post item
Managing Summary Report
March 19, 2024
Managing Summary Report ...
post item
Managing Stock by Manufacturer Report
March 18, 2024
Managing Stock by Manufacturer Report ...
post item
Managing Purchase Report
March 15, 2024
Managing Purchase Report ...
Products
Tags

Management

Ecommerce

Integrations

newsite

launch

grant

fund

replatforming

osCommerce 4.x

shopping cart

hosting

Installation

New PayPal Module (Latest API 2.0)

osCommerce 2.2

osCommerce 2.3

Shopping cart customizations

Manually

PayPal Express

APM (Alternative Payment Method)

Standard Variant

Advanced Variant

Configuration

Testing

Front End

Install osCommerce for Me

Let me install myself

Multiple sales channels

Single active sales channel

Installation on your own server

Assigning theme to sales channel

Deleting sales channel

Connect

App Shop

Adding Free Module

Admin Area

Adding Paid Module

Installing Module

Opayo Pi Module

Development Mode

Email Verification Before Registration

Managing Languages

Managing phpMussel

Managing Orders

oscommerce.com account

Creating Manual Orders

Managing Customers

Managing Customer Groups

Managing Brands

Managing Categories

Managing Filters on Categories

Managing Products

Managing Stock

Assigning Products and Categories to Front Ends

Assigning and Moving Products to Categories

Managing Default Sort Order on Product Listing and Category

Managing Cross-Sell and UPSell

Managing Reviews

Managing Attributes

Managing Product Groups

Managing Properties

Managing Suppliers

Managing Warehouses

Managing Sales Statistics and Purchase Report

Managing Stocktaking Costs

Managing Deleted Orders

Managing Coupons

Managing Virtual Gift Cards

Managing Sales Price

Managing Giveaways

Managing Featured Products

Managing SEO

Managing Meta Tags

Managing XML Sitemap

Settings of E-commerce Tracking for Google Tag Manager

Setting up GA4

Managing Pages

Managing Menus

Assigning Theme to Sales Channels

Deleting Sales Channels

Managing Translations

Managing Email Templates

Managing Catalog Pages

Managing Shipping Modules

Managing Payment Modules

Managing Order Structure

Managing Socials

Managing Extensions

Managing Managers

Managing Access Levels

Managing Back End Menu

Managing Configuration

Mail Sending via SMTP

Setting up SMTP

Status Groups

Order Statuses

Comment Templates

Stock Indication

Notify Me when in Stock

Stock Delivery Terms

Cross Sell Type

Cache Control

Filters

Managing Countries

Managing Counties and States

Geo Zones

Managing Cities

city settings

Postal Codes

Managing Taxes

Managing Currencies

Backups

Viewing Who is Online

Managing IP Restriction

Error Log Viewer

Creating Installation

Address Formats

Image Settings

Sales Tags

Managing Front Ends

Managing App Shop

Going Live with osCommerce

Affiliate Module

Awin Module

B2B Module

Business To Business module

Bazaarvoice Module

Managing Blog

Collection Points

Managing Competitors

Customer Code Module

Customer Modules Module

Customer Multi Emails Module

Customer Products Module

Delayed Despatch Module

Delivery Options Module

Fraud Address Module

Frontend Session Module

Invoice Number Format Module

Maximum Order Quantity

Merge Customers Module

Merge Orders Module

Minimum Order Quantity

Neighbour Module

One Trust Module

Order Flags and Markers

Pack Units

Covered by Coupon Module

Klarna Module

LiqPay Module

Mollie Pay

Pay360 by Capita Module

pxPay Module

RBS WorldPay Module

Tyl by NatWest Module

Personal Catalog

Personal Discount Module

Product Bundles

Product Collections

Product Easy View

Product Global Sort

Product Ignored Payment Methods

Product Ignored Shipping Methods

Product Press Reviews

Product Relocation

Managing Refer Friend

Bookkeeping Detail Report

Changes History Report

Compare Report

Deficit Product Report

Emails History Report

Report by Email Module

Expected Products Report

Managing Freeze Stock

In Cart Stock Report

Low Stock Report

Manufacturer Sales Report

Ordered Products Report

Purchase Report

Stock by Manufacturer Report

Summary Report

Updating Opayo Pi Module

Updating Opayo Server Module

Temporary Stock Report

Universal Log Report

Managing Search Plus

Managing DHL Shipping

Managing FedEx Shipping

Issue #32: November 10, 2003

By Harald Ponce de Leon

November 10, 2003

Forum Migration
Development Progress
Contributions Forum Channel
Wiki Documentation

Discussions regarding this weekly report can be found here:

https://www.oscommerce.com/forums/index.php?showtopic=65383

Forum Migration

After the successful migration procedure of moving from a phpBB powered forum solution to an InvisionBoard powered forum solution, performance issues arose when a high number of search queries were being performed simultaneously.

When this happened, MySQL would choke on the number of incoming SQL queries and lock the general queries while struggling to perform the intensive search queries. This buildup of locked queries ultimately reached the maximum number of queries/connections allowed and brought the whole database server down, which unfortunately also affected the whole support site in general.

After failed attempts at fine-tuning InvisionBoard, upgrading MySQL to 4.x, and trying InnoDB based database tables for better locking capabilities, our sponsor Pair Networks graciously upgraded the server from a QS1 server to a QS3 server with no extra costs involved, which solved most of the performance issues.

We are still in the process of fine-tuning the server in general, as at times a buildup of locked queries still occurs. We'd like to thank you for your patience during this time, and for all the reports and notifications sent in when the server was down.

The move from phpBB to InvisionBoard was made to provide moderators with more power that aids them in their moderator duties, and to provide better search results for community members.

Development Progress

The Workboard entries for Milestone 3 and Milestone 4 have been reshuffled to change the focus on the remaining milestone releases.

The focus of the Milestone 3 release is to freeze the core API with the last amount of big changes to be made on implementing classes, being register_globals compatible, and integrating a template structure for easier frontend design work to be done.

These changes are needed to reach the goal of being "secure, stable, and efficient" which unfortunately brings in the side effect of contributions being incompatible due to the API changes required.

Reshuffling the Workboard entries has allowed us to focus the incompatibility issue on just one milestone release instead of two, with the original register_globals compatibility being assigned to Milestone 4 now being assigned to Milestone 3.

Documentation on the API changes will be provided on the Wiki site during this week when the changes are committed to the CVS repository.

The focus of the Milestone 4 release is to merge the Catalog and Administration Tool files, integrate contributions the community has provided, and to publish the much needed user documentation.

The Milestone 4 release will be the last development release before a finalized osCommerce 2.2 package is made available.

Due to the long development time of finalizing 2.2, and due to the increased focus on the "secure, stable, and efficient" goal, PHP 3 compatibility will be dropped on the Milestone 3 release to focus on the advantages PHP > 4.1 brings while remaining compatible to PHP 4.0.x.

As PHP 5.0 is nearing, future releases will focus on taking advantage of PHP 5 while remaining compatible to PHP 4.

Contributions Forum Channel

This week the Contributions forum channel will be split to its own category with a channel for announcements and a channel for general support.

This move should ease the information overflow effect currently occurring in the single forum channel.

Wiki Documentation

The structure of the Wiki documentation has been updated - feedback is welcome on the Wiki forum channel.

The Wiki documentation can be reached at:

https://www.oscommerce.com/wiki

The Wiki forum channel can be reached at:

https://www.oscommerce.com/forums/index.php?showforum=15

 

You can further discuss it on our Forum