popekpl
09-03-2016, 13:28
Witam wszystkich, mam szereg problemów po przeniesieniu strony na darmowy serwer CBA.
Proszę o pomoc w ich rozwiązaniu :)
Dodam że był to serwis muzyczny i staram się go zmodyfikować do serwisu Konno-Społecznościowo-Jeżdzieckiego.
(1)Pierwszy z nich (backend):
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name,COUNT(asso2.id)>1 as association FROM uj6su_content AS a LEFT JOIN `uj6su_languages` AS l ON l.lang_code = a.language LEFT JOIN uj6su_users AS uc ON uc.id=a.checked_out LEFT JOIN uj6su_viewlevels AS ag ON ag.id = a.access LEFT JOIN uj6su_categories AS c ON c.id = a.catid LEFT JOIN uj6su_users AS ua ON ua.id = a.created_by LEFT JOIN uj6su_associations AS asso ON asso.id = a.id AND asso.context='com_content.item' LEFT JOIN uj6su_associations AS asso2 ON asso2.key = asso.key GROUP BY a.id ORDER BY a.hits DESC LIMIT 0, 5
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name,COUNT(asso2.id)>1 as association FROM uj6su_content AS a LEFT JOIN `uj6su_languages` AS l ON l.lang_code = a.language LEFT JOIN vj6su_users AS uc ON uc.id=a.checked_out LEFT JOIN uj6su_viewlevels AS ag ON ag.id = a.access LEFT JOIN uj6su_categories AS c ON c.id = a.catid LEFT JOIN uj6su_users AS ua ON ua.id = a.created_by LEFT JOIN uj6su_associations AS asso ON asso.id = a.id AND asso.context='com_content.item' LEFT JOIN uj6su_associations AS asso2 ON asso2.key = asso.key GROUP BY a.id ORDER BY created DESC LIMIT 0, 5
(2) Następny (backend):
POPULAR ARTICLES
Warning: Invalid argument supplied for foreach() in/virtual/koninio.cba.pl/administrator/modules/mod_popular/tmpl/default.php on line 16
RECENTLY ADDED ARTICLES
Warning: Invalid argument supplied for foreach() in/virtual/koninio.cba.pl/administrator/modules/mod_latest/tmpl/default.php on line 16
(3) Kolejny (pojawia się na stronie):
Warning: Parameter 3 to plgContentJw_allvideos::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentChronoforms() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/dispatcher.php on line 167
Warning: Parameter 3 to plgContentsysplgaup_raffle::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentsysplgaup_content::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentfshare::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentEmailcloak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentPagebreak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentJw_allvideos::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentChronoforms() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/dispatcher.php on line 167
Warning: Parameter 3 to plgContentsysplgaup_raffle::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentsysplgaup_content::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentfshare::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentEmailcloak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentPagebreak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentJw_allvideos::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentChronoforms() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/dispatcher.php on line 167
Warning: Parameter 3 to plgContentsysplgaup_raffle::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentsysplgaup_content::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentfshare::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentEmailcloak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentPagebreak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentJw_allvideos::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentChronoforms() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/dispatcher.php on line 167
Warning: Parameter 3 to plgContentsysplgaup_raffle::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentsysplgaup_content::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentfshare::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentEmailcloak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentPagebreak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Proszę o pomoc w ich rozwiązaniu :)
Dodam że był to serwis muzyczny i staram się go zmodyfikować do serwisu Konno-Społecznościowo-Jeżdzieckiego.
(1)Pierwszy z nich (backend):
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name,COUNT(asso2.id)>1 as association FROM uj6su_content AS a LEFT JOIN `uj6su_languages` AS l ON l.lang_code = a.language LEFT JOIN uj6su_users AS uc ON uc.id=a.checked_out LEFT JOIN uj6su_viewlevels AS ag ON ag.id = a.access LEFT JOIN uj6su_categories AS c ON c.id = a.catid LEFT JOIN uj6su_users AS ua ON ua.id = a.created_by LEFT JOIN uj6su_associations AS asso ON asso.id = a.id AND asso.context='com_content.item' LEFT JOIN uj6su_associations AS asso2 ON asso2.key = asso.key GROUP BY a.id ORDER BY a.hits DESC LIMIT 0, 5
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name,COUNT(asso2.id)>1 as association FROM uj6su_content AS a LEFT JOIN `uj6su_languages` AS l ON l.lang_code = a.language LEFT JOIN vj6su_users AS uc ON uc.id=a.checked_out LEFT JOIN uj6su_viewlevels AS ag ON ag.id = a.access LEFT JOIN uj6su_categories AS c ON c.id = a.catid LEFT JOIN uj6su_users AS ua ON ua.id = a.created_by LEFT JOIN uj6su_associations AS asso ON asso.id = a.id AND asso.context='com_content.item' LEFT JOIN uj6su_associations AS asso2 ON asso2.key = asso.key GROUP BY a.id ORDER BY created DESC LIMIT 0, 5
(2) Następny (backend):
POPULAR ARTICLES
Warning: Invalid argument supplied for foreach() in/virtual/koninio.cba.pl/administrator/modules/mod_popular/tmpl/default.php on line 16
RECENTLY ADDED ARTICLES
Warning: Invalid argument supplied for foreach() in/virtual/koninio.cba.pl/administrator/modules/mod_latest/tmpl/default.php on line 16
(3) Kolejny (pojawia się na stronie):
Warning: Parameter 3 to plgContentJw_allvideos::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentChronoforms() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/dispatcher.php on line 167
Warning: Parameter 3 to plgContentsysplgaup_raffle::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentsysplgaup_content::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentfshare::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentEmailcloak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentPagebreak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentJw_allvideos::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentChronoforms() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/dispatcher.php on line 167
Warning: Parameter 3 to plgContentsysplgaup_raffle::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentsysplgaup_content::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentfshare::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentEmailcloak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentPagebreak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentJw_allvideos::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentChronoforms() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/dispatcher.php on line 167
Warning: Parameter 3 to plgContentsysplgaup_raffle::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentsysplgaup_content::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentfshare::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentEmailcloak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentPagebreak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentJw_allvideos::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentChronoforms() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/dispatcher.php on line 167
Warning: Parameter 3 to plgContentsysplgaup_raffle::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentsysplgaup_content::onContentPrepare() expected to be a reference, value given in /virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to plgContentfshare::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentEmailcloak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71
Warning: Parameter 3 to PlgContentPagebreak::onContentPrepare() expected to be a reference, value given in/virtual/koninio.cba.pl/libraries/joomla/event/event.php on line 71