Purchase Without Account Updated & Admin Functionality

[cdi-buy.com]

Well I figured out my problem was in orders.php in that email configuration. I eliminated the changes that were in the instructions and it works fine, even PWA functions properly without that check in place.

[cdi-buy.com]

I have new problems. Unless they're actually bugs in the programming. I had enabled the customer to print their invoice from a javascript popup window but it only works for customers who signed up now, not PWAs. For PWAs it pops up the window with my website's login page without the toolbars. Is there any way to fix it so that they can still print their invoice since the order DOES in fact exist? After all, it's the customer that doesn't exist, not the order. Every customer should be able to print their invoice, not just the ones that created an account. I used the osC-PrintOrder with Store Logo v1.0 contribution for this feature by the way.

 

 

Also when a PWA customer clicks continue on the confirmation screen, they get taken to an empty shopping cart instead of the main page of my store. Actual signed up customers are taken to the index page as intended. Not sure what's going on there either.

[UK61]

Hi everybody, first post. I am trying to set up my first store and have installed as third contrib this one, PWA. Very good! Thanks to all for sharing that!

 

However I'd like to streamline the whole process of checking out even more, to follow these steps

1. put something in cart

2. Click: Checkout

3. fill in personal info OR login (one page)

Click: Proceed ...

 

So what I need is to get a login box on the order_info page.

Since I have practically no knowledge of PHP yet I wonder if anybody has done this and could share a little tip to get me started.

 

What I have done is trying to strip the login.php of all html except the actual login box and include the rest into order-info php but without success so far. Am I even on the right track with that approach?

 

Thanks for any help and sorry if this has been dealt with in some thread here, I haven't found anything yet.

[cdi-buy.com]

Hi everybody, first post. I am trying to set up my first store and have installed as third contrib this one, PWA. Very good! Thanks to all for sharing that!

 

However I'd like to streamline the whole process of checking out even more, to follow these steps

1.  put something in cart

2. Click: Checkout

3. fill in personal info OR login (one page)

Click: Proceed ...

 

So what I need is to get a login box on the order_info page.

Since I have practically no knowledge of PHP yet I wonder if anybody has done this and could share a little tip to get me started.

 

What I have done is trying to strip the login.php of all html except the actual login box and include the rest into order-info php but without success so far. Am I even on the right track with that approach?

 

Thanks for any help and sorry if this has been dealt with in some thread here, I haven't found anything yet.

<{POST_SNAPBACK}>

 

 

If you get that successully and cleanly done, let me know because I would also like to do that.

[UK61]

If you get that successully and cleanly done, let me know because I would also like to do that.

<{POST_SNAPBACK}>

 

Well I have added the functionality of the original osc login.php to the PWA order_info.php and that seems to work.

I now have two areas displayed on the order_info page, one a loginbox (minus the welcome message, little pic and visitors cart note), the other the regular table to fill out for new customers. Both upon submit lead to checkout_shipping and transport the cart contents.

The redirect in checkout_shipping is changed to order_info.php, so that any click on "checkout" directly brings the customer to the new order_info page.

 

I'm going to have to test this now.

[boxtel]

Hi everybody, first post. I am trying to set up my first store and have installed as third contrib this one, PWA. Very good! Thanks to all for sharing that!

 

However I'd like to streamline the whole process of checking out even more, to follow these steps

1.  put something in cart

2. Click: Checkout

3. fill in personal info OR login (one page)

Click: Proceed ...

 

So what I need is to get a login box on the order_info page.

Since I have practically no knowledge of PHP yet I wonder if anybody has done this and could share a little tip to get me started.

 

What I have done is trying to strip the login.php of all html except the actual login box and include the rest into order-info php but without success so far. Am I even on the right track with that approach?

 

Thanks for any help and sorry if this has been dealt with in some thread here, I haven't found anything yet.

<{POST_SNAPBACK}>

 

 

 

i have in checkout_shipping :

 

// if the customer is not logged on, redirect them to the login page

if (!tep_session_is_registered('customer_id')) {

 

$navigation->set_snapshot();

 

if ((PWA_ON == 'true') and ($cart->count_contents() > 0)) {

tep_redirect(tep_href_link(FILENAME_CHECKOUT, '', 'SSL'));

} else {

tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));

}

}

