PHP Application Generator

PHsPeed is a PHP generator, RAD and Case development tool for PHP applications. It makes use of PDO for database independence, bootstrap for mobile application, jquery/ajax for responsiveness.
Before posting a new issue, please look at the (closed) items to see if the issue has already been posted and/or might be fixed. Always use the latest released version.On every release, we close the issues that are fixed in that release, which makes them invisible for the current view. So all items that are shown as fixed are not (yet) released!

ID Category Task Type Severity Summary Status Progress Opened Last Edited
470Backend / CoreBug ReportLowCsrf error when you redirect using a submit button.Closed
100%
06.03.202406.03.2024 Task Description

<p></p>

469Backend / CoreBug ReportLowInitial formmode is not remembered when it is passed by...New
0%
06.03.202406.03.2024 Task Description

<p></p>

468Backend / CoreBug ReportLowSample kanban brokenNew
0%
06.03.202406.03.2024 Task Description

If you select a task, then always the first task it taken.

467PHP GeneratorBug ReportLowInitialFormMode not respectedFixed
100%
12.02.202406.03.2024 Task Description

When a button redirects with a initial formmode in the not-ajax mode then the status gets lost.

466Backend / CoreEnhancementLowsaved directories showing several paths from developmen...Fixed
100%
07.01.202413.01.2024 Task Description

When creating a new project in the saved directories list several development paths such as:

aducomprojects
giuprojects
kitprojects
etc

465Backend / CoreEnhancementLowgrids mobile responsibity is not enabledFixed
100%
07.01.202413.01.2024 Task Description

mobile library is not included in the application links for bootstrap-table and mobile mode of grids is not automatically applied

464Backend / CoreEnhancementLowgroup total in grids not workingClosed
100%
07.01.202413.01.2024 Task Description

When setting up a total by group the row showing the total is not generated

463Backend / CoreEnhancementLowfunction redirect form mode parameter not workingClosed
100%
07.01.202406.03.2024 Task Description

when using the redirect function the las parameter initialformmode is not working

$app→redirect('form.php',$origin,$params,'Add');

as a side note entries in the KB about the function show variations regarding the parameter value during the initialformmode session variable

