Hi I did a move to a new host and the db import seems to have been missing some ALTER TABLE statements.
Now it has been a day and I do not want to go back to an older backup if possible so I thought about doing the SQL Alter Table part from an older backup in PHPMyadmin SQL area but on many items I get errors like #1068 – Multiple primary key defined
Is there any way to do it?
you can always adjust the keys from within phpmyadmin or other db tool…
but not much info here to provide more… what keys are missing? what keys are duplicate?
you can look in our db schema file to see what we set up…. simple-press/sp-startup/install/sp-schema.php
Careful now – that file is just for the changes that were consolidated in version 5.5.1 upgrade so I ma not sure what it may or may not tell you.
As Steve said – the bottom line is that you haven’t really given us enough information to know what has happened yet alone what may or may not need fixing…
So can you provide some detail?
Seems it was a MYSQL server problem. Tried a different server and there the import worked fine so I am good now.