Table Names
Permalink
I have just migrated a site and, with the help of the Database Migration add on which converted most of the tables, and a couple of 'Table not Found' interrupts help me to get the site up and running on the remote server. I have five tables :
oauth2accesstoken
oauth2authcode
oauth2client
oauth2refreshtoken
oauth2scope
which don't seem to be causing a problem at the moment but look as if they need to be converted. I could do with a definitive version of the camel case names if they need them.
I switched from Microsoft to Linux Mint for development locally however installing a fresh version of 5.8.1, by downloading the zipped file, still gives me lower case table names. How do I get an install with the camel case names?
oauth2accesstoken
oauth2authcode
oauth2client
oauth2refreshtoken
oauth2scope
which don't seem to be causing a problem at the moment but look as if they need to be converted. I could do with a definitive version of the camel case names if they need them.
I switched from Microsoft to Linux Mint for development locally however installing a fresh version of 5.8.1, by downloading the zipped file, still gives me lower case table names. How do I get an install with the camel case names?
Hi thanks for this, I now have all the tables in the correct format and a script which will do the conversion for my tables.
As for using lower_case_table_names=2 - I already have this set to 2 in my.cnf, there is no my.ini under the mysql directory.
I tried fresh installs with both 0 and 2 again. Stopping and restarting the mysql server after each change but get lower case table names each time.
I am running with mysql 8.0.16 on linux mint 19.1
As for using lower_case_table_names=2 - I already have this set to 2 in my.cnf, there is no my.ini under the mysql directory.
I tried fresh installs with both 0 and 2 again. Stopping and restarting the mysql server after each change but get lower case table names each time.
I am running with mysql 8.0.16 on linux mint 19.1
Some info for you here.
https://mysql.wisborg.dk/2019/04/14/install-mysql-8-on-linux-with-lo...
https://mysql.wisborg.dk/2019/04/14/install-mysql-8-on-linux-with-lo...
Thanks,
So for MYSQL 8 you are left with the version of lower_case_table_names you installed it with unless you clear out all the databases and start again. I suppose it makes sense. It gives me something to play with in the dark winter nights.
So for MYSQL 8 you are left with the version of lower_case_table_names you installed it with unless you clear out all the databases and start again. I suppose it makes sense. It gives me something to play with in the dark winter nights.
Yes, That was my understanding too. I use WAMP for my dev box and I love it...
Did you install an Add-On for OAuth, if so, can you provide an URL for that? Then I can investigate why the Database Migration tool you use doesn't do its work :)
@ramonleenders, OAuth is built into the 8.5.1 core.
He doesn't need to install an addon for it.
He was originally using Microsoft...
He doesn't need to install an addon for it.
He was originally using Microsoft...
In case you still want to use this Add-On, I applied an update. To clarify why it didn't include these tables, it has numbers in it (OAuth2xxx). So the number two (2) was messing it all up and not including all those tables. With this new version, 0.9.7, you should be able to get the complete list! In case there are tables missing, the Add-On should list them at the bottom.
So everything should be fine after the Add-On update. Let me know how it worked out if you're still wanting to use it!
So everything should be fine after the Add-On update. Let me know how it worked out if you're still wanting to use it!
Just starting another migration and have installed 0.9.7 of your Database Migration Add In. Yes, all those OAuth tables are there. However when I checked the tables I found one table was missing calendareventsearchindexattributes
I was running this on. Concrete5 version 8.5.1.
I was running this on. Concrete5 version 8.5.1.
@DL0rnie, just updated the package and that table should also be included now. Along with any package that has a src/Entity directory to include entities defined in this directory the same as the core does.
(entities have ORM like comments with the database table name)
(entities have ORM like comments with the database table name)
Restart your server and try a fresh install.
Your correct camel case table names are..