Errors when I start KonaKart

[BruceLee]

Dear Team,

I don't feel comfortable with many errors on Command Window that displays Tomcat start-up messages. One of them is,
com.konakart.app.KKException: There are no languages in the database
        at com.konakart.bl.LanguageMgr.setDefaultLanguage(LanguageMgr.java:270)
        at com.konakart.bl.LanguageMgr.getDefaultLanguage(LanguageMgr.java:103)
        at com.konakart.app.KKEng.getDefaultLanguage(KKEng.java:313)
        at com.konakart.app.KKEng.getDefaultLanguage(KKEng.java:63)
        at com.konakart.al.KKAppEng.<init>(KKAppEng.java:291)
        at com.konakart.al.ConfigCacheUpdater.getClientEng(ConfigCacheUpdater.ja
va:77)
        at com.konakart.al.ConfigCacheUpdater.updateConfigs(ConfigCacheUpdater.j
ava:191)
        at com.konakart.al.ConfigCacheUpdater.run(ConfigCacheUpdater.java:147)
21-Sep 09:04:39 INFO  (KKAppEng.java:<init>:268) Engine used by application is c
om.konakart.app.KKEng
com.konakart.app.KKException: There are no languages in the database


Besides, I got following error on IE when I clicked shortcut "Start and Launch KonaKart". After a while, the KonaKart Admin page still shows though.

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Cannot find bean: "konakartKey" in any scope
   org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
   org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
   org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
   org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
   org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
   org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
   org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:239)
   org.apache.struts.tiles.TilesRequestProcessor.internalModuleRelativeForward(TilesRequestProcessor.java:341)
   org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:572)
   org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:221)
   org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
   org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
   org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
   org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
   org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
   org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:318)
   org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
   org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
   org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

javax.servlet.ServletException: Cannot find bean: "konakartKey" in any scope
   org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
   org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
   org.apache.jsp.WEB_002dINF.jsp.MainLayout_jsp._jspService(MainLayout_jsp.java:305)
   org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
   org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
   org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
   org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
   org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
   org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
   org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:239)
   org.apache.struts.tiles.TilesRequestProcessor.internalModuleRelativeForward(TilesRequestProcessor.java:341)
   org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:572)
   org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:221)
   org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
   org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
   org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
   org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
   org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
   org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:318)
   org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
   org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
   org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

javax.servlet.jsp.JspException: Cannot find bean: "konakartKey" in any scope
   org.apache.struts.taglib.TagUtils.lookup(TagUtils.java:935)
   org.apache.struts.taglib.bean.DefineTag.doEndTag(DefineTag.java:230)
   org.apache.jsp.WEB_002dINF.jsp.MainLayout_jsp._jspService(MainLayout_jsp.java:77)
   org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
   org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
   org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
   org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
   org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
   org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
   org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:239)
   org.apache.struts.tiles.TilesRequestProcessor.internalModuleRelativeForward(TilesRequestProcessor.java:341)
   org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:572)
   org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:221)
   org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
   org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
   org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
   org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
   org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
   org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:318)
   org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
   org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
   org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


Thanks!
-Bruce

[trevor]

Hi Bruce,

It looks like you haven't loaded the database successfully...  eg:

com.konakart.app.KKException: There are no languages in the database

You need to get the database loaded successfully before running KonaKart.

Regards,
Trevor

[jbarb]

I upgraded 3.2.0.0 to 4.1.0.0 and it went smoothly but now I need to "run" the Upgrade scripts as it will not let me log on to the admin app until the database upgrades have been accomplished. I have located the upgrade scripts in the konakart download C:\Program Files\KonaKart\database\MySQL, Upgrade script versions 3.2.0.0 to 4.0.0.0 and 4.0.0.0 to 4.1.0.0 and it says it must run sequentially.

How do I "run" these upgrade scripts? I have gone into my MYSQL database and can see where these edits are to be made but isn't there an easier way to upgrade my database other than edit each line of database script manually ?
I upgraded to the 4.1.0.0 because I was having a problem getting the order page(s) to work and I thought perhaps I may have not installed or deleted the checkout pages I required. I could add products to cart and it would total,  but when I hit checkout I got a 404 error. I was hoping the new install would help this problem.
If you give me some guidance on the upgrade scripts I can probably figure out the order pages .

Thanks

jbarb.

[heidi]

You can run the database scripts using any standard database client tools...   For MySQL there is a very user-friendly graphical tool called MySQL Query Browser that you could use (look at the script tab) - or you could use the basic command line client.   

[jbarb]

You can run the database scripts using any standard database client tools...   For MySQL there is a very user-friendly graphical tool called MySQL Query Browser that you could use (look at the script tab) - or you could use the basic command line client.   

