Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error with new hosting company (please help)


Guest

Recommended Posts

Hello Dear forumers,

 

Recently I moved from one hosting to another,

 

www.gbn.ge is hosted at servage and it works

 

I needed to remove database and the website to ixwebhosting.com

 

I did really removed database successfully and all the files to ixwebhosting.com FTP. To test it I did not moved domain name yet, I moved it to www.fx-sys.com to test how it will work and then I wanted to move domain as well, (of course I did change gbn.ge to fx-sys.com in config.php file)

 

well as you see I removed everything successfully but I have too problems

 

1. The font is not readable on ixwebhosting.com this is Georgian font, I had every file in UTF8 and I do not know why it is not readable

 

2. I cannot access in fx-sys.com/admin with the password for gbn.ge/admin

 

Please who are experienced people here help me with this issue

 

thanks in advance

Link to comment
Share on other sites

I even modified htaccess AuthUserFile /home20a/sub001/sc20035-XVQO/fx-sys.com/admin/.htpasswd

 

may be the problem is ome20a/sub001/sc20035-XVQO ???????

Link to comment
Share on other sites

Every server is different so it is probably looking for the password in a file that does not exist on your new server. Delete any password files that you created and set everything back to the way it was when you got it from the new host. Then in your control panel create a new password and protect your admin from scratch.

 

 

I have no idea about the other issue.

Link to comment
Share on other sites

Every server is different so it is probably looking for the password in a file that does not exist on your new server. Delete any password files that you created and set everything back to the way it was when you got it from the new host. Then in your control panel create a new password and protect your admin from scratch.

I have no idea about the other issue.

 

 

Hello thanks for reply

 

however I am not so advanced to understand what you suggested :)

 

please can you clarify for me

 

1. must I modify .HTACCESS file (if yes what should I do)

2. Must I modify .HTPASSWORD file (IF yes what should I do)

 

I am afraid I did not understand this sentence

 

Delete any password files that you created and set everything back to the way it was when you got it from the new host

 

I did not reinstalled oscommerce script on new server because I had too much contributions installed, I just removed files from one hosting FTP to another

 

So the question is how can I reset the old password to enter to admin and then how to create new password or how to enable so that I would be able to enter with old password with old server

 

thanks

Link to comment
Share on other sites

If you use .htaccess to store passwords such as those created by password protecting a directory with your hosts control panel you just have to recreate your password the same way, using your hosts control panel.

 

I would never try to move a password over from one server to another. Check your .htaccess file in your admin directory and see if it has any info relating to passwords. If it does remove that part (backup first) and then try create a new one via your hosts control panel.

 

By control panel I mean CPanel, Plesk, Helm, etc.

Link to comment
Share on other sites

At one time I set up all my OSCOMMERCE products on a FREE-SERVER... Things were great... Until i came into some scripting errors (i.e. register globals etc..) I found that my best solution to fix my scripting errors was to sign up for a paid hosting plan at a Reputible dealer, a big name such as GoDaddy.com

 

I thought it would be as simple as backing up my database and renaming it on the Godaddy servers(wrong), this didn't work one bit. I had to manually enter all my product data into the new servers database now(and that was just over 100 products to transfer).

 

Whatever you decide - I hope it works out but I needed to share my experience. My best advice is to set up a hosting/domain plan somewhere that you can trust (and reach when you have a customer service issues)

 

[Nothing is worse than trying to contact your hosting providers to change or upgrade your account and them not even reply to a question for over a week]

{Pick a provider that will deal with your problems immediately from the start and when there is a problem ask for help}

Link to comment
Share on other sites

Problem partially solved but still error

 

I created new .htaccess file in my host Cpanel and created new user and pass,

 

when I go to fx-sys.com/admin and write user and pass it seems it is accessing page but nothing appears only white page without oscommerce admin interface, I tried to access fx-sys.com/admin/newsdesk.php byt stil nothing white boring page wihtout any sourve

 

I thought it is problem of config.php in admin/includes because when I made new .htaccess the directory was named as /hsphere/local/home/fxtrader777/.htmaster/.ok_user while in config.php there is /home20a/sub001/sc20035-XVQO/fx-sys.com/

 

