เว็บบอร์ด PHP เว็บส่งเสริมการเรียนรู้ Hosting CRM ERP Server Programming ถาม-ตอบปัญหา

โดย **Raja Pdl** » 15/11/2024 9:20 am

MindPHP Assistant เขียน: ↑15/11/2024 9:16 am In a Joomla! extension manifest file, the placement of certain tags and elements is crucial for the correct functioning of the extension's installation, uninstallation, and updating processes. Let's go through your questions step by step:

### 1. How does the `<update>` tag locate the directory?

The `<update>` element within the Joomla! extension manifest file is used to define the schema update files for your extension. The path you specify in `<schemapath>` is relative to the root of the extension directory.

When you specify:
โค้ด: เลือกทั้งหมด
xml
<schemapath type="mysql">install/updates/</schemapath>
Joomla! looks for the `install/updates/` directory relative to the main directory of your extension, which is typically the root directory where the manifest file resides. Therefore, even if your updates folder is located at `administrator/components/com_tools_calendar_events/install/updates`, you should specify the path as `install/updates/` in the manifest file because the base path is the root of the extension directory by default.

### 2. Why doesn't it work when added inside the `<administration>` tag?

In Joomla!, the `<administration>` tag is used to define files and settings specific to the administrator part of a component. Elements such as `<files>`, `<menu>`, and `<submenu>` are typically included within this tag to add administrative features and files.

However, the `<install>`, `<uninstall>`, and `<update>` tags should not be placed inside `<administration>` because they are not part of the administrator-specific configuration. Instead, they are part of the overall extension installation and update process, which applies to both the frontend and backend of the component.

Placing them inside `<administration>` can cause Joomla! to not recognize or execute these tasks, leading to issues with installation, updates, or uninstallation processes of the component.

### Summary

- **Location of Directories**: The paths in `<update>` and similar tags are relative to the root of the extension's directory structure, not specifically to any subdirectory like `administrator/`.
- **Tag Placement**: `<install>`, `<uninstall>`, and `<update>` are global to the extension and should remain outside of the `<administration>` section to function correctly.

By ensuring that these tags are correctly placed at the top level of the manifest file, Joomla! can handle the installation, updating, and uninstallation of your component effectively.

I understand now, thank you

โดย **MindPHP Assistant** » 15/11/2024 9:16 am

In a Joomla! extension manifest file, the placement of certain tags and elements is crucial for the correct functioning of the extension's installation, uninstallation, and updating processes. Let's go through your questions step by step:

### 1. How does the `<update>` tag locate the directory?

The `<update>` element within the Joomla! extension manifest file is used to define the schema update files for your extension. The path you specify in `<schemapath>` is relative to the root of the extension directory.

When you specify:

โค้ด: เลือกทั้งหมด

xml
<schemapath type="mysql">install/updates/</schemapath>

Joomla! looks for the `install/updates/` directory relative to the main directory of your extension, which is typically the root directory where the manifest file resides. Therefore, even if your updates folder is located at `administrator/components/com_tools_calendar_events/install/updates`, you should specify the path as `install/updates/` in the manifest file because the base path is the root of the extension directory by default.

### 2. Why doesn't it work when added inside the `<administration>` tag?

In Joomla!, the `<administration>` tag is used to define files and settings specific to the administrator part of a component. Elements such as `<files>`, `<menu>`, and `<submenu>` are typically included within this tag to add administrative features and files.

However, the `<install>`, `<uninstall>`, and `<update>` tags should not be placed inside `<administration>` because they are not part of the administrator-specific configuration. Instead, they are part of the overall extension installation and update process, which applies to both the frontend and backend of the component.

Placing them inside `<administration>` can cause Joomla! to not recognize or execute these tasks, leading to issues with installation, updates, or uninstallation processes of the component.

### Summary

- **Location of Directories**: The paths in `<update>` and similar tags are relative to the root of the extension's directory structure, not specifically to any subdirectory like `administrator/`.
- **Tag Placement**: `<install>`, `<uninstall>`, and `<update>` are global to the extension and should remain outside of the `<administration>` section to function correctly.

By ensuring that these tags are correctly placed at the top level of the manifest file, Joomla! can handle the installation, updating, and uninstallation of your component effectively.

โดย **Raja Pdl** » 15/11/2024 9:16 am

Raja Pdl เขียน: ↑15/11/2024 8:56 am My <install>, <uninstall>, and <update> tags were inside <administration>. I moved them outside of the <administration> tag, and it works now

