Purchase Without Account Updated & Admin Functionality

[Guest]

You are missing an entire box in that space it should say: Go back and check through your code for login.php

 

Do you want to go straight to the checkout process?

 

Would like like to check out without creating a customer account? Please note that all of our services will not be available to customers that do not wish to create an account. Also, you cannot view the status of your order, and each time you shop with us you will have to re-enter all of your data.

 

Creating an account is free. If you still wish to continue to checkout please click the checkout button to your right.

 

 

Thanks for the speedy response Lildog!

 

That box of text does come up when I try to checkout without an account, but there is still space above it. Not as much space as the normal login page though.

 

I'm sure it's a simple fix. I'll keep digging.

Cheers, Jim

Edited August 18, 2008 by jim@qb

[Guest]

I just finished adding the latest PWA contribution and I noticed I am getting an error when I try to log back into an account that was already created. here is the error

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' guest_account from customers where customers_email_address = '[email protected]' at line 1

select customers_id, customers_firstname, customers_group_id, customers_password, customers_email_address, customers_default_address_id, customers_specific_taxes_exempt from, guest_account from customers where customers_email_address = '[email protected]' and guest_account='0'

[TEP STOP]

 

Any help???? I know pretty much nothing about SQL

[lildog]

you have too many from statements there I believe----from, guest_account from customers check that query.....

 

lildog

 

 

I just finished adding the latest PWA contribution and I noticed I am getting an error when I try to log back into an account that was already created. here is the error

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' guest_account from customers where customers_email_address = '[email protected]' at line 1

select customers_id, customers_firstname, customers_group_id, customers_password, customers_email_address, customers_default_address_id, customers_specific_taxes_exempt from, guest_account from customers where customers_email_address = '[email protected]' and guest_account='0'

[TEP STOP]

 

Any help???? I know pretty much nothing about SQL

[jamminjime]

it should take you to login first...

 

Thank you for the response , but that does nothing as well. I just checked to ensure that my login.php page has PWA code in it and it does. My login page looks just like it did before.

 

How many of the installs do I have to go through? I downloaded a full (?) package and it had instructions on how to go from 1.25 to 2.0a and 2.0c to 2.0d etc.etc through 2.0f. Did I just not put enough of the code in there or something? This package really could use some combination. I'd offer, but hell, I can't get what I have working yet.

 

Thanks,

 

Jim Evans

Still purchasing WITH an account

[jamminjime]

you have too many from statements there I believe----from, guest_account from customers check that query.....

 

lildog

 

I see your problem. In your FROM clause, you have a bit of "overpasted" code.

 

customers_specific_taxes_exempt from, guest_account from customers

 

should read

 

customers_specific_taxes_exempt from guest_account

OR

customers_specific_taxes_exempt from customers

 

Best of luck!

[Guest]

I see your problem. In your FROM clause, you have a bit of "overpasted" code.

 

customers_specific_taxes_exempt from, guest_account from customers

 

should read

 

customers_specific_taxes_exempt from guest_account

OR

customers_specific_taxes_exempt from customers

 

Best of luck!

 

Thanks guys, you saved my butt here!!!! The problem was when I combined the code of PWA with the contribution SPPC that I already had installed. I had to do some coding myself to make the two work together and thats where I went wrong. Mostly because I know nothing about PHP.

 

The error was in catalog/login.php

 

here is the fix for future reference

 

 

code should read:

