GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   Mysql can't figure it out :(( (https://gfy.com/showthread.php?t=1014547)

Danmixz 03-16-2011 11:20 PM

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` (  `PSIDbigint(20NOT NULL auto_increment,  `namevarchar(120NOT NULL default '',  `websitetext NOT NULL,  `viewsint(11NOT NULL,  `heighttext NOT NULL,  `hairtext NOT NULL,  `borntext NOT NULL,  `measurementstext NOT NULL,  `relatedtext NOT NULL,  `total_videosbigint(20NOT NULL default '0',  `abouttext NOT NULL,  `imagestext 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:

`performertext NOT NULL, `astrologytext NOT NULL, `birthplacetext NOT NULL, `yearstext NOT NULL, `weighttext NOT NULL, `ethnictext NOT NULL,`measurementstext 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 (Post 17985195)
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 :disgust

Danmixz 03-16-2011 11:38 PM

Quote:

Originally Posted by k0nr4d (Post 17985198)
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 :winkwink:

Damn dindt see measurements was there twice :thumbsup

Thanks!!!


All times are GMT -7. The time now is 11:51 AM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123