Hi Jacques, We are using Mysql, what command would we use for Mysql.
On Mon, Nov 15, 2021 at 3:08 AM Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Hi Justine, > > Are you using Derby (OOTB DBMS) or another external DBMS like Postgres? > In the 1st case simply try "gradlew cleanData loadAll ofbiz" > > HTH > > Jacques > > Le 14/11/2021 à 20:32, Justine Nowak a écrit : > > Hello, > > > > We rebuilt Ofbiz to get the NPM to load all the files and we now get the > > following error on our website. > > > > *Type* Exception Report > > > > *Message* Could not get next sequenced ID for sequence name: Visit > > > > *Description* The server encountered an unexpected condition that > prevented > > it from fulfilling the request. > > > > *Exception* > > > > java.lang.IllegalArgumentException: Could not get next sequenced ID > > for sequence name: Visit > > > > org.apache.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2362) > > > > org.apache.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2349) > > > org.apache.ofbiz.entity.GenericEntity.setNextSeqId(GenericEntity.java:726) > > > > org.apache.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator.java:784) > > > org.apache.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:189) > > > org.apache.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:100) > > > > org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:214) > > > org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:655) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:764) > > > org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) > > > > org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:45) > > > > org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) > > > > org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:156) > > javax.servlet.http.HttpFilter.doFilter(HttpFilter.java:57) > > > > org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) > > > > *Note* The full stack trace of the root cause is available in the server > > logs. > > > > > > > > > > On Sun, Nov 14, 2021 at 1:22 AM Jacques Le Roux < > > jacques.le.r...@les7arts.com> wrote: > > > >> Hi Justine, > >> > >> Actually it's normally loaded by npm when you build OFBiz with Gradle. > >> Gradle uses the > >> https://plugins.gradle.org/plugin/com.github.node-gradle.node plugin > for > >> executing loading few js libs. > >> > >> What are you actually doing "When [you] go to open the JS files tomcat"? > >> > >> > >> Le 14/11/2021 à 06:17, Justine Nowak a écrit : > >>> Hi Jacques, > >>> > >>> When I go to open the JS files tomcat gives me this output- The > requested > >>> resource [/common/js/node_modules/jquery/dist/jquery.min.js] is not > >>> available > >>> > >>> Where do I download the JS libs or does NPM do that? > >>> > >>> > >>> On Sat, Nov 13, 2021 at 2:48 AM Jacques Le Roux < > >>> jacques.le.r...@les7arts.com> wrote: > >>> > >>>> Forgot: note that when I speak about trunk and R18 I always speak > about > >>>> the HEAD versions, ie the last up to date versions. > >>>> > >>>> Le 13/11/2021 à 09:38, Jacques Le Roux a écrit : > >>>>> Hi Justine, > >>>>> > >>>>> Mmm, that's no good. I know you made a versions mix at a moment. > Which > >>>> version are you now using? Or at least what is your primarily version? > >>>>> Because in trunk we now use npm to dynamically load (once) some js > libs > >>>> (jQuery is one) but in R18 all js libs are preloaded. > >>>>> As I see jquery-ui-1.13.0.min.js, I can conclude that you are rather > >>>> basically using a R18 version. In trunk, npm dynamically loads > jquery-ui > >>>> and we > >>>>> no longer put the version in the file name (it's anyway inside the > >>>> file). So check that you have all the js libs downloaded. > >>>>> I think you can neglect the 2nd point. It's a [Report Only]: > >>>>> > >> > https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/Content-Security-Policy-Report-Only > >>>>> This said where do you get this error (URL)? > >>>>> > >>>>> HTH > >>>>> > >>>>> Jacques > >>>>> > >>>>> > >>>>> Le 13/11/2021 à 06:39, Justine Nowak a écrit : > >>>>>> Hi Jacques, > >>>>>> > >>>>>> This is what shows when we check the Console. > >>>>>> > >>>>>> Uncaught ReferenceError: jQuery is not defined > >>>>>> at jquery-ui-1.13.0.min.js:6 > >>>>>> at jquery-ui-1.13.0.min.js:6 > >>>>>> > >>>>>> [Report Only] Refused to load the stylesheet ' > >>>>>> > >> > https://fonts.googleapis.com/css2?family=Quicksand:wght@300;400;500;600;700&display=swap > >>>> ' > >>>>>> because it violates the following Content Security Policy directive: > >>>>>> "default-src 'self'". Note that 'style-src-elem' was not explicitly > >>>> set, so > >>>>>> 'default-src' is used as a fallback. > >>>>>> > >>>>>> > >>>>>> > >>>>>> On Fri, Nov 12, 2021 at 1:52 AM Jacques Le Roux < > >>>>>> jacques.le.r...@les7arts.com> wrote: > >>>>>> > >>>>>>> Hi, > >>>>>>> > >>>>>>> You did not give enough information to help you. I suggest to have > a > >>>> look > >>>>>>> with the js console in your browser (F12 key there) > >>>>>>> > >>>>>>> Jacques > >>>>>>> > >>>>>>> Le 11/11/2021 à 03:38, Justine Nowak a écrit : > >>>>>>>> Hello, > >>>>>>>> > >>>>>>>> We got everything fixed, the CSS has not loaded and the system > >>>> upgrade is > >>>>>>>> finished. But once again we run into a product, non of the > >> javascript > >>>> is > >>>>>>>> working, the button inside of the text field to bring up the popup > >>>> search > >>>>>>>> isn't showing and non of the expanded forms are opening up. > >>>>>>>> > >>>>>>>> How do we fix this? > >>>>>>>> > >>>>>>>> > >>>>>>>> On Sun, Nov 7, 2021 at 2:18 AM Pierre Smits < > pierresm...@apache.org > >>>>>>> wrote: > >>>>>>>>> Goeiemoarn Justine, > >>>>>>>>> > >>>>>>>>> If the backend database of your OFBiz implementation is > >> professional > >>>>>>> grade > >>>>>>>>> (meaning anything else than the default integrated Apache Derby), > >>>>>>> cleanAll > >>>>>>>>> won't delete your data. > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> Met vriendelijke groet, > >>>>>>>>> > >>>>>>>>> Pierre Smits > >>>>>>>>> *Proud* *contributor** of* Apache OFBiz < > https://ofbiz.apache.org/ > >>>>>>> since > >>>>>>>>> 2008 (without privileges) > >>>>>>>>> Proud contributor to the ASF since 2006 > >>>>>>>>> > >>>>>>>>> *Apache Directory <https://directory.apache.org>, PMC Member* > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> On Sun, Nov 7, 2021 at 7:42 AM Jacques Le Roux < > >>>>>>>>> jacques.le.r...@les7arts.com> > >>>>>>>>> wrote: > >>>>>>>>> > >>>>>>>>>> Hi Justine, > >>>>>>>>>> > >>>>>>>>>> It will "only" replace the current DB content by the demo data. > So > >>>> if > >>>>>>> you > >>>>>>>>>> have important data there you need to keep a dump and then > >>>> meticulously > >>>>>>>>>> replace it again. If you don't want all the demo date load only > >> the > >>>>>>> seed. > >>>>>>>>>> checkhttps:// > >>>>>>>>>> > >> > ci.apache.org/projects/ofbiz/site/trunk/readme/html5/README.html#data-loading-tasks > >>>>>>>>>> out > >>>>>>>>>> > >>>>>>>>>> With something like|<<gradlew "ofbiz --load-data > >>>>>>>>>> readers=seed,seed-initial,ext,ext-demo">> you don't have to fear > >> for > >>>>>>> you > >>>>>>>>>> own templates. Only data will be affected. Jacques | > >>>>>>>>>> > >>>>>>>>>> Le 06/11/2021 à 22:32, Justine Nowak a écrit : > >>>>>>>>>>> Thank you for this information Jacques, > >>>>>>>>>>> > >>>>>>>>>>> gradlew cleanData loadAll - If we do this will it remove our > >>>> database > >>>>>>>>>>> content, or will it just load the ofbiz files. And if we have > >>>>>>>>> customized > >>>>>>>>>>> template files can we just save them and reupload them after? > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> On Sat, Nov 6, 2021 at 2:58 PM Jacques Le Roux< > >>>>>>>>>> jacques.le.r...@les7arts.com> > >>>>>>>>>>> wrote: > >>>>>>>>>>> > >>>>>>>>>>>> Hi Justine, > >>>>>>>>>>>> > >>>>>>>>>>>> Inline... > >>>>>>>>>>>> > >>>>>>>>>>>> Le 06/11/2021 à 20:46, Justine Nowak a écrit : > >>>>>>>>>>>>> maybe mixing trunk data with 18 design perhaps?? > >>>>>>>>>>>>> > >>>>>>>>>>>>> I believe that is the issue, how would we go with resolving > >> this? > >>>>>>>>>>>> I believe a simple "gradlew cleanData loadAll" should work if > >> you > >>>>>>> have > >>>>>>>>>> not > >>>>>>>>>>>> mixed code between R18 and trunk. If you mixed code then you > >> must > >>>>>>>>> start > >>>>>>>>>>>> from scratch being sure that you keep the your own modified > >> code. > >>>>>>>>>>>>> Also,version 18.12 doesn't include the Helveticus themes. > >>>>>>>>>>>> If you want Helveticus then you must use trunk > >>>>>>>>>>>> > >>>>>>>>>>>> HTH > >>>>>>>>>>>> > >>>>>>>>>>>> Jacques > >>>>>>>>>>>> > >>>>>>>>>>>>> -Justine > >>>>>>>>>>>>> > >>>>>>>>>>>>> On Sat, Nov 6, 2021 at 7:35 AM Pierre Smits< > >>>> pierresm...@apache.org> > >>>>>>>>>>>> wrote: > >>>>>>>>>>>>>> Bonjour Justine, > >>>>>>>>>>>>>> > >>>>>>>>>>>>>> As the 18 branch has come available as a demo site, we can > now > >>>> - in > >>>>>>>>> a > >>>>>>>>>>>> handy > >>>>>>>>>>>>>> kind of way - compare local implementations against what is > in > >>>> the > >>>>>>>>>> repo. > >>>>>>>>>>>>>> See e.ghttps://demo-stable.ofbiz.apache.org/accounting > >>>>>>>>>>>>>> > >>>>>>>>>>>>>> As it shows nothing wrong there, it seems that a mixup of > >>>> events at > >>>>>>>>>> your > >>>>>>>>>>>>>> side (maybe mixing trunk data with 18 design perhaps??) led > to > >>>> the > >>>>>>>>>> issue > >>>>>>>>>>>>>> you reported here. > >>>>>>>>>>>>>> > >>>>>>>>>>>>>> I trust everything is ok now. > >>>>>>>>>>>>>> > >>>>>>>>>>>>>> Met vriendelijke groet, > >>>>>>>>>>>>>> > >>>>>>>>>>>>>> Pierre Smits > >>>>>>>>>>>>>> *Proud* *contributor** of* Apache OFBiz< > >>>> https://ofbiz.apache.org/> > >>>>>>>>>>>> since > >>>>>>>>>>>>>> 2008 (without privileges) > >>>>>>>>>>>>>> Proud contributor to the ASF since 2006 > >>>>>>>>>>>>>> > >>>>>>>>>>>>>> *Apache Directory<https://directory.apache.org>, PMC > Member* > >>>>>>>>>>>>>> > >>>>>>>>>>>>>> > >>>>>>>>>>>>>> On Sat, Nov 6, 2021 at 1:10 AM Justine Nowak< > >>>> cougar11...@gmail.com > >>>>>>>>>>>>>> wrote: > >>>>>>>>>>>>>> > >>>>>>>>>>>>>>> Are you confident that data sets were loaded correctly? > >>>>>>>>>>>>>>> > >>>>>>>>>>>>>>> I'm not sure they were, we did try to upgrade Ofbiz last > week > >>>> to > >>>>>>>>>> 18.12 > >>>>>>>>>>>>>> but > >>>>>>>>>>>>>>> that was unsuccessful so we reverted back to the Trunk > >> version. > >>>>>>>>>>>>>>> > >>>>>>>>>>>>>>> On Fri, Nov 5, 2021 at 2:40 AM Pierre Smits< > >>>>>>> pierresm...@apache.org > >>>>>>>>>>>>>>> wrote: > >>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>> Bore Da Justine, > >>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>> Weird. I tried it using the various applications with the > >>>> themes > >>>>>>>>>>>>>>> available > >>>>>>>>>>>>>>>> in trunk this morning, and could not detect anything > wrong > >> on > >>>>>>>>> first > >>>>>>>>>>>>>>> sight > >>>>>>>>>>>>>>>> (visual inspection in browser and in log). > >>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>> Are you confident that data sets were loaded correctly? > >>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>> Met vriendelijke groet, > >>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>> Pierre Smits > >>>>>>>>>>>>>>>> *Proud* *contributor** of* Apache OFBiz< > >>>>>>> https://ofbiz.apache.org/ > >>>>>>>>>>>>>>> since > >>>>>>>>>>>>>>>> 2008 (without privileges) > >>>>>>>>>>>>>>>> Proud contributor to the ASF since 2006 > >>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>> *Apache Directory<https://directory.apache.org>, PMC > >> Member* > >>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>> On Thu, Nov 4, 2021 at 6:43 PM Justine Nowak< > >>>>>>>>> cougar11...@gmail.com> > >>>>>>>>>>>>>>>> wrote: > >>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>> Hi Pierre, > >>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>> We are using the Trunk version and there are no custom > CSS > >> / > >>>>>>>>>> themes. > >>>>>>>>>>>>>>>>> On Thu, Nov 4, 2021 at 4:09 AM Pierre Smits< > >>>>>>>>> pierresm...@apache.org > >>>>>>>>>>>>>>>>> wrote: > >>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>> Bonjour Justine, > >>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>> Unfortunately, settings regarding this mailing list > >> doesn't > >>>>>>>>> allow > >>>>>>>>>>>>>>>>>> attachments to come through. > >>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>> Can you tell which OFBiz version you are using, and > >> whether > >>>> the > >>>>>>>>>>>>>>>> theme/css > >>>>>>>>>>>>>>>>>> is custom? > >>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>> Met vriendelijke groet, > >>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>> Pierre Smits > >>>>>>>>>>>>>>>>>> *Proud* *contributor** of* Apache OFBiz < > >>>>>>>>>> https://ofbiz.apache.org/ > >>>>>>>>>>>>>>>>> since > >>>>>>>>>>>>>>>>>> 2008 (without privileges) > >>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>> *Apache Directory<https://directory.apache.org>, PMC > >>>> Member* > >>>>>>>>>>>>>>>>>> Apache Incubator<https://incubator.apache.org>, > committer > >>>>>>>>>>>>>>>>>> Apache Steve<https://steve.apache.org>, committer > >>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>> On Wed, Nov 3, 2021 at 9:49 PM Justine Nowak < > >>>>>>>>>>>>>> cougar11...@gmail.com> > >>>>>>>>>>>>>>>>>> wrote: > >>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>>> Hello, > >>>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>>> The past few days our css in our backend applications > >>>>>>> (catalog, > >>>>>>>>>>>>>>>>> partymgr, > >>>>>>>>>>>>>>>>>>> webtools) has not been loading. > >>>>>>>>>>>>>>>>>>> [image: Screen Shot 2021-11-03 at 3.47.51 PM.png] > >>>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>>> The HTML code shows the CSS link connected but it > doesn't > >>>>>>>>> render > >>>>>>>>>>>>>>> it. > >>>>>>>>>>>>>>>>> Even > >>>>>>>>>>>>>>>>>>> after refreshing and clearing all cookies, and on > >> multiple > >>>>>>>>>>>>>> devices. > >>>>>>>>>>>>>>>>>>> How do we fix this? > >>>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>>> -Justine > >>>>>>>>>>>>>>>>>>> >