SQL Lite NOT working On apple ipad(IOS)

12 posts, 0 answers
  1. Arthanari
    Arthanari avatar
    11 posts
    Member since:
    Apr 2013

    Posted 17 Jun 2013 Link to this post

    [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
  2. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 17 Jun 2013 Link to this post

    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.
  3. Arthanari
    Arthanari avatar
    11 posts
    Member since:
    Apr 2013

    Posted 17 Jun 2013 Link to this post

    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
  4. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 18 Jun 2013 Link to this post

    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.
  5. Arthanari
    Arthanari avatar
    11 posts
    Member since:
    Apr 2013

    Posted 18 Jun 2013 Link to this post

    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
  6. Arthanari
    Arthanari avatar
    11 posts
    Member since:
    Apr 2013

    Posted 18 Jun 2013 Link to this post

    hi Steve,

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


    Thanks,
    Arthanari
  7. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 18 Jun 2013 Link to this post

    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.
  8. Arthanari
    Arthanari avatar
    11 posts
    Member since:
    Apr 2013

    Posted 18 Jun 2013 Link to this post

    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
  9. Arthanari
    Arthanari avatar
    11 posts
    Member since:
    Apr 2013

    Posted 18 Jun 2013 Link to this post

    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

  10. Arthanari
    Arthanari avatar
    11 posts
    Member since:
    Apr 2013

    Posted 20 Jun 2013 Link to this post

    hi Steve,

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


    Regards,
    Arthanari
  11. Harry
    Harry avatar
    3 posts
    Member since:
    Jul 2013

    Posted 11 Feb 2014 in reply to Arthanari Link to this post

    Hi Arthanari,

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

    Many Thanks

    Harry
  12. Arthanari
    Arthanari avatar
    6 posts
    Member since:
    May 2013

    Posted 11 Feb 2014 in reply to Harry Link to this post

    Hi Harry,

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



    Thanks
    Arthanari
Back to Top