Jump to content

keat

Member
  • Posts

    1,614
  • Joined

  • Last visited

  • Days Won

    27

Posts posted by keat

  1. I have installed Cube Cart version 3 and am currently setting up the store.

    Today i was testing the freight handling and tried to check out some items to see if it worked correctly.

    Suddenly my site crashed and I get the error message:

    MySQL Error Occured

    1064: 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

    QUERY = SELECT productId, image, price, name, sale_price FROM CubeCart_inventory WHERE `showFeatured` = 1 ORDER BY productId DESC LIMIT

    I am not that technically savvy and have no idea as to what I should do to fix my site.

    Does anyone have a clue?

    Maybe try to change the freight handling to a diferent module.

    Or you could try to repair the database in your hosting control panel.

    In my host control panel is a section "My SQL Databases" from here I can check or repair the DBS.

    Failing that, maybe try to restore the DBS. But I guess as you've only just started building/playing.. a backup was the last thing on your mind..??

  2. Did you try the language file? root/language/en/lang.inc.php

    And then the root/includes/content/reg.inc.php

    I had a play around with includes/content/reg.inc.php, but couldn't seem to find the section that deals with the "subscribe to store emails" check box though.

    I had considered, (if I could locate the code), turning it into a "check this box to opt out" option.

    Being a newbie to PHP, its all a massive learning curve.

    Not sure my old brain can keep up.

  3. Nope.. I can't find it. I've played all morning, and can't figure it out.

    I also spent the best part of 2 hours scouring the net.. I can't believe, no ones done this before now.

  4. Guys.

    How do I have the contents of a box appear in the center.

    I've added the following code to the left hand column

    <div class="boxTitleRight">Catalogue Download</div>

    <div class="boxContentLeft">

    <p><a href="http://www.mysite.co.uk/44963%20catalogue%20v8.pdf">

    <img border="0" src="http://www.mysite.co.uk/webimage/download_icon.jpg" width="150" height="90"></a></p>

    <border="0" >

    </div>

    <div class="boxFootRight">&nbsp;</div>

    I'd like the icon.jpg to appear in the center of the box.. is this something very simple to do ??

    Thanks in Advance

    Doh... I just figured it out

    <p align="center">

  5. I don't have the answer, but we've seen something similar with CC3.16.

    Customers have been able to log in and order, then a few months later, their password is rejected.

    And because they already have an account, they can't create another one.

    Only solution we found, is to delete the account, so the customer can create another one

  6. The question doesn't really make much sense to be honest.

    Are you asking for the cubecart admin password ??

    If so, apparently, you can find it by usisng PHP Admin, from your hosting control panel.

    Don't know how though.. I've never done it

  7. I over came the compressed classic skin by changing the px sizes to a percentage value.

    Now the skin fills 95% of the screen regardless of what screen resoulution you have.

    I had a small issue with the prices and contents of the top right hand basket.. they were falling outside the box on smaller screen resolution sizes.

    Easy.. I moved the basket to the left hand column.

  8. OK.. I found the code in ViewCat.tpl

    It goes like this.

    <!-- BEGIN: buy_btn -->

    <input type="hidden" name="add" value="{PRODUCT_ID}" />

    <input type="hidden" name="quan" value="1" />

    <a href="java script:submitDoc('prod{PRODUCT_ID}');" target="_self" class="txtButton"> {BTN_BUY}

    Remove this section from veiwCat.tpl, there is no longer a "buy" button.

    Then in lang.inc.php, change the phrase 'more' => "More" to say something like 'more' => "Buy Now".

    I now only have one button, which takes me to the view page, where I can order the product.

  9. I've already changed the "more" button to say "view" in the language file.. at least this makes it a little less confusing.

    One of my business partners already has a basic website, which he paid to have done.

    To be honest, it's no better than the one I'm doing.

    I've just had a look to see how they did it.

    It looks like they removed the "buy" button..

    I might just follow suit.. !! now lets see if I can find the code

  10. Maybe the title doesn't really explain.

    Currently using CC3

    When you enter into a product catagory, and see the list of products, there are 2 buttons on the right of each item.

    "buy" & "more"

    If you click the buy button, it will automatically add the part to your basket. (not a problem)

    However, it then redirects you to the view mode of this item, where there is an "Add to basket" button at the bottom.

    It's very easy, to not realise, by previously clicking the "buy" button, you've already added the item to your basket, so you could now inadvertantly click the "add to basket" button, thus ordering the same item twice.

    I've done this in testing, a number of times, and questioned my own sanity.

    Is there a way to overcome this.. Maybe configure CC3 so it doesn't redirect you to the item page, if you use the "buy" button.

    Or maybe something along the line "This item is already added to your basket" message

  11. In the end.. we decided to change to the classic skin. Created my own background, moved some boxes around, and it looks a lot better.

    Certainly less cluttered.

    I now have another question, but I'll start a new thread.

    Thanks for the info regarding the css file.. I'm learning quite a lot.. changed a few things in layout.css, index.php and the language file.

    Really enjoying it

  12. I guess the main reason I went for Killer, some of my catagories have long names ie "Specialist and Hole Clearance Sizes", in any other skin, it scrolls on to 2 lines, plus the other skins don't seem to fill the page.

    Unless there's a way to stretch them

  13. Its not a quick job by the looks of it but its a case of altering these in the skins/killer/stylesheets/layout.css including resizing the image heights. to correspond with the stylesheet classes.

    .topCats {

    text-align: center;

    background-image: url(../styleImages/backgrounds/catBg.gif);

    height: 60px;

    color: #ffffff;

    margin-bottom: 15px;

    }

    .topCatsBgRight {

    background-image: url(../styleImages/backgrounds/catBgRight.gif);

    background-repeat: no-repeat;

    background-position: right;

    height: 60px;

    }

    .topCatsBgLeft {

    float: left;

    background-image: url(../styleImages/backgrounds/catBgLeft.gif);

    background-repeat: no-repeat;

    background-position: left;

    height: 60px;

    }

    hI FANDANGO.

    I tried what you said. I increased the gifs from 42px to 60px in photoshop, them altered the html in layout.css, but this didn't work.

    It sort of sent the gifs a little crazy, and chopped all the bottoms off.

    I'll try again later this evening when I get home.

    Thanks for your help so far.

  14. Guys.

    I'm using CC3, not really bothered too much about fancy templates, so am using the standard "killer" template.

    As I increase the nmber of product catagories, some of the catagory tabs along the top, are now starting to squash up slighly, resulting in some of the wording being pushed out..

    Hopefully, a screen shot is attached.

    How do I increase the size of the tabs to account for this ??

    Thanks again

  15. It looks detailed, but do-able. It obviously requires a considerable amount of planning and downtime.

    I guess an alernative, would be a new V4 install in another directory, or subdomain, then to migrate the data across.

    This would atleast allow me to tweak V4 and get it running nice, before going live.

    What are the main advatages to running V4 as opposed to V3.

    This is my 1st E-Commerce site, if I can make it work, then it could be one of many.

    It may not be worth upgrading this site to V4, but I might invest in V4 for any future sites.

  16. OK. I think I figured this one out.. well to do what I want it to at least.

    I have no need for all the country codes, as we don't intend selling off shore, so I removed them all apart from the UK related ones.

    I then added a new country code for the channel islands.

    This seems to have done what I wanted.

    Channel Islands is now Vat free

×
×
  • Create New...