Jump to content

Nala

Members
  • Content count

    40
  • Joined

  • Last visited

Everything posted by Nala

  1. Nala

    [Contribution] Ship In Cart

    Hi Folks and days2, first of all thanks to days2 for saving me some time on typing, since I am having exactly the same errors on MS 2.2 rc2a. Hours of searching made me assume that it has got something to do with either the </form> not being included or the form itself being placed in the wrong place. Whatever I tried did not work. I also tried this solution but am not sure I understood what pvallen wants to say. Me personally I suspect it could have something to do with <a href="_" onclick="return shipincart_submit(\'\');"> I made a .pdf with colored HTML and line numbers of my shopping_cart.php, shipping_estimator.php and product_shipping_estimator.pdf hoping somebody can help me. Thank you very much Nala
  2. Nala

    Automatic Stock Notification

    me again.. With the help of Ronaldo I found my error and notification now works fine. What I cannot get sorted is for the customer to get the mail in "his" language. The mail is sent out in the language that is used in admin section no matter which language the customer is using when visiting the product page with the notification option. I tried various options to force the language file in admin/categories.php but none did the job. How can I change that ? warm greetings Nala
  3. Nala

    Automatic Stock Notification

    Good evening, it does not look as if there many people out there who have got an idea what could be causing my problem. Though I am beginning to halfway understand how the basic functions in oscommerce are working I haven't got a clue how the mail system works. How come that orders and contact us work fine but the nofications don't? Where shall I start looking ? What can I test that I haven't tested up to now to narrow down the problem ? Please try to help me. I am helping my husband besides my 11 hrs a day main job and this add-on would save us a great deal of work. We are selling Hifi classics and often our customers are eagerly waiting for a certain product. This would save us having to maintain a waiting list and then notifying the customers. Thanks a lot Nala
  4. Nala

    Defect Manager Support

    Thanks for your help. I found the mistake thanks to your answer and as just punishment I openly plead guilty of absolute stupidity. As a hint for others having this problem: It helps a lot if you upload the relevant files in the right folder. E.g. not in the live shop but in the folder for your test shop. :blush: Warm regards Nala
  5. Nala

    Automatic Stock Notification

    Hello everybody, I have installed this great contribution without problems - I thought. Everything went fine, no errors on any files were found and the stock level is recognized and shown correctly. It would be perfect if only the notification would be sent out... I had these problems with a similar contribution before which is why I fear that there is something in my installation that stops this function from working. Mails on orders and contact us are working fine with either sendmail or SMTP, either HTML-mails or not. Any hint on where to look for the problem would be appreciated. Thanks in advance Nala
  6. Nala

    Defect Manager Support

    Well, looks like nobody but me has problems installing this... Everything went fine but the actual box for the defects manager does not work. For better understanding where the problems start, I have attached a screenshot for the first problem. If I ignore this and click on the link I get I have checked and doublechecked the installation instructions and my files but could not find the error. I also have checked that all files have been uploaded. Hoes anybody got a clue how to solve this ? warm regards Nala
  7. Hi Donenvy, I had the same error. In my case it did only occur when I was on the page as guest. Once logged the error did not occur. My mistake was not to allow guests to tell a friend in "My Store". best regards Nala
  8. Good evening again, I have found out one more thing that might help you. The tab "ask a question" seems to have 2 different types of behaviour depending on the category. It either loads the index page into the frame or it does not show the box at all - just the header part with the different tabs. Here is the last bit of code of the admin/includes/modules/product_tab.php Please - could somebody more experienced than me perhaps just give some hints where I shall start looking ? Thanks Nala
  9. Good evening, I am experiencing ecxactly the same problem both on my slightly modified main shop as well as on a total fresh install (still with the sample products). Can somebody help me ? hopeful greetings Nala
  10. Nala

    cDynamic Meta Tags

    Good evening, I was pleasantly surprised to read that somebody had the same errors on the same file in the same lines. I've been searching this forum for a solution but could not find any. It is not the common error with text or space after or before the <?php or ?> Can the cause perhaps be found this time ? Best Regards Nala
  11. Hi kolargol, this contrib ist exactly what you (and me) are after yet I did not get it to work :-( Just yesterday I installed it a second time after approx 1 year. I was hoping with the Online Merchant v2.2 RC1 iand/or me having learned a bit more it might work, but this stayed a hope. To me it looks like everything but sending out the e-mail works fine. Thanks to an mail-test by Harald Ponce de Leon I can be pretty sure my e-mail itself is fine. Unfortunately my skills are not good enough to figure out where the error might be. It would be interesting to see what experiences you are having with this. The nearest contrib on offer is a compromise. It is for customers to be notified when sold out products are back on stock. Best regards Nala
  12. Hi everbody, The story I am getting above error on trying to run the SQL-script on installing a new contribution. The error occured the first time on running the newest script of "shadow controller". After searching the forum I tried the older script of "shadow controller" and had no problems. Then I tried to install "column controller" and was delighted to see same error again. The general fact - osCommerce Online Merchant v2.2 RC1 release. - new database and imported customer and product tables from the old database - both errors relate to configuration_group and/or the 400 Facts on shadowe controller When running shadow_controller.sql first error says: clicking on the button to show, it says: the code of the working shadow_controller.sql: DELETE from configuration_group WHERE configuration_group_title="Shawdow Controller"; INSERT INTO configuration_group VALUES ('', 'Shadow Controller', 'Shadow Controller - configuration options', 1, 1); UPDATE configuration_group SET sort_order=last_insert_id() WHERE configuration_group_id=last_insert_id(); INSERT INTO configuration VALUES ('', 'Show Shadows', 'SHOW_SHADOWS', 'true', 'Enable Shadow Controller<br><br>true= on<br>false= off', last_insert_id(), 10, NULL, '2004-08-14 00:25:08', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),') ,('', 'Shadow Folder', 'SHADOW_FOLDER', '/shadow_controller/shadow_right_broad/', 'Enter path to the files for this shadow affect. Note that the path must end in a slash ( / ).<br>', last_insert_id(), 45, now(), now(), NULL, NULL) , ('', 'Shadow Side', 'SHADOW_SIDE', 'right_bottom', 'Choose one of the following. Note that this entry must coincide with the folder selected in Shadow Folder.<br><br> bottom<br>left<br>left_bottom<br>right<br>right_bottom<br>full<br>', last_insert_id(), 45, now(), now(), NULL, NULL) , ('', 'Shadow Height', 'SHADOW_HEIGHT', '12', '', last_insert_id(), 45, now(), now(), NULL, NULL) , ('', 'Shadow Width', 'SHADOW_WIDTH', '14', '', last_insert_id(), 45, now(), now(), NULL, NULL) , ('', 'Shadow Folder (ALT 1 )', 'SHADOW_FOLDER_ALT_1', '/shadow_controller/shadow_left/', 'Enter path to the files for this shadow affect. Note that the path must end in a slash ( / ).<br>', last_insert_id(), 45, now(), now(), NULL, NULL) , ('', 'Shadow Side (ALT 1 )', 'SHADOW_SIDE_ALT_1', 'left', 'Choose one of the following. Note that this entry must coincide with the folder selected in Shadow Folder.<br><br> bottom<br>left<br>left_bottom<br>right<br>right_bottom<br>full<br>', last_insert_id(), 45, now(), now(), NULL, NULL) , ('', 'Shadow Height (ALT 1 )', 'SHADOW_HEIGHT_ALT_1', '11', '', last_insert_id(), 45, now(), now(), NULL, NULL) , ('', 'Shadow Width (ALT 1 )', 'SHADOW_WIDTH_ALT_1', '15', '', last_insert_id(), 45, now(), now(), NULL, NULL) , ('', 'Shadow Folder (ALT 2 )', 'SHADOW_FOLDER_ALT_2', '/shadow_controller/shadow_right_broad/', 'Enter path to the files for this shadow affect. Note that the path must end in a slash ( / ).<br>', last_insert_id(), 45, now(), now(), NULL, NULL) , ('', 'Shadow Side (ALT 2 )', 'SHADOW_SIDE_ALT_2', 'bottom', 'Choose one of the following. Note that this entry must coincide with the folder selected in Shadow Folder.<br><br> bottom<br>left<br>left_bottom<br>right<br>right_bottom<br>full<br>', last_insert_id(), 45, now(), now(), NULL, NULL) , ('', 'Shadow Height (ALT 2 )', 'SHADOW_HEIGHT_ALT_2', '12', '', last_insert_id(), 45, now(), now(), NULL, NULL) , ('', 'Shadow Width (ALT 2 )', 'SHADOW_WIDTH_ALT_2', '14', '', last_insert_id(), 45, now(), now(), NULL, NULL); The code of the unloved shadow_controller.sql: DELETE from configuration_group WHERE configuration_group_title="Shawdow Controller"; INSERT INTO configuration_group VALUES (400, 'Shadow Controller', 'Shadow Controller - configuration options', 19, 1); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Show Shadows', 'SHOW_SHADOWS', 'true', 'Enable Shadow Controller<br><br>true= on<br>false= off', 400, 10, NULL, '2004-08-14 00:25:08', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Shadow Folder', 'SHADOW_FOLDER', '/shadow_controller/shadow_right_broad/', 'Enter path to the files for this shadow affect. Note that the path must end in a slash ( / ).<br>', 400, 11, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Shadow Side', 'SHADOW_SIDE', 'right_bottom', 'Choose one of the following. Note that this entry must coincide with the folder selected in Shadow Folder.<br><br> bottom<br>left<br>left_bottom<br>right<br>right_bottom<br>full<br>', 400, 12, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Shadow Height', 'SHADOW_HEIGHT', '12', '', 400, 13, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Shadow Width', 'SHADOW_WIDTH', '14', '', 400, 14, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Shadow Folder (ALT 1 )', 'SHADOW_FOLDER_ALT_1', '/shadow_controller/shadow_left/', 'Enter path to the files for this shadow affect. Note that the path must end in a slash ( / ).<br>', 400, 15, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Shadow Side (ALT 1 )', 'SHADOW_SIDE_ALT_1', 'left', 'Choose one of the following. Note that this entry must coincide with the folder selected in Shadow Folder.<br><br> bottom<br>left<br>left_bottom<br>right<br>right_bottom<br>full<br>', 400, 16, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Shadow Height (ALT 1 )', 'SHADOW_HEIGHT_ALT_1', '11', '', 400, 17, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Shadow Width (ALT 1 )', 'SHADOW_WIDTH_ALT_1', '15', '', 400, 18, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Shadow Folder (ALT 2 )', 'SHADOW_FOLDER_ALT_2', '/shadow_controller/shadow_right_broad/', 'Enter path to the files for this shadow affect. Note that the path must end in a slash ( / ).<br>', 400, 19, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Shadow Side (ALT 2 )', 'SHADOW_SIDE_ALT_2', 'bottom', 'Choose one of the following. Note that this entry must coincide with the folder selected in Shadow Folder.<br><br> bottom<br>left<br>left_bottom<br>right<br>right_bottom<br>full<br>', 400, 20, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Shadow Height (ALT 2 )', 'SHADOW_HEIGHT_ALT_2', '12', '', 400, 20, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Shadow Width (ALT 2 )', 'SHADOW_WIDTH_ALT_2', '14', '', 400, 21, now(), now(), NULL, NULL); Facts on "column controller" first error says: clicking on button to show I get: Now I need help from people to whom the exact cause of the error is more obvious than it is to me :-) Thanks for your help Nala
  13. Now a real, true thanks to you. It was a hard fight between the database and me but we finally agreed to a compromise and I have learned a bit more ;-)
  14. Thanks Jack, or perhaps not "thanks Jack" ? ;-) Your answer helped me to see that for some reason all or many tables from the old database are also in the new database though I haven't got a clue how this could pssibly have happened... I do not want all the old crap in my new database, so how to go about this best ? If I was sure I knew what I am doing, I would create a new database again, run oscommerce.sql and try again importing the tables for products and customers. Afterwards I would change the database name in configure.php and admin/configure.php. What would you do ? Thanks Nala
  15. Error found :-)) looks like it was too difficult for me to upload the files into the correct directory :rolleyes:
  16. Hi everybody, Being from Germany finding this contribution was answering my prayers. Unfortunaly I get following error in my admin area on order total in the german section as well as in the actual shop when on language german on "checkout_payment.php": I do not get the error in the english part. On language english evertyhing works fine, on german it doesn't. On top of that the text on "checkout_confirmation.php" is the one defined in the german "ot_subtotal_ex.php". I have a feeling what the problem could be, but not enough knowledge to fix it... looking forward to your help Nala
  17. Nala

    [CONTRIBUTION] CCGV (trad)

    Hi, it's the german nuisance again. ;) I finally stroke on the brilliant idea to search the contributions for a solution to my problem and found "Netto-Betrag (net amount)". Yet does this contribution of course not consider CCGV (trad).... According to my tax consultant I can leave my sums the way they are now, but this is not the way it shoud really work. Via the german Support Forum I then found out that on 22.03.06 "tax fix 1.1" (for the coupon part only) was uploaded as the contribution simply wouldn't work for the german tax system. Since by the looks of it nearly the whole ot_coupon.php needed to be changed there seem to be major differences between the german tax system and others. :rolleyes: Why do things have to be that complicated ? regards from Nala with already square eyes
  18. Nala

    [CONTRIBUTION] CCGV (trad)

    And me again, I just talked to my tax consultant and if we now understood each other correctly I can gladly ask you to ignore my problem/request :-)) Nevertheless would I be curious to read whether I wanted something that CCGV (trad) is not designed for. happy smiling regards Nala
  19. Nala

    [CONTRIBUTION] CCGV (trad)

    ok. that answer was clear :-) Let me just clarify that I do want something this contributition is not made for. The amount of subtotal incl. tax is fine. It looks like the tax is being based on the right amount of ? 90,-- (? 100,-- net - ? 10,-- net gift voucher) yet instead of 10% Tax (or 16%) only 8,.. % Tax is included in the total. If it needs to be programmed to work that way then I would like to ask you to quote me for doing this. Asking anybody else does not really make sense as too many cooks spoil the broth. greetings from Northern Germany Nala
  20. Nala

    [CONTRIBUTION] CCGV (trad)

    Hi again Vger, I don't really know how to interpret your silentness. Not a clue what could cause my problem ? busy ? Fed up with tax queries ? I really do want to get this fantastic contribution to work in our online shop which is why I would like to make a suggestion to you. You help me getting this problem sorted (which btw does not appear if I work without re-calculation) and I thank you with translating your contributions into german if you haven't got somebody to do that for you. That way I can at least give a bit back to you and the community. Looking forward to your response. Nala
  21. Nala

    [CONTRIBUTION] CCGV (trad)

    You can most likely help yourself by first getting a programm like ExamDiff to compare files and then looking at the dates of the files in the contribution. E.g. the update Vger made on 28.08. shows files of or around that date and files which may have an older date like january this year. If for example you installed your contrib in march then you have all the answers you need (I reckon...).
  22. Nala

    [CONTRIBUTION] CCGV (trad)

    I admit(ted) I do not quite understand the point of "include tax" but with trial and error that should not really matter. If I set that to "false" I get 16 % is the Tax in Germany, which is why I put that as text though for testing purpose I did set the amount to 10%. Still confused greetings Nala
  23. Nala

    [CONTRIBUTION] CCGV (trad)

    Hi Vger, I fear I do have the same problem as Mlu ! I have now been spending more than 2 whole days trying to figure out whether I am too dumb to understand your instructions or whether there is a problem with CCGV (trad). Though I must admit I do not understand how to handle "include tax in calculation". If I am too dumb, I have to live with that though it would hit me hard. Vger, I now would like to make you referee for Nala's brain v. CCGV (trad). German tax laws require the net amount of the gift voucher to be deducted from the net amount of the purchased product before tax is being added. To help me understand how tax is being calculated I did set my tax to 10%, the net value of the purchased product to ? 100 and the net value of the Gift voucher to ? 10. I do not use Discount Coupons and left the settings as they were except for the changes in the sort order as per the User Guide for re-calculation of tax for Gift Vouchers. I would expect a tax of ? 9,00 and a total of ? 99,00 yet what I get is: I am at my wits' end.... exhausted greetings Nala
  24. Um...well.. I don't really believe what I just saw when trying to figure out what caused the newest error.. How shall I put it ? I go for flat out ! The last error I reported disappeared without me doing anything on it ! The only thing that could have probably changed in between is my host finally having followed my request switching safe mode off. Anyway thanks a lot for your help !
  25. Good morning everybody, I cannot figure out why I have following problem. After installing "product tabs", I get below error: The relevant part of my general.php: function tep_get_orders_status() { global $languages_id; $orders_status_array = array(); $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int)$languages_id . "' order by orders_status_id"); while ($orders_status = tep_db_fetch_array($orders_status_query)) { $orders_status_array[] = array('id' => $orders_status['orders_status_id'], 'text' => $orders_status['orders_status_name']); } return $orders_status_array; } function tep_get_products_name($product_id, $language_id = 0) { global $languages_id; if ($language_id == 0) $language_id = $languages_id; $product_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'"); $product = tep_db_fetch_array($product_query); return $product['products_name']; } function tep_get_products_description($product_id, $language_id) { $product_query = tep_db_query("select products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'"); $product = tep_db_fetch_array($product_query); return $product['products_description']; } // begin added product tabs return $product['products_spec']; } function tep_get_products_musthave($product_id, $language_id) { $product_query = tep_db_query("select products_musthave from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'"); $product = tep_db_fetch_array($product_query); return $product['products_musthave']; } function tep_get_products_extraimage($product_id, $language_id) { $product_query = tep_db_query("select products_extraimage from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'"); $product = tep_db_fetch_array($product_query); return $product['products_extraimage']; } function tep_get_products_manual($product_id, $language_id) { $product_query = tep_db_query("select products_manual from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'"); $product = tep_db_fetch_array($product_query); return $product['products_manual']; } function tep_get_products_extra1($product_id, $language_id) { $product_query = tep_db_query("select products_extra1 from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'"); $product = tep_db_fetch_array($product_query); return $product['products_extra1']; } function tep_get_products_moreinfo($product_id, $language_id) { $product_query = tep_db_query("select products_moreinfo from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'"); $product = tep_db_fetch_array($product_query); return $product['products_moreinfo']; } function tep_get_products_url($product_id, $language_id) { $product_query = tep_db_query("select products_url from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'"); $product = tep_db_fetch_array($product_query); return $product['products_url']; } // end added product tabs function tep_get_products_url($product_id, $language_id) { $product_query = tep_db_query("select products_url from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'"); $product = tep_db_fetch_array($product_query); return $product['products_url']; } //// // Return the manufacturers URL in the needed language // TABLES: manufacturers_info function tep_get_manufacturer_url($manufacturer_id, $language_id) { $manufacturer_query = tep_db_query("select manufacturers_url from " . TABLE_MANUFACTURERS_INFO . " where manufacturers_id = '" . (int)$manufacturer_id . "' and languages_id = '" . (int)$language_id . "'"); $manufacturer = tep_db_fetch_array($manufacturer_query); return $manufacturer['manufacturers_url']; } bracket after return $product['products_spec']; removed, problem solved ? Yes and no ! I then get access to my admin section yet when I want to edit my product details it shows - not surprisingly even for my poor knowlege of PHP - following error: <!--begin added for product tabs--> <tr> <td class="main" valign="top"><?php if ($i == 0) echo TEXT_PRODUCTS_SPEC; ?></td> <td><table border="0" cellspacing="0" cellpadding="0"> <tr> <td class="main" valign="top"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?> </td> <td class="main"><?php echo tep_draw_textarea_field('products_spec[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (isset($products_spec[$languages[$i]['id']]) ? $products_spec[$languages[$i]['id']] : tep_get_products_spec($pInfo->products_id, $languages[$i]['id']))); ?></td> </tr> </table></td> Now the big question is where the gremlins have been getting into the works. I can't answer it and hope you can. thanks for helping :-) Nala
×