SQL ERROR ON Insert

April 13, 2021, 03:24:35 PM

I am having trouble on my project, on some pages I can insert rows. but on some pages I can't.

SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'field list'

C:\xampp\htdocs\ksms_new\app\models\PDODb.php On Line 459
StackTrace
1 C:\xampp\htdocs\ksms_new\app\models\PDODb.php(459): PDOStatement->execute()
2 C:\xampp\htdocs\ksms_new\app\models\PDODb.php(1151): PDODb->buildInsert('ks_accountbanned', Array, 'INSERT')
3 C:\xampp\htdocs\ksms_new\app\controllers\Ks_accountbannedController.php(134): PDODb->insert('ks_accountbanned', Array)
4 C:\xampp\htdocs\ksms_new\system\Router.php(196): Ks_accountbannedController->add(Array)
5 C:\xampp\htdocs\ksms_new\system\Router.php(109): Router->run('ks_accountbanned/add')
6 C:\xampp\htdocs\ksms_new\index.php(106): Router->init()

That's the error I am getting.

P.S. I am new to phprad thanks!

Re: SQL ERROR ON Insert

Reply #1 – April 26, 2021, 01:20:11 PM

@noob11‍ this means that one of the data being submitted fields does not exist in your database.