| | 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
Jun 2 2007, 02:57 PM
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
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
Jun 2 2007, 03:03 PM
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
Jun 2 2007, 03:16 PM
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
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
Similar Topics
Keywords : installing, simple, user, system,
- Postage Costs Problem For My Website
Ideas for postage system needed (4)
Stupid Credit System
(9) Why does this site has a stupid credit system that you only get 0.7 credit a word or is it even
less. WTF is this.....
Installing Drivers In Ubuntu(hardy Heron)
(4) I am a newbie who just installed Ubuntu Studio 8.04. I can't see network directories and
everything that is not on my machine so I just thought it was the network drivers. I tried to
install my pro 100VM drivers. I was trying to follow the Readme supplied by intel on how to install
but I got stuck where it said I have to compile the "make install" I have attached the read me so
thst you can see the instructions and give me a dummies guide to installing this thing. Tell me what
you wouldn't tell someone who is computer litterate because I think this readme assume....
Microsoft Vs. Macintosh
Which operation system is the best (16) 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....
Is The Database System Gone Again? [resolved]
Errors on PHPMyAdmin again (12) I wonder if there is a problem with the PHPMyAdmin system again? When trying to get into it, I once
again get the following: QUOTE Warning: session_write_close() : SQLite: session write query
failed: database is full in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42
Warning: session_write_close() : Failed to write session data (sqlite). Please verify that the
current setting of session.save_path is correct
(/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in
/usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42 Warning: Ca....
User Name
blimey this is the hardest work ever (0) Hi, I knew nothing about chaos until I signed up (and paid for my web space Order #2486 >
Invoice #6589) with you and I drive in London for a living ... 8 hours after sign up and still
don't know whether my User name and password work on cPanel or anywhere on this site for that
matter. I would suggest that the admin send out an introductory eMail on sign up with all our info
and put a sticky on at the start page of the forum containing standard info for all users. Like FTP
eMail and cPanel settings. The other thing that's fascinating is the 3 domains us....
Problems?!
{user: alex1985] (1) Hi, I got some problems mainly related to connection issue. Firstly, I can connect to FTP server to
upload files. Secondly, I can not access cpanel account, it does not accept my registered data, the
one which is totally right. I do not what happened because it was working fine before. ....
News System (cms)
.::DeadMan::. Paraphrased by alex1985 (4) A really nice tutorial how to create a full news system, a good guide to follow. The features are:
1. Admin Panel a) Add News /cool.gif" style="vertical-align:middle" emoid="B)" border="0"
alt="cool.gif" /> Edit News c) Delete News 2. Comments a) Add Comments /cool.gif"
style="vertical-align:middle" emoid="B)" border="0" alt="cool.gif" /> Delete Comments c) Edit
Comments 3. BBCode a) Bold Tags/Italics Tags /cool.gif" style="vertical-align:middle" emoid="B)"
border="0" alt="cool.gif" /> Underlined Tags c) Strike Through Tags d) Link Tags e) Image Tags....
A Simple Preg_replace Help Please.
(1) Hello.. Im looking for some help. I want to use preg_replace function to replace the following type
of code tags. CODE <code lang="php"></code> <code
lang="javascript"></code> <code lang="css"></code>
My question is that, in the above code tags, language (lang) is not always same, how can i use
preg_replace with the above code tags to place them with something. Any help will be very much
appreciated. thanks.....
Simple Is Beter - The Future Of Computers?
In the future, what will computers be like? (3) -Computers - The future - Who knows - I often wonder what the average home
computer will be like in ten or twenty years time; They seem to get larger, and have more functions,
be faster, and have more RAM ect. People always look for speed when buying a computer - But is this
really the way forward? If you have formatted your hard drive, then re-installed your operating
system; you will have noticed, that things run very smooth, very fast, and with few or no error
messages. But as soon as you have installed all your devices, media software, some games m....
Reverse Funnel System Making Money On Auto Pilot.
(2) Hi Guys This site provides a very best business opportunity making money from online and also
it is a home based business.You can earn money in profit-manner.It also provides Reverse funnel
system making money on auto pilot. Reverse funnel marketing,perpetual leverage payplan,global
resorts network,gold crown resorts,reverse funnel system,ultimate home business,fullyautomated,think
and grow rich,home biz,passive income,no phone calling,ultimate solution to home and so on. Cheer"s
Reverse funnel system making money on auto pilot ....
Regarding The New Rating System
(3) Alright, I love the new rating system as you can tell how much I've been using it, but there are
a few little things about it do annoy me. I've waited up until now to share it just because I
thought it was in beta or something and was going to be changed, but I think I'll post my
opinions now. First of all I'll talk about having your icon next to your name: People with
names as long as mine, it goes onto the next line, and when you mouse over, it goes back up to the
previous line. It is extremely annoying. And then when I try to click on it to se....
Simple Javascript And Password System
How to protect your pages with password (6) 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....
Blood Grouping System
Important blood grouping system of human and non-human (2) 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....
Need Help Installing Dolphin Community Script!
(5) I'm not sure if this is the right place to post this but I really need help in installing the
dolphin community script. I have absolutely no previous experience of scripts or programming. I
would really appreciate if someone could walk me through it step-by-step, or even do it for me by
logging into my cpanel. I have tried to install it my self but I'm a little confused. I'm
sure it won't take very long at all for someone who has done this before.....
I Have Install Windows 2003 Server
I want multiple user to login my server (4) 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....
Credit System V2.0 Online
Free Web Hosting Credit System v2 now online! (15) 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....
Ubuntu Linux As Free Operating System Alternative
linux operating system (46) About three years ago I decided to learn how to use Linux and after a lot of posts on a forum I
tried Ubuntu Linux as it was recommended as a good first Linux distro. Ubuntu is not the easiest
Linux distro to use but with its unmatched forum community support it is one of the easiest to learn
to use. One of the problems with learning Linux is that a lot of users have an attitude that Linux
should be a free Windows knock off which it is not. Ubuntu is build on a Linix core or kernel and is
a different Open Source and free as in to use operating system. This brings us to t....
Innovative Login System
A new way to login to a website (17) 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....
Get 30 Gb Email For Free
let us talk about , email system for huge data ! (30) Friends here we are talking about largest email, free System http://www.30gigs.com this one is
good and can handel many file at a time. plz let me know any one having this type of information
! Also for small user www.walla.com is good one....
Make 100% Free Money Online $4000+
free money making system (18) /cool.gif" style="vertical-align:middle" emoid="B)" border="0" alt="cool.gif" /> Hello I am
posting this site here as I am making money with it every month..It is a step-by-step money making
system..Best thing is it is 100% free..First I thought that it might be a scam but now as I am
making 4000$ per moth so now I have to believe it.. I will advise you that
please give it a try before making any decision..You will also make money..no experience is needed
and its free..so you have nothing to lose.. you will surely love it.. ....
What Is God?
simple question, hard to answer! (52) Yeah this is the only thing I'd like to know! Is he a big old man with a beard somewhere
above us (interstingly what is UP on one side of the earth is DOWN on the other side of it - so
where is God then if we point up there?)??? Is he inside of us? Are we all a part of god? Is God
present in everything that surrounds us? Isn't it interesting that GOD is very close to GOOD?
Maybe it is a metaphore for being and doing GOOD things?? That is something we have inside of us -
every normal human being has this feeling for what is good and bad and is tryin' to f....
Watermark Your Image With Simple Php Script
found it on the net (34) This script was found on the net http://tips-scripts.com/?tip=watermark#tip B&T's Tips &
Scripts site. Just in case the site may not show, I will include the code here: List of things
needed: 1. your image in any format 2. watermark image--in gif format with transparent background 3.
script below with name (i.e. watermark.php) CODE <?php // this script creates a watermarked
image from an image file - can be a .jpg .gif or .png file // where watermark.gif is a mostly
transparent gif image with the watermark - goes in the same directory as this script // ....
Simple C File Handling In Action
Small code snipet which covers most of basic file handling and navigat (3) 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....
New System Shuts Down After Running About 1 Minute
new ecs extreme (13) I have a new ecs extreme motherboard with an apthlon 939 3000+ processor, with 512mb ram a new power
supply and new hardrrive. I have a 128m AGP video card from a good machine. All of the itemes I am
using have either come from a running system or have been tested in a working computer. My computer
will turn on and I can get to cmos setup or to boot from cd, however, after about 1-2 minutes the
system just shuts down.....
Operating System Not Found
Error Displayed On Start Up (13) So I've been having some difficulties with my Laptop computer. Not the least significant of
them was this problem of not being able to find the O/S. What to do about it? How does the
computer not find the Operating System? I know that it is in there someplace, I had just
re-installed it, but the BIOS was not able to locate it. On the phone to the Manufacturer's
Help Centre. Explain the problem. Real nice guy. Had the answer right handy. Send me an email right
away. Good thing I had another machine available,huh? On startup, the powering on of the machine
tri....
Error Installing Windows Xp -error 7 Ntkrnlmp.exe
(10) i have tried to install windows xp on my pc and i get an error right after it ask at the bottom of
the screen to press f2 to restore an error pops up saying FILE
\$win_nt$.~bt\NTKRNLMP.EXE cannot be open error 7 setup cannot complete and has
to close i have had windows xp on the pc before so i know its compatible but i used a different
version of windows before ,this tinme im using a new one and i get this error i seem to find no
solution anywhere about how to resolve this and I was wondering if possible theres something i need
to do,I am not to sm....
Php Mod Rewrite Tutorial
Simple tutorial (3) REQUIRED: Internet server (Apache 1.3.33 recomended), php, basic skills with .htaccess Mod
rewrite is cool Apache option, it helps you to make your site URLs simple and clean... also it is
perfect for search engines... This is mod rewrite, it replaces : CODE
site.com/index.php?include=files?ID=45 with: CODE site.com/files/45 so lets get startet,
open notepad, enter this in it: CODE RewriteEngine On // - you are starting rewrite mod
:) RewriteBase / // - you set the rewrite base RewriteRule
^(.+)/([0-9]+)/?$ in....
Complete Login System
With PHP + MYSQL (56) Its an complete login sistem made and tested by me and I think itwill be very usefull for people who
are tryn to learn PHP. First, let's make register.php: CODE <?
include("conn.php"); // create a file with all the database connections
if($do_register){ // if the submit button were clicked if((!$name)
|| (!$email) || (!$age) || (!$login) ||
(!$password) || (!$password2)){ print "You can't let
any fields in blank....
What's Your Favorite Game System - Console
select one from each poll (175) 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.....
Looking for installing, simple, user, system,
|
|
Searching Video's for installing, simple, user, system,
|
advertisement
|
|
Jul 26, 2008
