Rosyweb

Ok thanks Jack!

OK, that makes sense. So should I perhaps not enable i.e. categories cache - to stop it building up the cache stored? If this created a problem?

I think it was working fine, well I hadn't seen any problems. Then someone told me about the problem today, they found from a different computer and they were right it was doing this also on my pc. I've just fiddled with the settings - tried to change Reset SEO URLs Cache to Reset, but it keeps defaulting back to false. Then looked again at the live site and the problem seems to have disappeared for now??!! Not sure if this cleared some cache and if the problem will return again later - but its working again for now. I'll keep an eye on it.

I'm sorry, I'm having another problem with this now. On my live site, when Enable SEO URLs is on, when you navigate to anywhere via the navigation, we're getting: If I just link straight to a product from the home page, i.e. a special - all is ok. When I turn Enable SEO URLs to false - all is fine again navigating the site. Any idea where I can look, or what I can set to get rid of this? It's Bootstrap v2.3.4.1 CE Php 7.1 thanks!

Thank you Jack. I'd inadvertently uploaded the 2 upload files includes/classes/seo.class.php admin/includes/reset_seo_cache.php from the wrong folder - onto my live site. Everything else was correct! It works now - Yipee! thanks for all your help!

Ok - will try the above.

Thank you Jack. Unfortunately it didn't work. I'm now using the .htaccess as above. The site all works fine when I take off the add ins. Works fine in fact when I add everything back in from SEO URL's contribution until application_top and includes/functions/html_output.php are put back in. I'm using the exact same files for these that work on my test site. When these go back in the code simply breaks. Could something server side be affecting this? Or is the clue in, that before I add back to application_top and html_output.php the site works with the admin additions put in, but the link to SEO URL is not appearing under configure. Although I have checked and checked the files in the admin folder: includes/classes/seo.class.php admin/includes/reset_seo_cache.php both uploaded correctly. admin/categories.php admin/includes/functions/general.php both identical to the ones working on my test site. Anything else to check that may not be compatible with the new code?

But not /test2/ just / for my live site

Sorry - .htaccess actually looks like this: #.htaccess ros #Redirect 301 mysite.co.uk http://www.mysite.co.uk <IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{HTTPS} !on [NC] RewriteRule ^(.*)$ https://%{HTTP_HOST}/$1 [R=301,L] </IfModule> Options +FollowSymLinks RewriteEngine On RewriteCond %{HTTP_HOST} ^mysite\.co.uk$ [NC] RewriteRule ^(.*)$ https://www.mysite.co.uk/$1 [R=301,L] ErrorDocument 404 /404.shtml #rewrite #RewriteEngine On (enables the rewrite engine) #RewriteCond %{HTTP_HOST} ^http://mysite.co.uk [NC,OR] #RewriteCond %{HTTP_HOST} ^mysite.co.uk [NC] #RewriteRule ^(.*)$ https://www.mysite.co.uk/$1 [L,R=301,NC] (send the redirect to this) <Files 403.shtml> order allow,deny allow from all </Files> deny from 65.19.141.114 # Begin Ultimate SEO V2.2d Options +FollowSymLinks RewriteEngine On # RewriteBase instructions # Change RewriteBase dependent on how your shop is accessed as below. # http://www.mysite.com = RewriteBase / # http://www.mysite.com/catalog/ = RewriteBase /catalog/ # http://www.mysite.com/catalog/shop/ = RewriteBase /catalog/shop/ # Change the following line using the instructions above #RewriteBase /YOU HAVE TO CHANGE ME/ changed - see below RewriteBase /test2/ RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-c-(.*).html$ index.php?cPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-m-(.*).html$ index.php?manufacturers_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pi-(.*).html$ popup_image.php?pID=$2&%{QUERY_STRING} RewriteRule ^(.*)-by-(.*).html$ all-products.php?fl=$2&%{QUERY_STRING} RewriteRule ^(.*)-t-(.*).html$ articles.php?tPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-a-(.*).html$ article_info.php?articles_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-au-(.*).html$ articles.php?authors_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pr-(.*).html$ product_reviews.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pri-(.*).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-f-(.*).html$ faqdesk_info.php?faqdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-fc-(.*).html$ faqdesk_index.php?faqPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-fri-(.*).html$ faqdesk_reviews_info.php?faqdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-fra-(.*).html$ faqdesk_reviews_article.php?faqdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-i-(.*).html$ information.php?info_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-links-(.*).html$ links.php?lPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-pm-([0-9]+).html$ info_pages.php?pages_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-n-(.*).html$ newsdesk_info.php?newsdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-nc-(.*).html$ newsdesk_index.php?newsPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-nri-(.*).html$ newsdesk_reviews_info.php?newsdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-nra-(.*).html$ newsdesk_reviews_article.php?newsdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-po-([0-9]+).html$ pollbooth.php?pollid=$2&%{QUERY_STRING} # End Ultimate SEO V2.2d

