Php Warning: It is not safe to rely on the system’s timezone settings …

Was getting following error while installing a php script:

” It is not safe to rely on the system’s timezone settings. You are
*required* to use the date.timezone setting or the
date_default_timezone_set() function … “

1) One way to approach this is to let php know what your time zone
is. You can edit your php.ini file and put in the following line:

date.timezone = “Asia/Dhaka”

2) But this was not effective immediately to the script. So best way I found is to insert a line at the top of the “functions.php” file – this is the file where the error was originated. The line was as below:

date_default_timezone_set(‘Asia/Dhaka’);

And that solves the issue.

PHP Link Directory v4.0 Installation Problem: Too long comment for table ‘pld_submit_verification’

In “include\tables.php” COMMENT is defined as:
‘Stores submit sessions for an improved validation of submitions’
replace it with something shortened:
‘Stores submit sessions for an improved validation’

Save the “include\tables.php” then resume the installation from where problem occured. You don’t need to drop the database and restart installation.

PHP Link Directory v4.0 Installation Problem – “Session variables are not available or not properly configured”

While installing PHPLD v4.0 on the second page i get an error message ” Session variables are not available or not properly configured.” The problem I identified was with the “include/config.php” setting.

The issue can be resolved in one the following ways:

a) in the .htacces add this if your host allows you to set php attributes:
php_value session.save_path /yourdomain/tmp/
obviously change yourdomain to your real site.

or

b) in the /include/config.php, add under the other ini_set that is in there:
ini_set (’session.save_path’, ‘/tmp’);
or
ini_set (’session.save_path’, INSTALL_PATH.’temp’);

The IP you are using to access the e-gold website appears to be either an open proxy

Is your e-gold account blocked? Are you trying to access your e-gold account and finding it difficult. Bewildered and clueless having the e-gold security notification like this one below?

“Unable to login to account.

Access denied

The IP you are using to access the e-gold website (your IP) appears to be either an open proxy or otherwise exploited. You will not be permitted to access e-gold services from this IP while this condition continues.

Your first order of business to restore access should be to make sure that you are computing securely. Please read and implement e-gold’s Security Recommendations.

After you have resolved any security issues, including virus removal, it may take a day or two for your access to be re-enabled.”

Well you are not alone. Especially if you are using an internet connection offered by mobile telephone company. A VPN connection is costly. To resolve this issue you may try some free proxy but note that chances are these proxies may also be blocked by e-gold once they notice it.

Some proxy that may allow access to your e-gold account are:
http://www.ninjaproxy.com
https://www.ninjcloak.com
http://www.drproxy.net

The below proxy no longer works:
http://hiddencloak.com/

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()