462Backend / CoreEnhancementLowmodalsearch runtime error: [foreach() argument must be ...Closed
100%
07.01.202406.03.2024 Task Description

set up a modal search

when the modal search is executed in the application, a record is selected and the search is executed the follow error is risen

runtime error: [foreach() argument must be of type array|object, null given]

aparently the selected record id is not being passed

461IDEEnhancementLowAccess violation when setting project default values in...Closed
100%
07.01.202406.03.2024 Task Description

when right-cliking on a component property and selecting the option "Manage property/set as default value" the application rises an access violation. the issue solves by executing the application as administrator and setting up the first property .

460Backend / CoreBug ReportLowSQLServer - DBQuery component does not retrieve metadat...Fixed
100%
06.10.202306.10.2023 Task Description

Apparently when trying to get fields names and properties for a DBQuery component using SQL Server, the sentence generate does not respect the SELECT TEMPLATE set for the connection.

Steps to reproduce:
- Having a SQL Server database configured (and working!)
- Create an empty runnable app with Database Connection
- Put a DBQuery component and set the dbconnection property
- Set the "query" propierty to any valid SQL like select * from carga
- Try to open the "fields" property

Error message:"Microsoft ODBC SQL Server Driver Incorrect syntax near 'limit'"

From SQL Server Profile the sentence PHsPeed tried:

SELECT carga.Codigo, carga.Descripcion, carga.Monto_Fijo, carga.Porcentaje, carga.Jornada, carga.cargaEspecial FROM dbo.carga WHERE 1=1 limit 1
Double checked my SELECT TEMPLATE in the connection properties is set to SELECT TOP …

459IDEBug ReportMediumIssue with translationsFixed
100%
03.10.202306.10.2023 Task Description

<p></p>I'm using PHsPeed 3.2 and a legacy MS SQL Server database. Some tables in the database have all lowercase names, like "dbo.configuracion", but others start with capital letter, like "dbo.Carga".

I created a batch of grid for some tables.

But when creating the translation for tables like "Carga", the fields in the Advanced Grid Settings (Bulk Edit) show strings like:

[%gpf_dboCarga_pla_dbgrid_1_link%]

As you can see, the "Carga" string starts with a capital "C" (like the table in SQL Server)

BUT, in the Project > Translation menu, the key has the name gpf_dbocarga_pla_dbgrid_1_link, all lowercase.

The result is the string is not "translated", because of case sensivity.

If I change the Grid string to lower case the translation works.

I think the [%gpf_dboCarga_pla_dbgrid_1_link%] for the field should be all lowercase to prevent the problem.

458Backend / CoreBug ReportLowtotal in grid breaking grid itselfFixed
100%
01.10.202306.03.2024 Task Description

When adding a function sum to a grid. the sql is misconstructed therefore breaks the application with an error similar

Fatal error: 2023-10-02 01:15:46 | (Error
999
in line
[]
of file
[]
) 2023-10-02 01:15:46 |
Runtime error
: [PDOException: SQLSTATE[HY000]: General error: 1 no such table: T8798BAE7424441658610867C8619D713_ex in C:\PHsPeedV31_15\xampp\htdocs\_libs\php\spdbtable.php:223 Stack trace: #0 C:\PHsPeedV31_15\xampp\htdocs\_libs\php\spdbtable.php(223): PDO->prepare('select count(*)...') #1 C:\PHsPeedV31_15\xampp\htdocs\_libs\php\spdbtable.php(1715): spdbtable->__SQLiteGetRecordCount() #2 C:\PHsPeedV31_15\xampp\htdocs\_libs\php\spdatasource.php(241): spdbtable->setSubSelectSQL('create table if...') #3 C:\PHsPeedV31_15\xampp\htdocs\_libs\php\spdbgrid.php(319): spdatasource->setSubSelectSQL('select '' as fn...') #4 C:\PHsPeedV31_15\xampp\htdocs\_libs\php\spdbgrid.php(291): spdbgrid->loadPage() #5 C:\PHsPeedV31_15\xampp\htdocs\_libs\php\spapplication.php(424): spdbgrid->__activate(Object(form_orders)) #6 C:\PHsPeedV31_15\xampp\htdocs\jwpos\form_orders.php(407): spapplication->init('M', Array, Array, Array) #7 {main}]

After reviewing the sql the following is found

create table
if not exists T8798BAE7424441658610867C8619D713_ex as
select '' as fnc, orderlines_quantity, orderlines_unitprice, orderlines_linetotal, orderlines_idorderlines, orderlines_orders_idorders
               , orderlines_products_idproducts
from T8798BAE7424441658610867C8619D713 union all
select 'Gran Total', '', '', SUM(orderlines_linetotal), '', '', ''
from T8798BAE7424441658610867C8619D713
order by          

the order by is incomplete braking the program.

457Backend / CoreBug ReportLowJavaScript event resets navbar statusClosed
100%
01.10.202306.03.2024 Task Description

Follow these steps to reproduce…

Create a grid with modal.
in the modal create an onchange event for one of the fields
in the onchange event.. change the value of another field
run the project.

when the onchange event is triggered.. then the insert status of the form is reseted.

456IDEEnhancementLowWizard should apply unique id for viewsFixed
100%
15.09.202315.09.2023 Task Description

Views have no primary key by default which is fine. You can assign one in the IDE. This key should be set to the uniqueid property of the grid so that the grid works out-of-the-box. Now you have to apply it manually before generating the application. That is confusing.

455Backend / CoreBug ReportLowResize splitter of the project manager sits on the left...Fixed
100%
15.09.202315.09.2023 Task Description

Because of that, you cannot resize the project and property windos

454IDEBug ReportLowSQLServer breaks the SQL Query BuilderFixed
100%
15.09.202303.10.2023 Task Description

The table list shows a lot of tables, but not of the current connection

453IDEBug ReportLowCannot add a form componentFixed
100%
12.09.202312.09.2023 Task Description

If you create a regular app without a form, or delete the form by accident, you cannot add a form component. PHsPeed generated an error message (component not allowed in blank application). But it is a normal application..

452IDEBug ReportLowSQLServer views are shown, but not selectableFixed
100%
11.09.202311.09.2023 Task Description

YOu can see the views, but they cannot be opened and you cannot select them in the application wizard

451Backend / CoreBug ReportLowDouble select box does not work, buttons are not respon...Closed
100%
31.03.202313.04.2023 Task Description

<p></p>

450PHP LibrariesBug ReportLowDropdown box ignores the item with the selectFixed
100%
31.03.202331.03.2023 Task Description

<p></p>

449Backend / CoreBug ReportLowTopmargin of root does not workClosed
100%
31.03.202313.04.2023 Task Description

When changing topmargin of the root, it does not have any effect

448PHP GeneratorBug ReportLowApplication generator uses wrong date field on datetime...Fixed
100%
28.03.202313.04.2023 Task Description

The work-around is to replace the date picker by the date/time picker in these situations.

447PHP LibrariesBug ReportLowdefault date(/time) does not work on insert/updateFixed
100%
28.03.202328.03.2023 Task Description

It appears that we rolled back one version too much?

446IDEBug ReportLowTitle Null in DBTable property fields should be 'not nu...Fixed
100%
28.03.202328.03.2023 Task Description

<p></p>

445IDEBug ReportLow[3.1] component tabs cannot be movedFixed
100%
23.03.202323.03.2023
444PHP GeneratorEnhancementLow[3.1] Includes based on component specificationsFixed
100%
23.03.202323.03.2023
443Backend / CoreEnhancementLow[3.1 fixed:] Adding/removing breakpoints while debuggin...Fixed
100%
23.03.202323.03.2023
442IDEBug ReportLowBulk edit of grid properties has an issueFixed
100%
17.02.202317.02.2023
441IDEBug ReportLowBulk edit ignores the checked status of modulesFixed
100%
01.02.202301.02.2023
440PHP GeneratorBug ReportLowPostgres driver reports wrong autoseq id, causing gener...Fixed
100%
29.01.202329.01.2023
439PHP LibrariesBug ReportLowgenerated pdf file includes entire server pathUnder investigation
0%
28.01.202316.05.2023
438IDEBug ReportLowChanging PHP version in the IDE does not trigger setup ...Fixed
100%
27.01.202323.03.2023
437PHP LibrariesEnhancementLowrequest change on DBNav library to allow showing or hid...Under investigation
0%
26.01.202323.03.2023
436IDEEnhancementLowenhance export project functionalityOn worklist
100%
25.01.202325.01.2023
435Backend / CoreEnhancementLowError when downloading pdf using pdfbody componentClosed
100%
21.01.202325.01.2023
434PHP GeneratorEnhancementLowapplication issue with csrf when multiple onsubmit even...Waiting for Customer response
90%
20.01.202327.01.2023
433Backend / CoreBug ReportLowphpdfClosed
100%
20.01.202320.01.2023
432PHP LibrariesBug ReportLowError in library phtemplateFixed
100%
20.01.202320.01.2023
431Backend / CoreFeature RequestLowSQLServer does not work with PHP 8.2Closed
100%
11.01.202311.01.2023
430PHP LibrariesBug ReportLowEnabling the multiselect option in the dropdown compone...Closed
100%
10.01.202327.01.2023
429IDEBug ReportLowThe embedded deploy module to create a zip file has a f...Fixed
100%
06.01.202306.01.2023
428ComponentsBug ReportLowcss of editable grid corrupts the date selector. Closed
100%
03.01.202306.01.2023
427Backend / CoreBug ReportLowDouble select box clears when no items changeFixed
100%
27.12.202227.12.2022
426ComponentsFeature RequestLowV3: Add row button feature to the dbgridOn wish list
100%
27.12.202206.01.2023
425Backend / CoreEnhancementLowAdding editable grid to grid application wizzardClosed
100%
24.12.202227.12.2022
424Backend / CoreBug ReportLowV3: Projectfile sometimes stacks global variables to a ...Fixed
100%
24.12.202206.01.2023
423Backend / CoreBug ReportLowV3: If the classtree is open, switching applications ca...Fixed
100%
24.12.202224.12.2022
422Backend / CoreEnhancementLowPHsPeed 3.0: Default date-time, date, uid on insert/upd...Closed
100%
23.11.202223.11.2022
421IDEEnhancementLowPHsPeed 3.0: N:M relation checkboxClosed
100%
23.11.202223.11.2022
Showing tasks 1 - 50 of 159 Page 1 of 4

Available keyboard shortcuts

Tasklist

Task Details

Task Editing