|
|
|
|
![]() ![]() |
Jun 2 2007, 02:46 PM
Post
#1
|
|
|
Super Member ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: [HOSTED] Posts: 257 Joined: 27-May 07 Member No.: 43,758 |
Ok well I have tried installing the simple user system. Now when I try to register I get the following errror
Unknown column 'id' in 'field list' How can I fix this? I really must know! |
|
|
|
Jun 2 2007, 02:57 PM
Post
#2
|
|
|
A computer once beat me at chess, but it was no match for me at kick boxing. ![]() Group: [MODERATOR] Posts: 3,993 Joined: 24-July 05 From: In Trouble Again... still? Member No.: 9,787 ![]() |
Have you created the d/b yet? Which log-in system were you trying to use? Link to the Tutorial, please.
Go to your cpanel > mysql > phpadmin (near the bottom of the page) > select the d/b from the left menu, view the structure of the database to make sure the table exists. And can you paste the actual error here for us to see, please? |
|
|
|
Jun 2 2007, 03:00 PM
Post
#3
|
|
|
Super Member ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: [HOSTED] Posts: 257 Joined: 27-May 07 Member No.: 43,758 |
|
|
|
|
Jun 2 2007, 03:03 PM
Post
#4
|
|
|
A computer once beat me at chess, but it was no match for me at kick boxing. ![]() Group: [MODERATOR] Posts: 3,993 Joined: 24-July 05 From: In Trouble Again... still? Member No.: 9,787 ![]() |
Okay, and which Tutorial were you following?
I don't see any "id" in the database, so post the link to the tutorial, please. |
|
|
|
Jun 2 2007, 03:06 PM
Post
#5
|
|
|
Super Member ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: [HOSTED] Posts: 257 Joined: 27-May 07 Member No.: 43,758 |
http://www.trap17.com/forums/simple-user-system-t46278.html
and http://www.enrit.trap17.com/projectblack/register.php if u wanna see the error yourself |
|
|
|
Jun 2 2007, 03:16 PM
Post
#6
|
|
|
A computer once beat me at chess, but it was no match for me at kick boxing. ![]() Group: [MODERATOR] Posts: 3,993 Joined: 24-July 05 From: In Trouble Again... still? Member No.: 9,787 ![]() |
I think you might need to add the 'id' field.
/the Tutorial has the SQL info you need. CODE CREATE TABLE `users` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , <<<<+++ check this line `username` VARCHAR( 255 ) NOT NULL , `password` VARCHAR( 255 ) NOT NULL , PRIMARY KEY ( `id` ) ) TYPE = MYISAM; phpadmin can be used to add the field. |
|
|
|
Jun 2 2007, 03:30 PM
Post
#7
|
|
|
Super Member ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: [HOSTED] Posts: 257 Joined: 27-May 07 Member No.: 43,758 |
Alright well now, when i try logging in it says "You couldn't be logged in!" even though I KNOW that the password is right and everything...and i already registered..
|
|
|
|
![]() ![]() |
Similar Topics
|
Lo-Fi Version | Time is now: 6th September 2008 - 02:31 AM |