The Joomla! Forum ™



Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  [ 61 posts ]  Go to page 1, 2, 3  Next

DO you think this threads is informative?
Excellent 29%  29%  [ 2 ]
Very good 29%  29%  [ 2 ]
Good 14%  14%  [ 1 ]
Satisfactory 14%  14%  [ 1 ]
Needs focus 14%  14%  [ 1 ]
Total votes : 7
Author Message
 Post subject: Analysis to production
PostPosted: Tue Oct 18, 2005 6:22 am 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast
Offline

Joined: Mon Oct 10, 2005 7:09 am
Posts: 212
Location: Payyannur, Kannur, Kerala,India
hi to all.

        Believeing that there is something documentation is missing,I am creating this.I would be updating it and this would prove to be a ommon document for Newbies(Newbie i meant who is taking the tour for the first time in the entire development phases to server uploding and configuring).As a preface, I am  trying to provide a introduction (glimpse, starters how to) and then the second stage for now.It would be updated with very useful links and snaps later with the problems faced by me and the solution I tried and which worked for me.
        I would be updating on daily basis and the language too would be cared about.I do admit that for now it is just a pointer and not favours either the starter or intermediate users but it would be updated very soon that it is the one of the best links to starters corner.

Primary/local installation

Step 1: Download the Joomla package.extract it to a temporary directory.now move this directory to the root directory.By root I mean for example if you are using xampp it is c->apachefriends->xampp->htdocs.

Step 2: Open the browser and type in the path : http://localhost....../yourextracteddirectory name.Now have a tour of installation steps as the screens are self explanatory.

Step 3: through the directory go to your extracted directory and delete the installation folder.

