Error with new hosting company (please help)

[Guest]

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

[Guest]

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

 

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

[Guest]

anyone can help?

[Guest]

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.

[Guest]

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

[Guest]

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.

[Guest]

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}

[Bushmaster]

Try uploading your files again. I have had trouble with uploading files with ixwebhosting. Don't know if it is on there end or the program I use. There has been some files that get corupted on upload.

[Guest]

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

[Guest]

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.

[Guest]

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

?>

[Guest]

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.

[Guest]

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

[Guest]

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 :(((((

[Guest]

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

[arietis]

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.

[Guest]

hello I could not find function alter to modify table

 

I found charset but when I click there appers uneditable info

[Guest]

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 :(

[Guest]

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

[Guest]

If you are running ms2.2 then you need to make changes for the site to run on PHP5 and Mysql5

 

http://addons.oscommerce.com/info/3727

[Guest]

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'

[Guest]

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".

[Guest]

The fix has been posted in the contributions area

 

http://addons.oscommerce.com/info/934 (if that is the one you are using)

[Guest]

thanks Java

 

really helpful info