marciuz / vfront Goto Github PK

Warning: count(): Parameter must be an array or an object that implements Countable in C:\xampp\htdocs\vfront\classes\src\Log.php on line ;864

Warning: count(): Parameter must be an array or an object that implements Countable in C:\xampp\htdocs\vfront\classes\src\Log.php on line882

This pages gives me a lotta php errors:

Warning: Illegal string offset 'XAxisDisplay' in C:\xampp\htdocs\vfront\plugins\pchart\class\pData.class on line 58
Warning: Illegal string offset 'XAxisFormat' in C:\xampp\htdocs\vfront\plugins\pchart\class\pData.class on line 59
Warning: Cannot assign an empty string to a string offset in C:\xampp\htdocs\vfront\plugins\pchart\class\pData.class on line 59
Warning: Illegal string offset 'XAxisName' in C:\xampp\htdocs\vfront\plugins\pchart\class\pData.class on line 60
Warning: Cannot assign an empty string to a string offset in C:\xampp\htdocs\vfront\plugins\pchart\class\pData.class on line 60
Warning: Illegal string offset 'XAxisUnit' in C:\xampp\htdocs\vfront\plugins\pchart\class\pData.class on line 61
Warning: Cannot assign an empty string to a string offset in C:\xampp\htdocs\vfront\plugins\pchart\class\pData.class on line 61
Warning: Illegal string offset 'Abscissa' in C:\xampp\htdocs\vfront\plugins\pchart\class\pData.class on line 62
Warning: Cannot assign an empty string to a string offset in C:\xampp\htdocs\vfront\plugins\pchart\class\pData.class on line 62
Warning: Illegal string offset 'Axis' in C:\xampp\htdocs\vfront\plugins\pchart\class\pData.class on line 63

Fatal error: Uncaught Error: Cannot use string offset as an array in C:\xampp\htdocs\vfront\plugins\pchart\class\pData.class on line 63
Error: Cannot use string offset as an array in C:\xampp\htdocs\vfront\plugins\pchart\class\pData.class on line 63

I would like to see an option to define more than one set of views for a table (so to reduce editing complexity by focusing on subsets of the available fields).

If I use the search feature I can find matching records just fine and it shows them in grid view.
But when I double-click on the record I want it instead takes me to record 1 every single time.

I'm not sure if this is a result of upgrading PHP to 7.4 from PHP 5.x, or if it's a change to the javascript behaviour in Firefox and Chrome. Unfortunately my distro no longer supports PHP 5.x, so testing that would be a significant headache.

This seems to be a general issue with the grid view whether using it in search mode or not. But it taking out the search feature would seem to be pretty serious.

Upgrading to the latest vfront seems to have no effect.
My database has only 1205 records in this table, so I doubt that's the issue.

No errors in the apache log files or database logs that I can find.

This seems like it might be vaguely related to bug #1 but I can't be certain of that. It doesn't have anything to do with filters so far as I can tell.

I'm willing to perform whatever tests might help you find the cause of this, but my database contains quite a bit of confidential stuff, so I may have to redact quite a bit of the output.

The 4.2.4 version of Adminer (part of vfront) generates a php warning that obsures the top of the screen.

The latest adminer version is 4.8.1.

Accessing http://127.0.0.1/vfront/admin/
Notice: Undefined offset: 0 in C:\xampp\htdocs\vfront\admin\findupdates.php on line 52

The translation 'js/lang/vfront-nl.js' is missing (perhaps an idea to use the English translation as fallback). I copied the english translation to the dutch one and things started to work a lot better.

Hey,
I've been searching for a while for a PostgreSQL databases front-end. The one you developed suits perfectly on what I need. But I think I found a bug (or maybe isn't working for me). When I see a record in the form view, all bools appear as checkboxes. But if in the record, that bool is true (1) the checkbox isn't checked. So I suppose that the regular behaviour of a boolean checkbox is that if it's true (1) must be checked and if it's false (0), isn't checked. Also, if I try to make a bool true by checking it and I save changes, it doesn't work. Can you please have a look on that?
Thanks in advance and thanks also for your really helpful open source,
Dídac.

vfront.org, which is listed as being the project's official website, shows the last release as being in 2017. The forums are down and have been for years. The sourceforge page has only the 2017 release.

If one does not bother to look specifically at the Sourceforge Support page for vfront, the project appears to be stone dead. I was in the process of deciding what to migrate to when I found the github.

It might be wise to do a little updating. There really isn't anything else out there that is both this simple to use and actually works reliably. At least, not that I could find.

It would be nice to have more than two columns for showing a record in formview (so one can get rid of vertical scrollbars).

Downloaded the most current release and upon setting the language, there was no option for English. Is this correct? Used the default and installed.
Whole site is in Dutch.

The localisation file for me is in the /locale directory but not in a sub-directory like the other available options. Would this be why it was unavailable for selection?

Directions on how I should fix this would be appreciated.

If I set a field of an embedded submask to use values defined by a table, it results in an empty disabled drop-down list.

