SQLSTATE[42S22]: Column not found: 1054 Unknown column 'igtv' in 'field list' — CyberPanel - WebHosting Control Panel for OpenLiteSpeed
CyberLoader

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

On my website's homepage, I want to change the descriptions of my services and add other services on the front page, in the website's admin panel I have an option to change but when I change the text I get this error.

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

My website is smmkeyfi.com I want to add text in this part: https://resimyukle.xyz/i/xT1RCP

This is part of my website's admin panel that allows you to edit the front page: https://resimyukle.xyz/i/PK14OC

P.S: This is a free script made and given away by some guy on a webmaster forum. I contacted the dev, he said he can't offer me support because this is a free product, I looked at his profile and it seems like he is offering PHP support services as a freelancer. I bought this site with the script installed, the previous owner doesn't have any coding experience.

I have zero coding skills/knowledge. I just mimicked the code that was used for other parts, as you can see.

This is the admin panel's homepage editing part;

@$_POST['nelerYapiyoruz']
@$_POST['facebook']
@$_POST['guvenliOdeme']
@$_POST['akilliFiyatlandirma']
@$_POST['apiDestegi']) {

$birinciBaslik = strip_tags($_POST['birinciBaslik']);
$ikinciBaslik = strip_tags($_POST['ikinciBaslik']);
$nelerYapiyoruz = strip_tags($_POST['nelerYapiyoruz']);
$instagram = strip_tags($_POST['instagram']);
$igtv = strip_tags($_POST['igtv']);
$twitter = strip_tags($_POST['twitter']);
$facebook = strip_tags($_POST['facebook']);
$Youtube = strip_tags($_POST['Youtube']);
$musteriMemnuniyeti = strip_tags($_POST['musteriMemnuniyeti']);
$guvenliOdeme = strip_tags($_POST['guvenliOdeme']);
$destek = strip_tags($_POST['destek']);
$esnekHarcama = strip_tags($_POST['esnekHarcama']);
$akilliFiyatlandirma = strip_tags($_POST['akilliFiyatlandirma']);
$apiDestegi = strip_tags($_POST['apiDestegi']);


$say = $db->from('anasayfaayar')
->all();

if (count($say) < 1) {
$query = $db->insert('anasayfaayar')
->set(array(
"birinciBaslik" => $birinciBaslik,
"ikinciBaslik" => $ikinciBaslik,
"nelerYapiyoruz" => $nelerYapiyoruz,
"instagram" => $instagram,
"igtv" => $igtv,
"twitter" => $twitter,
"facebook" => $facebook,
"Youtube" => $Youtube,
"musteriMemnuniyeti" =>$musteriMemnuniyeti,
"guvenliOdeme" => $guvenliOdeme,
"destek" => $destek,
"esnekHarcama" => $esnekHarcama,
"akilliFiyatlandirma" => $akilliFiyatlandirma,
"apiDestegi" => $apiDestegi
));
if ($query) {
include "admin/siteanasayfa.php";
Yonlendir("siteanasayfa.php");
} else {
include "admin/siteanasayfa.php";
echo ' swal("Bilgi", "Ekleme İşlemi Yapılamadı!.", "error"); ';
Yonlendir("siteanasayfa", 2);
}
} else {
$update = $db->update('anasayfaayar')
->set([
'birinciBaslik' => $birinciBaslik,
'ikinciBaslik' => $ikinciBaslik,
'nelerYapiyoruz' => $nelerYapiyoruz,
'instagram' => $instagram,
'igtv' => $igtv,
'facebook' => $facebook,
'twitter' => $twitter,
'Youtube' => $Youtube,
'musteriMemnuniyeti' => $musteriMemnuniyeti,
'guvenliOdeme' => $guvenliOdeme,
'destek' => $destek,
'esnekHarcama' => $esnekHarcama,
'akilliFiyatlandirma' => $akilliFiyatlandirma,
'apiDestegi' => $apiDestegi
]);
if ($update) {
include "admin/siteanasayfa.php";
Yonlendir("siteanasayfa.php");
} else {
include "admin/siteanasayfa.php";
echo ' swal("Bilgi", "Güncelleme İşlemi Yapılamadı.", "info"); ';
Yonlendir("siteanasayfa", 2);
}
}
};
I expected it to run smoothly. Instead, I got this error :

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

then 404 error page
Tagged:
Tagged:
Sign In or Register to comment.
CyberPanel Discord

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!