Topics

I have been running KonaKart Community Edition 4.2.0.1 for over a year without problems.  Using JDK 6 and Tomcat 6. My hosting provider is dailyrazor.net and the database version is MySQL 5.1.56.

After having some issues reaching my website, the hosting company restarted Tomcat.  Now, konakart displays this error when trying to view the root index.jsp/welcome page.  I have tried stopping/restarting tomcat, deleting the work directory, and even re-deploying the konakart.war, but I always receive this exception:

Code Select Expand


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:79)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)


Looking in the konakart logs, I see this exception, repeated over and over again:

Code Select Expand


23-Aug 02:11:07 ERROR (?:handleException:?) com.konakart.al.KKAppException: There has been an exception in the ConfigCacheUpdater
at com.konakart.al.ConfigCacheUpdater.handleException(Unknown Source)
at com.konakart.al.ConfigCacheUpdater.run(Unknown Source)
Caused by: com.konakart.app.KKException: org.apache.torque.TorqueException: java.sql.SQLException: Prepared statement needs to be re-prepared
at com.konakart.app.KKEng.getTempCustomerId(Unknown Source)
at com.konakart.al.CustomerMgr.createGuest(Unknown Source)
at com.konakart.al.KKAppEng.init(Unknown Source)
at com.konakart.al.KKAppEng.<init>(Unknown Source)
at com.konakart.al.ConfigCacheUpdater.getClientEng(Unknown Source)
at com.konakart.al.ConfigCacheUpdater.updateConfigs(Unknown Source)
... 1 more
Caused by: org.apache.torque.TorqueException: java.sql.SQLException: Prepared statement needs to be re-prepared
at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:109)
at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:688)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:554)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:431)
at com.konakart.bl.CustomerMgr.getTempCustomerId(Unknown Source)
... 7 more
Caused by: java.sql.SQLException: Prepared statement needs to be re-prepared
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
at com.workingdogs.village.Record.saveWithInsert(Record.java:438)
at com.workingdogs.village.Record.save(Record.java:234)
at com.workingdogs.village.Record.save(Record.java:201)
at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:685)
... 10 more


What could be causing this error?  Any help or suggestions are appreciated in helping me track down the cause of this issue, since the company website is no longer functioning.  Thanks.

Hi,

I have 4 products with a special price configured. There is no expiration date for the special price.  In the KonaKart Admin, I can do a Product search for "Specials Only", and my 4 products are returned.

The KonaKart configuration parameter "Selection of Products on Special" is set to 10.

However, in my JSP where I am trying to display a random special, the call to ProductManager.getRandomSpecial() returns null.  Is there something else that I need to configure, or is there something I am doing wrong?

Code Select Expand


<bean:define id="kkEng" name="konakartKey" type="com.konakart.al.KKAppEng"/>
<bean:define id="prodMgr" name="kkEng" property="productMgr" type="com.konakart.al.ProductMgr"/>

<bean:define id="special" name="prodMgr" property="randomSpecial" type="com.konakart.appif.ProductIf"/>
<%=special.getName() %>


The call to getRandomSpecial returns:

Code Select Expand


Caused by: javax.servlet.jsp.JspException: Define tag cannot set a null value for bean with id: special
at org.apache.struts.taglib.bean.DefineTag.doEndTag(DefineTag.java:236)



Hello,

I am using konakart 4.2.0.1 with "Enables Checkout Without Registration" set to true, and "Enables One Page Checkout" set to false.  However, whenever I add an item to the cart and attempt to checkout I am redirected to the login page.  Looking at the code of CheckoutDeliveryAction.java, I see the following Java code:

Code Select Expand


            // Check to see whether one page checkout is enabled
            boolean onePageC = isOnePageCheckout(kkAppEng);

            // Check to see whether the user is logged in unless we allow one page checkout
            if (!onePageC)
            {
                custId = this.loggedIn(request, response, kkAppEng, "CheckoutDelivery");
                if (custId < 0)
                {
                    return mapping.findForward(loginForward);
                }
            }


What is the proper way to modify this Action class such that is allows Checkout Without Registration?

Thanks.

Hello,

I'd like to conifgure konakart to send order confirmation emails to another email address in addition to the confirmation email that it sends to the customer.  For example, have an order confirmation email go to orders@mystore.com to notify the store that an order has been been placed.  Is it possible to configure this or modify some code to accomplish this?

Thanks

Okay, Yes I have searched the forum and looked at previous threads about customizing the sort order for products, but I didn't see where the suggested solutions apply, so I will re-post this question.

I am using KonaKart 4.2.0.1.

I only want to change the sort order of products as they are displayed when the user is viewing products within a category.  Naturally, I looked at the source of SelectCategoryAction1.  However the only line of code that I can tell which fetches the products is:

Code Select Expand

int prodsFound = kkAppEng.getCategoryMgr().setCurrentCatAndUpdateProducts1(catIdInt);

I can't modify the source of CategoryMgr.setCurrentCatAndUpdateProducts1 method - or can I?  Where is the appropriate place to customize the product query?

Thanks.

We have retail customers and wholesale customers.  For wholesale customers, we do not want to charge them sales tax.  Is there a way to configure KK to not charge tax for a particular customer group?

Thanks

I am trying to modify the One Page Checkout code as described in Chapter 12 of the KonaKart User Guide.  However, when I run the ant build script, I get an error, which I am assuming to be because I am running my development environment on Mac OS X Snow Leopard.

