[resolved] database help needed asap!!!

tez30 · 11-14-2007, 06:59 PM

i'm catch hell with this tables(my first time working with them)
when i test my registration for my site i get's this error

Error in checking :Table 'playstat_ps2t.users' doesn't exist

so i opened cpanel and opened phpmyadmin to create my tables then i got this error

Error
SQL query:

CREATE TABLE `members` (

`username` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AUTO_INCREMENT ,
`password` VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`first_name` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`last_name` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`address` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`city` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`state` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`interested_game` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`email_address` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`phone_number` INT( 11 ) NOT NULL ,
`age` INT( 2 ) NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT = 'registration for ps2-tournament'

MySQL said:

#1063 - Incorrect column specifier for column 'username'

can anybody please help me out?
thanks in advance.

baxter · 11-14-2007, 07:14 PM

you have username field set to text and you can't auto increment a text field. I believe thats what the error is telling you.

xrvel · 11-14-2007, 11:05 PM

Table 'playstat_ps2t.users' doesn't exist

Have you created a table which is named users , in database playstat_ps2t ?

tez30 · 11-15-2007, 06:56 AM

know i'm getting this error:

Error in registering user : .You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sab2829@yahoo.com','334-749-3616',0,'%2007-%11-%15 %09-%45-%02','s.c.a#',0,'28ae' at line 1

Peter · 11-15-2007, 08:03 AM

can you show us the full SQL you are trying to execute.

tez30 · 11-15-2007, 08:23 AM

this is the sql i'm triing to execute:

Field Type - Collation ---- Attributes ---- Null --- Default --- Extra Action
username - text ---- utf8_unicode_ci -- No
password - varchar(16) - utf8_unicode_ci -- No
first_name - text -------- utf8_unicode_ci -- No
last_name - text -------- utf8_unicode_ci -- No
address --- text -------- utf8_unicode_ci -- No
city ------- text -------- utf8_unicode_ci -- No
state ----- text --------- utf8_unicode_ci -- No
interested_game - text -- utf8_unicode_ci -- No
email_address - text ---- utf8_unicode_ci -- No
phone_number - int(11) -- -- No
age ------ int(2) -------- -- No

can anybody tell me what i'm doing wrong?

Peter · 11-15-2007, 09:39 AM

that isnt the sql you are trying to execute that looks more like a copy of the table structure.

Peter · 11-15-2007, 10:33 AM

okay had a quick look and it looks to me like you are trying to enclose $game in single quotes for the SQL but you did not close them

Change

PHP Code:

  $qry = mysql_query("insert into users(affid,username,password,fname,lname,address, city,state,game,paypalemailaddress,phone,credits,d ateapplied,notify,active,confirmcode) ".

" values(".$affid.",'".$uname."','".$pwd."','".$fname."','".$lname."','".$address."','".$city."','".$state."','".$game.

",'".$email."','".$ph."',".$credits.",'".date('%Y-%m-%d %H-%i-%s')."','".$game."#',0,'".$code."')") or die("Error in registering user : $username .".mysql_error());

Too

PHP Code:

  $qry = mysql_query("insert into users(affid,username,password,fname,lname,address, city,state,game,paypalemailaddress,phone,credits,d ateapplied,notify,active,confirmcode) ".

" values(".$affid.",'".$uname."','".$pwd."','".$fname."','".$lname."','".$address."','".$city."','".$state."','".$game.

"','".$email."','".$ph."',".$credits.",'".date('%Y-%m-%d %H-%i-%s')."','".$game."#',0,'".$code."')") or die("Error in registering user : $username .".mysql_error());

tez30 · 11-15-2007, 11:21 AM

now i'm gettin this error:

Error in registering user : .You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ateapplied,notify,active,confirmcode) values(0,'test','12345','joe','horn'' at line 1

do i have to have a field for all of these?

Peter · 11-15-2007, 11:54 AM

Yes there has to be a filed which correspond to each of those within the users table

tez30 · 11-16-2007, 03:50 AM

thanks alot peter@flexiwebhost, i fixed it

11-14-2007, 06:59 PM	#1 (permalink)
tez30 NamePros Member Join Date: Dec 2005 Posts: 78 10.00 NP$ (Donate)	database help needed asap!!! i'm catch hell with this tables(my first time working with them) when i test my registration for my site i get's this error Error in checking :Table 'playstat_ps2t.users' doesn't exist so i opened cpanel and opened phpmyadmin to create my tables then i got this error Error SQL query: CREATE TABLE `members` ( `username` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AUTO_INCREMENT , `password` VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , `first_name` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , `last_name` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , `address` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , `city` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , `state` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , `interested_game` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , `email_address` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , `phone_number` INT( 11 ) NOT NULL , `age` INT( 2 ) NOT NULL ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT = 'registration for ps2-tournament' MySQL said: #1063 - Incorrect column specifier for column 'username' can anybody please help me out? thanks in advance. __________________ Playstation2 Tournament Xbox360 Global BattleFury

11-14-2007, 07:14 PM	#2 (permalink)
baxter NamePros Regular Join Date: Apr 2006 Posts: 289 1,990.00 NP$ (Donate)	you have username field set to text and you can't auto increment a text field. I believe thats what the error is telling you. __________________ Chimps.ca - Swans.ca - Snails.ca

11-15-2007, 06:56 AM	#4 (permalink)
tez30 NamePros Member Join Date: Dec 2005 Posts: 78 10.00 NP$ (Donate)	know i'm getting this error: Error in registering user : .You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sab2829@yahoo.com','334-749-3616',0,'%2007-%11-%15 %09-%45-%02','s.c.a#',0,'28ae' at line 1 __________________ Playstation2 Tournament Xbox360 Global BattleFury

11-15-2007, 08:03 AM	#5 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	can you show us the full SQL you are trying to execute. __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

11-15-2007, 08:23 AM	#6 (permalink)
tez30 NamePros Member Join Date: Dec 2005 Posts: 78 10.00 NP$ (Donate)	this is the sql i'm triing to execute: Field Type - Collation ---- Attributes ---- Null --- Default --- Extra Action username - text ---- utf8_unicode_ci -- No password - varchar(16) - utf8_unicode_ci -- No first_name - text -------- utf8_unicode_ci -- No last_name - text -------- utf8_unicode_ci -- No address --- text -------- utf8_unicode_ci -- No city ------- text -------- utf8_unicode_ci -- No state ----- text --------- utf8_unicode_ci -- No interested_game - text -- utf8_unicode_ci -- No email_address - text ---- utf8_unicode_ci -- No phone_number - int(11) -- -- No age ------ int(2) -------- -- No can anybody tell me what i'm doing wrong? __________________ Playstation2 Tournament Xbox360 Global BattleFury

11-14-2007, 11:05 PM	#3 (permalink)
xrvel i love automation Join Date: Nov 2007 Posts: 1,409 987.78 NP$ (Donate)	Table 'playstat_ps2t.users' doesn't exist Have you created a table which is named users , in database playstat_ps2t ?

11-15-2007, 09:39 AM	#7 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	that isnt the sql you are trying to execute that looks more like a copy of the table structure. __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

11-15-2007, 10:33 AM	#8 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	okay had a quick look and it looks to me like you are trying to enclose $game in single quotes for the SQL but you did not close them Change PHP Code: `$qry = mysql_query("insert into users(affid,username,password,fname,lname,address, city,state,game,paypalemailaddress,phone,credits,d ateapplied,notify,active,confirmcode) ". " values(".$affid.",'".$uname."','".$pwd."','".$fname."','".$lname."','".$address."','".$city."','".$state."','".$game. ",'".$email."','".$ph."',".$credits.",'".date('%Y-%m-%d %H-%i-%s')."','".$game."#',0,'".$code."')") or die("Error in registering user : $username .".mysql_error());` Too PHP Code: `$qry = mysql_query("insert into users(affid,username,password,fname,lname,address, city,state,game,paypalemailaddress,phone,credits,d ateapplied,notify,active,confirmcode) ". " values(".$affid.",'".$uname."','".$pwd."','".$fname."','".$lname."','".$address."','".$city."','".$state."','".$game. "','".$email."','".$ph."',".$credits.",'".date('%Y-%m-%d %H-%i-%s')."','".$game."#',0,'".$code."')") or die("Error in registering user : $username .".mysql_error());` __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

11-15-2007, 11:21 AM	#9 (permalink)
tez30 NamePros Member Join Date: Dec 2005 Posts: 78 10.00 NP$ (Donate)	now i'm gettin this error: Error in registering user : .You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ateapplied,notify,active,confirmcode) values(0,'test','12345','joe','horn'' at line 1 do i have to have a field for all of these? __________________ Playstation2 Tournament Xbox360 Global BattleFury Last edited by tez30; 11-19-2007 at 07:29 AM.

11-15-2007, 11:54 AM	#10 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	Yes there has to be a filed which correspond to each of those within the users table __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

11-16-2007, 03:50 AM	#11 (permalink)
tez30 NamePros Member Join Date: Dec 2005 Posts: 78 10.00 NP$ (Donate)	thanks alot peter@flexiwebhost, i fixed it __________________ Playstation2 Tournament Xbox360 Global BattleFury

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)