#338 DUMPed database cannot be reloaded without errors!

3.7.0
closed-invalid
nobody
None
5
2013-09-03
2013-09-03
HarryD
No

DUMP generates output which, when used to recreate the database, causes errors.

Just the faulty line:

CREATE TABLE "members" (
"memberid" integer NULL PRIMARY KEY AUTOINCREMENT,
...
"logincount" text NULL DEFAULT '0',
FOREIGN KEY ("groupid") REFERENCES "groups" ("groupid") ON DELETE NO ACTION ON UPDATE NO ACTION
)
Error in query (1): near "NO": syntax error

Discussion

  • HarryD

    HarryD - 2013-09-03

    I withdraw this report. It appears to be version sqlite related. Needs more investigation on my part.

     
  • Jakub Vrána

    Jakub Vrána - 2013-09-03
    • status: open --> closed-invalid
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks