Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Andreas2003

Pioneers
  • Posts

    315
  • Joined

  • Last visited

Everything posted by Andreas2003

  1. Thanks, the code is not visible, but copy paste to an editor brings light into. And it works :-) Regards Andreas
  2. Hi there, got a problem. I first got this contribution working, Product Attributes Sort Order v1.0. Was no problem. Then I tried to implement this one too, Products attribute enhancement. The problem was, that both contribs are modifying the products_attributes.php. so I tried to merge them. To be honest, I dont be able to write in PHP, so it was clear that I got a parsing error. Here I have posted my merged code, with an error in line, where "else // PCA" is stated and I dont know, how to correct it. Please be so kind and help me out : // Next if ($attribute_page != $num_pages) { echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'attribute_page=' . $next_attribute_page) . '"> >> </a>'; else // PCA echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'attribute_page=1') . '"> Tout afficher </a>'; } ?> Many many Thanks in advance, Kinde regards Andreas
  3. Hi there, I need a recommendation for a Ticket System / Help Desk, which is not to hard to get it working. I got a look at OSC-SupportTicket System and at HelpDesk for osC. HelpDesk seems to be more professional due to email integration, but harder to get it working. I dont know much about OSC SupportTicket System, but it seems to be installed very easily. Can you give me a recommendation please about these two systems or about another one, and also some pro's and con's if you know some ? Thanks in advance, Regards Andreas
  4. Hi there, I've got a problem to get this nice contrib to work. I placed all files in /catalog/thumbs. I edited the code in /includes/functions/html_out.php so that all images are requested with the .thumb ending. But now the rewrite rule in my htaccess seems to be the problem. I already have a htaccess file, which makes my testsystem password-protected. The content: AuthUserFile /srv/www/test/.htpasswd AuthType Basic AuthName "am" require valid-user RewriteEngine on RewriteRule ^(.*)\.thumb_big /thumbs/thumb_big.php?%{REQUEST_FILENAME} RewriteRule ^(.*)\.thumb_medium /thumbs/thumb_medium.php?%{REQUEST_FILENAME} RewriteRule ^(.*)\.thumb /thumbs/thumb.php?%{REQUEST_FILENAME} But then I only get a 500 - Internal server error. Please be so kind and give me some further advice to get this contrib working. Thanks in advance, Regards Andreas
  5. Hi there, when I want to download a Complete tab-delimited .txt file to edit, I'm running into a timeout error. Following message: Fatal error: Maximum execution time of 30 seconds exceeded in /srv/www-extern/shop/htdocs/admin/easypopulate.php on line 467 And when I try to download Model/Attributes tab-delimited .txt file, I get following message: Fatal error: Maximum execution time of 30 seconds exceeded in /srv/www-extern/shop/htdocs/admin/includes/classes/logger.php on line 49 Can anyone tell me please, what to do, to get it done correctly ? Thanks in advance, Regards Andreas
  6. Hi there, has anyone of you tried out the EasyPopulate Update, that comes with the UltraPics contribution here ? I installed all as instructed, but the EP Update from aliadoleo is not working correctly. I figured out that the import function is the problem. In the SQL string it makes " instead of ' as cell limitation. Here is the part of the original code, which is (IMHO) not working (starting in line 1789): manufacturers_id) VALUES ( '$v_products_image'," . $v_products_image_med . '", "' . $v_products_image_lrg . '", "' . $v_products_image_sm_1 . '", "' . $v_products_image_xl_1 . '", "' . $v_products_image_sm_2 . '", "' . $v_products_image_xl_2 . '", "' . $v_products_image_sm_3 . '", "' . $v_products_image_xl_3 . '", "' . $v_products_image_sm_4 . '", "' . $v_products_image_xl_4 . '", "' . $v_products_image_sm_5 . '", "' . $v_products_image_xl_5 . '", "' . $v_products_image_sm_6 . '", "' . $v_products_image_xl_6 . '", "'; A friend and I changed this to that: VALUES ( '$v_products_image', '$v_products_image_med', '$v_products_image_lrg', '$v_products_image_sm_1', '$v_products_image_xl_1', '$v_products_image_sm_2', '$v_products_image_xl_2', '$v_products_image_sm_3', '$v_products_image_xl_3', '$v_products_image_sm_4', '$v_products_image_xl_4', '$v_products_image_sm_5', '$v_products_image_xl_5', '$v_products_image_sm_6', '$v_products_image_xl_6',"; With this change, the products are imported correctly, but now I'm facing the fact, that EP is setting the category not correctly, with every import EP is creating a new category number, but which is not shown up. This happens, when the category is already there, or even if not. Both, my friend and I, are not that experts, that we understand the complete code and what else errors are hiding there. I emailed aliadoleo yesterday, but as today, he didn't answered yet. So, now my question is, if someone of you has the same problem, or even better, has also a solution to my problem ? Or perhaps someone of you could kindly review the code there and tell me what else error are in there. Many Thanks in advance, Regards Andreas
  7. Hi there, I've got a big problem with my shop, because EP is not importing my test-import-file. I was running EP version 2.62 (formely), in the meantime installed UltraPics (dont know the exact version :( OsCommerce is version MS 2.2, php-version is 4.3.4. With UltraPics, there was coming another version of the both EP-files. Then after installing UltraPics I saw, that I dont have any attributes exported with EP. As I figured out, the two EP-files coming with UltraPics were for an old version of EP, so I downloaded the newest version of EP v2,76b. I already have some articles in my system, so I exported them to have the correct format in the CSV file. This I took and edited it for testing just with one product. But during import, I only get the error message: File uploaded. Temporary filename: /tmp/phptXJamC User filename: Testeinspielung2.txt Size: 1718 | 20999 | no_pic_yet | Test | Test | | Test | Test | | Test | Test | | | | no_pic_yet | | | | | | | | | | | | 581.08 | 10 | 2005-12-01 | 2005-12-01 | 10 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Testherste | Test | Test | | Taxable Go | Active !New Product! 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 'no_pic_yet.jpg", "", "", "", "", "", "", "", "", "", "", "", " INSERT INTO products ( products_image, products_image_med, products_image_lrg, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_image_sm_3, products_image_xl_3, products_image_sm_4, products_image_xl_4, products_image_sm_5, products_image_xl_5, products_image_sm_6, products_image_xl_6, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( 'no_pic_yet.jpg',", "", "no_pic_yet.jpg", "", "", "", "", "", "", "", "", "", "", "", " '20999', '500.931', '1', CURRENT_TIMESTAMP, "2005-12-01", "2005-12-01", '1', '10', '10', '23') [TEP STOP] Here is my test import CSV file: v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_name_2 v_products_description_2 v_products_url_2 v_products_name_5 v_products_description_5 v_products_url_5 v_products_image_med v_products_image_lrg v_products_image_sm_1 v_products_image_xl_1 v_products_subimage2 v_products_image_xl_2 v_products_image_sm_3 v_products_image_xl_3 v_products_image_sm_4 v_products_image_xl_4 v_products_image_sm_5 v_products_image_xl_5 v_products_image_sm_6 v_products_image_xl_6 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_options_name_1_2 v_attribute_options_name_1_5 v_attribute_values_id_1_1 v_attribute_values_name_1_1_1 v_attribute_values_name_1_1_2 v_attribute_values_name_1_1_5 v_attribute_values_price_1_1 v_attribute_values_id_1_2 v_attribute_values_name_1_2_1 v_attribute_values_name_1_2_2 v_attribute_values_name_1_2_5 v_attribute_values_price_1_2 v_attribute_options_id_2 v_attribute_options_name_2_1 v_attribute_options_name_2_2 v_attribute_options_name_2_5 v_attribute_values_id_2_1 v_attribute_values_name_2_1_1 v_attribute_values_name_2_1_2 v_attribute_values_name_2_1_5 v_attribute_values_price_2_1 v_attribute_values_id_2_2 v_attribute_values_name_2_2_1 v_attribute_values_name_2_2_2 v_attribute_values_name_2_2_5 v_attribute_values_price_2_2 v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_tax_class_title v_status EOREOR 20999 no_pic_yet.jpg Test Test Test Test Test Test no_pic_yet.jpg 581.08 10 2005-12-01 2005-12-01 10 Testhersteller Test Test Taxable Goods Active EOREOR I dont know why and when I messed my EP up, therefore I kindly asked for your expert help. Kind regards and thanks in advance, Andreas
  8. Hi Irishcavan, try to enter the path without the leading images and start right with "Collectibles/African American Heritage/29319.jpg". Regards Andreas
  9. Hi there, I've got a problem with my Easy Populate v2.76b. I want to figure out, in which format the txt-file must be. Background info: I'm running Linux on my Desktop, all data I want to import with EP is stored with KSpread, the spreadsheet app in KDE. osCommerce is MS 2.2, EP is version 2.76b (Link to EP) and I have the UltraPic-Contrib installed (Link), all current files listed there, including the most recent EP update there !! I do have applied the correct column order. This order I got from the direct EP export, directly out of my shop. When I want to re-import exact the same file, all works well, so I assume, that the EP contrib is included well and working. When my assumption is correct, that EP is working with that file, and not with my other test-file, something has to be wrong with the test-file. Now my problem: When I want to export my data into a txt-file in KSpread, I have several possibilities during the export: Encoding: - UTF-8 - ISO 8859-15 Format, which handles the end of line: - UNIX style (line feed only) - Windows style (carriage return and line feed) - MacOS style (carriage return only) Separator: - Komma - Tab - Semicolon - Space Delimiter: - " - ' I chosse for the encoding ISO 8859-15, because I am from Germany, and I have special characters in my data, which I want to have set correctly. As Separator I use Tabulator and as delimiter ' When I upload my test-file and import it into the DB, I receive the following error message: File uploaded. Temporary filename: /tmp/phpWG2B8X User filename: Testeinspielung.txt Size: 1730 | 99 999 | | Testproduk | Testproduk | | Testproduk | Testproduk | | Testproduk | Testproduk | | | | | | | | | | | | | | | | 100 | 10 | 2005-12-01 | 2005-12-01 | 10 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Testherste | Test | Test | | Taxable Go | Active !New Product! 1136 - Column count doesn't match value count at row 1 INSERT INTO products ( products_image, products_image_med, products_image_lrg, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_image_sm_3, products_image_xl_3, products_image_sm_4, products_image_xl_4, products_image_sm_5, products_image_xl_5, products_image_sm_6, products_image_xl_6, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( '',", "", "", "", "", "", "", "", "", "", "", "", "", "", " '99 999', '86.2069', '1', CURRENT_TIMESTAMP, "2005-12-01", "2005-12-01", '1', '10', '10', '23') [TEP STOP] I only can guess that it has something to do with the correct txt-format, so I kindly asked you to give some advice on this issue, because I have tried most options I have during export from KSpread, and the problem is driving me nuts. Thanks in advance Regards Andreas
  10. Hi there, first of all, I would like to say thank you, because this mod is really what I was looking for. I tried to install it (Contribution Control & Bookmark MOD 0.1.4 MS2.zip), as described in your manual with no errors. But when I click on ADMIN > configuration > Contributions the screen is only blank, and I dont know why. Can you please advise, what I have to do, to get it work ?? Regards Andreas
  11. Hi there, I'm looking for a little contribution, that adds a little box in the middle of the main page (no box on the left or right side), where I can post the latest news. The whole thing should be handled through the admin section and should display up to 5 news. Can anyone give me a good and working recommendation. Thanks in advance, Regards Andreas
  12. I checked the database. My database is called "mysite_test". In this database I have now a table called "theme_configuration" I dont know if the errormessage Table 'oscommerce.theme_configuration' doesn't exist means that my database has to be called "oscommerce". Greetings Andreas
  13. Hi there, i'm getting an error message after installing contribution "Infobox Admin" http://www.oscommerce.com/community/contributions,1175 The error message comes after complete installation as described in the readme.txt and clicking on the link in the admin section: ******************************* Infobox Display,Update and Create Title Filename Column Position Action 1146 - Table 'oscommerce.theme_configuration' doesn't exist select configuration_id, configuration_title, configuration_value, configuration_column, location from theme_configuration where configuration_group_id = '1' order by configuration_column [TEP STOP] ******************************* The included SQL-File was executed without errors. Please advise. Regards Andreas
  14. Hi there, I'm struggling with the integration of the contribution : http://www.oscommerce.com/community/contributions,1603 http://www.oscommerce.com/community/contributions,1604 => the integration of the phpBB forums in osC. I can hardly understand the install file since I'm not a programmer. Can anyone please be so kind and give me a straight forward and step-by-step instruction of what to do in order to get this fine contrib working ?? Please post the instruction here, so that the community can profit too. Thanks in advance Andreas
  15. Thanks for your answer - sounds like hell of work :-) Regards Andreas
  16. Hi there, Ive got a question: If you have osC with several contributions installed, all contribs are making several changes and sometimes also in the same file. How do you keep track about all changes especially when you also have to handle upgrades ?? Thanks in advance, Andreas
×
×
  • Create New...