Welcome Guest ( Log In | Register)



 
Reply to this topicStart new topic
> Installing The Simple User System.
nol
post 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!
Go to the top of the page
 
+Quote Post
jlhaslip
post 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 Icon

Group: [MODERATOR]
Posts: 3,993
Joined: 24-July 05
From: In Trouble Again... still?
Member No.: 9,787
Spam Patrol



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?
Go to the top of the page
 
+Quote Post
nol
post Jun 2 2007, 03:00 PM
Post #3


Super Member
*********

Group: [HOSTED]
Posts: 257
Joined: 27-May 07
Member No.: 43,758



alright well heres the actual error..I get it when trying to register, it takes off all the username and password crap (like it clears the fields) then gives me the error.




and heres the view of the database crud, i think i entered it correctly :\


Go to the top of the page
 
+Quote Post
jlhaslip
post 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 Icon

Group: [MODERATOR]
Posts: 3,993
Joined: 24-July 05
From: In Trouble Again... still?
Member No.: 9,787
Spam Patrol



Okay, and which Tutorial were you following?

I don't see any "id" in the database, so post the link to the tutorial, please.
Go to the top of the page
 
+Quote Post
nol
post 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
Go to the top of the page
 
+Quote Post
jlhaslip
post 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 Icon

Group: [MODERATOR]
Posts: 3,993
Joined: 24-July 05
From: In Trouble Again... still?
Member No.: 9,787
Spam Patrol



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.
Go to the top of the page
 
+Quote Post
nol
post 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..
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Help With Forums(9)
  2. Fantastico Is Not Installing Forums Properly(10)
  3. Installing Apache, Mysql, Phpmyadmin Locally(5)
  4. Help With Installing A Content Management System.(9)
  5. Installing Python 2.4 On Server(4)
  6. Help Installing Mods On Invision Powerboard(3)
  7. Installing Shoutbox,poll And Recent Written Topics In Phpbb(1)
  8. Problems Installing Ipb 2.1.5(2)
  9. php My Admin Rejecting Me/ SQL outtage(6)
  10. Security Check Php Register_globals(7)
  11. Parse Errors While Installing Smf Board(3)
  12. Help Installing Phpbb On My Site [resolved](6)
  13. Installing Phpbb(0)
  14. Having Trouble Installing Smf(3)
  15. Need Help Installing Smf(5)
  1. Installing Phpbb Forum On My Site?(5)
  2. Installing Easymod(3)
  3. Installing Ipb(1)
  4. Having Problems With Installing Ipb 2.3.x(2)
  5. Installing Joomla And Shell Question(0)
  6. Installing Ffmpeg(7)
  7. Installing Theme On Smf Forum(4)
  8. Using Different Font(3)
  9. Successfully Installing Joomla [resolved](2)
  10. Installing Custom Fonts...(5)
  11. Joomla 1.5.2 Broken Link?(3)
  12. Problems?!(1)
  13. Movable Type 4(0)


 



- Lo-Fi Version Time is now: 6th September 2008 - 02:31 AM