[bigbuck]

Hello, i'm fairly new to os, let along php, lol.

 

I just got done installing this contribution PWA

 

After i got done filling in all info (name, etc...) click checkout,

 

i got this error?

 

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

 

 

 

any help would be much appreciated!

 

thanks

mike

[Guest]

you need to use phpmyadmin or mysql cvonnector to add the database addition to the file.

 

perhaps the best ting to do is search the internet for phpmyadmin tutorial to learn how to use it, then you will be able to go back to the contribution and know exactly what to do

[bigbuck]

Hi Mibble,

 

I added the part thru phpmyadmin (mysqladmin), it went thru good, unless there is more?

 

I did add it before i updated all the files, would that make a difference if it was first or last?

[Guest]

no that doesnt make a difference, as long as all sql statements are added

[bigbuck]

Will it overwrite it if i run it again?

[jond]

There are several things that could be wrong. First off, the install instructions have a few problems, especially for a novice. That installation step for admin/orders.php needs to be cleaned up a lot. The way it is, part of the code is actually commented out. Id download a free copy of Crimson Editor, which color codes all php tags and makes everything really easy. Anywy, try looking at this file and fixing it. Then id manually look at your DB and make sure the column exists.

[bigbuck]

OK...that don't sound fun! I'm not sure what i'm looking for in the order.php.

 

I wanted everything to work, then i was going to take out the create account and login, so PWA is the only option.

 

I guess thats what ya call hiding,lol.

[bigbuck]

OOP, something just hit me! When i pasted the order.php code, i put the

 in with it, will that hurt?

[bigbuck]

didn't help! ;)

Edited January 11, 2005 by bigbuck

[jond]

Ok,

 

Id go through all steps and make sure no

 is included. Also, make sure you go through the install instructions manually, as just copying the new files over yours will miss some changes. For the admin/orders.php step, you must remove the [COde] and fix it even more. Take the code after the first comment and move it to a new line. Look for all semicolons. Place the code after each on a new line. This is true for the code you are trying to replace in the instructions, too. It is placed all on one line, when in actuality it is several lines of code you will be removing. Id try to get this working As-IS, then try to mod it to your liking. Other than that, i cant really offer any help.

[bigbuck]

This is exaclty what it shows. What going on with the UPPER?

 

 

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

 

select customers_id, purchased_without_account, customers_firstname, customers_password, customers_email_address, customers_default_address_id from customers where upper(customers_email_address) = 'FJFJFJ@YAHOO.COM' and upper(customers_firstname) = 'HHHHH' and upper(customers_lastname) = 'HHHHH'

 

[TEP STOP]

[bigbuck]

i got it too work! I must have had something wrong with the:-----

// start pwa changes

 

Looked thru the 30 pages and copy pasted a code, must have been the problem?

It works now, lol. yahoo...only took all day! lol

 

thanks for replies

mike

Edited January 11, 2005 by bigbuck

[UK61]

i have in checkout_shipping :

 

// if the customer is not logged on, redirect them to the login page

  if (!tep_session_is_registered('customer_id')) {

 

    $navigation->set_snapshot();

 

    if ((PWA_ON == 'true') and ($cart->count_contents() > 0)) {

      tep_redirect(tep_href_link(FILENAME_CHECKOUT, '', 'SSL'));

    } else {

        tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));

    }

  }

<{POST_SNAPBACK}>

 

Hello Amanda,

thanks for your reply! I have to admit I'm a bit puzzled by that piece of code. At the site in your profile visitors when hitting Checkout get redirected to order_info if they are not logged in which is fine and just what I do. The code above to this php illiterate seems to say that visitors get redirected to login.php, which is stamdard PWA behaviour?

 

In any case it looks like I have achieved my goal for now.

 

- Visitors who are logged in and hit Checkout:

1. go to checkout-shipment directly

 

- Visitors who are NOT logged in and hit Checkout:

1. get redirected to Order_info.php

fill in personal info form OR

login on the same page

2. go to checkout-shipment.

 

If anybody is interested I'd share my hacked order_info.php.

[cdi-buy.com]

In any case it looks like I have achieved my goal for now.

 

- Visitors who are logged in and hit Checkout:

