Post by rassalas » Tue Sep 03, 2013 7:41 am

butte wrote:rassalas, I responded to your, "don't remember ever doing the paypal decimal tax fix VQMod,
Butte,
Thank you, I saw that, it's just what you wrote didn't make any sense to me. Are you certain, we are talking about the same error? I exported the Database to a text file as you suggested and did a search on company_id, and company_id_display, as well as tax_id, and tax_id display, I found all of them as you thought I might. Here's a brief summary:

Code: Select all

CREATE TABLE `opn_customer_group` (
  `customer_group_id` int(11) NOT NULL AUTO_INCREMENT,
  `approval` int(1) NOT NULL,
  `company_id_display` int(1) NOT NULL,
  `company_id_required` int(1) NOT NULL,
  `tax_id_display` int(1) NOT NULL,
  `tax_id_required` int(1) NOT NULL,
  `sort_order` int(3) NOT NULL,
  PRIMARY KEY (`customer_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
After reading all that I went back to the database itself and looked under the opn_customer_group table. I found the entries again. The problem Is it looks fine, I can't see anything that looks like a bug. I was thinking about it last night as I was falling asleep, and I decided to try to checkout as a guest. To see what happens. So I just did that, and while I'm filling out that info I note the fields for Company Id and Tax Id are included under step 2 Billing Detail-> your address. Not only that those fields are marked as required. (see below) What if I'm just a person, and I don't have a company ID. From all that data we've reviewed, I think I should be able to fix this using the dashboard. But I don't seem to be able to find anywhere in the dashboard that addresses this issue. Thank you for your interest! Please enlighten if possible any and all.

Attachments

billDetail.png

I don't want the customer Tax Id In checkout.!!! - billDetail.png (11.03 KiB) Viewed 4239 times


Newbie

Posts

Joined
Tue Aug 27, 2013 9:05 am

Post by rassalas » Tue Sep 03, 2013 8:14 am

I think I figured it out, I went in and edited my customer groups, and I'm past that bug. Now I'm stuck on a shipping error,
That was why I decided to upgrade to the newest version in the first place, so I'll have to ponder those error codes, I may have a question or two on that but I think it will be under a different topic.
Thank you for helping me find the problem!

Newbie

Posts

Joined
Tue Aug 27, 2013 9:05 am

Post by butte » Tue Sep 03, 2013 8:27 am

You posted while I was readying to post. Congratulations on that part.

Since you do not share the vqmod Paypal Decimal Tax Fix part above, and you do have both company_id and tax_id in your database as well as showing in the storefront. That sets your experience apart. There is a recent instance of no tax_id in database or showing in storefront, and that one seemed similar above, but with more details on the table now is obviously not relevant here. Among your vqmod/logs/ and system/logs/ you are [were] seeing undefined index, customer_id_Display and Tax_id_display. (That differentiates them from customer_id and tax_id, I may have overlooked _display iteself.) I think you fixed it with no further help than keeping your mind on it.

"Required" can be altered to not when you need to do that.

A customer with no company id should presumably have that field show blank (maybe 0). The pattern in your table's field will tell that.

Shipping should be set apart as a new thread so it'll stand out as a shipping matter, rather than buried under a button.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by rassalas » Thu Sep 05, 2013 7:13 am

Ok I'm afraid I'm not out of the woods yet. There are two issues that are still holding me up. The first I think is still relevant to this discussion. If you recall I was experimenting with the guest checkout, when I last made the progress we discussed. When I went back to my normal login and tried to checkout, I came up with a similar error as before.
2013-09-04 23:07:19 - PHP Notice: Undefined index: company_id_display in /srv/disk3/692737/www/parsecsunlimited.com/shop/catalog/controller/checkout/payment_address.php on line 144
2013-09-04 23:07:19 - PHP Notice: Undefined index: tax_id_display in /srv/disk3/692737/www/parsecsunlimited.com/shop/catalog/controller/checkout/payment_address.php on line 149
So today I went back and created an account for Herman Munster at 1313 Mockingbird lane, and went through the checkout process. It seemed to work fine I got all the way to the confirm order page before I abandoned the effort.

So Now I think there's something different about the customers that registered before I started to do my last upgrade, compared to the new ones. That problem is kind of bad I could ask my customers to re-register and purge the old users from the database, but I would prefer to maintain continuity.

The second Issue I think should be posted elsewhere, but I'll just state it here for now. When I try to checkout with downloadable goods, I am not allowed to use the guest registration. However If I try to checkout with a T-Shirt or what have you the option for guest checkout appears. Is there something simple I'm missing there? if not, just focus on my first issue.

Newbie

Posts

Joined
Tue Aug 27, 2013 9:05 am

Post by butte » Thu Sep 05, 2013 7:47 am

(1) It had looked very carefully at Herman's address . . .

(2) Did you happen to change the encryption key (System / Settings, Store / Edit, or perhaps via just differing OC defaults) between "before and after"?

(3) Guests cannot download, only registrants, and that's to control downloads. That is normal, not a problem.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by rassalas » Thu Sep 05, 2013 8:22 am

(2) Did you happen to change the encryption key (System / Settings, Store / Edit, or perhaps via just differing OC defaults) between "before and after"?
I may have. I'm not sure. I found that data piece, and it's a number I recognize. Part of my problem is I work on this part of my projects quite infrequently, and often have to relearn everytime I start to mess with it. If it is changed from the earlier key, is there anything I can do to reset my older users?

Newbie

Posts

Joined
Tue Aug 27, 2013 9:05 am

Post by butte » Thu Sep 05, 2013 10:21 pm

The earlier default was 12345. If that is the one you recognize, then you should be able to find others that you tried in database backups of different vintages. There are several reasons for keeping old database backups, that's one.

Perhaps even most users never realize that it should be changed, and there is as yet no provision for a field in each affected table to ensure that the then-current encryption is used for every record, such that if the encryption is changed, then prior and subsequent records still have their proper ones at the ready. When it is changed, there is risk that prior and subsequent records are immediately placed into two camps.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by rassalas » Fri Sep 06, 2013 6:44 am

Well the one I recognize is a number series I sometimes use, not 12345. It's likely I saw the 12345 and said that's dumb, and just changed it and forgot about it.
So today I changed it to 12345 and tried it with my old user account. The problem, still came up when I tried to checkout.
So I guess that means the old encryption key wasn't 12345...

So I do have some old backups, I might have to look on my old laptop to find them, but I may be able to dig some stuff out, but how would I try to find the Key in it? I just pulled up my most recent backup.txt version of it, and did a find for "key" also tried a find on the key series I am using. But I only found one match and that might have just been a bit of data from the context I found it in...

Newbie

Posts

Joined
Tue Aug 27, 2013 9:05 am

Post by butte » Fri Sep 06, 2013 7:39 am

You can check database backups from OC and from phpMyAdmin, both will end .sql -- the formats inside them differ slightly. You can open .sql files with a text editor. Blocks of gibberish, bash as it is called, for text blocks (such as descriptions) won't be of interest.

The encryption key will be in one cell, for the store, in a store or oc_store or similar table, in essentially the same place in each database backup. Look for (Find) "encrypt" (that will take in encryption), but "key" would stop at least once on every table. You can look in the current database for the term and position along with other store details, so that you can zero in on the table and record quickly. For example, several of the store settings appear only once -- but "encrypt" may show up several times in different contexts (such as passwording) till you tire of hitting "next".

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by rassalas » Sat Sep 07, 2013 5:51 am

Strange I wentinto the database using myphp, and found opn_store. That had four columns. Store_ID, Name,URL, and SSL
but they are all empty, Myphp says there is no rows and it won't let me browse the table. Am I looking in the wrong place or have I perhaps found the bug?

Newbie

Posts

Joined
Tue Aug 27, 2013 9:05 am

Post by butte » Sat Sep 07, 2013 7:52 am

It won't let you browse a table with no records, there's nothing to be browsed. Those four for an empty row mean no entries were made (or at least no entries were recorded as saved). The encryption key (12345 or other) works whether the shop is ssl or not. You could try Find in an older .sql for "12345" to see where it sits.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by rassalas » Sat Sep 07, 2013 9:52 am

I guess I'm lost, As I mentioned I looked where you said and found an empty table, So i I went back to try and do a search from phpmyadmin, and there was no search button ! I must be in over my head because I seem to be traipsing around and not getting anywhere closer to a solution....

Newbie

Posts

Joined
Tue Aug 27, 2013 9:05 am

Post by butte » Sat Sep 07, 2013 10:15 am

Let's recap square one -- open an older .sql in a text editor, use Find (both Next and Previous as need be) to locate the string "12345" and to locate the string "encrypt" in order to see just where that field is. There is no such easy way inside phpMyAdmin, although you could run a query for a string (a "string" of keyboard characters), and a text editor is probably quicker. You'll get there.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by rassalas » Tue Sep 10, 2013 8:20 am

butte wrote:Let's recap square one -- open an older .sql in a text editor, use Find (both Next and Previous as need be) to locate the string "12345" and to locate the string "encrypt" in order to see just where that field is. There is no such easy way inside phpMyAdmin, although you could run a query for a string (a "string" of keyboard characters), and a text editor is probably quicker. You'll get there.

Ok, I've followed up on this. I went to my old laptop and dug up some of my old database backups. I opened them in notepad as .txt and did some searches on "Encrypt"

In one I did find the 12345 String. in a different one I found some random looking string that started with 0x32.....
I tried replacing the key to 12345 as I tried before and still no luck with that, also I tried it with the 0x32... key.
Neither of them worked.

So I'm thinking this is not the droid I'm looking for.

In summary What I've found is encryption key does not matter, with my old login I can't go through checkout, but with the new user I created last week, (Herman Munster) I have no problem getting all the way to step 6 'confirm order.' This last was just re-verified with the 0x32 encryptian key, Which I just found today and know was not active when I created that user.

So the problem is different. I've posted the Error log entries in the past they appear to be complaining about the same thing each time, I've done a screen cap of the message I get while checking out, I'll post that below. Thank you for your interest so far, I hope I'm still narrowing the issue, and will soon come to the right solution..

Attachments

error_cap.png

error_cap.png (15.52 KiB) Viewed 4069 times


Newbie

Posts

Joined
Tue Aug 27, 2013 9:05 am

Post by butte » Tue Sep 10, 2013 11:26 pm

A very few people have now had problems with or saying company_id/tax_id or company_id_display/tax_id_display. In your instance, rassalas, what worked for others but hasn't worked for you may (or not) relate to subtleties of the server. Those who are already evaluating code changes for 1.5.5.1 and up will already have noticed the several but thus far few incidents. Hang in there, somebody will think of something to try -- while you are, too.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by visnetmedia » Wed Sep 11, 2013 2:01 pm

Hi I think the problem with the decimal tax vqmod was it changed the language text file and so the order language file was different so it didn't work. I also had to make sure that my customer group was selected Admin -> Sales -> Customers -> Customer Groups.

Active Member

Posts

Joined
Fri Feb 12, 2010 7:17 am

Post by rassalas » Fri Sep 13, 2013 7:43 am

visnetmedia wrote:Hi I think the problem with the decimal tax vqmod was it changed the language text file and so the order language file was different so it didn't work. I also had to make sure that my customer group was selected Admin -> Sales -> Customers -> Customer Groups.
Visnet, I'm not sure if your info applies to me. I don't think I should need to worry about vqmod because I'm US I looked at my customer groups and there is only one option default. when i look at my customers, mine included, i see they are in the default group.

Newbie

Posts

Joined
Tue Aug 27, 2013 9:05 am

Post by joydeziners » Fri Oct 09, 2015 5:13 pm

hi,

Sorry for My Bad english,

issue in Checkout and registration buttons not available to continue
http://apollo.intellizeinfosolutions.co ... t/register

Plz help me..

Newbie

Posts

Joined
Thu Oct 08, 2015 9:07 pm
Location - India
Who is online

Users browsing this forum: Semrush [Bot] and 5 guests