Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
  • Gender
  1. redrum

    QTPro BS

    Thank you so much for your quick and informative reply, @raiwa Yes that makes sense, I had my suspicions about something like that when I continued to look at it after my post. If I want to find the lost product IDs I guess I should write some kind of query to locate them. But for now I will keep it as it is. It shouldn't do any harm and my time is limited right now. Thanks again :)
  2. redrum

    QTPro BS

    When I go to admin/qtprodoctor.php I get the following message: "In the database we currently have 3 trash rows" There is no further information, and I have fixed all the products that had a faulty stock. I looked into the code for admin/includes/functions/qtpro_functions.php and find the functions for the Trash-Tools (around line 460). But I couldn't figure out what the functions qtpro_stock_row_is_trash() and qtpro_number_of_trash_stock_rows() actually checks. I did a quick query in phpmyadmin to find for duplicats in the table PRODUCT_STOCKS: SELECT products_id, products_stock_attributes, COUNT(*) FROM products_stock GROUP BY products_id, products_stock_attributes HAVING COUNT(*) > 1 But the results was zero. So what and where does the functions qtpro_stock_row_is_trash() and qtpro_number_of_trash_stock_rows() checks?
  3. redrum

    Recover Cart Sales

    Regarding how long time after the visit the email should be sent; How can I change it to look back for a specific amount of hours, instead of days?
  4. Where is "V2.1 - bugfixes, enhancements" available for download?
  5. redrum

    Quantity Price Breaks

    I have some issues with Quantity Price Breaks for Separate Pricing Per Customer. I cant get the discounted price to be displayed unless I add two pcs of the same product (the total number of items must of course meet the criteria I have set up in the discount table). But if I go to shopping_cart.php and hit the Update Cart-button then the correct price with the discount is shown. I have set up a price table as follows; 1-4 pcs: $39 5+ pcs: $33 And then assign the products to the same discount category. This scenario work: Adding: 2 pcs of Product-A, 2 pcs of Product-B and 2 pcs of Product-C. or Adding: 3 pcs of Product-A and 2 pcs of Product-B. This scenario don't work: Adding: 2 pcs of Product-A, 1 pcs of Product-B, 1 pcs of Product-C, 1 pcs of Product-D or Adding: 4 pcs of Product-A, 1 pcs of Product-B, 1 pcs of Product-C, 1 pcs of Product-D or Adding: 4 pcs of Product-A and 1 pcs of Product-B I have spent some time trying to fix this but havent been able to find a solution. What could be wrong and where should I looking, does anyone have an idea?
  6. will it work with osCommerce 2.2-MS2?
  7. redrum

    Stocktaking Cost 0.3 problem.

    Does anyone have any idea of why the name of the categories disappear after this update, and how to solve that?
  8. redrum

    ULTIMATE Seo Urls 5 - by FWR Media

    Well, this contribution keeps confusing me. I noticed that the settings in admin was changed; Cache system was chaned from "file" to "sqlite" uri format was changed from "rewrite" to "standard" So the settings was reverted to default. I thougth it was very odd, but just changed it back. A few hours later it was back to default again. I then checked the database tables for usu5 and noticed that the time for date_added was just recently. So for some reason usu5 reinstalls for me. help, anyone?
  9. redrum

    ULTIMATE Seo Urls 5 - by FWR Media

    Did you find a solution for this? I hope I dont speak to mylelf here. After changing from "sqlite" to "file", the only error message in the log that I have received during 40 hrs is PHP Fatal error: Call to a member function store() on a non-object in /xxx/includes/modules/ultimate_seo_urls5/main/usu5.php on line 78 it occured 42 times during a period of 1,5 minute. I searched this thread and found that some other have had the same problem, but I couldnt find any soultion for it. The closest thing I found was the qoute above. I find it confusing that this contribution generate so many error massage for me, as faar as I know Robert is a skilled programmer.
  10. redrum

    ULTIMATE Seo Urls 5 - by FWR Media

    I have some more errors in my log since the last post and one of them is new. Here it is: PHP Warning: SQLiteDatabase::query() [<a href='sqlitedatabase.query'>sqlitedatabase.query</a>]: database disk image is malformed in /xxx/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 136 I have switched "cache system" in admin from "sqlite" to "file". So lets see how that turns out. Another question. As for the different cache systems, which is the best, next best, and so on? Thanks, Fredrik
  11. redrum

    ULTIMATE Seo Urls 5 - by FWR Media

    I have switched from Chemos SEO URLs to this one by FWR Media I first received this error in my logs PHP Warning: SQLiteDatabase::query() [<a href='sqlitedatabase.query'>sqlitedatabase.query</a>]: column cache_name is not unique in /xxx/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 130 I then updated sqlite.php from http://forums.oscommerce.com/topic/336702-ultimate-seo-urls-5-by-fwr-media/page__st__2920#entry1573002 and reset USU5 Cache from admin Then after a couple of minutes these error messages appeared in the logs PHP Warning: SQLiteDatabase::query() [<a href='sqlitedatabase.query'>sqlitedatabase.query</a>]: column cache_name is not unique in /xxx/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 136 PHP Warning: SQLiteDatabase::query() [<a href='sqlitedatabase.query'>sqlitedatabase.query</a>]: unable to open database file in /xxx/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 136 These error messages have occured 5 times during 4 hours. The folder includes/modules/ultimate_seo_urls5/cache_system/sqlite have the rights 777 I use Ultimate Seo Urls 5 PRO ( r205 ) at http://addons.oscommerce.com/info/6768 PHP Version: 5.2.17 OSC Version: 2.2 rc2a Any idea how to fix there errors?
  12. redrum

    Jquery UI Autocomplete search box

    json needs to fetch the database info in utf8, my database is in latin1 and have special character such as å, ä and ö, This returend to display some products as "null". So you need to encode how the data is fetched from the database if you encounter this problem. Find array_push($return_arr, $row['products_name']); in autocomplete.php and replace with array_push($return_arr, utf8_encode($row['products_name']));
  13. redrum

    Jquery UI Autocomplete search box

    Does this contributions have some limitations? I have around 2000 active products and 1000 inactive. I only get an autocomplete list when I type in the letters "ai". If I type the letters "do" no products get listed. But I do get a searh result when searching for "do". Why is it like that? //Fredrik
  14. Thanks for your reply. Does it support propperly so the payment options and shipping options changes when you changing country, depending on what each country allows?
  15. When I try the demo I get the message "No shipping available to the selected country". Can you set up the demo that allows shipping to some countrys, and so it changes the payment and shipping options depending on country. So we can see how this is updated. If this work propperly you have some good stuff here. Keep up the good work. Cheers, Fredrik