OSCommerce

[klachman]

I need instructions, the more detailed the better for installing OSCommerce on Hostgator here.

I have already installed the OSC version from Fantastico as a 'test' and it works fine, but for some reason I cannot seem to access my admin panel.
I dont want to spend much time on the Fantastico version, as I have my own OSC website, developed on my own machine with a LAMP server (XAMPP), that is 90% functional, including its own databse conversion tools, and heavily modded, and now I want to take this online, hash out the last of the 'bugs' and bring this live.

I see the fantastic version is dated 2010, but mine is originally from 2008. If there are any search and replaces for deprecated functions a list, or a poiter to a script would be much appreciated.

I'm on shared hosting, Commercial.

Are we allowed to run scripts here?
I got a 'jailed' error just trying to run a file count script here!

I am somewhat familiar with WinXP, Fedora, Ubuntu, Mint and Mandriva, but havent a clue to CentOS!

I did google a page that looked promising only to find it was removed

[klachman]

Just wanted to add that I removed and reinstalled the default Fantastico OSC, and seen where I may have goofed earlier, and that it only accepts 8 character passwords.

However in reinstalling and putting in my 'normal' user name and a new password, it still wont let me log in.

Once again this is not MY site, but the default one....

[laudenbachm]

Just for shiggles have you tried another browser?

Any error messages? did you check logs?

Mark

[klachman]

I uninstalled the Fantastico version, as I figured that I might as well jump in to the mud puddle and just upload the OSC 2.2rcA website I have, as I might be spinning wheels on the Fantastico 2.3 and I have too darn many mods to simply start afresh.

So far I am running into some very basic problems....

I am transferring OSC from an XAMPP setup.
There the web root was 'htdocs' - here is is 'public_html'.
Fine, just copy everything from htdocs to public_html.

First error, no password in database.
OK, went to configure.php and put password in.

Now error is that it cannot find database.

I tried to import my last website database backup, but it tries, and just error with 'no database selected'.
I havent tried to import my phpmyadmin backup, as I'm not sure its safe.
I am totally new to online hosting so havent a clue what to do here.
And it doesnt help that I havent been using the local website for over a year and am a bit rusty!


So, in a nutshell, I am flying blind here trying to transfer an OSC 2.2 local site from a Windoze LAMPP app (XAMPP) to Hostgator, and dont want to mess things up too much!

There is probably a simple FAQ somewhere on how to do this, but I have changed local machines after a crash, and while I was able to save the site, most of my docs went down in flames.....

[klachman]

Me again.

I knew there was something funny about that CPanel here.
No 'new DB' option, so had to go to MySQL option to create the database.
It insists on prepending my user name, so don't know how many files other than config.php's in OSC that I need to change for the DB name!.

On importing the old website database it gives the error:

------------------------------
Error
SQL query:
CREATE TABLE products_description(
products_id int( 11 ) NOT NULL AUTO_INCREMENT ,
language_id int( 11 ) default '1' NOT NULL ,
author text,
products_name text,
products_description text,
products_url varchar( 255 ) ,
products_viewed int( 5 ) default '0',
pub_info text,
isbn_13 text,
keywords text,
PRIMARY KEY ( products_id, language_id ) ,
KEY products_name( products_name )
);
MySQL said: Documentation
#1170 - BLOB/TEXT column 'products_name' used in key specification without a key length
----------------------------------------

[striddy]

Originally Posted by klachman

Me again.

I knew there was something funny about that CPanel here.
No 'new DB' option, so had to go to MySQL option to create the database.
It insists on prepending my user name, so don't know how many files other than config.php's in OSC that I need to change for the DB name!.

On importing the old website database it gives the error:

As this is application specific help you are asking for, you might get more expert help by asking for help on the OSCommerce forum. Ask how to "move oscommerce to another server with cpanel".

A couple of tips which may help you or readers of this thread in the future. OSCommerce is a database driven website. In other words there are files and a database that make up the website.

You say you have copied your files to public_html. Well done. You also need to create a database, create a database user, and add that database user to the database with full permissions. Only then can you import an existing mysql database from another server, or from a backup, to this new blank database.

Cpanel prepends your new database name and database user with the cpanel username and an underscore. ( cpanelusername_ )

[klachman]

The OSC forum can be a little funny.
I searched through them, but could not find anything specific as to what I needed. And they are infamous for ignoring some fairly basic questions.

I ran into 3 basic problems here:

MySQL here, apparently does not like too many statements in one query, had to choose the option to disable extended inserts in exports.

The registered globals setting caused a problem in application-top.php, which required replacing some code ( googled the error message there).

But most important was the fact was that while Hostgator has historically advertized on OSC info sites, and does in fact provide OSCommerce 2.3 installed from Fantastico, there are no FAQs I could find for migrating it from a LAMPP server on a local machine such as XAMPP.
My 2.2 setup was heavily modded, so starting fresh from 2.3 was simply not an option.

The major problem I had was with the configure.php's. The sample files I was able to find were as clear as mud, and even contradictory. Live help tried to be helpful, but were apparently unfamiliar with the files.

What I needed to do was to move all my OSC files out of public_html, install Fantastico's OSC, download it, wipe it, replace my own OSC and use the OSC 2.3 configure.php's as a template and hope they would work (with a few mods of course for the database) in the old version.
They did.

The site is still in test phase, as I need to work out a few bugs and add a few features, best done from a 'real' server - but it functions now on HG exactly as it does locally.

Unfreakingbelievable especially as I expected ALOT more problems.
I had to do a double take when I seen that HG was still on PHP 5.29 which meant NO PROBLEMS for my older OSC version.

I cannot fault live support for being unfamiliar with some somewhat obscure files. But I can commend them for being spot on for noticing that an apparently unrelated error (to me) was due to MySQL not fully importing my database.

[klachman]

One other thing, for those wishing to migrate an OSCommerce site here:

OSC v2.x installs into the web root directory (public_html, www, or htdocs). It creates two directories: catalog and extras.

However Fantastico's OSC 2.3 omits the /catalog directory and moves everything up one level.

Using their directory structure works with my 2.2 version, especially as I used their configure.php's . It makes the difference between the live site being ~/index.php or ~/catalog/index.php