Another bug in Infusions?
Asked Modified Viewed 902 times
douwe_yntema
douwe_yntema 33
- Senior Member, joined since
- Contributed 667 posts on the community forums.
- Started 57 threads in the forums
- Started this discussions
- Answered 1 question
How it was:
When installing an infusion that is not already installed, the PHP_fusion installer executes the inf_newtable[] from the infusion.php file of the infusion.
When updating an infusion that already is installed, the installer checks the version number. When new version has higher version, only the alter_table[] are executed.
Now:
In V9.03.50 when installing a new infusion the installer executes both the inf_newtable[] and the inf_altertable[].
This is given errors, because the newly added fields in the altertable[] section are also defined in the newtable[] section in case for a new install.
So when executing the altertable[] after executing the newtable[] section, you got errors for duplicate fieldnames.
When installing an infusion that is not already installed, the PHP_fusion installer executes the inf_newtable[] from the infusion.php file of the infusion.
When updating an infusion that already is installed, the installer checks the version number. When new version has higher version, only the alter_table[] are executed.
Now:
In V9.03.50 when installing a new infusion the installer executes both the inf_newtable[] and the inf_altertable[].
This is given errors, because the newly added fields in the altertable[] section are also defined in the newtable[] section in case for a new install.
So when executing the altertable[] after executing the newtable[] section, you got errors for duplicate fieldnames.
Anonymous User
Anonymous User 367
- Veteran Member, joined since
- Contributed 939 posts on the community forums.
- Started 2 threads in the forums
- Answered 20 questions
If you want to add new tables or columns via upgrade you must create upgrade folder in your infusion with file version_number.upgrade.inc. See this https://github.com/PHPFusion/PHPFusio...12/upgrade
douwe_yntema
douwe_yntema 33
- Senior Member, joined since
- Contributed 667 posts on the community forums.
- Started 57 threads in the forums
- Started this discussions
- Answered 1 question
That information is not written in the upgrade guide for infusions V7 -> V9.
But thanks for the explanation.
But thanks for the explanation.
Anonymous User
Anonymous User 367
- Veteran Member, joined since
- Contributed 939 posts on the community forums.
- Started 2 threads in the forums
- Answered 20 questions
It's not only for v7 -> v9. I assume you are still using old v7 infusion API.
If you have infusion v1.1 and you want to add new tables you can add upgrade/1.2.upgrade.inc file with new tables. Then in Infusions page click to "Upgrade".
This is how the new v9 upgrade system works.
If you have infusion v1.1 and you want to add new tables you can add upgrade/1.2.upgrade.inc file with new tables. Then in Infusions page click to "Upgrade".
This is how the new v9 upgrade system works.
Edited by Anonymous User on 05-04-2020 21:34,
douwe_yntema
douwe_yntema 33
- Senior Member, joined since
- Contributed 667 posts on the community forums.
- Started 57 threads in the forums
- Started this discussions
- Answered 1 question
So the information in this link is of no use anymore?
https://www.php-fusion.co.uk/infusion...orum_id=63
How can I convert my v7 infusions to v9?
https://www.php-fusion.co.uk/infusion...orum_id=63
How can I convert my v7 infusions to v9?
Edited by douwe_yntema on 05-04-2020 21:54,
Falk
Falk 131
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
- Super Admin, joined since
- Contributed 6,201 posts on the community forums.
- Started 639 threads in the forums
- Answered 11 questions
You can still convert them that way , the information was given about implementing upgrades.
Category Forum
Suspected Bugs and Errors - 9Labels
None yet
Statistics
- Views 0 views
- Posts 5 posts
- Votes 0 votes
- Topic users 3 members
3 participants
Falk 131
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
- Super Admin, joined since
- Contributed 6,201 posts on the community forums.
- Started 639 threads in the forums
- Answered 11 questions
douwe_yntema 33
- Senior Member, joined since
- Contributed 667 posts on the community forums.
- Started 57 threads in the forums
- Started this discussions
- Answered 1 question
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions