Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

peteruittilburg

Pioneers
  • Posts

    42
  • Joined

  • Last visited

About peteruittilburg

  • Birthday 08/06/1965

Profile Information

peteruittilburg's Achievements

  1. What you need is called a chained select menu. Google for it, and you will find many links with script you can adapt easily to let it do the job. Some usable links: http://www.dynamicdrive.com/dynamicindex1/chainedmenu/index.htm http://www.dhtmlgoodies.com/index.html?whichScript=ajax_chained_select http://www.sitepoint.com/forums/showthread.php?t=619933
  2. Good day to you all. I seems that I found a small bug in this refreshing ultimate SEO contribution. On the moment, I am implementing it into a shop with a prefix before the database tables. As long as every query is using the database tables as defined in database_tables.php, it is no problem. I found an entry that is not using the defines, but using a hard code table call. In module/ultimate_seo_urls5/modules/Usu_Categories.php, line 37 (in function __construct), change: $this->base_query = "SELECT cd.categories_name AS cName, cd2.categories_name AS pName FROM " . TABLE_CATEGORIES . " c LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd2 ON c.parent_id = cd2.categories_id AND c.parent_id = cd2.categories_id AND cd2.language_id = :languages_id, categories_description cd WHERE c.categories_id = cd.categories_id AND c.categories_id = :cid AND cd.language_id = :languages_id"; to $this->base_query = "SELECT cd.categories_name AS cName, cd2.categories_name AS pName FROM " . TABLE_CATEGORIES . " c LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd2 ON c.parent_id = cd2.categories_id AND c.parent_id = cd2.categories_id AND cd2.language_id = :languages_id, " . TABLE_CATEGORIES_DESCRIPTION . " cd WHERE c.categories_id = cd.categories_id AND c.categories_id = :cid AND cd.language_id = :languages_id";
  3. I have found a nice bug in ot_discount_coupon_codes_3_33 (21 Mar 2009). This is what's happening. In the table discount_coupons_to_customers, all customers are stored that are NOT allowed to use the coupon. So to determine who are allowed, a complete list of customers is retrieved from the database (table customers), and subtracted with the customers who aren’t allowed to use the coupon. Remaining, customers who are allowed. But if the total customer list is growing, the list of people who are not allowed should also grow. This is not happening, so all new customers are added to the allowed list. I guess this is not a problem, because new customers don’t know the coupon code, and if the coupon is max used, it will be disabled. But, here is the catch: if a coupon can be used more then once, a “smart” customer can create a new account and use the coupon again. The watertight solution: If a new account is created, add it’s customers_id to every coupon_id in the table discount_coupons_to_customers. I have tried it and it looks like this covers it all.
  4. @ Edrack The part in the error message saying: MAX_ROW_LISTS_OPTIONS means that MAX_ROW_LISTS_OPTIONS is not defined. This is standard osCommerce, so this is weird. Look in the language folder from the language your admin is using, and open product_attributes.php. You should find the line: define('MAX_ROW_LISTS_OPTIONS', 10); If not, add it. As a test, you can add this line in the file admin/product_attributes.php, right under the first <?. Does your shop have more language issues? Success
  5. Hi there, I found a small bug in the latest version (15 0kt 2008) of the fine contri. The problem that occurred was as follows: On the bottom of the page, the product_attributes are shown. On top of this table, you can go a page forwards or backwards by pushing the arrows. Also a pulldown is shown to go directly to a product_attribute page. The arrows worked fine. Using the pull down always results in showing page 1, and a new and empty product_attribute row was added to the list. The problem is caused by a double <form> in the code. One is above the line that creates the pulldown (line 733), the other is under it (line746). Simple remove line 733 does the trick. Everything looks okay, but I am not sure it will always be okay. Line 733 and line 746 both call the same page and action, but sent different variables with it. So what I did was a working trick: delete 733, keep 746. But also working is replace 746 with 733. Both versions “seem” to work. Because I am not sure if everything really is going oke, I would like to ask to somebody who knows more of this file what line 746 should be. Of course, in the above mentioned statements, the tables are not touched.
  6. Hello, I am using HTC for some time now, and it is really working great, but I have a question. HTC is used in a shop with a lot of different categories. The products have product names that do not refer to the categories. Because of the large number of categories, it is not wise to ad them all to the keywords. Therefore I want HTC to put the category name in front of the keywords on the product information pages. Is this already possible, or easily to adapt?
  7. in admin/admin_notes.php Line 278 $sInfo_array = array_merge($admin_quer,''); Change it to: $sInfo_array = array_merge($admin_quer);
  8. in admin/admin_notes.php Line 278 $sInfo_array = array_merge($admin_quer,''); Change it to: $sInfo_array = array_merge($admin_quer);
  9. Hi Jack, Please see my posting 508. It is an PHP4 versus PHP4 problem
  10. Got it! The first error was: Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/sites/site81/web/admin/links.php on line 733 Line 733 is: $lInfo_array = array_merge($links, $category); By accident, I found the following in the installation file of the contri ?extra pages?: Because I am using PHP5, I changed line 733 into: $lInfo_array = array_merge($links, (array)$category); It helped, now it seems to work, but I haven?t tried everything yet. I saw that there are still some more array_merge instructions in the files. That is why I am changing my question now to: For stability, is it wise to change all lines with: array_merge($A, $B); Into: array_merge((array)$A, (array)$B);? Regards, Peter
  11. Hello, I couldn?t edit my topic, but I have some extra info. If I look into links_setup.php, it seems that there is a protection to run setup if the tables are already there. I can run the setup over and over, without any warning that the tables exist, In admin > configuration, the item Links occurs as many times as I run the setup, but the item admin>links manager will not multiply. The link that was submitted is deleted, and the error in the link manager is disappeared. As soon as I submit a link in the shop, the error in the link manager will occur again. Does this ring any bells? Best regards, Peter
  12. Hello, I installed the latest version, but having some problems like the ones a few post back. Installation and database adaptation gave no problem. All menus work fine as long as no links where submitted. Problems in admin occurred when a link was submitted. In de admin section, the next error occurs: Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/sites/site81/web/admin/links.php on line 235 Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/sites/site81/web/admin/links.php on line 235 Warning: reset() [function.reset]: Passed variable is not an array or object in /home/sites/site81/web/admin/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /home/sites/site81/web/admin/includes/classes/object_info.php on line 18 Also sometimes the errors are: Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/sites/site81/web/adminshop/links.php on line 733 Warning: reset() [function.reset]: Passed variable is not an array or object in /home/sites/site81/web/adminshop/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /home/sites/site81/web/adminshop/includes/classes/object_info.php on line 18 The first error refers to line 235 in admin/links.php: $lInfo_array = array_merge($links, $category); My knowledge of PHP is not that great, but I think it means that arrays $links and $category don?t exist. Looking into this file, I can?t find something like: $links = array(); $category = array(); So what is happening here? Regards, Peter
  13. Is there a cleaver way of finding them? What are the terms on why the contri thinks it is something for the sitemap
  14. Hi you all, I have installed version 1.6, and having a slight problem The information box items looks good I think ? Information o Verzenden & Retourneren o Privacy verklaring o Algemene Voorwaarden o Neem contact op o Site Map o Maten tabel The word information has no link, but looking to the properties, it is pointing to dynamic_sitemap.php. The other 6 links work correct. But I also have in my list: ? Algemene Voorwaarden " href="http://localhost/catalog/conditions.php?osCsid=bef70ecd622c7a1552bd1cae744d7529"> Algemene Voorwaarden ? Privacy Verklaring " href="http://localhost/catalog/privacy.php?osCsid=bef70ecd622c7a1552bd1cae744d7529"> Privacy Verklaring ? Verzenden & Retourneren " href="http://localhost/catalog/shipping.php?osCsid=bef70ecd622c7a1552bd1cae744d7529"> Verzenden & Retourneren ? Maten tabel " href="http://localhost/catalog/sizes.php?osCsid=bef70ecd622c7a1552bd1cae744d7529"> Maten tabel Those items have no link attached, and I think the don?t belong there. All those items belong to the already mentioned information bos What is happing here? Best regards, Peter
  15. Hello, It is a bit quiet in the Dutch forum, so i try my luck over here. I?m having problems with the cattree_v1.0 contri. Looking in the forums isn?t giving any solution. First, what do I want. The category menu of the demo site looks a bit silly. I like the way it works, but not how it looks. It just needs some small changes. The right sited arrow needs to be a dot ore something else in gif format, but on the left site of the category. It must look like Windows explorer, but I want to change the yellow folders in some other *.gif or *.JPG. What I realy like of the osC menu is that the tree stays visible. For al this, I want to use the cattree_v1.0 contri. I did the following: Exchange the old categories.php for the new one in catalog/include/boxes And I placed the folder javascript into the catalog folder This al can be found in readme.txt When I open my site (firefox or IE), the Category box is containing 1 line and no text. Also no errors. I opened the site with firefox and tried the javascript consol. It gave no errors. OsC is running local with XAMPP, but that can not be the problem (I think). Further more, Java is running on IE en Firefox. Someone suggested me to use Coolmenu, but this is not the kind of menu that I want. With this conti, (as far as I know), not the complete tree is visible. The deeper levels are not visible if one is selected. Who has some advice on this sunny and dry afternoon. Regards, Peter
×
×
  • Create New...