[TYPO3-project-seminars] OneTimeAccount - Seminars - Ameos_Formidable

[Mark Kuiphuis]

Hi all,

After upgrading the Seminars extension from 0.6.2 to 0.7.3 I receive the 
following error on the page where the onetimeaccount plugin is placed:

-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
caller	t3lib_DB::exec_SELECTquery

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 'AND static_countries.deleted=0' at line 4

lastBuiltQuery	SELECT 
static_countries.cn_short_local,static_countries.cn_short_en
FROM static_countries
WHERE
AND static_countries.deleted=0

debug_backtrace	require#76 // tslib_fe->INTincScript#461 // 
tslib_fe->INTincScript_process#3012 // tslib_cObj->USER#3086 // 
tslib_cObj->callUserFunction#724 // call_user_func_array#5866 // 
tx_onetimeaccount_pi1->main# // 
tx_onetimeaccount_pi1->initializeForm#125 // 
tx_ameosformidable->initFromTs#143 // tx_ameosformidable->init#1482 // 
tx_ameosformidable->_initDataHandler#500 // 
formidable_maindatahandler->refreshAllData#1969 // 
formidable_maindatahandler->refreshFormData#417 // 
formidable_maindatahandler->_getFormData#407 // 
formidable_maindatahandler->_getThisFormData#237 // 
tx_rdtlistbox->_getValue#258 // formidable_mainrenderlet->_getValue#323 
// formidable_maindatahandler->getRdtValue#275 // 
formidable_maindatahandler->getRdtValue_noSubmit_noEdit#663 // 
tx_rdtlistbox->__getDefaultValue#726 // 
formidable_mainrenderlet->__getDefaultValue#180 // 
formidable_mainrenderlet->_callUserObj#207 // 
tx_ameosformidable->_callUserObj#751 // 
tx_onetimeaccount_pi1->getDefaultCountry#5116 // 
tx_staticinfotables_div->getTitleFromIsoCode#313 // 
t3lib_DB->exec_SELECTquery#311 // t3lib_DB->debug#234
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

I've upgraded the extension according to what is written down in the 
manual. If I ignore this error and continue registering it works fine, 
but this error shouldn't be there I guess :)

The WHERE clause is empty followed by an AND ..... and this is where it 
goes wrong, but I cannot find the real issue what is causing this error. 
We don't need the country field to be displayed at all when people want 
to register for a seminar.

Anyone has a clue where I should look?

Kind regards,

Mark Kuiphuis

P.S. Sorry if it is in the wrong newsgroup. I didn't see a newsgroup 
specifically for onetimeaccount