โค้ด: เลือกทั้งหมด

<extension type="component" version="5.0" method="upgrade">
    <name>com_tools_calendar_events</name>
    <version>1.5.43</version>
    <scriptfile>install.php</scriptfile>
    
            <install>
            <sql>
                <file charset="utf8" driver="mysql">install/tools_calendar_events.sql</file>
            </sql>
        </install>
        <uninstall>
                <sql>
                    <file charset="utf8" driver="mysql">install/unistall.sql</file>
                    <file driver="mysql">install/unistall.sql</file>
                </sql>
        </uninstall>
        <update>
                <schemas>
                        <schemapath type="mysql">install/updates/</schemapath>
                </schemas>
        </update>

    <administration>
        <files folder="administrator/components/com_tools_calendar_events">
            <folder>controllers</folder>
            <folder>models</folder>
            <folder>assets</folder>
            <folder>views</folder>
            <folder>language</folder>
            <folder>tables</folder>
            <folder>install</folder>
            <filename>tools_calendar_events.php</filename>
        </files>
        <menu>com_calendar_events</menu>
        <submenu>
            <menu link="option=com_tools_calendar_events&amp;view=events">com_calendar_events_events</menu>
            <menu link="option=com_tools_calendar_events&amp;view=eventtypes">com_calendar_events_eventtypes</menu>
        </submenu>
    </administration>

    <files folder="components/com_tools_calendar_events">
        <folder>controllers</folder>
        <folder>models</folder>
        <folder>assets</folder>
        <folder>views</folder>
        <folder>language</folder>
        <folder>tables</folder>
        <filename>tools_calendar_events.php</filename>
    </files>
</extension>

I created an updates folder in administrator/components/com.../install/updates, but in the <update> tag, I only specified the path as "install/updates".

โค้ด: เลือกทั้งหมด

<update>
    <schemas>
        <schemapath type="mysql">install/updates/</schemapath>
    </schemas>
</update>

How does it locate that directory, and how does it work?
And why doesn't it work when I add it inside the <administration> tag?

โดย **MindPHP Assistant** » 15/11/2024 9:15 am

In Joomla extensions, the structure of the XML manifest file is crucial for defining how the extension should be installed, updated, or uninstalled. Let's break down your situation:

### Understanding the Directory Structure and Path Resolution

1. Path Resolution:
- In the `<update>` tag, the path specified in `<schemapath>` is relative to the root of the installation directory of the component. If you specify `install/updates/`, Joomla looks for this folder starting from the component's base directory. This is why you created the `updates` folder inside `administrator/components/com_tools_calendar_events/install/`.

2. Why It Works Outside `<administration>`:
- The `<install>`, `<uninstall>`, and `<update>` tags are not supposed to be inside the `<administration>` tag. These tags are meant to define actions applicable to the entire component, not just the administrator part.
- The structure of the XML manifest file requires these tags to be direct children of the `<extension>` element. When they are nested within `<administration>`, Joomla doesn't process them correctly because they aren't in the expected place.

3. Functionality of Tags:
- `<install>`: This tag defines SQL files or scripts that should be executed when the component is installed.
- `<uninstall>`: This tag defines SQL files or scripts that should be executed when the component is uninstalled.
- `<update>`: This tag specifies how updates are managed, including schema updates.

### Why Moving the Tags Works

By moving `<install>`, `<uninstall>`, and `<update>` outside of the `<administration>` tag, you align with the expected structure Joomla expects, allowing it to correctly process installation, uninstallation, and updates.

### Best Practices

- Keep Structure Clean: Always ensure that tags are placed where they are expected in the XML structure.
- Use Correct Paths: Make sure paths in your XML (like `install/updates/`) match the actual filesystem structure relative to the component's base directory.
- Testing: After making changes to the manifest or directory structures, test the installation, update, and uninstallation processes to ensure everything works as expected.

By adhering to these guidelines, you ensure that Joomla can manage your component effectively.

โดย **Raja Pdl** » 15/11/2024 9:15 am

Raja Pdl เขียน: ↑15/11/2024 8:56 am My <install>, <uninstall>, and <update> tags were inside <administration>. I moved them outside of the <administration> tag, and it works now

โค้ด: เลือกทั้งหมด

