خطا در اکلیپس

[erfan.sh]

سلام من ی برنامه میخوام بنویسم ک با ارور های زیر برخوردم عکس ارور هارو گذاشتم و آخرش هم سورس رو گذاشتم ممنون میشم کمکم کنید.
128861128864

[erfan.sh]

public void useable(){

boolean checkdb=checkdb();

if(checkdb){

}else{
this.getReadableDatabase();
try{
copydatabase();
}
catch(IOException e){

}
}
}

public void open(){
mydb=SQLiteDatabase.openDatabase(path+Name,null, SQLiteDatabase.OPEN_READWRITE);

}
public void close(){
mydb.close();
}

public boolean checkdb(){
SQLiteDatabase db=null;
try{
db=SQLiteDatabase.openDatabase(path+Name, null, SQLiteDatabase.OPEN_READONLY);
}
catch(SQLException e)
{

}
//mydb.close();
return db !=null ? true:false;
}

[erfan.sh]

private void refresh(){
db.open();
int s=db.count("content", "Seasone");
Name=new String[s];
Tedad=new String[s];
for(int i=0;i<s;i++){
Name[i]=db.Season_display("content", i);
Tedad[i]=db.Story_count("content", Name[i].toString())+"";

}

فک کنم از همین دو قسمت مشکل داشته باشه

[ali_khodayar]

اگر بتونی BreakPoint بزاری و محل دیقیق خطا رو پیدا کنی و کد رو بزاری خیلی بهتره.

[atpf67]

فک کنم از همین دو قسمت مشکل داشته باشه


توی لاگتون خطا مربوط به یک شیء ListView در متد getView هست در واقع فکر کنم مربوط به آداپتر لیست ویو هست.

[erfan.sh]

public View getView(int position, View convertView, ViewGroup parent) { LayoutInflater in=getLayoutInflater();
View row=in.inflate(R.layout.row_season, parent,false);

TextView name=(TextView)row.findViewById(R.id.row_season_na me);
TextView tedad=(TextView)row.findViewById(R.id.row_season_t edad);
name.setText(Name[position]);
tedad.setText(Tedad[position]);

یعنی این قسمت؟؟

return (row);
توی لاگتون خطا مربوط به یک شیء ListView در متد getView هست در واقع فکر کنم مربوط به آداپتر لیست ویو هست.

[erfan.sh]

02-24 13:05:11.366: I/SqliteDatabaseCpp(20172): sqlite returned: error code = 1, msg = no such column: Saesone, db=data/data/com.example.dastan/databases/database
02-24 13:05:11.386: D/AndroidRuntime(20172): Shutting down VM
02-24 13:05:11.386: W/dalvikvm(20172): threadid=1: thread exiting with uncaught exception (group=0xa000f180)
02-24 13:05:11.456: E/AndroidRuntime(20172): FATAL EXCEPTION: main
02-24 13:05:11.456: E/AndroidRuntime(20172): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.dastan/com.example.dastan.list_season}: android.database.sqlite.SQLiteException: no such column: Saesone: , while compiling: select * from content where Saesone='فصل اول' group by Name
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.app.ActivityThread.performLaunchActivity(A ctivityThread.java:1956)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.app.ActivityThread.handleLaunchActivity(Ac tivityThread.java:1981)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.app.ActivityThread.access$600(ActivityThre ad.java:123)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.app.ActivityThread$H.handleMessage(Activit yThread.java:1147)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.os.Handler.dispatchMessage(Handler.java:99 )
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.os.Looper.loop(Looper.java:137)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.app.ActivityThread.main(ActivityThread.jav a:4424)
02-24 13:05:11.456: E/AndroidRuntime(20172): at java.lang.reflect.Method.invokeNative(Native Method)
02-24 13:05:11.456: E/AndroidRuntime(20172): at java.lang.reflect.Method.invoke(Method.java:511)
02-24 13:05:11.456: E/AndroidRuntime(20172): at com.android.internal.os.ZygoteInit$MethodAndArgsCa ller.run(ZygoteInit.java:784)
02-24 13:05:11.456: E/AndroidRuntime(20172): at com.android.internal.os.ZygoteInit.main(ZygoteInit .java:551)
02-24 13:05:11.456: E/AndroidRuntime(20172): at dalvik.system.NativeStart.main(Native Method)
02-24 13:05:11.456: E/AndroidRuntime(20172): Caused by: android.database.sqlite.SQLiteException: no such column: Saesone: , while compiling: select * from content where Saesone='فصل اول' group by Name
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.database.sqlite.SQLiteCompiledSql.native_c ompile(Native Method)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:68)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.database.sqlite.SQLiteProgram.compileSql(S QLiteProgram.java:143)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.database.sqlite.SQLiteProgram.compileAndbi ndAllArgs(SQLiteProgram.java:361)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:127)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:94)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:53)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.database.sqlite.SQLiteDirectCursorDriver.q uery(SQLiteDirectCursorDriver.java:47)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.database.sqlite.SQLiteDatabase.rawQueryWit hFactory(SQLiteDatabase.java:1564)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.database.sqlite.SQLiteDatabase.rawQuery(SQ LiteDatabase.java:1538)
02-24 13:05:11.456: E/AndroidRuntime(20172): at com.example.dastan.database.Story_count(database.j ava:127)
02-24 13:05:11.456: E/AndroidRuntime(20172): at com.example.dastan.list_season.refresh(list_season .java:57)
02-24 13:05:11.456: E/AndroidRuntime(20172): at com.example.dastan.list_season.onCreate(list_seaso n.java:22)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.app.Activity.performCreate(Activity.java:4 465)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.app.Instrumentation.callActivityOnCreate(I nstrumentation.java:1049)
02-24 13:05:11.456: E/AndroidRuntime(20172): at android.app.ActivityThread.performLaunchActivity(A ctivityThread.java:1920)
02-24 13:05:11.456: E/AndroidRuntime(20172): ... 11 more
02-24 13:05:11.476: D/dalvikvm(20172): GC_CONCURRENT freed 182K, 4% free 6681K/6919K, paused 0ms+0ms
02-24 13:05:11.476: E/SQLiteDatabase(20172): close() was never explicitly called on database 'data/data/com.example.dastan/databases/database'
02-24 13:05:11.476: E/SQLiteDatabase(20172): android.database.sqlite.DatabaseObjectNotClosedExc eption: Application did not close the cursor or database object that was opened here
02-24 13:05:11.476: E/SQLiteDatabase(20172): at android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1943)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at android.database.sqlite.SQLiteDatabase.openDatabas e(SQLiteDatabase.java:1007)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at android.database.sqlite.SQLiteDatabase.openDatabas e(SQLiteDatabase.java:986)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at android.database.sqlite.SQLiteDatabase.openDatabas e(SQLiteDatabase.java:962)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at com.example.dastan.database.checkdb(database.java: 71)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at com.example.dastan.database.useable(database.java: 45)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at com.example.dastan.Main.onCreate(Main.java:25)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at android.app.Activity.performCreate(Activity.java:4 465)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at android.app.Instrumentation.callActivityOnCreate(I nstrumentation.java:1049)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at android.app.ActivityThread.performLaunchActivity(A ctivityThread.java:1920)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at android.app.ActivityThread.handleLaunchActivity(Ac tivityThread.java:1981)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at android.app.ActivityThread.access$600(ActivityThre ad.java:123)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at android.app.ActivityThread$H.handleMessage(Activit yThread.java:1147)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at android.os.Handler.dispatchMessage(Handler.java:99 )
02-24 13:05:11.476: E/SQLiteDatabase(20172): at android.os.Looper.loop(Looper.java:137)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at android.app.ActivityThread.main(ActivityThread.jav a:4424)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at java.lang.reflect.Method.invokeNative(Native Method)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at java.lang.reflect.Method.invoke(Method.java:511)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at com.android.internal.os.ZygoteInit$MethodAndArgsCa ller.run(ZygoteInit.java:784)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at com.android.internal.os.ZygoteInit.main(ZygoteInit .java:551)
02-24 13:05:11.476: E/SQLiteDatabase(20172): at dalvik.system.NativeStart.main(Native Method)
02-24 13:05:11.816: I/dalvikvm(20172): threadid=3: reacting to signal 3
02-24 13:05:11.816: I/dalvikvm(20172): Wrote stack traces to '/data/anr/traces.txt'
02-24 13:05:11.986: I/dalvikvm(20172): threadid=3: reacting to signal 3
02-24 13:05:11.986: I/dalvikvm(20172): Wrote stack traces to '/data/anr/traces.txt'

اگر بتونی BreakPoint بزاری و محل دیقیق خطا رو پیدا کنی و کد رو بزاری خیلی بهتره.

[atpf67]

public View getView(int position, View convertView, ViewGroup parent) { LayoutInflater in=getLayoutInflater();
View row=in.inflate(R.layout.row_season, parent,false);

TextView name=(TextView)row.findViewById(R.id.row_season_na me);
TextView tedad=(TextView)row.findViewById(R.id.row_season_t edad);
name.setText(Name[position]);
tedad.setText(Tedad[position]);

یعنی این قسمت؟؟

return (row);

طبق اون لاگ آره مربوط به همین قسمته که توی اون کلاستون هم خط شماره ی 42 هست، ببینید خط 42 کدومه؟ طبق لاگتون یه مقداری اونجا null هست که نباید باشه.