Thanks for the help Heidi.

I used the MYSQL Query Browser as you suggested and it did the job. There are quite a few other GUI tools on the MYSQL site also that may be helpful in the future.
Do you have to build the order and shipping pages? (I get a 404 when I hit the Checkout button)
I know that one page checkout comes with the download but I'm still sorting through JSPs for storefront changes but I have not run across the it yet.
Is there any particular area I should be looking for it?


Thanks for your help,

Jim

[heidi]

You shouldn't have to build anything to get it to work.

You could try a completely new installation (using a new database schema) and see that running then compare the differences.

[jbarb]

KonaKart 4.1.0.0 was a new installation. I installed 3.2 prior to 4.1.

I may have done something in the admin app configurations to break the hyperlink to the checkout pages. i.e AddToCartFromProdID.Do and EditCartSubmit.Do.  Is there a section in the admin app can check to see if the hyperlink to those pages are pointing correctly or a jsp I can look at and repair?

All my products are loaded and my storefront looks good enough to publish and this is the only thing holding me back.

I upgraded to the 4.1.0 version in the hopes that I would recover some code I may have lost but obviously that was not the case. The shopping cart worked when I first installed 3.2 so I know everything is there. It was after I started modifying specifics in the admin app that I disabled the shopping cart. If I knew what the error is (a 404 like a broken hyperlink) and where to look in the admin app to configure the shopping cart I could correct it? I did change some addresses from  konakart to my web page envirosales.com but don't know which one it was. What is the address that the shopping cart is hyperlinked to after installation?

If I do a soap build will that help me at all? I am using MS Front Page 2003 for my editor although it does not let me view everything in the JSPs.

Thanks for your help,

Jim 

[heidi]

Have you tried disabling the one page checkout in the admin app just to see if that helps?

[jbarb]

Have you tried disabling the one page checkout in the admin app just to see if that helps?

I disabled one page checkout and made no difference. But I did some comparisons of hyperlink URLs between the KonaKart E-commerce demo on the KonaKart Website and my KonaKart website and got this:

From the Konakart Demo:

Add to cart from storefront  http://www.konakart.com/konakart/AddToCartFromProdId.do?prodId=5

Select prod from storefront:    http://www.konakart.com/konakart/SelectProd.do?prodId=7

Add to cart 2nd time for totals: http://www.konakart.com/konakart/AddToCartSubmit.do

Checkout  http://www.konakart.com/konakart/EditCartSubmit.do

Confirm order  http://www.konakart.com/konakart/CheckoutConfirmationSubmit.do?onePage=true


From my KonaKart storefront

Add to cart from storefront      http://localhost:8780/konakart/AddToCartFromProdId.do?prodId=32

Select prod from storefront  http://localhost:8780/konakart/SelectProd.do?prodId=32
                                     
Add to cart 2nd time for price totals  http://localhost:8780/konakart/AddToCartSubmit.do

Checkout    res://ieframe.dll/http_404.htm#http://localhost:8780/konakart/EditCartSubmit.do

All the URL address are live links until you get the checkout link on my page above which is dead.

Also when you go to the URL: http://localhost:8780/konakart/AddToCartSubmit.do

you get this:

Unfortunately we have encountered a malfunction.
Please contact the system administrator.

 
 

The details of the malfunction are :

Exception Name = com.konakart.app.KKException
Exception Message = The product id of the product : null, is invalid 
 
 I have obviously disabled the checkout link accidentally using the admin app which has affected the entire shopping cart.

If you can help steer me to the the area, whether at the admin app or jsp or classes, you will have given myself some real insights on how to configure KonaKart.

Thanks,

Jim

[jbarb]

Hi Bruce,
It looks like you haven't loaded the database successfully...  eg:
com.konakart.app.KKException: There are no languages in the database

You need to get the database loaded successfully before running KonaKart.
Regards,
Trevor

When you hit Add to cart 2nd time (for price/ship totals)  http://localhost:8780/konakart/AddToCartSubmit.do

you get this: (the same as your previous help question)



"Unfortunately we have encountered a malfunction.
Please contact the system administrator.

The details of the malfunction are :

Exception Name = com.konakart.app.KKException
Exception Message = The product id of the product : null, is invalid  
 
 I have obviously disabled the shopping cart accidentally, using the admin app, possibly loading my products?? 

When I hit Checkout I get this 404 message:    res://ieframe.dll/http_404.htm#http://localhost:8780/konakart/EditCartSubmit.do
Since I caused this error somewhere in the admin app, can I resolve it there or do I need to repair the database itself? And If so how,  and where do I find the database error?

Thanks

jbarb