redrum

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 :)

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?

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?

Where is "V2.1 - bugfixes, enhancements" available for download?

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?

will it work with osCommerce 2.2-MS2?

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

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?

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.

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

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://www.oscommerce.com/forums/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?

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']));

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

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?

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

I have a custom made one-page-checkout (namned checkout.php). In the country pull down menu I used to have Sweden as pre-selected. That pre-selection was disapeared after the upgrade to rc2a. This is due to the new function tep_draw_pull_down_menu in includes/functions/html_output.php So if I use the rc2a: function tep_draw_pull_down_menu($name, $values, $default = '', $parameters = '', $required = false) { global $HTTP_GET_VARS, $HTTP_POST_VARS; $field = '<select name="' . tep_output_string($name) . '"'; if (tep_not_null($parameters)) $field .= ' ' . $parameters; $field .= '>'; if (empty($default) && ( (isset($HTTP_GET_VARS[$name]) && is_string($HTTP_GET_VARS[$name])) || (isset($HTTP_POST_VARS[$name]) && is_string($HTTP_POST_VARS[$name])) ) ) { if (isset($HTTP_GET_VARS[$name]) && is_string($HTTP_GET_VARS[$name])) { $default = stripslashes($HTTP_GET_VARS[$name]); } elseif (isset($HTTP_POST_VARS[$name]) && is_string($HTTP_POST_VARS[$name])) { $default = stripslashes($HTTP_POST_VARS[$name]); } } for ($i=0, $n=sizeof($values); $i<$n; $i++) { $field .= '<option value="' . tep_output_string($values[$i]['id']) . '"'; if ($default == $values[$i]['id']) { $field .= ' SELECTED'; } $field .= '>' . tep_output_string($values[$i]['text'], array('"' => '"', '\'' => ''', '<' => '<', '>' => '>')) . '</option>'; } $field .= '</select>'; if ($required == true) $field .= TEXT_FIELD_REQUIRED; return $field; } no country is pre-selected. If I use the old ms2: function tep_draw_pull_down_menu($name, $values, $default = '', $parameters = '', $required = false) { $field = '<select name="' . tep_output_string($name) . '"'; if (tep_not_null($parameters)) $field .= ' ' . $parameters; $field .= '>'; if (empty($default) && isset($GLOBALS[$name])) $default = stripslashes($GLOBALS[$name]); for ($i=0, $n=sizeof($values); $i<$n; $i++) { $field .= '<option value="' . tep_output_string($values[$i]['id']) . '"'; if ($default == $values[$i]['id']) { $field .= ' SELECTED'; } $field .= '>' . tep_output_string($values[$i]['text'], array('"' => '"', '\'' => ''', '<' => '<', '>' => '>')) . '</option>'; } $field .= '</select>'; if ($required == true) $field .= TEXT_FIELD_REQUIRED; return $field; } the store country is pre-selected just as it should. This is how my code for selecting country looks like: <?php echo tep_get_country_list('country', ($HTTP_POST_VARS['country'] ? $HTTP_POST_VARS['country'] : $order->billing['country']['id']),'onchange="sb=1;copy_shipping(document.getElementsByName(\'ship_as_bill\')[0],true);sb=0;getbillstatewithshipp();" class="checkoutCountry" style="width:145px;"') . ' ' . (tep_not_null(ENTRY_COUNTRY_TEXT) ? '<span class="inputRequirement">' . ENTRY_COUNTRY_TEXT . '</span>': ''); ?> Should I stick to the old ms2 function tep_draw_pull_down_menu? Or can anyone help me out modify the code for selecting country in my checkout.php? Thanks, Fredrik

I looked into this abit more. And it does update as it should. The problem is that if you continue and hit the "Preview" button the value in the field "Products Quantity:" over-write the the value AJAX Attribute Manager set in 'products_quantity'. So it would be nice with a solution for this.

There is still a bug when using QTpro; The field 'products_quantity' in table 'products' is not updated. If you use the QTpro manager to update the attributes stock this table gets updated as well (and not only 'products_stock'). Example: If you have two attributes and 5 pcs of each you have a total of 10 pcs in 'products_quantity'. If you then go and edit this product and update the attribute stock to 10 pcs of each you should have a total of 20 pcs in 'products_quantity'. But it still ends up with a total of 10 pcs. This could be very crucial If you have set your store so your products become inactive while they are out of stock, then your product will be inactive in the store before its actually out of stock. It’s become inactive when 'products_quantity' in table 'products' has the value 0, even thou you have a positive value in the field 'products_stock_quantity' in the 'table products_stock'. Does anyone have a fix or thoughts about this? //Fredrik

I little bit more info about the question abowe. I made some atempts by adding $order = new order($oInfo->orders_id); echo sizeof($order->products); in some various combinations and with some additional code. I also tried <?php $total_units = 0; for( $i=0, $j=count($order->products); $i<$j; $i++) { $total_units += $order->products[$i]['qty']; } ?> <?php echo $total_units . ' items'; ?> This code works fine for displaying total items on the invoce.php But there was no luck by get the total amount of items in the list for orders at orders.php I suspect I need to attach the code to each specific order number. But I cant find out how.

It should be; Is it possible to add the total quantity that each order contains in the order listing?

Is it possible to add the total quantity that each order contains in the product listing? If so, please enlighten me with that. Thanks, Fredrik

Thanks for your reply. My shop is in swedish, therefore a possibility for the swedish language would be nice for me. I use the contribution Googiespell Multilanguage Spell Check Script to do spell checking when I add a new item in admin. And that contrib use the script from http://orangoo.com/labs/GoogieSpell/. That contribution is not updated with the latest version of Googiespell thou. But if you're planning to look into it, those links might help you a bit. Another question regarding your contribution and the precedur of it, Does it check all pages for spelling error at once and then suggest the correct spelling and then you confirm the changes? So you dont have to go into each product to find spelling errors? Thanks, Fredrik

What kind of dictionary does it use? Is it possible to use google spell, since it support several languages? Cheers, Fredrik

Is there any online demo for this contribution? //Fredrik

I wouldnt call these issues "minor issues". Have you made any progress with this, and found out if it is related to this contribution? //Fredrik