The error given is:

[java] Exception in thread "main" java.lang.UnsatisfiedLinkError: Can't load library: /konakart/custom/onepagecheckout/lib/libswt-win32-3235.jnilib
     [java]    at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1702)
     [java]    at java.lang.Runtime.load0(Runtime.java:770)
     [java]    at java.lang.System.load(System.java:1020)
     [java]    at org.eclipse.swt.internal.Library.loadLibrary(Library.java:132)
     [java]    at org.eclipse.swt.internal.win32.OS.<clinit>(OS.java:18)
     [java]    at org.eclipse.swt.widgets.Display.<clinit>(Display.java:125)
     [java]    at com.google.gwt.dev.SwtHostedModeBase.<clinit>(SwtHostedModeBase.java:96)

BUILD FAILED
/Users/joe/konakart/custom/onepagecheckout/build.xml:129: Java returned: 1

I assume this is happening because the SWT library included is for windows, and not Mac OS.  Is there a way to get this working in Mac OS X?

Thanks

I can see all 24 customers in the Customers table in MySQL.  However, the konakart admin app only shows 12 customers.  I am searching for All Customers, All Groups, and leaving Last Name, City, Street, and Post Code blank.

Is there a way to configure KonaKart to not list product options where the quantity is 0?

For example, let's say I have a product "T-Shirt" with options "Color" and "Size". 

The "Color" option has possible values [Red, White], and the "Size" option has possible values [small, large]. The quantities are set to:

Red, Small T-shirt: 0
Red, Large T-shirt: 0
White, Small T-shirt: 5
White, Large T-shirt: 8

If the quantity of Red t-shirts is 0, I don't want that to display as one of the color options. Is this possible?

Thanks.

I have two tax areas defined:

Tax Area: Washington
Tax Area: US States Not Taxed

The Washington Tax Area is mapped to the Zone "Washington"
The "US States Not Taxed" tax area is mapped to the other 49 US State Zones.

I created a Tax Rate "WA TAX 9.5%", and set the tax rate to 9.5 and the Tax Area to "Washington" and Priority 1
I created a Tax Rate "Outside WA State" and set the tax rate to 0 and the Tax Area to "US States Not Taxed" and Priority 1

(I do not want orders from outside WA to be taxed)

Now, everything as far as tax calculation is correct. WA residents are charged 9.5% and residents outside of WA are not charged tax. However, in the shopping cart, several tax areas and zone are show in the cart (see image).. How can this be remedied?

I am getting intermittent OutOfMemoryError errors in KonaKart. Sometimes when viewing an Address Book entry, sometimes during Checkout:

java.lang.OutOfMemoryError: Java heap space
   org.apache.velocity.runtime.parser.VelocityCharStream.<init>(VelocityCharStream.java:335)
   org.apache.velocity.runtime.parser.VelocityCharStream.<init>(VelocityCharStream.java:392)
   org.apache.velocity.runtime.parser.VelocityCharStream.<init>(VelocityCharStream.java:403)
   org.apache.velocity.runtime.parser.Parser.<init>(Parser.java:62)
   org.apache.velocity.runtime.RuntimeInstance.createNewParser(RuntimeInstance.java:1034)
   org.apache.velocity.runtime.ParserPoolImpl.initialize(ParserPoolImpl.java:50)
   org.apache.velocity.runtime.RuntimeInstance.initializeParserPool(RuntimeInstance.java:1007)
   org.apache.velocity.runtime.RuntimeInstance.init(RuntimeInstance.java:254)
   org.apache.velocity.runtime.RuntimeInstance.init(RuntimeInstance.java:615)
   org.apache.velocity.app.VelocityEngine.init(VelocityEngine.java:121)
   com.konakart.bl.EmailMgr.getVelocityEngine(Unknown Source)
   com.konakart.bl.EmailMgr.sendOrderConfirmationEmail1(Unknown Source)
   com.konakart.app.KKEng.sendOrderConfirmationEmail1(Unknown Source)
   com.konakart.actions.gateways.BaseGatewayAction.sendOrderConfirmationMail(Unknown Source)
   com.konakart.actions.gateways.AuthorizenetAction.execute(Unknown Source)
   org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
   org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
   org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
   org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

I am running with Xmx set to 32.  Is this too low for KonaKart and the KonaKartAdmin webapps?  What is the suggested memory setting?

Thanks

I am having a problem that only occurs on my production server konakart and konakart web applications.  These issues do not occur on my local version of tomcat that is packaged with the konakart distribution.

My web hosting company provides Tomcat 5.5. I have deployed the konakart and konakartadmin war files, and I am able to view all the web pages, add items to the shopping cart, etc.  The problems occur on any action requiring an email be sent, such as requesting a new password, registering a new user, placing an order, etc.  I get the following exception:


The details of the malfunction are :

Exception Name = com.konakart.app.KKException
Exception Message = org.apache.velocity.exception.VelocityException: Failed to initialize an instance of org.apache.velocity.runtime.log.AvalonLogChute with the current runtime configuration.

I searched the forum and found this topic before. So I replaced the tomcat/conf/logging.properties file and tomcat/common/classes/log4j.properties file on the production Tomcat with the versions that came with the konakart distribution, but this did not fix the problem.

Do you have any recommendations on how to fix this problem?

Thanks.