The Joomla! Forum ™

Hi

Just pushed my first site to a shared hosting site.  It was working fine on my computer. I've seen some threads on how to migrate, and followed them for the most part.  I'm not sure what I haven't done at this point.

The site generally looks ok on the surface ( http://gardenwalkbuffalo.com/cms ), but when you try to do things within the administrator, there appears to be php/database problems. For example, trying to add users doesn't work.  It adds a row to the table, but then doesn't come back to the user management page showing completion.  Same with adding/modifying content.

The current version I put out there is 1.0.5, but I planned on upgrading to 1.0.7.  For now, I'm just practicing the process and getting it down right.

Here's the steps I took:

1. I created the database and an admin user full privileges. I prepared an export of the db using phpMyAdmin.  I ran the SQL and loaded the table.  All seemed fine with this step.

2. I zipped up the site directories, and FTP'd it to the site.  Then I extracted the files. 

3. I changed the configuration.php to make it appropriate for the environment.  Looked fine.  Up and running.

I noticed that there are differences between my development platform and the shared hosting site:

My Dev:

(WampServer)
Database Version:  5.0.16-nt 
PHP Version:  5.1.1 
Web Server:  Apache/1.3.33 (Win32) PHP/5.1.1 


Remote Server:

PHP built On:  Linux box70.bluehost.com 2.6.9-22.0.1.106.unsupportedsmp #1 SMP Sun Nov 6 09:55:19 CST 2005 x86_64 
Database Version:  4.1.13-standard-log 
PHP Version:  4.4.1 
Web Server:  Apache/1.3.34 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.25 OpenSSL/0.9.7a PHP-CGI/0.1b 



What did I do wrong???

PHP Version:  4.4.1  --> this has been known to have a lot of issues.. though you may try to ask your new shared hosting if its possible to update php version?

2. you may check with other hosting and try out if your local wil work.. im pretty sure its server/hosting invironment issue.

- g

_________________
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net | http://www.backspace.ph

also if youre having those problems on tables pls check also the versions of mysql in your local and the shared hosting.

otherwise you might have missed somthing in the db dumping.


- g

_________________
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net | http://www.backspace.ph

Thanks Guilliam

I guess I did better than I thought...but now I have concern about the web hosting.  I chose BlueHost.com, which was mentioned by others to be Joomla friendly.

One thing I was wondering about was whether the problem was due to how I packaged up the SQL.  Comparing it to your previous thread for newbies, I found that I needed to specify in in phpMyAdmin the SQL export compatibility to "MySQL40" for it to work.

Do you think that would have any effect?

hold.. let me give oyu a better and almost fail safe way to dump it without having those version issues in mysql.

1. on your site 1 open phpmyadmin and open the structure of the db.. then click export WITHOUT saving it to a file.. meaning just pure text. keep it open.

2. on the live site(site2), opne phpmyadmin and open a CLEAN db, i mean a new db without tables.. or if you want to use the existing db.. DROP all data on that db together with the tables of course. keep that open as well(site 2's new/clean db)

3.  from the site one which generated a dump of "text" version select all and copy(so it will be in your clipboard.

4. in your site 2 which is a clean db,.. run that dump that you currently have in your clip board.

sorry.. my sys hd just crashed.. using a mobile pc in replying so i cant give you a guided solution with screenies.

- g

_________________
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net | http://www.backspace.ph

Guilliam

You're a genius!!!    That worked like a champ!

Could you explain in slight detail why this method worked, and others did not, for the benefit of me and other listeners?

Thanks Again!!!!!!

I think you have helped with an issue I'm having, too. My hosting provider won't allow upload of a mySQL dump, but I can use phpmyadmin to open the db. The problem is (and pls note I am a very new newbie...) I don't understand where to paste (I assume that's what u mean by "run" in 4) the clipboard contents. When I click on the Structure  tab, what I see on the mphpmyadmin screen is  a form with "Create new table on database xxxx" with entry forms for "Name" and "Number of Fields". Do I paste into the "Name" field? Thanks, I know these questions are really elementary (read:dumb) but I could use some help right now!

2. on the live site(site2), opne phpmyadmin and open a CLEAN db, i mean a new db without tables.. or if you want to use the existing db.. DROP all data on that db together with the tables of course. keep that open as well(site 2's new/clean db)

3.  from the site one which generated a dump of "text" version select all and copy(so it will be in your clipboard.

4. in your site 2 which is a clean db,.. run that dump that you currently have in your clip board.

_________________
Martin

I may have spoke too soon.

While Guilliam certainly has moved me along some, I'm still seeing some anomalies related to users/permissions.

There were 2 accounts set up prior to migration - an admin, and a backend manager that could only do content changes.

I added two more, which now work thanks to Guilliam.

Unfortunately, all accounts except for the admin account have problems with the MCtiny editor coming up when attempting to modify content.  Things lock up.  I've seen this happen in 1.0.4 I think.  It leaves the user out there.  I have to go back in as admin to globally check in the module to clear it up.

Guilliam - Is this problem separate from what I had before??

@slyboots,

you should click this tab/icon where the hand is pointed in the screenshot:



when you click that, it will lead you to a screen where you can paste the data from your clip board.

hope i havent used much of techie terms here.. i understand pretty well being a newbie.. im a NEWBIE too

for further reference check this thread for that db dumping: http://forum.joomla.org/index.php/topic ... #msg122027

- g

_________________
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net | http://www.backspace.ph

line breaks sometimes are interpreted diffrently when in a zipped file.. compared to pasting it clean from clipboard.. check the diff from a dl'ed dump from the pure text version.. in your pure text version paste it in notepad.

- g 

_________________
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net | http://www.backspace.ph

1. can oyu double check tinymce's files if exactly the same in your local and your live?
2. NO, this is NOT a db issue but on the tinymce. though i cant answer that correctly IMHO, bec i dont use tinymce, i use MOSCE,.. far better

- g

_________________
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net | http://www.backspace.ph

Guilliam- thanks! I think I understand- I'll let you know how it goes.

Martin

_________________
Martin

"i think i understand" ehehheh. thats a lil dangerous statment

let us know if you still bump into trouble.. be sure to read the thread i gave you.. will give you further info step by step.

- g

_________________
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net | http://www.backspace.ph

Guilliam,
Well, I understood part of it, at least enough to create the database, after which I uploaded my site files. The only problem was caused by different versions of mysql, but a search on the forum found the fix (I'll post on this later). After dinner I'll work on the configuration file... right now I see a partial Joomla "offline page", so I think I can call this "progress". Thanks for helping me get this far!

Martin

_________________
Martin

wonderful! heart warming  to know newbies are getting into the next stage!

- g

_________________
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net | http://www.backspace.ph

Well, as long as you are continuing to be patient and understanding, here is a REALLY DUMB question. When I used JSAS to set up the dev site on my PC it said "leave the password blank", and now my config file has this line: $mosConfig_password = ''; question is, what do I use for a p/w? An existing database or user p/w? something new? 

Martin

_________________
Martin

thats not a dumb question..

the mysql db's password is protected via md5 hashing of pw's..

have you searched the forum on how to migrate JSAS sites to live servers? i dont use it(i use win, apache, mysql, php) thats why i dont know why its blank..

what i suggest is search the forum.. must be here somewhere.. or check with jsas site

- g

_________________
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net | http://www.backspace.ph

Guilliam,

Thanks again for the reply. I searched around quite a bit on this before I started, and information on JSAS>live server is pretty scant. The JSAS help site is actually the Joomla forum, so at least I only had to search one site... I think what I'll do tonight (hey, I've had dinner and it's time to watch some bad tv) is just leave things as they are and get back to it in the AM. Unless I'm leaving a major door open to the server - any suggestions if that's so? And that, I promise, is today's last question! You have been really helpful.

Martin

_________________
Martin

i will call one the attention of one of the joomla solutions crew to check this thread.

- g

_________________
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net | http://www.backspace.ph

[me=joomlasolutions_JB]rushes in at Guilliams call![/me]


1.Info for JSAS / MSAS local to remote host - see animated step by step flash tutorial MSAS / JSAS Site Sync Flash Tutorial

This tutorial was made for MSAS (Mambo) b ut same principals apply for JSAS ( Joomla)

2. password blank issue: In JSAS, the password is blank, correct behavior. However on live host you will need a database password! You get this from your host!



Hope that helps!

_________________
Joomla! Template Shop www.joomlathemes.org

Joomla Template Club
[URL=http://templateclub.mambosolutions.com]templateclub.mambosolutions.com
[/URL]

@joomlasolutions_JB, thanks! i know we can always count on you.

- g

_________________
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net | http://www.backspace.ph

JB and Guilliam,

Thanks guys- here is where I am now. JB, I went back and looked (more carefully  ) at the tutorial I downloaded several days ago, and that did indeed help a lot. My problems are all in the config file, I think (oops, there I go again Guilliam) and I'll try to work them out this AM.

I still have a question about the db p/w: JB (or Guilliam anyone), when you say that I get it from my provider, I am guessing that it is not the p/w I used when I set up the db, but a hashed p/w? Am I going in the right direction? I'll probably utter a  few more cries for help before this is done, but in return for this selfish use of bandwidth I'll post my experiences in hopes of giving some ideas to  other newbies facing the same issues.

Martin.

_________________
Martin

hi martin, questions:

1. do you have an existing db in your live server?

2. the pw for the mysql db IS NOT hashed,.. dont be misleaded.. what i mean hashed pw is the user's pw like the the one you used in: yoursite/administrator/


- g

_________________
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net | http://www.backspace.ph

Guilliam- thanks for getting back to me so quickly- yes, I set up a db on the live server with p/w- is that what I enter in $mosConfig_password = ''; ?

_________________
Martin

yes! thats what you will enter. not hashed ;)

$mosConfig_db          -> the name of the db
$mosConfig_user        -> the username you used for the mysql db
$mosConfig_password  -> the mysql db's pw (unhashed)

$mosConfig_dbprefix -> check the table prefix youre using in your local.. bec some versions use jos_ and some uses mos_ if you dump it from your local double check what prefix your db's tables are using.. should be the same with the prefix which is in your config file.


- g

_________________
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net | http://www.backspace.ph

Eureka!!  That and a couple of other corrected entries in the configuration.php file got my site running! I still have something wrong because when I try to log in as Administrator  I keep getting the same error message I got before, so I'm assuming that's where the problem is. I have to do some chores but you'll probably hear from me again when I get back to this...

Martin

_________________
Martin

what  "same error message" are you getting??

- g

_________________
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net | http://www.backspace.ph

guilliam

first thanks for your tip on how to upload a db, i followed this thread and your step, and it worked fine beside the fact that i had to set the "SQL export compatibility:" to the proper version. but at least it was a very easy way and it worked right away. I tried many things with exporting my db as a .zip file in so many ways that i gave up for a few weeks. Untill i found this trick.
GREAT GREAT GREAT JOB !!!!!!!!!!!!!!!
i can not believe that such a simple step copy/paste worked better than many other complex export/import process, even the tech from my hosting did not think of that.

so now, i have uploaded all my file and change the settings in the "configurarion.php" file to reflect the db info and site path ( here also i had to tweek a few things but got rid of error messages.
but now i get the :
This site is temporarily unavailable.
Please notify the System Administrator
3
do you have any idea why it shows that my site is offline?

thanks again for your help on moving a site to remote shared hosting server. it's really great to have people like you around.
cheers

julien

Guilliam,

Here it is:

Warning: main(.//includes/version.php): failed to open stream: No such file or directory in /home/content/b/u/l/myusername/html/includes/joomla.php on line 71

Fatal error: main(): Failed opening required './/includes/version.php' (include_path='.:/usr/local/lib/php') in /home/content/b/u/l/myusername/html/includes/joomla.php on line 71

Line 71 in joomla.php is:  require_once( $mosConfig_absolute_path . '/includes/version.php' );

I'm working on it - suggestions appreciated!

Martin

_________________
Martin

slyboots

i got the same problem before getting the "this site is unavailable..." error message. all i did was changing:
$mosConfig_absolute_path = '';
$mosConfig_live_site = ';
in the configuration.php

i don't know if that can help you but i thought i should this.
let me know if you get the same error meesage afterwards

i, also, am trying to put my site from my local server to a shared one