Forgot the previous email, we fixed it. But still, after rebuilding Ofbiz we still don't have the Javascript libs created.
On Sun, Nov 14, 2021 at 1:32 PM Justine Nowak <[email protected]> wrote: > 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 < > [email protected]> 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 < >> > [email protected]> 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 < >> >>>> [email protected]> 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 < >> [email protected]> >> >>>>> 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 < >> >>>>>>> [email protected]> >> >>>>>>> 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< >> >>>>>>>> [email protected]> >> >>>>>>>>> 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< >> >> [email protected]> >> >>>>>>>>>> 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< >> >> [email protected] >> >>>>>>>>>>>> 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< >> >>>>> [email protected] >> >>>>>>>>>>>>> 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< >> >>>>>>> [email protected]> >> >>>>>>>>>>>>>> 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< >> >>>>>>> [email protected] >> >>>>>>>>>>>>>>> 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 < >> >>>>>>>>>>>> [email protected]> >> >>>>>>>>>>>>>>>> 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 >> >>>>>>>>>>>>>>>>> >> >
