[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