1. go to checkout-shipment directly

 

- Visitors who are NOT logged in and hit Checkout:

1. get redirected to Order_info.php

  fill in personal info form OR

  login on the same page

2. go to checkout-shipment.

 

If anybody is interested I'd share my hacked order_info.php.

<{POST_SNAPBACK}>

 

I would like to see the actual page of your website and the code as well.

[UK61]

I would like to see the actual page of your website and the code as well.

<{POST_SNAPBACK}>

my store is not in a state that I want to give out the address so here's a screenshot

. It needs of course some formatting and styling.

 

The code of the order_info.php:

<?php
/*
?$Id: Order_Info.php,v 0.52 2002/09/21 hpdl Exp $
? ? ? ?by Cheng

? ? ? ?OSCommerce v2.2 CVS (09/17/02)

? Modified versions of create_account.php and related
?files. ?Allowing 'purchase without account'.

?osCommerce, Open Source E-Commerce Solutions
?http://www.oscommerce.com

?Copyright (c) 2002 osCommerce

?Released under the GNU General Public License
*/

?require('includes/application_top.php');


// Begin added php stuff from original OSC login php ?
?
?// redirect the customer to a friendly cookie-must-be-enabled page if cookies are disabled (or the session has not started)
? ?if ($session_started == false) {
? ? ?tep_redirect(tep_href_link(FILENAME_COOKIE_USAGE));
? ?}
?
? ?require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_LOGIN);
?
? ?$error = false;
? ?if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'process')) {
? ? ?$email_address = tep_db_prepare_input($HTTP_POST_VARS['email_address']);
? ? ?$password = tep_db_prepare_input($HTTP_POST_VARS['password']);
?
?// Check if email exists
? ? ?$check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");
? ? ?if (!tep_db_num_rows($check_customer_query)) {
? ? ? ?$error = true;
? ? ?} else {
? ? ? ?$check_customer = tep_db_fetch_array($check_customer_query);
?// Check that password is good
? ? ? ?if (!tep_validate_password($password, $check_customer['customers_password'])) {
? ? ? ? ?$error = true;
? ? ? ?} else {
? ? ? ? ?if (SESSION_RECREATE == 'True') {
? ? ? ? ? ?tep_session_recreate();
? ? ? ? ?}
?
? ? ? ? ?$check_country_query = tep_db_query("select entry_country_id, entry_zone_id from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int)$check_customer['customers_id'] . "' and address_book_id = '" . (int)$check_customer['customers_default_address_id'] . "'");
? ? ? ? ?$check_country = tep_db_fetch_array($check_country_query);
?
? ? ? ? ?$customer_id = $check_customer['customers_id'];
? ? ? ? ?$customer_default_address_id = $check_customer['customers_default_address_id'];
? ? ? ? ?$customer_first_name = $check_customer['customers_firstname'];
? ? ? ? ?$customer_country_id = $check_country['entry_country_id'];
? ? ? ? ?$customer_zone_id = $check_country['entry_zone_id'];
? ? ? ? ?tep_session_register('customer_id');
? ? ? ? ?tep_session_register('customer_default_address_id');
? ? ? ? ?tep_session_register('customer_first_name');
? ? ? ? ?tep_session_register('customer_country_id');
? ? ? ? ?tep_session_register('customer_zone_id');
?
? ? ? ? ?tep_db_query("update " . TABLE_CUSTOMERS_INFO . " set customers_info_date_of_last_logon = now(), customers_info_number_of_logons = customers_info_number_of_logons+1 where customers_info_id = '" . (int)$customer_id . "'");
?
?// restore cart contents
? ? ? ? ?$cart->restore_contents();
?
? ? ? ? ?if (sizeof($navigation->snapshot) > 0) {
? ? ? ? ? ?$origin_href = tep_href_link($navigation->snapshot['page'], tep_array_to_string($navigation->snapshot['get'], array(tep_session_name())), $navigation->snapshot['mode']);
? ? ? ? ? ?$navigation->clear_snapshot();
? ? ? ? ? ?tep_redirect($origin_href);
? ? ? ? ?} else {
? ? ? ? ? ?tep_redirect(tep_href_link(FILENAME_DEFAULT));
? ? ? ? ?}
? ? ? ?}
? ? ?}
? ?}
?
? ?if ($error == true) {
? ? ?$messageStack->add('login', TEXT_LOGIN_ERROR);
? ?}
?
?
// End of included php stuff

?require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CREATE_ACCOUNT);

