Moved site gone totally wrong. Localhost destroyed! :'(
Permalink
Hi everyone,
I'm fairly new to concrete5 and I've managed to create my own theme with a xampp server on my pc. Everything went perfectly! But eventually you would want to move that site to a live environment... and there the trouble happend.
The host where the site was gonna be stored was pretty new to me, didn't know the ins and outs. I've worked the whole documentation down to the last bit. Looked the site and got a 404 error and sometimes a 403 or a internal server error. I've contacted the host that I have this problem and he told me that I need to put the sites root not in httpdocs but in a directory IN httpdocs. Tried this with a empty index.html and that worked.
But since I have tried So...Many...Things... to get everything to work that I've lost track and eventually resulted in a broken localhost and a broken live version.
I think that my localhost broke when I wrote the site.php back from live to local. Maybe something to do with the Salt_password?!
The local is giving this error:
Unable to connect to database.
A database error occurred while processing this request.
And my live version this error:
An unexpected error occurred.
mysql error: [1146: Table 'db36662_welldone.PermissionAccessList' doesn't exist] in EXECUTE("select paID, peID, pdID, accessType from PermissionAccessList where paID = 45 and peID in (2) order by accessType desc")
10 hours I'm in to fixxing this problem already and I just CAN'T figure it out. Can someone please help me out here! :'(
I'm fairly new to concrete5 and I've managed to create my own theme with a xampp server on my pc. Everything went perfectly! But eventually you would want to move that site to a live environment... and there the trouble happend.
The host where the site was gonna be stored was pretty new to me, didn't know the ins and outs. I've worked the whole documentation down to the last bit. Looked the site and got a 404 error and sometimes a 403 or a internal server error. I've contacted the host that I have this problem and he told me that I need to put the sites root not in httpdocs but in a directory IN httpdocs. Tried this with a empty index.html and that worked.
But since I have tried So...Many...Things... to get everything to work that I've lost track and eventually resulted in a broken localhost and a broken live version.
I think that my localhost broke when I wrote the site.php back from live to local. Maybe something to do with the Salt_password?!
The local is giving this error:
Unable to connect to database.
A database error occurred while processing this request.
And my live version this error:
An unexpected error occurred.
mysql error: [1146: Table 'db36662_welldone.PermissionAccessList' doesn't exist] in EXECUTE("select paID, peID, pdID, accessType from PermissionAccessList where paID = 45 and peID in (2) order by accessType desc")
10 hours I'm in to fixxing this problem already and I just CAN'T figure it out. Can someone please help me out here! :'(
Hi irsah,
Thanks for your reply! I deleted all existing tables of the "new site". I'll look into permissions on the forum. That backup Voodoo you're talking about. You think that'll fix everything or large chucks of it? Wanna be sure before purchase!
First thing I need to do now is get the site working again on my local server, which has the "Unable to connect to database.A database error occurred while processing this request" error message.
Got any tips for that? What steps I can take to get it up and running again?
Thanks again!
Thanks for your reply! I deleted all existing tables of the "new site". I'll look into permissions on the forum. That backup Voodoo you're talking about. You think that'll fix everything or large chucks of it? Wanna be sure before purchase!
First thing I need to do now is get the site working again on my local server, which has the "Unable to connect to database.A database error occurred while processing this request" error message.
Got any tips for that? What steps I can take to get it up and running again?
Thanks again!
For a working site it will.
But for your situation, it must have it up and running, by then you can use back_up voodoo and start transferring data to new environment. And the developer is always around, just send PM.
Others, from the top of my head, in site.php,
1. database name -> same as the name of your uploaded files database name.
2. No, unnecessary spaces in site.php line of codes (depends on your host environment/software)
3. Caps and small letters in line of code.
4. The same version of c5 from your previous site install.
You could also copy/move blocks, packages, or any customization to files been created previously. Have you re-created/copied all the files/folders EXCEPT concrete/ folder?
If however, entering password would be an issue upon log-in if success (password mismatch with database), use the overwrite password Method 3 in the How-To's section.
irsah
But for your situation, it must have it up and running, by then you can use back_up voodoo and start transferring data to new environment. And the developer is always around, just send PM.
Others, from the top of my head, in site.php,
1. database name -> same as the name of your uploaded files database name.
2. No, unnecessary spaces in site.php line of codes (depends on your host environment/software)
3. Caps and small letters in line of code.
4. The same version of c5 from your previous site install.
You could also copy/move blocks, packages, or any customization to files been created previously. Have you re-created/copied all the files/folders EXCEPT concrete/ folder?
If however, entering password would be an issue upon log-in if success (password mismatch with database), use the overwrite password Method 3 in the How-To's section.
irsah
Hi Irsah,
Thanks again for the reply and amazing help! I've managed to get my local server up and running again. Indeed ran into the problem that my username/password wasn't correct at login, but checked the logs table in the database to retrieve it etc.
I've also purchased and installed Backup Voodoo. I've did all the steps found in the documentation @ the "cloning site" section. But when I'm importing the database on the live environment I get this error message at phpmyadmin sql:
#1146 - Table 'db36662_welldone.Config' doesn't exist
And if I open the website, it can't find the page still. :(
I feel like I'm almost there, you know how I can fix this (hopefully last) issue? :)
Thanks again!
Youri
Thanks again for the reply and amazing help! I've managed to get my local server up and running again. Indeed ran into the problem that my username/password wasn't correct at login, but checked the logs table in the database to retrieve it etc.
I've also purchased and installed Backup Voodoo. I've did all the steps found in the documentation @ the "cloning site" section. But when I'm importing the database on the live environment I get this error message at phpmyadmin sql:
#1146 - Table 'db36662_welldone.Config' doesn't exist
And if I open the website, it can't find the page still. :(
I feel like I'm almost there, you know how I can fix this (hopefully last) issue? :)
Thanks again!
Youri
Hi great to here the news..
I was away for couple of days.. sorry :(
Anyway, did u manage to overcome and find a solution? You could also PM JohntheFish (Voodoo author) for assistance (if required) since probably you've missed something out (that small little piece..)
Regards,
Irsah
I was away for couple of days.. sorry :(
Anyway, did u manage to overcome and find a solution? You could also PM JohntheFish (Voodoo author) for assistance (if required) since probably you've missed something out (that small little piece..)
Regards,
Irsah
I only just bumped into this thread. First off, thanks to Israh for recommending Backup Voodoo and thanks to Youri for purchasing. I have received a PM from Youri and have given some guidance and asked a few questions to see how I can help.
For the benefit of anyone else running into this thread, if you think a table is missing from a backup, the database part of the backup is a sql text file, so can be loaded into a text editor and examined to confirm the table is in it.
Also worth noting is when moving from a Windows to Linux install, you need to consider the case sensitivity of the database. Backup Voodoo will integrate with the database case sensitivity migration addon to take care of that for you, but the case sensitivity addon needs to be installed separately.
I suspect that in this instance, the problem is a missed step in installing the clone, which unlike the highly automated backup process, is a series of manual steps. Perhaps not importing the sql to the new database, or not editing config/site to connect to the new database.
For the benefit of anyone else running into this thread, if you think a table is missing from a backup, the database part of the backup is a sql text file, so can be loaded into a text editor and examined to confirm the table is in it.
Also worth noting is when moving from a Windows to Linux install, you need to consider the case sensitivity of the database. Backup Voodoo will integrate with the database case sensitivity migration addon to take care of that for you, but the case sensitivity addon needs to be installed separately.
I suspect that in this instance, the problem is a missed step in installing the clone, which unlike the highly automated backup process, is a series of manual steps. Perhaps not importing the sql to the new database, or not editing config/site to connect to the new database.
Your welcome John,
I think Youri managed to come thru... (without redoing his site anyway). I too suspect a few details probably missed out by Youri, but it's a good thing you guys are always around for additional support.
Anyway luv your works and guidance here on c5, definitely made our work process easier and hope others too.
Regards,
Irsah.
I think Youri managed to come thru... (without redoing his site anyway). I too suspect a few details probably missed out by Youri, but it's a good thing you guys are always around for additional support.
Anyway luv your works and guidance here on c5, definitely made our work process easier and hope others too.
Regards,
Irsah.
To anyone else encountering this problem, it is caused by the "php timeout" stopping the database installation, normally around the point where it is at this table.
To solve it, reinstall the database and de-select "Allow the interruption of an import in case the script detects it is close to the PHP timeout limit. This might be good way to import large files, however it can break transactions."
To solve it, reinstall the database and de-select "Allow the interruption of an import in case the script detects it is close to the PHP timeout limit. This might be good way to import large files, however it can break transactions."
You can also import a sql file through phpMyAdmin.
If the SQL file is too big, you can chop it into smaller files using a text editor and import them in sequence using phpMyAdmin.
(Just make sure no one tries to do anything else with the database while you are importing).
See
http://www.concrete5.org/documentation/how-tos/developers/backup-a-...
If the SQL file is too big, you can chop it into smaller files using a text editor and import them in sequence using phpMyAdmin.
(Just make sure no one tries to do anything else with the database while you are importing).
See
http://www.concrete5.org/documentation/how-tos/developers/backup-a-...
From your record, it seems like you've set permissions (probably advance permissions) from your working site and the database mismatch in new environment.
Did you delete all existing tables (new site) before installing your working .gzipped database (old site) file (just wondering)?
Also take a look on permissions here in the forum, and which one should you also move from your working site (or some overwrite) for your c5 version installed.
I'd recommend some c5 apps like the back_up voodoo which with simple procedures makes moving site (incl database) much more easier and user friendlyhttp://www.concrete5.org/marketplace/addons/backup-voodoo/...
Hope it helps.
Irsah.