Joomla! Discussion Forums



It is currently Wed Nov 25, 2009 8:47 pm (All times are UTC )

 




Post new topic Reply to topic  [ 301 posts ]  Go to page Previous  1, 2, 3, 4, 5 ... 11  Next
Author Message
Posted: Thu Jan 26, 2006 5:02 pm 
User avatar
Joomla! Virtuoso
Joomla! Virtuoso
Offline

Joined: Thu Aug 18, 2005 10:27 am
Posts: 3928
Location: Sunny City Cebu, Philippines!
@raymond, 2 options i can think of:

1. break up your uploads of dump into per tables. or one table at a time.. if lets say; one table is already 50mb.. so dump that table then do that same thing with others. you can make just particular dumps of a table correct? then then can be a solution.

2. use another mysql db application to directly edit the tables and db's you got on remote.. i use navicat(its commercial application though) for organizing HUGE db's.. just search google for it. :)

- 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.
^If u cant read that, you clearly missed the HIGHLIGHTS!
www.backspace.ph | www.joomlaconsultancy.net


Top
  E-mail  
 
Posted: Thu Jan 26, 2006 7:30 pm 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast
Offline

Joined: Tue Jan 24, 2006 3:24 pm
Posts: 240
Location: Philippines
Thanks gulliam! I've looked it up and it looks ok. I've found two other solutions while googling.
It seems you can set the maximum size of the DB using some phpMyAdmin config settings. Its on their site's faqs.
Also, there's BigDump which can be found at http://www.ozerov.de/bigdump.php. With this, you're supposed to upload the .gz SQL file and the bigdump.php files onto your webserver and then run go to the bigdump webpage. It seems to load the data incrementally from the website itself. Don't know if it works but I'll post my experiences when I hit the 52Mb barrier. Its supposed to raise your webserver's processing load, though. That might be a problem if your webserver complains  :P

Again, thanks for the tips! This is really a great community. No wonder open source continues to develop despite the lack of megabucks like, say, that other guy from Redmond.  :o

_________________
http://www.santosestrella.com
Santos Estrella Personal Site
http://www.thecorpusjuris.com
The online repository of Philippine law, jurisprudence, administrative issuances and legal research tools.


Top
  E-mail  
 
Posted: Fri Jan 27, 2006 8:16 pm 
User avatar
Joomla! Virtuoso
Joomla! Virtuoso
Offline

Joined: Thu Aug 18, 2005 10:27 am
Posts: 3928
Location: Sunny City Cebu, Philippines!
@raymond,.. great to hear you found that bigdump. havent tried it yet.. but may try it soon as an alternative to my ways of dumping big chunks of db.

SECOND, yes OPEN SOURCE will always be here for you and the community. its the people like YOU who make this community a reality. :)

BOTTOM LINE-> dont wonder why joomla forums has 20,000 members in less than 6 months :) amd still getting stronger each day.

- 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.
^If u cant read that, you clearly missed the HIGHLIGHTS!
www.backspace.ph | www.joomlaconsultancy.net


Top
  E-mail  
 
Posted: Sat Jan 28, 2006 11:23 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Thu Jan 19, 2006 12:30 am
Posts: 20
I am about to post my site, developed locally with JSAS, to my server, http://www.1and1.com - can I do that through Joomla itself if I have the logon of my server? This is all a test and not critical or live site. Reference to a tutorial would be lovely - I am so new to CMS and Joomla that it is scary and I probably have no business doing it, except I run sites for about 10 nonprofits and would LOVE to have a better way of managing them. A nice step by step, tutorial would be great. I am using Windows XP, JSAS 1.0.3, and Joomla 1.0.7 (upgraded).

_________________
The fascination of learning a new tongue means...above all, entering its culture. Because culture is where the dictionary ends and where we find real meaning, crossing over into the life and world of another people. -- C.J. Moore, 2005


Top
  E-mail  
 
Posted: Sun Jan 29, 2006 12:37 am 
User avatar
Joomla! Virtuoso
Joomla! Virtuoso
Offline

Joined: Thu Aug 18, 2005 10:27 am
Posts: 3928
Location: Sunny City Cebu, Philippines!
check this one for reference for JSAS --> http://forum.joomla.org/index.php/topic,32577.0.html

