Psytanium

done and working. php -q public_html/backend/auto_update_currencies.php

this is the cronjob output i'm getting: /usr/local/cpanel/bin/jailshell: /home/domain/public_html/backend/auto_update_currencies.php: Permission denied any idea what could be the reason ? I'm running osc 2.3.4

Good day, How can i know which Coupon is used ? Thank you.

<meta name="description" content=""> <meta name="keywords" content=""> anyone here ? osc2.3.3.4

alright, ill try to remove the addon, currently it have a bug and its not functional, probably because an SQL or PHP version. Tested and failed on PHP 5.4.37 and MySQL 5.5.40-cll

@@kymation i'll explain to you. probably your module have a bug. I installed a fresh 2.3.3.4 version, and uploaded your files 1.4.6 the problem persist. please have look here (temporary domain mame, do whatever you want): http://3d-cosmetics.com/admin user: kymation pass: kymation to test the problem: install the (Category Meta Keywords - Insert) module now remove the (Category Meta Keywords - Insert) module go and edit any category and you will see the (Category Meta Keywords - Insert)

i tried it on another osc 2.3.1 website, same problem, currently I'm testing this addon on a fresh osc 2.3.3.4. will let you know. could it be the php or sql version ? btw, I'm using the Modular SEO Header Tags 1.4.6

how did you know your next post solved the problem ? anyway, i told you before, I uploaded the same categories.php file included in your package. same problem happening. as i can see, the problem lies in the : catalog/admin/includes/modules/header_tags/categories_insert.php catalog/admin/includes/modules/header_tags/categories_products_process.php catalog/admin/includes/modules/header_tags/products_insert.php all your other modules (title, front page, etc...) are working perfect. just the (Categories / Products Insert New) have the following problem: text fields do now show in case of "insert new product" but appear in case of "edit product"

i have files back up but i don't have database back up. anyway, if you don't have time to fix the problem it's alright, maybe someone else have a solution. especially that i found other having the same problem here.

I'm stuck in between. i can't remove this addon, because i didn't back up my database before installing the modules. and i can't proceed, because its all corrupted. that's why i keep knocking at your doors.

i checked the database, if i delete the modules of this addon, the database remain the same, i cannot uninstall it, please give me some hints, or where should i look. When i insert a new product, both the installed an uninstalled are disabled, unlike when i edit a product, both are enabled.

just to report my attempts.. I can install then remove other modules without problem, i tried the social social media modules.

I noticed something, once i install a module, i cannot remove it. I tried to install Category meta keyword - Insert, it appeared fine. now I removed the module, but it still exist when i edit a category.

@@kymation i did check very carefully again, also I used the exact categories.php file from your addon. same problem: New product : Nothing appear. Edit product : both appear, the installed and not installed. Installed modules: Canonical Header Links Category Title - Category Name Front Page - Description Front Page - Keywords Language Product Meta Description - Product Description Product Meta Keywords - Insert Product Title - Model Product Title - Product Name Robot NoIndex is your addon compatible with 2.3.3.4 ? thank you.

if i insert new product, product meta description and meta keywords won't appear. but they appear if i edit a product. I removed all modules, the meta description and keywords still appear when i edit a product. does it happened previously with someone ?

hehe , well , i mean 2.3.4. thank you.

hello, i have this addon version 1.1.11 installed. is there any changes should i do to this addon if I upgrade from osc2.3 to 2.4 ?

sry i get you wrong at first. yes if i run the url from a browser the page ask me to login. does this mean the cron jobs is running fine but have permission problem with the addon ? that's what i have in the file : require_once('includes/configure.php'); require_once(DIR_WS_FUNCTIONS . 'localization.php'); $link = mysqli_connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD,DB_DATABASE) or die("Unable to connect to database server!"); should i replace some variables ? Cron jobs: /home/wood/public_html/admin/auto_update_currencies.php

i think you are right, there is a security problem, some phishing files. how can i fix this issue ? just upgrading to the latest version ? or there is something else ? thank you for your advice.

@@Jack_mcs, i have no idea why the cron jobs is not working. just a quick question if a browse directly www.domain.com/admin/auto_update_currencies.php i should be asked to login?

@@Bob Terveuren thx, i really appreciate your help. also i needed the 2% markup. :thumbsup:

What versions are compatible ? is there something i can do ?

