Jump to content

traylor23

Member
  • Posts

    104
  • Joined

  • Last visited

Everything posted by traylor23

  1. It works! I jumped the gun, as I didn't clear my browser cache. I'll play around with it and see if there's any unexpected consequences, but for now, it works! Thank you, so much!
  2. Cubecart does a decent enough job with search if it’s keywords in the title or description. The problem for me is workflow efficiency. With as many products as I envision adding, I need the team name to be its own field. Cutting and pasting whole columns of data is way easier than splicing data into existing fields (titles/descriptions). Instead of trying to create a new database item, I figured I’d utilize one that I have no other use for. Just seems easier to me. That being said, I would just like this data to appear in search. Thanks, again, for helping all of us with our rather trivial requests.
  3. Hmm. I appreciate the reply, but I'm not really following what I need to do. I'll give an example of a product, and in turn, I'm hoping I can get some guidance on how specifically to add what I'm trying to allow customers to search for in the easiest terms possible: Here is a link: https://www.ballcardz.com/2018-panini-playoff-42-geno-atkins-football-card Under the "Product Specifications" tab, I have changed the GTIN Code language, to Team, and this player happens to play for the Cincinnati Bengals. I would like for a customer to be able search for all Cincinnati Bengals players by either typing in the whole team name, the city, or just the team name, understanding that if just Cincinnati is typed in, that any other team from Cincinnati will populate, and that's ok. Thanks, as always, for your amazing assistance, BSmither.
  4. I have been trying to search the forums for this solution, and I think I have come close, but not actually found anything that will allow this to happen. It doesn't really matter to me which is searchable, as long as I understand how to make it happen. Thanks in advance.
  5. Interesting. I’ve had other types of intrusions, but not this. Been on CC for at least 10 years. Thanks for the feedback!
  6. I think this is the bulk of the ones that are repeating. Thanks for looking! File: [catalogue.class.php] Line: [2094] "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.stock_level > 0 AND I.use_stock_level = 1) OR I.use_stock_level = 0) AND (I.name RLIKE '[[:<:]]jEGY/**/ORDER/**/BY/**/6415--/**/NTLs[[:>:]]' OR I.description RLIKE '[[:<:]]jEGY/**/ORDER/**/BY/**/6415--/**/NTLs[[:>:]]' OR I.product_code RLIKE '[[:<:]]jEGY/**/ORDER/**/BY/**/6415--/**/NTLs[[:>:]]') ORDER BY `name` ASC LIMIT 500 OFFSET 0 " - Got error 'repetition-operator operand invalid' from regexp File: [catalogue.class.php] Line: [1974] "SELECT `id` FROM `CubeCart_manufacturers` WHERE `name` LIKE '%jEGY'/**/ORDER/**/BY/**/5459--/**/DtDf%' ;" - 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 ''' at line 1 File: [catalogue.class.php] Line: [1974] "SELECT `id` FROM `CubeCart_manufacturers` WHERE `name` LIKE '%jEGY')/**/AND/**/3482=DBMS_PIPE.RECEIVE_MESSAGE(CHR(77)||CHR(85)||CHR(110)||CHR(102),15)/**/AND/**/('UlZF'='UlZF%' ;" - 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 ')/**/AND/**/3482=DBMS_PIPE.RECEIVE_MESSAGE(CHR(77)||CHR(85)||CHR(110)||CHR(102),' at line 1 File: [catalogue.class.php] Line: [1974] "SELECT `id` FROM `CubeCart_manufacturers` WHERE `name` LIKE '%jEGY'/**/AND/**/3482=DBMS_PIPE.RECEIVE_MESSAGE(CHR(77)||CHR(85)||CHR(110)||CHR(102),15)/**/AND/**/'JbFw'='JbFw%' ;" - execute command denied to user 'ballcard'@'localhost' for routine 'DBMS_PIPE.RECEIVE_MESSAGE' File: [catalogue.class.php] Line: [1974] "SELECT `id` FROM `CubeCart_manufacturers` WHERE `name` LIKE '%jEGY'/**/WAITFOR/**/DELAY/**/'0:0:15'/**/AND/**/'xFcc'='xFcc%' ;" - 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 'WAITFOR/**/DELAY/**/'0:0:15'/**/AND/**/'xFcc'='xFcc%'' at line 1
  7. Title says it all. Attached is my error log. Threw it up in comparison tool, and it was the same as the freshly downloaded version. My orders have screeched to a halt. Not sure if this is a cause, or if it is coincidental.
  8. Added the 3 lines to classes/catalogue.class.php, resaved all my categories, cleared cache, and it did not resolve the problem that I am having. The good news is that I do have a direct fix in just restoring 6.4.7, and it completely fixes the issue for me. Thanks for the timely response. Hoping that I can figure this out. I'm going to stop messing with it, for now, and see what other info can be gleaned from what I've shared. Ok...so, I just disabled the "Hide out of stock products," and it reverted back to working properly. So, this is the issue. It doesn't answer the database error that has popped up, which is still there, but it is a temporary fix for the links being broken. I usually delete all out of stock items promptly, so it's not too big of an issue, but would be nice to work properly.
  9. Hello All, I have replicated this issue twice. The first time, I thought it was something I did, but now that I've gone through the upgrade process again, I can confirm that it was the upgrade process that broke something. Here is what is happening. When I click on my main categories, some of them are either broken links, or link to other categories. Even though the URLs are correct in Admin, and in the address bar, what is being returned is either a page not found, or a different page altogether. This is not throwing any errors in the error log, that I can see, but there is a database error, and it is as follows: ballcard_ccrt01.CubeCart_extension_info 10 InnoDB utf8_unicode_ci 32 kB - CubeCart_extension_info.seller_id has a key type KEY but expecting key. What could have caused this? How can it be fixed (short of reverting to 6.4.7)? Thank you all in advance. Matt Ballcardz.com (the problem can be experienced by clicking the first four links in Shop by Category, but is not exclusive to those links.
  10. Got it all fixed, including the highlighted database errors. Thanks to this forum, or I'd have to switch carts. Special thanks to @bsmither, @Dirty Butter and @havenswift-hosting. You folks are most helpful, and we're highly grateful for you!
  11. Yep. Already thought of this. The backup for my hosting happened on 11/12, and there have been hundreds of categories and products added/removed since then, and no backup within cubecart. Oh well. Tedious lesson learned. I really appreciate your help, as always. After I get these cats reassigned, I will need to revisit this, as I'm having the same KEY/PRIMARY database errors that led me to this thread.
  12. That is correct. What happened is, that I was trying to fix an error that was listed here, went to the Structured column under Cubecart_category, and hit DROP. It was a mistake. I didn't catch it before it was gone. And, now, it appears I'm going to have to manually reassign all of these categories. If there's another way, that'd be awesome! Reggie Jackson should be under the following Category Tree: All Baseball Cards --> Last Names - J --> Jackson, Reggie
  13. I have no clue what I'm doing. When I drop in the code into the SQL section of Cubecart, it tells me that 1 line was affected, but it makes no changes that I can see to the database table. This thing has literally unassociated every category from it's parent category. This happened under the structure tab in phpMyAdmin
  14. I accidentally dropped the index CubeCart_category.cat_parent_id Of course I didn't back the db up before. Please help :-<
  15. Hey Noodleman,

       I've seen you help another user with really slow loading times on the admin side of their website. Is there any way I can get you to look at mine, and see if there's a way to speed things up? (over a minute for most loads).

    Thanks,


       Matt

  16. Hey There...for some reason, Cubecart's site won't let me message you. Is there a way to add a background image to the skin, and is there any way to have the products in list view by default? Thanks, Matt
  17. I'm getting this same error, but it's saying from thumbs.db instead of the index.htm. Before I deleted the index.htm, it was giving me both errors.
  18. That mod looks like it would do exactly what I want it to do. I'm still playing with Brian's edits in a cloned store. Not having any trouble, just haven't had time to mess with it. If that doesn't appear to be a solution, this might. Thanks for sharing! This worked perfectly, by the way. Thanks!
  19. Great stuff, bsandall! Haven't tested it yet, but I'm sure it'll be fine. Still having a problem with my pictures auto-assigning to products after I did the 6.1.3 upgrade, but I'm sure that's something I didn't do right.
×
×
  • Create New...