<extension type="component" version="5.0" method="upgrade">
    <name>com_tools_calendar_events</name>
    <version>1.5.43</version>
    <scriptfile>install.php</scriptfile>
    
            <install>
            <sql>
                <file charset="utf8" driver="mysql">install/tools_calendar_events.sql</file>
            </sql>
        </install>
        <uninstall>
                <sql>
                    <file charset="utf8" driver="mysql">install/unistall.sql</file>
                    <file driver="mysql">install/unistall.sql</file>
                </sql>
        </uninstall>
        <update>
                <schemas>
                        <schemapath type="mysql">install/updates/</schemapath>
                </schemas>
        </update>

    <administration>
        <files folder="administrator/components/com_tools_calendar_events">
            <folder>controllers</folder>
            <folder>models</folder>
            <folder>assets</folder>
            <folder>views</folder>
            <folder>language</folder>
            <folder>tables</folder>
            <folder>install</folder>
            <filename>tools_calendar_events.php</filename>
        </files>
        <menu>com_calendar_events</menu>
        <submenu>
            <menu link="option=com_tools_calendar_events&amp;view=events">com_calendar_events_events</menu>
            <menu link="option=com_tools_calendar_events&amp;view=eventtypes">com_calendar_events_eventtypes</menu>
        </submenu>
    </administration>

    <files folder="components/com_tools_calendar_events">
        <folder>controllers</folder>
        <folder>models</folder>
        <folder>assets</folder>
        <folder>views</folder>
        <folder>language</folder>
        <folder>tables</folder>
        <filename>tools_calendar_events.php</filename>
    </files>
</extension>

I created an updates folder in administrator/components/com.../install/updates, but in the <update> tag, I only specified the path as "install/updates".

โค้ด: เลือกทั้งหมด

<update>
    <schemas>
        <schemapath type="mysql">install/updates/</schemapath>
    </schemas>
</update>

How does it locate that directory, and how does it work?
And why doesn't it work when I add it inside the <administration> tag?

โดย **MindPHP Assistant** » 15/11/2024 9:08 am

In Joomla extensions, the XML manifest file is used to define the structure and installation process of the extension. The structure of this file must adhere to specific conventions to ensure that Joomla can correctly interpret and process it.

### Location of Directories

1. Finding the `install/updates` Directory:
- When you specify `<schemapath type="mysql">install/updates/</schemapath>`, Joomla interprets this path relative to the root of your component's directory. This is because Joomla assumes paths in the manifest file are relative to the component’s directory unless otherwise specified.

2. Differences Between Tags:
- The `<install>`, `<uninstall>`, and `<update>` tags are used to define SQL scripts and schema updates and are typically placed outside the `<administration>` tag to apply to the entire component, not just the administrator side.
- These tags define actions that need to be executed globally during installation, uninstallation, or upgrading processes, affecting both the site and administrator parts of the component.

### Why it Doesn’t Work Inside `<administration>`

- Scope of Tags:
- The `<administration>` tag is specifically for defining files and other resources that are part of the administrator side of the component. Placing `<install>`, `<uninstall>`, and `<update>` inside `<administration>` can cause Joomla to misinterpret the scope, as these operations are not meant to be confined to the administrator section alone.

- Joomla's Parsing Logic:
- Joomla expects the `<install>`, `<uninstall>`, and `<update>` tags to be directly under the `<extension>` element. This expectation is based on the standard parsing logic of the Joomla installer, which looks for these tags at the root level to properly execute installation scripts, database changes, or schema updates.

### Best Practices

- Always place `<install>`, `<uninstall>`, and `<update>` tags directly inside the `<extension>` element, outside the `<administration>` or any other section tags.
- Ensure paths in these tags are relative to the component’s main directory unless explicitly defined otherwise.
- Follow Joomla’s XML schema conventions to ensure compatibility with Joomla’s installer and updater.

By doing so, you ensure that Joomla can reliably access the necessary resources and execute the required scripts across all areas of your component.

โดย **Raja Pdl** » 15/11/2024 9:08 am

Raja Pdl เขียน: ↑15/11/2024 8:56 am My <install>, <uninstall>, and <update> tags were inside <administration>. I moved them outside of the <administration> tag, and it works now

โค้ด: เลือกทั้งหมด

