Skip to main content ↑ ↓

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - Asawyer13

3
Questions / Don't show initial records on list page
How can I make it so when entering a List page, it doesn't show all the records? I also don't want the No Record Found message. I want the user to have to search to see the records.

I am thinking I might be able to use some code in the Actions Before List but no clue what I could put in.



Thanks
6
Bugs / Re: Error using sqlite and Roles/Permissions
The problem stems from line 2034 in the pageactiondetails.xml file that's used to create the ACL.php file.

Does someone know if that could be changed to look at the database type (mysql or sqlite) and create the appropriate php code??? That would be a nice short term solution until an updated release could be made.

I don't know if the database type is exposed anywhere when that xml file is processed.
7
Bugs / Error using sqlite and Roles/Permissions
Bug using Roles/Permissions in Sqlite database.

I believe the buildQuery function in PDOFb.php has a bug.

When using sqlite database and using the Roles/Permssions, the query is

SELECT CONCAT(page_name, '/', action_name) AS page FROM role_permissions WHERE role_id = ?

For mysql that would be fine, however for sqlite the concatenate function is || so the query should be:

SELECT page_name ||' /' || action_name AS page FROM role_permissions WHERE role_id = ?

Can that be fixed so the sqlite database can be used with the Roles/Permissions??

Please fix...

8
Questions / Change database type
I have a project that was setup to use MySQL. I want to change it to use sqlite. I have converted the mysql database into sqlite so the table names, etc are the same.

Is there a way to change the PHPRad object to use sqlite instead of MySQL? I tried making the change in the Global Settings but I get an error. Not sure where else I could change it.

There must be someplace in the project that I could change the database type. I'm not even against sending the project to PHPRad Techs to make the change for me. It's just this one project, but it's a decent sized project and I'm not sure I remember everything I did.

Thanks
Alan
9
Issues / Re: Getting PDO error
I didn't do anything specific that I know of. What should I be looking for?
10
Questions / Re: SQL Server support
Thank you for the information. I did see it when you create a new project but I was looking in the project properties as I was wanting to change a project that currently was using mysql.

Hopefully the outstanding issues with mssql will be able to be fixed soon?

Thanks again
Alan
11
Questions / SQL Server support
I know I had seen at least one or two screenshots that showed SQL Server as a database that I could use. I see now that support for it was removed 2 versions ago.

Can you tell me why?? I would very much like to use MSSQL going forward along with MySQL and Sqlite.

Thanks
Alan
12
Questions / IIS url rewrite
Is anyone running phprad with IIS?

I cant get the mod_rewrite file to import into IIS so even though I can get the main page to work, I am unable to navigate to other pages.
13
Bugs / Re: Joining 2 tables with 'Soft Delete' enabled on both tables
I am thinking that you'll get that error if any columns between the two tables match.. Instead of the SQL Statement being "Select *" it should list the columns and preface each by the table name. Hopefully PHPRad can make that change in the next release..
14
Issues / Getting PDO error
Using PHP 7.2 and xampp.

Getting an error while trying to access my sqlite database.

All other pages work, like Home, Contact Us, etc

It's a simple table


Error 500

Server Error
Exception Traces
This will only be displayed in DEVELOPMENT_MODE.
Error Message    Call to a member function execute() on null
File    C:\xampp\htdocs\test\app\models\PDODb.php On Line 1045
Stack Trace    1 C:\xampp\htdocs\test\app\controllers\TestController.php(53): PDODb->get('test', Array, Array)2 C:\xampp\htdocs\test\system\Router.php(196): TestController->index()3 C:\xampp\htdocs\test\system\Router.php(109): Router->run('test')4 C:\xampp\htdocs\test\index.php(106): Router->init()


Thanks
Alan