Jump to content

markscarts

Member
 View Profile  See their activity

  • Posts

    2,486

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Posts posted by markscarts

    Broken Images - DB issue?

    in Technical Help

    Posted

    Thx I saw that about the three hex bytes while googling earlier, am interested in seeing the database table now but still haven't gotten access yet. I noticed that CC4 went to varbinary instead of varchar for the image names as opposed to CC3, also it seems CC3 specified collation of that field as latin1_swedish_ci and the field was not null. In CC4, no collation is specified when the field is created (some other inventory fields are specified as utf8_unicode_ci) and the field accepts null.

    Not sure why those changes were made in CC4, but it'll probably be more important to see if the store owner's db has collation specified for the image field - or what the default collation is for his db.

    I really appreciate your sharing the troubleshooting technique, I will try it in the meantime to see what's being sent.

    Broken Images - DB issue?

    in Technical Help

    Posted

    I've been checking out a 4.4.7 install, slightly modded store, and there is some strange behavior I do not understand. It appears that when saving a product image to db, characters are added to end of product name into db field, thus ruining path and breaking images in store front.

    Here is an example: http://www.love-bird...od&productId=13

    On that page, NOTE the alt text that appears just above the image gallery, alt text for main product image is "Pay GBP20". If you right-click and view image info, you will see the issue.

    You will see the image name is FUBARed:

    
http://www.love-birds-weddings.com/images/uploads/DSCN2116_344.JPG%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD


    



I have checked the code for updating db field, and see no problem there:





    
$record['image'] = $db->mySQLSafe(imgPath($_POST['imageName'], false, ''));

    Likewise, the imgPath() method seems fine. Any ideas?

    CC: 4.4.7

    PHP: 5.2.17

    MySQL: 5.1.63-cll

    BTW, I have replaced rte directory with one from 4.4.6 as suggested by C support in another thread. I have not yet checked the db directly (waiting for access just now).

    customize product show vertical to horizontal

    in Customising Look & Feel

    Posted

    Hello ravuth. As bsmither has already answered, you have to "customize skin" as you originally asked, and you can do it by following his basic instructions . . .

    In other words, you have to edit the html and the smarty tags in the two files he mentions. You prefer a "gallery view" for your products, but your skin shows products in a "list view" on the category page. So, you need to use the "gallery view" code from latest products found in skins/<your_skin>/templates/content.homepage.php and adapt that code to the other file for category view page which is skins/<your_skin>/templates/content.category.php

    Just pay attention to the post from bsmithers, he has given you the gist of what needs to be done. Use a text editor and keep a backup copy or the original skins/<your_skin>/templates/content.category.php in case you make a mess and need to start over.

    Additional Documents and how to link/present them?

    in Install & Upgrade Support

    Posted

    Actually, CC5 already has a hide/show docs feature, you just click the green checkmark or red x to toggle this. As for linking to a "hidden" doc, you'll simply have to write some html in your template where you want the link or side box with links to appear, and hard code it all . . . or create a "side box with links" plugin.

    For your PDF files, how about adding a link to the file in product description (wysiwyg editor)?

    Adding a request box to some products

    in Customising Look & Feel

    Posted

    An Update, I have managed to put the text box next to an item,,,,next problem how do I get the text that a customer would enter to show on the order, any Ideas please

    Thanks

    Did you do this by adding a textarea option to the product, as bsmither suggested, or by some other means? It seems to me that if you have created a textarea option this should work automatically.

    Multiple Domain Front

    in Technical Help

    Posted

    CubeCart (Devellion, Ltd.) does not do any custom work. There are links to resources on the main site for partners and third party developers. There is an unofficial 3rdparty Forum as well where you can discuss modifications and sometimes hire 3rd party developers to do custom work, www.cubecartforums.org

    Resolved - Logo Issues in Mauris Skin

    in Technical Help

    Posted

    Agree with bsmither it is difficult to advise when we are unable to view a live site.

    In the meantime, try adjusting some styles for the mauris skin by looking into skins/mauris/styles/common.css

    In the stock (unmodified) file, around line 93 find this:

    
#header p.logo {

padding-top: 18px;

padding-left: 24px;

margin-bottom: 15px;

}

    This sets styles for the paragraph tag that holds the logo image. You need to change the 18px padding added to the top of the paragraph. Try removing the entire line, "padding-top: 18px;" and see what that gets you, we can refine the adjustment from there. Looking at your screenshot, I'd guess that at the very least you'll have to also either adjust the bottom margin (15px;) or remove it as well, to prevent the paragraph element from "kicking out" the breadcrumb layout.

    Anyway, this should get you started in the right direction :)

    Resolved - Free Documents

    in Technical Help

    Posted · Edited by markscarts

    I can give you a simple hack to replace any 0.00 price in your store with the word "FREE" - note that you will be modifying a core file, so the tweak will not survive upgrades, it would have to be re-added after upgrading because the modified file will be overwritten. It would be better to write a little plugin using the hook system, but this may help you in the interim.

    Open up classes/catalogue.class.php, and find around line 803:

    :glare: To achieve the same effect in Latest Products section, edit yet another core file. Open up classes/cubecart.class.php, and find around line 113: 

    
$product['price'] = $GLOBALS['tax']->priceFormat($product['price']);


    



