Jump to content

UncleSam

Member
  • Posts

    19
  • Joined

  • Last visited

Posts posted by UncleSam

  1. Howdy,

     

    My cubecart site was on a different server, but I had to transfer the site to my other hosting.

     

    So i copied the files from old server to new an Changed the DNS mapping to the new server.

     

    However Im getting this error now.

     

    Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2003): Can't connect to MySQL server on 'mysql.XXXXX.net' (113) in /home/SITE/public_html/classes/db/mysqli.class.php on line 22

    Fatal error: Can't connect to MySQL server on 'mysql.XXXXX.net' (113) in /home/SITE/public_html/classes/db/mysqli.class.php on line 24

     

    Thanks!

  2. Yes it was working fine on this same server.

     

    However recently i added Inveo Magic SEO URLs for CubeCart5.The installation was successful without any issues.

     

    I'm not sure if Magic SEO is causing this, because i disabled it and the issue is still there.

  3. Hi there,

     

    I'm Using cubecart 5.2.1.

     

    My website works just fine, I mean the home page only.

     

    However when i click on any of the links it adds "en-gb/page name".

     

    For eg : www.xxxx.cm/en-gb/account/new-user and it gives the error (Attachment).

  4. I really appreciate your help bsmither.

     

    I'm surprised why AI didn't notice it even when I'd attached a screen-shot. The moderator wrote "LOL" :-P and locked that thread.

     

    Anyway I figured it out the file (/admin/sources/reports.index.inc.php) was calling the wrong template (orders).

     

    I have no idea why the previous developer did it. I’ve replaced it with the original one. It displays the correct reports page with the export button now.

     

    Thanks :-) !!!

  5. Thanks,

     

    Now, what I did is, I changed the "Out of stock" text to "Log In" as suggested by a guy on the other thread and changed the styling to Blue button instead of red. So now when the user clicks on this "log In" button it takes him to the product details page where he see the correct "stock status" status and "Log in to view price" button.

     

    For now this is working just fine, but now sure if this could create problem in future.


    Importantly,

     

    So now we need to learn why ctrl_purchase is false.

     

    Is it because the "Hide prices until logged in" is enabled ?

     

    If that’s the case then the changes I’ve done won't affect the "if conditions" and I'm good to go.

  6. Here the output :

    array(53) {
      ["product_id"]=>
      string(4) "1289"
      ["status"]=>
      string(1) "1"
      ["product_code"]=>
      string(10) "852KGZO686"
      ["quantity"]=>
      string(1) "1"
      ["description"]=>
      string(0) ""
      ["price"]=>
      string(6) "£x.xx"
      ["sale_price"]=>
      string(6) "£x.xx"
      ["cost_price"]=>
      string(4) "0.25"
      ["name"]=>
      string(39) "Blac Normal"
      ["cat_id"]=>
      string(1) "5"
      ["popularity"]=>
      string(1) "8"
      ["stock_level"]=>
      string(3) "952"
      ["stock_warning"]=>
      string(3) "100"
      ["use_stock_level"]=>
      string(1) "1"
      ["digital"]=>
      string(1) "0"
      ["digital_path"]=>
      string(0) ""
      ["product_weight"]=>
      string(5) "0.000"
      ["tax_type"]=>
      string(1) "0"
      ["tax_inclusive"]=>
      string(1) "1"
      ["featured"]=>
      string(1) "1"
      ["seo_meta_title"]=>
      string(0) ""
      ["seo_meta_description"]=>
      string(0) ""
      ["seo_meta_keywords"]=>
      string(0) ""
      ["upc"]=>
      string(0) ""
      ["ean"]=>
      string(0) ""
      ["jan"]=>
      string(0) ""
      ["isbn"]=>
      string(0) ""
      ["date_added"]=>
      string(19) "2013-03-28 14:37:52"
      ["updated"]=>
      string(19) "2013-06-09 12:06:02"
      ["manufacturer"]=>
      string(2) "15"
      ["condition"]=>
      string(3) "new"
      ["brand"]=>
      string(0) ""
      ["gtin"]=>
      string(0) ""
      ["mpn"]=>
      string(0) ""
      ["ctrl_sale"]=>
      bool(false)
      ["description_short"]=>
      string(0) ""
      ["price_unformatted"]=>
      string(4) "4.99"
      ["sale_price_unformatted"]=>
      string(4) "0.00"
      ["ctrl_purchase"]=>
      bool(false)
      ["out"]=>
      bool(false)
      ["thumbnail"]=>
      string(49) "http://www.abc.com/images/cache/01.100.png"
      ["category"]=>
      string(49) "http://www.abc.com/images/cache/01.150.png"
      ["subcategory"]=>
      string(49) "http://www.abc.com/images/cache/01.100.png"
      ["gallery"]=>
      string(48) "http://www.abc.com/images/cache/01.50.png"
      ["normal"]=>
      string(49) "http://www.abc.com/images/cache/01.300.png"
      ["enlarge"]=>
      string(49) "http://www.abc.com/images/cache/01.600.png"
      ["small"]=>
      string(49) "http://www.abc.com/images/cache/01.150.png"
      ["medium"]=>
      string(49) "http://www.abc.com/images/cache/01.300.png"
      ["magnify"]=>
      bool(true)
      ["large"]=>
      string(49) "http://www.abc.com/images/cache/01.600.png"
      ["source"]=>
      string(46) "http://www.abc.com/images/source/01.png"
      ["review_score"]=>
      bool(false)
      ["url"]=>
      string(66) "http://www.abc.com/index.php?_a=product&product_id=1289"
    }
    ,string(0) ""
    

    and............

     	Smarty_Variable Object (3)
    ->value = 0
    ->nocache = false
    ->scope = "file:skins/vector/templates/element.p..."
    $CART_TOTAL 	Smarty_Variable Object (3)
    ->value = 0
    ->nocache = false
    ->scope = "file:skins/vector/templates/element.p..."
    $CATALOGUE_MODE 	Smarty_Variable Object (3)
    ->value = ""
    ->nocache = false
    ->scope = "file:skins/vector/templates/element.p..."
    $CHARACTER_SET 	Smarty_Variable Object (3)
    ->value = "UTF-8"
    ->nocache = false
    ->scope = "file:skins/vector/templates/element.p..."
    $CONFIG 	Smarty_Variable Object (3)
    ->value = Array (112)
      store_name => "abc efg"
      store_address => "Business Centre .."
      store_country => "826"
      store_zone => "471"
      store_postcode => "UB2 4AB"
      default_language => "en-GB"
      default_currency => "GBP"
      product_prices_include_tax => "0"
      basket_tax_by_delivery => "0"
      google_analytics => ""
      enable_reviews => "1"
      basket_order_expire => ""
      catalogue_sale_mode => "0"
      catalogue_sale_percentage => ""
      catalogue_sale_items => ""
      recaptcha => "0"
      admin_notify_status => "2"
      no_skip_processing_check => ""
      catalogue_hide_prices => "1"
      catalogue_mode => ""
      auto_save_cart => "1"
      allow_no_shipping => ""
      disable_shipping_groups => ""
      cookie_dialogue => "1"
      catalogue_products_per_page => "100"
      product_sort_column => "condition"
      product_sort_direction => "ASC"
      catalogue_show_empty => "1"
      product_precis => ""
      default_directory_symbol => ""
      catalogue_expand_tree => "1"
      basket_jump_to => "0"
      disable_checkout_terms => ""
      default_rss_feed => ""
      catalogue_latest_products => "1"
      catalogue_latest_products_count => "100"
      catalogue_popular_products_count => "100"
      catalogue_popular_products_source => "0"
      skin_folder => "vector"
      skin_style => "green"
      admin_skin => "default"
      skin_change => "0"
      skin_folder_mobile => "mobile"
      skin_style_mobile => "green"
      disable_mobile_skin => "0"
      download_expire => ""
      download_count => ""
      download_custom_path => ""
      stock_level => "1"
      basket_out_of_stock_purchase => ""
      stock_warn_type => "0"
      stock_warn_level => "10"
      product_weight_unit => "Lb"
      show_basket_weight => ""
      basket_allow_non_invoice_address => ""
      stock_change_time => "2"
      hide_out_of_stock => "1"
      store_title => "abc efg Limited"
      store_meta_description => "abc efg hij..."
      store_meta_keywords => "Mobile, mobile phone, ip..."
      seo_metadata => "0"
      seo => "0"
      seo_method => "0"
      seo_trackbacks => "0"
      ssl_force => "0"
      ssl_path => ""
      ssl_url => ""
      standard_url => "http://www.abc.com/shop"
      offline => "0"
      offline_allow_admin => "0"
      offline_content => "<br /><i>r</i><i>n</i>"
      license_key => "xxxxxxxxxxxxxxxxxxxxxxxxxxxx"
      email_method => "mail"
      email_name => ""
      email_address => ""
      email_smtp_host => ""
      email_smtp_port => ""
      email_smtp => "0"
      email_smtp_user => ""
      email_smtp_password => ""
      debug => "0"
      debug_ip_addresses => ""
      cache => "0"
      cache_memcache_list => ""
      proxy => "0"
      proxy_host => ""
      proxy_port => ""
      time_format => "%Y-%m-%d %H:%M"
      time_offset => ""
      time_zone => "UTC"
      feed_access_key => ""
      store_copyright => "<p> <strong>(c) 2013 www.abc.c..."
      product_clone => "1"
      product_clone_images => ""
      product_clone_options => ""
      product_clone_acats => ""
      product_clone_code => "1"
      product_clone_translations => ""
      product_clone_redirect => ""
      lkv => "xxxxxxxxxxxxxxxxxxxx"
      adminFile => "admin.php"
      adminFolder => "admin"
      dbdatabase => "abc"
      dbhost => "mysql213"
      dbprefix => ""
      dbusername => "abc"
      encoder => "ioncube"
      installed => "1"
      rootRel => "/"
      storeURL => "http://www.abc.com"
      bftime => "600"
      ssl => false
    ->nocache = false
    ->scope = "file:skins/vector/templates/element.p..."
    $COPYRIGHT 	Smarty_Variable Object (3)
    ->value = "<p> <strong>(c) 2013 www.abc.c..."
    ->nocache = false
    ->scope = "file:skins/vector/templates/element.p..."
    $CURRENT_PAGE 	Smarty_Variable Object (3)
    ->value = "http://www.abc.com/index.php?_..."
    ->nocache = false
    ->scope = "file:skins/vector/templates/element.p..."
    $GLOBALS 	
    
  7. Alrightyyy, I found the file with the issue.

     

    It is element.product.php

     

    This is the code :

    					{if ($product.ctrl_stock || $product.ctrl_purchase) && !$CATALOGUE_MODE}
    						<a href="#submit" class="btn btn-primary" title="{$LANG.catalogue.add_to_basket}">
    							<i class="icon-shopping-cart icon-white"></i> {$LANG.catalogue.add_to_basket}
    						</a>
    					{elseif !$CATALOGUE_MODE && $LANG.catalogue.out_of_stock_short}
    						<a href="{$product.url}" class="btn btn-danger">
    							<i class="icon-shopping-cart icon-white"></i> {$LANG.catalogue.out_of_stock_short}
    						</a>
    					{/if}
    

    The "If" condition is not true (I have no idea why !!) so it goes inside the elseif (whicch shouldn't happen.)

  8. By "front end", which pages are you referring to? The Latest Products on the Homepage, the list of products in a View Category page? The View Product page? Or everywhere?

    The page which ends in  " /index.php?_a=category&cat_id=XX". I'm newbie to cubecart so it would be really helpful if you could help me find out which file is it.

    Weird thing is when I click on the out of stock button it takes me to the product details page and there it displays "in stock".

     

    In admin, Store Settings, Stock tab, please enable "Show stock levels". Then visit that Product's page. There should be an indication of the stock level somewhere near the price.

    I tried it and the stock status says in stock in the frontend (on the product details page, the one with Zoom Image.)

     

    What is the name of the skin your store is using?

    Vector.

  9. Thank you so much !!

     

    The problem is resolved now, I installed a free version of cube cart (latest one) and copied the catalogue.class file from it to my live installation and it worked.

     

    however, there are many other issues as well so I was curious to know can I upgrade my website to the latest version without disturbing the "Theme and other Plugins."

     

    or would it affect the theme or any other settings.

     

    Thanks again :-)

  10. Heyy Thanks,

     

    It says 5.2.1 in the Dashboard > Store Overview.

     

    Its exactly the same issue as YnZs's , I get "undefined" when delete the quantity discount option.

     

    My options are set as :

     

    Retail price is 13$.

     

    Option 1 : Price 12$ > quantity 10.

     

    Option 2 : Price 10$ > quantity 12.

     

    but when I update it in the basket it takes price as 10$ for all quantities over 4.

     

    Thanks !!

×
×
  • Create New...