I'm having problems getting this to work correctly on my live site. On my test site (where files are identical) all is fine. When I transfer it over to my live site - it just results in a blank page. Basically when you look at code source it just has 1. then nothing. So the code is broke from the point where it's introduced into application_top. Copies over all files from test site - so identical. The admin files and seo.class and the file reset_seo_cache.php copy over ok, i.e. do not break the site - although SEO URLs title is not appearing under configure in the admin side of the site. When I add it into application_top and includes/functions/html_output.php then the code breaks. I'm on for both the test site and live - Bootstrap v2.3.4.1 CE and php 7.1. .htaccess now looks like this: ------------------------------------------------------------------------------------------ #.htaccess ros #Redirect 301 mysite.co.uk http://www.mysite.co.uk <IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{HTTPS} !on [NC] RewriteRule ^(.*)$ https://%{HTTP_HOST}/$1 [R=301,L] </IfModule> Options +FollowSymLinks RewriteEngine On RewriteCond %{HTTP_HOST} ^mysite\.co.uk$ [NC] RewriteRule ^(.*)$ https://www.mysite.co.uk/$1 [R=301,L] ErrorDocument 404 /404.shtml #rewrite #RewriteEngine On (enables the rewrite engine) #RewriteCond %{HTTP_HOST} ^http://mysite.co.uk [NC,OR] #RewriteCond %{HTTP_HOST} ^mysite.co.uk [NC] #RewriteRule ^(.*)$ https://www.mysite.co.uk/$1 [L,R=301,NC] (send the redirect to this) <Files 403.shtml> order allow,deny allow from all </Files> deny from 65.19.141.114 ------------------------------------------------------------------------------------------ Any ideas where else I can look for a reason why the same files uploaded to my live site that do work on my test site, don't work on the live site?? What other settings should I check? many thanks!

Jack, thanks for the answer. I'll add on that one.

Hi Raiwa yes I get the opposite. Installation is a new one and all else is working well. I'll test more when I have the chance. But yes - strange we are getting opposite results!

Raiwa, I'm not sure if this is a bug or not. It may only have been behaving like this on my site but thought I'd feed back to you. I'm on OSCommerce v2.3.4.1 CE and installed QTPro 2.3.4.1. CE When I have products with attributes attached, all behaves well with the QTPro add on - the admin/stock.php page. I can add stock, I can delete all stock and start again. All fine. However, on my site I have some products that don't have attributes attached and I just rely on the table = products, products_quantity field for the products quantity. When I add stock to one of these products I don't expect it to create an entry in products_stock also. Which is does with the current add on - as the button defaults to Add not Update when stock is 0. The problem being, the Add button automatically creates an entry corresponding to the products id in table products_stock. So what's the problem with that? Well on products WITHOUT attributes, it causes the QTPro doctor to complain that this is a 'sick' product. I got round it in the end, and changed your code - about line 220 (($db_quantity)? BUTTON_UPDATE : BUTTON_ADD ) to ($flag? BUTTON_ADD : BUTTON_UPDATE ) going back to the original way, from an older QTPro contribution. I tweaked in a couple of other places, but this seems to work. I don't know if I'm causing myself other problems here, hopefully not, but now I can take a product without attributes down to 0 stock again, then add stock back to it - now the button is Update not Add!! and no 'sick product' messages in QTPro doctor and no forced entry into table products_stock. If you have a better solution, please let me know. Otherwise this is just feedback on problems encountered.

