Forums / Installing on a Linux/Unix Server / A database quirk in 1.3.8?

A database quirk in 1.3.8?

Locked

Views: 2,046

Results 1 to 12 of 12
This thread is locked. New replies are disabled.
3 Jan 2008, 10:46 PM
#1
andy1234 avatar

andy1234

Zen Follower

Join Date:
Oct 2006
Posts:
148
Plugin Contributions:
0

A database quirk in 1.3.8?

Hi,

I have installed 1.3.8 three times and it creates tables adding the password as prefix, i.e.

address_book is created as passwordaddress_book

tried three times... exactly the same problem

Any quick hack here?

4 Jan 2008, 12:11 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: A database quirk in 1.3.8?

what are you entering for a prefix?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Jan 2008, 12:17 AM
#3
andy1234 avatar

andy1234

Zen Follower

Join Date:
Oct 2006
Posts:
148
Plugin Contributions:
0

Re: A database quirk in 1.3.8?

Nothing as a prefix. If I enter a prefix, it works. I tried to debug it by checking the value of getConfigKey('DB_PREFIX') in the function dbLoadProcedure (installer.php):

echo 'prefix'.$this->getConfigKey('DB_PREFIX');

Even if there is no prefix entered, it returns the entered password value

4 Jan 2008, 12:24 AM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: A database quirk in 1.3.8?

Puzzling. I've never seen that happen.
I would suspect file corruption but would expect different symptoms if files were bad.
What version of PHP?
What hosting platform?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Jan 2008, 12:31 AM
#5
andy1234 avatar

andy1234

Zen Follower

Join Date:
Oct 2006
Posts:
148
Plugin Contributions:
0

Re: A database quirk in 1.3.8?

php 4.4.2, freeBSD

I have installed over 50 1.3.7 carts and never had this before.

4 Jan 2008, 12:43 AM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: A database quirk in 1.3.8?

Agreed - definitely bizarre. I've never seen it before either.

I can only guess that somehow the GPC data is getting mangled by PHP once it gets into memory.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Jan 2008, 12:46 AM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: A database quirk in 1.3.8?

Are Register Globals on by any chance?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Jan 2008, 12:51 AM
#8
andy1234 avatar

andy1234

Zen Follower

Join Date:
Oct 2006
Posts:
148
Plugin Contributions:
0

Re: A database quirk in 1.3.8?

yes, Register Globals On

4 Jan 2008, 12:53 AM
#9
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: A database quirk in 1.3.8?

Can you turn them off and try again?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Jan 2008, 1:02 AM
#10
andy1234 avatar

andy1234

Zen Follower

Join Date:
Oct 2006
Posts:
148
Plugin Contributions:
0

Re: A database quirk in 1.3.8?

ok, give me some time as I will have to reinstall it on another subdomain, because, I have already installed this one with a prefix (the only way I could get rid of the password as a prefix):lookaroun

5 Jan 2008, 1:41 AM
#11
andy1234 avatar

andy1234

Zen Follower

Join Date:
Oct 2006
Posts:
148
Plugin Contributions:
0

Re: A database quirk in 1.3.8?

tried to reinstall it with Register Globals Off - exactly the same problem. Note that I have Globals On for all the zen sites all the time and never had such a problem with 1.3.7

Somehow, ConfigKey('DB_PREFIX') is equal to the password field. I tried digging into a code thinking that it has a simple typo error somewhere mixing up the fields, but could not find any

5 Jan 2008, 2:47 AM
#12
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: A database quirk in 1.3.8?

andy1234:

I tried digging into a code thinking that it has a simple typo error somewhere mixing up the fields, but could not find any

Same here.

Most bizarre.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.