Jump to content

SunDust

Members
  • Content count

    10
  • Joined

  • Last visited

Everything posted by SunDust

  1. SunDust

    Attribute Sets Plus

    PROBLEM: THE ADMINISTRATOR LOGIN SCREEN IS BLOCKED All works fine in localhost but when I transfer the files to my server by FTP, the Administrator Login Screen is blocked. FIX: In the files: /catalog/admin/includes/database_tables.php /catalog/includes/database_tables.php Insert a space before 'products_attributes_sets_elements'. BEFORE: define('TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS','products_attributes_sets_elements'); AFTER: define('TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS', 'products_attributes_sets_elements'); ------------------------------------------------------------------------------------ SunDust
  2. SunDust

    Attribute Sets Plus

    To use this great contribution in a Multilanguage store, make the next steps: First: Make the same changes in the files of your language (in my case, spanish): "/catalog/admin/includes/languages/english.php" --> make the same changes in --> "/catalog/admin/includes/languages/espanol.php" "/catalog/admin/includes/languages/english/categories.php" --> make the same changes in --> "/catalog/admin/includes/languages/espanol/categories.php" "/catalog/admin/includes/languages/english/products_attributes.php" --> make the same changes in --> "/catalog/admin/includes/languages/espanol/products_attributes.php" Second: COPY also the next files in your language folder (in my case, "spanol" folder): /catalog/admin/includes/languages/english/products_attributes_sets.php /catalog/admin/includes/languages/english/products_attributes_sets_edit.php /catalog/admin/includes/languages/english/images/buttons/button_add_as.gif /catalog/admin/includes/languages/english/images/buttons/button_create.gif --------------------------------------------------------------------------------- Well, now we have a problem. If you use Multilanguage you will see the Attributes and the Values of the different languages at the same time when you make new attribute sets. The contribution works but is something uncomfortable. To fix this, make the next changes in the file "/catalog/admin/products_attributes_sets.php": 1a.- Change this: $options_name_query_sql = "select po.products_options_name, po.products_options_id from " . TABLE_PRODUCTS_OPTIONS . " po where po.products_options_id=".$_POST['products_options_id']; 1b.- To this: $options_name_query_sql = "select po.products_options_name, po.products_options_id from " . TABLE_PRODUCTS_OPTIONS . " po where po.language_id = '" . (int)$languages_id . "' and po.products_options_id=".$_POST['products_options_id']; ----------------------------------------------- 2a.- Change this: $attributeSets_query = tep_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " order by products_options_name"); 2b.- To this: $attributeSets_query = tep_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . (int)$languages_id . "' order by products_options_name"); ----------------------------------------------- 3a.- Change this: $attribute_set_sql = "SELECT pas.products_attributes_sets_id, pas.products_attributes_sets_name, pas.products_options_id, po.products_options_name, pase.products_attributes_sets_elements_id, pase.options_values_id, pase.options_values_price, pase.price_prefix, pase.sort_order FROM " . TABLE_PRODUCTS_ATTRIBUTES_SETS . " pas, " . TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS . " pase, ". TABLE_PRODUCTS_OPTIONS . " po WHERE pas.products_attributes_sets_id = " . $_GET['attset_id'] . " AND pas.products_attributes_sets_id = pase.products_attributes_sets_id AND pas.products_options_id = po.products_options_id ORDER BY pase.sort_order"; 3b.- To this: $attribute_set_sql = "SELECT pas.products_attributes_sets_id, pas.products_attributes_sets_name, pas.products_options_id, po.products_options_name, pase.products_attributes_sets_elements_id, pase.options_values_id, pase.options_values_price, pase.price_prefix, pase.sort_order FROM " . TABLE_PRODUCTS_ATTRIBUTES_SETS . " pas, " . TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS . " pase, ". TABLE_PRODUCTS_OPTIONS . " po WHERE pas.products_attributes_sets_id = " . $_GET['attset_id'] . " AND pas.products_attributes_sets_id = pase.products_attributes_sets_id AND pas.products_options_id = po.products_options_id AND po.language_id = '" . (int)$languages_id . "' ORDER BY pase.sort_order"; ----------------------------------------------- 4a.- Change this: $options_query_sql = "select pov.products_options_values_name, pov.products_options_values_id from " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po where pov2po.products_options_id = " . (int)$_POST['products_options_id'] . " and pov.products_options_values_id = pov2po.products_options_values_id order by pov.products_options_values_name"; 4b.- To this: $options_query_sql = "select pov.products_options_values_name, pov.products_options_values_id from " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po where pov2po.products_options_id = " . (int)$_POST['products_options_id'] . " and pov.products_options_values_id = pov2po.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pov.products_options_values_name"; ----------------------------------------------- 5a.- Change this: $options_query_sql = "SELECT pov.products_options_values_name, pov.products_options_values_id FROM " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po where pov2po.products_options_id = '" . $attribute_set['products_options_id'] . "' and pov.products_options_values_id=pov2po.products_options_values_id order by pov.products_options_values_name"; 5b.- To this: $options_query_sql = "SELECT pov.products_options_values_name, pov.products_options_values_id FROM " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po where pov2po.products_options_id = '" . $attribute_set['products_options_id'] . "' and pov.products_options_values_id=pov2po.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pov.products_options_values_name"; ----------------------------------------------- SunDust
  3. SunDust

    Google XML Sitemap SEO

    WONDERFUL!!, No problem now, everything works fine!! I have used the sitemap.class.php (I have not used sitemap.class_Alternate.php). I recommend to make the change of the post #32, If you don't make it, everything will works fine but you can receive a error message in localhost test on the line 44 of the file index.php (but it will work). Thank you for your effort and time. SunDust
  4. SunDust

    Google XML Sitemap SEO

    Hi Coopco, Yes, you have to copy the gss.xsl in the same folder as xml files. And yes, that step lack in the instructions...
  5. SunDust

    Google XML Sitemap SEO

    Hi Jack, My installation is ok, I have some contributions installed and all works fine. I have made the next change and now I have not the error: Your code: define('DIR_WS_CATALOG', DIR_WS_HTTP_CATALOG); require_once('includes/configure.php'); My change: require_once('includes/configure.php'); define('DIR_WS_CATALOG', DIR_WS_HTTP_CATALOG); I have not the error now but the xml files are still empty.... Regards SunDust
  6. SunDust

    Google XML Sitemap SEO

    Hi Jack, I have the next messages in my test on the server (I have 777 permision on xml files): ERROR: Google Product Sitemap Generation FAILED! ERROR: Google Category Sitemap Generation FAILED! ERROR: Google Manufacturer Sitemap Generation FAILED! ERROR: Google Specials Sitemap Generation FAILED! ERROR: Google Sitemap Index Generation FAILED! Array ( [QUERY] => Array ( [PRODUCTS] => Array ( [sTATUS] => success [NUM_ROWS] => 1138 ) [CATEOGRY] => Array ( [sTATUS] => success [NUM_ROWS] => 14 ) [MANUFACTURERS] => Array ( [sTATUS] => success [NUM_ROWS] => 64 ) [sPECIALS] => Array ( [sTATUS] => success [NUM_ROWS] => 0 ) ) [sAVE_FILE_XML] => Array ( [0] => Array ( [file] => /sitemapproducts.xml [status] => failure [file_exists] => false ) [1] => Array ( [file] => /sitemapcategories.xml [status] => failure [file_exists] => false ) [2] => Array ( [file] => /sitemapmanufacturers.xml [status] => failure [file_exists] => false ) [3] => Array ( [file] => /sitemapindex.xml [status] => failure [file_exists] => false ) ) ) Thank you for your time.
  7. SunDust

    Google XML Sitemap SEO

    Hi Jack, I have the next error in my localhost, in the first line of the test report: Notice: Use of undefined constant DIR_WS_HTTP_CATALOG - assumed 'DIR_WS_HTTP_CATALOG' in C:\htdocs\mysite\catalog\googlesitemap\index.php on line 44 After, the lines say that the test is ok but the XML files are empty. Why?? Thank you for your time and your work. Regards, SunDust
  8. SunDust

    Error

    I'm wrong. Please delete this message.
  9. Hi Mr. Fisher, May you give more clues? I have no problems in my computer (localhost) but I have two real sites on two different servers and I have the same problem in both. I have to talk with my hosting company to modify some file? I have to look for some file to modify it by myself? which file? what do you mean with http://mysite.com// ? Thank you, Best Regards SunDust
  10. I have the same problem. Your 404 message works fine in "localhost", but in my website I receive the windows server official 404 message (The webpage cannot be found.. back link..etc). Localhost works fine, in server doesn't work. So, I think that the problem is in the server configuration or maybe I have to add a redirect 404 in the htacces file?, I don't know, what do you think? Thank you for your time and your work. SunDust
×