Not update database after add a new field to Admin View #1153

Closed
opened 2024-07-29 23:48:20 +00:00 by kwaninmacau · 5 comments

Steps to reproduce the issue

When I add a new field to Admin View, and compiler my component, but unzip the install files, didn't find sql update folder or files
PS:I only use demo Look component.

Expected result

auto update database table by adding new field.

Actual result

Can't update database table adding new field.

System information (as much as possible)

  • OS Name & Version: linux
  • MySql Version: 8.0
  • Apache Version: 2.4.61
  • PHP Version: 8.2
  • Joomla Version: 5.1.1
  • JCB Version: 5.0.1-alpha5
  • Browser: firefox 128.0

Additional comments

### Steps to reproduce the issue When I add a new field to Admin View, and compiler my component, but unzip the install files, didn't find sql update folder or files PS:I only use demo Look component. ### Expected result auto update database table by adding new field. ### Actual result Can't update database table adding new field. ### System information (as much as possible) - OS Name & Version: linux - MySql Version: 8.0 - Apache Version: 2.4.61 - PHP Version: 8.2 - Joomla Version: 5.1.1 - JCB Version: 5.0.1-alpha5 - Browser: firefox 128.0 ### Additional comments
Owner

With the latest release of JCB this issue should be fixed.
Simply install using the link 5.0.2-alpha3 and it should be fixed.
I have not been getting the issue of the database not updating in the latest release.

With the latest release of [JCB](https://git.vdm.dev/joomla) this issue should be fixed. Simply install using the link [5.0.2-alpha3](https://git.vdm.dev/joomla/pkg-component-builder/releases/tag/v5.0.2-alpha3) and it should be fixed. I have not been getting the issue of the database not updating in the latest release.
Owner

Also please make sure you watch these videos to understand that the demo component needs to be opened and saved in various areas for the updates to work, since its shipped without history liked to is inside the Joomla history component.

https://youtu.be/bRPJTRat158?si=0OPG25Ix3D0k5xu0
https://youtu.be/zN2M15fzf_M?si=frawon8Cn4_Tag5M
https://youtu.be/55U8FDlLI7Q?si=l6Tb7JEDzb0Lacle <=== IMPORTANT!

Also please make sure you watch these videos to understand that the demo component needs to be opened and saved in various areas for the updates to work, since its shipped without history liked to is inside the Joomla history component. https://youtu.be/bRPJTRat158?si=0OPG25Ix3D0k5xu0 https://youtu.be/zN2M15fzf_M?si=frawon8Cn4_Tag5M https://youtu.be/55U8FDlLI7Q?si=l6Tb7JEDzb0Lacle <=== IMPORTANT!
Author

I have upgraded to 5.0.2-alpha3, but this time been getting an issue of DB not creating new table, I have add a new admin view so adding a new table.

I have upgraded to 5.0.2-alpha3, but this time been getting an issue of DB not creating new table, I have add a new admin view so adding a new table.
Owner

Also please make sure you watch these videos to understand that the demo component needs to be opened and saved in various areas for the updates to work, since its shipped without history liked to is inside the Joomla history component.

https://youtu.be/bRPJTRat158?si=0OPG25Ix3D0k5xu0
https://youtu.be/zN2M15fzf_M?si=frawon8Cn4_Tag5M
https://youtu.be/55U8FDlLI7Q?si=l6Tb7JEDzb0Lacle <=== IMPORTANT!

Also please make sure you watch these videos to understand that the demo component needs to be opened and saved in various areas for the updates to work, since its shipped without history liked to is inside the Joomla history component. https://youtu.be/bRPJTRat158?si=0OPG25Ix3D0k5xu0 https://youtu.be/zN2M15fzf_M?si=frawon8Cn4_Tag5M https://youtu.be/55U8FDlLI7Q?si=l6Tb7JEDzb0Lacle <=== IMPORTANT!
Owner

Since this report was opened, JCB's database update generation has undergone significant improvements.
The current compiler supports automatic SQL updates when new fields are added to existing Admin Views or new database tables are introduced.

Please note that JCB uses Joomla's version history to detect changes. When working with imported demo components, it is important to ensure the relevant records have been saved so the compiler can establish the necessary history.
As this issue relates to an early alpha release and the reported functionality is supported in current JCB versions, we will be closing it as resolved.

We encourage you to update to the latest supported JCB release. If you encounter a new issue with database updates, please feel free to open a fresh report with current reproduction details.

Since this report was opened, JCB's database update generation has undergone significant improvements. The current compiler supports automatic SQL updates when new fields are added to existing Admin Views or new database tables are introduced. Please note that JCB uses Joomla's version history to detect changes. When working with imported demo components, it is important to ensure the relevant records have been saved so the compiler can establish the necessary history. As this issue relates to an early alpha release and the reported functionality is supported in current JCB versions, we will be closing it as resolved. We encourage you to update to the latest supported JCB release. If you encounter a new issue with database updates, please feel free to open a fresh report with current reproduction details.
Sign in to join this conversation.
3 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: joomla/Component-Builder#1153