ask your particular question on that thread since youre both using JSAS.

- 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.
^If u cant read that, you clearly missed the HIGHLIGHTS!
www.backspace.ph | www.joomlaconsultancy.net


Top
  E-mail  
 
Posted: Wed Feb 01, 2006 6:52 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Tue Nov 15, 2005 3:12 am
Posts: 6
Hello,

I am getting the dreaded number 2 error. the server is split into 2 different servers. a mysql sever and a web app server. I can connect to the DBl fine via its external IP. however, when using the same information in joomla i get no connection.

is there more testing i can be doing?

I tried connecting to the sql via the mysql command interface on the web app server. however im not sure if i had the syntax correct. i'm still a newbie.

--edit-- i should say that i have changed my configuration.php file for the new setup
here are the fields i changed

$mosConfig_user = 'j_user';
$mosConfig_password = 'password';
$mosConfig_host = '*.*.*.48'; -- set to the local address
$mosConfig_db = 'j_database';

did i miss anything?


Last edited by quiiver on Wed Feb 01, 2006 7:01 pm, edited 1 time in total.

Top
  E-mail  
 
Posted: Wed Feb 08, 2006 5:42 am 
User avatar
Joomla! Virtuoso
Joomla! Virtuoso
Offline

Joined: Thu Aug 18, 2005 10:27 am
Posts: 3928
Location: Sunny City Cebu, Philippines!
$mosConfig_host -> its usually 'localhost' ;)

additionally check the values of the following:

$mosConfig_cachepath -> not very impt however its usually the absolute path followed by '/cache'
$mosConfig_absolute_path -> the path where the joomla index.php or the joomla folder is located
$mosConfig_db -> the name of the db
$mosConfig_dbprefix  --> usually 'jos_' however if migrated from mambo its value is 'mos'
$mosConfig_live_site -> the URL in which the joomla site is viewable in the browser
$mosConfig_user  --> user name you use to connect to the db.

you may want to check this quickie file to resolve the absolute path if youre lost figuring what youre absolute path is:

http://forum.joomla.org/index.php/topic ... #msg185563

dl the zip file i attached on that 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.
^If u cant read that, you clearly missed the HIGHLIGHTS!
www.backspace.ph | www.joomlaconsultancy.net


Top
  E-mail  
 
Posted: Wed Feb 08, 2006 9:04 am 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Sat Aug 20, 2005 8:53 am
Posts: 803
Location: Italy
guilliam wrote:

instructions on how to move the files can be read here:

