Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Rosyweb

Members
  • Content count

    102
  • Joined

  • Last visited

Everything posted by Rosyweb

  1. 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?
  2. 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.
  3. 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!
  4. 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!
  5. 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?
  6. But not /test2/ just / for my live site
  7. 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
  8. 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!
  9. Jack, thanks for the answer. I'll add on that one.
  10. Rosyweb

    QTPro BS

    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!
  11. Rosyweb

    QTPro BS

    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.
  12. Rosyweb

    QTPro - stock table sort order

    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");
  13. I've been trying to find an answer to this for some time. The QTPro add on has a stock table. This is in the file modules/qtpro_stock_table.php It appears to be ordering it by the table PRODUCTS_STOCK and the field products_stock_attributes. Adding different Order by to the other queries doesn't seem to change anything. The problem with the products_stock_attributes field in the table PRODUCTS_STOCK is that it is a varchar field and so sorts lexically. So for example I am getting soirting results that show: 1000 before 53 In addition the field has 2 hyphens and a comma. So I tried on the query a very complicated Order by to first separate the 2 bits of info in the products_stock_attributes field and order them separately (1st in my shop is colour, 2nd is size), then the Cast as Signed integer to order: // Get the stocklevels $products_stock_query=tep_db_query("SELECT products_stock_attributes, products_stock_quantity FROM " . TABLE_PRODUCTS_STOCK . " WHERE products_id=" . (int)$HTTP_GET_VARS['products_id'] ." ORDER BY SUBSTR(products_stock_attributes,INSTR(products_stock_attributes,'-')+1) ASC, SUBSTR(products_stock_attributes,INSTR(products_stock_attributes,',')+3) ASC, CAST(products_stock_attributes as SIGNED INTEGER) ASC"); It doesn't work. Cast as signed integer still leaves i.e. 1000 before 200 Any ideas QTPro experts out there? Has anyone else tried to get the QTPro table sorting correctly? I have the picklist in the right oder in pad_base. many thanks
  14. Rosyweb

    QTPro BS

    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
  15. Rosyweb

    QTPro BS

    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!
  16. Rosyweb

    QTPro BS

    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!
  17. Rosyweb

    QTPro BS

    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?
  18. Rosyweb

    QTPro BS

    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
  19. Rosyweb

    QTPro BS

    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.
  20. Rosyweb

    QTPro BS

    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!
  21. Rosyweb

    QTPro BS

    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
  22. Hello, I'm trying to upgrade to the latest Sage Pay form v. 2 and although the payment money has been taken successfully through Sage Pay, it then returns the customer to the site with the failure message and no orders are written to the admin side (as it views the payment as a failure). Anyone else experienced this? Any ideas why the form isn't working? I haven't modified it at all, it is as the download. My old sage pay form v. 1.2 worked fine - no problems there and if I swap it back it works fine again. I'd be grateful for any help with this ...
×