SQL Lite NOT working On apple ipad(IOS)

[Arthanari]

[LOG] DB opened: undefined
[LOG] Error: SQL statement error : no such table

But it works fine in simulator
The log file shows this kind of errors, Im stuck with this problem for last one week, pls  suggest me some Solutions


Thanks
Arthanari

[Steve]

Hello Arthanari,

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:

• http://stackoverflow.com/questions/934237/sqlite-exception-no-such-table-error
• http://stackoverflow.com/questions/13533619/sqlite-no-such-table

Regards,
Steve
Telerik

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.

[Arthanari]

Hi steve,

                  Thanks for your reply, i added cordova plugins, But still i cant get, Pls suggest another solution, And the other is, the sample sqllite that given in example project works fine on device, is any any jquery problem in it??   This problem only in Apple ipad(IOS), bt it run fine in androifd devices...

Thanks
Arthanari

[Steve]

Hello Arthanari,

If it works both on Simulator and Android, the problem could be that the file paths/names you use in your app do not match the correct case. The filesystem in iOS is case-sensitive, whereas the Android filesystem and the Simulator are not.

Regards,
Steve
Telerik

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.

[Arthanari]

hi Steve,

                   Thank you very much. But the problem is in app.error, it throws error in log file, i cant rectify it.


Thanks,
Arthanari

[Arthanari]

hi Steve,

                    But the problem is in app.error, it throws error in log file, i cant rectify it.


Thanks,
Arthanari

[Steve]

Hi Arthanari,

Let us know the name of your project and we would look into it.

Regards,
Steve
Telerik

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.

[Arthanari]

Hi steve,

                   Its an news app project, in that the comments are given for each article and stored in device, this is the concept... and the other thing is the plugin which i add shows in green colour underline...

Thanks
Arthanari

[Arthanari]

Hi steve,

                    I attached js file, in which it throws error
[Detected docs path: /var/mobile/Applications/F562885E-2D93-4750-ABBB-53DC834BAC06/Documents
using db name: /var/mobile/Applications/F562885E-2D93-4750-ABBB-53DC834BAC06/Documents/Todo
[LOG] DB opened: undefined
[LOG] Error: SQL statement error : no such table: comm

pls find this error


thanks in advance


Arthanari

[Arthanari]

hi Steve,

               I got it..... Thanks for ur replies..


Regards,
Arthanari

[Harry]

Hi Arthanari,

I am getting the same error - what did you do to resolve this in the end?

Many Thanks

Harry

[Arthanari]

Hi Harry,

Its a syntax problem in creating tables, Please check it.



Thanks
Arthanari