cronlin wrote:
To move your Mambo site from either one folder to another or one server to another, here are a few basics.


    * Copy over your files, either via ftp or SSH/command line
    * Backup and then restore your database - perhaps using phpmyadmin or SSH/command line
      (this step only needed if moving site from one server to another.
    * Edit your configuration.php file to reflect the new values. Specifically the following:
     
Quote:
      $mosConfig_user = 'joomla_joomla';
      $mosConfig_password = 'password';
      $mosConfig_db = 'joomla_joomla';
      $mosConfig_absolute_path = '/home/joomla/public_html';
      $mosConfig_live_site = 'http://www.joomla.org';
      $mosConfig_cachepath = '/your absolute path/cache';



$mosConfig_user  --> user name you use to connect to the db. DO YOU MEAN THE HOST USER, DON'T YOU ? NOT THE JOOMLA ADMIN USER 
$mosConfig_password = 'password'; SAME AS BEFORE, RIGHT ?!
$mosConfig_db -> the name of the db
$mosConfig_absolute_path -> the path where the joomla index.php or the joomla folder is located FOUND USING YOUR INFO.PHP SCRIPT
$mosConfig_live_site -> the URL in which the joomla site is viewable in the browser IS IT MY DOMAIN, ISN'T IT?
$mosConfig_cachepath -> not very impt however its usually the absolute path followed by '/cache' DON'T KNOWING I JUST ADD /cache AT THE END OF THE ABSOLUTE PATH

WHAT IS ? :
$mosConfig_host = '*.*.*.48'; -- set to the local address

IS THERE OTHER TO KNOW TO CHANGE IN CONFIG.PHP ?

AND, PLEASE, AFTER MOVED FROM LOCAL TO REMOTE, WHICH IS THE BEST SISTEM TO WORK ?
WORK IN LOCAL AND UPGRADE REMOTE ? HOW DO IT ?

Many Thanks  :-[


Last edited by eGulp on Wed Feb 08, 2006 9:17 am, edited 1 time in total.

Top
  E-mail  
 
Posted: Wed Feb 08, 2006 10:34 am 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Sat Aug 20, 2005 8:53 am
Posts: 803
Location: Italy
mumble mumble ...

I tried the Dump following guilliam instructions:

Loalhost:                    Remote
Easy PHP 1.8.01         
PHP 4.3.10                4.4.1
mySQL 4.1.9              4.0.25
PhpMyAdmin 2.6.1      2.6.4 pl2

(hoping I been able to check right)

Importing database I have back this message:
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=4' at line 37

What am I missing  ??? 


Top
  E-mail  
 
Posted: Wed Feb 08, 2006 10:42 am 
User avatar
Joomla! Virtuoso
Joomla! Virtuoso
Offline

Joined: Thu Aug 18, 2005 10:27 am
Posts: 3928
Location: Sunny City Cebu, Philippines!
$mosConfig_host -> its the path to where the web app to be pointed. in which this is "typically" valued as 'localhost' in which localhost is the defualt address to point to the same box/computer/server/host or in lay man's term localhost is to point to its SELF. co-value of this is 127.0.0.1 which is a "loopback address". you might be wondering why is this a variable in the configuration.php of joomla? well.. since Joomla is aimed to be cross platform and cross compatible with host/server environments it is made to a variable since NOT all servers/host are a like. another reason is for MULTI and CROSS install of joomla to another box(networked) in which the database server is separated from the file server(however this is more advance install and barely happens to newbies ;) ).


2. IS THERE OTHER TO KNOW TO CHANGE IN CONFIG.PHP? -> its basically what i pointed out are the important things to check and double check, others can be changed in the global config in the joomla admin once you logged in.

3.  AND, PLEASE, AFTER MOVED FROM LOCAL TO REMOTE, WHICH IS THE BEST SISTEM TO WORK ? -> i dont understand what oyu mean by SYSTEM?

4. WORK IN LOCAL AND UPGRADE REMOTE ? HOW DO IT ? -> you may want to check the thread here -> http://forum.joomla.org/index.php/topic,36488.0.html

btw.. refrain from using all caps(ALL CAPITAL LETTERS ;))

- 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.
^If u cant read that, you clearly missed the HIGHLIGHTS!
www.backspace.ph | www.joomlaconsultancy.net


Top
  E-mail  
 
Posted: Wed Feb 08, 2006 10:45 am 
User avatar
Joomla! Virtuoso
Joomla! Virtuoso
Offline

Joined: Thu Aug 18, 2005 10:27 am
Posts: 3928
Location: Sunny City Cebu, Philippines!
doctorlife wrote:
Importing database I have back this message:
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=4' at line 37


try this(almost 100% failsafe to bypass that charset and encoding issue, also bypassing the mysql version issue) :

guilliam wrote:
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


- 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.
^If u cant read that, you clearly missed the HIGHLIGHTS!
www.backspace.ph | www.joomlaconsultancy.net


Top
  E-mail  
 
Posted: Wed Feb 08, 2006 11:33 am 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Sat Aug 20, 2005 8:53 am
Posts: 803
Location: Italy
guilliam wrote:
$mosConfig_host -> its the path to where the web app to be pointed. in which this is "typically" valued as 'localhost' in which localhost is the defualt address to point to the same box/computer/server/host or in lay man's term localhost is to point to its SELF. co-value of this is 127.0.0.1 which is a "loopback address". you might be wondering why is this a variable in the configuration.php of joomla? well.. since Joomla is aimed to be cross platform and cross compatible with host/server environments it is made to a variable since NOT all servers/host are a like. another reason is for MULTI and CROSS install of joomla to another box(networked) in which the database server is separated from the file server(however this is more advance install and barely happens to newbies ;) ).

3.  AND, PLEASE, AFTER MOVED FROM LOCAL TO REMOTE, WHICH IS THE BEST SISTEM TO WORK ? -> i dont understand what oyu mean by SYSTEM?


Many Thanks for information, ok step by step  ;)

