[TYPO3-english] upgrade error msg about realurl

[Jigal van Hemert]

Hi,

On 27/05/2016 15:06, mario chiari wrote:
> trying to upgrade form the Install wizard, i get
>
>
> Update failed!
> SQL-ERROR: Incorrect table definition; there can be only one auto column and it
> must be defined as a key
>
> Update database schema: Create tables and fields
> ALTER TABLE tx_realurl_pathcache ADD uid int(11) NOT NULL auto_increment;
>

Extensions or the core only define the new situation of the database 
structures. The Database update tool compares the current situation with 
the new definitions and builds the queries to make the necessary changes.
Sometimes this leads to the situation that queries can't be executed. In 
most cases the solution is to repeat the action to check the database. 
It's very likely that one of the other proposed queries removes the 
"auto_increment" from another field. Once that query is executed the 
query to add the "uid" field will succeed.

Advice: repeat the database compare action multiple times. As long as 
the number of proposed updates become smaller the action should be 
repeated. It's very likely that after a while all proposed database 
updates for realurl will be gone.


-- 
Jigal van Hemert
TYPO3 CMS Active Contributor

TYPO3 .... inspiring people to share!
Get involved: typo3.org