Just adding this to bootstrap site - a number of years later! I'm finding that LPAD on attNum1 is needed for it to work correctly in this version. $products_stock_query=tep_db_query("SELECT SUBSTR(products_stock_attributes, 1, INSTR(products_stock_attributes,',')-1) AS attNum1, SUBSTR(products_stock_attributes,INSTR(products_stock_attributes,',')+3, 5) AS attNum2, products_stock_attributes, products_stock_quantity FROM products_stock WHERE products_id=" . (int)$_GET['products_id'] ." ORDER BY LPAD(attNum1, 10, 0) DESC, LPAD(attNum2, 10, 0) ASC");

Yes, after moving server etc it works. Yipee! Strangely again the OSCommerce v2.3.4.1 CE I'd installed from a zip file and during the installation it had indicated the old version of php was fine, showing a thumbs up by the PHP version during the installation screens. For some reason doesn't pick up on this in the install screens correctly! Sorry I had missed this on your QTPro version Raiwa. So all good now and thanks for the help. Raiwa - just a small note on your QTPro 2.3.4.1. CE Frozen installation documentation (word file). Install point 5: 5. [mandatory] In Admin =>Product Attributes => Header Tags install and configure the module "QT Pro Stock Check". needs to say in Admin / Modules / Header Tags - install QT Pro Stock Check i.e. not in Product Attributes. A typo I think but it may be worth changing this for the next update. many thanks

Thanks Raiwa. So school girl error. Its the PHP version. Strangely the OSCommerce 2.3.4.1. CE Frozen installation seems to work on an earlier php than 7, but maybe all the functionality isn't there. I'm setting up on another server area where I can switch the php higher. I'll report back - hopefully this is the solution and all will then work! thanks for the pointers!

Hello Raiwa. Yes I'm using a clean 2.3.4.1. CE Frozen installation. I did not modify the content modules. Everything was from the QTPro 2.3.4.1 CE Frozen download and not modified. The Amended files, also I used the ones from your download, because this is a clean install so I could use your ones. I've tried turning off content modules for page product_info one by one, as you suggested. And it is only the QTPRO Options module that has a problem. So when this is turned off, content modules are loaded. When turned on, code stops at <div class="row is-product"> and the QTPro Options module is not loaded. So I'm guessing either there is a problem with the Options module file: includes / modules / content / product_info / cm_pi_qtpro_options.php (which I took from the download NEW files) or there is a problem with calling the module. Also The only Error_logs I found were in the admin folder and install, but only listed old errors from previous dates. The page is not calling the module today and no error logs are being generated for today. My hosting company also looked in their error log to see if anything is being generated. So if the Options module file is there and correct. includes / modules / content / product_info / cm_pi_qtpro_options.php What could be causing it NOT to call this? It calls all other module files correctly when this one is turned off. Any ideas? and thanks for the help!

I have re-installed the OSCommerce version v2.3.4.1 CE and re-downloaded the QTPro 2.3.4.1 CE Frozen package and re-done the install again for this. So I've resolved the back end issues with the language files, its picking those up correctly now. Everything seems to be working as it should - back end (in admin). BUT - the product_info.php page is still not rendering correctly. Yes Raiwa, it is the header showing with the main content blank. Here's my link. This is just a test site. https://www.rosweb.co.uk/alpine_mobileEdge/product_info.php?products_id=28 code stops at line 76 <div class="row is-product"> I have uploaded all the content modules. Checked and checked again. I have not modified product_info.php Any ideas?

Hello Raiwa thanks for coming back about this. So firsty, great I'm using the correct QTPro version for my installation. 2.3.4.1 CE Frozen package. 2nd - in the download for this - there is no product_info.php page included in either the new files or amended ones. There is in the Edge version under amended files. Is this page missing from the download, or have I mis-understood? many thanks, my download was from and was the latest: https://apps.oscommerce.com/e317m&amp;qtpro-bs Ros