configuration.php done  :) In fact now if you go to http://www.doctorlife.org you can see message "3" (DB not imported yet)

System: (Sorry for my bad English) I mean the best "how to do"

I'll take a look to the link and let you know there  :P

Sorry for all capital letters

Please, Could you give me more details for import DB, I understand the concept, but ... I'm really not sure on what you told me, in special I don't understand export copy and how to run the dump  :'(

Many Thanks 


Last edited by eGulp on Wed Feb 08, 2006 11:43 am, edited 1 time in total.

Top
  E-mail  
 
Posted: Wed Feb 08, 2006 11:58 am 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Sat Aug 20, 2005 8:53 am
Posts: 803
Location: Italy
If I understood:

from 1st DB I export it without compression and a text file is shown, I copied

to 2nd DB I entried into SQL then I past all text into "RUN SQL Query"

Same error:
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=4' at line 37

What I can do  ??? ...  :'(

May be try selecting a compatibility during SQL export ?
Please help me  :'(


Top
  E-mail  
 
Posted: Wed Feb 08, 2006 12:07 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Sat Aug 20, 2005 8:53 am
Posts: 803
Location: Italy
Here :
http://forum.joomla.org/index.php/topic ... #msg182934

I found a similar instructions with:
8 ) In the box for "Structure" check the boxes for "Add DROP TABLE" AND "Add IF NOT EXISTS".

but result don't change:
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=4' at line 19

Question:
Coping, have I to copy also the header text export ? :

-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: 08 Feb, 2006 at 01:01 PM
-- Versione MySQL: 4.1.9
-- Versione PHP: 4.3.10
--
-- Database: `doctorlife`
--

-- --------------------------------------------------------


Top
  E-mail  
 
Posted: Wed Feb 08, 2006 12:09 pm 
User avatar
Joomla! Virtuoso
Joomla! Virtuoso
Offline

Joined: Thu Aug 18, 2005 10:27 am
Posts: 3928
Location: Sunny City Cebu, Philippines!
make a new/blank mysql db.

if still no go,.. try playing with the character set of the new mysql db. set it to latin1
2nd, in your site1 uncheck/check those options regarding version etc..

im like shooting now where here ehhehe. can you post whats the mysql version of your site1 and site2? so i will have an idea what to do. :)

- 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.
^If u cant read that, you clearly missed the HIGHLIGHTS!
www.backspace.ph | www.joomlaconsultancy.net


Top
  E-mail  
 
Posted: Wed Feb 08, 2006 12:12 pm 
User avatar
Joomla! Virtuoso
Joomla! Virtuoso
Offline

Joined: Thu Aug 18, 2005 10:27 am
Posts: 3928
Location: Sunny City Cebu, Philippines!
okay were almost there.. (I HOPE :)) i got the version of site one -> Versione MySQL: 4.1.9
whats the mysql version of site 2?

- 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.
^If u cant read that, you clearly missed the HIGHLIGHTS!
www.backspace.ph | www.joomlaconsultancy.net


Top
  E-mail  
 
Posted: Wed Feb 08, 2006 12:19 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Sat Aug 20, 2005 8:53 am
Posts: 803
Location: Italy
doctorlife wrote:
Loalhost:                     Remote-online-server
Easy PHP 1.8.01         
PHP 4.3.10                 4.4.1
mySQL 4.1.9            4.0.25
PhpMyAdmin 2.6.1       2.6.4 pl2


Importing database I have back this message:
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=4' at line 37


Waiting your suggestion  :'(


Top
  E-mail  
 
Posted: Wed Feb 08, 2006 12:40 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Sat Aug 20, 2005 8:53 am
Posts: 803
Location: Italy
Ok,
I made some trials and selcting: MySQL 40 Compatibility during export I done dump, no errors during import

But message in http://www.doctorlife.org don't change : This site is temporarily unavailable. Please notify the System Administrator "3"
May be I forget something  ???

Also, may be is different if I select the two boxes as expained here  ??? :
http://forum.joomla.org/index.php/topic ... #msg182934
8 ) In the box for "Structure" check the boxes for "Add DROP TABLE" AND "Add IF NOT EXISTS".


Last edited by eGulp on Wed Feb 08, 2006 12:44 pm, edited 1 time in total.

