Ipowerweb Migration Messed my store

[oukhchi2007]

Thank you guys for all the contributions and for this fantastic software. I have an odd problem and i need help.

The infamous ipower migration to the new platform is a real nightmare. We worked on our stote for a year and we are still adding more and more products. It was working fine with no problem whatever till ipowerweb upgraded their platform. We got all kind of errors and everytime we fix one we discover a new one. here is the the new server configuration:

 

Ipower moved from mysql 4 to 5.0.45

PHP Version installed: 4.4.7

Platform: Debian

 

Actions Performed

 

We took Shared SSL off and change include/configue to :

 

define('HTTP_SERVER', 'http://abcmarineflorida.com');

define('HTTPS_SERVER', 'https://abcmarin.ipower.com');

define('ENABLE_SSL', false); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', 'abcmarineflorida.com');

define('HTTPS_COOKIE_DOMAIN', 'abcmarin.ipower.com');

define('HTTP_COOKIE_PATH', '/osCommerce/catalog/');

define('HTTPS_COOKIE_PATH', '/osCommerce/catalog/');

define('DIR_WS_HTTP_CATALOG', '/osCommerce/catalog/');

define('DIR_WS_HTTPS_CATALOG', '/osCommerce/catalog/'

 

Change Admin/includes/configure to

define('HTTP_SERVER', 'http://abcmarineflorida.com');

define('HTTP_CATALOG_SERVER', 'http://abcmarineflorida.com');

define('HTTPS_CATALOG_SERVER', 'https://abcmarin.ipower.com/');

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

define('DIR_FS_DOCUMENT_ROOT', '/home/abcmarin/public_html/osCommerce/catalog/'); // where the pages are located on the server

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

define('DIR_FS_ADMIN', '/home/abcmarin/public_html/osCommerce/catalog/admin/'); // absolute pate required

 

We install contribution and followed all instruction step by step and run Mysql queries

http://www.oscommerce.com/community/contributions,3727

 

Problem:

 

My html pages loded quickly. The store takes forever and very often it timeout when it does when i clik on checkout or my account or continue to checkout all what i get is just blank page whith No error message. The browser status says done. the administrator section works fine except that

You can try it at

http://abcmarineflorida.com/osCommerce/catalog/index.php

The page sometimes it load sometimes it does not. in other words the store became unstable. Please.Please i m pulling my hair and i appreciate any help

Thank you

[oukhchi2007]

Thank you guys for all the contributions and for this fantastic software. I have an odd problem and i need help.

The infamous ipower migration to the new platform is a real nightmare. We worked on our stote for a year and we are still adding more and more products. It was working fine with no problem whatever till ipowerweb upgraded their platform. We got all kind of errors and everytime we fix one we discover a new one. here is the the new server configuration:

 

Ipower moved from mysql 4 to 5.0.45

PHP Version installed: 4.4.7

Platform: Debian

 

Actions Performed

 

We took Shared SSL off and change include/configue to :

 

define('HTTP_SERVER', 'http://abcmarineflorida.com');

define('HTTPS_SERVER', 'https://abcmarin.ipower.com');

define('ENABLE_SSL', false); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', 'abcmarineflorida.com');

define('HTTPS_COOKIE_DOMAIN', 'abcmarin.ipower.com');

define('HTTP_COOKIE_PATH', '/osCommerce/catalog/');

define('HTTPS_COOKIE_PATH', '/osCommerce/catalog/');

define('DIR_WS_HTTP_CATALOG', '/osCommerce/catalog/');

define('DIR_WS_HTTPS_CATALOG', '/osCommerce/catalog/'

 

Change Admin/includes/configure to

define('HTTP_SERVER', 'http://abcmarineflorida.com');

define('HTTP_CATALOG_SERVER', 'http://abcmarineflorida.com');

define('HTTPS_CATALOG_SERVER', 'https://abcmarin.ipower.com/');

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

define('DIR_FS_DOCUMENT_ROOT', '/home/abcmarin/public_html/osCommerce/catalog/'); // where the pages are located on the server

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

define('DIR_FS_ADMIN', '/home/abcmarin/public_html/osCommerce/catalog/admin/'); // absolute pate required

 

We install contribution and followed all instruction step by step and run Mysql queries

http://www.oscommerce.com/community/contributions,3727

 

Problem:

 

My html pages loded quickly. The store takes forever and very often it timeout when it does when i clik on checkout or my account or continue to checkout all what i get is just blank page whith No error message. The browser status says done. the administrator section works fine except that

You can try it at

http://abcmarineflorida.com/osCommerce/catalog/index.php

The page sometimes it load sometimes it does not. in other words the store became unstable. Please.Please i m pulling my hair and i appreciate any help

Thank you

 

Another thing. i can t even backup my database. the error on the top backup directory does not exist even i can see it in the server. and when i click on file manager in the admin section . all i get is

File Manager

/home/abcmarin/public_html/oscommerce/catalog and no files under. Any idea why?

 

Thank You :blink:

[kketring]

The easiest way to install oscommerce w/o paying is to create your database and upload a backup through the mysql data base, w/ipower you have to be aware of your mysql database, because if you don't use your mysql it seems they try to host other peoples stuff.

 

Ipower certainly doesn't know how they 'scrwed' their own client base, I had 5 sites hosted with them and a few of them had oscommerce stores and not a one works on their new platform, I paid 12.95 for one install and I still have to pay 12.95 for each client, one of them has hundreds of items. When this particular store finally migrated ipower said 'go to OSCommerce" for support, (even with the 12.95 payment to install they do not provide support.)

I am looking for a new provider.

I lost two clients after the transition.

Some of the people have been on line for over two years and their data base holds importation information about their buyers.

(Of course ipower will manage the stores for a huge monthly fee)

I also used the joomla install and that opened up a whole new arena of pay for plug-ins.

 

 

I have called ipowr almost every day and waited on hold for no-one to know anything. They still owe me a reund for cancelled clients.

Seems the attorney general (http://www.oag.state.ny.us/complaints/complaints.html) should be notified with a complaint since they still offer the "free oscommerce" in their sales pitch on the front page.

Anyway I think I will duplicate and install the config files I got with the paid install(replacing the conf info with the correct database info) and upload from the data base all the old tables and files backup from a previous save. :thumbsup: to use backup after you get your files working you have to manually ad the backup folder(inside the admin dir) for the admin panel to be able to back up too ( of course ipower is charging for that too)

Oh and if you want to add on google checkout- save time and know thats an all week job(going back to the sandbox)

It would have been easier for them to tell us they were raising their prices.

 

So after I figure out the sure fire way of installing this clients store to the ipower new pain in the a## hosting I'll come back with the step by step procees for anyone who needs it.

[silver360]

I was able to get my store up and running...............BUT my problem now is how the heck do I connect to the database?

 

 

<?

$username="************";

$password="************";

$database="*************";

 

mysql_connect(gatekeep.accountsupportmysql.com,$username,$password);

@mysql_select_db($database) or die( "<BR><BR><B>Error: Could not establish connection");

 

$query="SELECT * FROM PCITURES ORDER BY TITLE";

$result=mysql_query($query);

$num=mysql_numrows($result);

?>

 

This doesn't work anymore........???????????

[oukhchi2007]

I was able to get my store up and running...............BUT my problem now is how the heck do I connect to the database?

<?

$username="************";

$password="************";

$database="*************";

 

mysql_connect(gatekeep.accountsupportmysql.com,$username,$password);

@mysql_select_db($database) or die( "<BR><BR><B>Error: Could not establish connection");

 

$query="SELECT * FROM PCITURES ORDER BY TITLE";

$result=mysql_query($query);

$num=mysql_numrows($result);

?>

 

This doesn't work anymore........???????????

 

Dear Kimberlee,

 

I really feel your pain. I went through the same thing and came up with the same result. I have an os commerce still in the old platform and working flawlessly while the 4 ones migrated having all kind of issues. Every day i discover a new problem. Just to give you a hint. there is a combined contribution that helped me resolve a bunch my problems and ipower are putting a link to it. (you gotta dig in deeeeeeeeeeeeep to find it next to (IPower QUOTE)

 

"On the new platform ...

 

There is no "Import SQL" command. Please review the Knowledgebase for information about importing a database.

There are three days' worth of database backups. There is no way to rename a database, though you can create a new database with a different name and import it. Activate Your Scheduled Jobs (Cron Jobs) For security reasons, all scheduled jobs on the new platform are managed through the Scheduled Jobs tool in vDeck. (You can no longer set up cron jobs by editing the crontab file in your Web directory."

 

Thank you very much ipowerweb for the headsup. PLEASE here is the link to the contribution

 

http://www.oscommerce.com/community/contributions,3727/

 

This will resolve the following issues:

 

customer_country_id in addressbook

 

## Update 051112

 

Cannot re-assign $this

limit -20, 20

Database Input Enhancement

Adding Non-Existing Products To Cart

Session ID XSS Issue

Validate Session ID

File Manager Problem

HTTP Header Injection

E-Mail Header Injection

Contact Us Form XSS Issue

Open Redirector

Extra Slashes In New Products

Order Status Filtering

MySQL 5.0 Compatibility

 

Another hint. If your browser does not generate any error or you get just a blank page head to CGI and scrip look for the error log you may find it easy to pinpoint the page that has a problem. i found that out the hard way

 

Jay