?$breadcrumb->add(NAV_ORDER_INFO, tep_href_link('Order_Info.php', '', 'SSL'));
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
?<title><?php echo TITLE ?></title>
<base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<?php require('includes/form_check.js.php'); ?>

</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
?<tr>
? ?<td width="<?php echo BOX_WIDTH; ?>" valign="top">
? ?
<!-- A T T E N T I O N ?Start login form table--> ? ?
? ?<?php echo tep_draw_form('login', tep_href_link(FILENAME_LOGIN, 'action=process', 'SSL')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">
<!--Cut out welcome table with little pic--> ? ? ? ? ?
? ? ? ? ?<tr>
? ? ? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ? ? ?</tr>
? ?<?php
? ? ?if ($messageStack->size('login') > 0) {
? ??>
? ? ? ? ?<tr>
? ? ? ? ? ?<td><?php echo $messageStack->output('login'); ?></td>
? ? ? ? ?</tr>
? ? ? ? ?<tr>
? ? ? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ? ? ?</tr>
<!--Cut out Visitor Cart Note-->

? ?<?php
? ? ?}
? ??>
? ? ? ? ?<tr>
? ? ? ? ? ?<td><table border="1" bordercolor="red" width="100%" cellspacing="0" cellpadding="2">
? ? ? ? ? ? ?<tr>
<!--cut out new customer 1. cell--> ? ? ? ? ? ? ? 
? ? ? ? ? ? ? ?<td class="main" width="50%" valign="top"><b><?php echo HEADING_RETURNING_CUSTOMER_LOGINBOX; ?></b></td>
? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ?<tr>
?<!--cut out new customer 2. cell--> ? ? ? ? ? ? ? 
? ? ? ? ? ? ? ?<td width="50%" height="100%" valign="top"><table border="0" width="100%" height="100%" cellspacing="1" cellpadding="2" class="infoBox">
? ? ? ? ? ? ? ? ?<tr class="infoBoxContents">
? ? ? ? ? ? ? ? ? ?<td><table border="0" width="100%" height="100%" cellspacing="0" cellpadding="2">
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td class="main" colspan="2"><?php echo TEXT_RETURNING_CUSTOMER_LOGINBOX; ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td>
? ? ? ? ? ? ? ? ? ? ? ?<td class="main"><?php echo tep_draw_input_field('email_address'); ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td class="main"><b><?php echo ENTRY_PASSWORD; ?></b></td>
? ? ? ? ? ? ? ? ? ? ? ?<td class="main"><?php echo tep_draw_password_field('password'); ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td class="smallText" colspan="2"><?php echo '<a href="' . tep_href_link(FILENAME_PASSWORD_FORGOTTEN, '', 'SSL') . '">' . TEXT_PASSWORD_FORGOTTEN . '</a>'; ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td colspan="2"><table border="0" width="100%" cellspacing="0" cellpadding="2">
? ? ? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ? ? ?<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
? ? ? ? ? ? ? ? ? ? ? ? ? ?<td align="right"><?php echo tep_image_submit('button_login.gif', IMAGE_BUTTON_LOGIN); ?></td>
? ? ? ? ? ? ? ? ? ? ? ? ? ?<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
? ? ? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ? ?</table></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ?</table></td>
? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ?</table></td>
? ? ? ? ? ? ?</tr>
? ? ? ? ? ?</table></td>
? ? ? ? ?</tr>
? ?</table></form>

<!-- A T T E N T I O N End of Login form table-->

? ?</td>
<!-- body_text //-->
? ?<td width="100%" valign="top"><form name="account_edit" method="post" <?php echo 'action="' .
tep_href_link('Order_Info_Process.php', '', 'SSL')
. '"'; ?> onSubmit="return check_form(this);"><input type="hidden" name="action" value="process"><table border="0" width="75%" cellspacing="0" cellpadding="0" align="center">
? ? ?<tr>
? ? ? ?<td><table border="0" width="75%" cellspacing="0" cellpadding="0">
? ? ? ? ?<!--tr>
? ? ? ? ? ?<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
? ? ? ? ? ?<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_account.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
? ? ? ? ?</tr//-->
? ? ? ?</table></td>
? ? ?</tr>
<?php
?if (sizeof($navigation->snapshot) > 0) {
?>
? ? ?
<!--Cut out: Text_origin_login message for existing account holders--> ? ? ?
? ? ?
<?php
?}
?>
? ? ?<tr>
? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ?</tr>
? ? ?<tr>
? ? ? ?<td>
<?php
?$email_address = tep_db_prepare_input($HTTP_GET_VARS['email_address']);
?$account['entry_country_id'] = STORE_COUNTRY;

?require(DIR_WS_MODULES . 'Order_Info_Check.php');
?>
? ? ? ?</td>
? ? ?</tr>
? ? ?<tr>
? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ?</tr>
? <tr>
? ? ? ?<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
? ? ? ? ?<tr class="infoBoxContents">
? ? ? ? ? ?<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ?<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
? ? ? ? ? ? ? ?<td align="right"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></td>
? ? ? ? ? ? ? ?<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
? ? ? ? ? ? ?</tr>
? ? ? ? ? ?</table></td>
? ? ? ? ?</tr>
? ? ? ?</table></td>
? ? ?</tr>
? ?</table></form></td>
<!-- body_text_eof //-->
? ?<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
? ?</table></td>
?</tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

The TEXT_RETURNING_CUSTOMER_LOGINBOX and the HEADING_RETURNING_CUSTOMER_LOGINBOX need to be defined in the includes/languages/english(or whatever languages)login.php

 

The redirect in checkout_shipping.php must be changed to order_info.php.

 

// A T T E N T I O N Please, be aware that I`m not a coder and don't know jack about php, and I mean it! Use at your own risk! And, btw, it would be most wonderful if some of you php buffs could take a look at the code and see if I really managed NOT to mess up anything.

Edited January 12, 2005 by UK61

[stevej]

Sorry for this I have gone through the 600 posts here but I have yet to find an answer, even an inkling of an answer to this problem with the PWA when a customer whose email address is in the system tries to buy. Basically a 404 error page is generated instead of the ordinary page when a purchase attempt is made by a customer with an email address in the system. 2 others on this thread have asked and I have not seen any response to that either.

 

It looks like something to do with Search friendly URLs. I need those on, so can someone tell me how to bypass or solve this problem.

error message below.....

 

404 Error

The requested URL /login.php/login/fail/reason/An+account+already+exists+for+the+email+address+

i>test@test.com</i>.

++You+must+login+here+with+the+password+for+that

+account+before+proceeding+to+checkout. was not found on this server.

[bigbuck]

I have another error:

 

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

 

update orders set purchased_without_account = '1' where orders_id = '1'

 

 

What do the 1 and 1 mean

purchased without accont=1 ???

 

I always wondered this!

 

thanks

mike

[Guest]

I have another error:

 

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

 

update orders set purchased_without_account = '1' where orders_id = '1'

What do the 1  and  1  mean

purchased without accont=1      ???

 

I always wondered this!

 

thanks

mike

<{POST_SNAPBACK}>

Try commenting out this line in catalog/checkout_success.php:

 

tep_db_query("insert into " . TABLE_ORDERS . " (purchased_without_account) values ('1') where orders_id = '" . (int)$orders['orders_id'] . "'");

[dentonio69]

First of all sorry if this is slightly off topic:

 

I am confused about installing the PWA module (especially the SQL part) because I have already installed the Master Password MD5 module in the configuration tables.

 

- Do I overwrite those values with the PWA values? If so will the Master Password module still work?

 

- I am also confused about the Master Password installation procedure. Can I confirm that this is what I'm meant to do:

 

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('188', 'Master Password', 'MASTER_PASS', MD5('yourpassword'), 'This password will allow you to login to any customers account.', 1, 23, '2004-06-15 07:10:52', '2004-06-15 07:10:52', NULL, NULL);

 

And therefore if I want to login into a customer's account I use their email address and 'yourpassword' (without the apostrophes) as the password?

 

Cheers

 

(edit: And also, the Default value for configuration_value is MD5('yourpassword')? and not something else?)

Edited January 13, 2005 by dentonio69