La Jobe Posted July 21, 2021 Posted July 21, 2021 Hello, We are currently updating our forum. We are doing this upgrade manually, but the error "Duplicate column name 'status_author_id' " occurred during the process. Does anyone know what this is due to? If so, what should we do to fix it? Thank you in advance for your reply
Afrodude Posted July 21, 2021 Posted July 21, 2021 @La Jobe if you still have access to ACP, I prefer to disable all plugin and application by third-party and try again. If the issue occur again, then you should submit a ticket to IPS staff.
Adlago Posted July 21, 2021 Posted July 21, 2021 (edited) 31 minutes ago, La Jobe said: Hello, We are currently updating our forum. We are doing this upgrade manually, but the error "Duplicate column name 'status_author_id' " occurred during the process. Does anyone know what this is due to? If so, what should we do to fix it? Thank you in advance for your reply Open PHPMy Admin - find in your database table "members_status_updates" Find these two columns with this name - status_author_id, and delete one column Continue with the upgrade Edited July 21, 2021 by Adlago
La Jobe Posted July 21, 2021 Author Posted July 21, 2021 33 minutes ago, Afrodude said: @La Jobe if you still have access to ACP, I prefer to disable all plugin and application by third-party and try again. If the issue occur again, then you should submit a ticket to IPS staff. I disable all third party plugins and the problem is still there. I have already contacted the IPS staff for more information. 28 minutes ago, Adlago said: Open PHPMy Admin - find in your database table "members_status_updates" Find these two columns with this name - status_author_id, and delete one column Continue with the upgrade Looking through all my databases, I could not find any "members_status_updates" table. Is this normal ?
Daniel F Posted July 21, 2021 Posted July 21, 2021 1 minute ago, La Jobe said: I could not find any "members_status_updates" table. Is this normal ? There's a core_member_status_updates database table in 4.x BTW, are you sure that you're upgrading from 3.4??? The step in your error indicates you're on IPB 3.2
Afrodude Posted July 21, 2021 Posted July 21, 2021 8 minutes ago, La Jobe said: I disable all third party plugins and the problem is still there. I have already contacted the IPS staff for more information. Looking through all my databases, I could not find any "members_status_updates" table. Is this normal ? Try to find "core_member_status_updates"
La Jobe Posted July 21, 2021 Author Posted July 21, 2021 3 minutes ago, Daniel F said: There's a core_member_status_updates database table in 4.x BTW, are you sure that you're upgrading from 3.4??? The step in your error indicates you're on IPB 3.2 Sorry, I got my applications mixed up. The forum version is 3.2 and not 3.4.
La Jobe Posted July 21, 2021 Author Posted July 21, 2021 16 minutes ago, Afrodude said: Try to find "core_member_status_updates" In my database, I have "core_" tables but no "core_member_status_updates" table
Adlago Posted July 21, 2021 Posted July 21, 2021 26 minutes ago, La Jobe said: In my database, I have "core_" tables but no "core_member_status_updates" table What tables do you have in which there is a word - status?
La Jobe Posted July 21, 2021 Author Posted July 21, 2021 I have a question, which may seem silly, but do we have to go through version 3.4.7 to upgrade to version 4?
Miss_B Posted July 21, 2021 Posted July 21, 2021 1 minute ago, La Jobe said: I have a question, which may seem silly, but do we have to go through version 3.4.7 to upgrade to version 4? You can upgrade directly to the latest version of the 4.6. series imo. Make sure to make a full backup of your database and forum files too prior to the upgrade though. And check the database backup to make sure that it is whole.
La Jobe Posted July 21, 2021 Author Posted July 21, 2021 18 minutes ago, Adlago said: What tables do you have in which there is a word - status? I found it, but I don't have any duplicate columns. I have "status_id" and "status_author_id". But, namely, I have several databases with the same structure. Is this where it comes from?
Adlago Posted July 21, 2021 Posted July 21, 2021 29 minutes ago, La Jobe said: I found it, but I don't have any duplicate columns. I have "status_id" and "status_author_id". But, namely, I have several databases with the same structure. Is this where it comes from? If you have several tables that have "status_author _id" probably some table is from the 3rd side app or plugin. If this is true, uninstall all 3rd side plugins
Recommended Posts