MySQL export/import problem

[silurius]

Migrating my site from one domain to another and using phpMyAdmin to do the database export/import. I'm a little rusty on this as I've been relying on application exports for a while for other systems.

My existing site is running fine but after I performed a dump of my db using the following options (default) and imported it into the new db, I tested it out on my new domain and ran into a 404 Not Found error and found myself on "/cgi-system/index.php/index/install".

Running: MySQL 5.0.18, phpMyAdmin 2.6.4-pl3

Any ideas as to what I did wrong?



One thing I can say is the total db sizes are about 500k off, even though I selected all tables.

[asmecher]

Hi silurius,

It looks like your new system doesn't properly handle URLS using path_info; this isn't related to the database dump and reload. Search the forum for path_info and you'll find a number of threads on the subject. You can configure OJS so that it doesn't rely on path_info, but the URLs will be uglier.

Regards,
Alec Smecher
Open Journal Systems Team

[silurius]

Before I run down that path, I thought I would mention that I did not change hosts, just domain names. So I don't believe this issue would be related to my environment.

[asmecher]

Hi silurius,

Hmm, something is odd about your environment. Basically, when you point your browser to an unconfigured installation of OJS (i.e. to http://myserver.com/index.php), OJS will redirect to the installation page, which is at http://myserver.com/index.php/index/install. This all happens without OJS ever trying to connect to the database, as an unconfigured OJS installation doesn't yet know what kind of database it's using.

The redirect is sending you to a non-existent page, hence the 404 error. Is OJS actually installed in a subdirectory called cgi-system, or is that what's causing the problem?

Regards,
Alec Smecher
Open Journal Systems Team

[silurius]

The site is running in the root. Your comments got me thinking about environmental settings which I had not examined during this issue, and lo and behold I found that my previous domain had PHP as CGI disabled, and the new domain was running PHP as CGI which is default. New domain now is not running PHP as CGI, but now when I hit the root I get...
EDIT
Aha, found it. Although my files migrated over without apparent error, I just re-uploade the cache folder and the problem has been fixed. Sorry for wasting your time!

[silurius]

I spoke too soon. I'm now getting taken to http://www.mysite.com/index.php/index/install when I attempt to hit the main site (index.php).

I noticed that the file permissions needed to be fixed again as indicated by that page, so I did so but still get taken there. Given that this is an existing database, I am not willing to allow the install script to run at this point. Advice?

Edit: I've re-copied everything and exported/imported the db again, same status.

Thanks!

[asmecher]

Hi Silurius,

Check your config.inc.php -- there should be an "installed" setting. If this isn't set to On, or if OJS can't access the configuration file, you'll be redirected to the install page. If you've configured your installation manually (i.e. filled in database configuration in config.inc.php), just set installed to On and you should be fine.

Regards,
Alec Smecher
Open Journal Systems Team

[silurius]

Whoohoo, at last. You win the prize:

Code: Select all

; Set this to On once the system has been installed
; (This is generally done automatically by the installer)
installed = Off

I guess my original install was running fine with this flag the way it was, but then for some reason the new instance noticed the flag when I moved everything?