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;
if (@@$_POST[‘birinciBaslik’] || @@$_POST[‘ikinciBaslik’] || @@$_POST[‘nelerYapiyoruz’]
|| @@$_POST[‘instagram’] || @@$_POST[‘igtv’] || @@$_POST[‘twitter’] || @@$_POST[‘facebook’]
|| @@$_POST[‘Youtube’] || @@$_POST[‘musteriMemnuniyeti’] || @@$_POST[‘guvenliOdeme’]
|| @@$_POST[‘destek’] || @@$_POST[‘esnekHarcama’] || @@$_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 '<script type = "text/javascript"> swal("Bilgi", "Ekleme İşlemi Yapılamadı!.", "error"); </script>';
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 '<script type = "text/javascript"> swal("Bilgi", "Güncelleme İşlemi Yapılamadı.", "info"); </script>';
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