You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cordova.apache.org by "Ronnie Schaniel (JIRA)" <ji...@apache.org> on 2012/09/26 14:05:08 UTC
[jira] [Created] (CB-1546) index.html DB Error: Could not prepare
statement (1 no such table: table_name) Code=5 on ios6
Ronnie Schaniel created CB-1546:
-----------------------------------
Summary: index.html DB Error: Could not prepare statement (1 no such table: table_name) Code=5 on ios6
Key: CB-1546
URL: https://issues.apache.org/jira/browse/CB-1546
Project: Apache Cordova
Issue Type: Bug
Components: iOS
Reporter: Ronnie Schaniel
Assignee: Shazron Abdullah
My app gets the data from a mysql database. After updating the iphone to ios6 I'm facing a database error. "DB Error: Could not prepare statement (1 no such table: table_name) Code=5". I upgraded the cordova from 1.7 to 2.1 but I still have this problem. The error appears in the ios6 simulator on xcode too.
There is surely no problem with the database itself because the webservice and the android app receive the correct data without an error.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (CB-1546) index.html DB Error: Could not prepare
statement (1 no such table: table_name) Code=5 on ios6
Posted by "Andrew Grieve (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrew Grieve resolved CB-1546.
-------------------------------
Resolution: Invalid
Assignee: Andrew Grieve (was: Shazron Abdullah)
Okay, I was able to use your code to repro it working on iOS 5 but not 6. However, it looks like the error is in your code and iOS5 was just more forgiving.
You should change your db.transaction() call from:
db.transaction(function, [], win, fail)
to:
db.transaction(function, fail, win)
> index.html DB Error: Could not prepare statement (1 no such table: table_name) Code=5 on ios6
> ---------------------------------------------------------------------------------------------
>
> Key: CB-1546
> URL: https://issues.apache.org/jira/browse/CB-1546
> Project: Apache Cordova
> Issue Type: Bug
> Components: iOS
> Reporter: Ronnie Schaniel
> Assignee: Andrew Grieve
> Attachments: Bildschirmfoto 2012-09-26 um 20.10.42.png
>
>
> My app gets the data from a mysql database. After updating the iphone to ios6 I'm facing a database error. "DB Error: Could not prepare statement (1 no such table: table_name) Code=5". I upgraded the cordova from 1.7 to 2.1 but I still have this problem. The error appears in the ios6 simulator on xcode too.
> There is surely no problem with the database itself because the webservice and the android app receive the correct data without an error.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CB-1546) index.html DB Error: Could not prepare
statement (1 no such table: table_name) Code=5 on ios6
Posted by "Andrew Grieve (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13463885#comment-13463885 ]
Andrew Grieve commented on CB-1546:
-----------------------------------
Yes, from your description it sounds like the problem isn't with Cordova, but in your app somewhere. Cordova doesn't use MySQL anywhere.
> index.html DB Error: Could not prepare statement (1 no such table: table_name) Code=5 on ios6
> ---------------------------------------------------------------------------------------------
>
> Key: CB-1546
> URL: https://issues.apache.org/jira/browse/CB-1546
> Project: Apache Cordova
> Issue Type: Bug
> Components: iOS
> Reporter: Ronnie Schaniel
> Assignee: Shazron Abdullah
>
> My app gets the data from a mysql database. After updating the iphone to ios6 I'm facing a database error. "DB Error: Could not prepare statement (1 no such table: table_name) Code=5". I upgraded the cordova from 1.7 to 2.1 but I still have this problem. The error appears in the ios6 simulator on xcode too.
> There is surely no problem with the database itself because the webservice and the android app receive the correct data without an error.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CB-1546) index.html DB Error: Could not prepare
statement (1 no such table: table_name) Code=5 on ios6
Posted by "Ronnie Schaniel (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ronnie Schaniel updated CB-1546:
--------------------------------
Attachment: screenshot-1.jpg
> index.html DB Error: Could not prepare statement (1 no such table: table_name) Code=5 on ios6
> ---------------------------------------------------------------------------------------------
>
> Key: CB-1546
> URL: https://issues.apache.org/jira/browse/CB-1546
> Project: Apache Cordova
> Issue Type: Bug
> Components: iOS
> Reporter: Ronnie Schaniel
> Assignee: Shazron Abdullah
> Attachments: screenshot-1.jpg
>
>
> My app gets the data from a mysql database. After updating the iphone to ios6 I'm facing a database error. "DB Error: Could not prepare statement (1 no such table: table_name) Code=5". I upgraded the cordova from 1.7 to 2.1 but I still have this problem. The error appears in the ios6 simulator on xcode too.
> There is surely no problem with the database itself because the webservice and the android app receive the correct data without an error.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CB-1546) index.html DB Error: Could not prepare
statement (1 no such table: table_name) Code=5 on ios6
Posted by "Ronnie Schaniel (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ronnie Schaniel updated CB-1546:
--------------------------------
Attachment: (was: screenshot-2.jpg)
> index.html DB Error: Could not prepare statement (1 no such table: table_name) Code=5 on ios6
> ---------------------------------------------------------------------------------------------
>
> Key: CB-1546
> URL: https://issues.apache.org/jira/browse/CB-1546
> Project: Apache Cordova
> Issue Type: Bug
> Components: iOS
> Reporter: Ronnie Schaniel
> Assignee: Shazron Abdullah
>
> My app gets the data from a mysql database. After updating the iphone to ios6 I'm facing a database error. "DB Error: Could not prepare statement (1 no such table: table_name) Code=5". I upgraded the cordova from 1.7 to 2.1 but I still have this problem. The error appears in the ios6 simulator on xcode too.
> There is surely no problem with the database itself because the webservice and the android app receive the correct data without an error.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CB-1546) index.html DB Error: Could not prepare
statement (1 no such table: table_name) Code=5 on ios6
Posted by "Andrew Grieve (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13463802#comment-13463802 ]
Andrew Grieve commented on CB-1546:
-----------------------------------
Are you able to provide repro steps?
> index.html DB Error: Could not prepare statement (1 no such table: table_name) Code=5 on ios6
> ---------------------------------------------------------------------------------------------
>
> Key: CB-1546
> URL: https://issues.apache.org/jira/browse/CB-1546
> Project: Apache Cordova
> Issue Type: Bug
> Components: iOS
> Reporter: Ronnie Schaniel
> Assignee: Shazron Abdullah
>
> My app gets the data from a mysql database. After updating the iphone to ios6 I'm facing a database error. "DB Error: Could not prepare statement (1 no such table: table_name) Code=5". I upgraded the cordova from 1.7 to 2.1 but I still have this problem. The error appears in the ios6 simulator on xcode too.
> There is surely no problem with the database itself because the webservice and the android app receive the correct data without an error.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CB-1546) index.html DB Error: Could not prepare
statement (1 no such table: table_name) Code=5 on ios6
Posted by "Ronnie Schaniel (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13463853#comment-13463853 ]
Ronnie Schaniel commented on CB-1546:
-------------------------------------
Unfortunately not. Do you need any further information?
> index.html DB Error: Could not prepare statement (1 no such table: table_name) Code=5 on ios6
> ---------------------------------------------------------------------------------------------
>
> Key: CB-1546
> URL: https://issues.apache.org/jira/browse/CB-1546
> Project: Apache Cordova
> Issue Type: Bug
> Components: iOS
> Reporter: Ronnie Schaniel
> Assignee: Shazron Abdullah
>
> My app gets the data from a mysql database. After updating the iphone to ios6 I'm facing a database error. "DB Error: Could not prepare statement (1 no such table: table_name) Code=5". I upgraded the cordova from 1.7 to 2.1 but I still have this problem. The error appears in the ios6 simulator on xcode too.
> There is surely no problem with the database itself because the webservice and the android app receive the correct data without an error.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CB-1546) index.html DB Error: Could not prepare
statement (1 no such table: table_name) Code=5 on ios6
Posted by "Ronnie Schaniel (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ronnie Schaniel updated CB-1546:
--------------------------------
Attachment: screenshot-2.jpg
> index.html DB Error: Could not prepare statement (1 no such table: table_name) Code=5 on ios6
> ---------------------------------------------------------------------------------------------
>
> Key: CB-1546
> URL: https://issues.apache.org/jira/browse/CB-1546
> Project: Apache Cordova
> Issue Type: Bug
> Components: iOS
> Reporter: Ronnie Schaniel
> Assignee: Shazron Abdullah
>
> My app gets the data from a mysql database. After updating the iphone to ios6 I'm facing a database error. "DB Error: Could not prepare statement (1 no such table: table_name) Code=5". I upgraded the cordova from 1.7 to 2.1 but I still have this problem. The error appears in the ios6 simulator on xcode too.
> There is surely no problem with the database itself because the webservice and the android app receive the correct data without an error.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CB-1546) index.html DB Error: Could not prepare
statement (1 no such table: table_name) Code=5 on ios6
Posted by "Peter Warren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13464639#comment-13464639 ]
Peter Warren commented on CB-1546:
----------------------------------
This happened to me. My data was being deleted.
see https://issues.apache.org/jira/browse/CB-1535
> index.html DB Error: Could not prepare statement (1 no such table: table_name) Code=5 on ios6
> ---------------------------------------------------------------------------------------------
>
> Key: CB-1546
> URL: https://issues.apache.org/jira/browse/CB-1546
> Project: Apache Cordova
> Issue Type: Bug
> Components: iOS
> Reporter: Ronnie Schaniel
> Assignee: Andrew Grieve
> Attachments: Bildschirmfoto 2012-09-26 um 20.10.42.png
>
>
> My app gets the data from a mysql database. After updating the iphone to ios6 I'm facing a database error. "DB Error: Could not prepare statement (1 no such table: table_name) Code=5". I upgraded the cordova from 1.7 to 2.1 but I still have this problem. The error appears in the ios6 simulator on xcode too.
> There is surely no problem with the database itself because the webservice and the android app receive the correct data without an error.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CB-1546) index.html DB Error: Could not prepare
statement (1 no such table: table_name) Code=5 on ios6
Posted by "Ronnie Schaniel (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ronnie Schaniel updated CB-1546:
--------------------------------
Attachment: Bildschirmfoto 2012-09-26 um 20.10.42.png
> index.html DB Error: Could not prepare statement (1 no such table: table_name) Code=5 on ios6
> ---------------------------------------------------------------------------------------------
>
> Key: CB-1546
> URL: https://issues.apache.org/jira/browse/CB-1546
> Project: Apache Cordova
> Issue Type: Bug
> Components: iOS
> Reporter: Ronnie Schaniel
> Assignee: Shazron Abdullah
> Attachments: Bildschirmfoto 2012-09-26 um 20.10.42.png
>
>
> My app gets the data from a mysql database. After updating the iphone to ios6 I'm facing a database error. "DB Error: Could not prepare statement (1 no such table: table_name) Code=5". I upgraded the cordova from 1.7 to 2.1 but I still have this problem. The error appears in the ios6 simulator on xcode too.
> There is surely no problem with the database itself because the webservice and the android app receive the correct data without an error.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CB-1546) index.html DB Error: Could not prepare
statement (1 no such table: table_name) Code=5 on ios6
Posted by "Ronnie Schaniel (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ronnie Schaniel updated CB-1546:
--------------------------------
Attachment: (was: screenshot-1.jpg)
> index.html DB Error: Could not prepare statement (1 no such table: table_name) Code=5 on ios6
> ---------------------------------------------------------------------------------------------
>
> Key: CB-1546
> URL: https://issues.apache.org/jira/browse/CB-1546
> Project: Apache Cordova
> Issue Type: Bug
> Components: iOS
> Reporter: Ronnie Schaniel
> Assignee: Shazron Abdullah
>
> My app gets the data from a mysql database. After updating the iphone to ios6 I'm facing a database error. "DB Error: Could not prepare statement (1 no such table: table_name) Code=5". I upgraded the cordova from 1.7 to 2.1 but I still have this problem. The error appears in the ios6 simulator on xcode too.
> There is surely no problem with the database itself because the webservice and the android app receive the correct data without an error.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CB-1546) index.html DB Error: Could not prepare
statement (1 no such table: table_name) Code=5 on ios6
Posted by "Ronnie Schaniel (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13464006#comment-13464006 ]
Ronnie Schaniel commented on CB-1546:
-------------------------------------
Well...all the data from the mysql database is send in json. Then I think the App uses openDatabase to store the data, but that is not the point the error appears. In the index.html file a function onDeviceReady() calls another function setupTables(dbShell) after that the function loadAddresses should be executed.
According to the log setupTables(dbShell) is the last executed function at the iOS6 simulator. The iOS5.1 simulator shows the invocation of the loadAddresses function. I attached the corresponding function as a screenshot.
"Setup tables for locale database" is the last log entry.
> index.html DB Error: Could not prepare statement (1 no such table: table_name) Code=5 on ios6
> ---------------------------------------------------------------------------------------------
>
> Key: CB-1546
> URL: https://issues.apache.org/jira/browse/CB-1546
> Project: Apache Cordova
> Issue Type: Bug
> Components: iOS
> Reporter: Ronnie Schaniel
> Assignee: Shazron Abdullah
>
> My app gets the data from a mysql database. After updating the iphone to ios6 I'm facing a database error. "DB Error: Could not prepare statement (1 no such table: table_name) Code=5". I upgraded the cordova from 1.7 to 2.1 but I still have this problem. The error appears in the ios6 simulator on xcode too.
> There is surely no problem with the database itself because the webservice and the android app receive the correct data without an error.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira