Broadleaf Commerce Discussion Forums

We're upgrading a work in progress that was on BETA3 to GA and getting the following error at startup:

[ERROR] 09:51:50 ErrorLogger - Job (DEFAULT.rebuildIndexJobDetail threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.scheduling.quartz.JobMethodInvocationFailedException: Invocation of method 'rebuildIndex' on target class [class org.broadleafcommerce.core.search.service.solr.SolrSearchServiceImpl] failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: ERROR: column localeimpl0_.use_in_search_index does not exist

It looks like this is related to SOLR and that I need to create a new DB column but so far have not found the solution. Can anyone help?

Tom

Figured out that I had to add a column to the blc_locale table but...what is the proper way to find and fix these database changes from one release to the next?

Tom

There is an ant task called build-update-sql in the build.xml file in the root of the project. This takes in a database connection defined in the root build.properties file and will spit out a sql file in target/sql which holds all of the update and create statements.

Thanks...had to add the following to the ant task to eliminate a missing dependency complaint:



Something we noticed after going from BETA3 to GA is that when you add a SKU the appropriate selected product options appear but if you edit the SKU then all of the available options show up, including options that have not been associated with the product. I don't recall this happening before the upgrade from BETA3 to GA...do you think it's an error in GA or something gone wrong during the upgrade?

Tom

This sounds like a bug in the GA.

If you could open an issue for it at github.com/BroadleafCommerce/BroadleafCommerce/issues that would be great.

And of course a pull request would be even better