<extension type="component" version="5.0" method="upgrade">
    <name>com_tools_calendar_events</name>
    <version>1.5.43</version>
    <scriptfile>install.php</scriptfile>
    
            <install>
            <sql>
                <file charset="utf8" driver="mysql">install/tools_calendar_events.sql</file>
            </sql>
        </install>
        <uninstall>
                <sql>
                    <file charset="utf8" driver="mysql">install/unistall.sql</file>
                    <file driver="mysql">install/unistall.sql</file>
                </sql>
        </uninstall>
        <update>
                <schemas>
                        <schemapath type="mysql">install/updates/</schemapath>
                </schemas>
        </update>

    <administration>
        <files folder="administrator/components/com_tools_calendar_events">
            <folder>controllers</folder>
            <folder>models</folder>
            <folder>assets</folder>
            <folder>views</folder>
            <folder>language</folder>
            <folder>tables</folder>
            <folder>install</folder>
            <filename>tools_calendar_events.php</filename>
        </files>
        <menu>com_calendar_events</menu>
        <submenu>
            <menu link="option=com_tools_calendar_events&amp;view=events">com_calendar_events_events</menu>
            <menu link="option=com_tools_calendar_events&amp;view=eventtypes">com_calendar_events_eventtypes</menu>
        </submenu>
    </administration>

    <files folder="components/com_tools_calendar_events">
        <folder>controllers</folder>
        <folder>models</folder>
        <folder>assets</folder>
        <folder>views</folder>
        <folder>language</folder>
        <folder>tables</folder>
        <filename>tools_calendar_events.php</filename>
    </files>
</extension>

I created an updates folder in administrator/components/com.../install/updates, but in the <update> tag, I only specified the path as "install/updates".

โค้ด: เลือกทั้งหมด

<update>
       <schemas>
               <schemapath type="mysql">install/updates/</schemapath>
      </schemas>
</update>

How does it locate that directory, and how does it work?
And why doesn't it work when I add it inside the <administration> tag?

โดย **Raja Pdl** » 15/11/2024 8:56 am

My <install>, <uninstall>, and <update> tags were inside <administration>. I moved them outside of the <administration> tag, and it works now

โค้ด: เลือกทั้งหมด

<extension type="component" version="5.0" method="upgrade">
    <name>com_tools_calendar_events</name>
    <version>1.5.43</version>
    <scriptfile>install.php</scriptfile>
    
            <install>
            <sql>
                <file charset="utf8" driver="mysql">install/tools_calendar_events.sql</file>
            </sql>
        </install>
        <uninstall>
                <sql>
                    <file charset="utf8" driver="mysql">install/unistall.sql</file>
                    <file driver="mysql">install/unistall.sql</file>
                </sql>
        </uninstall>
        <update>
                <schemas>
                        <schemapath type="mysql">install/updates/</schemapath>
                </schemas>
        </update>

    <administration>
        <files folder="administrator/components/com_tools_calendar_events">
            <folder>controllers</folder>
            <folder>models</folder>
            <folder>assets</folder>
            <folder>views</folder>
            <folder>language</folder>
            <folder>tables</folder>
            <folder>install</folder>
            <filename>tools_calendar_events.php</filename>
        </files>
        <menu>com_calendar_events</menu>
        <submenu>
            <menu link="option=com_tools_calendar_events&amp;view=events">com_calendar_events_events</menu>
            <menu link="option=com_tools_calendar_events&amp;view=eventtypes">com_calendar_events_eventtypes</menu>
        </submenu>
    </administration>

    <files folder="components/com_tools_calendar_events">
        <folder>controllers</folder>
        <folder>models</folder>
        <folder>assets</folder>
        <folder>views</folder>
        <folder>language</folder>
        <folder>tables</folder>
        <filename>tools_calendar_events.php</filename>
    </files>
</extension>

In summary, to update the component and sql files,

(1) change method from "install" to "upgrade" in <extension> tag

โค้ด: เลือกทั้งหมด

<extension type="component" version="5.0" method="upgrade">

(2) Create an <update> section in the extension's manifest XML file: (outside of <admininstration> tag)

โค้ด: เลือกทั้งหมด

        <update>
                <schemas>
                        <schemapath type="mysql">install/updates/</schemapath>
                </schemas>
        </update>

(3) Create an "updates" folder under the "install" folder.

(4) Create an SQL file that matches the version name defined in the XML file and add the SQL code.

Thank you very much

โดย **eange08** » 14/11/2024 4:34 pm

If the database table is not updating despite the new SQL file, it’s likely because Joomla’s update schema mechanism might not be detecting or executing the SQL file correctly. Here are some steps to troubleshoot and ensure the SQL update file is executed:

1. **Check the SQL Filename and Versioning**:
Ensure that the SQL file in the `updates` folder matches the component’s version. Since your component version is `1.5.43`, the SQL file should be named `1.5.43.sql` and be placed in the `install/updates/` directory.

