regarding table not created in the sqlite in android application
<p>I am developing an android application in which i have to fetch and show database in a list.problem is that when i run the code it gives error android database sqlite exception..</p>

<p>its my database java adapter class code 
<a href="http://pastebin.com/Hx6PqVKB" rel="nofollow">http://pastebin.com/Hx6PqVKB</a></p>

<p>here is my custom adapter class code
<a href="http://pastebin.com/BFkdbrSC" rel="nofollow">http://pastebin.com/BFkdbrSC</a></p>

<p>can anyone help me in this regard.................</p>

<p>below is the Logcat crash report :</p>

<pre><code> 09-09 01:36:01.689: ERROR/Database(22703): Error inserting lights=Christmas Lights bonus=.25% profit dollar=5 description=adds .25% profit at plant completion
 09-09 01:36:01.689: ERROR/Database(22703): android.database.sqlite.SQLiteException: no such table: lights: , while compiling: INSERT INTO lights(lights, bonus, dollar, description) VALUES(?, ?, ?, ?);
 09-09 01:36:01.689: ERROR/Database(22703):     at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
 09-09 01:36:01.689: ERROR/Database(22703):     at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:92)
 09-09 01:36:01.689: ERROR/Database(22703):     at android.database.sqlite.SQLiteCompiledSql.&lt;init&gt;(SQLiteCompiledSql.java:65)
 09-09 01:36:01.689: ERROR/Database(22703):     at android.database.sqlite.SQLiteProgram.&lt;init&gt;(SQLiteProgram.java:83)
 09-09 01:36:01.689: ERROR/Database(22703):     at android.database.sqlite.SQLiteStatement.&lt;init&gt;(SQLiteStatement.java:41)
 09-09 01:36:01.689: ERROR/Database(22703):     at android.database.sqlite.SQLiteDatabase.compileStatement(SQLiteDatabase.java:1149)
 09-09 01:36:01.689: ERROR/Database(22703):     at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1549)
 09-09 01:36:01.689: ERROR/Database(22703):     at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1422)
 09-09 01:36:01.689: ERROR/Database(22703):     at com.redorange.database.MessageDbAdapter.InsertHeadShopValuesLights(MessageDbAdapter.java:360)
 09-09 01:36:01.689: ERROR/Database(22703):     at com.redorange.headshop.CustomAdapter.onCreate(CustomAdapter.java:42)
 09-09 01:36:01.689: ERROR/Database(22703):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
 09-09 01:36:01.689: ERROR/Database(22703):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1586)
 09-09 01:36:01.689: ERROR/Database(22703):     at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1638)
 09-09 01:36:01.689: ERROR/Database(22703):     at android.app.ActivityThread.access$1500(ActivityThread.java:117)
 09-09 01:36:01.689: ERROR/Database(22703):     at android.app.ActivityThread$H.handleMessage(ActivityThread.java:928)
 09-09 01:36:01.689: ERROR/Database(22703):     at android.os.Handler.dispatchMessage(Handler.java:99)
 09-09 01:36:01.689: ERROR/Database(22703):     at android.os.Looper.loop(Looper.java:123)
 09-09 01:36:01.689: ERROR/Database(22703):     at android.app.ActivityThread.main(ActivityThread.java:3647)
 09-09 01:36:01.689: ERROR/Database(22703):     at java.lang.reflect.Method.invokeNative(Native Method)
 09-09 01:36:01.689: ERROR/Database(22703):     at java.lang.reflect.Method.invoke(Method.java:507)
 09-09 01:36:01.689: ERROR/Database(22703):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
 09-09 01:36:01.689: ERROR/Database(22703):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
 09-09 01:36:01.689: ERROR/Database(22703):     at dalvik.system.NativeStart.main(Native Method)
</code></pre>

<p>Thanks in advance
Tushar</p>
