Mysql can't figure it out :(( - GoFuckYourself.com

Danmixz · 03-16-2011, 11:20 PM

I made some modification to a tube script to add a Pornstar section, now i want to modified it to add more info... But seem i'm always getting some syntax error

Working Table:

PHP Code:


			
CREATE TABLE IF NOT EXISTS `pornstar` (  `PSID` bigint(20) NOT NULL auto_increment,  `name` varchar(120) NOT NULL default '',  `website` text NOT NULL,  `views` int(11) NOT NULL,  `height` text NOT NULL,  `hair` text NOT NULL,  `born` text NOT NULL,  `measurements` text NOT NULL,  `related` text NOT NULL,  `total_videos` bigint(20) NOT NULL default '0',  `about` text NOT NULL,  `images` text NOT NULL,  PRIMARY KEY  (`PSID`),  UNIQUE KEY `name` (`name`)) ENGINE=INNODB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;

What i'm trying to add:

PHP Code:


			
`performer` text NOT NULL, `astrology` text NOT NULL, `birthplace` text NOT NULL, `years` text NOT NULL, `weight` text NOT NULL, `ethnic` text NOT NULL,`measurements` text NOT NULL,

Any tips on this, seem i can't figure it out

Thanks!!!

k0nr4d · 03-16-2011, 11:26 PM

No syntax error that I see...

k0nr4d · 03-16-2011, 11:27 PM

oh wait, you have measurements twice.

CREATE TABLE IF NOT EXISTS `pornstar` (
`PSID` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 120 ) NOT NULL default '',
`website` text NOT NULL ,
`views` int( 11 ) NOT NULL ,
`height` text NOT NULL ,
`hair` text NOT NULL ,
`born` text NOT NULL ,
`measurements` text NOT NULL ,
`performer` text NOT NULL ,
`astrology` text NOT NULL ,
`birthplace` text NOT NULL ,
`years` text NOT NULL ,
`weight` text NOT NULL ,
`ethnic` text NOT NULL ,
`related` text NOT NULL ,
`total_videos` bigint( 20 ) NOT NULL default '0',
`about` text NOT NULL ,
`images` text NOT NULL ,
PRIMARY KEY ( `PSID` ) ,
UNIQUE KEY `name` ( `name` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8

Danmixz · 03-16-2011, 11:30 PM

Quote:

Originally Posted by k0nr4d

No syntax error that I see...

Finally got it, but seem now i'm getting a 500 error when i try to visit the page

(

Crap think i'll do something else for now

Danmixz · 03-16-2011, 11:38 PM

Quote:

Originally Posted by k0nr4d

oh wait, you have measurements twice.

CREATE TABLE IF NOT EXISTS `pornstar` (
`PSID` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 120 ) NOT NULL default '',
`website` text NOT NULL ,
`views` int( 11 ) NOT NULL ,
`height` text NOT NULL ,
`hair` text NOT NULL ,
`born` text NOT NULL ,
`measurements` text NOT NULL ,
`performer` text NOT NULL ,
`astrology` text NOT NULL ,
`birthplace` text NOT NULL ,
`years` text NOT NULL ,
`weight` text NOT NULL ,
`ethnic` text NOT NULL ,
`related` text NOT NULL ,
`total_videos` bigint( 20 ) NOT NULL default '0',
`about` text NOT NULL ,
`images` text NOT NULL ,
PRIMARY KEY ( `PSID` ) ,
UNIQUE KEY `name` ( `name` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8

Thanks a bunch, everything work now

Damn dindt see measurements was there twice

Thanks!!!

03-16-2011, 11:20 PM	#1
Danmixz Confirmed User Industry Role: Join Date: Sep 2010 Posts: 649	Mysql can't figure it out :(( I made some modification to a tube script to add a Pornstar section, now i want to modified it to add more info... But seem i'm always getting some syntax error Working Table: PHP Code: CREATE TABLE IF NOT EXISTS `pornstar` ( `PSID` bigint(20) NOT NULL auto_increment, `name` varchar(120) NOT NULL default '', `website` text NOT NULL, `views` int(11) NOT NULL, `height` text NOT NULL, `hair` text NOT NULL, `born` text NOT NULL, `measurements` text NOT NULL, `related` text NOT NULL, `total_videos` bigint(20) NOT NULL default '0', `about` text NOT NULL, `images` text NOT NULL, PRIMARY KEY (`PSID`), UNIQUE KEY `name` (`name`)) ENGINE=INNODB DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ; What i'm trying to add: PHP Code: `performer` text NOT NULL, `astrology` text NOT NULL, `birthplace` text NOT NULL, `years` text NOT NULL, `weight` text NOT NULL, `ethnic` text NOT NULL,`measurements` text NOT NULL, Any tips on this, seem i can't figure it out Thanks!!! __________________ FFMPEG Hosting with AptHost

03-16-2011, 11:26 PM	#2
k0nr4d Confirmed User Industry Role: Join Date: Aug 2006 Location: Poland Posts: 9,228	No syntax error that I see... __________________ Mechanical Bunny Media Mechbunny Tube Script \| Mechbunny Webcam Aggregator Script \| Custom Web Development

03-16-2011, 11:27 PM	#3
k0nr4d Confirmed User Industry Role: Join Date: Aug 2006 Location: Poland Posts: 9,228	oh wait, you have measurements twice. CREATE TABLE IF NOT EXISTS `pornstar` ( `PSID` bigint( 20 ) NOT NULL AUTO_INCREMENT , `name` varchar( 120 ) NOT NULL default '', `website` text NOT NULL , `views` int( 11 ) NOT NULL , `height` text NOT NULL , `hair` text NOT NULL , `born` text NOT NULL , `measurements` text NOT NULL , `performer` text NOT NULL , `astrology` text NOT NULL , `birthplace` text NOT NULL , `years` text NOT NULL , `weight` text NOT NULL , `ethnic` text NOT NULL , `related` text NOT NULL , `total_videos` bigint( 20 ) NOT NULL default '0', `about` text NOT NULL , `images` text NOT NULL , PRIMARY KEY ( `PSID` ) , UNIQUE KEY `name` ( `name` ) ) ENGINE = MYISAM DEFAULT CHARSET = utf8 __________________ Mechanical Bunny Media Mechbunny Tube Script \| Mechbunny Webcam Aggregator Script \| Custom Web Development