2. **Verify the Schema Update Entry**:
Confirm that Joomla has recorded the previous update version in the `#__schemas` table. This table keeps track of which version of each component has been applied. If the recorded version is higher than `1.5.43`, Joomla won’t apply the new update.
- You can manually change the version in `#__schemas` to a version lower than `1.5.43` to trigger the update.
- Alternatively, you can delete the entry for your component in `#__schemas` and try re-running the update. Joomla should re-run any schema updates not marked in the database.

3. **Check the SQL File Path and Encoding**:
Ensure the path specified in `<schemapath type="mysql">install/updates/</schemapath>` is correct and matches the actual location of the `1.5.43.sql` file.
- Confirm the encoding of the SQL file is set to `utf8` as specified.
- Sometimes, minor formatting issues in the SQL file (such as encoding or line endings) can prevent it from running, so double-check the formatting.

4. **Enable Debug Mode**:
Turn on Joomla’s debugging in the global configuration settings. This will log database errors if there’s an issue with the SQL syntax or if Joomla encounters a problem executing the file.

5. **Run the Update Script Manually**:
If the issue persists, try manually running the SQL commands in the database to confirm they work as expected. If they do, the issue is likely with Joomla's schema tracking rather than the SQL statements themselves.

After making these checks, try running the update again. Let me know if you encounter further issues after these steps.

โดย **Raja Pdl** » 14/11/2024 3:43 pm

It updates the component with new version but database table is not updating with latest sql file.

โค้ด: เลือกทั้งหมด

<extension type="component" version="5.0" method="upgrade">
    <name>com_tools_calendar_events</name>
    <version>1.5.43</version>
    <scriptfile>install.php</scriptfile>

    <administration>
        <files folder="administrator/components/com_tools_calendar_events">
            <folder>controllers</folder>
            <folder>models</folder>
            <folder>assets</folder>
            <folder>views</folder>
            <folder>language</folder>
            <folder>tables</folder>
            <folder>install</folder>
            <filename>tools_calendar_events.php</filename>
        </files>
        <install>
            <sql>
                <file charset="utf8" driver="mysql">install/tools_calendar_events.sql</file>
            </sql>
        </install>
        <uninstall>
                <sql>
                    <file charset="utf8" driver="mysql">install/unistall.sql</file>
                    <file driver="mysql">install/unistall.sql</file>
                </sql>
        </uninstall>
        <update>
                <schemas>
                        <schemapath type="mysql">install/updates/</schemapath>
                </schemas>
        </update>
        <menu>com_calendar_events</menu>
        <submenu>
            <menu link="option=com_tools_calendar_events&amp;view=events">com_calendar_events_events</menu>
            <menu link="option=com_tools_calendar_events&amp;view=eventtypes">com_calendar_events_eventtypes</menu>
        </submenu>
    </administration>

    <files folder="components/com_tools_calendar_events">
        <folder>controllers</folder>
        <folder>models</folder>
        <folder>assets</folder>
        <folder>views</folder>
        <folder>language</folder>
        <folder>tables</folder>
        <filename>tools_calendar_events.php</filename>
    </files>
</extension>

I created "updates" folder under "install" folder and created 1.5.43.sql file
but it is not updating in database.
How can I fix it ?

เว็บบอร์ด PHP เว็บส่งเสริมการเรียนรู้ Hosting CRM ERP Server Programming ถาม-ตอบปัญหา

Q - How to create update sql file and how to connect that sql file when updating component in Joomla 5 ?

ตอบกระทู้

มุมมองที่ขยายได้ กระทู้แนะนำ: Q - How to create update sql file and how to connect that sql file when updating component in Joomla 5 ?

Re: Q - How to create update sql file and how to connect that sql file when updating component in Joomla 5 ?

Re: Q - How to create update sql file and how to connect that sql file when updating component in Joomla 5 ?

Re: Q - How to create update sql file and how to connect that sql file when updating component in Joomla 5 ?

Re: Q - How to create update sql file and how to connect that sql file when updating component in Joomla 5 ?

Re: Q - How to create update sql file and how to connect that sql file when updating component in Joomla 5 ?

Re: Q - How to create update sql file and how to connect that sql file when updating component in Joomla 5 ?

Re: Q - How to create update sql file and how to connect that sql file when updating component in Joomla 5 ?

Re: Q - How to create update sql file and how to connect that sql file when updating component in Joomla 5 ?

Re: Q - How to create update sql file and how to connect that sql file when updating component in Joomla 5 ?

Re: Q - How to create update sql file and how to connect that sql file when updating component in Joomla 5 ?