Jump to content


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
  • Gender
  • Location
    Málaga Spain
  1. Amigoo

    Daily Specials

    Yes, you are right. I found the bug. I bought an addon specially fixed for my needs. This addon use customer groups to show/hide products. Sorry to bother you. Cheers Amigoo
  2. Amigoo

    Daily Specials

    Hi Jack, The addon download includes a directory "Database" where I found the daily_specials_install.php. File is last modified on 2014-06-15. There is anywhere a newer one? Amigoo
  3. Amigoo

    Daily Specials

    Hi there, Need some help please. My OSC: osCommerce 2.3.4 on xampp with MySQL 5.5.32 + PHP 5.5.6 I have copied the daily_specials_install.php into my root shop directory. When I execute the file, I get this error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where customers_group_id in(1,1)' at line 24 CREATE TABLE daily_specials ( unique_id int NOT NULL auto_increment, special_name varchar (64) DEFAULT '' NOT NULL, page_type TINYINT (4) DEFAULT '0' NOT NULL, page_text TEXT NOT NULL default '', popup_text TEXT NOT NULL default '', alt_text varchar (128) NOT NULL default '', image varchar(64) NOT NULL default '', categories text NOT NULL default '', pages text NOT NULL default '', products_list text NOT NULL default '', condition1 varchar(32) NOT NULL default '0', condition2 varchar(32) NOT NULL default '0', condition3 varchar(32) NOT NULL default '0', coupon_amount varchar(16) NOT NULL default '', date_start datetime NOT NULL, date_stop datetime NOT NULL, recur_days varchar (3) DEFAULT '0' NOT NULL, recur_mode TINYINT (1) DEFAULT '0' NOT NULL, test_mode TINYINT (1) DEFAULT '0' NOT NULL, use_css TINYINT (1) DEFAULT '0' NOT NULL, language_id int(11) NOT NULL default '1', index idx_unique_id (unique_id) ) where customers_group_id in(1,1) [TEP STOP] Can anyone help? Thanks Amigoo
  4. Amigoo

    Age Restricted Category v2.1

    @@osc_david I have the same problem as DesertCoder. I've installed the module but I can not find out how it works. There is no link at the Admin to insert the restricted categories. Any help would be great Cheers Amigoo
  5. Amigoo

    Simply Hide Products (SHP)

    Puhh OSC shows more error messages At first level I cannot insert a category nor a product A click on new product opens the product page at half with this error: Fatal error: Call to undefined function tep_print_shp_menu() in D:\xampp\..\catalog\admin\categories.php on line 642 The code on this line is: <?php for ($i=0, $n=sizeof($languages); $i<$n; $i++) { ?> <tr> <td class="main" valign="top"><?php if ($i == 0) echo TEXT_PRODUCTS_DESCRIPTION; ?></td> <td><table border="0" cellspacing="0" cellpadding="0"> <tr> <td class="main" valign="top"><?php echo tep_image(tep_catalog_href_link(DIR_WS_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], '', 'SSL'), $languages[$i]['name']); ?> </td> <td class="main"><?php echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (empty($pInfo->products_id) ? '' : tep_get_products_description($pInfo->products_id, $languages[$i]['id']))); ?></td> </tr> </table></td> </tr> <?php } Line 641 //START SHP Line 642 echo tep_print_shp_menu('article'); Line 643 //END SHP ?> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_QUANTITY; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_quantity', $pInfo->products_quantity); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_MODEL; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_model', $pInfo->products_model); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main" valign="top"><?php echo TEXT_PRODUCTS_IMAGE; ?></td> <td class="main" style="padding-left: 30px;"> <div><?php echo '<strong>' . TEXT_PRODUCTS_MAIN_IMAGE . ' <small>(' . SMALL_IMAGE_WIDTH . ' x ' . SMALL_IMAGE_HEIGHT . 'px)</small></strong><br />' . (tep_not_null($pInfo->products_image) ? '<a href="' . DIR_WS_CATALOG_IMAGES . $pInfo->products_image . '" target="_blank">' . $pInfo->products_image . '</a> | ' : '') . tep_draw_file_field('products_image'); ?></div> <ul id="piList"> A clic on new category shows only this error: Fatal error: Call to undefined function tep_print_shp_menu() in D:\xampp\..\catalog\admin\categories.php on line 1012 Line 1008 $contents[] = array('text' => '<br />' . TEXT_CATEGORIES_NAME . $category_inputs_string); Line 1009 $contents[] = array('text' => '<br />' . TEXT_CATEGORIES_IMAGE . '<br />' . tep_draw_file_field('categories_image')); Line 1010 $contents[] = array('text' => '<br />' . TEXT_SORT_ORDER . '<br />' . tep_draw_input_field('sort_order', '', 'size="2"')); Line 1011 //START SHP Line 1012 $contents[] = array('text' => tep_print_shp_menu('category')); Line 1013 //END SHP Line 1014 $contents[] = array('align' => 'center', 'text' => '<br />' . tep_draw_button(IMAGE_SAVE, 'disk', null, 'primary') . tep_draw_button(IMAGE_CANCEL, 'close', tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath))); Line 1015 break; Line 1016 case 'edit_category': Line 1017 $heading[] = array('text' => '<strong>' . TEXT_INFO_HEADING_EDIT_CATEGORY . '</strong>'); BTW: This mentioned code while (list($key, $value) = each($HTTP_POST_VARS)) { if (!is_array($HTTP_POST_VARS[$key])) { echo tep_draw_hidden_field($key, htmlspecialchars(stripslashes($value))); } could not be added because I did not find any solution. I'll unmount this pretty addon, because I'm not able to fix the errors. :sweating:
  6. Amigoo

    Simply Hide Products (SHP)

    I have some trouble to update SHP with a Deprecated error message. Deprecated: mysql_real_escape_string(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in D:\xampp....... The responsible code for this error message is: $shp = " where ".$prefix."products_id not in(".mysql_real_escape_string($_SESSION['hidden_products']).")"; In the PHP documentation I can find this update to change the code into PHP 5.5 conform version string mysqli::real_escape_string ( string $escapestr ) Anybody can help please?
  7. Amigoo

    Simply Hide Products (SHP)

    Hi all, I'm preparing a OSC shop and I have the same problem as @@boltje. Mentioned code while (list($key, $value) = each($HTTP_POST_VARS)) { if (!is_array($HTTP_POST_VARS[$key])) { echo tep_draw_hidden_field($key, htmlspecialchars(stripslashes($value))); } is not included in \admin\categories.php Anybody can help? Thanks Ernesto
  8. Amigoo

    [Addon} Theme Switcher

    Hi Jim, I have made your fixes regarding the error message. Now I have the next similar error. MySQL 5.5.32 PHP 5.5.6 All checks are green! Warning: Illegal string offset 'id' in D:\xampp\htdocs\shop\includes\modules\header_tags\ht_theme_switcher.php on line 188 Thanks in advance for help. Cheers Amigoo
  9. Amigoo

    [Addon} Theme Switcher

    Sorry wrong thread
  10. Amigoo

    [Contribution] CKEditor [wyswyg]

    @nedragdnuos This seems to be a problem of Ultrapics with Lightbox because I have made a test installation into a fresh osc 22rc2a of "Simple Multiple Images (Unlimited) with Fancy Popups V1.3.5" http://addons.oscommerce.com/info/7008 and oscThumbs http://addons.oscommerce.com/info/5491 and the error message is like yours Warning: trim() expects parameter 1 to be string, array given in ..catalog\admin\includes\functions\general.php on line 35 and appear when I click onto the back button at the preview page. I'm still searching the responsible code :-( If you have solved the problem in the meanwhile it would be great to post the code. Thanks
  11. The addon is running well on my server. Only a similar problem I have when I make a copy from a product. I also have some additional fields in products. 1136 - Column count doesn't match value count at row 1 insert into products (products_quantity, products_model, products_lang, products_os, products_release, products_region, products_amount, products_image, products_image_array, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('10', 'DVD-UNSG2', '', 'Windows', '', '', '', '', '101/101-001_01.jpg', 'a:3:{i:0;s:18:\"101/101-001_02.jpg\";i:1;s:18:\"101/101-001_03.jpg\";i:2;s:18:\"101/101-001_04.jpg\";}', '29.9900', now(), '', '7.00', '0', '0', '3') [TEP STOP] Any opinion from where comes this problem?
  12. Finally I found the thread: Skip preview
  13. I think to remember that I have read something about - what I have to change at the code when a product description disappear. Anybody knows where it is? I'm searching now more than 3h without luck. :-( Thanks for help.
  14. Hello Sam, 3 days ago I asked you about a solution for this error message. Warning: trim() expects parameter 1 to be string, array given in D:\xampp\htdocs\php530_22rc2a\catalog\admin\includes\functions\general.php on line 35 It appear when I go back from Product Preview Page. Until now I could not find the problem. I think it occur because I'm running on my xampp PHP 5.3 .I have changed all deprecated functions on my 22rc2a. On my test server with PHP 5.2.8 I do not have any problems. All is working well. e.g. I have also changed this deprecated ereg_replace() function at admin/categories.php: <td class="main"><?php echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (isset($products_description[$languages[$i]['id']]) ? ereg_replace('& ', '& ', trim(stripslashes($products_description[$languages[$i]['id']]))) : tep_get_products_description($pInfo->products_id, $languages[$i]['id']))); ?></td> into this: <td class="main"><?php echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (isset($products_description[$languages[$i]['id']]) ? stripslashes($products_description[$languages[$i]['id']]) : tep_get_products_description($pInfo->products_id, $languages[$i]['id']))); ?></td> Hope this was correct. I like these addons :-). Very good work but I think now is time to check these add ons at a clean 22rc2a with PHP5.3 .In march I have more time. I'll try it than.
  15. Amigoo


    Hello all, I'm reading this thread through all 62 pages since 2 days now and I found many information about browser problems. I have installed "Cool-Menu" and it seems that the contrib works with IE6 but not with FireFox and also not with Opera. This are the pictures I get after the installation of this contrib. Picture from FIREFOX 3.0.5 FireFox Picture Picture from OPERA 9.63 Opera Picture 2 pictures from Internet Explorer InternetExplorer Picture 1 InternetExplorer Picture 2 (I have osC 2.2 MS2) The problem is that I can copy and past, but I'm not a professional programmer to fix my problem. Can anybody tell me where I have to search to solve the problem? I can not post a link because it is a local installation. Thanks for any hint. Amigoo