Hello Justine, Have you checked if files exist under themes\common-theme\webapp\common\js\node_modules as shared by Jacques?
if not, you could explicitly install js libraries with following command: ./gradlew npmInstall Thanks and regards, Aditya Sharma On Tue, Nov 16, 2021 at 3:52 AM Justine Nowak <[email protected]> wrote: > 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 < > [email protected]> 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 < > > > [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 > > >>>>>>>>>>>>>>>>>>> > > >