REPLACE that line with this code:





    
//markscarts edited to replace 0.00 with text

if ($product['price'] == "0.00") {

$product['price'] = "FREE";

} else {

//original line of code

$product['price'] = $GLOBALS['tax']->priceFormat($product['price']);

}


    



Two notes: 1) I use comments to indicate where I've added or changed code in the file, feel free to change comments, 2) The text "FREE" - I like to show it in all caps, but you can put any unadorned text there between the quote marks to achieve what you desire.



OK - So this did not affect Latest Products! 
    
	 $product['price'] = $GLOBALS['tax']->priceFormat($product['price']);


    



REPLACE that line with this:





    
	 // markscarts, edited to replace 0.00 with text

	 if ($product['price'] == "0.00") {

	 $product['price'] = "FREE";

	 } else {

	 // original line of code:

	 $product['price'] = $GLOBALS['tax']->priceFormat($product['price']);

	 }

    And finally, a word on formatting . . . :sourcerer:

    Note: You can use simple html tags (even proprietary ones as in my example) between the quote marks if you need to style your text, but do not use double quotation marks unless you escape them!

    example 1: $product['price'] = "<blink>FREE</blink>";

    example 2: $product['price'] = "<span style="color: lime;">FREE</span>";

    example 3: $product['price'] = "<span style='color: lime;'>FREE</span>";

    well clearly I am not up on the changes

    in General Discussion

    Posted

    Hi lcools, please read this important announcement made some time back. Note, v.4 will suffer a similar fate.

    There is no point discussing how or if things might have been handled differently, CC3 is no longer supported and the software is no longer distributed, so Devellion is not obligated in any way to preserve the forum archives, or if they have, to offer them publicly.

    http://forums.cubeca...e-announcement/

    There are still many CC3 store owners (myself included) and there are still 3rd party developers who service CC3 stores (myself included), and there is a CC3 section for forums as well as documentation. You can find these at:

    http://www.cubecartforums.org/

    Hope this helps.

    By the way, it doesn't help anything to post to the moderator after your thread is locked, it should be apparent that CC3 discussions can no longer be made here, and should be taken to the third party forum instead. Dirty Butter is a very helpful volunteer here, and he means no animosity by locking your topic. I think it might help folks like you if the moderators would use a more explanatory stock reply for these topics that includes some helpful links. Anyway, that is that :)

    Resolved - Tech question - accessing config settings in plugin files

    in Technical Help

    Posted

    @Dirty Butter, yes I am busy perusing the stock CubeCart files, I haven't found an instance where the store email address is retrieved yet.

    @bsmithers, thank you I was hoping you might shed some light. Also, thanks for the tip on showing smarty globals. Presently, I am looking to retrieve a config value for store email for use in a php file as mentioned previously, and it won't be used in the template. You've given me some help with the discussion already, maybe I can figure out how to do this.

    Guides on how to mod or create skins

    in Customising Look & Feel

    Posted

    I do feel your frustration - went through it a bit when CubeCart 3 was released, and CubeCart 4. While my next comments won't probably help to make you feel better, they need saying.

    1. It is ridiculous to think that the code developers can throw together a manual in an hour. Authoring documentation for public consumption is time-consuming, it is not as easy as you think, and developing the script / removing bugs is more important.

    2. Companies who "have it all" - extensive working scripts and full documentation - are companies who have large enough staff to "do it all" - Devellion has a small programming and customer service / tech assistance staff. There is no staff to my knowledge for manning forums, writing documentation, etc.

    3. Moderators here are volunteers, they do not work for Devellion and are not reimbursed for their time in any way.

    4. The documentation for CC4 and CC3 that you can find on cubecartforums.org was all written by people like you who learned the script and shared their knowledge.

    About the PDF idea, I did the same thing years ago with CC3, but really that's not the best solution IMO, it is better to submit it to the documentation project at cubecartforums.org where it will be readily accessible to the community alongside the documentation for CC3 and CC4. Please do contribute, and continue to invite others to contribute. Sooner done, sooner satisfied!

    Please note that cubecartforums.org is not a part of Devellion, Ltd. and we are volunteers there . . . though most of us are also CubeCart third-party developers as well.

    Lastly, I agree that a paid ecommerce solution should be a bit more polished than CC5 . . . but even with its rough edges and lack of documentation, the small development crew well earn their monies, and I have faith in their commitment to excellence. Though much of what I have written can be characterized as a defense of them, I do not represent them nor am I privy to their plans, they may well be planning company documentation, but knowing the small work force of programmers and imagining the tasks they face in developing the software I very seriously doubt they will be authoring documentation any time soon.

    Skin Modification

    in Customising Look & Feel

    Posted

    We'll see about pulling that and some more info together to get some developer docs prepped.

    LOL good luck with all the work you guys have to do on the coding end! Are you really going to stop and author documentation? I hope so, but . . .

    Just a reminder, if you do, PLEASE submit it at cubecartforims.org documentation project. As with CC3 and CC4, there is no documentation shipping with CC5 and we are in dire need of folk to contribute to the documentation there for CC5. Viola, would you consider sending the info above to Rob at cubecartforums.org, and maybe shore it up with some info on gui.class.php as well? It would be a big help to the community IMO . . .

×
×
  • Create New...