Site maintenance: Sun 15 Nov, from 12:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Forums / Installing on a Linux/Unix Server / installing a template-uploading the sql table update

installing a template-uploading the sql table update

Locked

Started by cudaboy71 on 19 Jul 2006, 12:55 AM · Views: 2,644

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
19 Jul 2006, 12:55 AM
#1
cudaboy71 avatar

cudaboy71

New Zenner

Join Date:
Apr 2006
Posts:
54
Plugin Contributions:
0

installing a template-uploading the sql table update

i've never purchased one of the many available zencart templates before. but, one of my clients authorized its purchase. so, i'm working with one now.

i'm to the point where i need to update the tables in the sql database before i activate the template. but, i've never actually had to restore a database before (lots of backups--just never a restore).

what's more is it's just a field/table update. i'm not using the full.sql file with sample data.

so, my dilemma is my host's import utility (godaddy.com) seems to expect a CSV file. this is fine for the zencart backups, as that's what it creates. and, how do i specify that i'm only doing a table update and not a complete overwrite of the existing database?

the template we purchased includes a .sql file. what sort of magic do i need to perform on this file to get it to work? is there another way? all the help files i read say "contact your host for help". godaddy was less than enthusiastic about helping me. in fact, he didnt even want to really take my call. all he kept saying was "go to help.godaddy.com". thanks tech 'support'.

anyone give me some guidance?

thanks.

19 Jul 2006, 12:57 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: installing a template-uploading the sql table update

We do not sell any templates ... who did you buy this from?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

19 Jul 2006, 1:47 PM
#3
cudaboy71 avatar

cudaboy71

New Zenner

Join Date:
Apr 2006
Posts:
54
Plugin Contributions:
0

Re: installing a template-uploading the sql table update

if you google for zencart template you'll see that there are several resellers. the first hit for example, sells the template we purchased.

I didn't think these were any huge mystery. I was hoping someone had worked with one before.

19 Jul 2006, 2:00 PM
#4
tinas avatar

tinas

Totally Zenned

Join Date:
Jan 2005
Location:
Lake Havasu, AZ
Posts:
1,090
Plugin Contributions:
0

Re: installing a template-uploading the sql table update

These templates appear to be 1.2 templates given the number of tables I see when I view source. Of course the site says absolutely nothing about which version the templates are for.

In any case it looks as though you may have more than just an issue of SQL with these templates.

Sorry I cannot help more, but personally, after looking at what these ppl charge and what you got, you would have been better off to hire someone from the Commercial Help Wanted section to create a template for you.

When the world gets in my face I say Have A Nice Day.

19 Jul 2006, 2:08 PM
#5
sermonzone avatar

sermonzone

Zen Follower

Join Date:
Oct 2005
Location:
New Mexico
Posts:
365
Plugin Contributions:
0

Re: installing a template-uploading the sql table update

Algozone templates templates often have a 1.2+ AND a 1.3+ version. I suggest you con firm whether a 1.3+ version is available. However, even the 1.3+ versions are built in a peculiar way. IMO this programmer ports his designs from another shopping cart and does not build them for Zen from the ground up.

Algozone has nice looking graphic design and layout but the coding has given problems to several users. Be cautious of any mods from the forum if you get it running. The Algo changes sometimes do not play well with others.

19 Jul 2006, 8:58 PM
#6
cudaboy71 avatar

cudaboy71

New Zenner

Join Date:
Apr 2006
Posts:
54
Plugin Contributions:
0

Re: installing a template-uploading the sql table update

thanks all.

these are indeed 1.2 templates. i did not contact them for a 1.3 version (though i should have). rather, i just built the site with 1.2.6d. I have several others still running 1.2 just fine.

As for hiring out to have a template built, maybe next time. But my client really liked the one from algozone. So, I make due ;)

As for my original question, I never got any clarification from anyone. So, i just bit my cheek and uploaded the .sql file via godaddy's interface and it loaded fine :D

19 Jul 2006, 10:37 PM
#7
vger avatar

vger

Past Contributor

Join Date:
Nov 2004
Location:
Norfolk, United Kingdom
Posts:
3,189
Plugin Contributions:
0

Re: installing a template-uploading the sql table update

So, i just bit my cheek and uploaded the .sql file via godaddy's interface and it loaded fine

It's all part of the plan - make people wait long enough so they do it themselves and thus become more accomplished and independent :D

Vger