Forums / Upgrading from 1.3.x to 1.3.9 / Wich SQL to choose? upgr 138 to 139 or only sgl??

Wich SQL to choose? upgr 138 to 139 or only sgl??

Locked

Views: 6,360

Results 21 to 40 of 40
This thread is locked. New replies are disabled.
2 Jun 2010, 1:18 PM
#21
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Location:
Australia
Posts:
6,263
Plugin Contributions:
4

Wich SQL to choose? upgr 138 to 139 or only sgl??

frank18:

You enter this into the address field of your browser:

http://www.your_site.com/your_testing_folder**/zc_install/index.php**

Tried that. Got this:
Firefox can't find the server at www.your_site.com.

Any other ideas?

NOTE: We are sorry that Rod is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

2 Jun 2010, 1:29 PM
#22
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

Before doing everything you said I should do, I want to simply upload/import 139c as is to my new temporary, and empty, databas.
Via phpmyadmin I imported the dowload file from zen-cart website/Sourceforgenet called zen-cart-v1.3.9c-full-fileset-05162010.zip

phpmyadmin result when importing it gave me 0 files installed. Any clues to why?

2 Jun 2010, 2:50 PM
#23
drbyte avatar

drbyte

Sensei

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

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

RodG:

Tried that. Got this:
Firefox can't find the server at www.your_site.com.

Any other ideas?

Rod, are you trying to help the OP? or are you trying to talk about something you are having problems with on your site?
If your post is NOT part of the present discussion, please start a separate thread for it, as it doesn't sound like it's relevant here.

.
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.

2 Jun 2010, 3:10 PM
#24
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Location:
Australia
Posts:
6,263
Plugin Contributions:
4

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

DrByte:

Rod, are you trying to help the OP? or are you trying to talk about something you are having problems with on your site?
If your post is NOT part of the present discussion, please start a separate thread for it, as it doesn't sound like it's relevant here.

I was trying to replicate the OP's problem and following Frank18's suggestion.
:p

I know when my help isn't needed though, and since its 1am here I'm off to bed. :sleep1:

Cheers
Rod.

NOTE: We are sorry that Rod is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

2 Jun 2010, 3:30 PM
#25
drbyte avatar

drbyte

Sensei

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

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

Your sarcasm isn't helping things any.

.
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.

2 Jun 2010, 5:41 PM
#26
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,853
Plugin Contributions:
18

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

Stefanl,

Sorry for the bad translation, but let's try this....

Behaga berätta oss vad du skulle skriva på maskin i din beter till komma till din temporär version av Zen Cart.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

2 Jun 2010, 6:07 PM
#27
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

dbltoe:

Stefanl,

Sorry for the bad translation, but let's try this....

Behaga berätta oss vad du skulle skriva på maskin i din beter till komma till din temporär version av Zen Cart.

It wasnt the best translation - Google translate ;-) - but I like that you did it.

So if I understand the swedish translation good enough, your question was why I like to use a temporary database?

If the question was such, it is because I dont dare to upload the new version 139c until I know its working and looking like it should do, and until I know I am doing everything by the book.

2 Jun 2010, 6:14 PM
#28
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,853
Plugin Contributions:
18

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

NO, the question was not thought out well by me.

What you need to do is enter into your browser, the address of your temporary files and add /zc_install/index.php.com to the end of the address you type in.

For instance, let's say your site is stefanl.com and your 139c files are in 139c.

In that case, you would enter http://www.stefanl.com/139c/zc_install/index.php.

That will start the installer that will load a NEW copy of all the files and create the new database.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

2 Jun 2010, 6:38 PM
#29
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

dbltoe:

NO, the question was not thought out well by me.

What you need to do is enter into your browser, the address of your temporary files and add /zc_install/index.php.com to the end of the address you type in.

For instance, let's say your site is stefanl.com and your 139c files are in 139c.

In that case, you would enter http://www.stefanl.com/139c/zc_install/index.php.

That will start the installer that will load a NEW copy of all the files and create the new database.

Thanks!
I have been sending emails and got some respons and hopefully a new one tomorrow from my webhost.
Still liked the swedish though.
Because you know know Swedish here is a swedish newspaper website, use google translate if needed ;-) https://www.dn.se

3 Jun 2010, 2:39 PM
#30
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

