QUERY FAILED: SELECT s.*, COUNT(s.uid) FROM tx_twmeinlcymbals_series AS s,tx_twmeinlcymbals_artist_series_mm AS smm WHERE s.uid = smm.uid_foreign AND smm.uid_local = GROUP BY s.uid HAVING COUNT(s.uid)>=1 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 'GROUP BY s.uid HAVING COUNT(s.uid)>=1' at line 1 #0 tx_twbetools_db::getRecordArray(Array ([0] => tx_twmeinlcymbals_series,[1] => s), WHERE s.uid = smm.uid_foreign AND smm.uid_local = , , , Array ([smm] => tx_twmeinlcymbals_artist_series_mm)) called at [/www/htdocs/typo3conf/ext/tw_meinlcymbals/pi/class.tx_twmeinlcymbals_artists.php:387] #1 tx_twmeinlcymbals_artists->_buildArtistProfile() called at [/www/htdocs/typo3conf/ext/tw_meinlcymbals/pi/class.tx_twmeinlcymbals_artists.php:104] #2 tx_twmeinlcymbals_artists->main(, Array ([userFunc] => tx_twmeinlcymbals_artists->main,[listCount] => 35;)) #3 call_user_func_array(Array ([0] => tx_twmeinlcymbals_artists Object ([prefixId] => tx_twmeinlcymbals_artists,[scriptRelPath] => pi/class.tx_twmeinlcymbals_artists.php,[extKey] => tw_meinlcymbals,[pi_checkCHash] => 1,[] => EXT:tw_meinlcymbals/res/tx_twmeinlcymbals_artist.htm,[] => tx_twexttmplparser_pi Object ([prefixId] => tx_twexttmplparser_pi,[scriptRelPath] => pi/class.tx_twexttmplparser_pi.php,[extKey] => tw_exttmplparser,[pi_checkCHash] => 1,[register] => Array (),[template] => /*--------------------------------------------------------------------------*/ /*START PAGE*/ /*--------------------------------------------------------------------------*/
###URL###
###TAG_CLOUD###
###URL###
Showing artist ###LIMIT_FROM### - ###LIMIT_TO### from ###COUNT### artists
###PAGEBROWSER###
| Sort by: class="ordered">Artist | class="ordered">Country | class="ordered">Band | class="ordered">Videos | |
|---|---|---|---|---|
| ###IMAGES### | ###SURNAME###, ###NAME### | ###COUNTRY_NAME### | ###BAND### | ###VIDEOS### --- |
Showing artist ###LIMIT_FROM### - ###LIMIT_TO### from ###COUNT### artists
###PAGEBROWSER###
###IMGPROC_IMAGES|###
###TITLE###
###URL###
###TAG_CLOUD###
###URL###
Showing artist ###LIMIT_FROM### - ###LIMIT_TO### from ###COUNT### artists
###PAGEBROWSER###
| Sort by: class="ordered">Artist | class="ordered">Country | class="ordered">Band | class="ordered">Videos | |
|---|---|---|---|---|
| ###IMAGES### | ###SURNAME###, ###NAME### | ###COUNTRY_NAME### | ###BAND### | ###VIDEOS### --- |
Showing artist ###LIMIT_FROM### - ###LIMIT_TO### from ###COUNT### artists
###PAGEBROWSER###
###IMGPROC_IMAGES|###
###TITLE###
{LLL:EXT:css_styled_content/pi1/locallang.xml:label.toTop}
,[innerWrap2.] => Array ([insertData] => 1,[fieldRequired] => linkToTop),[dataWrap] => |,[prepend] => TEXT,[prepend.] => Array ([dataWrap] => ,[if.] => Array ([isTrue.] => Array ([field] => _LOCALIZED_UID))),[editPanel] => 1,[editPanel.] => Array ([allow] => move,new,edit,hide,delete,[line] => 5,[label] => %s,[onlyCurrentPid] => 1,[previewBorder] => 4,[edit.] => Array ([displayRecord] => 1)),[prefixComment] => 1 | CONTENT ELEMENT, uid:{field:uid}/{field:CType}),[header] => COA,[header.] => Array ([10] => < lib.stdheader,[20] => TEXT,[20.] => Array ([field] => subheader,[required] => 1,[dataWrap] =>|
,[htmlSpecialChars] => 1,[editIcons] => tt_content:subheader,layout,[editIcons.] => Array ([beforeLastTag] => 1,[iconTitle.] => Array ([data] => LLL:EXT:css_styled_content/pi1/locallang.xml:eIcon.subheader)),[prefixComment] => 2 | Subheader:)),[text] => COA,[text.] => Array ([10] => < lib.stdheader,[20] => TEXT,[20.] => Array ([field] => bodytext,[required] => 1,[parseFunc] => < lib.parseFunc_RTE,[editIcons] => tt_content:bodytext, rte_enabled,[editIcons.] => Array ([beforeLastTag] => 1,[iconTitle.] => Array ([data] => LLL:EXT:css_styled_content/pi1/locallang.xml:eIcon.bodytext)),[prefixComment] => 2 | Text:,[parseFunc.] => Array ([tags.] => Array ([flash] => < plugin.tx_gbsifr_pi1)))),[image] => COA,[image.] => Array ([10] => < lib.stdheader,[20] => USER,[20.] => Array ([imgList.] => Array ([field] => image),[textPos.] => Array ([field] => imageorient),[imgPath] => uploads/pics/,[imgObjNum] => 1,[1.] => Array ([file.] => Array ([import.] => Array ([current] => 1),[width.] => Array ([field] => imagewidth)),[imageLinkWrap] => 1,[imageLinkWrap.] => Array ([bodyTag] => ,[wrap] => | ,[width] => 800m,[height] => 600m,[effects] => ,[JSwindow] => 1,[JSwindow.] => Array ([newWindow] => 0,[expand] => ),[enable.] => Array ([field] => image_zoom,[ifEmpty.] => Array ([typolink.] => Array ([parameter.] => Array ([field] => image_link,[listNum.] => Array ([stdWrap.] => Array ([data] => register : IMAGE_NUM_CURRENT))),[returnLast] => url))),[typolink.] => Array ([parameter.] => Array ([field] => image_link,[listNum.] => Array ([stdWrap.] => Array ([data] => register : IMAGE_NUM_CURRENT,[if.] => Array ([isTrue.] => Array ([field] => image_link)))),[override.] => Array ([cObject] => IMG_RESOURCE,[cObject.] => Array ([file.] => Array ([import.] => Array ([data] => TSFE:lastImageInfo|origFile),[maxW] => 900,[maxH] => 600)),[if.] => Array ([isTrue.] => Array ([field] => image_zoom),[isFalse.] => Array ([field] => image_link)))),[target] => ,[extTarget] => _blank,[userFunc] => tx_perfectlightbox->useGlobal)),[altText] => TEXT,[altText.] => Array ([field] => altText,[stripHtml] => 1,[split.] => Array ([token.] => Array ([char] => 10,[if.] => Array ([isTrue] => 1)),[returnKey.] => Array ([data] => register : IMAGE_NUM_CURRENT))),[titleText] => TEXT,[titleText.] => Array ([field] => titleText,[stripHtml] => 1,[split.] => Array ([token.] => Array ([char] => 10,[if.] => Array ([isTrue] => 1)),[returnKey.] => Array ([data] => register : IMAGE_NUM_CURRENT)),[override.] => Array ([field] => imagecaption,[htmlSpecialChars] => 1,[if.] => Array ([isTrue.] => Array ([field] => image_zoom)))),[longdescURL] => TEXT,[longdescURL.] => Array ([field] => longdescURL,[stripHtml] => 1,[split.] => Array ([token.] => Array ([char] => 10,[if.] => Array ([isTrue] => 1)),[returnKey.] => Array ([data] => register : IMAGE_NUM_CURRENT))),[emptyTitleHandling] => removeAttr,[titleInLink] => 1,[titleInLinkAndImg] => 0),[maxW] => 1000,[maxW.] => Array ([override.] => Array ([data] => register:maxImageWidth)),[maxWInText] => ,[maxWInText.] => Array ([override.] => Array ([data] => register:maxImageWidthInText)),[equalH.] => Array ([field] => imageheight),[spaceBelowAbove] => 6,[image_compression.] => Array ([field] => image_compression),[image_effects.] => Array ([field] => image_effects),[noRows.] => Array ([field] => image_noRows),[cols.] => Array ([field] => imagecols),[border.] => Array ([field] => imageborder),[caption.] => Array ([1] => TEXT,[1.] => Array ([field] => imagecaption,[required] => 1,[parseFunc] => < lib.parseFunc,[br] => 1,[split.] => Array ([token.] => Array ([char] => 10,[if.] => Array ([isPositive] => 1 + 0)),[returnKey.] => Array ([data] => register : IMAGE_NUM_CURRENT))),[editIcons] => tt_content : imagecaption[imagecaption_position],[editIcons.] => Array ([beforeLastTag] => 1,[iconTitle.] => Array ([data] => LLL:EXT:css_styled_content/pi1/locallang.xml:eIcon.caption))),[captionSplit] => 0,[imageTextSplit] => 1,[borderCol] => black,[borderThick] => 2,[colSpace] => 10,[rowSpace] => 5,[textMargin] => 10,[editIcons] => tt_content : image [imageorient|imagewidth|imageheight], [imagecols|image_noRows|imageborder],[image_link|image_zoom],[image_compression|image_effects|image_frames],imagecaption[imagecaption_position],[editIcons.] => Array ([iconTitle.] => Array ([data] => LLL:EXT:css_styled_content/pi1/locallang.xml:eIcon.images)),[stdWrap.] => Array ([prefixComment] => 2 | Image block:),[userFunc] => tx_cssstyledcontent_pi1->render_textpic,[captionAlign.] => Array ([field] => imagecaption_position),[borderSpace] => 0,[separateRows] => {$styles.content.imgtext.separateRows},[addClasses] => ,[addClassesImage] => ,[addClassesImage.] => Array ([ifEmpty] => csc-textpic-firstcol csc-textpic-lastcol,[override] => csc-textpic-firstcol |*| |*| csc-textpic-lastcol,[override.] => Array ([if.] => Array ([isGreaterThan.] => Array ([field] => imagecols),[value] => 1))),[imageStdWrap.] => Array ([dataWrap] =>|
))),[layout] => COA,[layout.] => Array ([wrap] =>|
|
|
),[commentWrap.] => Array ([wrap] =>|
),[radioWrap.] => Array ([wrap] => ||
)),[COMMENT.] => Array ([layout] =>|
),[commentWrap.] => Array ([wrap] =>|
),[radioWrap.] => Array ([wrap] => ||
)),[COMMENT.] => Array ([layout] =>ERROR: Content Element type "|" has no rendering definition!
,[prefixComment] => 2 | Unknown element message:),[templavoila_pi1] => COA,[templavoila_pi1.] => Array ([20] => < plugin.tx_templavoila_pi1),[page_php_content_pi1] => COA,[page_php_content_pi1.] => Array ([10] => < lib.stdheader,[20] => < plugin.tx_pagephpcontent_pi1))) called at [/www/typo3_src-4.2.3/typo3/sysext/cms/tslib/class.tslib_content.php:550] #14 tslib_cObj->cObjGetSingle(CASE, Array ([key.] => Array ([field] => CType),[stdWrap.] => Array ([spaceBefore.] => Array ([field] => spaceBefore),[spaceAfter.] => Array ([field] => spaceAfter),[space] => 0|0,[innerWrap.] => Array ([cObject] => CASE,[cObject.] => Array ([key.] => Array ([field] => section_frame),[1] => TEXT,[1.] => Array ([value] =>{LLL:EXT:css_styled_content/pi1/locallang.xml:label.toTop}
,[innerWrap2.] => Array ([insertData] => 1,[fieldRequired] => linkToTop),[dataWrap] => |,[prepend] => TEXT,[prepend.] => Array ([dataWrap] => ,[if.] => Array ([isTrue.] => Array ([field] => _LOCALIZED_UID))),[editPanel] => 1,[editPanel.] => Array ([allow] => move,new,edit,hide,delete,[line] => 5,[label] => %s,[onlyCurrentPid] => 1,[previewBorder] => 4,[edit.] => Array ([displayRecord] => 1)),[prefixComment] => 1 | CONTENT ELEMENT, uid:{field:uid}/{field:CType}),[header] => COA,[header.] => Array ([10] => < lib.stdheader,[20] => TEXT,[20.] => Array ([field] => subheader,[required] => 1,[dataWrap] =>|
,[htmlSpecialChars] => 1,[editIcons] => tt_content:subheader,layout,[editIcons.] => Array ([beforeLastTag] => 1,[iconTitle.] => Array ([data] => LLL:EXT:css_styled_content/pi1/locallang.xml:eIcon.subheader)),[prefixComment] => 2 | Subheader:)),[text] => COA,[text.] => Array ([10] => < lib.stdheader,[20] => TEXT,[20.] => Array ([field] => bodytext,[required] => 1,[parseFunc] => < lib.parseFunc_RTE,[editIcons] => tt_content:bodytext, rte_enabled,[editIcons.] => Array ([beforeLastTag] => 1,[iconTitle.] => Array ([data] => LLL:EXT:css_styled_content/pi1/locallang.xml:eIcon.bodytext)),[prefixComment] => 2 | Text:,[parseFunc.] => Array ([tags.] => Array ([flash] => < plugin.tx_gbsifr_pi1)))),[image] => COA,[image.] => Array ([10] => < lib.stdheader,[20] => USER,[20.] => Array ([imgList.] => Array ([field] => image),[textPos.] => Array ([field] => imageorient),[imgPath] => uploads/pics/,[imgObjNum] => 1,[1.] => Array ([file.] => Array ([import.] => Array ([current] => 1),[width.] => Array ([field] => imagewidth)),[imageLinkWrap] => 1,[imageLinkWrap.] => Array ([bodyTag] => ,[wrap] => | ,[width] => 800m,[height] => 600m,[effects] => ,[JSwindow] => 1,[JSwindow.] => Array ([newWindow] => 0,[expand] => ),[enable.] => Array ([field] => image_zoom,[ifEmpty.] => Array ([typolink.] => Array ([parameter.] => Array ([field] => image_link,[listNum.] => Array ([stdWrap.] => Array ([data] => register : IMAGE_NUM_CURRENT))),[returnLast] => url))),[typolink.] => Array ([parameter.] => Array ([field] => image_link,[listNum.] => Array ([stdWrap.] => Array ([data] => register : IMAGE_NUM_CURRENT,[if.] => Array ([isTrue.] => Array ([field] => image_link)))),[override.] => Array ([cObject] => IMG_RESOURCE,[cObject.] => Array ([file.] => Array ([import.] => Array ([data] => TSFE:lastImageInfo|origFile),[maxW] => 900,[maxH] => 600)),[if.] => Array ([isTrue.] => Array ([field] => image_zoom),[isFalse.] => Array ([field] => image_link)))),[target] => ,[extTarget] => _blank,[userFunc] => tx_perfectlightbox->useGlobal)),[altText] => TEXT,[altText.] => Array ([field] => altText,[stripHtml] => 1,[split.] => Array ([token.] => Array ([char] => 10,[if.] => Array ([isTrue] => 1)),[returnKey.] => Array ([data] => register : IMAGE_NUM_CURRENT))),[titleText] => TEXT,[titleText.] => Array ([field] => titleText,[stripHtml] => 1,[split.] => Array ([token.] => Array ([char] => 10,[if.] => Array ([isTrue] => 1)),[returnKey.] => Array ([data] => register : IMAGE_NUM_CURRENT)),[override.] => Array ([field] => imagecaption,[htmlSpecialChars] => 1,[if.] => Array ([isTrue.] => Array ([field] => image_zoom)))),[longdescURL] => TEXT,[longdescURL.] => Array ([field] => longdescURL,[stripHtml] => 1,[split.] => Array ([token.] => Array ([char] => 10,[if.] => Array ([isTrue] => 1)),[returnKey.] => Array ([data] => register : IMAGE_NUM_CURRENT))),[emptyTitleHandling] => removeAttr,[titleInLink] => 1,[titleInLinkAndImg] => 0),[maxW] => 1000,[maxW.] => Array ([override.] => Array ([data] => register:maxImageWidth)),[maxWInText] => ,[maxWInText.] => Array ([override.] => Array ([data] => register:maxImageWidthInText)),[equalH.] => Array ([field] => imageheight),[spaceBelowAbove] => 6,[image_compression.] => Array ([field] => image_compression),[image_effects.] => Array ([field] => image_effects),[noRows.] => Array ([field] => image_noRows),[cols.] => Array ([field] => imagecols),[border.] => Array ([field] => imageborder),[caption.] => Array ([1] => TEXT,[1.] => Array ([field] => imagecaption,[required] => 1,[parseFunc] => < lib.parseFunc,[br] => 1,[split.] => Array ([token.] => Array ([char] => 10,[if.] => Array ([isPositive] => 1 + 0)),[returnKey.] => Array ([data] => register : IMAGE_NUM_CURRENT))),[editIcons] => tt_content : imagecaption[imagecaption_position],[editIcons.] => Array ([beforeLastTag] => 1,[iconTitle.] => Array ([data] => LLL:EXT:css_styled_content/pi1/locallang.xml:eIcon.caption))),[captionSplit] => 0,[imageTextSplit] => 1,[borderCol] => black,[borderThick] => 2,[colSpace] => 10,[rowSpace] => 5,[textMargin] => 10,[editIcons] => tt_content : image [imageorient|imagewidth|imageheight], [imagecols|image_noRows|imageborder],[image_link|image_zoom],[image_compression|image_effects|image_frames],imagecaption[imagecaption_position],[editIcons.] => Array ([iconTitle.] => Array ([data] => LLL:EXT:css_styled_content/pi1/locallang.xml:eIcon.images)),[stdWrap.] => Array ([prefixComment] => 2 | Image block:),[userFunc] => tx_cssstyledcontent_pi1->render_textpic,[captionAlign.] => Array ([field] => imagecaption_position),[borderSpace] => 0,[separateRows] => {$styles.content.imgtext.separateRows},[addClasses] => ,[addClassesImage] => ,[addClassesImage.] => Array ([ifEmpty] => csc-textpic-firstcol csc-textpic-lastcol,[override] => csc-textpic-firstcol |*| |*| csc-textpic-lastcol,[override.] => Array ([if.] => Array ([isGreaterThan.] => Array ([field] => imagecols),[value] => 1))),[imageStdWrap.] => Array ([dataWrap] =>|
))),[layout] => COA,[layout.] => Array ([wrap] =>|
|
|
),[commentWrap.] => Array ([wrap] =>|
),[radioWrap.] => Array ([wrap] => ||
)),[COMMENT.] => Array ([layout] =>|
),[commentWrap.] => Array ([wrap] =>|
),[radioWrap.] => Array ([wrap] => ||
)),[COMMENT.] => Array ([layout] =>ERROR: Content Element type "|" has no rendering definition!
,[prefixComment] => 2 | Unknown element message:),[templavoila_pi1] => COA,[templavoila_pi1.] => Array ([20] => < plugin.tx_templavoila_pi1),[page_php_content_pi1] => COA,[page_php_content_pi1.] => Array ([10] => < lib.stdheader,[20] => < plugin.tx_pagephpcontent_pi1)), tt_content) called at [/www/typo3_src-4.2.3/typo3/sysext/cms/tslib/class.tslib_content.php:483] #15 tslib_cObj->cObjGetSingle(,,,,[datetime_stdWrap.] => Array ([strftime] => %A, %d-%m-%y %H:%M),[date_stdWrap.] => Array ([strftime] => %d.%m.%y),[time_stdWrap.] => Array ([strftime] => %H:%M),[emoticons.] => Array ([active] => 0,[10] => IMAGE,[10.] => Array ([file] => EXT:ve_guestbook/pi1/emoticons/###EMOTICON###.gif,[params] => hspace="1" vspace="1",[border] => 0,[altText] => Emoticon,[titleText] => Emoticon),[subst.] => Array ([11.] => Array ([str] => :D,[val] => 1),[12.] => Array ([str] => :) || :-),[val] => 2),[13.] => Array ([str] => :( || :-(,[val] => 3),[14.] => Array ([str] => :cry:,[val] => 4),[15.] => Array ([str] => :?:,[val] => 5),[16.] => Array ([str] => ;) || ;-),[val] => 6))),[pageBrowser.] => Array ([maxPages] => 10,[tableParams] => cellpadding="5" cellspacing="0" border="0",[showResultCount] => 1,[activepage_stdWrap.] => Array ([wrap] => |),[page_stdWrap.] => Array ([wrap] => |),[pagelink_stdWrap.] => Array ([wrap] => |),[previous_stdWrap.] => Array ([wrap] => |),[next_stdWrap.] => Array ([wrap] => |)),[spamQuestion] => What's the total of 1 + 2?,[spamResult] => 3,[spamAnswer] => The total of 1 + 2 is 3!),[tx_timtab_pi1] => USER,[tx_timtab_pi1.] => Array ([userFunc] => tx_timtab_pi1->main,[header_stdWrap.] => Array ([wrap] => ),[dontWrapInDiv] => 0,[pid_list] => 0,[listClass] => ),[tx_timtab_pi2] => USER_INT,[tx_timtab_pi2.] => Array ([includeLibs] => typo3conf/ext/timtab/pi2/class.tx_timtab_pi2.php,[userFunc] => tx_timtab_pi2->main,[pidStorePosts] => 11,[pidStoreComments] => 10,[connectionTimeout] => 30,[bloggerTitle] => Blog post,[enableBlogger] => 1,[enableMetaWeblog] => 1,[strictAPI] => 0,[trackback.] => Array ([validate] => 1,[spam.] => Array ([mark] => 1))),[tx_timtab_pi3] => USER,[tx_timtab_pi3.] => Array ([userFunc] => tx_timtab_pi3->main,[header_stdWrap.] => Array ([wrap] => ),[dontWrapInDiv] => 0,[pid_list] => 0,[targetPid] => 0,[week_begins] => 1,[gmt_offset] => 0,[weekdayNameLength] => 1),[tx_timtabsociable_pi1] => USER,[tx_timtabsociable_pi1.] => Array ([userFunc] => tx_timtabsociable_pi1->main,[tagline.] => Array ([wrap] => |),[outerWrap] => ,