ok after looking at this i worked it out that the error was from the admin script
so i removed the line by adding -- at the start
-- Group management DB entry
database:queryupdate("CREATE TABLE IF NOT EXISTS player (ID INTEGER PRIMARY KEY NOT NULL, name VARCHAR NOT NULL, groupID INTEGER);");
-- database:queryupdate("CREATE TABLE IF NOT EXISTS group (ID INTEGER PRIMARY KEY NOT NULL, name VARCHAR NOT NULL, adminID INTEGER NOT NULL);");
database:queryupdate("CREATE TABLE IF NOT EXISTS groupAdmin (ID INTEGER PRIMARY KEY NOT NULL, admin1 INTEGER, admin2 INTEGER, admin3 INTEGER);");
this has fixed the error but what i want to now know is why was this line giving this error it looks fine to me