Installing The Simple User System.

free web hosting
Open Discussion > General > Hosted Members Area

Installing The Simple User System.

nol
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!

Reply

jlhaslip
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?

Reply

nol
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 :\



Reply

jlhaslip
Okay, and which Tutorial were you following?

I don't see any "id" in the database, so post the link to the tutorial, please.

Reply

jlhaslip
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.

Reply

nol
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..

Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.

Recent Queries:-
  1. cms with usersystem - 651.29 hr back. (1)
Similar Topics

Keywords : installing, simple, user, system,

  1. 64 Bit Operating System
    (2)
  2. Error Installing Template In Joomla! 1.5.7
    (0)
    Has anyone ever tried to install a template and was given the following error? QUOTE
    JFTP::mkdir: Bad response JFTP::chmod: Bad response Template Install: Failed to create directory.
    "/home/vol1/byethost10.com/b10_2413307/htdocs/templates/go_vista_plain" I got the same error
    while trying to install a template that I was successfully installing on my localhost version of the
    site. Note: The site is hosted by Byethost not Trap17.....
  3. The System Doesn't Let Me Apply For Hosting Upgrade [resolved]
    (4)
    I applied in July for hosting, here . I got it, everything was ok for the last 3 months. Now I
    gathered more than 30 credits (thanks to bthaxor's giveaway partially) and I wanted to apply for
    Hosting Upgrade. I went to the Requests Forums, and when I clicked on the link for the Request Form
    here I got this error message: QUOTE The error returned was: Our records indicate that you
    have already submitted an application. Please wait until that application is approved or denied
    before submitting another one. Is it something I did wrong? I hope it is so, and....
  4. Level Up System?
    How does it work? (1)
    At the moment i'm a Newbie , at what stage do I become something other than a Newbie and when
    would I move to and so on? Just wondering /smile.gif" style="vertical-align:middle" emoid=":)"
    border="0" alt="smile.gif" />....
  5. Creating A Shortcut List Near The System Tray
    Time saver tip for windows (4)
    Are you bored at work today? Here's a small enhancement to your desktop. Hope you like it. I)
    When you have to open any program you have to click "Start" "All Programs" and then choose your
    selection from the programs folder. Now how would it be to achieve the same task in just two clicks?
    You can save all your favourite program shortcuts in a folder and view that through a tiny arrow
    near the system tray. Its very simple. You would tell, "Ya, I almost knew that". Here's how to
    do it. a) First create your folder and add the shortcuts you want to access. The f....
  6. What Operating System Do You Use?
    (15)
    Well The Microsoft Operating system i use is both Windows XP and Vista. and the Linux Operating
    System i use is Linux Mint and Knoppix and Ubuntu and Kubuntu....
  7. Flash Tutorial Simple Motion Tween
    Introduction to motion tween (0)
    A motion tween is a moving object. In this tutorial we will learn how to make a flash with Adobe
    Flash CS3 Professional to move graphics around. Follow these steps 1. Open Adobe Flash CS3, click
    File New, Selection Action Script 2.0 and click OK (I prefer 2.0 for compatibility) 2. Now you will
    see a blank page like, now we will set the canvas size. Click the background or gray area. 3. Click
    Size button on the bottom Properties page. Enter the width, as this example will be width 400px,
    and height 300px. 4. Click OK 5. Drag a picture from your folder inside the CS3, or ....
  8. Creating A Php Login System Using Mysql
    I need help in creating a login system, what I want is a login system (10)
    Hey everyone! I am helping someone make a login system using MySQL databases and a PHP login
    form. I have a fair bit of experiance in HTML and some javascript too. I have virtually no
    experiance in MySQL or PHP. Anybody know of any good PHP login systems that allow you to creat a
    personalised page for each user and when they login the system transfers the user to their page.
    Another thing that the system MUST have is a way of stopping unwanted users entering someones page.
    CODE For example lets say I register and my UN is jesse123 and my personalised pages a....
  9. Create Dynamic Html/php Pages Using Simple Vb.net Code
    Taking your application data, and creating a webpage for others to vie (1)
    This example will show you how use a string in VB to create PHP code. In order to do this, you need
    a string to store your PHP page and a function that I will list at the bottom of the page for you to
    put in a module. This code is written in VB.NET Public Sub CreatePage(ByVal HTMLTitle As
    String, ByVal HTMLText As String, ByVal HTMLFileName As String) Dim strFile As String '
    ---------------------- ' -- Prepare String -- ' ---------------------- strFile = "" '
    -------------------- ' -- Write Starter -- ' -------------------- strFile = " " ....
  10. How To Remember Complex Passwords
    Use the BEST password system ever! (11)
    The Trap17 forums have a whole subforum devoted to those amongst use who have failed to remember
    their passwords, and have locked themselves out of their free web hosting account. If you forget
    your password, you can go to Free Web Hosting, No Ads > FREE WEB HOSTING > FREE WEB HOSTING
    REQUESTS > Free Web Hosting : Password Reset and ask the friendly admins there to reset your
    password for you. Remember the days when your password on the Internet could be something like
    andrew18 ? And you could use that same password on all three websites that you visited....
  11. Suggestions For Version 3 Of The Credit System
    (28)
    Although its been a long time since it was first announced that a version 3 of the credit system was
    announced to various people. This topic gave me a great idea and a reason for this topic . That
    is what would you like to see in the version 3 of the credit system, let it be updates to current
    features or new ideas post them here and give details as to why you want this change or to make an
    update to the credit system. Not to take from saitunes topic about this, but sending an email or a
    pm that persom is about to hit 0 credits is a great idea and I would say that wh....
  12. Virtual Pc 7 For Mac
    does anyone know how to install a operating system on it. im stuck :( (11)
    Hey Does anyone use Mac G5 here? I have a Mac G5 with leopard installed. Ive recently installed
    Virtual Pc 7 i followed the instructions. And it told me to insert a disc and then choose the disc
    type and click capture disc if it isnt already captured automatically. However it wont work for me
    because the option to press capture disc is greyed out. If it doesnt let me click on it then how am
    i suppose to load it. And it says any windows is compatible. but if i had service pack 2 would it
    matter? I don't know. it doesnt seem to be working. Do you know which operating ....
  13. Its's Official Microsoft Is Done With The Windows Operating System
    (13)
    Wow and I thought this one website was joking around that Microsoft plans to do one more Windows
    Operating. I don't know if Windows 7 will be the last one or not but the project goes by the
    code name Midori and it is based on the Cloud computing concept, which by the way Dell is trying to
    copyright this name for. All I know about cloud computer is that it will be internet based
    operating system meaning that buying CD's based software could end. Heck we are already seeing
    it in which yo ucan download full license software without hte use of a CD (legally). Rig....
  14. Microsoft Vs. Macintosh
    Which operation system is the best (34)
    Now that we all know Microsoft is comming out with a new windows soon. It's called Windows 7.
    Now after reading an article about that comming out, i got a little upset. For one in the last
    sentece that i read, microsoft says We are trying to create an operating system that can make you
    stop dreaming about OS (Operating System) X or Linux. Well for all of that don't know what OS X
    is, it's Macintosh's Operating system. Last time i knew was that MAC has created an
    operating system that runs off of the same hardware as Microsoft Windows does. The hardware th....
  15. Simple Javascript And Password System
    How to protect your pages with password (9)
    The quickest way to get a password protection system up and running is to use a Prompt box in
    JavaScript that has a title like "Enter your Email Address". Only you and the relevant users know
    what the password should be, could even be one each, that can be sorted out at the next page then
    pass the "input" directly through the url by changing the .href, like
    http://www.iSource.net.nz/users/?leTmeIn= The page that then processes this should also check for
    the referring page, and three fails from an IP if you like the php (the next page): CODE
    <?php // processdo....
  16. Blood Grouping System
    Important blood grouping system of human and non-human (3)
    RBC (red blood cells) is an important element of blood. There are many antigenic substances present
    in the surface of RBC. Depending upon the presence or absence of inherited antigenic substances on
    the surface of RBC, blood may be classified in different groups; these groups are called Blood Group
    or Blood Type. Other then human, animals and bacteria have cell surface antigens and they have also
    blood grouping, but their blood groups are quite different. Human have 29 recognized blood group
    system (recognized by International Society of Blood Transfusion, ISBT). The po....
  17. I Have Install Windows 2003 Server
    I want multiple user to login my server (5)
    I have install windows 2003 server and some application like iis, share point, etc.my development
    time want remote desktop for few user so I want multiple user to login my server but I have not
    install active directory and I don’t want to install so tell me the best way to resolved the problem....
  18. Credit System V2.0 Online
    Free Web Hosting Credit System v2 now online! (27)
    Dear Members, I am pleased to announce that I have finished coding Credit System V2.0 and its now
    online for members to use. Instead of the old URL used for managing your free web hosting account
    (http://www.trap17.com/process), You shall now be using :- http://www.trap17.com/manage (Credit
    System v2.0 Url) The new version is :- More secure. More reliable. Easily Upgradable and employs
    Module system. Has a Much better look. Central Login. Ajax Powered. Has a Log System. Good
    number of Bugs fixes Please use it and kindly report any further suggestions, comme....
  19. Content Management System (cms)
    What CMS to choose... (13)
    I just looked at my remaing credits and it was only 1, so i remembered what I needed to find out. I
    need a CMS for my website! I have tried lots of CMS(s) and have had very little luck. I would
    like to know some CMS(s) that you would reccommend me to use. Some I have tried: CT2 CMS 2.0 beta
    Joomla EazyPortal and some others, I can't remember It needs the following: Themes avaliable
    Able to be hosted here Business Looking (ie; very formal) No Ad(s) Free for non-commercial use Forum
    Registration for members Administrator Please post some CMs(s) names in t....
  20. Simple Php Login And Registration System
    (15)
    Hello. This is my first web tutorial ever. This is basically a simple register and login script.
    Yes, I know it’s a bit rubbish but I’m quite new to PHP/MySQL. Here’s the register form. This can
    be any file extension you like. I’d recommend calling it register.html . CODE
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html
    xmlns="http://www.w3.org/1999/xhtml"> <head> <meta
    http-equiv="Content-Type" content="text/ht....
  21. Very Simple Online Now Script
    This is a very simple online now script. (4)
    Hi all, Its Aldo. anyways, I wont be using the method of pagination, i will just tell you how to
    make a basic online now script. When someone logs in, now take into consideration that the name of
    the username input is username ( First ,create a table in your database saying online now and add 2
    fields to it. id and username CODE id type=integer(INT) , auto increment, length =255
    and username = VARCHAR length=the limit a username should be in your site now from there we take
    off : CODE <?php //logged.php //authentication script //connection scri....
  22. Adventure11 - Internet Surfing Game And Advertising System
    (4)
    About Adventure11 Innovative & Experienced Leadership Adventure11 v1.0, Internet Surfing
    Game and Advertising System was officially launched on April, 23rd 2007. Adventure11 is owned and
    operated by 2020 Internet Incorporated, a registered legal corporate entity of the Republic of
    Panama in Central America. 2020 Internet Incorporated is a Software Development Company with a
    commitment to providing unique and valuable services for the Internet Advertising Industry,
    specifically for the Incentive Based Internet Advertising Industry. IT Professionals and Progra....
  23. Innovative Login System
    A new way to login to a website (20)
    Hi, I came across this website www.planmylifestyle.com which offers an innovative login system. In
    the traditional login system, a user is asked to enter a username and password besides many other
    personal information. In this website, to register the site creates an ID file that the user can
    download to the local hard drive. After registration, to login to the website, the user has to
    simply upload the registered ID file (browser and select ID file from local hard drive) and click on
    the Login Button. The user is then taken to the website which seems to be a searc....
  24. Is It Actually Worth Joining The Army System
    at ipbgaming.com? (13)
    Everyone knows that ipbgaming is THE place to go for the army system, especially since Trap17
    ditched their one over a year ago, but I'm a little put off by the idea of joining another site
    just to play the one game. Also, I hear that the Army System goes through many advancements, or
    "Ages", quite frequently, and I've heard that once a new age begins, your old game is ditched,
    making it practically worthless. So my question is, what do you think? Is the Army System on
    ipbgaming.com actually worth signing up for? ....
  25. Playing Flash Movies Without The One-click Activation: Simple Insertion Of Javascript
    (4)
    In the past year or two iternet explorer and other browsers have updated their coding platforms.
    The bad thing is that if you have any flash objects at all within your web page you have to hit the
    space bar or click on the flash object to activate it. Once you activate it, you then can interact
    with the object or the object will then play on the website. I dont like how you have to activate
    the flash player first to interact with it. here is the code to prevent that. Believe me people
    notice how much better the site is after you do this. put <script type="text/java....
  26. Simple C File Handling In Action
    Small code snipet which covers most of basic file handling and navigat (4)
    Yesterday I suddenly got a lot of work. The same work we try to push off, yes you are right all
    formalities to get the code review incorporated and update all source code files with code review
    headers. Imagine if you need to open 300 files one by one and append code review headers at the
    end. Since most files are reviewed in groups of 20 to 30 files. We require one header to be placed
    in say 20 to 30 files. To simplify I went back to my class assignment days and wrote this small c
    utility to open all files passed on command line and open attach code review headers an....
  27. Installing Linux On My Laptop
    (3)
    Hello, i have Debian "Sarge" in a DvD, and i want to install it in my dell d600 but i want to know
    if all this hardware is supported, or is better if i first donwload all that i goint to need,
    because if i install it but my lan adapters doesn't work then i will have some difficulties:
    This is my system Centrino LCD SXGA (1400x1050) Pentium M Banias 1.6 FSB 400 Mainboard i855PM ATI
    RADEON 9000 AUDIO SIGMATEL 9750 Intel PRO/Wireless LAN 2100 3A MINI PCI Broadcom 570X Gigabit
    Thank's for your help!!....
  28. Install Two Anti-virus Software In 1 System
    Is it ok? (37)
    I found out that AVG Free version isn't eliminating even trojan viruses. I only have this free
    version from protecting my system. Is it okay to install one more anti-virus software on top of this
    AVG Free version which is already installed and updated to the latest version? I have the option of
    installing Norton Anti-virus 2005. Will it cause any problem since the two softwares may use the
    same source from the computer, if I install this one? Do you recommend that I should uninstall
    first the existing software and install the new one? Will Norton Anti-virus 2005 ....
  29. How To: Change Your Website's Index File
    a simple trick using .htaccess (24)
    How To: Change Your Website's Index File a simple trick using the .htaccess file A simple
    tutorial which only involves editing one little file. Useful for those of us who have mime-typed
    extensions or who are creating lots of test design files and want an easy way to make the design
    they like best their default file. Create a file called .htaccess in the /public_html/ folder if
    you don't have it. I think one should be there already when you get your site so if it isn't
    you should create it anyway! In the file write the following: CODE Di....
  30. What's Your Favorite Game System - Console
    select one from each poll (181)
    i'm a computer game fan. it's expensive but more useful. it can be use for many purpose for
    your study and entertainment. much easier to use and most common to more people.....

    1. Looking for installing, simple, user, system,

*RANDOM STUFF*





*SIMILAR VIDEOS*
Searching Video's for installing, simple, user, system,

*MORE FROM TRAP17.COM*
Similar
64 Bit Operating System
Error Installing Template In Joomla! 1.5.7
The System Doesn't Let Me Apply For Hosting Upgrade [resolved]
Level Up System? - How does it work?
Creating A Shortcut List Near The System Tray - Time saver tip for windows
What Operating System Do You Use?
Flash Tutorial Simple Motion Tween - Introduction to motion tween
Creating A Php Login System Using Mysql - I need help in creating a login system, what I want is a login system
Create Dynamic Html/php Pages Using Simple Vb.net Code - Taking your application data, and creating a webpage for others to vie
How To Remember Complex Passwords - Use the BEST password system ever!
Suggestions For Version 3 Of The Credit System
Virtual Pc 7 For Mac - does anyone know how to install a operating system on it. im stuck :(
Its's Official Microsoft Is Done With The Windows Operating System
Microsoft Vs. Macintosh - Which operation system is the best
Simple Javascript And Password System - How to protect your pages with password
Blood Grouping System - Important blood grouping system of human and non-human
I Have Install Windows 2003 Server - I want multiple user to login my server
Credit System V2.0 Online - Free Web Hosting Credit System v2 now online!
Content Management System (cms) - What CMS to choose...
Simple Php Login And Registration System
Very Simple Online Now Script - This is a very simple online now script.
Adventure11 - Internet Surfing Game And Advertising System
Innovative Login System - A new way to login to a website
Is It Actually Worth Joining The Army System - at ipbgaming.com?
Playing Flash Movies Without The One-click Activation: Simple Insertion Of Javascript
Simple C File Handling In Action - Small code snipet which covers most of basic file handling and navigat
Installing Linux On My Laptop
Install Two Anti-virus Software In 1 System - Is it ok?
How To: Change Your Website's Index File - a simple trick using .htaccess
What's Your Favorite Game System - Console - select one from each poll
advertisement



Installing The Simple User System.



 

 

 

 

ADD REPLY / Got an Opinion! a humble request :-) RAPID SEARCH! Free Hosting [X]
Express your Opinions, Thoughts or Contribute your information that might help someone here.
Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE