customer log in issue

[naschell81 0]

I recently updated to 2.3.4 and a customer informed me they couldn't sign in, or even make a purchase from my site as a guest. I had also recently downloaded and used USPS Rate V4 Intl Rate V2_r3.5.2 so that I could get shipping to calculate properly.

 

my site is www.commissionedcredentials.com

 

Please help.

[♥joli1811 171]

Looks like a 2.3.4 shop did you enable the log in and create account in admin/modules/content ?

[naschell81 0]

Customers where able to do it before the update, is that something I have to re-enable?

[♥joli1811 171]

2.3.4 introduced a few new content modules

 

enable the log in and create account in admin/modules/content/  this may be the problem of course you may have missed part of the update

 

I noticed you have no log in

 

http://commissionedcredentials.com/store/login.php

 

so very possibly a simple solution

 

 

*********************************************************************

 

Manual update instructions are here you can check depending what version

 

http://library.oscommerce.com/Online&en&oscom_2_3&release_notes

[naschell81 0]

Looks like I might not have made changes to the admin/includes/template_top.php file, could that be a reason?

[naschell81 0]

Scouring over the coding and it looks like everything is right, this is starting to get rather frustrating.

[De Dokta 106]

If everything is correctly installed then do what joli1811already told you! Go to your admin > modules > content and install the login modules you want.

[naschell81 0]

Did that now I'm getting this message at the top

Warning: curl_setopt_array() [function.curl-setopt-array]: CURLOPT_FOLLOWLOCATION cannot be activated when safe_mode is enabled or an open_basedir is set in /home/qrgxkhuc/public_html/store/includes/modules/shipping/usps.php on line 651

 

and this when i click on Check out with PayPal

 

Warning: curl_setopt_array() [function.curl-setopt-array]: CURLOPT_FOLLOWLOCATION cannot be activated when safe_mode is enabled or an open_basedir is set in /home/qrgxkhuc/public_html/store/includes/modules/shipping/usps.php on line 651

Warning: Cannot modify header information - headers already sent by (output started at /home/qrgxkhuc/public_html/store/includes/modules/shipping/usps.php:651) in /home/qrgxkhuc/public_html/store/includes/functions/general.php on line 49

[♥joli1811 171]

@@kymation

@@naschell81

 

Yes just had the same error last night using the latest usps module from Jim .

 

I believe this is server related issue  safe_mode !!

[03-Oct-2014 02:22:01 America/Los_Angeles] PHP Warning:  curl_setopt_array() [<a href='function.curl-setopt-array'>function.curl-setopt-array</a>]: CURLOPT_FOLLOWLOCATION cannot be activated when safe_mode is enabled or an open_basedir is set in /home/xxxxxxx/public_html/demo5/includes/modules/shipping/usps.php on line 651

so I installed this contribution which has also just been updated and working fine as far as I have tested

 

http://addons.oscommerce.com/info/487

 

Remember you must uninstall the old first before uploading the new

 

Regards

Joli

[naschell81 0]

Ok that seems to have fixed part of the problem. Now I'm getting this message under the section where you pic your shipping method on the site. -2147219101 Missing value for Service.

 

Also I noticed the following when I logged in as a customer on my site, it popped up a page with:

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

update customers_info set customers_info_date_of_last_logon = now(), customers_info_number_of_logons = customers_info_number_of_logons+1, password_reset_key = null, password_reset_date = null where customers_info_id = '1'

[TEP STOP]

 

When I clicked back a page i was suddenly logged in on my customer account. This is feeling like an ongoing issue.

[♥joli1811 171]

You did not do the updates correctly until you do it will be ongoing :)

 

 

Run this in your database and first backup the database

 

get into the habit of backing the database up before attempting any changes :devil:  or you will be haunted

 

alter table customers_info add password_reset_key char(40);
alter table customers_info add password_reset_date datetime;

[naschell81 0]

So I missed part of an update somewhere ... lovely.

Ok i must be doing something wrong, how do you update your page, because I end up uploading each file individually. Is there a better way or a correct way?

[naschell81 0]

Odd additional Questions time

 

How should I be doing these update?

Is there a recommended way?

Is there a way to install the newest version of osCommerce over what I already have?

Will this reset my inventory causing me to have to reenter everything?

[♥joli1811 171]

Well if you are careful yes  you could just overwrite everything except the include/configure.php  and the admin/include/configure.php

 

SO DO NOT UPLOAD THE X 2 CONFIGURE OR YOU WILL LOSE YOUR SETTINGS!!

 

your inventory is actually in your database nothing to do with the shop files.

 

You mentioned the store was not modified except for the USPS so uninstall that first and when you are finished upload the add on again and reinstall

 

 

Now better if you manually adjust the configure.php's the front shop end is the same but the admin configure  has also changed so you need to be careful there

 

This is the first database change so you need to run this sql after you first backup your database!!!

alter table customers_info add password_reset_key char(40);
alter table customers_info add password_reset_date datetime;

Then run these x 2

alter table sessions modify sesskey varchar(128) not null;

and

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Allow Orders Not Matching Defined Shipping Zones ', 'SHIPPING_ALLOW_UNDEFINED_ZONES', 'False', 'Should orders be allowed to shipping addresses not matching defined shipping module shipping zones?', '7', '5', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now());

Now no guarantee here I think that is all the database changes the rest will be automatic as regards the new content modules

 

So sure someone will correct me if I have forgot any :-

 

I posted a typical admin/configure.php in a directory here (your directory being store I think) so you can compare

 

http://www.oscommerce.com/forums/topic/397417-admin-issues-after-install/page-2

 

post #36

 

Regards

Joli

[naschell81 0]

Thanks, How do I run those though?

 

I'm concerned I've been doing my updates wrong.

[♥joli1811 171]

Database changes are made in your control panel before you change anything you make a back up of your database so if you make a mistake you can roll back and not lose all the work you have done adding products etc.

 

Then you look for phpmyadmin  go there and click on your database at the top somewhere there is a SQL button click this and you can copy and paste the commands in the empty window and run/go

 

Regards

Joli

[naschell81 0]

That seems to have solved some of it. But here are the only two issues I currently have, god willing the last two hopefully.

 

Issue 1

Upon picking an item to buy, clicking on the check out button leads to this image.

Not even remotely sure what this means.

 

Issue 2

Upon picking an item to buy, clicking on the check out with PayPal button leads to this image.

Not sure how the order total is missing when its marked at 1

[naschell81 0]

Still no luck, this is frustrating because I haven't been able to take customer orders for a week now.

[almico1 0]

I just created a store in a subdirectory to get working before I go live. I have an old version 2.2 that got corrupted when my ISP changed servers. I am not am IT guy. Just an old far that has some products to sell. 

 

My new store is at http://www.hobbyspecialties.com/dir

 

I cannot seem to log in. The login form and create account link are enabled in Modules>content

 

I see myself listed as a customer, but I cannot login to checkout. When I do, I go right back to the login screen...help!

[tgely 262]

@@almico1 and your account is created?

[almico1 0]

@@almico1 and your account is created?

 

Yes. I got a message after creating an account under my name that said "congratulations...". When I go into the admin back end I see my account information list there. 

 

But when I add an item to my cart, then click checkout I get a login screen again. When I login the blank login screen comes right back and the item is no longer in my cart. When I hit the back button on my browser I get the cart back with my item in it. 

 

Try it, if you would. Go to the site I listed above and create an account. 

 

FWIW, when I select PayPal to checkout I see the item there. It's just not acknowledging the login through normal checkout. 

[almico1 0]

Weirdness. It was a Safari issue. When I opened the site in Chrome it worked fine.