# Error when trying to update plugins

**URL:** <https://forum.seatable.com/t/error-when-trying-to-update-plugins/1447>\
**Category:** Upgrade\
**Created:** [July 5, 2022, 10:00pm UTC](https://forum.seatable.com/t/error-when-trying-to-update-plugins/1447 "2022-07-05T22:00:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![typhon](https://forum.seatable.com/user_avatar/forum.seatable.com/typhon/32/1814_2.png) [@typhon](https://forum.seatable.com/u/typhon)\
**Post date:** [July 5, 2022, 10:00pm UTC](https://forum.seatable.com/t/error-when-trying-to-update-plugins/1447/1 "2022-07-05T22:00:00Z")

</div>

I recently upgraded to Seatable 3.0.16 EE, doing all the necessary extra steps in the documentation. However, today i went to update my plugins and this is what appeared:

 ![image](https://forum.seatable.io/uploads/default/original/2X/e/e16fc827341b10a71a13a8436b211ec5cea08c97.png)  
When clicking on the button to upgrade, an error notification pops up.  
Another error pops in External Apps (though i don’t use it):  
 ![image](https://forum.seatable.io/uploads/default/original/2X/b/b9770ccfa7d2b0b69657e7908776bf48dafca4b5.png)

I couldn’t find out what’s causing it from the logs, but perhaps you may be able to help me to fix this issue, here they are [https://pastebin.com/2GfYBTAk](https://pastebin.com/2GfYBTAk)

Thanks!

---

<div class="post-metadata">

**Author:** ![cdb](https://forum.seatable.com/user_avatar/forum.seatable.com/cdb/32/7_2.png) [@cdb](https://forum.seatable.com/u/cdb)\
**Post date:** [July 16, 2022, 11:05pm UTC](https://forum.seatable.com/t/error-when-trying-to-update-plugins/1447/2 "2022-07-16T23:05:10Z")

</div>

Hey typhon,  
I checked your logs you send via pastbin. The only clear error message I would detect was the following:

`MySQLdb._exceptions.OperationalError: (1054, "Unknown column 'dtable_external_apps.visit_times' in 'field list'")`

If you have SQL errors like missing columns in the database then usually the update scripts were not executed. Did you probably forgot to execute the database update like described here?  
[https://manual.seatable.io/upgrade/upgrade\_manual/](https://manual.seatable.io/upgrade/upgrade_manual/)

Here is how the SQL-table in dtable-db should look like with version 3.0.16

```auto
mysql> describe dtable_external_apps;
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| token | varchar(36) | NO | UNI | NULL | |
| dtable_uuid | varchar(36) | NO | MUL | NULL | |
| app_type | varchar(255) | NO | | NULL | |
| app_config | longtext | YES | | NULL | |
| created_at | datetime(6) | YES | MUL | NULL | |
| visit_times | int(11) | NO | | 0 | |
| creator | varchar(255) | YES | | NULL | |
+-------------+--------------+------+-----+---------+----------------+

```

Best regards  
Christoph

---

<div class="post-metadata">

**Author:** ![typhon](https://forum.seatable.com/user_avatar/forum.seatable.com/typhon/32/1814_2.png) [@typhon](https://forum.seatable.com/u/typhon)\
**Post date:** [July 18, 2022, 10:19am UTC](https://forum.seatable.com/t/error-when-trying-to-update-plugins/1447/3 "2022-07-18T10:19:31Z")

</div>

Hey, thanks for the help!

I was pretty sure i did the migration, but after running that describe command it seems that in fact the migration did not occur. However, as i tried running the commends again, i would either get no output (and no migration or some errors).

Is there any way to check the version of the current database?

Edit:  
I actually managed to successfully migrate and the output of the describe command is now looking like you said it should:  
 ![image](https://forum.seatable.io/uploads/default/original/2X/c/cf3c695548b4876f6f87b758bbd5c139e1a2b632.png)  
However, i still get the same issue with the plugins and external apps.

Edit2:  
After looking at logs again after upgrading the database, i saw something about the plugin repo and checked the dtable\_web\_settings.py . Apparently i had second PLUGINS\_REPO\_ID varible with a different value that was messing things up - i deleted the new one which must have gotten there during this last 3.0 update when i added things to that config and plugins are working perfectly now.

So to summarize:

- Upgrading the database properly fixed the external apps issue
- A second PLUGINS\_REPO\_ID with a wrong value was causing the plugins to not be updatable

Again, thanks for the help with the database and help me unravel this particular mystery!

---

<div class="post-metadata">

**Author:** ![system](https://forum.seatable.com/uploads/default/original/1X/04603423fe81a46c321283663086c475429e8ccb.png) [@system](https://forum.seatable.com/u/system)\
**Post date:** [July 20, 2022, 10:20am UTC](https://forum.seatable.com/t/error-when-trying-to-update-plugins/1447/4 "2022-07-20T10:20:17Z")

</div>

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.