Security Assist not showing pages

When I set up pages in page manager to be viewed by security level, My pages do not view, the login will navigate to the right page on login accept but the page is totally blank the same goes for every page set to this security level, If I do not set a security level then the pages view ok, this obviously is not what I require as it is not secure. When I replace the non viewing pages with a blank page that has the security code pasted from the pages that will not view, this shows the page correctly on the security level set.

Normally in php when you get a blank page it is because there is an error occurring on the page somewhere and the error reporting is turned off. To see what the error is on these pages add this code to the top of them:

<?php 

error_reporting(E_ALL); 

ini_set('display_errors','on'); 

?>

This should let you know why the page is not showing, please post back with the result you get from this and include a copy of the page that is giving you this error and a copy of a blank page that you applied the rule to that is working. I will check on this to see what the problem might be.

thanks Eric i've found out what the problem was, there was two Security Assist folders one in root and one in admin and both where being called.

I now have a problem with encryption and sha1. the register page will put an encrypted password in the database field (this is also user level managed) but the login doesn't acknowledge the pasword, I have repeatidly created login pages using the sample video files in tutorials/support but for the life of me I can't get the password to redirect to another page it keeps failing.

Mike

Could you post back with a copy of your register and login page. I will take a look and let you know what I think.

One problem that occurs when using encryption for the password is that on the login page you need to also encrypt the value that the user is entering for the password so that the compare works out correctly.

Another issue that I have seen is that the password column is not defined as a varchar of large enough size. It should have a size of at least 40 to allow for the full length of the sha1 hash.

Hi Eric please see the attached login file. I have checked my database and I have it set up to VarChar 40 already. The registration page manges to put a SHA1 code into the database but I cant get the login to check my input against it.

Also on another note, I've seen my search results do not clear when I go back into the results page when I would expect to see all my data rather than just the results from a previous search i.e data grid page, I have checked the forum and it appears Web Assist automatically saves the result, how do I get rid of this, I want the search result to automattically clear when you navigate out of the search results page.

Mike

When you are testing this are you entering a password or are you using the auto login portion? The standard login seems to be setup correctly to me, but the auto login authenticate user server behavior seems incorrect. It looks like you are referencing the username session variable and the posted password. You should instead reference $_COOKIE["AutoLoginUN"] for the username and $_COOKIE["AutoLoginPWD"] for the password.

Other than this I do not see a problem with the current setup. If you continue to have trouble with this please post back with a copy of your db. I do not need to have any records, the structure will do.

As for saving the search query this is done on the DataAssist created results page. On this page you will see a section of code like this:

//save the query in a session variable

  if (1 == 1) {

    $_SESSION["WADbSearch1_1items_Results"]=$WADbSearch1->whereClause;

  }

You session variable name will differ from this example. You can just comment out the line within the if statement with two slashes like this:

//save the query in a session variable

  if (1 == 1) {

    //$_SESSION["WADbSearch1_1items_Results"]=$WADbSearch1->whereClause;

  }

This will make it so the results are not held in a session variable.

Thanks Eric, i've worked out what i've done wrong, I see the permissions for the opening page to 3 but set the login lave to 0 so it wouldn't show.

Thank you also for the search results, it works a treat, just one thing, I'm not sure how to filter my results, say I have to records New England and England when I search on a dropdown menu and select England it will show both New England and England. When I search on the dropdown for New England the results I get is New England which is correct, how do I filter out so only the result that matches exctly the drop down is shown.

Regards Mike

If your search term is coming from a select menu then you should update the DataAssist Search server behavior for this particular search element and for the comparison set to to = or exact match rather than includes.

I have a dropdown menu lists that are dynamically getting data from a datbase table, the dropdowns show duplicate record names, e.g if there are 10 cars all called Astra, then i get a list of 10 "Astra" what i want is 1 Astra and when you select it it shows all 10 in the results page. How do i get around this!

Mike

If you would like to consolidate the records you are seeing in the list you should do a group by. When you add a group by clause to your rs it will ensure that the values that are returned are grouped by the column you reference. Here is a link to more info on this SQL statement:

sql_groupby.asp