I’ve just hit this issue today. Any project i open i see this for all feilds.
They all worked last week.
Im on the latest version (2022.12.4) already and no reinstall or disk cleanup has fixed it.
Does anyone have any idea how to fix this?
Make sure you open PHPMaker via right-click on the .exe file and then choose Run as administrator.
Thank you for the response.
Unfortunately that didnt work. I am on the administrator account already to make the reinstall so I didnt think that was the issue. I usually open straight from clicking the project file.
I did install a trial on another machine and thats opening the same files without the issue. It seems to be machine/os/install spesific.
- Then you may try and reinstall on that problem PC.
- Do you also install other versions (e.g. v2023) on the same machine?
I have tried 2023 and it worked just fine on the same machine that 2022 is having issues on.
For now, i have moved the install to the machine I have tested on so I can continue working.
The only thing installed between Today and the last time i used the system a week ago seems to be ‘Microsoft Edge Webview2 Runtime’ that installed yesterday. Before that just a chrome update and then when I installed the machine in Feb. I am unable to install it because obviously microsoft shenanegans.
Microsoft Edge Webview2 Runtime should be irrelevant.If you have installed v2023, you might have updated some common files by the newer version. You may try uninstall both v2022 and v2023, then reinstall v2022.
PHPMaker v2020.0.16Same happend here today:Run as Admin, from one sec to other all pmp files are not more editable in Edit Tag => This field is not editableSince this is only my PHPMaker WIN10 Vbox machine no new install or update or any other interfirence happend.
Also test different templates etc. clear chache etc. no success.one curios think what happend before was that an drop down box do not provide data from mysql database(MariaDB), was just empty.
can field naming or charset be an issue?CREATE TABLE proz_teil (
tei_id int(6) NOT NULL AUTO_INCREMENT,
tei_haupt_id int(6) DEFAULT NULL,
tei_nam1 varchar(70) DEFAULT NULL,
tei_art int(6) DEFAULT NULL,
tei_gegenstand text DEFAULT NULL,
tei_grup_id int(6) DEFAULT NULL,
tei_doc_id varchar(20) DEFAULT NULL,
PRIMARY KEY (tei_id),
UNIQUE KEY tei_id (tei_id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;BR
Jens
Have you given Lookup permission for the table?
there is no security enabled at all (one user app).
User rights on MariaDB ok (nearly root) and not changedTo digger the issue deeper it would be helpfull tu know what are the circomstances / kriteria when the program state: “Field is not updatable”?Also test on second mashine, same result.
gregor4711 wrote:
can field naming or charset be an issue?
I don’t think so.
gregor4711 wrote:
Run as Admin, from one sec to other all pmp files are not more editable in Edit Tag => This field is not editable
Which field is not updatable? Did you mean the primary key field?
all fields, all tables in all pmp files
Your project file might be corrupted. To check, create a new project from the same database and see if the fields are updatable. If updatable in new project, then your old project file is probably corrupted, you may try to find an older version from the backup folder and use project history to revert to an older version, see Project File.
In addition, please double check the permission of all those your .pmp file that have the issue; perhaps it is Read Only. If so, then make sure it is NOT Read Only.
arbei wrote:
Your project file might be corrupted. To check, create a new project from the same database and see if the fields are updatable. >
strange, same result also new project, shows in all Fields Edit Tag "this field is not updateable"Tested with PHPMaker 2023 (new and old project files) => same “this field is not updateable”
Tested with Mysql DB (instat of MariaDB) => same "this field is not updateable"arbei wrote:
try to find an older version from the backup folder and use project history to revert to an older version, see Project File.
Good to know there is an backup functionaliy, didnt know before. Try the old one from User folder (with and without update Database) => same “this field is not updateable”
Also try from my old manual backups (from oct 22) => same "this field is not updateable"just to let you know port for DB’s standard port 3306, direct connection no ssl or ssh layer
Did you remember and make sure when installing PHPMaker 2023 you have right-clicked and choose “Run as administrator”?
sure
I suggest you do a clean reinstallation as follows:
- Uninstall all versions of PHPMaker
- Delete C:\Program Files (x86)\PHPMaker 202x and C:\Program Files (x86)\Common Files\e.World (if still exists)
- Delete registry HKEY_CURRENT_USER\Software\PHPMaker\18 and HKEY_CURRENT_USER\Software\PHPMaker\19 (if still exists)
- Reboot your PC
- Download the latest version of v2022 (from registered user site) or v2023 (https://phpmaker.dev/download.php), do not use any old installer downloaded before,
- Install again as administrator
- Create a new project to test again
following your suggestion (deinstall, cleaning, install) now full functionality is back.I also notice during the process 2 points which maby relevant:
- new phpmaker.exe (2022.v16) install program was around 600k bigger than my last install exe
- the primery keys within table / db are configured as autoincremnt + primary key flag. Nnow I use also uniqu flag which should included within primary and autoincrement flag, but just in case …
many thanks!