Hi Deepak,
The keyword TYPE was deprecated in earlier version of MySQL and is
non-existent in the version you are using.
To get across this, you can,
Edit ofbiz/framework/entity/src/org/ofbiz/entity/jdbc/DatabaseUtil.java in
eclipse and replace sqlBuf.append(" TYPE ") with sqlBuf.append(" ENGINE ")
Compile OFBiz & try to install again.
On Sun, Jun 24, 2012 at 2:12 AM, Deepak Agarwal <[email protected]>wrote:
> ant run-install-seed throws following . my mysql version is 5.5.16. Could
> you quickly tell me if this is a known issue.
>
> [java] 2012-06-24 02:09:35,132 (main) [
> DatabaseUtil.java:352:ERROR]
> Could not create table [WORK_EFFORT_TYPE_ATTR]: SQL Exception while
> executing th
> e following:
> [java] CREATE TABLE WORK_EFFORT_TYPE_ATTR (WORK_EFFORT_TYPE_ID
> VARCHAR(20)
> CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL, ATTR_NAME
> VARCHAR(60) C
> HARACTER SET latin1 COLLATE latin1_general_cs NOT NULL, LAST_UPDATED_STAMP
> DATET
> IME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME,
> CREATED_TX_STAMP DA
> TETIME, CONSTRAINT PK_WORK_EFFORT_TYPE_ATTR PRIMARY KEY
> (WORK_EFFORT_TYPE_ID, AT
> TR_NAME)) TYPE InnoDB CHARACTER SET latin1 COLLATE latin1_general_cs
> [java] Error was:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
> : You have an error in your SQL syntax; check the manual that corresponds
> to you
> r MySQL server version for the right syntax to use near 'TYPE InnoDB
> CHARACTER S
> ET latin1 COLLATE latin1_general_cs' at line 1
>
> On Sun, Jun 24, 2012 at 1:27 AM, Nick Rosser <[email protected]>
> wrote:
>
> > Yes it's free to use. Apache license. The intent is to totally integrate
> > with ofbiz so any order placed via the bigfish ecommerce ui can be
> fufilled
> > in the backend ofbiz. We are working with a client currently that will
> use
> > a bigfish ecomm solution and run thru an erp solution we built for them
> > some time ago.
> >
> > More news next week, we have a release ready.
> >
> > And we'll get solr working for sanjeev!
> >
> > Nick
> > C: 516.901.1720
> > [email protected]
> >
> >
> > On Jun 23, 2012, at 3:33 PM, Mike <[email protected]> wrote:
> >
> > It's not my project. It's Nicks with salmonllc.com. I believe it has
> an
> >> Apache 2.0 license, so it is free it use. Maybe Nick can clarify. I'm
> >> still evaluating it, but so far very impressed. It appears to fully
> >> integrate with OFBiz's back-end as well.
> >>
> >> On Sat, Jun 23, 2012 at 12:24 PM, Deepak Agarwal <[email protected]
> >> >wrote:
> >>
> >> Mike,
> >>>
> >>> I checked your admin panel. Amazing... great work I must say. Is it
> free
> >>> to
> >>> use. Can I move just switch to it without any hassle of configurations
> ?
> >>>
> >>> On Sat, Jun 23, 2012 at 5:12 AM, Mike <[email protected]> wrote:
> >>>
> >>> You can check out BigFish:
> >>>>
> >>>> http://bigfish.salmonllc.com <
> >>>>
> >>> http://bigfish.salmonllc.com/**bfDownload.html<
> http://bigfish.salmonllc.com/bfDownload.html>
> >>>
> >>>>
> >>>>>
> >>>> It's an awesome OFBiz ecommerce frontend (and simplified backend) that
> >>>>
> >>> has
> >>>
> >>>> SOLR built-in. Nick Rosser and his team of experts at
> >>>> sammonllc.comhave
> >>>> put together a great set of features that is nothing short of amazing.
> >>>>
> >>> I'm
> >>>
> >>>> sold on it [grin].
> >>>>
> >>>> You can always download it and checkout how they integrated SOLR.
> >>>>
> >>>> On Thu, Jun 21, 2012 at 11:40 AM, Sanjeev Gupta <
> [email protected]
> >>>>
> >>>>> wrote:
> >>>>>
> >>>>
> >>>> Hi Rajbir,
> >>>>> I spent a couple of days trying to play around with the approach you
> >>>>> recommended but couldn't get it to work for me. So finally gave it
> up.
> >>>>>
> >>>>> Will probably wait for someone to contribute the feature to the
> trunk.
> >>>>>
> >>>>>
> >>>>>
> >>>>> -----
> >>>>> Rgds
> >>>>> Sanjeev
> >>>>> www.sanjeevg.com
> >>>>> @sanjeevgcom
> >>>>> --
> >>>>> View this message in context:
> >>>>>
> >>>>>
> >>>> http://ofbiz.135035.n4.nabble.**com/Has-anyone-implemented-**
> >>> Faceted-Search-using-SOLR-**tp4633260p4633892.html<
> http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4633892.html
> >
> >>>
> >>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
> >>>>>
> >>>>>
> >>>> --
> >>>> Thanks,
> >>>> Deepak Agarwal,
> >>>>
> >>>> Paxcel Technologies Pvt Ltd.
> >>>> Hartron Complex, Sector 18, Gurgaon, India.
> >>>> E-Mail: [email protected]
> >>>> Mobile: +91 9910322604
> >>>>
> >>>> --
> >>>> Thanks,
> >>>> Deepak Agarwal,
> >>>>
> >>>> Paxcel Technologies Pvt Ltd.
> >>>> Hartron Complex, Sector 18, Gurgaon, India.
> >>>> E-Mail: [email protected]
> >>>> Mobile: +91 9910322604
> >>>>
> >>>> <%2B91%209910322604>
> >>>
> >>>
>
--
Regards,
Varun Bhansaly
