Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[Contribution] Upgrading osC from 2.2 MS2 to 2.2 RC2a


Recommended Posts

Hi Jan,

 

Thanks for your contribution.

 

I'm in the process of upgrading a heavily modified site from 2.2 MS2 to 2.2 RC2a. Working on the test site I've modified all of the required files and everything seems to be fine until we reach checkout_shipping - we get a blank page. I've tried it with the original file in the add-on to replace the modified file in case it was one of the modifications causing the problem.

 

Was wondering if you could point me in the right direction as to where the problem may lie.

 

Cheers

Link to comment
Share on other sites

Was wondering if you could point me in the right direction as to where the problem may lie.

The error log. Since your hosting provider has switched off displaying errors (with good reason) there surely must be an error log.

Link to comment
Share on other sites

The error log. Since your hosting provider has switched off displaying errors (with good reason) there surely must be an error log.

 

Thanks Jan,

 

Found the error log, looks like includes/classes/order.php. Will look into it.

 

Regards,

 

jaya

Link to comment
Share on other sites

  • 2 months later...

Hallo Jan,

 

I've used your contribution and it looks like things are working again however I can no longer login into the admin section of the shop. I've understood that the administrator table didn't excist in MS2 so I copied the table from a more recent (RC2) shop I have and imported it into the database but I still couldn't login.

 

So I emptied the users and passwords hoping I would get a request to setup a new admin account when trying to login. It didn't and now I'm stuck so any help is appreciated.

 

I do have some understanding of things (through practical experience) but I am by no means an expert... :huh:

Link to comment
Share on other sites

  • 6 months later...
  • 2 weeks later...

Hi,

 

Have just finished upgrading from 2.2MS2 to 2.2RC2a.

In addition I have changed webhost and name of domene for my store.

Both my store and my admin is totally blank, just a white screen, no error message.

 

Have tried for several days now, buth no luck in figuring this one out.

 

Right after changing host, I uploaded all old storefiles to my new webhotel and it worked, both catalog and admin showed on the internet.

Then I upgraded from MS2 to RC2a -> both store and admin totally blank

Then I went through all files to change all path directions to new pathdirections and also change the storename and domenename.

 

In my old store the path was like this: www.mydomain.com/catalog........ (right at the root)

In my new store the path has one extra folder: www.mydomain2.no/public_html/catalog......

 

I did not think that /public_html should be in the pathdirections in any other files than the configure files, but maybe I'm wrong?

 

Also I use an old sts free template. I have been told that I must upgrade this. I will start this work now, but could this be the reason that my store and admin now both are blank?

 

 

Any idea in which files I can start to look for the cause?

And what code?

 

Please help anyone :-)

 

Thanks :-)

Hi there,

I was wondering if you mind helping me out from upgrading from 2.2MS2 to 2.2 RC2a

I've been trying for day and no luck

I have got diffmerge but I don't know how to use it, and don't know where to start

Thanks in advance

Dominique

Link to comment
Share on other sites

I updated and i'm getting an error

 

1054 - Unknown column 'customers_name' in 'field list'

 

