Author Topic: Error! 1075 upgrade 1.1.21 to 2.0.17  (Read 401 times)

Offline aswuser

  • Semi-Newbie
  • *
  • Posts: 21
Error! 1075 upgrade 1.1.21 to 2.0.17
« on: June 10, 2021, 02:35:29 PM »
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

The 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.
« Last Edit: June 10, 2021, 02:46:10 PM by aswuser »

Offline shawnb61

  • Developer
  • SMF Hero
  • *
  • Posts: 3,326
    • sbulen on GitHub
Re: Error! 1075 upgrade 1.1.21 to 2.0.17
« Reply #1 on: June 11, 2021, 12:51:05 AM »
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

Offline Doug Heffernan

  • Full Member
  • ***
  • Posts: 655
    • An Unofficial King of Queens Forum
Re: Error! 1075 upgrade 1.1.21 to 2.0.17
« Reply #2 on: June 13, 2021, 06:43:39 AM »
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.

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Project Manager
  • SMF Super Hero
  • *
  • Posts: 20,366
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • Aleksi Kilpinen
Re: Error! 1075 upgrade 1.1.21 to 2.0.17
« Reply #3 on: June 13, 2021, 07:11:45 AM »
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 an 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