Statistik |
Beiträge: 144.506 (Täglich: 19,21 )
Themen: 16.699
Mitglieder: 13.209
Neuestes Mitglied: zitronentee.
Ausl. d. letzten Minute: 105%
Ausl. d. letzten 5 Minuten: 102%
Ausl. d. letzten 15 Minuten: 107%
Aktulle Uhrzeit: 13:48
Freier Webspace: 4.09 TB
PHP-Version: 7.4.33
|
|
|
|
|
mysql insert schlägt fehlt |
|
mysql insert schlägt fehlt |
|
huhus
seid fasst einer std suche ich den fehler nur finde ich den nicht
php: |
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
|
$sql = "INSERT INTO wcf" . WCF_N . "_user_zusatz_profilevideo
(id, userID, filesize,filename,audio_dataformat, audio_codec,audio_sample_rate,audio_bits_per_sample,
audio_channels,audio_channelmode,video_dataformat,video_frame_rate,video_resolution_x, video_resolution_y
,video_pixel_aspect_ratio,video_codec,playtime_seconds)
VALUES (''," . $user->userID . ",
" . $ThisFileInfo ['filesize'] . ",
" . $ThisFileInfo ['filename'] . ",
" . $ThisFileInfo['audio']['dataformat'] . ",
" . $ThisFileInfo['audio']['codec'] . ",
" . $ThisFileInfo['audio']['sample_rate'] . ",
" . $ThisFileInfo['audio']['bits_per_sample'] . ",
" . $ThisFileInfo['audio']['channels'] . ",
" . $ThisFileInfo['audio']['channelmode'] . ",
" . $ThisFileInfo['video']['dataformat'] . ",
" . $ThisFileInfo['video']['frame_rate'] . ",
" . $ThisFileInfo['video']['resolution_x'] . ",
" . $ThisFileInfo['video']['resolution_y'] . ",
" . $ThisFileInfo['video']['pixel_aspect_ratio'] . ",
".$ThisFileInfo['video']['codec'] . ",
" . $ThisFileInfo['playtime_seconds'] . "
)";
WCF::getDB ()->sendQuery ( $sql ); |
|
code: |
1:
2:
3:
4:
5:
6:
7:
8:
|
Information:
error message: Invalid SQL: INSERT INTO wcf1_user_zusatz_profilevideo (id, userID, filesize,filename,audio_dataformat, audio_codec,audio_sample_rate,audio_bits_per_sample, audio_channels,audio_channelmode,video_dataformat,video_frame_rate,video_resolution_x, video_resolution_y ,video_pixel_aspect_ratio,video_codec,playtime_seconds) VALUES ('',349, 306902520, 3812735_hd.flv, flv, AAC, 44100, 16, 2, stereo, flv, 30.002564395047, 1280, 720, 1.7777777777778, Sorenson H.264, 1165.967 )
error code: 1064
sql type: MySQLDatabase
sql error: 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 'H.264, 1165.967 )' at line 19
sql error number: 1064
sql version: |
|
wäre lieb wenn jemand den fehler findet
__________________
Ich bin nicht gestört - ich bin verhaltensoriginell
|
|
03.12.2014 14:18 |
|
|
|
fehler gefunden
php: |
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
|
$sql = "INSERT INTO wcf" . WCF_N . "_user_zusatz_profilevideo
(id, userID, filesize,filename,audio_dataformat, audio_codec,audio_sample_rate,audio_bits_per_sample,
audio_channels,audio_channelmode,video_dataformat,video_frame_rate,video_resolution_x, video_resolution_y
,video_pixel_aspect_ratio,video_codec,playtime_seconds)
VALUES (''," . $user->userID . ",
'" . $ThisFileInfo ['filesize'] . "',
'" . $ThisFileInfo ['filename'] . "',
'" . $ThisFileInfo['audio']['dataformat'] . "',
'" . $ThisFileInfo['audio']['codec'] . "',
'" . $ThisFileInfo['audio']['sample_rate'] . "',
'" . $ThisFileInfo['audio']['bits_per_sample'] . "',
'" . $ThisFileInfo['audio']['channels'] . "',
'" . $ThisFileInfo['audio']['channelmode'] . "',
'" . $ThisFileInfo['video']['dataformat'] . "',
'" . $ThisFileInfo['video']['frame_rate'] . "',
'" . $ThisFileInfo['video']['resolution_x'] . "',
'" . $ThisFileInfo['video']['resolution_y'] . "',
'" . $ThisFileInfo['video']['pixel_aspect_ratio'] . "',
'".$ThisFileInfo['video']['codec'] . "',
'" . $ThisFileInfo['playtime_seconds'] . "'
)";
WCF::getDB ()->sendQuery ( $sql ); |
|
muss man net verstehen das es an den ' lag
__________________
Ich bin nicht gestört - ich bin verhaltensoriginell
|
|
03.12.2014 18:41 |
|
|
|
|
|
|