Skip to content

Missing additions to database update scripts #1488

@objecttothis

Description

@objecttothis

Issue / Question / Bug

Before submitting an issue please make sure you tick (add an x between the square brackets with no spaces) the following check boxes:

  • I'm reporting an issue of an unmodified OSPOS installation
  • I checked open and closed issues database and no similar issue was already discussed (please make sure you searched!)
  • I read the README, WHATS_NEW and UPGRADE
  • I read the FAQ (https://github.com/jekkos/opensourcepos#faq) for any known install and/or upgrade gotchas (in specific PHP has php-gd, php-intl, sockets and etc. installed)
  • I read the wiki
  • I ran any database upgrade scripts (e.g. database/2.4_to_3.0.sql), and migrating function
  • I'm aware the latest master could be a development version and therefore not stable
  • I know the version of OSPOS and git commit hash (check the footer of your OSPOS), the name and version of OS, Web server, PHP and MySQL and will add them to my issue report

Installation information

  • OSPOS version is: 3.1.0
  • OSPOS git commit hash is: 4f5ad57 (latest master as of 8/19)
  • PHP version is: (e.g. 5.5, 5.6, 7.0, 7.1) 5.6.31
  • MySQL or MariaDB version is: (e.g. MySQL 5.5, MySQL 5.6, MySQL 5.7, MariaDB 10.0, MariaDB 10.1, MariaDB 10.2) 5.7
  • OS and version is: (e.g. CentOS 6.9, Ubuntu 16.4, Windows 10) FreeBSD 11.0
  • WebServer is: (e.g. Apache 2.2, Apache 2.4, Nginx 1.12, Nginx 1.13) 2.4
  • (If applicable) Installation package for the LAMP/LEMP stack is: (e.g. WAMP, XAMPP) FAMP

Expected behaviour

Migration using scripts results in identical database structure and compatible data.

Actual behaviour

One or more database changes are missing in the update scripts. for example ospos_app_config is missing the number_locale key/value

Steps to reproduce the issue

Migrate 2.0.2 to 3.1.0 using database update scripts

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions