This is default install, per the directions, demo data, current version (17.12.04). It simply doesn't work.
On Mon, 26 Oct 2020 at 14:25, Dominic Amann <dominic.am...@gmail.com> wrote: > Here is the demo "Company" in display - note that it is in CA (california > state). > > And here when I click Update, the State field is empty, and I cannot > select a state. > > > > On Mon, 26 Oct 2020 at 14:21, Dominic Amann <dominic.am...@gmail.com> > wrote: > >> Thanks Georg. I am looking at a _huge_ table of entities, 900+ references >> to "Geo". I need to narrow it down but I don't really know what I am >> looking for. >> >> I found this: >> >> >> >> On Mon, 26 Oct 2020 at 13:57, Dominic Amann <dominic.am...@gmail.com> >> wrote: >> >>> I can confirm that values were loaded from the relevant xml file for my >>> country. >>> >>> Beginning import from URL: >>> file:/var/www/apache-ofbiz-17.12.04/framework/common >>> /data/GeoData_CA.xml >>> 2020-10-26 17:27:43,384 |main |EntitySaxReader >>> |I| >>> Transaction Timeout set to 2 hours (7200 seconds) >>> 2020-10-26 17:27:43,424 |main |EntitySaxReader >>> |I| >>> Finished 26 values from >>> file:/var/www/apache-ofbiz-17.12.04/framework/common/da >>> ta/GeoData_CA.xml >>> >>> On Mon, 26 Oct 2020 at 13:25, Dominic Amann <dominic.am...@gmail.com> >>> wrote: >>> >>>> Yes, the data is there (in XML). I guess I need to go poking around in >>>> the database to find out if it got into there during setup? Or >>>> perhaps check the pages of output during the "./gradlew loadAll " step... >>>> I'll do the latter first. >>>> >>>> On Mon, 26 Oct 2020 at 13:11, Jason RJ <jason_of...@reast.net> wrote: >>>> >>>>> Hi Dominic, >>>>> >>>>> Province data and similar locality data is part of the seed data and >>>>> loaded from the /framework/common/data/Geo*.xml files you should be >>>>> able >>>>> to spot that being loaded in your initial setup log output. It's been >>>>> a >>>>> while since I've spun up a clean instance, but the data is certainly >>>>> there so it's just not being loaded for some reason. >>>>> >>>>> Hope that helps, >>>>> >>>>> Jason >>>>> >>>>> >>>>> On 26/10/2020 16:55, Dominic Amann wrote: >>>>> > I am attempting to setup OFBiz for my business. >>>>> > >>>>> > I am a Linux developer of many years experience. >>>>> > >>>>> > I wanted a secure (SSL) setup, and I thought I would use Mariadb as I >>>>> > already use that for other software, and I would avoid duplication >>>>> with >>>>> > another database. I stretched this further by wanting to have no >>>>> demo data. >>>>> > >>>>> > I found it very difficult to accomplish all this. Much more >>>>> difficult than >>>>> > I might have expected for a major apache project. However, I >>>>> persevered, >>>>> > and after a whole weekend of work, I got it working to a first >>>>> order. I >>>>> > have documented each step I took. >>>>> > >>>>> > HOWEVER: >>>>> > >>>>> > I CANNOT ADD A PARTY MAILING ADDRESS. There are no provinces listed >>>>> for >>>>> > Canada. There are no states listed for the USA. I don't know other >>>>> > countries intimately, so I can't speak for them. As a result of being >>>>> > incomplete, I cannot add addresses at all. >>>>> > >>>>> > I initially thought this must be because I did not use the demo >>>>> data. So, I >>>>> > repeated my work, but left the demo data in place. SAME PROBLEM. >>>>> > >>>>> > Then I thought that perhaps I should do the migration (to Mysql) >>>>> AFTER >>>>> > setting up the initial data. That was BROKEN and wouldn't complete on >>>>> > import, and the resulting website wouldn't display properly. >>>>> > >>>>> > Then I thought it might be the database - perhaps it doesn't work >>>>> with >>>>> > mysql. I would just do the straightforward install, and work with >>>>> that. >>>>> > SAME PROBLEM. >>>>> > >>>>> > So here we are: 3 full days and I can't enter my first employee, >>>>> even with >>>>> > the simplest install with default settings. Of course there is one >>>>> > fundamental lesson here: never just believe that something works just >>>>> > because it is from a reputable project that has been out there for >>>>> years. I >>>>> > should have known better. >>>>> > >>>>> >>>> >>>> >>>> -- >>>> >>>> >>>> Dominic Amann >>>> >>>> M 416-270-4587 >>>> >>> >>> >>> -- >>> >>> >>> Dominic Amann >>> >>> M 416-270-4587 >>> >> >> >> -- >> >> >> Dominic Amann >> >> M 416-270-4587 >> > > > -- > > > Dominic Amann > > M 416-270-4587 > -- Dominic Amann M 416-270-4587