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
_______________________________________________
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
