Franz Holzinger

Verse of the day

Rühme dich nicht des morgenden Tages; denn du weißt nicht, was heute sich begeben mag.
Sprueche 27:1

© Bible Gateway's Verse of the Day


Entwickler Version

Bitte testen Sie es immer vor dem Stellen einer Frage auch mit der aktuellen Entwicklerversion

autor  
6-07-09 17:10:10 Nach Update auf 2.5.22 entstehen Fehlermeldungen
Christian E
Hallo,

Seit dem Update erscheinen eine menge Fehlermeldungen sobald man das Plugin in irgendeiner form auf der Seite einfügt.

Ich verwende die Typo3 Version 4.2.8 von einem Typo3 Hoster

Hier die Meldungen:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php on line 809

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php on line 836

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php on line 809

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php on line 836

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php on line 809

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php on line 836

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php on line 809

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php on line 836

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php on line 809

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php on line 836

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php on line 809

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php on line 836

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php on line 809

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php on line 836

Warning: Cannot modify header information - headers already sent by (output started at /usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php:809) in /usr/share/php/typo3_src-4.2.6/typo3/sysext/cms/tslib/class.tslib_fe.php on line 3226

Hat vielleicht jemand das selbe Problem?
Danke im voraus!
6-07-09 22:22:25 SQL Fehlermeldungen
Franz Holzinger
Das sind im Prinzip alles SQL Fehlermeldungen. Um die Ursache herauszufinden, muss das sqlDebug im Install Tool aktiviert werden. Welche SQL Anweisung ist fehlerhaft gewesen?

Ideal wäre eine debug Ausgabe an der Code Stelle
/usr/share/php/typo3_src-4.2.6/t3lib/class.t3lib_db.php Zeile 809

$tmp = t3lib_div::debug_trail();
debug ($tmp, 'calling path in className::methodName', __LINE__, __FILE__);

Und die devIPmask auf die eigene IP Adresse setzen.

