SQLite requires that you enable the SQLite Cordova plug-in for your project, for more information see Add and Configure Plugins
help article. However, Cordova plugins are not supported in the simulator, so the fact that your project works in the simulator does not necessarily mean it would work on device in your case. When you run the project in the simulator, it would fall back to Web SQL, which syntax is very much the same as SQLite and everything might seem alright.
The error from the log is thrown by SQLite itself and not by Icenium. You can take a look at stackoverflow for common causes for this error:
Looking for tips & tricks directly from the Icenium team? Check out our blog!
Missed our first webinar, watch it here.
Share feedback and vote for features on our Feedback Portal.