ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Deepak Agarwal <dagarwa...@gmail.com>
Subject Re: Has anyone implemented Faceted Search using SOLR?
Date Mon, 25 Jun 2012 16:44:53 GMT
Great. Switching over to bigfish :)

On Sun, Jun 24, 2012 at 7:18 AM, varun bhansaly <vbhansaly@gmail.com> wrote:

> 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 <dagarwal82@gmail.com
> >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 <nrosser@salmonllc.com>
> > 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
> > > nrosser@salmonllc.com
> > >
> > >
> > > On Jun 23, 2012, at 3:33 PM, Mike <mz4wheeler@gmail.com> 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 <
> dagarwal82@gmail.com
> > >> >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 <mz4wheeler@gmail.com>
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 <
> > subscribe@sanjeevg.com
> > >>>>
> > >>>>> 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: deepak.agarwal@paxcel.net
> > >>>> Mobile: +91 9910322604
> > >>>>
> > >>>> --
> > >>>> Thanks,
> > >>>> Deepak Agarwal,
> > >>>>
> > >>>> Paxcel Technologies Pvt Ltd.
> > >>>> Hartron Complex, Sector 18, Gurgaon, India.
> > >>>> E-Mail: deepak.agarwal@paxcel.net
> > >>>> Mobile: +91 9910322604
> > >>>>
> > >>>>  <%2B91%209910322604>
> > >>>
> > >>>
> >
>
>
>
> --
> Regards,
> Varun Bhansaly
>
> --
> Thanks,
> Deepak Agarwal,
>
> Paxcel Technologies Pvt Ltd.
> Hartron Complex, Sector 18, Gurgaon, India.
> E-Mail: deepak.agarwal@paxcel.net
> Mobile: +91 9910322604
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message