Kryptronic Software Support Forum
You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
#51 05-24-2007 14:57:58
- JGB
- Member
- From: Holyoke, Massachusetts
- Registered: 01-16-2004
- Posts: 298
Re: Update Issued: KRYPT05212007A - Important Info
GoBrushless.com wrote:
Sigh... I followed the instructions exactly as written and I have all the stupid stock IT equipment added to my cats, prods, prod options, ....
Me too. Ran it twice, once locally, then on the live site. Second time I was very careful to follow instructions to the letter. Still got all the computer equipment stuff added back in.
John
Offline
#52 05-24-2007 15:58:37
- redmanstudios
- Member
- Registered: 11-10-2003
- Posts: 387
Re: Update Issued: KRYPT05212007A - Important Info
just run this sql query in phpmyadmin. this will remove all the default store product and cats.
Code:
DELETE FROM `ccp0_cat` WHERE CONVERT(`id` USING utf8) = 'BuildYourOwn' LIMIT 1; DELETE FROM `ccp0_cat` WHERE CONVERT(`id` USING utf8) = 'PCs' LIMIT 1; DELETE FROM `ccp0_cat` WHERE CONVERT(`id` USING utf8) = 'DeskPCs' LIMIT 1; DELETE FROM `ccp0_cat` WHERE CONVERT(`id` USING utf8) = 'GamePCs' LIMIT 1; DELETE FROM `ccp0_cat` WHERE CONVERT(`id` USING utf8) = 'HDD' LIMIT 1; DELETE FROM `ccp0_cat` WHERE CONVERT(`id` USING utf8) = 'scsiHDD' LIMIT 1; DELETE FROM `ccp0_cat` WHERE CONVERT(`id` USING utf8) = 'pcmciaHDD' LIMIT 1; DELETE FROM `ccp0_cat` WHERE CONVERT(`id` USING utf8) = 'eideHDD' LIMIT 1; DELETE FROM `ccp0_cat` WHERE CONVERT(`id` USING utf8) = 'MONITOR' LIMIT 1; DELETE FROM `ccp0_prod` WHERE CONVERT(`id` USING utf8) = 'DESKTOP1001' LIMIT 1; DELETE FROM `ccp0_prod` WHERE CONVERT(`id` USING utf8) = 'DESKTOP1002' LIMIT 1; DELETE FROM `ccp0_prod` WHERE CONVERT(`id` USING utf8) = 'DESKTOP1003' LIMIT 1; DELETE FROM `ccp0_prod` WHERE CONVERT(`id` USING utf8) = 'DESKTOP1004' LIMIT 1; DELETE FROM `ccp0_prod` WHERE CONVERT(`id` USING utf8) = 'HDD1005' LIMIT 1; DELETE FROM `ccp0_prod` WHERE CONVERT(`id` USING utf8) = 'HDD1006' LIMIT 1; DELETE FROM `ccp0_prod` WHERE CONVERT(`id` USING utf8) = 'HDD1007' LIMIT 1; DELETE FROM `ccp0_prod` WHERE CONVERT(`id` USING utf8) = 'MONITOR1008' LIMIT 1; DELETE FROM `ccp0_prod` WHERE CONVERT(`id` USING utf8) = 'MONITOR1009' LIMIT 1; DELETE FROM `ccp0_prod` WHERE CONVERT(`id` USING utf8) = 'BUILD1001' LIMIT 1;
Last edited by redmanstudios (05-24-2007 15:59:42)
Offline
#53 05-25-2007 11:39:07
Re: Update Issued: KRYPT05212007A - Important Info
Here is a better set of statements:
https://forum.kryptronic.com/viewtopic.php?id=17047
Nick Hendler
Offline
#54 05-25-2007 13:44:07
- LexFrost
- Member
- Registered: 07-22-2005
- Posts: 48
Re: Update Issued: KRYPT05212007A - Important Info
That is great, it worked perfectly and removed all the default products. Now how do I get my "Add to Cart" and "Add to Wishlist" buttons back?
Offline
#55 05-25-2007 14:23:16
Re: Update Issued: KRYPT05212007A - Important Info
webmaster wrote:
JGB- Yes - all of those should have the string 'khxc_ordersumm' changed to 'khxc_regtable'.
dh783- No - only the XHTML mail code. In that code only, change 'ordersummary.php' to 'ordersummaryxhtml.php'.
My dumb question is where do we do this?
Thom-
"Life is a banquet, and most poor suckers are starving to death!" - AUNTIE MAME
Offline
#56 05-25-2007 14:59:57
- larry
- Member
- Registered: 07-21-2003
- Posts: 437
Re: Update Issued: KRYPT05212007A - Important Info
webmaster wrote:
Code:
DELETE FROM ccp0_country DELETE FROM ccp0_stateprov DELETE FROM ccp0_proddetdisp
Yikes! I spent a lot of time on the ccp0_country list to mark them as "show" or "dont show" during checkout and account creation. Do I REALLY need to delete that table? Same goes with ccp0_stateprov. We get HUGE amounts of fraud from many countries and I refuse to even let them attempt to create an account.
Also, I've "cloned" some entries in ccp0_proddetdisp and created my own displays. Don't want to delete them!
I'll run a backup of my entire database, and try to put "my" entries back. But I fear that there may be other tables modified that I don't know about. I've added fields to ccp0_prod and ccp0_prodoptionsel using Raw DB admin. Will I have to re-add those fields and repopulate them with my "saved" data?
Laurie Stephens
Offline
#57 05-25-2007 15:10:49
Re: Update Issued: KRYPT05212007A - Important Info
The only way you will loose the information in these database tables is if you run delete entries in the submit raw sql statment. Other wise it will only update any database file that has been changed, it will not remove any new columns you have placed in any database. I don't think that not deleting the country or state/prove database will hurt you but it is always good practice to have backups.
John
Offline
#58 05-26-2007 11:23:31
Re: Update Issued: KRYPT05212007A - Important Info
The reason it is recommended that you remove data from both the ccp0_stateprov and ccp0_country tables is: There was a new column named 'sortorder' to the tables. If you do not remove the data from the tables, when you run the database update the sortorder for every entry will default to zero. This is not a bad thing - it just means you have to go in an manually update the sortorder for each entry in the two tables. You can leave them intact without problems - but it's easier to remove the data and reload a fresh set with sortorder information set.
Nick Hendler
Offline
#59 05-27-2007 12:20:44
- Dave
- Member
- Registered: 07-05-2003
- Posts: 11233
Re: Update Issued: KRYPT05212007A - Important Info
May the skin directory named KHXCMI be deleted after completing the update? From the looks of it the answer is yes but better safe than sorry 
Offline
#62 05-29-2007 09:53:22
Re: Update Issued: KRYPT05212007A - Important Info
May the skin directory named KHXCMI be deleted after completing the update?
Yes, it can be removed.
5. Change references from 'ordersummary.php' to 'ordersummaryxhtml.php' in all order mail message includes.
Here:
Home > ClickCartPro > Mail: Messages, Mail and Subscriptions > Manage Mail Messages
Edit these includes:
Order Confirmation Message (Customer)
Order Confirmation Message (Internal)
Order Confirmation Message (Shipper)
In the XHTML Message box.
Nick Hendler
Offline
#63 05-30-2007 15:04:46
- GoBrushless.com
- Member
- Registered: 06-29-2005
- Posts: 431
Re: Update Issued: KRYPT05212007A - Important Info
GoBrushless.com wrote:
Another edit: seems the lightbox mod is a bit retarded. The "shadow" now only covers all but about 10px margin along the right side of my page. I'm using a ZipSkin and this worked just fine prior to the update. Even the Flash fix which I researched, implemented, and posted the fix for on this forum.
Nick,
Can you please propose how I fix this?
TIA
Steve
Offline
#64 05-31-2007 08:17:53
- GJohn
- Member
- Registered: 04-04-2007
- Posts: 67
Re: Update Issued: KRYPT05212007A - Important Info
Hi,
I've carried out the updates, but now when I select a product from the catalogue I go to the item details page, but nothing is displayed.
What have I done wrong ?
Was working OK before upgrade.
Has this got anything to do with the last SQL statement, namely DELETE * FROM gbu0_proddetdisp ; ?
Yes it has. I've imported my saved copy of the table back and now all works ok again. Why then do you require all records to be deleted from this table ?
Now I've noticed I can't edit any of the products ? I get the error message "There was a processing problem encountered while processing your request. Please try again later." Please help !
I've just read other comments on the update which suggest that I need to obtain the latest installer.php file. Any idea where I can download it from ?
Last edited by GJohn (05-31-2007 12:33:30)
Offline
#65 05-31-2007 08:57:41
- GoBrushless.com
- Member
- Registered: 06-29-2005
- Posts: 431
Re: Update Issued: KRYPT05212007A - Important Info
Note: when I performed the update, it duplicated the KHXC default skin so now I have two of 'em... what to do? what to do?
Offline
#66 05-31-2007 14:11:24
Re: Update Issued: KRYPT05212007A - Important Info
(1) Lightbox issues: Lightbox was modified in the update to include the flash hack found on this forum. Back out that hack if you're having issues. That was the only change made to Lightbox.
(2) Email support@kryptronic.com if you need a new copy of the installer. For GJohn, you are running the GBU version of CCP (UK). This version was not updated until about two hours ago. Now is when you want to run the installer. Make sure you follow all instructions (again) posted in the GBU forum.
Nick Hendler
Offline
#67 06-01-2007 14:30:40
- BlackBunnyAL
- Member
- Registered: 05-28-2006
- Posts: 58
- Website
Re: Update Issued: KRYPT05212007A - Important Info
webmaster wrote:
The following updates are recommended for the 'Ecom' and 'Mail' skins. Because skins are not touched during updates, these changes should be applied manually:
Code:
1. Remove references to 'Wish List' from links in the 'Ecom' skin. 2. Added 'big' CSS class for paragraphs. Default bold 16 pixels. 3. Update css in both skins. Do a find on 'khxc_ordersumm' and replace with 'khxc_regtable'. 4. Change any classed H1 tags in your user HTML pages (under Home > ClickCartPro > Web Pages: Web Page Management > Manage Web Pages) to use a p tag classed as 'khxc_storehead'. 5. Change references from 'ordersummary.php' to 'ordersummaryxhtml.php' in all order mail message includes.
For the life of me I cannot find khxc_ordersumm in any of the css files or the skins. Also where are order mail message includes?
Also the order look page looks real smudged together. :-/
Last edited by BlackBunnyAL (06-01-2007 14:32:23)
Offline
#68 06-01-2007 15:02:55
Re: Update Issued: KRYPT05212007A - Important Info
What you are look for in the all.css is:
Code:
table.khxc_ordsumm {
color: inherit;
background-color: inherit;
margin: 0px 0px 5px 0px;
border-spacing: 3px;
width: 100%;
}
.khxc_ordsumm a {
color: #0000FF;
background-color: inherit;
font-weight: bold;
text-decoration: none;
}
tr.khxc_ordsumm {
color: inherit;
background-color: inherit;
padding: 5px;
border: 1px solid #000000;
}
th.khxc_ordsumm {
color: inherit;
background-color: inherit;
padding: 4px 3px 4px 3px;
border-top: 1px solid #CDCDCD;
border-left: 1px solid #CDCDCD;
vertical-align: top;
}
td.khxc_ordsumm {
color: inherit;
background-color: #F7F7F7;
padding: 4px 3px 4px 3px;
border-top: 1px solid #CDCDCD;
border-left: 1px solid #CDCDCD;
vertical-align: top;
}
.khxc_ordsumm p {
color: inherit;
background-color: inherit;
padding: 0px;
margin: 0px 0px 5px 0px;
}
.khxc_ordsumm a {
color: #3E6B8A;
background-color: inherit;
}
.khxc_ordsumm a:hover {
color: inherit;
background-color: inherit;
text-decoration: underline;
}
.khxc_ordsummhead {
color: #333333;
background-color: inherit;
padding: 2px 5px 2px 5px;
margin: 0px;
border-bottom: 1px solid #CCCCCC;
font-weight: bold;
font-size: 14px;
clear: both;
}
.khxc_ordsummcenter {
color: inherit;
background-color: inherit;
text-align: center;
padding: 0px;
margin: 0px 0px 10px 0px;
border: 1px solid #000000;
}
.khxc_ordsummbig {
color: inherit;
background-color: inherit;
font-weight: bold;
font-size: 16px;
}
.khxc_ordsummlink {
color: inherit;
background-color: #F7F7F7;
padding: 0px 5px 0px 5px;
margin: 10px 0px 10px 0px;
border: 1px solid #CCCCCC;
}
.khxc_ordsummlink a {
color: #0000FF;
background-color: inherit;
font-weight: normal;
}the mail messages are at Home > Front End > Mail: Messages, Mail and Subscriptions > Manage Mail Messages make sure you look in the xhtml part closer to the bottom.
John
Offline
#69 06-01-2007 15:49:49
- almost
- Member
- Registered: 06-01-2007
- Posts: 1
Re: Update Issued: KRYPT05212007A - Important Info
I was about 2 seconds from ordering CCP until I saw that my customers had to register with a password before they could even begin to checkout. I figured I would search your support forum for the module or workaround to turn this feature off. After reading numerous posts I now see this is not possible. I started a retail site over 6 years ago and now have 7 online stores. None of which REQUIRE the customer to create an account first. From experience you absolutely will lose customers by FORCING them to do anything. I might have a returning customer 1 in 500 or more orders. Amazon is doing it so everyone else should too. Bogus...larger sites like Amazon do it because they can. The only purpose it serves is to make it easier on returning customers. If you don't have returning customers it is nothing more than an annoyance. Nick you're obviously a very intelligent programmer and I find it extremely hard to believe you cannot provide a simple work around to the registering. At the very least let the customer add a password at the end of the order (better yet let them choose) at this point the consumer has invested enough time and info that the hassle of creating an account will not turn them away. How about an auto generated password that is emailed with confirmation of the order. I am soooooo tired of thinking of new passwords never to be remembered again.
You really should listen to your customers. Right or wrong "the customer is always right"
Just my two cents worth after all its your cart and you can require cart users to enter anything you wish.
BTW - my experience is that nearly every cart gives the option to register or not.
Unfortunately the above was the deal breaker on purchasing CCP. With that said, I'll give kudos to CCP for allowing add to cart from static html pages outside cart domain. Only a couple of carts still around being updated allow this. Hopefully litecommerce won't "upgrade" forcing customer registration or I'll be SOL.
Offline
#71 06-04-2007 05:37:36
- Dave
- Member
- Registered: 07-05-2003
- Posts: 11233
Re: Update Issued: KRYPT05212007A - Important Info
The latter (ordsumm)
Offline
#72 06-04-2007 08:06:46
- Quizno
- Member
- Registered: 06-02-2003
- Posts: 447
Re: Update Issued: KRYPT05212007A - Important Info
The latter (ordsumm)
That explains a bit. Nick needs to edit his instructions.
Offline
#74 06-08-2007 10:40:33
- BlackBunnyAL
- Member
- Registered: 05-28-2006
- Posts: 58
- Website
Re: Update Issued: KRYPT05212007A - Important Info
Anyone else still having trouble with the breadcrumbs?
In a future update do you think you can just put in "Manage Application Settings" the ability to just turn them off?
Offline
#75 06-08-2007 15:24:27
- GoBrushless.com
- Member
- Registered: 06-29-2005
- Posts: 431
Re: Update Issued: KRYPT05212007A - Important Info
Yeah mine are still whacked out. For example, if you bounce between subcategories within a category, it ends up displayed the long senseless trail of breadcrumbs like before the update.
Offline