SQL ile ilgili sorun yaşıyorum.

05-05-2021, 19:10:33

$ekle = "INSERT INTO streams (id, type, category_id, stream_display_name, stream_source, stream_icon, notes, created_channel_location, enable_transcode, transcode_attributes, custom_ffmpeg, movie_propeties, movie_subtitles, read_native, target_container, stream_all, remove_subtitles, custom_sid, epg_id, channel_id, epg_lang, order, auto_restart, transcode_profile_id, pids_create_channel, cchannel_rsources, gen_timestamps, added, series_no, direct_source, tv_archive_duration, tv_archive_server_id, tv_archive_pid, movie_symlink, redirect_stream, rtmp_output, number, allow_record, probesize_ondemand, custom_map, external_push, delay_minutes) 
VALUES ($son_id,$type,$kategori_id,'".addslashes($isim[1][0])."','".addslashes($film_veri)."','".addslashes($afis[1][0])."','','',0,'[]','','','',0,'',0,0,'','','','',".$son_veri_order.",'',0,'','',1,'".$mc_time."',0,0,0,0,0,0,1,0,0,1,128000,'','[]',0)";

Her sütünu kontrol ettim, her sütunun veri tipini kontrol ettim ama bir türlü ekleyemedim.
Syntax hatası alıyorum.
Error description: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order, auto_restart, transcode_profile_id, pids_create_channel, cchannel_rsource' at line 1

Googleden bakıyorum, tırnakla ilgili olabilir diyor, tüm escapeleri denedim banamısın demedi, sorun ne olabilir?

05-05-2021, 21:25:20

#2

Fikirüssü

Merhaba,

VALUE sonrasında bir değeriniz eksik.

id, type, category_id, stream_display_name, stream_source, stream_icon, notes, created_channel_location, enable_transcode, transcode_attributes, custom_ffmpeg, movie_propeties, movie_subtitles, read_native, target_container, stream_all, remove_subtitles, custom_sid, epg_id, channel_id, epg_lang, order, auto_restart, transcode_profile_id, pids_create_channel, cchannel_rsources, gen_timestamps, added, series_no, direct_source, tv_archive_duration, tv_archive_server_id, tv_archive_pid, movie_symlink, redirect_stream, rtmp_output, number, allow_record, probesize_ondemand, custom_map, external_push, delay_minutes => 41 adet Virgül var

$son_id,$type,$kategori_id,'".addslashes($isim[1][0])."','".addslashes($film_veri)."','".addslashes($f ilm_link[$a])."','',0,'[]','','','[]',0,'["mp4"]',0,0,'','','','',[],'0','','',1,'',0,1,0,0,0,0,0,1,0,0,0,128000,'','[]',0 => 40 adet virgül var

1 adet virgül yani 1 adet VALUE değeriniz eksik.

05-05-2021, 21:35:35

#3

oktayc0

BedirhanERKAN adlı üyeden alıntı: mesajı görüntüle

Merhaba,

VALUE sonrasında bir değeriniz eksik.

id, type, category_id, stream_display_name, stream_source, stream_icon, notes, created_channel_location, enable_transcode, transcode_attributes, custom_ffmpeg, movie_propeties, movie_subtitles, read_native, target_container, stream_all, remove_subtitles, custom_sid, epg_id, channel_id, epg_lang, order, auto_restart, transcode_profile_id, pids_create_channel, cchannel_rsources, gen_timestamps, added, series_no, direct_source, tv_archive_duration, tv_archive_server_id, tv_archive_pid, movie_symlink, redirect_stream, rtmp_output, number, allow_record, probesize_ondemand, custom_map, external_push, delay_minutes => 41 adet Virgül var

$son_id,$type,$kategori_id,'".addslashes($isim[1][0])."','".addslashes($film_veri)."','".addslashes($f ilm_link[$a])."','',0,'[]','','','[]',0,'["mp4"]',0,0,'','','','',[],'0','','',1,'',0,1,0,0,0,0,0,1,0,0,0,128000,'','[]',0 => 40 adet virgül var

1 adet virgül yani 1 adet VALUE değeriniz eksik.

Evet hocam saydım, 1 eksikmiş ama sorun geçmedi, şimdi hepsi eşit, sorun halen aynı.

$ekle = "INSERT INTO streams (id, type, category_id, stream_display_name, stream_source, stream_icon, notes, created_channel_location, enable_transcode, transcode_attributes, custom_ffmpeg, movie_propeties, movie_subtitles, read_native, target_container, stream_all, remove_subtitles, custom_sid, epg_id, channel_id, epg_lang, order, auto_restart, transcode_profile_id, pids_create_channel, cchannel_rsources, gen_timestamps, added, series_no, direct_source, tv_archive_duration, tv_archive_server_id, tv_archive_pid, movie_symlink, redirect_stream, rtmp_output, number, allow_record, probesize_ondemand, custom_map, external_push, delay_minutes) 
VALUES ($son_id,$type,$kategori_id,'".addslashes($isim[1][0])."','".addslashes($film_veri)."','".addslashes($afis[1][0])."','','',0,'[]','','','',0,'',0,0,'','','','',".$son_veri_order.",'',0,'','',1,'".$mc_time."',0,0,0,0,0,0,1,0,0,1,128000,'','[]',0)";

05-05-2021, 21:49:41

#4

Fikirüssü

echo $ekle; yazıp, çıktıyı paylaşabilir misiniz ?

05-05-2021, 21:51:35

#5

oktayc0

BedirhanERKAN adlı üyeden alıntı: mesajı görüntüle

echo $ekle; yazıp, çıktıyı paylaşabilir misiniz ?

INSERT INTO streams (id, type, category_id, stream_display_name, stream_source, stream_icon, notes, created_channel_location, enable_transcode, transcode_attributes, custom_ffmpeg, movie_propeties, movie_subtitles, read_native, target_container, stream_all, remove_subtitles, custom_sid, epg_id, channel_id, epg_lang, order, auto_restart, transcode_profile_id, pids_create_channel, cchannel_rsources, gen_timestamps, added, series_no, direct_source, tv_archive_duration, tv_archive_server_id, tv_archive_pid, movie_symlink, redirect_stream, rtmp_output, number, allow_record, probesize_ondemand, custom_map, external_push, delay_minutes) VALUES (10972,2,72824,'▃ ▅ ▆ █ x SPORTS █ ▆ ▅ ▃','http:\\/\\/xxxxx.com:8080\\/bot-12\\/w75tQitUgP\\/99809 ','','','',0,'[]','','','',0,'',0,0,'','','','',7719,'',0,'','',1,'1620240657',0,0,0,0,0,0,1,0,0,1,128000,'','[]',0)

05-05-2021, 21:57:36

#6