If instead the values are defined in the text box, the correct value is shown in the disabled drop-down list.

I'm using version 0.99.5.

When trying to import a simple CSV with 3 columns, I can go through all the steps for the importation and mapping of fields, but at the last step I get a 500 error. The URL refers to ?step=21
Using php 7.4.3
Grazie

Hello,
When trying to delete a record of a subform by clicking the delete button of that specific record, it disappears but still appears: (1 record). Also, If I click the save button after "deleting" the record, appears the message "Record well saved" and the subform refreshes and appear that deleted record.
How can I fix it?
Thanks in advance,
Dídac.

I see no horizontal scrollbar in gridview, so cannot use it for very wide tables with lots of columns.

When I apply a filter to any table and then display records within table view it shows them correctly filtered but when I double click to view the record it does not open the correct record.

Here's a full Dutch translation for those who like. Could you add this to the code files Marcello?
nl_NL.zip

I have two tables defined as

CREATE TABLE `A` (
  `ID` SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `Name` VARCHAR(30) NOT NULL
);
CREATE TABLE `B` (
  `ID` SMALLINT UNSIGNED PRIMARY KEY,
  `A_ID` SMALLINT UNSIGNED UNIQUE KEY,
  CONSTRAINT `fk_B_A`
    FOREIGN KEY (`A_ID`) REFERENCES `A` (`ID`)
    ON DELETE RESTRICT
    ON UPDATE CASCADE
);

I make table A visible and create a subform for table B, which works correctly both as a shadowbox subform and as an embedded subform.

I then make table B visible and create a subform for table A, which works correctly as a shadowbox subform.
As an embedded subform, instead, it tries to match A.ID with B.ID instead of B.A_ID, despite being correctly set: it displays the record of A with A.ID = B.ID if it exists, otherwise it results in No data available for the subform "A".

I was able to go through the install process, but when I tried to log in, I got an error:

Parse error: syntax error, unexpected '?' in /var/www/html/vfront/classes/src/User_Session.php on line 35

It seems the release assumes php7 (use of null coalescing operator, ??) but checks at start of install do not warn that php version will not work.

If a field's values are defined by table, sometimes, apparently randomly, on page load the <select> element is populated but no <option> is selected, resulting in the empty entry being shown.
Changing record back and forth always results in the correct <option> being selected.

Unable to get vfront to connect to the MySQL Database. I don't know if it's because of PHP 7.4

Warning: Illegal string offset ‘XAxisFormat’ in vfront/plugins/pchart/class/pData.class on line 58
Warning: Illegal string offset ‘XAxisFormat’ in vfront/plugins/pchart/class/pData.class on line 59
Warning: Cannot assign an empty string to a string offset in vfront/plugins/pchart/class/pData.class on line 59
Warning: Illegal string offset ‘XAxisName’ in vfront/plugins/pchart/class/pData.class on line 60
Warning: Cannot assign an empty string to a string offset in vfront/plugins/pchart/class/pData.class on line 60
Warning: Illegal string offset ‘XAxisUnit’ in vfront/plugins/pchart/class/pData.class on line 61
Warning: Cannot assign an empty string to a string offset in vfront/plugins/pchart/class/pData.class on line 61
Warning: Illegal string offset ‘Abscissa’ in vfront/plugins/pchart/class/pData.class on line 62
Warning: Cannot assign an empty string to a string offset in vfront/plugins/pchart/class/pData.class on line 62
Warning: Illegal string offset ‘Axis’ in vfront/plugins/pchart/class/pData.class on line 63
Fatal error: Uncaught Error: Cannot use string offset as an array in vfront/plugins/pchart/class/pData.class:63 Stack trace: #0 vfront/stats/stat.graph2.php(33): pData->pData() #1 vfront/stats/stat.count_table.php(87): barre_pchart(Array, Array, 1435.5, ‘Table populatio…’, ‘tab_count’, 540, 280, Array, 165, ‘%d’, ‘ivory’) #2 {main} thrown in **

There seems to be a new pchart/pData.class as of December 2020 to address this issue

vfront is not working and installing with php 8.1 and postgres 14. The only message I receive is "Connection error: is Postgres running? Otherwise please check your conf file".
The conf.vfront.php file is ok. The message is from vmsql.postgres.php at line 45, it seems related to is_resource().
I tested the connection to postgres 14 with a simple php script (pg_connect ....) and it works, so I think that this issue could be related to is_resource().
Please if you have some suggestions I could test everything on my pc.

Everithing works fine except xml report from query that return a "404 The requested URL was not found on this server."
The report from table is working and all dir are writable.
Strainge issue is that the name of the reports ares not written in the list, in fact all report are without names (??) pls see attached screenshot.
Someone already face this problem?

vfront .99.5
php 7.3

Any help is very appreciated

Form starts infinity loop when clicking from Grid view to Form view

Is there a special requirement in table relations to be able to create a subform?

When I try to create a subform and link the tables on an id field i get en error about invalid reference for foreign key.

My database does not have foreign keys or relations defined.