Site goes blank after changing Login Redirection Page in Pop login

Hi,

I am using Joomla 3.0 and installed this plugin which is working fine.

But when i tried to change the login redirection page, complete site goes blank with this message "0, SQL=SELECT FROM WHERE =1 AND ='101'"
"Error displaying the error page: SQL=SELECT FROM WHERE =1 AND ='101'"

I tried this on a fresh installation of Joomla 3.0.2, so not providing the site URL info. Please mail me if these details required.

Can anyone please help me on this
11 years 11 months ago #1 by Ganesh

Please Log in or Create an account to join the conversation.

Hi,

I was able to get my site by changing the following code in helper.php but i am not sure this is really a fix or not.

****original @Line 27
$query->select($db->nameQuote('link'));
$query->from($db->nameQuote('#__menu'));
$query->where($db->nameQuote('published') . '=1');
$query->where($db->nameQuote('id') . '=' . $db->quote($itemid));

**** changed
$query->select('link');
$query->from('#__menu');
$query->where('published=1');
$query->where('id = '.$db->quote($itemid).'');

Thanks
Ganesh
11 years 11 months ago #2 by Ganesh

Please Log in or Create an account to join the conversation.

  • Posted by TemplatePlazza (5260) Offline
Hi sgg_btech
How about to change that line 27 with this one :
$query->select($db->quoteName('link'));
$query->from($db->quoteName('#__menu'));
$query->where($db->quoteName('published') . '=1');
$query->where($db->quoteName('id') . '=' . $db->quote($itemid));

Can you tell what is the result?
11 years 11 months ago #3 by TemplatePlazza

Please Log in or Create an account to join the conversation.

Hi,

The issue was not there with your mentioned code (quoteName) as well.

Thanks for the support
11 years 11 months ago #4 by Ganesh

Please Log in or Create an account to join the conversation.

  • Posted by TemplatePlazza (5260) Offline
Ok great. Thanks for your confirmation :)
11 years 11 months ago #5 by TemplatePlazza

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum