Why is onupgradeneeded never called in this code?

Question

I'm trying to insert data in my indexed db, but the function onupgradeneed never is called, just onsuccess. The version of the database is always the same (it is a global variable). I have understood that in order to get into onupgradeneed the version have to be always the same. In my case, it is in this way. So, I have no data... What can I do? Thanks!

var db;
var dbname = "mi";
var dbversion = 1;

function abrirDB()
{
    if (plataforma == plataformaW8) {
        if (db == null) {
            var request = window.indexedDB.open(dbname, dbversion);
            request.onsuccess = function (evt) {
                db = evt.target.result;
                if (db.objectStoreNames.length == 0)
                    crearDB();
            };
            }
        }
}
function crearDB() {


   //Declaración datos BBDD

        var paisesData = [{ id_pais: 1, pais: "Arabia Saudí", continente: "Asia", capital: "Riad", paisurl: "arabiasaudi", continenteurl: "asia" },
      { id_pais: 2, pais: "Emiratos Árabes Unidos", continente: "Asia", capital: "Abu Dhabi", paisurl: "emiratosarabes", continenteurl: "asia" }];


    //////////

    //Abrir BBDD
    var request =window.indexedDB.open(dbname, dbversion);

    request.onerror = function (evt) {
        console.log("Error al abrir la bbdd" + evt.target.errorCode);
    };


    request.onupgradeneeded = function (evt) {
       db = evt.target.result;

        var storePaises = db.createObjectStore(storePaisesNombre, { keyPath: "id_pais", autoincrement: false, unique: true });
      .......
    request.onsuccess = function (evt) {
        //db = request.result;
        db = evt.target.result;
    };

  }

score 2 · Answer 1 · answered Oct 18 '13 at 08:30

2

Change your dbversion variable to 2. This way the db will open in a newer version and the onupgradeneeded callback will get called

answered Oct 18 '13 at 08:30

Kristof Degrave

4,142
22
32

score 2 · Answer 2 · edited Jul 09 '20 at 00:17

2

you can change version 1 for two, it worked for me like this:

let openRequest = window.indexedDB.open ("MyTestDatabase", 2);

edited Jul 09 '20 at 00:17

Jared Forth

1,577
6
17
32

answered Jul 08 '20 at 14:47

NATALIAGJ

105
5

score 0 · Answer 3 · edited May 23 '17 at 10:25

0

Stop using a global db variable, even if some examples show it. It just leads to problems for newer programmers. Try reviewing my answer at How to get objectstore from indexedDB? for help.

edited May 23 '17 at 10:25

Community

1
1

answered Oct 17 '13 at 19:09

Josh

17,834
7
50
68

I have already solved it. It was a problem in another file that was calling a function before my request had finished. – luperxe Oct 18 '13 at 09:11

Why is onupgradeneeded never called in this code?

3 Answers3

Linked