Top
  E-mail  
 
Posted: Wed Feb 08, 2006 1:13 pm 
User avatar
Joomla! Virtuoso
Joomla! Virtuoso
Offline

Joined: Thu Aug 18, 2005 10:27 am
Posts: 3928
Location: Sunny City Cebu, Philippines!
oh thats a good sign.. so your prob now is only "3" it means:

Error 3 = FATAL ERROR: Database not found

check the name of the db in your configuration.php

- 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.
^If u cant read that, you clearly missed the HIGHLIGHTS!
www.backspace.ph | www.joomlaconsultancy.net


Top
  E-mail  
 
Posted: Wed Feb 08, 2006 2:16 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Sat Aug 20, 2005 8:53 am
Posts: 803
Location: Italy
:) that was !

I'm so stupid don't thinking creating sql DB username was been added as DB nome. Solved ! MANY THANKS  :)

But: what is better for export select or not select these during export:

""""In the box for "Structure" check the boxes for "Add DROP TABLE" AND "Add IF NOT EXISTS" """

or, leave as default  ???


Top
  E-mail  
 
Posted: Wed Feb 08, 2006 2:45 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Sat Aug 20, 2005 8:53 am
Posts: 803
Location: Italy
guilliam wrote:
4. WORK IN LOCAL AND UPGRADE REMOTE ? HOW to DO IT ? -> you may want to check the thread here -> http://forum.joomla.org/index.php/topic,36488.0.html


I checked that link but I haven't found nothing about ...  ???
What do you suggest me to work properly having an online site and the same in local ?
Is there an easy and quickly solution to work in local and upgrade the live site ?


Top
  E-mail  
 
Posted: Wed Feb 08, 2006 3:41 pm 
User avatar
Joomla! Virtuoso
Joomla! Virtuoso
Offline

Joined: Thu Aug 18, 2005 10:27 am
Posts: 3928
Location: Sunny City Cebu, Philippines!
its not actually called upgrade but MIGRATE to another host/server.

this is the easiest..

can you give us again what are the probs youre encountering?

- 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.
^If u cant read that, you clearly missed the HIGHLIGHTS!
www.backspace.ph | www.joomlaconsultancy.net


Top
  E-mail  
 
Posted: Wed Feb 08, 2006 5:21 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Sat Aug 20, 2005 8:53 am
Posts: 803
Location: Italy
Sorry Guilliam,
I'm been confused posting, so

1_site is running, all seem ok -> http://www.doctorlife.org (right now is down)

2_only a question because I found here around forums a suggestment to select these during DB export (dump):
""""In the box for "Structure" check the boxes for "Add DROP TABLE" AND "Add IF NOT EXISTS" """
is it better select or not ?

3_about Migrate: What I mean is that now I built my site in local and I have put it on-line, but, right now, when I want add components, add contents and/or try something ... what is better to do ? How do it ? How is better managing the site ?
Change things in local and than put online ?! Is there a better way to sincronize them ?

Hoping I'm been more clear ...


Top
  E-mail  
 
Posted: Fri Feb 10, 2006 3:45 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Wed Jan 25, 2006 7:41 am
Posts: 24
Location: Cumberland, Maryland USA
Just a little note from a newbie:
I have followed Guilliam's fantastic post on backing up your database via phpMyadmin and have finally successfully backed up and moved my site to another server.

I just wanted to post a note of an issue I had and how it was resolved.
I was initially using Safari to export my database via phpMyadmin. When I attempted to download the DB as a compressed file (gzip), all I got was an uncompressed file. When I attempted to restore the DB, I got errors in phpMyadmin.

I then switched over to Firefox and was able to export the DB as a compressed gzip. When I restored from the gzip. Everything went very smoothly. PhpMyadmin must like the gzip version better.

I don't no if anyone else has had the same issue but from now on, I will only export the DB using Firefox as my browser so I can get the gzip file.

BTW, thanks much to Guilliam for his very clear and well instructed posts. I find his explanations to be the easiest to understand and implement from a newbie perspective. Thanks G!  :)


Top
  E-mail  
 
Posted: Sun Feb 12, 2006 5:29 pm 
User avatar
Joomla! Virtuoso
Joomla! Virtuoso
Offline

