insert bug

[dayrui]

$rt = $this->db->table('admin_menu')->insert(array(
                    'pid' => 0,
                    'name' => $top['name'],
                    'uri' => $top['uri'] ?? '',
                    'url' => $top['url'] ?? '',
                    'mark' => $top['mark'] ?? '',
                    'icon' => $top['icon'] ?? '',
                    'hidden' => $top['hidden'] ?? 0,
                    'displayorder' => $top['displayorder'] ?? 0,
                ));
                print_r($rt);

return:

CodeIgniter\Database\MySQLi\Result Object
(
    [connID] => mysqli Object
        (
            [affected_rows] => -1
            [client_info] => 5.6.30
            [client_version] => 50630
            [connect_errno] => 0
            [connect_error] => 
            [errno] => 1146
            [error] => Table 'v3.dr_`dr_admin_menu' doesn't exist
            [error_list] => Array
                (
                    [0] => Array
                        (
                            [errno] => 1146
                            [sqlstate] => 42S02
                            [error] => Table 'v3.dr_`dr_admin_menu' doesn't exist
                        )

                )

[dayrui]

"insert" replace "replace"

[dayrui]

$this->db->table('admin_menu')->replace([

[sv3tli0]

It will be good if you use at least for your code the Markdown code tags (new line + ```, before and after the code). There is a URL to Markdown info page, down here left from Comment button ..

[lonnieezell]

I've edited the comment with the code tags like @sv3tli0 mentioned so it's all readable.

What I'm seeing, though, is the system telling you that Table 'v3.dr_dr_admin_menu' doesn't exist`. I don't know if you have $prefix set in database config file, but that's the only way that I can think of the system changing the table name that you're using. If you figure out that error, I think you'll find that it works as expected.

[dayrui]

@lonnieezell
I'm just so excited to find out which.

'database' => 'v3', 'DBPrefix' => 'dr_',
When using delete, insert, there will be an error

$this->db->table('admin_menu')->whereIn('id', $this->ids)->delete()
$this->db->table('admin_menu')->insert($insert)

/system/Database/BaseBuilder.php:

public function delete($where = '', $limit = null, $reset_data = true, $returnSQL = false) { $table = $this->QBFrom[0]; // repair

And:

`public function insert($set = null, $escape = null, $test = false)
{
if ($set !== null)
{
$this->set($set, '', $escape);
}

    if ($this->validateInsert() === false)
    {
        return false;
    }

    $sql = $this->_insert(
        $this->QBFrom[0], // Repair
        array_keys($this->QBSet),
        array_values($this->QBSet)
    );`

[sv3tli0]

Did you set any value to swapPrefix?
Field "swapPre" into App/Config/Database

[lonnieezell]

It does look like their might be an issue with some doubly-applied sanitization going on between the constructor and the from method.

Just to verify - what is your table name in the db, dr_admin_menu?

[lonnieezell]

@dayrui You'll be happy to know it's not your code. But it has unearthed a major bug in the handling of tables with prefixes. Working on that, but might take a touch to get it all working correctly.

[Rost445]

$this->db->table('admin_menu')->replace([

"replace" - Thanks for the advice! This worked for me...