scartier

I solved it modifying admin/contrib_tracker.php from: case 'quick_insert': if (is_numeric($HTTP_POST_VARS['contrib_quick_insert'])){ $date_updated =date("Y-m-d H:M:S"); $date_added =date("Y-m-d H:M:S"); to: case 'quick_insert': if (is_numeric($HTTP_POST_VARS['contrib_quick_insert'])){ $date_updated =strtotime($HTTP_POST_VARS['last_update']); $date_updated=strftime ($format, $date_updated); $date_added =strtotime($HTTP_POST_VARS['note_created']); $date_added=strftime ($format, $date_added); I don't know if it's correct since I'm not a PHP expert but it works... Sébastien

Hi Steve, Great contrib but I get this error: 1292 - Incorrect datetime value: '2009-10-29 12:Oct:th' for column 'note_created' at row 1 insert into contrib_tracker (contr_id, contrib_osc_id, contrib_name, contrib_link, contrib_support, config_comments, note_created, contr_last_modified, status, last_update, contrib_vers) values (NULL, '6853','H2EPAYMENT OSCommerce plugin','http://addons.oscommerce.com/info/6853','','', '2009-10-29 12:Oct:th', '2009-07-02 00:00:00', '1', '2009-10-29 12:Oct:th', '' ) Sébastien

Hi I have a problem with Explorer not handling various css files. In that case, it doesn't look fwr_suckertree_css_menu.php file and only apply directives from stylesheet.css. What can I do? Sébastien

Hi Is there a way to make One Page Checkout work with TPV Virtual Servired, Pago en Mano + Retirar en mano and Transferencia Bancaria which are common payment methods here in Spain? Sébastien

Hi Steve I had to change all $Qxxx queries in includes/classes/onepage_checkout.php to make it work: From (line 80): $QcustomerEmail = tep_db_query('select customers_email_address, customers_telephone from ' . TABLE_CUSTOMERS . ' where customers_id = "' . $customer_id . '"'); to: $QcustomerEmail = tep_db_query("select customers_email_address, customers_telephone from " . TABLE_CUSTOMERS . " where customers_id = '" . $customer_id . "'"); From (line 208): $Qcheck = tep_db_query('select customers_id from ' . TABLE_CUSTOMERS . ' where customers_email_address = "' . tep_db_prepare_input($emailAddress) . '"'); to: $Qcheck = tep_db_query("select customers_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_prepare_input($emailAddress) . "'"); From (line 524) $QcInfo = tep_db_query('select * from ' . TABLE_COUNTRIES . ' where countries_id = "' . $country . '"'); to: $QcInfo = tep_db_query("select * from " . TABLE_COUNTRIES . " where countries_id = '" . $country . "'"); From (line 588): $Qaddress = tep_db_query('select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name, c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id, ab.entry_state from ' . TABLE_ADDRESS_BOOK . ' ab left join ' . TABLE_ZONES . ' z on (ab.entry_zone_id = z.zone_id) left join ' . TABLE_COUNTRIES . ' c on (ab.entry_country_id = c.countries_id) where ab.customers_id = "' . (int)$customer_id . '" and ab.address_book_id = "' . (int)$addressID . '"'); to: $Qaddress = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name, c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id, ab.entry_state from " . TABLE_ADDRESS_BOOK . " ab left join " . TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id) left join " . TABLE_COUNTRIES . " c on (ab.entry_country_id = c.countries_id) where ab.customers_id = '" . (int)$customer_id . "' and ab.address_book_id = '" . (int)$addressID . "'"); From (line 664): $Qcheck = tep_db_query('select address_book_id from ' . TABLE_ADDRESS_BOOK . ' where address_book_id = "' . $_POST['address_id'] . '" and customers_id = "' . $customer_id . '"'); to: $Qcheck = tep_db_query("select address_book_id from " . TABLE_ADDRESS_BOOK . " where address_book_id = '" . $_POST['address_id'] . "' and customers_id = '" . $customer_id . "'"); and from (line 875): $Qcustomer = tep_db_query('select customers_firstname, customers_lastname, customers_email_address from ' . TABLE_CUSTOMERS . ' where customers_id = "' . $customer_id . '"'); to: $Qcustomer = tep_db_query("select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS . " where customers_id = '" . $customer_id . "'"); Sébastien

Hi, After installing v 1.08 on an heavily modified RC2 shop (STS, PWA, Ultimate SEO...), I get the following error: 1054 - Unknown column '2' in 'where clause' select customers_email_address, customers_telephone from customers where customers_id = "2" Any idea? Thanks Sébastien

Thanks. Now it works fine. Next time I'll read instructions better...

Hi Jack, Great contrib as usual but I have a small problem with the all_pages.php accessed from categories. Everything looks correct but when I choose products beginning by A, i get a 404 Not Found error because it's looking for page http://mysite/all-products.php-by-A.html which obviously doesn't exist. Do you have any idea? Thanks, Sébastien

Hi Jack, very nice contribution but I have a problem since version 2-2.2d-3, already mentioned in this forum: when I change seo.class.php from version 2 (which works) to version 3 o 4, I get a blank page when trying to load a page of my site. I tried reseting SEO URL Cache, reseting the FWR categories menu, forcing the use of cookies but no way... Do you have any idea? Thanks, Sébastien

Surfalot, I solved my problem; it appeared to be a database problem, a conflict with table 'specials'. Sorry for my insisting so much and thank you for your job and help. Sébastien

Sorry, I suppose you reffer to the link to the .txt archive... Here it is: http://www.mendikirolak.com/CalzadoSalomon1.txt Thank you Sébastien

Hi, EP worked well but an error ocurred since I updated my host to Apache/2.2.11 and PHP/5.2.8: products are created but not the relation product to categories. I get the following message: Easy Populate 2.76g-MS2 - Default Language : espanol(1) File uploaded. Temporary filename: C:\Documents and Settings\Administrador\Configuración local\Temp\PHP\upload\php4CB.tmp User filename: CalzadoSalomon1.txt Size: 9781 | 278434 | Cosmic 4D | Bota de tr | | Cosmic 4D | Cosmic 4D | Cosmic 4D | Cosmic 4D | Bota de tr | | Cosmic 4D | Cosmic 4D | Cosmic 4D | SS09/Salom | 172.371 | 4 | 1.41 | 01/02/2009 | 02/02/2008 | | Botas | Botak | | | | | | | | | | Salomon | 4 | Salomon M | Salomon M | 46 | 6,5 UK | 6,5 UK | | | 47 | 7 UK | 7 UK | | | 48 | 7,5 UK | 7,5 UK | | | 49 | 8 UK | 8 UK | | | 50 | 8,5 UK | 8,5 UK | +0.0000 | 1 | 51 | 9 UK | 9 UK | +0.0000 | 1 | 52 | 9,5 UK | 9,5 UK | +0.0000 | 1 | 53 | 10 UK | 10 UK | +0.0000 | 1 | 54 | 10,5 UK | 10,5 UK | | | 55 | 11 UK | 11 UK | | | 56 | 11,5 UK | 11,5 UK | | | 57 | 12 UK | 12 UK | | | 58 | 12,5 UK | 12,5 UK | | | 59 | 13 UK | 13 UK | | | 60 | 13,5 UK | 13,5 UK | | | 5 | Salomon W | Salomon W | 61 | 3,5 UK | 3,5 UK | | | 62 | 4 UK | 4 UK | | | 63 | 4,5 UK | 4,5 UK | | | 64 | 5 UK | 5 UK | | | 65 | 5,5 UK | 5,5 UK | | | 66 | 6 UK | 6 UK | | | 67 | 6,5 UK | 6,5 UK | | | 68 | 7 UK | 7 UK | | | 69 | 7,5 UK | 7,5 UK | | | 70 | 8 UK | 8 UK | | | 71 | 8,5 UK | 8,5 UK | | | 72 | 9 UK | 9 UK | | | 73 | 9,5 UK | 9,5 UK | | | 74 | 10 UK | 10 UK | | | 75 | 10,5 UK | 10,5 UK | | | IVA | Active !New Product! 1054 - Unknown column '1200' in 'field list' INSERT INTO products_to_categories (products_id, categories_id) VALUES ("1200", "19") I have the following configuration: EP vers: 2.76g-MS2 osCommerce Online Merchant v2.2 RC2a OS: HTTP: Apache/2.2.11 (Win32) PHP/5.2.8 DB: MySQL 5.1.30-community PHP: 5.2.8 (Zend: 2.2.0) Temp Directory: C:/Archivos de programa/Apache Software Foundation/Apache2.2/htdocs/XXX/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: off Split files on: 300 records Model Num Size: 12 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: tab Excel safe output: false Preserve tab/cr/lf: false Category depth: 4 Enable attributes: true SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: true SPPC: false Extra Fields: false Could somebody give me a hand please? Cheers, Sébastien

Hi, EP worked well but an error ocurred since I updated my host to Apache/2.2.11 and PHP/5.2.8: products are created but not the relation product to categories. I get the following message: Easy Populate 2.76g-MS2 - Default Language : espanol(1) File uploaded. Temporary filename: C:\Documents and Settings\Administrador\Configuración local\Temp\PHP\upload\php4CB.tmp User filename: CalzadoSalomon1.txt Size: 9781 | 278434 | Cosmic 4D | Bota de tr | | Cosmic 4D | Cosmic 4D | Cosmic 4D | Cosmic 4D | Bota de tr | | Cosmic 4D | Cosmic 4D | Cosmic 4D | SS09/Salom | 172.371 | 4 | 1.41 | 01/02/2009 | 02/02/2008 | | Botas | Botak | | | | | | | | | | Salomon | 4 | Salomon M | Salomon M | 46 | 6,5 UK | 6,5 UK | | | 47 | 7 UK | 7 UK | | | 48 | 7,5 UK | 7,5 UK | | | 49 | 8 UK | 8 UK | | | 50 | 8,5 UK | 8,5 UK | +0.0000 | 1 | 51 | 9 UK | 9 UK | +0.0000 | 1 | 52 | 9,5 UK | 9,5 UK | +0.0000 | 1 | 53 | 10 UK | 10 UK | +0.0000 | 1 | 54 | 10,5 UK | 10,5 UK | | | 55 | 11 UK | 11 UK | | | 56 | 11,5 UK | 11,5 UK | | | 57 | 12 UK | 12 UK | | | 58 | 12,5 UK | 12,5 UK | | | 59 | 13 UK | 13 UK | | | 60 | 13,5 UK | 13,5 UK | | | 5 | Salomon W | Salomon W | 61 | 3,5 UK | 3,5 UK | | | 62 | 4 UK | 4 UK | | | 63 | 4,5 UK | 4,5 UK | | | 64 | 5 UK | 5 UK | | | 65 | 5,5 UK | 5,5 UK | | | 66 | 6 UK | 6 UK | | | 67 | 6,5 UK | 6,5 UK | | | 68 | 7 UK | 7 UK | | | 69 | 7,5 UK | 7,5 UK | | | 70 | 8 UK | 8 UK | | | 71 | 8,5 UK | 8,5 UK | | | 72 | 9 UK | 9 UK | | | 73 | 9,5 UK | 9,5 UK | | | 74 | 10 UK | 10 UK | | | 75 | 10,5 UK | 10,5 UK | | | IVA | Active !New Product! 1054 - Unknown column '1200' in 'field list' INSERT INTO products_to_categories (products_id, categories_id) VALUES ("1200", "19") I have the following configuration: EP vers: 2.76g-MS2 osCommerce Online Merchant v2.2 RC2a OS: HTTP: Apache/2.2.11 (Win32) PHP/5.2.8 DB: MySQL 5.1.30-community PHP: 5.2.8 (Zend: 2.2.0) Temp Directory: C:/Archivos de programa/Apache Software Foundation/Apache2.2/htdocs/XXX/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: off Split files on: 300 records Model Num Size: 12 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: tab Excel safe output: false Preserve tab/cr/lf: false Category depth: 4 Enable attributes: true SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: true SPPC: false Extra Fields: false Could somebody give me a hand please? Cheers, Sébastien

Hi Jack, very nice contrib that works like a charm but I had a little problem with W3C specifications. After looking for a while, it appears to be caused by the search box and more especifically by $catBoxWidth. W3C needs to know if the width is % or px and the solution I found is to modify the includes/boxes/search.php file and change line 28 from $catBox = ($showCatBox ? '<tr><td height="3"></td></tr><tr><td class="infoBoxContents" valign="top" colspan="3">' . BOX_ADVSEARCH_CAT . '</td></tr><tr><td class="infoBoxContents" valign="top" colspan="3">' . tep_draw_pull_down_menu('categories_id', tep_get_categories(array(array('id' => '', 'text' => BOX_ADVSEARCH_ALLCAT))), '', 'style="width:' . $catBoxWidth . ';"') . '</td></tr>' : ''); to: $catBox = ($showCatBox ? '<tr><td height="3"></td></tr><tr><td class="infoBoxContents" valign="top" colspan="3">' . BOX_ADVSEARCH_CAT . '</td></tr><tr><td class="infoBoxContents" valign="top" colspan="3">' . tep_draw_pull_down_menu('categories_id', tep_get_categories(array(array('id' => '', 'text' => BOX_ADVSEARCH_ALLCAT))), '', 'style="width:' . $catBoxWidth . 'px' . ';"') . '</td></tr>' : ''); and it seems to work. Is it correct ? Sébastien

It works. Thank you. Sébastien