chrometweaks.org

Can I access iPage's MySQL database from my local computer? If so, how?

Click Here To View All Answers...


Quick question: Can I access iPage's MySQL database from my local computer? If so, how? Many thanks for any comment. Second question of mine... I'm having problems with the iPage site www.starchsupplies.co.uk, (it is a live store, so dont buy unless you want really crisply ironed shirts.

!) on account creation/Address book editing, I cannot enter the county as London it just returns:.

"Please select a county from the county pull down menu.".

In the past, when I've experienced this problem, it has been because of a duplicate record in the zones table, however this isnt the case, no duplicate ID's, Zone Codes, or Zone Names. I've deleted the record and recreated it, still doesnt work, however it only happens (as far as I can see) to London, as any other randomly picked county works..

Any idea's?.

Would it get confused with Londonderry? I dont think so, but I could be wrong..

Thanks,.

Leigh..

Comments (98)

Yes sir! however you might wanna make sure and wait for another person to confirm this as I am not sure. Better yet, why don't you give a call to the iPage guys because they can help better...

Comment #1

Sorry I mean phpmy, to make sure it's there...

Comment #2

Sorry, I thought the forum emailed you when it had a reply. Yes, the code is definately there, Zone_Country ID 222, Unique ID something like 263, Short Code, LDN (But I have tried it as London aswell) Description London..

Alas Cant figure it out..

Comment #3

Hi.

I have the same problem as well..

There don't seemto be any duplicates in the zones table..

Anyone else got any ideas or seent his before?.

Thanks.

Tim..

Comment #4

Hi.

I've changed the name of the county to "Greater London" which I believe is the official county name anyway. It works now but I have no idea why "London" is unacceptable..

Regards.

Tim..

Comment #5

I have been dealing with the LONDON state for 2 months...at last, found your solution here that change it to GREATER LONDON and it works!!!.

This is so weird!!! Why LONDON is not able to use, I search through my MYSQL in PHPADMIN and not found any duplication???.

Is it the oscommerce somewhere blocking the LONDON word??.

Any one got any idea???..

Comment #6

The code that looks up "states" uses the "like" SQL operator, and looks to see if there are multiple matches. It would not astonish me if it gets upset by two "states" beginning with "London"...

Comment #7

I personally agree with stevel's comments, as I found after further investigation that it was clashing with Londonderry in Ireland, I removed 'Londonderry' and this worked fine, perhaps the code should be changed to a '=' instead of 'like'. Not looking at the code at the moment, does anyone have a reason why it is set to like anyway, perhaps a bug that should be addressed?..

Comment #8

The code assumes that the user may not type in the "state" exactly the way it shows in the zones database..

An alternative is to use my Country-State Selector contribution in conjunction with an appropriate.

Zones contribution.

, such as.

World Zones.

That way, if there are zones defined, the user will have to select from a pulldown list and there will be no issue of them typing it in wrong...

Comment #9

I'm having problems with the iPage site www.starchsupplies.co.uk, (it is a live store, so dont buy unless you want really crisply ironed shirts.

!) on account creation/Address book editing, I cannot enter the county as London it just returns:.

"Please select a county from the county pull down menu.".

In the past, when I've experienced this problem, it has been because of a duplicate record in the zones table, however this isnt the case, no duplicate ID's, Zone Codes, or Zone Names. I've deleted the record and recreated it, still doesnt work, however it only happens (as far as I can see) to London, as any other randomly picked county works..

Any idea's?.

Would it get confused with Londonderry? I dont think so, but I could be wrong..

Thanks,.

Leigh..

Comment #10

Have you tried entering the code in the admin area for a London Zone? Check there first to see if thats ok...

Comment #11


This question was taken from a support group/message board and re-posted here so others can learn from it.