Hi redealmeida,

I had trouble with some sites not finding the 8.0 update path. I followed the"Manual Dashboard Update" section on this page:
https://documentation.concrete5.org/developers/installation/upgradin...

8.1 should show up fine then.

Backup everything first. 5.7.5.13 to 8.0 is not as seamless as I had hoped.

HTH,
Sean

Hi redealmeida,

I had trouble with some sites not finding the 8.0 update path. I followed the"Manual Dashboard Update" section on this page:
https://documentation.concrete5.org/developers/installation/upgradin...

8.1 should show up fine then.

Backup everything first. 5.7.5.13 to 8.0 is not as seamless as I had hoped.

HTH,
Sean

Nope that didn't work.. Followed the instructions and about 10 seconds later it errored with...
Doctrine \ DBAL \ Exception \ DriverException
An exception occurred while executing 'ALTER TABLE pagetypes ADD siteTypeID INT UNSIGNED DEFAULT 0': SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

Tried restarting.. same thing
Any other ideas ??

Bob

This is over my head with regard to C5. However as a DBA I can tell you a lock timeout can only occur if there are 2 people (or threads) accessing the table at the same time. Are there other users on the site when you are upgrading?

Sean

Nope , it's only me on localhost and I restart xampp before I upgrade ..
Thanks.. any other ideas ??

Bob

Yes it should. And after you rename it to proper camelcase it should be working. I faced the same issue when moving from MAMP to webserver once but I have no clue how it happened.

Followed the manual upgrade to 5.8 here
https://documentation.concrete5.org/developers/installation/upgradin...
and got.. After 60 seconds
An exception occurred while executing 'ALTER TABLE NotificationAlerts ADD CONSTRAINT FK_E11C7408FD71026C FOREIGN KEY (uID) REFERENCES Users (uID)': SQLSTATE[HY000]: General error: 1822 Failed to add the foreign key constaint. Missing index for constraint 'FK_E11C7408FD71026C' in the referenced table 'users'
Does anyone have any ideas ??

Bob

You might need to change ALL of your table names to the standard case. I think there's a script for that somewhere—but check it's for the same c5 version you're running before trying it.

And back up first, of course!

This is a table name case sensitivity issue:

The constraint is referencing table "Users" (REFERENCES Users (uID)')
The error refers to table "users" (in the referenced table 'users')

"An exception occurred while executing 'ALTER TABLE NotificationAlerts ADD CONSTRAINT FK_E11C7408FD71026C FOREIGN KEY (uID) REFERENCES Users (uID)': SQLSTATE[HY000]: General error: 1822 Failed to add the foreign key constaint. Missing index for constraint 'FK_E11C7408FD71026C' in the referenced table 'users'"

Hi rdealmeida,
It looks like this DB came from WAMP or MAMP. That is when these table name case issues come into to play most frequently. The solution is not to hard.

try:
(backup db)
mysqldump --add-drop-table -u[username] -p[password] [dbname] > [path]/mydb_dump.sql

In the config file Stop the server, set lower_case_table_names to 1, and restart the server

(restore db with new config value)
mysql -u[username] -p[password] [dbname] < [path]/mydb_dump.sql

This tells MySQL to use lowercase for table and file names and recreates all the tables, converting the names to lowercase. Leave the config value set to 1 and you should be OK.

More info athttps://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity....

Sean