Database Tables Missing after Site Transfer
Permalink
Hi all!
I just transferred my site from localhost to Arvixe hosting. I transferred the database and C5 files fine. I used the Database Migration Tool since I was going from Windows host to Linux host.
All the pages on the site show up fine. It is when I go to the Dashboard and click on the Sitemap, File Manager, User Search, Waiting For Me, Stacks, Block & Stack Permissions, etc. that I see the errors which I have included screenshots of. The most wide spread error I see has to do with the table named concrete5.Permissions.Assignments. It says that the table doesn't exist. I looked into the tables and it isn't there.
I need to get this site up ASAP. Any ideas?
Thanks in advance!
I just transferred my site from localhost to Arvixe hosting. I transferred the database and C5 files fine. I used the Database Migration Tool since I was going from Windows host to Linux host.
All the pages on the site show up fine. It is when I go to the Dashboard and click on the Sitemap, File Manager, User Search, Waiting For Me, Stacks, Block & Stack Permissions, etc. that I see the errors which I have included screenshots of. The most wide spread error I see has to do with the table named concrete5.Permissions.Assignments. It says that the table doesn't exist. I looked into the tables and it isn't there.
I need to get this site up ASAP. Any ideas?
Thanks in advance!
There are a couple of migration tools. I think (and could be wrong) that one has the list of tables built in and the other reads the db.xml. So perhaps it missed a table rename.
1- As far as you migrate from Windows to Linux, check if your table names are still CamelCase or not? C5 table names contain UpperCase characters (like BlockTypes, PageStatistics,..) that sometimes convert to lowercase in windows OS.
2- You forgot to attach the screenshot, also copy/paste the error may help others to get what happens on your site.
2- You forgot to attach the screenshot, also copy/paste the error may help others to get what happens on your site.
Opps, Sorry about that. Here they are.
Hmm, I do see one other migration tool,http://www.concrete5.org/marketplace/addons/mysql-case-insensitive-... .
I can see that the the table names are in CamelCase. I do see a good bit that start with bt, such as btLogin. There are some that are not in CamelCase.
Hmm, I do see one other migration tool,http://www.concrete5.org/marketplace/addons/mysql-case-insensitive-... .
I can see that the the table names are in CamelCase. I do see a good bit that start with bt, such as btLogin. There are some that are not in CamelCase.
Am I correct in thinking now that you have all the tables, but for some reason some of the names were not converted?
If so:
- Post a support request with info for the addon so it can be revised.
- Use phpMyAdmin to correct the names that it missed.
If so:
- Post a support request with info for the addon so it can be revised.
- Use phpMyAdmin to correct the names that it missed.
Ok, there were a few table is missed, including PermissionsAssignments, which was preventing anyone from viewing the site!!! I exported it manually out of the local version and renamed it. I also went through and set all the tables to CamelCase.
Everything works great now! Thanks!!!
Everything works great now! Thanks!!!
