The code of VFront has moved on Github
postgres issue - Synchronize database/frontend fails when CaseSensitive table names are found
specifying input type "values defined by table" generates PHP warnings
misleading error message in installation routine
Also log changes done in submasks
Can not Create Widget
Great! Just curiosity: did you test it with the latest Postgresql (9.x and/or 10.x)? I guess, it should work without problem.
I reinstalled VFront, now the VFront tables are in the same Postgresql database as the DB itself. Now when I imported the DB into the frontend, the Compatibility test showed only 4 errors instead of 12 (no primary keys). So, in general, it seems using sqlite as vfront backend is not really a good idea. Note: I had to increase the size of commento (varchar 255) in all vfront tables, otherwise I was not able to import the DB. This is because I had heavy comments on the tables.
In other table VFront was able to see the Primary Key. The difference could be, the problematic table has foreign key, too. Here are the constraints: CONSTRAINT msz_id_pk PRIMARY KEY (id), CONSTRAINT fid_fk FOREIGN KEY (fid) REFERENCES mf (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION
It seems VFront just cannot see the Primary Key of the table in Postgresql 8.4. There is a primary key defined in the table, but VFront cannot see it.
Some progress: VFront has log, where I can found some leads. It seems the missing Primary Key is the reason, why the grid view is empty, at least in my case. Here is the relevant part from the log: LINE 1: SELECT as pk, fsz,cd,vk,vn,vg,var... ^ SELECT as pk,
Hi, This bug still exists in 0.99.5. I have Database is on Postgresql 8.4 (yes, old), Vfront in sqlite Table in the database has no primary key. In the browser I cannot see any relevant issue (Shift+F8 devtools, console) What can I do solve this issue? What kind of info do you need to solve this? Thanks, István
Checkboxes do not update properly when using postgresql database
Fixed bug about the "+" char.
Fixed bug about autoincrement. Now when a new record is added, the cursor point to the right record.
I second this. I'm using postgresql with vfront. The "default" is shown in the field editor properly, but when I make a new record, it does not use the next value in the sequence.
Removed debug
0.99.5 released - XSS vulnerability fix and other improvement
Update on CHANGELOG (pre-release)
Fix on Log Update (better SQL parsing) and Log History.
Fixed XSS vulnerability on $_SERVER['PHP_SELF'] & parameters in GET
Fixed XSS vulnerability on $_SERVER['PHP_SELF'] & parameters in GET
Fixed XSS vulnerability on $_SERVER['PHP_SELF'] & parameters in GET
Fixed XSS vulnerability on $_SERVER['PHP_SELF']
Fixed XSS vulnerability on $_SERVER['PHP_SELF']
Update field select in submask
Can we populate value in the field based on a Sequence defined in DB
Cant populate value in the field based on a Sequence defined in DB
Can we populate value in the field based on a Sequence defined in DB
I want to use the sequence defined on the field in DB to be assigned when we create a NEW record from the VFRONT. For eg by default the Primary Key in table will have a Sequence been created to use the same whenever a record is created. But the problem is by default in VFRONT all the fields which are Primary key are required(*) and hence would raise a error while creating a NEW record. "Autocomplete from table will not" will not help. Has anybody found a way around it. Please share....thanks in ...
I want to use the sequence defined on the field in DB to be assigned when we create a NEW record from the VFRONT. For eg by default the Primary Key in table will have a Sequence been created to use the same whenever a record is created. But the problem is by default in VFRONT all the fields which are Primary key are required(*) and hence would raise a error while creating a NEW record. "Autocomplete from table will not" will not help. Has anybody found a way around it. Please share....thanks in ...
Cannot delete subform
Values defined by table 403
Modifying or disabling session timeout
changed or new comments aren't recognized in "Synchronize database/frontend"
%cognomenome" variable seems to fail in hidden input type filed
MySQL year() datatype isn't recognised
Session Timeout
Ldap link test on install failed (simple fix)
Report from SQL - Unsafe keyword checking
Bug selecting a record when a table has a default filter applied
"Autocomplete from" in subforms
0.99.4 released - PHP7 and Postgresql 9.5
0.99.4 released - PHP7 and Postgresql 9.5
Deleted test folder
Pre-release 0.99.4
Fix in Postgresql >= 9.4
Fix in the import process
PHP7 compatibility
legacy sqlite v. 2 frontend
updating installation on multiple databases
P.S.: If you are Italian, reply me in Italian. Thanks. P.S.: Se sei Italiano, rispondimi...
Records not view in grid table
It was the case for the ubuntu machine, now all the subfolders are writable and I...
It seems to be a misconfiguration of filesystem permission, not a bug. Please check...
Unable to use "values defined by table" on a foreign key
ldap_escape() definition clashes with php5-ldap
0.99.3 - Other bugfixes
Pre-release: set version
Deleted unused code
Fix on INSERT with PostgreSQL on date and numer...
Fix on "tabella link " connection
Multibyte support not tested during installation and errors
Multibyte support not tested during installation and errors
after fresh install, sqlite access fails
Multibyte fallback (fix https://sourceforge.net...
Version number
Add security support in user creation
Hi Mateusz Normally VFront, during the installation, copy the sqlite file from a...
Bugfix on boolean fields / MYSQL tinyint(1)
Changes in the alias column in grid view. Now t...
after fresh install, sqlite access fails
Embedded table subform does not show values defined from table
Create new widget does not enable link definition (and fails)
Multibyte support not tested during installation and errors
Problem here is that attacker can abuse the cross-site scripting vulnerability via...
vfront-0.99.2 CSRF & Persistent XSS
Hi, I've just fixed the issues in the SVN. Maybe I'm wrong, but everything seems...
Security issues fix
Security issues fix
http://hyp3rlinx.altervista.org/advisories/AS-VFRONT0602.txt
vfront-0.99.2 CSRF & Persistent XSS
Function common for the server name - attachments
Function common for the server name - attachments
New JS translation for ES (thank you to Daniel ...
Bugfix in submask with PK -> FK (http://www.vfr...
0.99.2 - Postgres bugfix
Changes in CHANGELOG and other files (pre-release)
Fix in Default Filters (http://www.vfront.org/f...
Fix in recursive_escaped in Postgresql
Fix in recursive_escaped in Postgresql