Problem Instalasi Module PUQ Proxmox

[answerwar]

Issue Description

I performed the installation of Puqcloud using PUQcloud-Scripts, and the installation finished successfully without any issues on a Debian 12 server.

However, after installation and initial testing, I noticed that the PUQ Proxmox module was in a Non Installed state. Therefore, I tried to install it manually, but encountered the following problems:

Problem 1

I received the following error during installation:

Error activating plugin: SQLSTATE[42000]: Syntax error or access violation: 1166 Incorrect column name 'ha-managed '
(Connection: mysql, SQL: create table puq_pm_lxc_presets (... ha-managed tinyint(1) not null default '0', ...))

I investigated the issue and found that the column name contains a trailing space: ha-managed .

I solved this by modifying the file:

root@puqcloud:/var/www/puqcloud# grep -r 'ha-managed ' ./
./modules/Product/puqProxmox/puqProxmox.php: $table->boolean('ha-managed ')->default(false);

I changed it to:

$table->boolean('ha-managed')->default(false);

After fixing that, I tried installing the module again and encountered the second problem.

Problem 2
Error activating plugin: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'deploy_progress'

This happened because there are two conflicting column definitions under the same table:

$table->integer('deploy_progress')->nullable();
$table->dateTime('deploy_progress')->nullable();

I solved this by disabling one of the fields so that only one deploy_progress column is created.

File reference:

root@puqcloud:/var/www/puqcloud# grep -r 'deploy_progress' ./
./modules/Product/puqProxmox/puqProxmox.php: $table->integer('deploy_progress')->nullable();
./modules/Product/puqProxmox/puqProxmox.php: $table->dateTime('deploy_progress')->nullable();

After applying this fix, the installation completed successfully and displayed:

Success Activated successfully

Final Result & Issue

Although the module was successfully activated, the PUQ Proxmox menu does not appear in the navbar, and I could not find any error logs related to this issue.

Thank you.

[puqcloud]

Good day,

Thank you for your comments and for your help in finding and identifying bugs.
Yes, these issues did exist, and we will fix them.

Regarding the module not being displayed: please go to the group settings and find the group that contains permissions for this module. Then grant your user the required permissions to manage this module. Each module has its own set of permissions that define which actions a user is allowed to perform.

If you have any additional questions, please feel free to contact us.

Kind regards,
Ruslan Polovyi
PUQcloud