the update currency button is working fine, currencies updated. thats the code <? /* Auto Update Currencies v 1.0 by Jack_mcs - oscommerce-solution.com osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ ///////CONFIGURABLE VARIABLES/////////// define('DEFAULT_CURRENCY', 'EUR'); define('HOURS_BETWEEN_UPDATES' , '24'); //if more than one day, multiply days by hours so the setting for two days would be 2 * 24 = 48 define('REPORT_NO_UPDATE', true); //if the currencies are not updated since they have already been updated, don't report it. Set to false to always receive this message define('NO_REPORT', 0); define('SCREEN', 1); define('EMAIL', 2); define('SCREEN_EMAIL', 3); $output_report = EMAIL; ///////////////END////////////////////// define('CURRENCY_SERVER_PRIMARY', 'xe'); define('CURRENCY_SERVER_BACKUP', 'oanda'); require_once('includes/configure.php'); require_once(DIR_WS_FUNCTIONS . 'localization.php'); function date_diff_new($str_start, $str_end) { $str_start = strtotime($str_start); // The start date becomes a timestamp $str_end = strtotime($str_end); // The end date becomes a timestamp $nseconds = $str_end - $str_start; // Number of seconds between the two dates $ndays = round($nseconds / 86400); // One day has 86400 seconds $nseconds = $nseconds % 86400; // The remainder from the operation $nhours = round($nseconds / 3600); // One hour has 3600 seconds $nseconds = $nseconds % 3600; $nminutes = round($nseconds / 60); // One minute has 60 seconds, duh! $nseconds = $nseconds % 60; return $nhours; } $link = mysql_connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD) or die("Unable to connect to database server!"); mysql_select_db(DB_DATABASE); $report = ''; $updated = array(); $rate = ''; $today = date("Y-m-d H:i:s"); // The exact time $currency_query = mysql_query("select currencies_id, code, title, last_updated from currencies" ) or die(mysql_error()); while ($currency = mysql_fetch_array($currency_query, MYSQL_ASSOC)) { if (($ndays = date_diff_new($currency['last_updated'], $today)) > HOURS_BETWEEN_UPDATES) { $quote_function = 'quote_' . CURRENCY_SERVER_PRIMARY . '_currency'; $rate = $quote_function($currency['code']); if (empty($rate)) { $quote_function = 'quote_' . CURRENCY_SERVER_BACKUP . '_currency'; $rate = $quote_function($currency['code']); } if (!empty($rate)) { $updated[] = 'The exchange rate for ' . $currency['title'] . ' <b>WAS</b> successfully updated.' . "\n"; mysql_query("update currencies set value = '" . $rate . "', last_updated = now() where currencies_id = '" . (int)$currency['currencies_id'] . "'"); } else $updated[] = 'The exchange rate for ' . $currency['title'] . ' <b>WAS NOT</b> successfully updated. It was last updated on ' . $currency['last_updated'] . "\n"; } else if (REPORT_NO_UPDATE) $updated[] = $currency['title'] . ' was not updated since it has been updated in the last ' . HOURS_BETWEEN_UPDATES . ((HOURS_BETWEEN_UPDATES > 1) ? ' hours.' : ' hour.') . "\n"; } if ($output_report > NO_REPORT) { $report = 'Currencies Update Report' . "\n\n"; $configuration_query = mysql_query("select configuration_value as store_name from configuration where configuration_key = 'STORE_NAME' limit 1") or die(mysql_error()); $configuration = mysql_fetch_array($configuration_query, MYSQL_ASSOC); $report .= 'Currencies for ' . $configuration['store_name'] . ' updated on ' . date("D M j G:i:s Y") . "\n\n"; foreach ($updated as $changed) $report .= $changed; if ($output_report != EMAIL) { echo str_replace("\n", '<br>', $report); } if ($output_report != SCREEN) { $config_query = mysql_query("select configuration_value as email_address from configuration where configuration_key = 'STORE_OWNER_EMAIL_ADDRESS' limit 1") or die(mysql_error()); $config = mysql_fetch_array($config_query, MYSQL_ASSOC); mail($config['email_address'], 'Currency Rates updated for ' . $configuration['store_name'], stripslashes($report), $configuration['store_name']); } } mysql_close($link); ?> anything wrong ?

Hello @@Jack_mcs I did the edit of the file and upload it to the admin directory, setup a cron job, but I don't know why its not working, I waited 48h and the exchange rate didn't changed. Also I tried to run the script directly by browsing domain.com/admin/auto_update_currencies.php the page returned a blank page and the exchange rate didn't changed. can you please help me ?

same problem with me, anyone solved it ?