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

ZI Store Updates

Zi Store

Online Users

Registered Users: 2016
Latest Registration: yhamrodne
Online Users: 10
(0 Members, 10 Guests)

Poll

What should be done first on the ZI overhaul?
Find more staff (45%) [10 Votes]
Fix all bugs (36%) [8 Votes]
Make new features (not challenges) (9%) [2 Votes]
Get more content (challenges etc) (9%) [2 Votes]

[Poll Archive]

Kr0wKr0w

Avatar

Last Login:
2012-01-20
Joined:
December 11 2009 01:08
Experience:
2
(17 day(s) ago)
The crashed tables for registration and other stuff is easy to fix (using the Mysql command "REPAIR TABLE").
ttyler333ttyler333
php coder
Avatar

Last Login:
0000-00-00
Joined:
May 09 2008 01:45
Experience:
1095.2
(18 day(s) ago)
according to a friend the registration doesn't work.
hack4uhack4u
ZI Owner
Avatar

Last Login:
0000-00-00
Joined:
March 30 2008 22:30
Experience:
20492
(19 day(s) ago)
Please do keep a list of all the bugs. They might eventually get fixed.. lol.
Hunter XHunter X

Avatar

Last Login:
0000-00-00
Joined:
September 25 2010 15:44
Experience:
0
(01 month(s) ago)
What we could do is start compling a list of bugs on the Tasks page, so if and when development resumes the developers know what needs doing.
Kr0wKr0w

Avatar

Last Login:
2012-01-20
Joined:
December 11 2009 01:08
Experience:
2
(02 month(s) ago)
Kewl, the domain renewed another year. :) Any other future plans?
Hunter XHunter X

Avatar

Last Login:
0000-00-00
Joined:
September 25 2010 15:44
Experience:
0
(02 month(s) ago)
I've got no idea. I'll send off an email to one of the admins in a moment to check, since I've been meaning to contact them anyway.
Hunter XHunter X

Avatar

Last Login:
0000-00-00
Joined:
September 25 2010 15:44
Experience:
0
(02 month(s) ago)
There seems to be ~10 guests on most days, but I have no idea if that's genuine users or crawler bots. If they are real users we need to do something to convince them to register.


Icon Zero Identity Forums - General - General - Skills Center, zomg


Are you bored? Check out the unaswered threads!

irukandji
Member


Avatar
Trainee

Joined: 08/13/2009
Last Seen: 0000-00-00
Experience: 37.9
Points: 370
#1 Skills Center, zomg on 01/01/1970 00:00
Hello :)

Well, I found out about this neat site a few days ago. Really interesting I must say.
Anyways, the problem I'm having is with the first :o challenge, Lesson #1 - SQL.

I did 'em all, except for 6,7, and 9. They seem broken to me.

the 6:th question : "Delete the row that has the city of San Francisco"
DELETE FROM countries WHERE city='San Francisco'

Doesn't work.


7:th : "Update all rows that contain United States as the country and set Los Angeles as the city."
UPDATE countries SET city = 'Los Angeles' WHERE country = 'United States'

Doesn't work.


9:th : " Insert a new row with the following data: Country: France, City: Paris."
INSERT INTO countries (country, city) VALUES ('France', 'Paris')

Doesn't work either, gives me the error : "That is not what we are looking for.". Then what are they looking for?

Seriously, what else options do I have? In what other way can I achieve the objectives?
As far as I know, this is the way. And its quite embarrasing as I have taken a lesson in SQL, tho on a Swedish "upper secondary school" with a straight A+ (MVG). And I've also been coding SQL among with PHP for some years now.

I must be soo newb :S

I'd really appreciate the help.
Grindordie
Administrator
Software Engineer

Avatar
ZI Guru

Joined: 11/04/2007
Last Seen: 0000-00-00
Experience: 1207.57
Points: 1100
#2 on 01/01/1970 00:00
You aren't a novice, your answers are correct, the challenge is just buggy/broken.

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

phpFort - light-weight content management system.
irukandji
Member


Avatar
Trainee

Joined: 08/13/2009
Last Seen: 0000-00-00
Experience: 37.9
Points: 370
#3 on 01/01/1970 00:00
Ok, thanks :) At least it makes the effort worth something.


Who is watching forums


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