/var/www/dev# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1193391
Server version: 5.7.30-33-log Percona Server (GPL), Release '33', Revision '6517692'
Copyright (c) 2009-2020 Percona LLC and/or its affiliates
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use dev;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> describe xf_resource;
+------------------------+---------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+---------------------------------------+------+-----+---------+----------------+
| resource_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| title | varchar(100) | NO | | | |
| tag_line | varchar(100) | NO | | | |
| user_id | int(10) unsigned | NO | MUL | NULL | |
| username | varchar(100) | NO | | | |
| resource_state | enum('visible','moderated','deleted') | NO | | visible | |
| resource_date | int(10) unsigned | NO | | NULL | |
| resource_category_id | int(11) | NO | MUL | NULL | |
| current_version_id | int(10) unsigned | NO | | NULL | |
| description_update_id | int(10) unsigned | NO | | NULL | |
| discussion_thread_id | int(10) unsigned | NO | MUL | NULL | |
| external_url | varchar(500) | NO | | | |
| is_fileless | tinyint(3) unsigned | NO | | 0 | |
| external_purchase_url | varchar(500) | NO | | | |
| price | decimal(10,2) unsigned | NO | | 0.00 | |
| currency | varchar(3) | NO | | | |
| download_count | int(10) unsigned | NO | | 0 | |
| rating_count | int(10) unsigned | NO | | 0 | |
| rating_sum | int(10) unsigned | NO | | 0 | |
| rating_avg | float unsigned | NO | | 0 | |
| rating_weighted | float unsigned | NO | MUL | 0 | |
| update_count | int(10) unsigned | NO | | 0 | |
| review_count | int(10) unsigned | NO | | 0 | |
| last_update | int(10) unsigned | NO | MUL | NULL | |
| alt_support_url | varchar(500) | NO | | | |
| had_first_visible | tinyint(3) unsigned | NO | | 0 | |
| custom_resource_fields | mediumblob | NO | | NULL | |
| prefix_id | int(10) unsigned | NO | MUL | 0 | |
| icon_date | int(10) unsigned | NO | | 0 | |
| tags | mediumblob | NO | | NULL | |
+------------------------+---------------------------------------+------+-----+---------+----------------+
30 rows in set (0.00 sec)
mysql> describe xf_resource_update;
+--------------------+---------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+---------------------------------------+------+-----+---------+----------------+
| resource_update_id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| resource_id | int(11) | NO | MUL | NULL | |
| title | varchar(100) | NO | | | |
| message | mediumtext | NO | | NULL | |
| message_state | enum('visible','moderated','deleted') | NO | | visible | |
| post_date | int(10) unsigned | NO | | NULL | |
| attach_count | int(10) unsigned | NO | | 0 | |
| likes | int(10) unsigned | NO | | 0 | |
| like_users | blob | NO | | NULL | |
| ip_id | int(10) unsigned | NO | | 0 | |
| had_first_visible | tinyint(3) unsigned | NO | | 0 | |
| warning_id | int(10) unsigned | NO | | 0 | |
| warning_message | varchar(255) | NO | | | |
+--------------------+---------------------------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)
mysql> exit
Bye
@server:/var/www/dev# rm -rf /tmp/1/*
@server:/var/www/dev# unzip /tmp/xf/xfresource_2.2.0-Beta-3-Unsupported_<redacted>_full.zip -d /tmp/1/
[...]
@server:/var/www/dev# cp -pr /tmp/1/upload/* ./
@server:/var/www/dev# php cmd.php xf:addon-upgrade XFRM
Upgrading XenForo Resource Manager from 1.2.5 to 2.2.0 Beta 3...
Confirm upgrade? (y/n)y
Upgrading . .
In AbstractStatement.php line 228:
[XF\Db\Exception (1054)]
MySQL statement prepare error [1054]: Unknown column 'is_fileless' in 'fiel
d list'
Exception trace:
at src/XF/Db/AbstractStatement.php:228
XF\Db\AbstractStatement->getException() at src/XF/Db/Mysqli/Statement.php:196
XF\Db\Mysqli\Statement->getException() at src/XF/Db/Mysqli/Statement.php:39
XF\Db\Mysqli\Statement->prepare() at src/XF/Db/Mysqli/Statement.php:54
XF\Db\Mysqli\Statement->execute() at src/XF/Db/AbstractAdapter.php:94
XF\Db\AbstractAdapter->query() at src/XF/Install/InstallHelperTrait.php:229
XF\AddOn\AbstractSetup->executeUpgradeQuery() at src/XF/AddOn/AbstractSetup.php:90
XF\AddOn\AbstractSetup->query() at src/addons/XFRM/Setup.php:365
XFRM\Setup->upgrade2000010Step3() at src/XF/AddOn/StepRunnerUpgradeTrait.php:122
XFRM\Setup->upgradeStepRunner() at src/XF/AddOn/StepRunnerUpgradeTrait.php:71
XFRM\Setup->upgrade() at src/XF/Cli/Command/AddOnActionTrait.php:109
XF\Cli\Command\AddOnSubAction->performAddOnAction() at src/XF/Cli/Command/AddOnSubAction.php:79
XF\Cli\Command\AddOnSubAction->execute() at src/vendor/symfony/console/Command/Command.php:255
Symfony\Component\Console\Command\Command->run() at src/vendor/symfony/console/Application.php:987
Symfony\Component\Console\Application->doRunCommand() at src/vendor/symfony/console/Application.php:255
Symfony\Component\Console\Application->doRun() at src/vendor/symfony/console/Application.php:148
Symfony\Component\Console\Application->run() at src/XF/Cli/Runner.php:76
XF\Cli\Runner->run() at cmd.php:15
xf:addon-sub-action [--k K] [--] <id> <action>
/var/www/dev# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1193391
Server version: 5.7.30-33-log Percona Server (GPL), Release '33', Revision '6517692'
Copyright (c) 2009-2020 Percona LLC and/or its affiliates
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use dev;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> describe xf_rm_resource;
+-----------------------+---------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+---------------------------------------+------+-----+---------+----------------+
| resource_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| title | varchar(100) | NO | | | |
| tag_line | varchar(100) | NO | | | |
| user_id | int(10) unsigned | NO | MUL | NULL | |
| username | varchar(100) | NO | | | |
| resource_state | enum('visible','moderated','deleted') | NO | | visible | |
| resource_date | int(10) unsigned | NO | | NULL | |
| resource_category_id | int(10) unsigned | NO | MUL | NULL | |
| current_version_id | int(10) unsigned | NO | | NULL | |
| description_update_id | int(10) unsigned | NO | | NULL | |
| discussion_thread_id | int(10) unsigned | NO | MUL | NULL | |
| external_url | varchar(500) | NO | | | |
| external_purchase_url | varchar(500) | NO | | | |
| price | decimal(10,2) unsigned | NO | | 0.00 | |
| currency | varchar(3) | NO | | | |
| download_count | int(10) unsigned | NO | | 0 | |
| rating_count | int(10) unsigned | NO | | 0 | |
| rating_sum | int(10) unsigned | NO | | 0 | |
| rating_avg | float unsigned | NO | | 0 | |
| rating_weighted | float unsigned | NO | MUL | 0 | |
| update_count | int(10) unsigned | NO | | 0 | |
| review_count | int(10) unsigned | NO | | 0 | |
| last_update | int(10) unsigned | NO | MUL | NULL | |
| alt_support_url | varchar(500) | NO | | | |
| custom_fields | mediumblob | NO | | NULL | |
| prefix_id | int(10) unsigned | NO | MUL | 0 | |
| icon_date | int(10) unsigned | NO | | 0 | |
| tags | mediumblob | NO | | NULL | |
| resource_type | varchar(25) | NO | | NULL | |
| view_count | int(10) unsigned | NO | | 0 | |
+-----------------------+---------------------------------------+------+-----+---------+----------------+
30 rows in set (0.00 sec)
mysql> alter table `xf_rm_resource` add column `is_fileless` tinyint unsigned not null default 0;
Query OK, 0 rows affected (0.31 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> exit
Bye
@server:/var/www/dev# php cmd.php xf:addon-upgrade XFRM
Upgrading XenForo Resource Manager from 1.2.5 to 2.2.0 Beta 3...
Confirm upgrade? (y/n)y
Upgrading . . . . . . . . . . . .
In AbstractStatement.php line 228:
[XF\Db\Exception (1054)]
MySQL statement prepare error [1054]: Unknown column 'like_users' in 'where
clause'
Exception trace:
at src/XF/Db/AbstractStatement.php:228
XF\Db\AbstractStatement->getException() at src/XF/Db/Mysqli/Statement.php:196
XF\Db\Mysqli\Statement->getException() at src/XF/Db/Mysqli/Statement.php:39
XF\Db\Mysqli\Statement->prepare() at src/XF/Db/Mysqli/Statement.php:54
XF\Db\Mysqli\Statement->execute() at src/XF/Db/AbstractAdapter.php:94
XF\Db\AbstractAdapter->query() at src/XF/Db/AbstractAdapter.php:322
XF\Db\AbstractAdapter->update() at src/XF/Install/InstallHelperTrait.php:85
XF\AddOn\AbstractSetup->tableColumnsToJson() at src/XF/Install/InstallHelperTrait.php:43
XF\AddOn\AbstractSetup->entityColumnsToJson() at src/addons/XFRM/Setup.php:729
XFRM\Setup->upgrade2010010Step3() at src/XF/AddOn/StepRunnerUpgradeTrait.php:122
XFRM\Setup->upgradeStepRunner() at src/XF/AddOn/StepRunnerUpgradeTrait.php:71
XFRM\Setup->upgrade() at src/XF/Cli/Command/AddOnActionTrait.php:109
XF\Cli\Command\AddOnSubAction->performAddOnAction() at src/XF/Cli/Command/AddOnSubAction.php:79
XF\Cli\Command\AddOnSubAction->execute() at src/vendor/symfony/console/Command/Command.php:255
Symfony\Component\Console\Command\Command->run() at src/vendor/symfony/console/Application.php:987
Symfony\Component\Console\Application->doRunCommand() at src/vendor/symfony/console/Application.php:255
Symfony\Component\Console\Application->doRun() at src/vendor/symfony/console/Application.php:148
Symfony\Component\Console\Application->run() at src/XF/Cli/Runner.php:76
XF\Cli\Runner->run() at cmd.php:15
xf:addon-sub-action [--k K] [--] <id> <action>
@server:/var/www/dev# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1193546
Server version: 5.7.30-33-log Percona Server (GPL), Release '33', Revision '6517692'
Copyright (c) 2009-2020 Percona LLC and/or its affiliates
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use dev;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> describe xf_resource_update;
+--------------------+---------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+---------------------------------------+------+-----+---------+----------------+
| resource_update_id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| resource_id | int(11) | NO | MUL | NULL | |
| title | varchar(100) | NO | | | |
| message | mediumtext | NO | | NULL | |
| message_state | enum('visible','moderated','deleted') | NO | | visible | |
| post_date | int(10) unsigned | NO | | NULL | |
| attach_count | int(10) unsigned | NO | | 0 | |
| likes | int(10) unsigned | NO | | 0 | |
| like_users | blob | NO | | NULL | |
| ip_id | int(10) unsigned | NO | | 0 | |
| had_first_visible | tinyint(3) unsigned | NO | | 0 | |
| warning_id | int(10) unsigned | NO | | 0 | |
| warning_message | varchar(255) | NO | | | |
+--------------------+---------------------------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)
mysql> describe xf_rm_resource_update;
+--------------------+---------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+---------------------------------------+------+-----+---------+----------------+
| resource_update_id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| resource_id | int(10) unsigned | NO | MUL | NULL | |
| title | varchar(100) | NO | | | |
| message | mediumtext | NO | | NULL | |
| message_state | enum('visible','moderated','deleted') | NO | | visible | |
| post_date | int(10) unsigned | NO | | NULL | |
| attach_count | int(10) unsigned | NO | | 0 | |
| reaction_score | int(11) | NO | | 0 | |
| reactions | blob | YES | | NULL | |
| reaction_users | blob | NO | | NULL | |
| ip_id | int(10) unsigned | NO | | 0 | |
| warning_id | int(10) unsigned | NO | | 0 | |
| warning_message | varchar(255) | NO | | | |
| embed_metadata | blob | YES | | NULL | |
+--------------------+---------------------------------------+------+-----+---------+----------------+
14 rows in set (0.00 sec)
mysql> exit
Bye
Thanks.
. Sorry.
![^[GS]^](/community/data/avatars/s/74/74606.jpg?1701363404){kind=avatar}
