Jump to content
Latest News: (loading..)


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
    Alix Laniesse
  • Location
    London, UK
  1. Hi there, I'm getting a table not found issue although I can see the table in my database. 1146 - Table 'soonlineshop.NEWSLETTER_ABONNEMENT' doesn't exist select count(*) as checkinscrits from NEWSLETTER_ABONNEMENT where abonnement_addresse_email = 'test@@test.com' I checked the name of the table in both the database and in file newsletter_abonnement.php and they match so I have no idea how I could get that error. Would someone be able to help please? Thanks
  2. Ok thanks Jack - I'll just uninstall it and install the latest version and see what that does.
  3. Hi, I built an oscommerce site a while back www.mossurfing.com with this add on and made some tweaks to have hyphen separators between my category titles (www.mysite.com/category1-category2) Example: http://www.mossurfing.com/women-snow-jackets-c-118_127.html I am currently building a new site but with a different host this time. I just copied over my previous site to this new host however my hyphen separators get wiped out (www.mysite.com/category1category2) Example: http://www.soon-line.com/hommesaccessoires-c-112_159.html I haven't changed anything so I'm thinking this is an issue on the host side but what could it be? Any help/advice would be very welcome! Many thanks
  4. Hi, I have duplicated products accross several categories. I just installed the "Specials in Categories List" however the products show as many times as they have been duplicated. Would you know how I could fix the code so that each product would show once only? Here are the instructions I followed: Step 1: Using the Admin tool create a "Specials" category at the top level of the categories tree. Do NOT put any products in this category!!!! Make a note of the category id number. You can find this out by clicking on the Specials link and looking at the URL in your browser where it says "......index.php?cPath=xx&....." the xx is the category id. +++++++++++++++++++++++++++++++ Step 2: Open up \catalog\index.php in your editor At line 15 immediately after: require('includes/application_top.php'); add: // Flag for SPECIALS category - change this number to your specials category id number if ($cPath == 30) { change 30 to xx from your URL $AHspecials = 1; } +++++++++++++++++++++++++++++++ Step 3: at about line 186 find: } else { // show the products in a given categories immediately after } else { add: if ($AHspecials == 1) { // We show all specials $listing_sql = "select " . $select_column_list . " p.products_id, pd.short_desc, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and s.status = '1' and p.products_id = p2c.products_id and p.products_id = s.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "'"; } else { +++++++++++++++++++++++++++++++++ Step 4: at about line 199 immediately after } } add: } +++++++++++++++++++++++++++++++++ save \catalog\index.php. Step 5: Add specials to your site by using the Admin tool "Catalog, Specials" Do NOT put any products in the Special category using "Catalog, Categories / Products" they will not show!!!! Thanks for your help!!
  5. Hi! Thanks a lot for taking the time to reply. Your first option is actually something I never thought of although it sounds bleeding obvious :) Well in my situation it is as I only have about 20 products on sale so great for short term solution. In the longer term I will look into this 2nd option. Thanks again
  6. Hi, In the product listing and for all products on sale, I'd like to have a "sale" written on the product's image. Has anyone got an idea of how to do this? Many thanks!
  7. alix32

    Who's Online Enhancement 1.4

    Today it's working and i haven't touched anything! No idea of what went wrong. Sorry for the waist of time Glen. Alix
  8. alix32

    Who's Online Enhancement 1.4

    Hi Glen and thanks a lot for your reply. I haven't touched the Javascript options...do you know where I should be looking at? I believe it's in my internet options / advanced? It may be my Java version? Thanks
  9. alix32

    Who's Online Enhancement 1.4

    Hi, I installed version 3.5.4 and is brilliant. However, although I haven't touched anything, my pages don't refresh anymore. It looks like this happens since I updated to IE7. has this happened to anyone too? Is there a fix to this? Thanks, Alix
  10. I've found the problem! :blush: When I moved to the new server, the options "track stock?" in the admin/products_attributes.php page had defaulted back to no. So I just had to set each of my product options in the top left hand corner of the page to yes. Sorry!
  11. I've checked that all files were and they are. I've tried several times to upload and nothing changes. I've made backups. I've got this feeling that problem sits in the stock.php page which is the one which displays the products attributes stock and allows them to be updated. The only difference I could point out is that I used to be on register_globals off and on this new server I'm on register_globals on. Also, I downgraded from MySQL 5.0 to MySQL 4.1...would that be the cause you think?
  12. Hi, I have QTPro V4.2. I've just transferred my site onto a new server and my page admin/stock.php does not display the stock per attribute anymore. It just displays a quantity with a button "update" next to it. Normally I would see the attributes, the quantities and a button "Add". In the admin section, I do have the page "products_attributes.php" correctly populated and on the online store itself, the attributes display correctly too. I checked the page "stock.php" against the one I have on the old server and there's no difference. I also checked that I transferred all my database tables onto my new server but all semms ok...big problem :( Thanks to anyone who knows and would help me out!
  13. alix32

    "Dynamenu" for osCommerce

    Hi there! I installed this contirbution and it works great. However, I would like to replace the category names by images. Has anyone managed to do so? If yes I wouldn't mind some little guidance :) Cheers