may be this are not similar things but more experienced webmasters can advise what's the matter

 

thanks

Link to comment
Share on other sites

I thought it is problem of config.php in admin/includes because when I made new .htaccess the directory was named as /hsphere/local/home/fxtrader777/.htmaster/.ok_user while in config.php there is /home20a/sub001/sc20035-XVQO/fx-sys.com/

 

Those changes need to be made in your configure.php files

define('DIR_FS_CATALOG'

 

that one is in your catalog/inlcudes/configure.php file. They will be different from server to server.

 

If all else fails remove your site and using fantastico install a new store and get your configure.php files from there.

 

If you have a backup of your DB and files (on your computer for sure) you can also try to download the osC version you have from the internet and just upload the install directory. Then make your configure.php files 777 and proceed to install it over top of your working site. It "should" (no responsibility for lost data so back up first) just rewrite your configure.php files and your DB which is easily uploaded again (from your backup of course).

 

If you install it from fantastico create a directory in your folder called test-store and install it there otherwise it will overwrite your current store.

 

I created new .htaccess file in my host Cpanel and created new user and pass,

 

Check your .htaccess file and see if there is anything there that might mess it up although .htaccess errors usually give 500 errors, not blank pages.

 

Also did you upload in ascii format or binary. Ascii is for files, binary is for images.

Link to comment
Share on other sites

No I cannot reinstall oscommerce

 

I have made so much contributions installed I cannot reinstall them one by one

 

isnot there other way to solve that problem

 

I do not know how to check this:

 

"Also did you upload in ascii format or binary. Ascii is for files, binary is for images."

 

as for blank page as it seems password works but is is problem with config.php or something else

 

Here is my config.php at fx-sys.com

 

<?php

/*

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

define('HTTP_SERVER', 'http://fx-sys.com'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://fx-sys.com');

define('HTTPS_CATALOG_SERVER', '');

define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', '/hsphere/local/home/fxtrader777/fx-sys.com/'); // where the pages are located on the server

define('DIR_WS_ADMIN', '/admin/'); // absolute path required

define('DIR_FS_ADMIN', '/hsphere/local/home/fxtrader777/fx-sys.com/admin/'); // absolute pate required

define('DIR_WS_CATALOG', '/'); // absolute path required

define('DIR_FS_CATALOG', '/hsphere/local/home/fxtrader777/fx-sys.com/'); // absolute path required

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

 

// define our database connection

define('DB_SERVER', 'mysql404.ixwebhosting.com'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'fxtrade_nick');

define('DB_SERVER_PASSWORD', 'Pqrn1923');

define('DB_DATABASE', 'fxtrade_gbn');

define('USE_PCONNECT', 'false'); // use persisstent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

define('CONFIG_TIME_ZONE', '+4:00'); // add 10 hours to the time in mysql server. Your location may require some other value

?>

 

 

here is at gbn.ge on servage

 

 

<?php

/*

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

define('HTTP_SERVER', 'http://gbn.ge'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://gbn.ge');

define('HTTPS_CATALOG_SERVER', '');

define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', '/home20a/sub001/sc20035-XVQO/gbn.ge/'); // where the pages are located on the server

define('DIR_WS_ADMIN', '/admin/'); // absolute path required

define('DIR_FS_ADMIN', '/home20a/sub001/sc20035-XVQO/gbn.ge/admin/'); // absolute pate required

define('DIR_WS_CATALOG', '/'); // absolute path required

define('DIR_FS_CATALOG', '/home20a/sub001/sc20035-XVQO/gbn.ge/'); // absolute path required

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

 

// define our database connection

define('DB_SERVER', 'mysql1024.servage.net'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'U5311513');

define('DB_SERVER_PASSWORD', 'P239740');

define('DB_DATABASE', 'U5311513');

define('USE_PCONNECT', 'false'); // use persisstent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

define('CONFIG_TIME_ZONE', '+4:00'); // add 10 hours to the time in mysql server. Your location may require some other value

?>

Link to comment
Share on other sites

When I go to http://fx-sys.com/ I get a site with Georgian Business News at the top and a bunch of ???? in the left column. All the links such as the newsdesk suff in the left column all link to gbn.ge. Does that make sense to you.

Link to comment
Share on other sites

When I go to http://fx-sys.com/ I get a site with Georgian Business News at the top and a bunch of ???? in the left column. All the links such as the newsdesk suff in the left column all link to gbn.ge. Does that make sense to you.

 

I know this and will correct

 

I did not want to leave website on fx-sys.com on fx-sys.com I am just testing how it removes from servage to ixwebhosting

 

when all tests are successful I transfer gbn.ge domain name form servage to ixwebhosting

 

before I do this I want to solve these two problems

 

1. language, (I entered to PHPmyadmin and that database collation is in latin1_swedish_ci, how can I change it to UTF8???)

 

2. admin is behaving strange when I access it blank page appears, cannot understand what's the problem, even ixwebhosting representative was unable to correct, we created new .htaccess but no problem was solved,

 

I think it is config.php but have not idea what to modify and how

Link to comment
Share on other sites

to make sure that .htaccess and .htpassword work I entered to fx-sys.com/admin/images and all images were listed also in fx-sys.com/admin/includes/boxes and files were listed

 

but I could not enter in fx-sys.com/indes.php and other php files :(((((

Link to comment
Share on other sites

hmmmmmmm wait a minute

 

I can even enter to http://fx-sys.com/admin/includes/stylesheet.css all contents are shown

 

well, as it seems it is problem of PHP to folder, I had this problem with fx-sys.com root directory and ixwebhosting rep solved,

 

well admin cannot open php files while it can open JPG, CSS TXT files very good

 

any one got experience what's the problem

Link to comment
Share on other sites

1. language, (I entered to PHPmyadmin and that database collation is in latin1_swedish_ci, how can I change it to UTF8???)

 

try this, after making a backup of course... :)

alter table (table name) charset utf8;

 

this will change the default charset for the table to utf8. changing the charset should allow for the proper collation. if individual columns have a charset specified then you'll have to alter those column names individually. those alter table statements can get a little complicated depending on what the table definition looks like, but i think this will do it for you.

 

let me know how it works out.

Link to comment
Share on other sites

I changed collation for entire data base and got message

 

" SQL query:

ALTER DATABASE `fxtrade_newgbn` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci

"

 

but poblem remains :(

Link to comment
Share on other sites

vwell I went almost wild how many thing I tested but I think I came to the clue of the problem

 

initial database on servage was mySQL 4.0 version,

 

I backed up it using gzip and utf8 unicode I selected mySQL 5.0 version,

 

what I got is www.gbn.ge I got the same language error,

 

then I tried to back up current database in mySQL 4.0 version I created new database on my hosting also 4.0 sql version adn imported. The site was working great

 

so I have two question is current oscommerce script valid for only mySQL 4.0 and does not work at mySQL 5.0? Or some modification of database will solve the problem and I can run script on mySQL 5.0 as I run on mySQL 4.0 currently

 

what do you suggest?

 

thanks

Link to comment
Share on other sites

Also I have got newsdesk contribution and

 

I got error

 

1054 - Unknown column 'p.newsdesk_id' in 'on clause'

 

select count(p.newsdesk_id) as total from newsdesk_description pd, newsdesk p left join manufacturers m on p.newsdesk_id = m.manufacturers_id, newsdesk_to_categories p2c left join specials s on p.newsdesk_id = s.products_id where p.newsdesk_status = '1' and p.newsdesk_id = p2c.newsdesk_id and pd.newsdesk_id = p2c.newsdesk_id and pd.language_id = '5' and p2c.categories_id = '48'

Link to comment
Share on other sites

I think it will be a problem with the left join part of the sql code. In the contribution there should be a part there already that fixes the other left join statements, you can try to see what the difference is then apply the same to the statement that is giving you the error.

 

OR

 

Check the contribution and see if it has been updated or find the contribution support thread and search for "MYSQL5".

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...