Jump to content

Chargin

Member
  • Posts

    171
  • Joined

  • Last visited

Posts posted by Chargin

  1. Ive run this mysql query but I now have multiple listings for homepage on the permissions page... Ive attached an image to show what I mean.

    Everything seems to be working fine but I now need to do this same thing to another site, Im wondering if I should alter the query somehow??

  2. I really need to have a client be able to edit their own homepage text, as a non super user the homepage link doesnt appear as a link in the admin panel, only "sitedocs" does but homepage isnt in there of course. How can I have them as a non super user and edit the Homepage?

    Also why is this treated seperately from the rest of the "sitedocs" anyway? I understand the 777 permissions on the file, but it should still be under "sitedocs" if you ask me..

  3. Im in the same boat as you guys. Im on 3.0.10, all I really care about I guess is getting the security fix, none of the other changes mean much to me. I have 5 stores to edit, how do I just apply the security patch? I mean can this be done the same as a MOD, edit this past that and your done. All my stores have so many mods I wouldnt even want to think about reapplying all the mods, it would take me ages.

    Ahh Im an idiot, to do this go here

    http://www.cubecart.com/site/forums/index....showtopic=21247

    Its only a few files that need to be uploaded, none of which should have been modded by anyone, phew, I was sweating for a moment there.

    Ill go for 3.1 when that comes out..

  4. Just tried changing the names within the downloaded sql file to the same name as the database thats already on the site Im trying to import to and I get this..

    Error

    There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:

    ----BEGIN CUT----

    eNplUElSwzAQvOsVc8jRm4yJgzgJR5WkKhuWCcdEXoq48IatLH5bDjyJLyCFChw4TNVUT093z7Aw

    XIUEAgyBC3O2JIDBBXeIEY8UfkEo2HACg1lKoPsoGtF2WWsVeWw1+8Y4gmt5PriOM7QdbGMfsE8c

    l9w5kPRxLbeyBHZuYIAWPX+eE/Asx3J9s5OiSkWbohcewoobQCdsGRmwYcrzNa9gxmBoOWi9oERZ

    jPQWWk/XmmCsuNbxLJU3rw5nNKfLCYGsMvOuNkej+wdThddmX5dP0wSVc9HTtFSqCoXxoWyQgo9Z

    2+V19auuoL2UDbHt0+mkjyt7oZesKpN6qGtad5JAUSei2KtWQ5OsylohtVKUlxkBenhTTzCuPwEh

    AWOCHaALTeZZq2xv1rdv6Mn1tj/Y+wmkayykiEWnlHdxLWTc1u/bJGkl3l0ZQchoxGBMI/pEOftH

    evwGXkOIJA==

    ----END CUT----

    ----BEGIN RAW----

    ERROR: C1 C2 LEN: 1 2 261

    STR: »

    CVS: $Id: sqlparser.lib.php,v 2.47 2006/01/17 17:02:30 cybot_tm Exp $

    MySQL: 4.0.27-standard

    USR OS, AGENT, VER: Win IE 6.0

    PMA: 2.8.0.2

    PHP VER,OS: 4.4.2 Linux

    LANG: en-iso-8859-1

    SQL: -- phpMyAdmin SQL Dump

    -- version 2.8.0.2

    -- http://www.phpmyadmin.net

    --

    -- Host: localhost

    -- Generation Time: Aug 17, 2006 at 11:10 AM

    -- Server version: 4.0.27

    -- PHP Version: 4.4.2

    --

    -- Database: `boatbrok_ccrt1`

    --

    CREATE DATABASE `boatbrok_ccrt1`;

    ----END RAW----

    SQL query:

    -- phpMyAdmin SQL Dump -- version 2.8.0.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Aug 17, 2006 at 11:10 AM -- Server version: 4.0.27 -- PHP Version: 4.4.2 -- -- Database: `boatbrok_ccrt1` -- CREATE DATABASE `boatbrok_ccrt1`;

    MySQL said:

    #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 'CREATE DATABASE `boatbrok_ccrt1`' at line 1

  5. NO, tell me more?

    I dont want to import all the products or anything, just keep the layout and the mods. Whats sql? I know mysql refers to the database, but I have a seperate DB for each site, its when the new version of the site is pointed at its new DB that things go wrong, pointing at the old sites DB means the site works but the Admin section gives lots of errors when I login.

  6. Im trying to duplicate a store, but theres a problem, I have the storefront working perfectly, but only with the old global.inc.php in place.

    Hmm perhaps I should explain my method. I installed the new store via fantastico, then copied EVERYTHING via FTP from the old store, Admin, Skins the lot. All worked fine, until trying to login to admin. got lots of wierd errors, so I copied the new global.inc file to where it should be in the new site, and admin then works fine, but... the store front then gives an error

    MySQL Error Occured

    1054: Unknown column 'img_folder' in 'field list'

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

    Thats all there is on the page, not just a bit of text above the store like Ive seen before. I didnt want to just copy the skin ovr as Ive done quit a few mods so wanted to copy all of them over also.

    So what have I missed there must be some referenc to the old database somewhere that Ive copied over and its trying to look for it but the global.inc dosnt point to that DB anymore so it cant find it.

  7. I want to create a copy of a current CC store. The new store doesnt need ANY of the categories/images etc carried over JUST the design and layout is all I care about. Can I just copy over what is in the FTP or is some of the stuff Ive done tied up with the database somehow? Ive done a fair few mods, www.kearnsauctions.com.au/index.php

  8. Hmm did you perhaps mean cellhead?

    My topheader has this

    #topHeader {

    text-align: right;

    height: 186px;

    margin-bottom: 10px;

    padding-right: 9px;

    padding-top: 0px;

    background-image: url(../styleImages/backgrounds/topHeader.jpg);

    border-bottom: 1px solid #000000;

    But my cellhead has this

    .cellhead {

    background-image: url(../styleImages/backgrounds/topHeader.jpg);

    height: 188px;

    text-align: right;

    padding-right: 50px;

    changing that last padding right moved it over.

    Thanks for getting me in there.

  9. Ive looked high and low on the forums for this, cant find it. Ive seen skins with it before but I want to know how to do it myself. Just putting a 1 px box around each of the listings in the latest products on the homepage.

    Also can I have more than 3 accross? Ive been playing with trying to get 4 but cant figure it out, page is here

    kearnsauctions.com.au/index.php

    And one more question, when I have these items boxed, will the boxes all line up and be the same size regardless of whats in them??

  10. Hmm and the other part of your reply doesnt look right to me either??

    heres my catagories.tpl

    <!-- BEGIN: categories -->

    <div class="boxTitleLeftcat">{LANG_CATEGORY_TITLE}</div>

    <div class="boxContentLeft">

    <ul>

    <li class="bullet"><a href="index.php" class="txtDefault">{LANG_HOME}</a></li>

    <!-- BEGIN: li -->

    <li class="bullet"><a href="index.php?act=viewCat&amp;catId={DATA.cat_id}" class="txtDefault">{DATA.cat_name}</a></li>

    <!-- END: li -->

    <!-- BEGIN: sale -->

    <li class="bullet"><a href="index.php?act=viewCat&amp;catId=saleItems" class="txtDefault">{LANG_SALE_ITEMS}</a></li>

    <!-- END: sale -->

    </ul>

    </div>

    <!-- END: categories -->

    I see the bullets listed there but no colours??

×
×
  • Create New...