Chargin

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??

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..

Hey OT but I like that C & A site, about as simple a look as Ive ever seen on a CC site, very nice.

ANSUK!! I need to put you on the payroll... Thanks, yes Ive got the button widened, just couldnt find that damn GO!

I want to change the search button text but cant find it anywhere. looked all over the forum and found details about version 2 of CC but its moved since then. Anyone got the good info for me??

I wonder if mod writers could write their mods so we could use a merge system? I use PSPAD, I LOVE it, I wonder if theres a plugin for merging for it...

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..

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

Thimk I too am getting the same error CREATE DATABASE `kearnsau_ccrt1` ; MySQL said: #1044 - Access denied for user: 'boatbrok@localhost' to database 'kearnsau_ccrt1' Anyone out there able to help on this??

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.

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.

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

Thanks, new FCK has a working image upload also, looks good.

Hmm I dont see FCK on that page?

Well I see that if you put your image into a table you can wrap within the cell... not perfect but itll do for now.

I cant see how to do any sort of word wrapping in fckeditor, is this an option in later versions of this? What version do we run in 3.0.10 and how old is it?

Ahh OK, I downloaded a free skin a while back called Iconskin, Ive used it as a starting point for 3 carts so far heh, didnt realise it was different in this area.

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.

Im just gonna start emailing my questions to you Ansuk and cut out the middle man LOL joking, thanks

I have the search field in the top "panel" same as most of the default skins, I know how to adjust the padding to move it down but how do I move it left and right?

Ive just looked at practically every mod on CC.org and cant find what you refer to..??

Whats it called? Ive been scanning cubecart.org today and never found it..??

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??

Thanks Ansuk

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??