Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by foz1234

  1. i may have spoken to soon, i now get a different error File: [catalogue.class.php] Line: [1715] "SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name fulltext '%t8%' OR I.description fulltext '%t8%' OR I.product_code fulltext '%t8%') LIMIT 12 OFFSET 0 " - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fulltext '%t8%' OR I.description fulltext '%t8%' OR I.product_code fulltext '%t8' at line 1
  2. I have put back the two manual patches that were suggested by al from the upgrades 6.1.2 & 6.1.4 back to the standard 6.1.1 files and it seems to have cured the problem. As yet no errors have shown in either log so i will continue to test for the next few hours then look to upgrade. I believe 6.1.7 is imminent ? so i may hang fire on the upgrade if this is the case? once again Brian thank you for your time and experienced guidance with my issue.
  3. Hi Brian thank you for your help mate followed the above instructions and i get Debug Messages: [0] Out of Stock Where is: Memory: Peak Usage / Max (%): 2.46MB / 128M (1.92%) Cache (File): Enabled Cache Used: 0.58 KB of 475.56 KB (0.12%) [Clear Cache] Page Load Time: 0.212754 seconds I've pm'ed you the full debug mate
  4. what would you suggest Brian? i have compared the working catalogue.class.php to one from stock 6.1.1 file and they match no edits may not be related but looking back through the logs it happed around the time i edited this https://github.com/cubecart/v6/commit/8f1ec4e87c58e60e7fd865eabc6a1ab2b721729c
  5. lines 95-99 if ($GLOBALS['config']->get('config', 'catalogue_latest_products')) { $query = sprintf("SELECT I.* FROM `%1\$sCubeCart_inventory` AS I JOIN `%1\$sCubeCart_category` AS C ON C.cat_id=I.cat_id AND C.`status`=1 AND $where ORDER BY I.date_added DESC, I.product_id DESC", $GLOBALS['config']->get('config', 'dbprefix')); $latestProducts = $GLOBALS['db']->query($query, (int)$GLOBALS['config']->get('config', 'catalogue_latest_products_count')); if ($latestProducts) { foreach ($latestProducts as $product) { was this something to do with a security issue that i had to put the cubecart.class.php from 6.1.3 into 6.1.1 save updating from memory but memory is not what it used to be lol. shall i just upload the cubecart.class.php from 6.1.1 ? i want to get on to the latest version asap but seeing the problems people were having recently i hung back should i be able to cpanel upgrade from 6.1.1 to 6.1.6 without many problems? thanks again Brian
  6. All sorted Ian thank you, i had updated to php 7.1 but seems as yet ioncube is not supported, so i ended up on php 7.0
  7. no Brian not as i am aware of mate, only edits i have ever applied are what you have suggested over time for different things. where is that code i can check?
  8. hi just wondered what this error was if anyone can help, takne from admin error log? File: [cubecart.class.php] Line: [97] "SELECT I.* FROM `CubeCart_inventory` AS I JOIN `CubeCart_category` AS C ON C.cat_id=I.cat_id AND C.`status`=1 AND ORDER BY I.date_added DESC, I.product_id DESC LIMIT 9" - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY I.date_added DESC, I.product_id DESC LIMIT 9' at line 1 thanks
  9. i have a paid licence code now ian, but we had to downgrade the php or the ioncube version back in November to run it, so now going back to php7 (because its noticeable faster) but wasn't sure if to delete the other version first or just run the new version with token
  10. is it as simply as just running the token upgrade Ian or will i have to delete other version first? with them being the same version number?
  11. thanks Ian showing in the market also now.
  12. after reading up on this issue, it would seem most guides recommend using rel=canonical tag in the document header into the page i want indexing and rel=canonical & noindex tag in the page=2-7 but with cubecart how do i enter these tags? i don't see anywhere to enter the code in document source? or with Cubecart do i need to set up each ?page=2 etc as a 301 redirect?
  13. i had an issue but i can't remember what problem it caused, but i had to downgrade php version from 7 down to 5.6.30 for this plugin to work correctly, may or may not be related to your issue. Did you ever update this Ian to run on php 7?
  14. May i ask how i fix this Ian, i will but struggling to know where to fix these issues in google with url parameters, .htaccess or robots.txt ? thanks again for your help
  15. Are we 100% sure google does not see this as duplicate? .html .html?page=1 .html?page=2 According to google webmasters HTML Improvements it does Duplicate meta descriptions Meta description information can give users a clear idea of your site's content and encourage users to click on your site in the search results pages. i have 7 url's showing as duplicate 5 with .html?page=1.2, etc up to page 7 1 with /index.php?_a=contact, /index.php?_a=register, /login.html, /our-youtube-channel.html & /sale-items.html 1 with html?page=3&set_currency=AUD, html?page=3&set_currency=CAD, html?page=3&set_currency=JPY & html?page=3&set_currency=EUR robots file User-agent: * Allow: /*page=all Disallow: /?page= Disallow: /*?seo_path= Disallow: /*html? Disallow: /*?set_currency
  16. i have spotted in my webmasters for a while now crawl errors where it seems its cut the url off or its added a forward slash on the end, completely random not the same one each time eg:- https://www.domain.com/best-vpn-f https://www.domain.com/shop.html/
  17. This is somewhat contradictive, you say Google DOES NOT have a duplicate content penalty, yet if you intend duplicate content to manipulate search engine it does? who decides this? so i am assuming that it does have a duplicate content penalty but i think you are saying not in this case regarding the index.php this also seems to go against what haven swift has said "You should definitely only ever have one url that points to each page" i am only asking because i am trying to understand.
  18. these are separate /index.php?page=0 /index.php? if i am honest all I've done is confused myself further, keep trying to get my seo on the home page rankings up within google but its no where to be seen yet its page 2 on bing same search so google penalising me for something for sure, yet as I've said above and in other thread the products are fine showing page 1 or 2 in google its just frustrating the hell out of me.
  19. it would be nice if someone could post how to stop this /index.php resolving to the same address as the domain Keat does your site resolve theses /index.php?page=0 - /index.php? & /index.php. to the same home page?
  20. the documents custom URL part was not about seo duplicate content really although the site map generated by cc creates an entry for that url in the sitemap is this correct? along with the https://www.domain.index.php i noticed the currency creates 5 duplicate pages so i made an entered in robots text file, so now its this User-agent: * Allow: /*page=all Disallow: /?page= Disallow: /*?seo_path= Disallow: /*html? Disallow: /*?set_currency but these all resolve to my home page https://www.domain/ index.php?page=0 & index.php? as well as index.php
  21. i am confused, does it not automatically generate one? Custom SEO URL Path * * This will be generated automatically if left empty? I've also noticed it resolves to the same page with index.php?page=0 & index.php? as well as index.php is this just me or am i missing something here
  22. the custom url is created in - admin - dashboard - documents - site documents / home page - search engines tab - Custom SEO URL Path * this is were i edit my home page
  23. hi, I've sorted the www redirect and changed from merge to replace globe meta with individual seo for each url. surprised i needed to redirect the https://www.domain.com/index.php to https://www.domain.com/ thought that would have been included in the cubecart .htaccess ? so its looking like i do have duplicate pages for the home page, this would point to my problem as i said before its only the home page seo i seem to struggle with. i am confused about the url in the sitmap that also points to the home page? https://www.domain.com/Custom-SEO-URL-Path..html ? so i should really only end up with 1 home page? just the domain or the Custom SEO URL Path in documents? thanks
  24. Quick question regarding duplicate pages for seo, i am still trying to get to the bottom of my problem, i am assuming this is ok but wanted to ask, i have no landing page, the domain opens in to Cubecart, the url opens https://www.domain.com or https://www.domain.com/index.php is this correct? i also noticed that the sitemap maps a page to the documents home page search engine seo url path so that would be 3 of the same page? although the sitemap does not map a page to just the domain url only the index.php extension is this correct? thanks for your input in advance
  • Create New...