Move Wampserver 2.0 Windows to VPS with Webmin/Virtualmin - Table Capitalization
Permalink
First I got this error
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'avenus_conrete.Config' doesn't exist..
Then thePhilm suggested it was the lowercase tables problem in windows, so I downloaded the most recent sql to rename the tables, "renameC5tables.sql" here second to last in the string,http://www.concrete5.org/community/forums/installation/move-site/#27175 I did it from within phpAdmin using SQL with 'concrete' db selected.
However there were some tables that were still not capitalized, so changed them using the same SQL syntax.
These are the ones I added:
ALTER TABLE `btasmillerGallery` RENAME `btasmillerGalleryTMP` ; ALTER TABLE `btasmillerGalleryTMP` RENAME `btasmillerGallery` ;
ALTER TABLE `btasmillerGalleryImg` RENAME `btasmillerGalleryImgTMP` ; ALTER TABLE `btasmillerGalleryImgTMP` RENAME `btasmillerGalleryImg` ;
ALTER TABLE `btFile` RENAME `btFileTMP` ; ALTER TABLE `btFileTMP` RENAME `btFile` ;
ALTER TABLE `btGallery` RENAME `btGalleryTMP` ; ALTER TABLE `btGalleryTMP` RENAME `btGallery` ;
ALTER TABLE `btGalleryImg` RENAME `btGalleryImgTMP` ; ALTER TABLE `btGalleryImgTMP` RENAME `btGalleryImg` ;
ALTER TABLE `btLogin` RENAME `btLoginTMP` ; ALTER TABLE `btLoginTMP` RENAME `btLogin` ;
ALTER TABLE `btNextPrevious` RENAME `btNextPreviousTMP` ; ALTER TABLE `btNextPreviousTMP` RENAME `btNextPrevious` ;
ALTER TABLE `btSortableFancyBoxGallery` RENAME `btSortableFancyBoxGalleryTMP` ; ALTER TABLE `btSortableFancyBoxGalleryTMP` RENAME `btSortableFancyBoxGallery` ;
ALTER TABLE `btSortableFancyBoxGalleryPositions` RENAME `btSortableFancyBoxGalleryPositionsTMP` ; ALTER TABLE `btSortableFancyBoxGalleryPositionsTMP` RENAME `btSortableFancyBoxGalleryPositions` ;
ALTER TABLE `btSuperFish` RENAME `btSuperFishTMP` ; ALTER TABLE `btSuperFishTMP` RENAME `btSuperFish` ;
ALTER TABLE `btTags` RENAME `btTagsTMP` ; ALTER TABLE `btTagsTMP` RENAME `btTags` ;
ALTER TABLE `btDateNav` RENAME `btDateNavTMP` ; ALTER TABLE `btDateNavTMP` RENAME `btDateNav` ;
Now I am getting this error. Anyone know why?
An unexpected error occurred.
mysql error: [1146: Table 'concrete.btSuperfish' doesn't exist] in EXECUTE("SHOW COLUMNS FROM `btSuperfish`")
I've attached the file I used below, called ReNameC5Tables-C5411.txt
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'avenus_conrete.Config' doesn't exist..
Then thePhilm suggested it was the lowercase tables problem in windows, so I downloaded the most recent sql to rename the tables, "renameC5tables.sql" here second to last in the string,http://www.concrete5.org/community/forums/installation/move-site/#27175 I did it from within phpAdmin using SQL with 'concrete' db selected.
However there were some tables that were still not capitalized, so changed them using the same SQL syntax.
These are the ones I added:
ALTER TABLE `btasmillerGallery` RENAME `btasmillerGalleryTMP` ; ALTER TABLE `btasmillerGalleryTMP` RENAME `btasmillerGallery` ;
ALTER TABLE `btasmillerGalleryImg` RENAME `btasmillerGalleryImgTMP` ; ALTER TABLE `btasmillerGalleryImgTMP` RENAME `btasmillerGalleryImg` ;
ALTER TABLE `btFile` RENAME `btFileTMP` ; ALTER TABLE `btFileTMP` RENAME `btFile` ;
ALTER TABLE `btGallery` RENAME `btGalleryTMP` ; ALTER TABLE `btGalleryTMP` RENAME `btGallery` ;
ALTER TABLE `btGalleryImg` RENAME `btGalleryImgTMP` ; ALTER TABLE `btGalleryImgTMP` RENAME `btGalleryImg` ;
ALTER TABLE `btLogin` RENAME `btLoginTMP` ; ALTER TABLE `btLoginTMP` RENAME `btLogin` ;
ALTER TABLE `btNextPrevious` RENAME `btNextPreviousTMP` ; ALTER TABLE `btNextPreviousTMP` RENAME `btNextPrevious` ;
ALTER TABLE `btSortableFancyBoxGallery` RENAME `btSortableFancyBoxGalleryTMP` ; ALTER TABLE `btSortableFancyBoxGalleryTMP` RENAME `btSortableFancyBoxGallery` ;
ALTER TABLE `btSortableFancyBoxGalleryPositions` RENAME `btSortableFancyBoxGalleryPositionsTMP` ; ALTER TABLE `btSortableFancyBoxGalleryPositionsTMP` RENAME `btSortableFancyBoxGalleryPositions` ;
ALTER TABLE `btSuperFish` RENAME `btSuperFishTMP` ; ALTER TABLE `btSuperFishTMP` RENAME `btSuperFish` ;
ALTER TABLE `btTags` RENAME `btTagsTMP` ; ALTER TABLE `btTagsTMP` RENAME `btTags` ;
ALTER TABLE `btDateNav` RENAME `btDateNavTMP` ; ALTER TABLE `btDateNavTMP` RENAME `btDateNav` ;
Now I am getting this error. Anyone know why?
An unexpected error occurred.
mysql error: [1146: Table 'concrete.btSuperfish' doesn't exist] in EXECUTE("SHOW COLUMNS FROM `btSuperfish`")
I've attached the file I used below, called ReNameC5Tables-C5411.txt
Here is the file ReNameC5Tables-C5411.txt
Your attachment is missing but for the problem of the database it's best to invest a little and use this add-on:http://www.concrete5.org/marketplace/addons/mysql-case-insensitive-...
doing it manually leaves you open to mistakes, using that add-on it should go without problems.
another option you have now since you already tried to change it all is to log in on your phpmyadmin enviroment and check if the table it actually there and if it is filled.
doing it manually leaves you open to mistakes, using that add-on it should go without problems.
another option you have now since you already tried to change it all is to log in on your phpmyadmin enviroment and check if the table it actually there and if it is filled.
Thanks
I am in the process of changing the table capitalization, but I changed the concrete db table to 'btSuperFish' yet on the VPS it is looking for 'btSuperfish' I believe. I will upload new corrected file once this is fixed.
I had been looking for some list, or directory which would tell me what the correct capitalization is for tables, but have not found it. Do you know where that might be? Or is there some standard?
Thanks
Rick
I am in the process of changing the table capitalization, but I changed the concrete db table to 'btSuperFish' yet on the VPS it is looking for 'btSuperfish' I believe. I will upload new corrected file once this is fixed.
I had been looking for some list, or directory which would tell me what the correct capitalization is for tables, but have not found it. Do you know where that might be? Or is there some standard?
Thanks
Rick
I don't think there is a list. You can find out the basics by installing a fresh concrete on a Linux enviroment and checking the tables created but that won't give you a list on how all add-ons will be listed in the database.
I think the basic is starting each word in the table with a capital. so add-ons will have: btNextPrevious for example. atleast that's what I see when I check out my database
I think the basic is starting each word in the table with a capital. so add-ons will have: btNextPrevious for example. atleast that's what I see when I check out my database
Well anyway, changing the table to "btSuperfish" fixed it.
The site is up an running on VPS and it appears to be a bit faster than my 2004 Windows laptop using Wampserver 2.0.
Thanks for everyone's help.
Rick
PS:
Here's the corrected table rename file
ReNameC5Tables-C5411.txt
The site is up an running on VPS and it appears to be a bit faster than my 2004 Windows laptop using Wampserver 2.0.
Thanks for everyone's help.
Rick
PS:
Here's the corrected table rename file
ReNameC5Tables-C5411.txt
Damit
An unexpected error occurred.
mysql error: [1146: Table 'concrete.btSortableFancyboxGallery' doesn't exist] in EXECUTE("SHOW COLUMNS FROM `btSortableFancyboxGallery`")
How is this supposed to be spelled?
This is driving me crazy.
An unexpected error occurred.
mysql error: [1146: Table 'concrete.btSortableFancyboxGallery' doesn't exist] in EXECUTE("SHOW COLUMNS FROM `btSortableFancyboxGallery`")
How is this supposed to be spelled?
This is driving me crazy.
Sortable Fancybox Gallery has 2 tables. these ones:
btSortableFancyboxGallery
btSortableFancyboxGalleryPositions
I checked these in a phpmyadmin enviroment on a Linux server so the names are like above.
looking at your message yours is looking for: concrete.btSortableFancyboxGallery instead of btSortableFancyboxGallery
btSortableFancyboxGallery
btSortableFancyboxGalleryPositions
I checked these in a phpmyadmin enviroment on a Linux server so the names are like above.
looking at your message yours is looking for: concrete.btSortableFancyboxGallery instead of btSortableFancyboxGallery
Ok I corrected the caps by guessing and it seems to work now.
ALTER TABLE `btSortableFancyboxGallery` RENAME `btSortableFancyboxGalleryTMP` ; ALTER TABLE `btSortableFancyboxGalleryTMP` RENAME `btSortableFancyboxGallery` ;
ALTER TABLE `btSortableFancyboxGalleryPositions` RENAME `btSortableFancyboxGalleryPositionsTMP` ; ALTER TABLE `btSortableFancyboxGalleryPositionsTMP` RENAME `btSortableFancyboxGalleryPositions` ;
Also corrected the file attached below.
At the moment I know of no other caps problems, and Dashboard > Systems & Maint> Jobs > Run checked has no errors.
ALTER TABLE `btSortableFancyboxGallery` RENAME `btSortableFancyboxGalleryTMP` ; ALTER TABLE `btSortableFancyboxGalleryTMP` RENAME `btSortableFancyboxGallery` ;
ALTER TABLE `btSortableFancyboxGalleryPositions` RENAME `btSortableFancyboxGalleryPositionsTMP` ; ALTER TABLE `btSortableFancyboxGalleryPositionsTMP` RENAME `btSortableFancyboxGalleryPositions` ;
Also corrected the file attached below.
At the moment I know of no other caps problems, and Dashboard > Systems & Maint> Jobs > Run checked has no errors.
