SQLite3: table exist while insertting about ezsql HOT 6 CLOSED

Not sure, need more info, could be:

$db->query("CREATE TEMP TABLE temp.history( . . . )");

You could remove "TEMP". see https://database.guide/create-temporary-table-sqlite/
Or do:

$db->query("CREATE TABLE IF NOT EXISTS temp.history( . . . )");

How is the db connection setup?

from ezsql.

exact query is:

$db->query("DROP TABLE IF EXISTS temp.history");
$db->query("CREATE TEMP TABLE temp.history(s, id, oid, oli, p, q, qq, c, ca, t, ib, im, ibm)");
foreach ($history as $h)
{
	$db->insert('temp.history', $h);
}

connection is:

use ezsql\Database; // Load ezSQL Database Class
$db = Database::initialize('sqlite3', ['./database/', 'b.sqlite3']);
$db->connect();

from ezsql.

What's $history contents?

You should check see if the actual "$db->query(...)" returns false, which indicates not successful/error.

Or echo $db->getLastError(); after query call.

The warning line 441 referenced is actually for some other error logged.

Also your create table is not valid as you have it. No column types, primary keys, etc...

from ezsql.

$history is:

 ["s"]=> string(7) "ALLINONE" 
 ["id"]=> int(37544933) 
 ["iod"]=> int(620365953) 
 ["oli"]=> int(-1) 
 ["p"]=> string(10) "214.19500000" 
 ["q"]=> string(11) "942.45473600" 
 ["qq"]=> string(12) "5352.56700000" 
 ["c"]=> string(10) "12.67415903" 
 ["ca"]=> string(3) "WHATNEXT" 
 ["t"]=> int(1747210393384) 
 ["ib"]=> bool(true) 
 ["im"]=> bool(true) 
 ["ibm"]=> bool(true)

from ezsql.

You need to supply full sample,, so far what you have is not correct.

Why you doing a for loop on $history array?
That $db->insert(...) should fail the way you have it, each step thru it's not filling all columns.

Look over our Tests script.

from ezsql.

I am assuming your issue is resolved now, reopen if not.

from ezsql.