android.database.sqlite.SQLiteException: table tb_diary2 has no column named recordPath 解決辦法
錯誤提示:
android.database.sqlite.SQLiteException: table tb_diary2 has no column named recordPath (code 1): , while compiling: insert into tb_diary2
出現背景:
更新了某個表,插入或刪除某個列:
如圖:
我在原來的tb_diary2中增添了一個欄位recordPath,對應的實體、Dao類也做了修改,結果在新增時程式報上面那個錯。
解決辦法:
修改資料庫名稱。比如說把上圖中原來的資料庫 name = “diary2.db”改為”diary3.db”。
修改表後插入報錯,可能sqlite沒有更新該資料庫下的表,只好修改資料庫名稱,新建一個。
相關文章
- SQLITE_ERROR - table sap_capire_bookshop_books has no column named currencySQLiteErrorAPI
- ModuleNotFoundError: No module named ‘DBUtils‘解決辦法Error
- This function has none of DETEMINISTIC,NO SQL錯誤解決辦法FunctionNoneSQL
- Myeclipse 錯誤An internal error has occurred 解決辦法EclipseError
- ORA-28001: the password has expired解決辦法
- ModuleNotFoundError: No module named ‘matplotlib‘ 一系列解決辦法Error
- “command-not-found has crashed” 解決辦法 (*unsolved)
- RedHat9的service named stop問題及解決辦法(轉)Redhat
- PHP Warning: exec() has been disabled for security 問題解決辦法PHP
- 資料庫 Table is marked as crashed and should be repaired 解決辦法資料庫AI
- Cargo invocation has failed: Error: exit code: 101.解決辦法CargoAIError
- android.database.sqlite.SQLiteException: no such table錯誤AndroidDatabaseSQLiteException
- Oracle opatch apply 時提示oci.dll has active的解決辦法OracleAPP
- 【Error】AttributeError: module ‘scipy.misc‘ has no attribute ‘logsumexp‘ 的解決辦法Error
- Starting sendmial: make: Warning: File 'virtusertable.db' has ..的解決辦法2
- ANS0326E This node has exceeded its maximum number of mount points 解決辦法
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 錯誤解決辦法FunctionNoneSQL
- Apache無法啟動解決 the requested operation has failedApacheAI
- pip install了之後還是顯示no module named xxx的解決辦法
- github慢解決辦法Github
- Grub Rescue解決辦法
- /dev/null解決辦法devNull
- MSBuild Tools解決辦法UI
- 檔案無法粉碎解決辦法
- oracle 19c 無法create table解決Oracle
- v$lock之alter table drop column與alter table set unused column區別系列五
- SQLAlchemy Table(表)類方式 – Table類和Column類SQL
- OpenStack 的NAT解決辦法
- android ExceptionInInitializerError解決辦法AndroidExceptionError
- Could not find *.apk!解決辦法APK
- man出錯解決辦法
- ARP病毒解決辦法
- 公寓噪音的解決辦法
- No module named MYSQLdb 問題解決MySql
- ImportError: No module named ‘torch‘ 解決方法ImportError
- ImportError: No module named setuptools 解決方法ImportError
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解決辦法ErrorMySql
- SSH 連線卡頓解決辦法