Migrating site
Permalink 1 user found helpful
Hi, I developed a concrete 5 site on my local machine running with a wamp server. I have now finished development and want to get the site live. i followed the installation steps found here:https://documentation.concrete5.org/developers/installation/moving-a...
in my database.php file i changed the name of the username and password to match with the ones for my database and i kept the database name the same. However when i go to the url mysite/concrete5-8.2.1/index.php i get this error:
An exception occurred while executing 'SELECT t0.pkgID AS pkgID_1, t0.pkgHandle AS pkgHandle_2, t0.pkgVersion AS pkgVersion_3, t0.pkgIsInstalled AS pkgIsInstalled_4, t0.pkgAvailableVersion AS pkgAvailableVersion_5, t0.pkgDescription AS pkgDescription_6, t0.pkgDateInstalled AS pkgDateInstalled_7, t0.pkgName AS pkgName_8 FROM Packages t0 WHERE t0.pkgIsInstalled = ? ORDER BY t0.pkgID ASC' with params [1]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'c1.Packages' doesn't exist
i do not know anything about php so any advice would be greatly appreciated.
thank you
in my database.php file i changed the name of the username and password to match with the ones for my database and i kept the database name the same. However when i go to the url mysite/concrete5-8.2.1/index.php i get this error:
An exception occurred while executing 'SELECT t0.pkgID AS pkgID_1, t0.pkgHandle AS pkgHandle_2, t0.pkgVersion AS pkgVersion_3, t0.pkgIsInstalled AS pkgIsInstalled_4, t0.pkgAvailableVersion AS pkgAvailableVersion_5, t0.pkgDescription AS pkgDescription_6, t0.pkgDateInstalled AS pkgDateInstalled_7, t0.pkgName AS pkgName_8 FROM Packages t0 WHERE t0.pkgIsInstalled = ? ORDER BY t0.pkgID ASC' with params [1]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'c1.Packages' doesn't exist
i do not know anything about php so any advice would be greatly appreciated.
thank you
I've ran into this issue many times. Your database tables names on your local machine are lowercase. But when you move the database to the web hosting, the table names need to be Upper Case. If your web hosting uses phpmyadmin you can turn the lower case names into upper case table names using mysql script writer.
Let me know if you need help with it.
Let me know if you need help with it.
Thank you both very much for your responses. I went through the tables and changed them all to have a capital letter at the start of each word. but I am still getting an error:
An exception occurred while executing 'SELECT t0.issID AS issID_1, t0.customClass AS customClass_2, t0.customID AS customID_3, t0.backgroundColor AS backgroundColor_4, t0.backgroundImageFileID AS backgroundImageFileID_5, t0.backgroundRepeat AS backgroundRepeat_6, t0.backgroundSize AS backgroundSize_7, t0.backgroundPosition AS backgroundPosition_8, t0.borderColor AS borderColor_9, t0.borderStyle AS borderStyle_10, t0.borderWidth AS borderWidth_11, t0.borderRadius AS borderRadius_12, t0.baseFontSize AS baseFontSize_13, t0.alignment AS alignment_14, t0.textColor AS textColor_15, t0.linkColor AS linkColor_16, t0.marginTop AS marginTop_17, t0.marginBottom AS marginBottom_18, t0.marginLeft AS marginLeft_19, t0.marginRight AS marginRight_20, t0.paddingTop AS paddingTop_21, t0.paddingBottom AS paddingBottom_22, t0.paddingLeft AS paddingLeft_23, t0.paddingRight AS paddingRight_24, t0.rotate AS rotate_25, t0.boxShadowHorizontal AS boxShadowHorizontal_26, t0.boxShadowVertical AS boxShadowVertical_27, t0.boxShadowBlur AS boxShadowBlur_28, t0.boxShadowSpread AS boxShadowSpread_29, t0.boxShadowColor AS boxShadowColor_30, t0.hideOnExtraSmallDevice AS hideOnExtraSmallDevice_31, t0.hideOnSmallDevice AS hideOnSmallDevice_32, t0.hideOnMediumDevice AS hideOnMediumDevice_33, t0.hideOnLargeDevice AS hideOnLargeDevice_34 FROM StyleCustomizerInlineStyleSets t0 WHERE t0.issID = ?' with params ["13"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.customClass' in 'field list'
I don't know where it is getting 't0' from as my table is called 'c1'?
An exception occurred while executing 'SELECT t0.issID AS issID_1, t0.customClass AS customClass_2, t0.customID AS customID_3, t0.backgroundColor AS backgroundColor_4, t0.backgroundImageFileID AS backgroundImageFileID_5, t0.backgroundRepeat AS backgroundRepeat_6, t0.backgroundSize AS backgroundSize_7, t0.backgroundPosition AS backgroundPosition_8, t0.borderColor AS borderColor_9, t0.borderStyle AS borderStyle_10, t0.borderWidth AS borderWidth_11, t0.borderRadius AS borderRadius_12, t0.baseFontSize AS baseFontSize_13, t0.alignment AS alignment_14, t0.textColor AS textColor_15, t0.linkColor AS linkColor_16, t0.marginTop AS marginTop_17, t0.marginBottom AS marginBottom_18, t0.marginLeft AS marginLeft_19, t0.marginRight AS marginRight_20, t0.paddingTop AS paddingTop_21, t0.paddingBottom AS paddingBottom_22, t0.paddingLeft AS paddingLeft_23, t0.paddingRight AS paddingRight_24, t0.rotate AS rotate_25, t0.boxShadowHorizontal AS boxShadowHorizontal_26, t0.boxShadowVertical AS boxShadowVertical_27, t0.boxShadowBlur AS boxShadowBlur_28, t0.boxShadowSpread AS boxShadowSpread_29, t0.boxShadowColor AS boxShadowColor_30, t0.hideOnExtraSmallDevice AS hideOnExtraSmallDevice_31, t0.hideOnSmallDevice AS hideOnSmallDevice_32, t0.hideOnMediumDevice AS hideOnMediumDevice_33, t0.hideOnLargeDevice AS hideOnLargeDevice_34 FROM StyleCustomizerInlineStyleSets t0 WHERE t0.issID = ?' with params ["13"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.customClass' in 'field list'
I don't know where it is getting 't0' from as my table is called 'c1'?
In the query you can read
That means that the query uses "t0" as an alias of "StyleCustomizerInlineStyleSets"
FROM StyleCustomizerInlineStyleSets t0
That means that the query uses "t0" as an alias of "StyleCustomizerInlineStyleSets"
thank you!! I misspelt that table it is fixed and the site is up and running now :)
2. Do you have Pretty URL turned on? If yes, see what 'RewriteBase /' is set to in the .htaccess file
3. Did you copy your site to the mysite/concrete5-8.2.1/ folder on purpose? e.g. why not mysite/?