|
Written by pnyet
|
Secara default, halaman administrasi oscommerce tidaklah aman. Tanpa username atau password siapapun bisa masuk sebagai administrator di admin panel oscommerce. Disini akan saya tulis hasil translate dari how to securing admin panel on oscommerce. untuk kontribusi paket secure login & logout admin dapat didownload disini. |
|
Read more...
|
|
|
Written by pnyet
|
|
Standar awal dari OSCommerce untuk proses update currency adalah dengan melalui website OANDA atau XE, ini bisa dilihat pada file admin/includes/application_top yang berupa
// Define how do we update currency exchange rates
// Possible values are 'oanda' 'xe' or ''
define('CURRENCY_SERVER_PRIMARY', 'oanda');
define('CURRENCY_SERVER_BACKUP', 'xe');
|
|
Read more...
|
|
|
Written by pnyet
|
MySQL 5.0 Compatibility ------------------------------------------------------------------------------ Problem: MySQL 5.0 introduces Server SQL modes as part of its SQL 2003 standards support, and uses a more stricter approach to executing SQL queries. This is performed by default with setting STRICT_TRANS_TABLES as a Server SQL mode. Due to this new setting, MySQL fails on certain SQL queries and produces error messages on the screen. Solution: |
|
Read more...
|
|
|
Written by pnyet
|
|
1054 - Unknown column 'p.products_id' in 'on clause'
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '62' order by pd.products_name
[TEP STOP] And how to fix this error? Please following step by step in there:
|
|
Read more...
|
|
|
Written by pnyet
|
his happens due to a bug in OSCommerce after the recent server upgrade from PHP 4.x to PHP 5. The way the code was written in upload.php was using an undocumented feature that was not officially supported, and subsequently did not carry over into PHP 5.
To fix this, edit the 'upload.php' file mentioned in the error message using a text editor. Open the file and find the line (about 30 lines down) that says:
// self destruct
$this = null;
And edit it to say this:
// self destruct
// $this = null;
unset($this);
(basically comment out with // the $this = null; line and add the unset($this); line)
Your admin panel should work properly now.
|
|
|
|
