Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Sunday 10:30 am
Add a reply View Replies (11)

Resolved Blank Page when using Custom SQL WHERE

  1. Chuck_Hellige_104784440474687469038
    Chuck_Hellige_104784440474687469038
  2. General
  3. Wednesday, October 08 2014, 05:46 PM
I am attempting to create a Radio option in the user profile that would allow users to hide their account from the list of users listed in a "Users List (Table)" menu item. I did the following:


Create a Custom field with the Title="Hidden", Alais="hidden", Type="Radio" and the Option List="1|Yes 0|No"
In Easy Profile Admin, click "Sync User"
Edited all accounts to set the option to either Yes or No (1 or 0)
Created a menu item of type "User List (Table)"
On the "Table" tab I set "Custom SQL WHERE" to: hidden=0
Saved Menu item.


The problem is when selecting this menu item on the front-end I just get a blank page. I have tried several different SQL commands (listed below) and get the same result. The only way I can get the page to display is when the "Custom SQL WHERE" is blank.

hidden NOT IN (1)
hidden=0
hidden = '0'
hidden IN (0)

Please advise. Thanks!
  1. SQL ERROR
  2. custom field
  3. Blank Page
Responses (11)
admin
admin Accepted Answer
Admin
Hi,
strange I tried and works. please post me your site details, we will check your configuration. You can use the form below the reply in "Site Details" tab
  1. more than a month ago
  2. General
  3. # 1
Chuck_Hellige_104784440474687469038
Chuck_Hellige_104784440474687469038 Accepted Answer
Content Protected
  1. more than a month ago
  2. General
  3. # 2
admin
admin Accepted Answer
Admin
in that post the problem is solved and no disable plugin is required.
  1. more than a month ago
  2. General
  3. # 3
bstripp
bstripp Accepted Answer
I have this issue as well. Also using the plugins from the prior thread. Is there a solution for this or not? I just registered and this will be a large issue for me.
  1. more than a month ago
  2. General
  3. # 4
admin
admin Accepted Answer
Admin
Hi,
sorry for late reply, it was too late for us and our offices were closed.

We have contacted RocketTheme Team to solve this issue. Unfortunately, this plugin is launched without control, this creates a number of problems including indexing of Joomla smart search built-in component.

You can use the Joomla Loadmodule Plugin instead RokInjectModule Plugin to do the same thing.

This is also what they claim
Question from customer:
Then why is RokInjectModule necesary?
Do you recomend someone?


Reply from RocketTheme Team:
I don't. LoadModule is much easier for most people to use.


Reference: http://www.rockettheme.com/forum/general-discussion/176067-rokinjectmodule-vs-loadmodule


Anyway, if you want to use this plugin, you can send me an FTP access, we will add a check to not trigger this plugin in common situations where it should not be launched. This require a small hack in RokInjectModule plugin.
  1. more than a month ago
  2. General
  3. # 5
Chuck_Hellige
Chuck_Hellige Accepted Answer
Thank you so much for following up on this. I would prefer to make the change myself so I know how to fix the issue again if it reappears after a future upgrade. Can you please let me know what needs to be changed in the RokInjectModule plugin.

Thanks
  1. more than a month ago
  2. General
  3. # 6
Chuck_Hellige
Chuck_Hellige Accepted Answer
Bill Stripp wrote:

I have this issue as well. Also using the plugins from the prior thread. Is there a solution for this or not? I just registered and this will be a large issue for me.


Bill - the temporary workaround that worked for me was to disable the RokInjectModule plugin. It sounds like they (support) might have a fix for this. We will need to wait for their response to my last post.
  1. more than a month ago
  2. General
  3. # 7
admin
admin Accepted Answer
Admin
Hi,
sorry but we not have a code of RokInjectModule. we can help you, but we need or an FTP access or PHP plugin files

[EDIT]
I forgot to reply to this:
I know how to fix the issue again if it reappears after a future upgrade
we will document any changes that we make ;)
  1. more than a month ago
  2. General
  3. # 8
Chuck_Hellige
Chuck_Hellige Accepted Answer
Content Protected
References
  1. http://sandyridgecommunitychurch.org/
  1. more than a month ago
  2. General
  3. # 9
admin
admin Accepted Answer
Admin
Ok,
try now, we have not tested :(

What have we done
- copy original file /plugins/content/rokinjectmodule/rokinjectmodule.php into /plugins/content/rokinjectmodule/rokinjectmodule.php.BAK
- add this code at line 33 of file /plugins/content/rokinjectmodule/rokinjectmodule.php
if ($context == 'com_finder.indexer')

		{

			return true;

		}


This code is the same of Email Cloak plugin and Loadmodule plugin
  1. more than a month ago
  2. General
  3. # 10
Chuck_Hellige
Chuck_Hellige Accepted Answer
Thank you for the excellent support! That worked perfectly. My Edit-Profile page is now displaying properly even after I enabled the RokInjectModule.

Thanks again
  1. more than a month ago
  2. General
  3. # 11
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.