Zero Identity
Username: Password:
[Forgot Password?] [Not Registered?]

ZI Store Updates

Zi Store

Online Users

Registered Users: 1426
Latest Registration: gohan
Online Users: 10
(0 Members, 10 Guests)

Poll

What should be done with ZI from here on out?
Get the staff to come back and work on it. (19%) [13 Votes]
Shutdown the site. (2%) [2 Votes]
Leave it to rot. (1%) [1 Votes]
Get new staff to work on it. (76%) [52 Votes]

[Poll Archive]


Icon Zero Identity Forums - General - Rules / Announcements / Suggestions - Skills Center: Lesson #1 - SQL - problems


Are you bored? Check out the unaswered threads!

micky
Member


Avatar
Newbie

Joined: 03.02.2009
Last Seen: 10 year(s) ago
Experience: 37.4
Points: 40
#1 Skills Center: Lesson #1 - SQL - problems on February 03 2009 21:18
Hello, i've been testing out the challenge system and to be honest i cant understand WHY it`s not working.
Having around 7 years of MySQL Experience this kind of bummed me up since my answers did not work in your tests opposed to a real live db test.

EDIT BY AQUILO: I understand that you are trying to make a point, but the evidence you used was the answer to some of the earlier questions in the test. We don't want to spoil this for our other users

Neither sql statements worked and i gave up trying.

Please specify WHY they did not since they are valid in any current MySQL version ( at least ver 3.0 to 5.1 ).

Or if these sql statement questions are based on another Database Server / Database Technology please specify it in the lesson`s description!

Thank you for taking the time to read my post.
Micky.
P.S. I realize this is my first post but take a look anyway.
Aquilo
Administrator
God of the Winds

Avatar
Advanced Analyst

Joined: 04.04.2008
Last Seen: 71 year(s) ago
Experience: 148.13
Points: 615
#2 God of the Winds on February 03 2009 21:41
The SQL test is on an actual MySQL database. It is not simulated in anyway. Please check your answers again.

We cannot specify why your answers are not working because that would essentially be giving you the answer.

May the Winds be with you.
Grindordie
Administrator
Software Engineer

Avatar
ZI Guru

Joined: 04.11.2007
Last Seen: 10 year(s) ago
Experience: 1074.3
Points: 1100
#3 on February 04 2009 01:22
A correcting to Aquilo's post, we use SQLite databases for the challenges.
The syntax for SQLite as far as my knowledge goes is the standard SQL syntax.

The only problem I can imagine is if you are not entering the correct table or field names.

That's not a bug, that's an unexpected feature

phpFort - light-weight content management system.
Psiber_Syn
Member
alert(HIGH)

Avatar
Starting Analyst

Joined: 09.02.2009
Last Seen: 10 year(s) ago
Experience: 80.6
Points: 450
#4 on February 15 2009 23:15
i too have problems with the skillz center sql test 6 7 and 9 my formate is correct and my fields are also yet it doesnt work :-(

Image
Image
Image
oofki
Member


Avatar
Advanced Analyst

Joined: 31.05.2008
Last Seen: 10 year(s) ago
Experience: 150.8
Points: 640
#5 on March 21 2009 22:39
EDIT BY SWIFTNOMAD. PLEASE DONT GIVE OUT ANY ANSWERS.
mundisum
Member


Avatar
Starting Analyst

Joined: 23.03.2009
Last Seen: 10 year(s) ago
Experience: 4
Points: 675
#6 on March 27 2009 06:19
I'm having problems with the insert, update and delete... can't get them to work and I know I'm entering valid SQL-syntax.

Image
Kruptein
Member


Avatar
Trainee

Joined: 09.04.2009
Last Seen: 10 year(s) ago
Experience: 34.2
Points: 80
#7 on April 09 2009 11:35
There are indeed problems, I'm quit sure,
maybe the 'designer' from the chall, had something else in mind, but my method works fine too!
Can I PM someone, to say what I think also is possible but doesn't work?

Thanks!
Aquilo
Administrator
God of the Winds

Avatar
Advanced Analyst

Joined: 04.04.2008
Last Seen: 71 year(s) ago
Experience: 148.13
Points: 615
#8 on April 09 2009 12:55
Yes we know it is broken, and we openly admit this...and we are trying to fix it, but we can't find why it doesn't work. Trust me, we are working on it...thank you for your concern though.

May the Winds be with you.
Kruptein
Member


Avatar
Trainee

Joined: 09.04.2009
Last Seen: 10 year(s) ago
Experience: 34.2
Points: 80
#9 on April 10 2009 03:30
Ok, thanks, I know you will find it :)


Who is watching forums


Users viewing this page: Guests (1)
Users viewing the forum: 0