• Welcome to Simple Machines Community Forum. Please login or sign up.
October 16, 2021, 04:54:26 PM


SMF 2.0.18 has been released! Please update. Read more.

Error! 1075 upgrade 1.1.21 to 2.0.17

Started by aswuser, June 10, 2021, 02:35:29 PM

Previous topic - Next topic


June 10, 2021, 02:35:29 PM Last Edit: June 10, 2021, 02:46:10 PM by aswuser
I am trying to run upgrade  from 1.1.21 to 2.0.17. The upgrader started but stopped with error "Error! 1075".

I see from this post that

QuoteThe 1075 description is "ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key". I would suggest doing a db export - structure only - and scan for a table definition that violates that rule.


I have exported the db structure (attached). It looks like NONE of my tables has "PRIMARY KEY" defined. How do I fix that?

I am not really sure what I should be looking for here.


If you scroll down, you will see the PRIMARY KEYs defined.  Those are there.  But the indexes in general are incomplete, many are missing.  So you have a slight variation of that previous issue, where another 1.1 forum was missing most of its indexes somehow.

The upgrader is not going to work with the DB being so far off.


The first step is to repair your 1.1 forum - get its structure back to where it is supposed to be.  After that, we can re-attempt the upgrade.

The steps I would follow are:
1. BACKUP - Do one with data & structure - for recovery purposes if needed. We need to be able to put things back if needed.
2. BACKUP - Do one with data only - to see if we can rebuild.
3. Build an empty 1.1 DB - get the install_1-1.sql file from an old 1.1 build and execute it.
4. TRUNCATE all tables in your (not quite) empty 1.1 DB.
5. RESTORE using the backup made in step 2 above.  The DATA ONLY backup should really just be a bunch of inserts. 
6. Point your 1.1 forum to the new DB.  It should work.

This is a weird scenario, not something done every day.  But this is how I would approach it.

Hope this helps,
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Doug Heffernan

This has been taken care of. @aswuser contacted me and I was able to fix all the database errors and successgully upgrade their forum to the latest version, 2.0.18.

Aleksi "Lex" Kilpinen

Marking solved then, glad to hear it got resolved.
For the OP, feel free to mark the topic not solved again, if there is something you still need assistance with.
A Finnish Project Manager (Support Specialist)
 Happily running multiple SMF 2.x installations.
  Fooling around with i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64

How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas