Jump to content
Sign in to follow this  
bmcewan

Purchase Without Account Updated & Admin Functionality

Recommended Posts

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 by jim@qb

Share this post


Link to post
Share on other sites

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 = 'sales@adappear.co' 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 = 'sales@adappear.com' and guest_account='0'

[TEP STOP]

 

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

Share this post


Link to post
Share on other sites

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 = 'sales@adappear.co' 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 = 'sales@adappear.com' and guest_account='0'

[TEP STOP]

 

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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!

Share this post


Link to post
Share on other sites
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!!!!

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

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


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

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>

Share this post


Link to post
Share on other sites

Hi there,

 

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

 

Many thanks

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 = 'my.emailaddress@verizon.net' 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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 by CrazyBandit

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×