PDA

Archiv verlassen und diese Seite im Standarddesign anzeigen : [SQL] Evtl kann mir mal Jemand den Fehler Geb_sql erklären



dalamtinar27
21.07.2012, 21:40
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 'gebgutschrift='500000.00', gebtage='30', gebak' at line 15

Ist der Fehler.
Dadurch kommt www.lose4clicks.de (http://www.lose4clicks.de) momentan nicht aus dem Wartungsmodus. Die SQL is komplett und das Script spricht doch auch an ?^^ Wo oder was muss ich denn da einstellen ?
'MFg
Danke um schnelle Hilfe.

Lokutos
21.07.2012, 23:03
poste doch mal die codezeilen in denen der code vorkommt:

'gebgutschrift='500000.00', gebtage='30'

dalamtinar27
21.07.2012, 23:17
gebtage smallint(11) unsignedABSACOSASCIIASINATANBIT_LENGTHBIT_COUNTCEI LINGCHAR_LENGTHCONNECTION_IDCOSCOTCRC32DAYOFMONTHD AYOFWEEKDAYOFYEARDEGREESEXPFLOORHOURINET_ATONLENGT HLNLOGLOG2LOG10MICROSECONDMINUTEMONTHOCTORDPIQUART ERRADIANSRANDROUNDSECONDSIGNSINSQRTTANTO_DAYSTIME_ TO_SECUNCOMPRESSED_LENGTHUNIX_TIMESTAMPUUID_SHORTW EEKWEEKDAYWEEKOFYEARYEARWEEK--------BINCHARCOMPRESSCURRENT_DATECURRENT_TIMECURRENT_USE RDATABASEDATEDAYNAMEDES_DECRYPTDES_ENCRYPTENCRYPTF ROM_DAYSFROM_UNIXTIMEHEXINET_NTOALAST_DAYLOAD_FILE LOWERLTRIMMD5MONTHNAMENOWOLD_PASSWORDPASSWORDQUOTE REVERSERTRIMSEC_TO_TIMESHA1SOUNDEXSPACESYSDATETIME TIMESTAMPTRIMUNCOMPRESSUNHEXUPPERUSERUTC_DATEUTC_T IMEUTC_TIMESTAMPUUIDVERSIONYEAR30gebgutschrift double(10,2) unsignedABSACOSASCIIASINATANBIT_LENGTHBIT_COUNTCEI LINGCHAR_LENGTHCONNECTION_IDCOSCOTCRC32DAYOFMONTHD AYOFWEEKDAYOFYEARDEGREESEXPFLOORHOURINET_ATONLENGT HLNLOGLOG2LOG10MICROSECONDMINUTEMONTHOCTORDPIQUART ERRADIANSRANDROUNDSECONDSIGNSINSQRTTANTO_DAYSTIME_ TO_SECUNCOMPRESSED_LENGTHUNIX_TIMESTAMPUUID_SHORTW EEKWEEKDAYWEEKOFYEARYEARWEEK--------BINCHARCOMPRESSCURRENT_DATECURRENT_TIMECURRENT_USE RDATABASEDATEDAYNAMEDES_DECRYPTDES_ENCRYPTENCRYPTF ROM_DAYSFROM_UNIXTIMEHEXINET_NTOALAST_DAYLOAD_FILE LOWERLTRIMMD5MONTHNAMENOWOLD_PASSWORDPASSWORDQUOTE REVERSERTRIMSEC_TO_TIMESHA1SOUNDEXSPACESYSDATETIME TIMESTAMPTRIMUNCOMPRESSUNHEXUPPERUSERUTC_DATEUTC_T IMEUTC_TIMESTAMPUUIDVERSIONYEAR500000.00gebaktiv smallint(11) unsignedABSACOSASCIIASINATANBIT_LENGTHBIT_COUNTCEI LINGCHAR_LENGTHCONNECTION_IDCOSCOTCRC32DAYOFMONTHD AYOFWEEKDAYOFYEARDEGREESEXPFLOORHOURINET_ATONLENGT HLNLOGLOG2LOG10MICROSECONDMINUTEMONTHOCTORDPIQUART ERRADIANSRANDROUNDSECONDSIGNSINSQRTTANTO_DAYSTIME_ TO_SECUNCOMPRESSED_LENGTHUNIX_TIMESTAMPUUID_SHORTW EEKWEEKDAYWEEKOFYEARYEARWEEK--------BINCHARCOMPRESSCURRENT_DATECURRENT_TIMECURRENT_USE RDATABASEDATEDAYNAMEDES_DECRYPTDES_ENCRYPTENCRYPTF ROM_DAYSFROM_UNIXTIMEHEXINET_NTOALAST_DAYLOAD_FILE LOWERLTRIMMD5MONTHNAMENOWOLD_PASSWORDPASSWORDQUOTE REVERSERTRIMSEC_TO_TIMESHA1SOUNDEXSPACESYSDATETIME TIMESTAMPTRIMUNCOMPRESSUNHEXUPPERUSERUTC_DATEUTC_T IMEUTC_TIMESTAMPUUIDVERSIONYEAR10gebtage smallint(11) unsignedABSACOSASCIIASINATANBIT_LENGTHBIT_COUNTCEI LINGCHAR_LENGTHCONNECTION_IDCOSCOTCRC32DAYOFMONTHD AYOFWEEKDAYOFYEARDEGREESEXPFLOORHOURINET_ATONLENGT HLNLOGLOG2LOG10MICROSECONDMINUTEMONTHOCTORDPIQUART ERRADIANSRANDROUNDSECONDSIGNSINSQRTTANTO_DAYSTIME_ TO_SECUNCOMPRESSED_LENGTHUNIX_TIMESTAMPUUID_SHORTW EEKWEEKDAYWEEKOFYEARYEARWEEK--------BINCHARCOMPRESSCURRENT_DATECURRENT_TIMECURRENT_USE RDATABASEDATEDAYNAMEDES_DECRYPTDES_ENCRYPTENCRYPTF ROM_DAYSFROM_UNIXTIMEHEXINET_NTOALAST_DAYLOAD_FILE LOWERLTRIMMD5MONTHNAMENOWOLD_PASSWORDPASSWORDQUOTE REVERSERTRIMSEC_TO_TIMESHA1SOUNDEXSPACESYSDATETIME TIMESTAMPTRIMUNCOMPRESSUNHEXUPPERUSERUTC_DATEUTC_T IMEUTC_TIMESTAMPUUIDVERSIONYEAR30gebgutschrift double(10,2) unsignedABSACOSASCIIASINATANBIT_LENGTHBIT_COUNTCEI LINGCHAR_LENGTHCONNECTION_IDCOSCOTCRC32DAYOFMONTHD AYOFWEEKDAYOFYEARDEGREESEXPFLOORHOURINET_ATONLENGT HLNLOGLOG2LOG10MICROSECONDMINUTEMONTHOCTORDPIQUART ERRADIANSRANDROUNDSECONDSIGNSINSQRTTANTO_DAYSTIME_ TO_SECUNCOMPRESSED_LENGTHUNIX_TIMESTAMPUUID_SHORTW EEKWEEKDAYWEEKOFYEARYEARWEEK--------BINCHARCOMPRESSCURRENT_DATECURRENT_TIMECURRENT_USE RDATABASEDATEDAYNAMEDES_DECRYPTDES_ENCRYPTENCRYPTF ROM_DAYSFROM_UNIXTIMEHEXINET_NTOALAST_DAYLOAD_FILE LOWERLTRIMMD5MONTHNAMENOWOLD_PASSWORDPASSWORDQUOTE REVERSERTRIMSEC_TO_TIMESHA1SOUNDEXSPACESYSDATETIME TIMESTAMPTRIMUNCOMPRESSUNHEXUPPERUSERUTC_DATEUTC_T IMEUTC_TIMESTAMPUUIDVERSIONYEAR500000.00gebaktiv smallint(11) unsignedABSACOSASCIIASINATANBIT_LENGTHBIT_COUNTCEI LINGCHAR_LENGTHCONNECTION_IDCOSCOTCRC32DAYOFMONTHD AYOFWEEKDAYOFYEARDEGREESEXPFLOORHOURINET_ATONLENGT HLNLOGLOG2LOG10MICROSECONDMINUTEMONTHOCTORDPIQUART ERRADIANSRANDROUNDSECONDSIGNSINSQRTTANTO_DAYSTIME_ TO_SECUNCOMPRESSED_LENGTHUNIX_TIMESTAMPUUID_SHORTW EEKWEEKDAYWEEKOFYEARYEARWEEK--------BINCHARCOMPRESSCURRENT_DATECURRENT_TIMECURRENT_USE RDATABASEDATEDAYNAMEDES_DECRYPTDES_ENCRYPTENCRYPTF ROM_DAYSFROM_UNIXTIMEHEXINET_NTOALAST_DAYLOAD_FILE LOWERLTRIMMD5MONTHNAMENOWOLD_PASSWORDPASSWORDQUOTE REVERSERTRIMSEC_TO_TIMESHA1SOUNDEXSPACESYSDATETIME TIMESTAMPTRIMUNCOMPRESSUNHEXUPPERUSERUTC_DATEUTC_T IMEUTC_TIMESTAMPUUIDVERSIONYEAR10gebtage smallint(11) unsigned 30
gebgutschrift double(10,2)unsigned 500000
gebaktiv smallint(11) unsigned 10

da sind neben den jeweiligen zeilen noch collatiosnfelder wo ASCI II usw eingetragen werden kann. meine Datenbank läuft auf php 5.3
Wenn das Script unter pho5.2 lief vermute ich momentan da den Fehler evtl.