Damit könnte ich herausfinden, von welcher Codestelle aus das aufgerufen worden ist.
6-07-09 22:41:44 SQL Debug
Christian E
caller t3lib_DB::exec_SELECTquery
ERROR Unknown column 'static_currencies.cu_name_de' in 'field list'
lastBuiltQuery SELECT static_currencies.cu_name_de,static_currencies.cu_name_en
FROM static_currencies
WHERE
static_currencies.cu_iso_3 = 'EUR'
debug_backtrace require#76 // tslib_fe->INTincScript#461 // tslib_fe->INTincScript_process#3015 // tslib_cObj->USER#3089 // tslib_cObj->callUserFunction#724 // call_user_func_array#5866 // tx_srfeuserregister_pi1->main# // tx_srfeuserregister_pi1_base->main#52 // tx_srfeuserregister_control_main->main#61 // tx_srfeuserregister_control_main->init#100 // tx_staticinfotables_pi1->init#143 // tx_staticinfotables_pi1->getStaticInfoName#117 // tx_staticinfotables_div->getTitleFromIsoCode#185 // t3lib_DB->exec_SELECTquery#311 // t3lib_DB->debug#234

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.8/t3lib/class.t3lib_db.php on line 809

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.8/t3lib/class.t3lib_db.php on line 836
caller t3lib_DB::exec_SELECTquery
ERROR Unknown column 'static_currencies.cu_name_de' in 'field list'
lastBuiltQuery SELECT static_currencies.cu_name_de,static_currencies.cu_name_en
FROM static_currencies
WHERE
static_currencies.cu_iso_3 = 'EUR'
debug_backtrace require#76 // tslib_fe->INTincScript#461 // tslib_fe->INTincScript_process#3015 // tslib_cObj->USER#3089 // tslib_cObj->callUserFunction#724 // call_user_func_array#5866 // tx_srfeuserregister_pi1->main# // tx_srfeuserregister_pi1_base->main#52 // tx_srfeuserregister_control_main->main#61 // tx_srfeuserregister_control_main->init#100 // tx_staticinfotables_pi1->init#143 // tx_staticinfotables_pi1->getStaticInfoName#117 // tx_staticinfotables_div->getTitleFromIsoCode#204 // t3lib_DB->exec_SELECTquery#311 // t3lib_DB->debug#234

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.8/t3lib/class.t3lib_db.php on line 809

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.8/t3lib/class.t3lib_db.php on line 836
caller t3lib_DB::exec_SELECTquery
ERROR Unknown column 'static_currencies.cu_name_de' in 'field list'
lastBuiltQuery SELECT static_currencies.cu_name_de,static_currencies.cu_name_en
FROM static_currencies
WHERE
static_currencies.cu_iso_3 = 'EUR'
debug_backtrace require#76 // tslib_fe->INTincScript#461 // tslib_fe->INTincScript_process#3015 // tslib_cObj->USER#3089 // tslib_cObj->callUserFunction#724 // call_user_func_array#5866 // tx_srfeuserregister_pi1->main# // tx_srfeuserregister_pi1_base->main#52 // tx_srfeuserregister_control_main->main#61 // tx_srfeuserregister_control_main->init#100 // tx_staticinfotables_pi1->init#143 // tx_staticinfotables_pi1->loadCurrencyInfo#120 // tx_staticinfotables_pi1->getStaticInfoName#553 // tx_staticinfotables_div->getTitleFromIsoCode#185 // t3lib_DB->exec_SELECTquery#311 // t3lib_DB->debug#234

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.8/t3lib/class.t3lib_db.php on line 809

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.8/t3lib/class.t3lib_db.php on line 836
caller t3lib_DB::exec_SELECTquery
ERROR Unknown column 'static_currencies.cu_name_de' in 'field list'
lastBuiltQuery SELECT static_currencies.cu_name_de,static_currencies.cu_name_en
FROM static_currencies
WHERE
static_currencies.cu_iso_3 = 'EUR'
debug_backtrace require#76 // tslib_fe->INTincScript#461 // tslib_fe->INTincScript_process#3015 // tslib_cObj->USER#3089 // tslib_cObj->callUserFunction#724 // call_user_func_array#5866 // tx_srfeuserregister_pi1->main# // tx_srfeuserregister_pi1_base->main#52 // tx_srfeuserregister_control_main->main#61 // tx_srfeuserregister_control_main->init#100 // tx_staticinfotables_pi1->init#143 // tx_staticinfotables_pi1->loadCurrencyInfo#120 // tx_staticinfotables_pi1->getStaticInfoName#553 // tx_staticinfotables_div->getTitleFromIsoCode#204 // t3lib_DB->exec_SELECTquery#311 // t3lib_DB->debug#234

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.8/t3lib/class.t3lib_db.php on line 809

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.8/t3lib/class.t3lib_db.php on line 836
caller t3lib_DB::exec_SELECTquery
ERROR Unknown column 'static_countries.cn_short_de' in 'field list'
lastBuiltQuery SELECT static_countries.cn_iso_3,static_countries.cn_short_de,static_countries.cn_short_en
FROM static_countries
WHERE
1=1 AND static_countries.deleted=0
debug_backtrace require#76 // tslib_fe->INTincScript#461 // tslib_fe->INTincScript_process#3015 // tslib_cObj->USER#3089 // tslib_cObj->callUserFunction#724 // call_user_func_array#5866 // tx_srfeuserregister_pi1->main# // tx_srfeuserregister_pi1_base->main#52 // tx_srfeuserregister_control_main->main#61 // tx_srfeuserregister_control->doProcessing#103 // tx_srfeuserregister_display->createScreen#570 // tx_srfeuserregister_marker->addStaticInfoMarkers#166 // tx_staticinfotables_pi1->buildStaticInfoSelector#489 // tx_staticinfotables_pi1->initCountries#268 // t3lib_DB->exec_SELECTquery#350 // t3lib_DB->debug#234

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.8/t3lib/class.t3lib_db.php on line 809

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.8/t3lib/class.t3lib_db.php on line 836
caller t3lib_DB::exec_SELECTquery
ERROR Unknown column 'static_country_zones.zn_name_de' in 'field list'
lastBuiltQuery SELECT static_country_zones.zn_code,static_country_zones.zn_name_de,static_country_zones.zn_name_local
FROM static_country_zones
WHERE
zn_country_iso_3='DEU'
debug_backtrace require#76 // tslib_fe->INTincScript#461 // tslib_fe->INTincScript_process#3015 // tslib_cObj->USER#3089 // tslib_cObj->callUserFunction#724 // call_user_func_array#5866 // tx_srfeuserregister_pi1->main# // tx_srfeuserregister_pi1_base->main#52 // tx_srfeuserregister_control_main->main#61 // tx_srfeuserregister_control->doProcessing#103 // tx_srfeuserregister_display->createScreen#570 // tx_srfeuserregister_marker->addStaticInfoMarkers#166 // tx_staticinfotables_pi1->buildStaticInfoSelector#500 // tx_staticinfotables_pi1->initCountrySubdivisions#273 // t3lib_DB->exec_SELECTquery#400 // t3lib_DB->debug#234

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.8/t3lib/class.t3lib_db.php on line 809

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.8/t3lib/class.t3lib_db.php on line 836
caller t3lib_DB::exec_SELECTquery
ERROR Unknown column 'static_languages.lg_name_de' in 'field list'
lastBuiltQuery SELECT static_languages.lg_iso_2,static_languages.lg_country_iso_2,static_languages.lg_name_de,static_languages.lg_name_en
FROM static_languages
WHERE
1=1 AND lg_sacred = 0 AND lg_constructed = 0
debug_backtrace require#76 // tslib_fe->INTincScript#461 // tslib_fe->INTincScript_process#3015 // tslib_cObj->USER#3089 // tslib_cObj->callUserFunction#724 // call_user_func_array#5866 // tx_srfeuserregister_pi1->main# // tx_srfeuserregister_pi1_base->main#52 // tx_srfeuserregister_control_main->main#61 // tx_srfeuserregister_control->doProcessing#103 // tx_srfeuserregister_display->createScreen#570 // tx_srfeuserregister_marker->addStaticInfoMarkers#166 // tx_staticinfotables_pi1->buildStaticInfoSelector#515 // tx_staticinfotables_pi1->initLanguages#283 // t3lib_DB->exec_SELECTquery#480 // t3lib_DB->debug#234

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.8/t3lib/class.t3lib_db.php on line 809

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/php/typo3_src-4.2.8/t3lib/class.t3lib_db.php on line 836