insert into orders_products (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value, ip_address) values ('711',

 

 

 

did the table syntax change that customer info is with ordered products or did I do something wrong>

Link to comment
Share on other sites

  • 7 months later...

Hi Jan, regarding my Ideal emailreminder issue from page 5, here I am again. The issue is still not fixed, after some time of not looking at it anymore I am working on this issue again.

 

My latest findings are that somehow a session is not ending correctly. Let me give you an example.

 

I ordered a product and paid via ideal. The ordernumber was 1413, no email confirmation

I made some changes as mentioned by you in the past, just to try them again

I made a new order via ideal, the ordernumber was 1414 and what happened> i receive two emailaconfirmations about order 1413, but the time between those orders was about 30 minutes, so it could never be the real confirmation of 1413, it was triggered then ordering order 1414. Strange or what.

 

I did find something interesting in the SQL database, but I don't know what caused this:

post-186534-0-36346700-1326294725_thumb.jpg

 

When starting the idealpayment for 1414, order 1413 is put in the database with same entrancecode.

 

Any thoughts?

Edited by Remco Leuven
Link to comment
Share on other sites

  • 3 months later...

Hello,

 

I'm following upgrade instructions found in the document "Upgrading osC from 2.2 MS2 to 2.2 RC2a". My PHP Version 4.4.9, MySQL 4.1.22.

 

After the following change in step 19: admin/includes/functions/html_output.php, I'm getting blank pages in admin.

 

Line 273-274 (294-295 in changed file) [Add the Session ID to GET Based Forms]

**BEFORE**

//// // Output a form pull down menu

**ADD**

////
// Hide form elements
 function tep_hide_session_id() {
$string = '';

if (defined('SID') && tep_not_null(SID)) {
  $string = tep_draw_hidden_field(tep_session_name(), tep_session_id());
}

return $string;
 }

I was wondering what can be the problem here.

Thanks for help.

Link to comment
Share on other sites

  • 5 weeks later...

I have a custom made one-page-checkout (namned checkout.php). In the country pull down menu I used to have Sweden as pre-selected.

That pre-selection was disapeared after the upgrade to rc2a. This is due to the new function tep_draw_pull_down_menu in includes/functions/html_output.php

 

So if I use the rc2a:

 function tep_draw_pull_down_menu($name, $values, $default = '', $parameters = '', $required = false) {
global $HTTP_GET_VARS, $HTTP_POST_VARS;
$field = '<select name="' . tep_output_string($name) . '"';
if (tep_not_null($parameters)) $field .= ' ' . $parameters;
$field .= '>';
if (empty($default) && ( (isset($HTTP_GET_VARS[$name]) && is_string($HTTP_GET_VARS[$name])) || (isset($HTTP_POST_VARS[$name]) && is_string($HTTP_POST_VARS[$name])) ) ) {
  if (isset($HTTP_GET_VARS[$name]) && is_string($HTTP_GET_VARS[$name])) {
	$default = stripslashes($HTTP_GET_VARS[$name]);
  } elseif (isset($HTTP_POST_VARS[$name]) && is_string($HTTP_POST_VARS[$name])) {
	$default = stripslashes($HTTP_POST_VARS[$name]);
  }
}
for ($i=0, $n=sizeof($values); $i<$n; $i++) {
  $field .= '<option value="' . tep_output_string($values[$i]['id']) . '"';
  if ($default == $values[$i]['id']) {
	$field .= ' SELECTED';
  }
  $field .= '>' . tep_output_string($values[$i]['text'], array('"' => '"', '\'' => ''', '<' => '<', '>' => '>')) . '</option>';
}
$field .= '</select>';
if ($required == true) $field .= TEXT_FIELD_REQUIRED;
return $field;
 }

no country is pre-selected.

 

If I use the old ms2:

 function tep_draw_pull_down_menu($name, $values, $default = '', $parameters = '', $required = false) {
$field = '<select name="' . tep_output_string($name) . '"';
if (tep_not_null($parameters)) $field .= ' ' . $parameters;
$field .= '>';
if (empty($default) && isset($GLOBALS[$name])) $default = stripslashes($GLOBALS[$name]);
for ($i=0, $n=sizeof($values); $i<$n; $i++) {
  $field .= '<option value="' . tep_output_string($values[$i]['id']) . '"';
  if ($default == $values[$i]['id']) {
	$field .= ' SELECTED';
  }
  $field .= '>' . tep_output_string($values[$i]['text'], array('"' => '"', '\'' => ''', '<' => '<', '>' => '>')) . '</option>';
}
$field .= '</select>';
if ($required == true) $field .= TEXT_FIELD_REQUIRED;
return $field;
 }

the store country is pre-selected just as it should.

 

This is how my code for selecting country looks like:

<?php echo tep_get_country_list('country', ($HTTP_POST_VARS['country'] ? $HTTP_POST_VARS['country'] : $order->billing['country']['id']),'onchange="sb=1;copy_shipping(document.getElementsByName(\'ship_as_bill\')[0],true);sb=0;getbillstatewithshipp();" class="checkoutCountry" style="width:145px;"') . ' ' . (tep_not_null(ENTRY_COUNTRY_TEXT) ? '<span class="inputRequirement">' . ENTRY_COUNTRY_TEXT . '</span>': ''); ?>

 

Should I stick to the old ms2 function tep_draw_pull_down_menu?

Or can anyone help me out modify the code for selecting country in my checkout.php?

 

 

Thanks,

Fredrik

Link to comment
Share on other sites

  • 3 weeks later...

I followed the instructions on upgrading from the contribution zip file I think from:

http://www.oscommerce.com/forums/topic/333215-contribution-upgrading-osc-from-22-ms2-to-22-rc2a/

 

I ran all the queries and upgraded the database. All were successful.

In an attempt to get my site back up quickly I uploaded all the new files into both admin and the store.

I then made a quick edit of header.php and replaced the OSC banner with my site's

My site comes up http://www.hcca.org/ClubStore/

You can get to a category

If you try to bring up details on any item you get 1054 - Unknown column 'p.products_id' in 'on clause'.

 

I have traced this to the classes/PriceFormatter.php file but don't know how to fix it. Any help would be greatly appreciated.

Edited by bbsemail
Link to comment
Share on other sites

  • 2 months later...

This is the support thread for the "Upgrading osC from 2.2 Milestone 2 to 2.2 RC2a" contribution (addon #6654).

 

 

Hello Jan,

 

I wanted to thank you for this Contribution. It worked fine for me.

 

http://www.oscommerce.com/forums/topic/388982-upgrading-22ms2-060817-to-22rc2a-to-php-5x-hosting/

 

Now, if I can just figure out how to re-integrate Ultra-Pics (or similar) . But that isn't a failing of this contrib. You stuff worked fine. Thanks again.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...