Joined: Thu Aug 18, 2005 10:27 am
Posts: 3928
Location: Sunny City Cebu, Philippines!
@eideas, thanks for the input regarding SAFARI, have made the walkthru for general audience(using i.e. of f.f.).. however thank you for the additional info that you get errors in safari. will take that noted and edit the first post to warn NOT to use safari for this.

@doctorlife, im really sorry,. i think its the language barrier that we have that i STILL cannot understand what youre trying to say. sorry.


- 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.
^If u cant read that, you clearly missed the HIGHLIGHTS!
www.backspace.ph | www.joomlaconsultancy.net


Top
  E-mail  
 
Posted: Sun Feb 26, 2006 2:28 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Wed Nov 02, 2005 12:56 pm
Posts: 47
These instructions have been great however I have found one big bug (from my point of view).  I created my articles using JoomlaFCK because of the image handling capabilities.  My pages on my local server look great.

However !!!! The absolute path is stored in the table jos_content so when I move my DB the paths to all my images do not work.

Why does Joomla not use relative paths like "images/stories" instead of "http://localhost/mysite/joomla/images/stories"

Any ideas and help on this to avoid any future problems would be appreciated


Top
  E-mail  
 
Posted: Fri Mar 10, 2006 6:15 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Sun Aug 28, 2005 11:23 am
Posts: 866
Location: New York
hello,

i followed this process of moving an offline db to an online location and got this error after clicking the SQL button to import the gzipped file.  any ideas please? i used jsas to develop offline site. 

EDIT 1:  The error was a 1064 error. 

EDIT 2:

Perhaps this has something to do with it - the phpmyadmin versions are different on offline and online server's?

JSAS 1.0.3 (the offline server) is:
phpMyAdmin 2.6.0-rc3
MySQL 4.1.14-nt running

Online it is:
phpMyAdmin 2.6.4-pl2
MySQL 4.0.25-standard running

EDIT 3 - Case closed, solution posted here ;)


Last edited by rw1 on Sat Mar 11, 2006 6:16 am, edited 1 time in total.

Top
  E-mail  
 
Posted: Fri Mar 10, 2006 6:43 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Fri Jan 27, 2006 11:49 am
Posts: 45
Location: Norway
doctorlife wrote:
Ok,
I made some trials and selcting: MySQL 40 Compatibility during export I done dump, no errors during import



Where do I select MySQL compability??

Rgds
Erik

_________________
http://www.norkirken.com


Top
  E-mail  
 
Posted: Sat Mar 11, 2006 8:23 am 
User avatar
Joomla! Intern
Joomla! Intern
Offline

Joined: Fri Aug 26, 2005 8:27 am
Posts: 79
Location: Westerlo
guilliam wrote:
@eideas, thanks for the input regarding SAFARI, have made the walkthru for general audience(using i.e. of f.f.).. however thank you for the additional info that you get errors in safari. will take that noted and edit the first post to warn NOT to use safari for this.

@doctorlife, im really sorry,. i think its the language barrier that we have that i STILL cannot understand what youre trying to say. sorry.


- g


There is nothing wrong with Safari !
But you need to turn of the 'Open safe files after downloading'. If checked Safari will automatically decompress the .zip files and delete the original.

Fonny


Top
  E-mail  
 
Posted: Thu Mar 16, 2006 4:45 am 
User avatar
Joomla! Virtuoso
Joomla! Virtuoso
Offline

Joined: Thu Aug 18, 2005 10:27 am
Posts: 3928
Location: Sunny City Cebu, Philippines!
Erik-Marius wrote:
doctorlife wrote:
Ok,
I made some trials and selcting: MySQL 40 Compatibility during export I done dump, no errors during import



Where do I select MySQL compability??

Rgds
Erik


check this quote from one of the thread reply i made:

guilliam wrote:


Image

^^that one, do you have that option?

- 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.
^If u cant read that, you clearly missed the HIGHLIGHTS!
www.backspace.ph | www.joomlaconsultancy.net


Top
  E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 301 posts ]  Go to page Previous  1, 2, 3, 4, 5 ... 11  Next

Quick reply

 



Who is online

Users browsing this forum: No registered users and 6 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 © 2000, 2002, 2005, 2007 phpBB Group