I have a PHP page which does little else but drop tables to clear out
tables from the DB.  This page worked prior to 0.4 being released.
All other pages and DB access works fine.

The error is: Could not delete tables: SQLite prepare() failed. ERROR:
SQL logic error or missing database DETAILS: no such table: activejobs
EXPRESSION: drop table activejobs;

Has anyone else experienced the same issue?

Thanks - GSN


The code is simple - I have not included the gears includes nor the
HTML.

        db = google.gears.factory.create('beta.database');
        try {
                db.open('damcoDB');

          } catch (ex) {
            alert('Could not open damcoDB: ' + ex.message);
          }

        try {

                db.execute('drop table activejobs;');
                db.execute('drop table currentsession;');

// I removed additional table entries here for simplicity

                db.execute('drop table out_manifest;');
                db.execute('drop table plates;');

                alert("Delete Complete");

                } catch (ex) {
            alert('Could not delete tables: ' + ex.message);
          }

try {
        db.close();
  } catch (ex) {
        alert('Could not close damcoDB: ' + ex.message);
  }

Reply via email to