I now have a temporary zencart up and running, on a subdomain on my website. The 139c is there and I can also log into my admin, BUT when looking at the demo/temp zencart on the web I see no visual difference. It is only the default design, which I of course isnt using.

Can it be that the admin folder I use on the temporary zencart has a different name than my regular sharp zencart?

3 Jun 2010, 4:28 PM
#31
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,853
Plugin Contributions:
18

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

No.

You will get the "standard" look until you customize your template.

See https://www.zen-cart.com/tutorials/index.php?article=142

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

4 Jun 2010, 6:22 AM
#32
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

dbltoe:

No.

You will get the "standard" look until you customize your template.

See https://www.zen-cart.com/tutorials/index.php?article=142

I have a ovveride "CUSTOM" folder system, the same as for my webshop that is already running with that customized look.

But the temporary site on my subdomain dont recognize the "custom" ovveride folders, of some reason.

4 Jun 2010, 6:27 AM
#33
get_em_fast avatar

get_em_fast

Totally Zenned

Join Date:
Dec 2006
Location:
Seligman, MO U.S.A.
Posts:
2,072
Plugin Contributions:
1

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

Have you set it to use your custom template, yet?
Admin>Tools>Template Selection

Teach them to shop and they will shop today;
Teach them to Zen and they will OWN a shop tomorrow!

4 Jun 2010, 7:17 AM
#34
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

Get Em Fast:

Have you set it to use your custom template, yet?
Admin>Tools>Template Selection

That did - to some extent, thanks! Why did I forget that ;-)
But it doesnt seem it recognized all CUSTOM folders. It doesnt recognize all sideboxes and all. They are all set to OFF. Is here a selection that make all to be ON right away? I will set all individaully to ON though

4 Jun 2010, 7:38 AM
#35
get_em_fast avatar

get_em_fast

Totally Zenned

Join Date:
Dec 2006
Location:
Seligman, MO U.S.A.
Posts:
2,072
Plugin Contributions:
1

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

Admin>Tools>Layout Boxes Controller

At the bottom of that screen you'll see a "reset" button. Click it. That should set the boxes exactly like you had them.

Teach them to shop and they will shop today;
Teach them to Zen and they will OWN a shop tomorrow!

4 Jun 2010, 7:49 AM
#36
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

get em fast:

admin>tools>layout boxes controller

at the bottom of that screen you'll see a "reset" button. Click it. That should set the boxes exactly like you had them.

thanks!!!

4 Jun 2010, 7:55 AM
#37
get_em_fast avatar

get_em_fast

Totally Zenned

Join Date:
Dec 2006
Location:
Seligman, MO U.S.A.
Posts:
2,072
Plugin Contributions:
1

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

Not a problem.

Teach them to shop and they will shop today;
Teach them to Zen and they will OWN a shop tomorrow!

10 Jun 2010, 4:57 PM
#38
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

Get Em Fast:

Not a problem.

I just felt I had to double chcek to feel comfortable enough.

My webhost helped installing the 139c on my server.
I then afterwards FTP transfered all 130d files.
In the Admin log in page it now says I have version 139d.

When I look further in the admin page I see that the level seem to be 139c despite it being version 139d.

I have learned that means 139d have to be pathed up from the 139c?

I have then afterwords learnet that I should use ZC_Install to pathc up my 139d to a "real" 139d.

Is this correct and if so how should I go about doing all the proper steps so my current temporary on a subdomain doesnt f-up.

Thanks

11 Jun 2010, 9:05 AM
#39
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

Hope someone will see my previous question about the patch 138 to 139

In any case I just tried the zc_install in my browser, tryinbg to PATCH UP 139c to 139d as I previously asked about in my previous question, BUT after "accepting" terms & conditions and click "continue" I got a ERROR message saying

ATTENTION: Problems Found
ERROR - Cannot proceed until problems are resolved.

* /admin/includes/configure.php does not exist more info...
* store configure.php is not writeable more info...

It says as you can see that it looks for /admin/includes/configure.php.
This is strange considering I previously changed my admin folder to something else already when I installed the 139c and afterwords transfering 139d files.

How can I fix this?
I wont reinstall the whole thing again will I?

11 Jun 2010, 5:31 PM
#40
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,853
Plugin Contributions:
18

Re: Wich SQL to choose? upgr 138 to 139 or only sgl??

stefanl,
Scroll to the bottom of that page and you will see a button for database upgrade.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com