Warning: Cannot modify header information - headers already sent by (output started at /usr/share/php/typo3_src-4.2.8/t3lib/class.t3lib_db.php:1148) in /usr/share/php/typo3_src-4.2.8/typo3/sysext/cms/tslib/class.tslib_fe.php on line 3229

das ist jetzt die ausgabe
an die andere datei kann ich leider nicht dran, da ich ja bei einem typo3 hoster binn

hier nochmal der link http://de.wurzeltreff.roboticbrain.de/login/
8-07-09 09:10:45 static_info_tables
Franz Holzinger
Dieser Fehler ensteht in static_info_tables. Ist dort die neueste Version 2.1.1 installiert?

8-07-09 13:16:22 static_info_tables aktuell
Christian E
ja

static_info_tables 2.1.1
static_info_tables_de 2.0.2
11-07-09 13:25:18 static_info_tables_de
Christian E
ich hab etwas herumexperimentiert und folgendes festgestellt:

wenn man static_info_tables_de deinstalliert sind die Fehler weg

woran liegt das?
11-07-09 13:37:34 seltsame Ereignisse
Christian E
ich habe static_info_tables_de nochmal installiert und jetzt funktioniert es?
28-07-09 14:00:18 Extension Manager
Franz Holzinger
Hier sind bei der ersten Installation von static_info_tables_de die deutschen Felder "..._de" nicht in den Datenbanktabellen angelegt worden.
< Zurück zum Forum