Sql ???

Locked
Results 1 to 7 of 7
This thread is locked. New replies are disabled.
08 Feb 2008, 07:02
#1
dacordave avatar

dacordave

New Zenner

Join Date:
Jan 2008
Posts:
21
Plugin Contributions:
0

Sql ???

I was wondering if there's anyway that I could get a crash course on using SQL or where I can get some sort of step-by-step-hold-my-hand instructions. I mean, I'm trying to add a module to my install of Zen Cart and I aint got the foggiest about how to use SQL, giving commands, etc. I must have missed out on my SQL lessons when I went to kindy.

And dont flatter me by calling me a New Zenner... I'm not worthy of that title yet!

Dacor:lamo:Dave
08 Feb 2008, 07:04
#2
yellow1912 avatar

yellow1912

Totally Zenned

Join Date:
Oct 2006
Posts:
5,422
Plugin Contributions:
0

Re: Sql ???

If you install a new module, it should have instruction inside readme file which you can easily follow without any sql knowledge.

It's good to learn though. And since mysql is open source and widely used, you can find tons of free docs out there, just google for it. Like "mysql tutorial" for example.
08 Feb 2008, 07:10
#3
dacordave avatar

dacordave

New Zenner

Join Date:
Jan 2008
Posts:
21
Plugin Contributions:
0

Re: Sql ???

I know the instructions came with it, but I dont even know how to or where to run commands or anything... I've never seen SQL before. I'm looking at the one to set up multisite... and I aint got a clue about where to run theses commands.... I feel like I'm in a raging river and up to my nose and getting deeper.
08 Feb 2008, 07:11
#4
yellow1912 avatar

yellow1912

Totally Zenned

Join Date:
Oct 2006
Posts:
5,422
Plugin Contributions:
0

Re: Sql ???

Go to Admin->Tools->Sql Patch

You can copy all the sql, paste in the box there, submit, done.
08 Feb 2008, 07:14
#5
dacordave avatar

dacordave

New Zenner

Join Date:
Jan 2008
Posts:
21
Plugin Contributions:
0

Re: Sql ???

Thanks... didnt know that was there... that'll help a lot... Owe you big time....
08 Feb 2008, 07:35
#6
dacordave avatar

dacordave

New Zenner

Join Date:
Jan 2008
Posts:
21
Plugin Contributions:
0

Re: Sql ???

So, what do I do...??
In this particular instance we have a directory called multisite_0.4.1 which has subdirectories ADD_FILES, etc.
I dont know which file to upload or instructions to run (and from where, etc).
What's my next step now I have SQL Query Executor open. ??
Thanks... (and dont go too far away)... sorry... Aussie arragogance!
08 Feb 2008, 10:52
#7
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Posts:
10,324
Plugin Contributions:
0

Re: Sql ???

Let's see what you need...

Firstly, tell us what module you are trying to add to your installation of zencart.

Then we can walk you through the steps.

Please tell us the URL of your webshop so we can see if it's functioning.

Tell us the VERSION of zencart you installed.

Tell us if you know how to use FTP

Tell us if you have a console site management system like C-PANEL.

Do you know how to use phpMyAdmin (or what this means).

Do you manage your webshop through the zencart Admin console (or does someone else do this for you).

Give us as much background as you can and we'll take you through the process.