Messages

I am now thinking this has nothing to do with the server restart, and the site was the victim of a hacker attack. At this point I have no proof, but I did notice some spam customer accounts created just the day before I noticed the problem.

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)



Let me summarize, since no one has replied.

The "Enable Checkout Without Registration" setting DOES NOT WORK if you set "Enable One Page Checkout" to FALSE.

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.

Excellent! Thank you!

Thanks!  Sadly, the sort option I want "ORDER_BY_DATE_ADDED_DESC" does not exist. 

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.

I am using version 4.2.0.1

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 would be happy to.  What logger do I need to enable in the logging properties file? I don't see anything marked as sql.

Also - the KonaKart Admin app, on the "My Store Status" page, reports 24 customers as well.  But when you click on the hyperlink, only 12 Customers appear.

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.