Comus Thumbs Install Help - GoFuckYourself.com

OzMan84 · 06-15-2004, 02:58 AM

i install it, make the db etc put that shit in and then i get this error:

[:::]
GD version 2.x found-OK[Has GIF Support]
ERROR: [ CREATE TABLE tblSponsors ( id int(10) unsigned NOT NULL auto_increment, name varchar(150) NOT NULL default '', url varchar(150) NOT NULL default '', identifier varchar(150) NOT NULL default '', sponsorcode varchar(15) NOT NULL default '', yourcode varchar(150) NOT NULL default '', status varchar(15) NOT NULL default '', sponsor varchar(150) NOT NULL default '', description varchar(250) NOT NULL default '', keywords text NOT NULL default '', totalstatics varchar(10) NOT NULL default '0', autorefreshlink tinyint(1) NOT NULL default '0', movies tinyint(1) NOT NULL default '0', dailyupdatedgals tinyint(1) NOT NULL default '0', dailyupdatedpics tinyint(1) NOT NULL default '0', freehostedsites tinyint(1) NOT NULL default '0', processor varchar(100) NOT NULL default '', partnertype varchar(100) NOT NULL default 'Partnership', payout varchar(150) NOT NULL default 'recurring', payfrequency varchar(50) NOT NULL default '14 days', paymentby varchar(100) NOT NULL default 'check', hash varchar(40) NOT NULL default '', cmd varchar(5) NOT NULL default '', active tinyint(1) NOT NULL default '0', tblSponsors originalcode varchar(150) NOT NULL default '' UNIQUE KEY id (id) ) TYPE=INNODB ]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 'originalcode varchar(150) NOT NULL default ''

wtf did i do wrong?

OzMan84 · 06-15-2004, 03:35 AM

Jer · 06-15-2004, 03:39 AM

Did you put the sql server, user and pass before this error happened? On my first comus installation I don't know what I did but I didn't see any screen asking for the sql info.

OzMan84 · 06-15-2004, 03:47 AM

yeh mate, i had the db all done then i got the error

margarita · 06-15-2004, 03:51 AM

I don't use comus script, but when I see the error message, I'd say maybe you have older mysql version than required.

OzMan84 · 06-15-2004, 04:38 AM

Quote:

Originally posted by margarita
I don't use comus script, but when I see the error message, I'd say maybe you have older mysql version than required.

no that isnt the prob

Jer · 06-15-2004, 04:38 AM

You could try posting on their board

OzMan84 · 06-15-2004, 05:06 AM

Quote:

Originally posted by Jer
You could try posting on their board

been there, some1 beat me to it, and no1 has replied to him

Juicy D. Links · 06-15-2004, 09:18 AM

hit me up in 30 min ill look into it for you

OzMan84 · 06-16-2004, 01:17 AM

Quote:

Originally posted by juicylinks
hit me up in 30 min ill look into it for you

your not online dude

06-15-2004, 02:58 AM	#1
OzMan84 Confirmed User Join Date: Nov 2003 Location: Australia Posts: 4,740	Comus Thumbs Install Help i install it, make the db etc put that shit in and then i get this error: [:::] GD version 2.x found-OK[Has GIF Support] ERROR: [ CREATE TABLE tblSponsors ( id int(10) unsigned NOT NULL auto_increment, name varchar(150) NOT NULL default '', url varchar(150) NOT NULL default '', identifier varchar(150) NOT NULL default '', sponsorcode varchar(15) NOT NULL default '', yourcode varchar(150) NOT NULL default '', status varchar(15) NOT NULL default '', sponsor varchar(150) NOT NULL default '', description varchar(250) NOT NULL default '', keywords text NOT NULL default '', totalstatics varchar(10) NOT NULL default '0', autorefreshlink tinyint(1) NOT NULL default '0', movies tinyint(1) NOT NULL default '0', dailyupdatedgals tinyint(1) NOT NULL default '0', dailyupdatedpics tinyint(1) NOT NULL default '0', freehostedsites tinyint(1) NOT NULL default '0', processor varchar(100) NOT NULL default '', partnertype varchar(100) NOT NULL default 'Partnership', payout varchar(150) NOT NULL default 'recurring', payfrequency varchar(50) NOT NULL default '14 days', paymentby varchar(100) NOT NULL default 'check', hash varchar(40) NOT NULL default '', cmd varchar(5) NOT NULL default '', active tinyint(1) NOT NULL default '0', tblSponsors originalcode varchar(150) NOT NULL default '' UNIQUE KEY id (id) ) TYPE=INNODB ]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 'originalcode varchar(150) NOT NULL default '' wtf did i do wrong? __________________ XferClick - 300,000 UV daily and growing quickly. Majority US, EU, CA and AU traffic. Contact me for more information ICQ: 304568058

06-15-2004, 03:35 AM	#2
OzMan84 Confirmed User Join Date: Nov 2003 Location: Australia Posts: 4,740	bump __________________ XferClick - 300,000 UV daily and growing quickly. Majority US, EU, CA and AU traffic. Contact me for more information ICQ: 304568058

06-15-2004, 03:47 AM	#4
OzMan84 Confirmed User Join Date: Nov 2003 Location: Australia Posts: 4,740	yeh mate, i had the db all done then i got the error __________________ XferClick - 300,000 UV daily and growing quickly. Majority US, EU, CA and AU traffic. Contact me for more information ICQ: 304568058

06-15-2004, 03:51 AM	#5
margarita Confirmed User Join Date: Jun 2003 Posts: 917	I don't use comus script, but when I see the error message, I'd say maybe you have older mysql version than required. __________________ Check out my favourite kinky sponsor and must-have tool Nifty Stats

06-15-2004, 03:39 AM	#3
Jer God is Brazilian Join Date: Feb 2001 Location: Brazil Posts: 10,601	Did you put the sql server, user and pass before this error happened? On my first comus installation I don't know what I did but I didn't see any screen asking for the sql info.

06-15-2004, 04:38 AM	#7
Jer God is Brazilian Join Date: Feb 2001 Location: Brazil Posts: 10,601	You could try posting on their board

06-15-2004, 09:18 AM	#9
Juicy D. Links So Fucking Banned Industry Role: Join Date: Apr 2001 Location: N.Y. -Long Island -- Posts: 122,992	hit me up in 30 min ill look into it for you