Thank you for that reply. That's the one I've been using - but within that download there are 2 versions to choose from. 2.3.4.1. CE Frozen version and 2.3.4.(1) Edge version I've tried both and neither seem to render properly. I think its supposed to be the 2.3.4.1. CE Frozen version I should use, as I have OSCommerce version v2.3.4.1 CE installed. So both have CE in their names. Trying to get that to work. The first problem is on the public - product view page. Product_info.php is rendered blank. Looking at the source code, is there up till line 76 <div class="row is-product"> then nothing after that. In the admin side, looking at the modules - they're not linking to their language file properly. Have checked this over and over to make sure its in the right location - it is. Not sure why not linking to it?? But that is the least of my worries - not rendering on the public - product_info.php page is the main thing. ?? Any ideas. I have done the install about 3 times now to make sure I'm doing it right.

So I think I might have made this sound more complicated than it needs to be. I have OSCommerce version v2.3.4.1 CE installed. Which QTPro download should I use with this? Any help would be gratefully received as I'm desparately trying to crack this today!

Hello Raiwa - as requested posting this query on the public site. I'm trying to add QTPro to a fresh installation of OSCOmmerce. I have installed OSCommerce version: osCommerce Online Merchant v2.3.4.1 CE I have downloaded your QTPro contribution and tried firstly the 2.3.4.1. CE Frozen version - but when I tried to view the product on the public side product_info.php page, the product page was blank and had not rendered the code. So I removed the CE Frozen version and then tried using your 2.3.4.(1) Edge version and although the back end worked fine - able to select attributes and add stock in admin, again the product_info.php page is not displaying as it should. Just displaying product info and add to cart. No stock pick lists, no stock chart. And yes I have enabled the QTPro Options module - to true. Have I simply installed the wrong version? I'm trying to work out if my OS version v2.3.4.1 CE is in fact Edge or Frozen. Please any advice to help me get this working! I have installed and used QTPro on previous OSCommerce versions of course. many thanks Ros

Ok a year later, but a slight amendment. The 1st part of the split - creating attNum1 had never really worked correctly, so here's a version that does: $products_stock_query=tep_db_query("SELECT SUBSTR(products_stock_attributes, 1, INSTR(products_stock_attributes,',')-1) AS attNum1, SUBSTR(products_stock_attributes,INSTR(products_stock_attributes,',')+3, 5) AS attNum2, products_stock_attributes, products_stock_quantity FROM " . TABLE_PRODUCTS_STOCK . " WHERE products_id=" . (int)$HTTP_GET_VARS['products_id'] ." ORDER BY attNum1 ASC, LPAD(attNum2, 10, 0) ASC");

Wow - that took a long time but I found a way to sort it correctly in the end and will post it here in case anyone else tries to do this. So in modules/qtpro_stock_table.php, the sort order is determined by the $products_stock_query=tep_db_query and not the other queries. The field I needed to get to sort in natural sort order not lexically is products_stock_attributes. Applying the usual ways to convert a varchar field to natural sort order in the ORDER BY part of the query didn't seem to work. i.e. LPAD CAST(field as SIGNED INTEGER) ASC convert(field, decimal) ASC"); none of these worked because products_stock_attributes has hypens and commas in it as well. They didn't even work if I got rid of the hypens, because I had to keep the comma as this separates the product attribute data (size, colour). They didn't work when I split the field into 2 strings in the ORDER BY part of the query. So I split it into 2 strings in the SELECT part of the query and gave each alias names, then sorted it in ORDER BY by the alias names. Added LPAD to these in the ORDER BY part to force natural sort order (this time it works as there are only numerics in the strings). Here's what worked for me: // Get the stocklevels $products_stock_query=tep_db_query("SELECT SUBSTR(products_stock_attributes,INSTR(products_stock_attributes,',')-1, 4) AS attNum1, SUBSTR(products_stock_attributes,INSTR(products_stock_attributes,',')+3, 4) AS attNum2, products_stock_attributes, products_stock_quantity FROM " . TABLE_PRODUCTS_STOCK . " WHERE products_id=" . (int)$HTTP_GET_VARS['products_id'] ." ORDER BY LPAD(attNum1, 10, 0) DESC, LPAD(attNum2, 10, 0) ASC");