// PWA BOF
// BOF Separate Pricing per Customer
// using guest_account with customers_email_address
  $check_customer_query = tep_db_query(  "select customers_id, customers_firstname, customers_group_id, customers_password, customers_email_address, customers_default_address_id, customers_specific_taxes_exempt, guest_account from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address). "' and guest_account='0'");
// PWA EOF
// EOF Separate Pricing Per Customer

 

This has both contributions added to it. (PWA and SPPC)

Thanks again guys!!!!

[AnnasAttic]

Install PWA and that seems to be working fine, But if I go to login as returning customer I get this:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'te_of_last_logon = now(), customers_info_number_of_logons = customers_info_numbe' at line 2

 

update customers_info set customers_info_da te_of_last_logon = now(), customers_info_number_of_logons = customers_info_numbe r_of_logons+1 where customers_info_id = '4'

 

[TEP STOP]

 

 

I have searched forums and found not fixes.

 

Any suggestions or tips.

 

TIA

[Guest]

Hi lildog,

 

I was wondering if you had any suggestions about this error after I installed a copy of 2.0f onto a fresh install of RC2a:

 

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

 

select 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, customers_dummy_account, 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, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '4'

 

I get this when I try to check the customers order in OSC Admin. I did install the sql's as instructed. This is my second attempt at using PWA, the first time I tried to integrate into the site already complete but when that failed I reinstalled OSC and used the included files with PWA to modify the fresh install.

 

Any suggestions would be appreicated.

 

 

Chris

[Guest]

Hi,

Disregard this, I didn't realize the common SQL had errors when I ran it. So I ran the Order alterations again and everything is ok now.

 

Thanks

 

Chris

 

 

 

Hi lildog,

 

I was wondering if you had any suggestions about this error after I installed a copy of 2.0f onto a fresh install of RC2a:

 

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

 

select 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, customers_dummy_account, 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, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '4'

 

I get this when I try to check the customers order in OSC Admin. I did install the sql's as instructed. This is my second attempt at using PWA, the first time I tried to integrate into the site already complete but when that failed I reinstalled OSC and used the included files with PWA to modify the fresh install.

 

Any suggestions would be appreicated.

 

 

Chris

[audioshop55]

Hello all,

 

thank you for this wonderful contribution unfortunately it does not work with me!

 

I think it comes from the fact that I install the contribution INFOBOX_admin!

 

what do column_right that my file is not the same as basic and I do not know or add this line in this file:

/ / PWA EOF 
  if (tep_session_is_registered ( 'customer_id') & & (! tep_session_is_registered ( 'customer_is_guest'))) include (DIR_WS_BOXES. "order_history.php '); 
/ / PWA BOF

 

could you please help me?

 

thank you

 

my column_right.php

 

<?php
/*
 $Id: column_right.php,v 1.15 2002/03/13 13:52:20 lango Exp $

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

 Copyright (c) 2002 osCommerce

 Released under the GNU General Public License
*/
 $column_query = tep_db_query('select configuration_column as cfgcol, configuration_title as cfgtitle, configuration_value as cfgvalue, configuration_key as cfgkey, box_heading from ' . TABLE_THEME_CONFIGURATION . ' order by location');
 while ($column = tep_db_fetch_array($column_query)) {

  $column['cfgtitle'] = str_replace(' ', '_', $column['cfgtitle']);
  $column['cfgtitle'] = str_replace("'", '', $column['cfgtitle']);

if ( ($column[cfgvalue] == 'yes') && ($column[cfgcol] == 'right')) {

define($column['cfgkey'],$column['box_heading']);

if ( file_exists(DIR_WS_BOXES . $column['cfgtitle'] . '.php') ) {
require(DIR_WS_BOXES . $column['cfgtitle'] . '.php');
} 
}
}
?>
<tr>
				<td class="pageHeading" height="100%" valign="top">
<?php 
if ( file_exists('includes/classes/thema/' . SITE_THEMA . '/images/backend.gif')) {
?>
<IMG SRC="includes/classes/thema/<?php echo SITE_THEMA;?>/images/backend.gif" width="100%">
<?php
}
?>
				</td>
			  </tr>

[mongomike]

Hi there,

 

Is it true that the 'How Did You Hear About Us' contribution does not work with the PWA contrib?

 

Many thanks

[MikeTurner]

Hi,

 

I'm having a problem before I've pretty much started. In the common.sql I get the following error:

 

SQL query:

 

ALTER TABLE `customers` MODIFY COLUMN `customers_password` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_general_ci

 

MySQL said:

 

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_general_ci' at line 1

 

Any ideas how to fix this?

 

Thanks in advance

 

Mike

[janetgot]

Hi, I think I messed something up !

 

I'm in process of rebuilding an old osCommerce site using the latest versions of all the contributions, and I'm almost done. I have PWA installed and tested on my development server... all is well.

 

However, here's where I messed up... I tranferred all my customers and order data from my old live database to my new database and I might have broken PWA there. Now on my newly moved site, when I fill out my address page in create_account.php and hit next, I get the following error:

 

1054 - Unknown column 'guest_account' in 'where clause'

 

select count(*) as total from customers where customers_email_address = '[email protected]' and guest_account != '1'

 

[TEP STOP]

 

Here's where it coughs:

 

// PWA BOF 2b

$check_email_query = tep_db_query("select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "' and guest_account != '1'");

// PWA EOF 2b

//$check_email = tep_db_fetch_array($check_email_query);

 

I looked in my customer table and don't see the column, but I also don't see it in the english.sql for this app, so I'm a little stumped if I'm on the right track.

 

If anybody has an idea of where I should look to fix it, I'd greatly appreciate it... meanwhile, I'll keep looking on my own and try adding the column back over on the dev site...

 

Thanks,

Janet

[lildog]

You are missng the guest_account column in your new database. If you look in the PWA sql file you will see it. You can then go in and manually add it in php my admin.BTW, I am also rebuilding and adding the latest versions of contribs, you will probably come across this similar error again. Check out contrib tracker...I wrote it to keep track of all of my contrbs. Let's you know when there is a newer version.

 

lildog

[janetgot]

You are missng the guest_account column in your new database. If you look in the PWA sql file you will see it. You can then go in and manually add it in php my admin.BTW, I am also rebuilding and adding the latest versions of contribs, you will probably come across this similar error again. Check out contrib tracker...I wrote it to keep track of all of my contrbs. Let's you know when there is a newer version.

 

lildog

Thanks, I was able to sort it out and get it working again... I'll check out Contribution Tracker... sounds like it would be VERY helpful!

[chaosnet]

I've installed this according to the instructions (seel below), but am getitng a blank screen upon hitting 'continue' The site can be found here and i'm kinda stuck as to what's going wrong.

 

I wasn't able to complete step 17 due to my site having a different set up on that page, but other than that think it all went in as per instructions.

 

Any help appreciated.

[chaosnet]

***** Fixed ******

 

Had missed out a single / before the starting statement :blush:

[joyces]

Hi

I have installed PWA and although the last contribution by lildog 'Purchase Without Account v2.0f' says it is to stop the "my account" appearing in the breadcrumbs it refuses to disappear for me.

 

On checkout_shipping.php 'Log Off' appears in breadcrumbs and remains there for the rest of the checkout process and once you get to 'checkout_success.php' 'My Account' joins it in the breadcrumbs.

ideally if a customer is not creating an account I don't want either 'Log Off' or 'My Account' to appear at all.

I have now reinstalled 3 times incase i was missing something - has anyone got any idea what I'm doing wrong?

Thanks

Joyces

[CrazyBandit]

I recently installed PWA and am getting the following error:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and categories_id=0' at line 1

 

select discount from groups_to_categories where customers_groups_id = and categories_id=0

 

[TEP STOP]

 

This error occurs after I've put an item in the shopping cart and selected check out without an account. I then get the customer info screen where I enter name, address, etc. It's at the next screen where I get this error.

 

I do have the contrib Discount Groups also installed and I believe the conflict is between these two contribs.

 

You can take a look at the site here MyPerfectCandle.com.

 

Thanks for any help!

Edited October 3, 2008 by CrazyBandit

[blr044]

no searches found in this contribution or instructions for PWA version 2.0f for this error:

 

Parse error: syntax error, unexpected T_DOUBLE_ARROW in /xxxx/xxxxxxxx/xxxxxxxxxxx/includes/classes/order.php on line 82

 

That section od code is below:

 

// PWA BOF
		     'is_dummy_account' => $order['customers_dummy_account']);
// PWA EOF

 

Any ideas any one?

 

Thanks.

[blr044]

no searches found in this contribution or instructions for PWA version 2.0f for this error:

 

Parse error: syntax error, unexpected T_DOUBLE_ARROW in /xxxx/xxxxxxxx/xxxxxxxxxxx/includes/classes/order.php on line 82

 

That section od code is below:

 

// PWA BOF
		     'is_dummy_account' => $order['customers_dummy_account']);
// PWA EOF

 

Any ideas any one?

 

Thanks.

 

I did copy and paste from instructions on this. I even tried this: 'is_dummy_account' => $order['customers_dummy_account']; . But that not solve the issue.

[blr044]

I had to uninstall PWA because of this error code: Parse error: syntax error, unexpected T_DOUBLE_ARROW in /xxxx/xxxxxxxx/xxxxxxxxxxx/includes/classes/order.php on line 82

 

When customers checking out, one would not get beyound the checkout process. So can any one tell me if an later version that can be used where one would receive this error message?

 

Thanks.

[lildog]

You are probably missing or have an extra a comma, or "(" somewhere near that code. Doesn't have to be near but probably is.

 

lildog

[blr044]

You are probably missing or have an extra a comma, or "(" somewhere near that code. Doesn't have to be near but probably is.

 

lildog

 

error was, I had a mistake - ; instead of a ,

 

 

Thanks.

[bluedookies]

I installed PWA today (2.0h). I think I did everything right but I am having one HUGE problem that I can't figure out. I was just wondering if anyone could provide any pointers.

 

tep_session_register('customer_is_guest');

 

I set the session per instructions in create_account.php and nothing. Nothing at all. Later pages never think it is set. I can refer to other sessions and they were set but not this one. I created a random session to see if I could refer to that - nothing. Do I have to do something for new sessions to be registered or acknowledged by OSC? I mean the other session identifiers can be referenced and checked if set, but not this one? Any recommendations or advice? Thanks.