Useful SQL Queries for osCommerce Store Management

Here are two useful SQL queries for osCommerce database:

product_attribute_download.qbquery

SELECT p.products_id, p.products_name, a.products_attributes_id, d.products_attributes_filename
FROM products_description p, products_attributes a, products_attributes_download d
where p.products_id=a.products_id
and a.products_attributes_id=d.products_attributes_id;

product_category.qbquery

SELECT pc.products_id, pc.categories_id, pd.products_name, cd.categories_name
FROM products_to_categories pc, products_description pd, categories_description cd
WHERE pc.products_id=pd.products_id
AND pc.categories_id= cd.categories_id;

FTP to localhost

Make sure that you set write permission for “Default FTP Site”. Open up “Internet Information Service”. Right click on “Deafult FTP Site” and then click “Properties”. From the property dialog select “Home Directory” tab and then check on “Write”.

You will be able to write files using FTP. By default the files will be written to “c:\inetpub\ftproot” folder.

MySQL 5.0: The used table type doesn’t support FULLTEXT indexes

The following SQL statement produces the error “The used table type
doesn’t support FULLTEXT indexes” when executed in MySQL 5.0 query
browser. The default table type was InnoDB which doesn’t support
FULLTEXT indexes. The FULLTEXT indexes is supported by MyISAM (old
ISAM) table type.

DROP TABLE IF EXISTS `asb_articles`;
CREATE TABLE `asb_articles` (
  `id` int(255) NOT NULL auto_increment,
  `url` varchar(255) NOT NULL default '',
  `title` longtext NOT NULL,
  `author` varchar(200) NOT NULL default '',
  `article` longtext NOT NULL,
  `resource_box` longtext NOT NULL,
  `category` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `url` (`url`),
  FULLTEXT KEY `article` (`article`)
) AUTO_INCREMENT=1;

So when ENGINE for the table is specified as below it was allright. The statement ENGINE=MYISAM is the storage engine for the table here. The older term TYPE is supported (TYPE=ISAM) as a synonym for ENGINE for backward compatibility, but ENGINE is the preferred term and TYPE is deprecated.

DROP TABLE IF EXISTS `asb_articles`;
CREATE TABLE `asb_articles` (
  `id` int(255) NOT NULL auto_increment,
  `url` varchar(255) NOT NULL default '',
  `title` longtext NOT NULL,
  `author` varchar(200) NOT NULL default '',
  `article` longtext NOT NULL,
  `resource_box` longtext NOT NULL,
  `category` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `url` (`url`),
  FULLTEXT KEY `article` (`article`)
) AUTO_INCREMENT=1 ENGINE = MYISAM;

For detail please see: http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html

Warning: I am able to write to the configuration file – On windows server

I am having this warning message after successfully installing oSCommerce on a windows server. The usual remedy to this for on a unix server is to do a CHMOD 644 for the file (in this case the file is \includes\configure.php) but CHMOD is not possible on a windows server.

At last i have found a solution here:
http://www.oscommerce.com/community/contributions,3131/page,18

It takes talent to exit

Any fool can enter, it takes talent to exit consistently and profitably (– Jeff Cooper about Trading)

How to Auto Submit a Form in VBScript

Here is an example code snippet. Replace the site address, field names and values to match the form you want to submit. Save the code in a file and save it using vbs (VBScript) extension. Double click on the file and you are done.

Set IE = CreateObject("InternetExplorer.Application")
set WshShell = WScript.CreateObject("WScript.Shell")
IE.Navigate "http://mydomain.com/form.asp"
IE.Visible = True
Wscript.Sleep 2000
IE.Document.All.Item("uselectid").Value = "10001"
IE.Document.All.Item("category").Value = "19"
IE.Document.All.Item("rep").Value = "10001"
IE.Document.All.Item("title").Value = "A new problem title"
IE.Document.All.Item("description").Value = "Description of the new problem"
call IE.Document.Forms(0).Submit()


File and Folder Security – Installing PHP Based Web Application on Windows Machine

Setting up php based web applications such as SMF etc. requires to set file and folder permission. In XP using NTFS file system, this is a problem when Anonymous website access is set. By default in-process applications such as ASP web pages use IUSR_MACHINE account and ISAPI applications (e.g. PHP) and other out-of-process applications use IWAM_MACHINE account for anonymous access.

I was trying to setup files and folder access required to install SMF using either of the two anonymous user account but failed.

So I just reset the SMF virtual directory access to use Windows Authentication and thereafter I found no problem installing SMF.

Installing PHP 5 on IIS 5 or IIS 6 in 5 simple steps

Just click the link below and follow the steps outlined there:
Installing PHP 5 on IIS 5 or IIS 6 in 5 simple steps

Uninstalling IIS from Windows XP

It seemed an easy task at first. From the windows control panel we have to choose Add/Remove Programs, and then to choose Add/Remove Windows components. Once IIS is unchecked we should be able to uninstall it. But unfortunately it could not finish uninstalling IIS that way. It could uninstall several components of IIS individually but it failed or appeared non-responsive during un-installing World Wide Web Service component of IIS.

After many trial and error attempts and googling I finally figured out an way. I restarted my PC in Safe mode and followed the above approach and was able to unistall IIS finally. If you dont know how to restart your PC in safe mode – reboot it and keep pressing on F8.

The file wmplayer.exe has a version number of 11.0.5358.4827 where 9.0.0.3250 was expected

I’ve just installed Window Media Player 11 on windows xp sp2, but when I start, it gives an error message:
“The file wmplayer.exe has a version number of 11.0.5358.4827 where 9.0.0.3250 was expected”
and I’m not able to start the player. After a little googling found this tips on eivaagames.com. The fix is as follows:

For Windows Vista:
Reboot your system. Then open cmd.exe as an administrator and then run
“c:\windows\system32\unregmp2.exe /UpdateWMP” to fix this.

On all other Windows systems:
Reboot your system and then run “c:\windows\inf\unregmp2.exe /UpdateWMP” to fix this.