Step 4:Open the browser and type in the path to your extracted folder you would find your site screen up.:) Now if you would like to go to administrator backend type with the path(after the extracted directoryname add '/administrator'.(Believeing that you had done fresh installation and no security fear had gripped you.:)

Step 4 provide the username and password and cheers , for the gate to the power of simplicity gets opened before you.
ANy queries to the above steps would be very well appreciated as I would like to update this to act as a common document with all concerns addressed.

For the phase when you are ready with your site locally and would like to have it up in your remote server.

Step 1: Zipp your working directory(extracted directory in the root).

Step2: I use softwares like secureFX or wsFTP Pro for uploading and site maintenance.Now you should be getting connected to your remote server. Just browse to this local zipped file and upload it to your remote server. You can use a small cgi script for doing some handy tasks like unzipping, copying, moving, remmoving.I would try to provide if i get query for these.If you don't have such an option it is simple to upload the entire extracted folder with its files.Note:- 1 The total size is 12 MB approx and chances of getting the files corrupted are more.

Now is slight database work.

You can use PhpMyadmin for this which is very simple and handy to use.It would be explained in detail here itself. If you find the need urgent, private message me and I wouldreadily update it in minutes.
Step 3: create the sql dump file of your local sql database.

Step 4: go to your remote cpanel and create a database for your site.Now you select the sql tab and at the lower area you would find a file uploader.use it to browse your local sql file and press go.

Step 5: If all goes fine, your database is imported successfully.

Step 6Now, change the configuration.php in your site directory. Correct the absolute and relative path and also the cache path.

Step 7: Now also change the database name,password and user.

Step 8: Yes.browse to your site.You would find it up live. So you are with a smile on your lips.thanks for that.


Any pointers and suggestions that might be helpful is whole heartedly welcomed and as a personal request it would be great if you could private message suggestions and queries so that the thread remains a one look point for the information that had been updated with the help ogf your suggestions/ queries and mentioning your username as acknowedgement for that part.

Thanking you I remain

Harish Balakrishnan Marar

_________________
Technology to Solutions ( Skype : holy.geek_saffrongeek )
Given enough eyeballs , All bugs are shallow.
Collecting data is only the first step toward wisdom. But sharing data is the first step toward community


Top
 Profile  
 
PostPosted: Sat Oct 22, 2005 7:49 am 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast
Offline

Joined: Mon Oct 10, 2005 7:09 am
Posts: 212
Location: Payyannur, Kannur, Kerala,India
hi,

scene : importing the database from dump file to remote server
Issue #1: Default charachter set latin1 collate latin1_general_ci
Reason: { 1. Mysql versions difference, [invites suggestions] }
Refernce : a snap of error attached.

Well, searching the mysql server for the solution took me to a thread. But that was informative. Now the error could be solved in simple way:-

    Open your sql dumpfile in wordpad ( Wordpad is said to support unix characters and do a search for the following keyword for replace:-
collate latin1_general_ci and replace it with a space.

    Now once you hae replaced all occurrences you so another search for 'Collate latin1_general_ci' and replace those occurences too.Now try to import, YOu are displayed

    "  Your SQL query has been executed successfully  and The content of your file has been inserted and [number] of instructions."


You do not have the required permissions to view the files attached to this post.

_________________
Technology to Solutions ( Skype : holy.geek_saffrongeek )
Given enough eyeballs , All bugs are shallow.
Collecting data is only the first step toward wisdom. But sharing data is the first step toward community


Top
 Profile  
 
PostPosted: Sat Oct 29, 2005 2:58 pm 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast
Offline

Joined: Mon Oct 10, 2005 7:09 am
Posts: 212
Location: Payyannur, Kannur, Kerala,India
hi to all.

      I uploaded my site and everything was ready.Database was setup and believing that it would be fine.but when i tried to load my site i found to my horor many 'could not sent header infor ....already sent ........../*.php' like wise.

      What could that be that is causing this?
  If you find yourself stuck in a similiar situation , I suggest you to try the following:

1: Check your configuration.php file in the root folder for any space after the closing tag.If so remove those.
 
  2. Check to see that you provided the proper information.(though not related, make sure that you have propoer caahe , absolute, relative path, databse name,and user name to database.

  3. Open your includes folder and search for the mambo.php file.you should check at the end of the file that there si no space.If so remove it and push these files after the correction and try again.Wow, your site liiks fine i believe.
Wishing you a nice time and Happy Dipawali wishes to all jooml forum members
Harish Balakrishnan Marar

_________________
Technology to Solutions ( Skype : holy.geek_saffrongeek )
Given enough eyeballs , All bugs are shallow.
Collecting data is only the first step toward wisdom. But sharing data is the first step toward community


Top
 Profile  
 
PostPosted: Sat Oct 29, 2005 3:04 pm 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast
Offline

Joined: Mon Oct 10, 2005 7:09 am
Posts: 212
Location: Payyannur, Kannur, Kerala,India
hi to all,

  Issue: send registration button on click not submitting.

  Solution: I tried and worked out.

    Well check the script (javascript) in the registration.html.php in com_registration and you would find that there is a password validation bing done.Now if you have your page loaded in a window , try to view the source.you will find that mambo/joomla has inserted an extra '&&' also.Just remove the entire '&&' and just place '&'.Everything works fine.

   I do not know whethere i am correct with my approach or likewise and it worked for me and it is more important.like my motto in my words.Hope this might help someone and save him/her some time.

Wishing you all  a happy dipawali

Harish Balakrishnan Marar

_________________
Technology to Solutions ( Skype : holy.geek_saffrongeek )
Given enough eyeballs , All bugs are shallow.
Collecting data is only the first step toward wisdom. But sharing data is the first step toward community


Top
 Profile  
 
PostPosted: Mon Oct 31, 2005 7:45 am 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Tue Aug 23, 2005 9:45 am
Posts: 687
Location: La Grande, Oregon
Great FAQ.  I appreciate the time you put into doing this.  I understand that there are language restraints but I get the gist of everything just fine.  If you want me to help you proof all this information and write it up, let me know.  I will ask someone on the doc team if we have any other help docs like this and if so, we will compare the information, if not, maybe would should start writing one. 

I am also going to post a link over to this thread: http://forum.joomla.org/index.php/topic,5556.0.html, and maybe more people will migrate this way and give you somemore feedback.  Thanks for all the work.

Charles

_________________
From the beginning...


Top
 Profile  
 
PostPosted: Mon Oct 31, 2005 2:12 pm 
User avatar
Joomla! Intern
Joomla! Intern
Offline

Joined: Sun Aug 28, 2005 9:07 pm
Posts: 51
Location: St. Charles, Missouri USA
Thank you for this information... I wish I would have found this when Joomla first came out!

The problem I'm having now is that my Frontpage is blank. I can successfully log in and work with the Admin area and everything looks fine. But when I simply try to load the site I just get a blank page.

What should I be looking for to fix this?

_________________
--> Brian Robertson


Top
 Profile  
 
PostPosted: Mon Oct 31, 2005 2:16 pm 
User avatar
Joomla! Intern
Joomla! Intern
Offline

Joined: Sun Aug 28, 2005 9:07 pm
Posts: 51
Location: St. Charles, Missouri USA
Well, I just figured it out... it has something to do with swMenuFree... when I unpublished my swMenuFree menu, the Frontpage loaded successfully. Is this just a matter of doing a simple reinstall? Or shoudl I be able to just change something to get swMenuFree working properly again?

_________________
--> Brian Robertson


Top
 Profile  
 
PostPosted: Mon Oct 31, 2005 2:33 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Tue Aug 23, 2005 9:45 am
Posts: 687
Location: La Grande, Oregon
I'd recommend just reinstalling the component (uninstall first).

_________________
From the beginning...


Top
 Profile  
 
PostPosted: Mon Oct 31, 2005 3:33 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Tue Aug 23, 2005 9:45 am
Posts: 687
Location: La Grande, Oregon
By the way...My migration of my website from local to server when great with these instructions.  However, I did not need to change the collate latin1_general_ci in my sql file when I had errors.  I just changed the conversion in phpmyadim from UTF-8 in the drop-down list to latin1 when I uploaded my replace file.

_________________
From the beginning...


Top
 Profile  
 
PostPosted: Wed Nov 02, 2005 1:24 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon Oct 31, 2005 9:32 pm
Posts: 17
I installed Joomla 1.0.3 locally (on my PowerBook that is) using MAMP as a SAS. Zipped the site and upload it to  my remote server. Unzipped it there using ssh terminal. Exported the database data with phpMyAdmin to a file and then uploaded this file successfully to the remote database  (which has the same name/user/pass as my local one). Changed the configuration.php, corrected the absolute and relative path and also the cache path and NO I don't have a smile on my lips, man. I am looking at a screen that says:

This site is temporarily unavailable.?Please notify the System Administrator
2

has anyone any idea what's happening.
Thanks in advance


Top
 Profile  
 
PostPosted: Wed Nov 02, 2005 3:15 am 
User avatar
Joomla! Intern
Joomla! Intern
Offline

Joined: Sun Aug 28, 2005 9:07 pm
Posts: 51
Location: St. Charles, Missouri USA
I had that problem as well and it was just one of my settings... If I remember right I had put in the wrong database password in the config file... it was something like that...

I have another problem now though... the images in my images/stories directory aren't working... any ideas?

_________________
--> Brian Robertson


Top
 Profile  
 
PostPosted: Wed Nov 02, 2005 4:26 am 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Tue Aug 23, 2005 9:45 am
Posts: 687
Location: La Grande, Oregon
gregko wrote:
I installed Joomla 1.0.3 locally (on my PowerBook that is) using MAMP as a SAS. Zipped the site and upload it to  my remote server. Unzipped it there using ssh terminal. Exported the database data with phpMyAdmin to a file and then uploaded this file successfully to the remote database  (which has the same name/user/pass as my local one). Changed the configuration.php, corrected the absolute and relative path and also the cache path and NO I don't have a smile on my lips, man. I am looking at a screen that says:

This site is temporarily unavailable.?Please notify the System Administrator
2

has anyone any idea what's happening.
Thanks in advance


I am sure you thought of this, but check your configuration.php file again and look for $mosConfig_offline = 

If it says zero, change it to 1 ( think).  Heck, if it says 1, try changing it to zero.  See what happens. 

Beyond that, it could be a database issue.  I deleted my entire database once and my website would not going anywhere except to the site is temporarily unavailable page of Joomla. 

Another question, is it the "Joomla" maintenance page that has the Joomla logo, or is it a server error page, like a 500 error?  If it is the latter, than it probably is definitly a database or directory problem.  Check to make sure your absolute and relative paths are set again in your configuration.php file.  Double check.

_________________
From the beginning...


Top
 Profile  
 
PostPosted: Wed Nov 02, 2005 4:32 am 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Tue Aug 23, 2005 9:45 am
Posts: 687
Location: La Grande, Oregon
qbonoguy wrote:
I had that problem as well and it was just one of my settings... If I remember right I had put in the wrong database password in the config file... it was something like that...

I have another problem now though... the images in my images/stories directory aren't working... any ideas?


Sounds like you also have a directory problem somewhere.  What do you mean by not working?  Are all your images showing as an x on your website?  Make sure that the images folder got FTP'd to the right directory and make sure there are images in it. 

I found that with a few components (can't remember them all, but MosCE was one), there are directory settings in the configuration section in the back end.  If those don't get changed by opening the configuration or setting files (something.php in the administrator/components/ directory), then those components will not work in the backend. 

Check some of your components to see if they are working.  Check your configuration files again for the cache directory to make sure it is right.  But if your website is up and no images are showing, it definitely sounds like a directory issue.  Make sure your FTP program finished uploading your images directory without errors.

_________________
From the beginning...


Top
 Profile  
 
PostPosted: Wed Nov 02, 2005 4:10 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon Oct 31, 2005 9:32 pm
Posts: 17
charlwillia6 wrote:
gregko wrote:
I installed Joomla 1.0.3 locally (on my PowerBook that is) using MAMP as a SAS. Zipped the site and upload it to  my remote server. Unzipped it there using ssh terminal. Exported the database data with phpMyAdmin to a file and then uploaded this file successfully to the remote database  (which has the same name/user/pass as my local one). Changed the configuration.php, corrected the absolute and relative path and also the cache path and NO I don't have a smile on my lips, man. I am looking at a screen that says:

This site is temporarily unavailable.?Please notify the System Administrator
2

has anyone any idea what's happening.
Thanks in advance


I am sure you thought of this, but check your configuration.php file again and look for $mosConfig_offline = 

If it says zero, change it to 1 ( think).  Heck, if it says 1, try changing it to zero.  See what happens. 

Beyond that, it could be a database issue.  I deleted my entire database once and my website would not going anywhere except to the site is temporarily unavailable page of Joomla. 

Another question, is it the "Joomla" maintenance page that has the Joomla logo, or is it a server error page, like a 500 error?  If it is the latter, than it probably is definitly a database or directory problem.  Check to make sure your absolute and relative paths are set again in your configuration.php file.  Double check.



First, thank you all for your help.
I tried the <$mosConfig_offline => change, didn't work.
I am afraid it is a database issue and has to do with the Collation in the My SQL. I 'll let you know.
Thanks again


Top
 Profile  
 
PostPosted: Wed Nov 02, 2005 11:33 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Tue Aug 23, 2005 9:45 am
Posts: 687
Location: La Grande, Oregon
Try deleting the database and exporting your database on your local machine again with different settings.  And then when you import into your new site, make sure you pick latin1 for your language (or whatever your MySQL settings were collated for).

_________________
From the beginning...


Top
 Profile  
 
PostPosted: Thu Nov 03, 2005 4:26 am 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast
Offline

Joined: Mon Oct 10, 2005 7:09 am
Posts: 212
Location: Payyannur, Kannur, Kerala,India
qbonoguy wrote:
I had that problem as well and it was just one of my settings... If I remember right I had put in the wrong database password in the config file... it was something like that...

I have another problem now though... the images in my images/stories directory aren't working... any ideas?


hi,

Sorry for delay, got a bit busy.

i too faced a situation like this. just  it might be that you uploaded the image via joomla to the server folder and the owner group it takes byt default is some 99 and you are not in that group.

Try to move the iamges to one of your folders manually and it would give you permission to access.

I tried this and it worked.

Wishing you a nice day.
regards
Harish

_________________
Technology to Solutions ( Skype : holy.geek_saffrongeek )
Given enough eyeballs , All bugs are shallow.
Collecting data is only the first step toward wisdom. But sharing data is the first step toward community


Top
 Profile  
 
PostPosted: Thu Nov 03, 2005 10:50 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon Oct 31, 2005 9:32 pm
Posts: 17
hbmarar wrote:
hi,

scene : importing the database from dump file to remote server
Issue #1: Default charachter set latin1 collate latin1_general_ci
Reason: { 1. Mysql versions difference, [invites suggestions] }
Refernce : a snap of error attached.

Well, searching the mysql server for the solution took me to a thread. But that was informative. Now the error could be solved in simple way:-

    Open your sql dumpfile in wordpad ( Wordpad is said to support unix characters and do a search for the following keyword for replace:-
collate latin1_general_ci and replace it with a space.

    Now once you hae replaced all occurrences you so another search for 'Collate latin1_general_ci' and replace those occurences too.Now try to import, YOu are displayed

    "  Your SQL query has been executed successfully  and The content of your file has been inserted and [number] of instructions."




First I want to thank you for the help you provide to this board.
Can you tell me what thread you took that led you to the 'Collate latin1_general_ci' replacement trick?
Because that didn't work for me. I have UTF8 encoding both locally and remotely for MySQL dbs and when I try to upload the local dump I get this screen


You do not have the required permissions to view the files attached to this post.


Top
 Profile  
 
PostPosted: Thu Nov 03, 2005 10:58 am 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Tue Aug 23, 2005 9:45 am
Posts: 687
Location: La Grande, Oregon
I am not sure why it isn't working for you gregko.  On my local machine my database automatically makes it latin_1.  My server MySQL tries to make it UTF-8, but I changed it when I uploaded to latin_1. 

If you have opened up your exported sql file and it says UTF-8, and your server is trying to take it as UTF-8, I am not sure what the problem is.  In all actuallity, you want it to be UTF-8 since that is a form of unicode for other languages.  I wish I could help you, but I am not sure about all the error syntax's that MySQL gives.  You might want to look it up at the MySQL website.

_________________
From the beginning...


Top
 Profile  
 
PostPosted: Thu Nov 03, 2005 6:57 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon Oct 31, 2005 9:32 pm
Posts: 17
Well, charlwillia6
I think I know what's happening and I really don't know why anyone else isn't mentioning this, after all I am a newbie.
The thing is that both versions of MySQL (local and remote) must be identical if you want the site you upload (move) to be functional 100%!!!
In my case the local MySQL version is 4.1.12 (the one that comes within the MAMP stand alone server) while the MySQL that runs on my provider's server is 3.23.58 which has a different structure. That fact causes all the problems and I don't think that by the "replacement trick" mentioned above one can be certain.
If anyone thinks different I would like to know.
Thanks again for your concern.


Top
 Profile  
 
PostPosted: Thu Nov 03, 2005 10:26 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Tue Aug 23, 2005 9:45 am
Posts: 687
Location: La Grande, Oregon
Well, I am not sure.  This is the first time I have used PHP and MySQL ever.  I am definitely not an expert.  By I am using a newer version of MySQL on my computer than my host has set up.  But my host still has MySQL 4.0xx, so maybe since it is newer, that is why I had no problems.  You may be right.

_________________
From the beginning...


Top
 Profile  
 
PostPosted: Fri Nov 04, 2005 4:54 am 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast
Offline

Joined: Mon Oct 10, 2005 7:09 am
Posts: 212
Location: Payyannur, Kannur, Kerala,India
gregko wrote:
Well, charlwillia6
I think I know what's happening and I really don't know why anyone else isn't mentioning this, after all I am a newbie.
The thing is that both versions of MySQL (local and remote) must be identical if you want the site you upload (move) to be functional 100%!!!
In my case the local MySQL version is 4.1.12 (the one that comes within the MAMP stand alone server) while the MySQL that runs on my provider's server is 3.23.58 which has a different structure. That fact causes all the problems and I don't think that by the "replacement trick" mentioned above one can be certain.
If anyone thinks different I would like to know.
Thanks again for your concern.


hi  gregko,

      It is the version differces that is causing the issue.As you said, the version you are  using is higher than the provider's version and if i am correct from 4.1 the collation concept is there.I too do not know it in depth but when you try to import a file created by the higher version in to a lower version the error comes.I have faced the error which i have posted only.I would try to troubleshoot(if it is possible only) a similiar one later and update you.

       
regards
Harish

     

_________________
Technology to Solutions ( Skype : holy.geek_saffrongeek )
Given enough eyeballs , All bugs are shallow.
Collecting data is only the first step toward wisdom. But sharing data is the first step toward community


Top
 Profile  
 
PostPosted: Fri Nov 04, 2005 7:36 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon Oct 31, 2005 9:32 pm
Posts: 17
Thank you Harish


Top
 Profile  
 
PostPosted: Sat Nov 05, 2005 7:24 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon Oct 31, 2005 9:32 pm
Posts: 17
hbmarar wrote:
hi,

scene : importing the database from dump file to remote server
Issue #1: Default charachter set latin1 collate latin1_general_ci
Reason: { 1. Mysql versions difference, [invites suggestions] }
Refernce : a snap of error attached.

Well, searching the mysql server for the solution took me to a thread. But that was informative. Now the error could be solved in simple way:-

    Open your sql dumpfile in wordpad ( Wordpad is said to support unix characters and do a search for the following keyword for replace:-
collate latin1_general_ci and replace it with a space.

    Now once you hae replaced all occurrences you so another search for 'Collate latin1_general_ci' and replace those occurences too.Now try to import, YOu are displayed

    "  Your SQL query has been executed successfully  and The content of your file has been inserted and [number] of instructions."




If you run into Mysql versions differences, I strongly suggest you use phpMyAdmin 2.6.4-pl3 where you have the option to use "the SQL export compatibility" button as you can see in the attached gif.


You do not have the required permissions to view the files attached to this post.


Top
 Profile  
 
PostPosted: Sat Nov 05, 2005 7:33 am 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast
Offline

Joined: Mon Oct 10, 2005 7:09 am
Posts: 212
Location: Payyannur, Kannur, Kerala,India
hi gregko,

          I believe that solved your issue and now you are having a nice time.Thanks for sharing the information.

regards
Harish

_________________
Technology to Solutions ( Skype : holy.geek_saffrongeek )
Given enough eyeballs , All bugs are shallow.
Collecting data is only the first step toward wisdom. But sharing data is the first step toward community


Top
 Profile  
 
PostPosted: Sun Nov 06, 2005 4:12 am 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Fri Oct 21, 2005 7:37 pm
Posts: 31
This is not working out for me, can someone explain what I'm missing?

One one machine I installed Joomla, created my skin, did stuff and got it to the point where I'm ready to go live. The database is stored on a separate server, not the web server. The database I used for development will be the same as for production.

On the production web server I did rsync -avl devserver:/path/to/Joomla /final/path/to/Joomla and copied over the entire Joomla install directory. I ran chown -R on all of the files to set the correct owner and group. The permissions are the save as on the development server for no change needed there.

I edited configuration.php and changed the URLs to the production urls and the paths to the production path. The database settings are the save so I didn't change those.

When I try to go to / with my browser I'm told it can't find a template. When I go to the administrator I can't login.

I can still access the Joomla install on the development web server, I get all of the contant and can login to the administrator just fine. I just can't do it from the production server (again same database and server, not a copy).

Anyone? I saw someone had the same symptoms (template error) but I haven't for the answer to it yet.


Top
 Profile  
 
PostPosted: Sun Nov 06, 2005 5:50 am 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Fri Oct 21, 2005 7:37 pm
Posts: 31
I get lots of these (5):

mysql_query(): Unable to save result set in /data/httpd/s2ki.com/Home/includes/database.php on line 265

in my php error log when I try to load the site with the browser.

I am able to connect to the database server fine using mysql:

$ mysql -h server -u joomla -p joomla

select * from jos_content; works fine so I know the database parameters in configuration.php are correct and the permissions are fine from the server to the database (at least as far as mysql client are concerned).

I know PHP is working because the server is running Mambo, IPB and several other apps all day long (still is).

I downloaded a fresh copy of Joomla 1.0.3 and unpacked it in a diectory on the production server right next to the copy I'm trying to get working. I ran through step one of te install to check that PHP was configured ok for Joomla and it said all versions were ok apache 2.0/PHP 4.3/Mysql 4.1, all modules were there (mysql, XML, zLib) and that the PHP ini settings were correct.

Still nothing...


Top
 Profile  
 
PostPosted: Sun Nov 06, 2005 12:47 pm 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast
Offline

Joined: Mon Oct 10, 2005 7:09 am
Posts: 212
Location: Payyannur, Kannur, Kerala,India
hi ,

  Issue: I would like to use different templates for differnet components and also differ the templates / make subtemplates for the task that is getting generated.
  solution:

  switch($option)

        case "com_registration":
                  if ($task=="lostPassword")
                            require_once( password template.);
                  else                     
                        normal registration template
          default:
              default tamplate
              break;

Hoping that there would be someone out there looking for this information now or later,

Wishing you all a great weekend

Harish

_________________
Technology to Solutions ( Skype : holy.geek_saffrongeek )
Given enough eyeballs , All bugs are shallow.
Collecting data is only the first step toward wisdom. But sharing data is the first step toward community


Top
 Profile  
 
PostPosted: Sun Nov 06, 2005 3:50 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Fri Oct 21, 2005 7:37 pm
Posts: 31
I fixed my issue: The database is set up with a latin1 character set and latin1_general_ci collation. This is the default for most PHP/MySQL installations. My production web server however is setup to default to using utf8 and utf8_general_ci for it's database connections. To resolve this I edited includes/database.php and changed the character set and collation of the connection after connecting to latin1 and latin1_general_ci. Works great now :)

If you look in includes/database.php around line 90 you will see a commented line similar to "// @mysql_query("SET NAMES 'utf8'", $this->_resource);

After that I added:

@mysql_query("SET NAMES latin1", $this->_resource);
@mysql_query("SET CHARACTER SET latin1", $this->_resource);
@mysql_query("SET COLLATION_CONNECTION='latin1_general_ci'", $this->_resource);

To force the character set and collation type for the connection to what I wanted. All is working well and the install is running in production now :) http://www.s2ki.com if you are interested.

Sorry for the poor grammar and spelling in my previous posts. I've been working on this for 3 solid weeks dawn to dusk and am a little pooped.


Last edited by cthree on Sun Nov 06, 2005 3:52 pm, edited 1 time in total.

Top
 Profile  
 
PostPosted: Sun Nov 06, 2005 3:51 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Fri Oct 21, 2005 7:37 pm
Posts: 31
I think there is a component/module for this. Check the forge.

hbmarar wrote:
hi ,

  Issue: I would like to use different templates for differnet components and also differ the templates / make subtemplates for the task that is getting generated.
  solution:

  switch($option)

        case "com_registration":
                  if ($task=="lostPassword")
                            require_once( password template.);
                  else                     
                        normal registration template
          default:
              default tamplate
              break;

Hoping that there would be someone out there looking for this information now or later,

Wishing you all a great weekend

Harish




Top
 Profile  
 
PostPosted: Sun Nov 06, 2005 7:16 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon Oct 31, 2005 9:32 pm
Posts: 17
cthree wrote:
...
If you look in includes/database.php around line 90 you will see a commented line similar to "// @mysql_query("SET NAMES 'utf8'", $this->_resource);

After that I added:

@mysql_query("SET NAMES latin1", $this->_resource);
@mysql_query("SET CHARACTER SET latin1", $this->_resource);
@mysql_query("SET COLLATION_CONNECTION='latin1_general_ci'", $this->_resource);

To force the character set and collation type for the connection to what I wanted. All is working well and the install is running in production now :) http://www.s2ki.com if you are interested.

Sorry for the poor grammar and spelling in my previous posts. I've been working on this for 3 solid weeks dawn to dusk and am a little pooped.

Thanks for sharing the info.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 61 posts ]  Go to page 1, 2, 3  Next



Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group