traylor23
-
Posts
104 -
Joined
-
Last visited
Posts posted by traylor23
-
-
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!
-
30 minutes ago, bsmither said:
Quick question: are you able to make a small edit to the core code?
Should be fine and able.
-
Much appreciated. I look forward to seeing what you come up with.
-
9 hours ago, bsmither said:
So, if the product's description made mention that this card/player is associated with the Cincinnati Bengals, how would CubeCart's search not find this?
I assume, then, that for good reason, the description will not or cannot make this mention. Maybe using GTIN is a more broadly appropriate solution?
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.
-
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. -
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. -
Interesting. I’ve had other types of intrusions, but not this. Been on CC for at least 10 years. Thanks for the feedback!
-
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 -
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.
-
Thank you, both, for the help. I really appreciate it!
-
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.4 minutes ago, traylor23 said: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.
-
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. -
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!
-
Thank G-d!
-
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.
-
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 -
Just now, bsmither said:
Do you have a website we can look at?
Ballcardz.com
-
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
-
I accidentally dropped the index CubeCart_category.cat_parent_id
Of course I didn't back the db up before. Please help :-<
-
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
-
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.
-
8 hours ago, Dirty Butter said:
It may b too late now to be of any use to you, but I mentioned this thread to Daren of SFWS, and here's his reply concerning his Search plugin:
#1
Utilize the custom search field introduced via the AJAX Search plugin to specify the product codes from the options matrix.
e.g.
#2
Configure the plugin to only search that field, matching all keywords.
e.g.
He suggested another alternative would be to alter the standard search so it looks at the 'product_code' field in the 'CubeCart_option_matrix' table directly.
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!
7 hours ago, bsandall said:I'm not sure why your category SEO paths are all set to custom=1 (perhaps they are indeed custom paths?), but the naming / display issue for custom paths is a result of this change - I have submitted a fix.
This worked perfectly, by the way. Thanks!
-
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.
-
All cool stuff, and I really appreciate the help. Trying to implement Brian's Custom Search edits, but I have run into an annoyance, at least on the admin side of things, that's different since upgrading to v6.1.3. Basically, any category that I created, and used a custom seo url for, is now showing up in my add a product pages, where you would select a category, differently than they ever have before, making finding the categories difficult. Well, I was able to track this back to the database and see that all of these new cats were assigned a custom tag of 1, and when I made all of them 0 again, everything was back to normal. Every time I add a new category, I have to go clear this 1 designation for it to look correct and be in the right order. I have included a couple of pictures to demonstrate what I'm talking about. Does anyone know of a way I can stop the new categories from gaining this 1 designation? Also, if I forgo using the Custom URL and then update it later, the update causes the 1 to be designated.
Thanks!
Including Product Identifiers in Search Results (UPC, ISBN, JAN, MPN, etc).
in Customising Look & Feel
Posted
Flawless execution. Thank you, so much. Happy Holidays!