|
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
|
|
Hm... ada apa dengan judul diatas? Jadi begini, alkisah beberapa waktu lalu salah satu server dijaminmurah.com dimana pnyet bernaung mengalami overload process yang disebabkan oleh salah satu user di server tersebut. Setelah berita dipublish oleh pihak Dijaminmurah akhirnya saya tahu penyebabnya adalah cron job yang dijalankan oleh wp-cron.php. |
|
Read more...
|
|
|
|
