[TYPO3-project-seminars] Problem with registration in the backend

Kerstin Finke kerstinfinke at hotmail.com
Tue Jul 21 14:30:19 CEST 2009


I found the cause of the problem. Since static_info_tables 2.0.8 the 
table static_taxes is in a separate extension.

With an older version of static_info_tables the backend-registration works.

Regards
Kerstin

Kerstin Finke schrieb:
> Hi,
> I installed and configured the extension and it works fine. There is 
> only one problem:
> When I want to register a user for a seminar in the backend I get the 
> following error. In the frontend the registration works.
> In the database there is no table static_taxes.
> 
> Where could this table come from? Is it from an older version of 
> "static_info_tables"?
> 
> I tried to update the seminars extension to 0.8 but it did not help, so 
> reactivated my old version.
> seminars 0.7.3
> felogin 1.0.0
> sr_feuserregister 2.5.21
> static_info_tables 2.1.0
> oelib 0.6.1
> ameos formidable 1.1.0
> 
> Regards
> Kerstin
> 
> Here the error message:
> 
> 
> 
> 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 'FROM static_taxes, pages
> WHERE
> pages.uid=static_taxes.pid
> AND pag' at line 2
> 
> lastBuiltQuery SELECT static_taxes.uid,static_taxes.
> FROM static_taxes, pages
> WHERE
> pages.uid=static_taxes.pid
> AND pages.deleted=0 AND 1=1
> 
> debug_backtrace SC_alt_doc->main#1483 // SC_alt_doc->makeEditForm#538 // 
> t3lib_TCEforms->getMainFields#760 // t3lib_TCEforms->getSingleField#569 
> // t3lib_TCEforms->getSingleField_SW#899 // 
> t3lib_TCEforms->getSingleField_typeSelect#991 // 
> t3lib_TCEforms->addSelectOptionsToItemArray#1420 // 
> t3lib_TCEforms->foreignTable#4186 // 
> t3lib_BEfunc::exec_foreign_table_where_query#4432 // 
> t3lib_DB->exec_SELECT_queryArray#3041 // t3lib_DB->exec_SELECTquery#298 
> // t3lib_DB->debug#234
> 
> 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 'FROM 
> static_taxes, pages WHERE pages.uid=static_taxes.pid AND pag' at line 2 
> This may indicate a table defined in tables.php is not existing in the 
> database!


More information about the TYPO3-project-seminars mailing list