Indie-Resource.com

Posted: **Fri Jun 19, 2015 5:00 pm**

this is my install.sql

drop table if exists timers;
create table timers(
id integer(100) unsigned not null primary key auto_increment,
name varchar(100) null,
PutTime varchar(100) null,
InTime varchar(100)  null,
NotInTime varchar(100) null,
ReleaseTime varchar(100) null,
ReduceTime varchar(100) null,)
ENGINE InnoDB, CHARACTER SET utf8, COLLATE utf8_bin;

then i got this error when installing it:

Code: Select all

Error whilst executing:
create table timers( id integer(100) unsigned not null primary key auto_increment, name varchar(100) null, PutTime varchar(100) null, InTime varchar(100) null, NotInTime varchar(100) null, ReleaseTime varchar(100) null, ReduceTime varchar(100) null,) ENGINE InnoDB, CHARACTER SET utf8, COLLATE utf8_bin

i don't get it.

Posted: **Fri Jun 19, 2015 5:24 pm**

not too sure but please for the love of God do not leave those at 100!

Posted: **Fri Jun 19, 2015 7:34 pm**

Try to run the SQL directly and see how it goes.

Posted: **Fri Jun 19, 2015 8:19 pm**

Hahahaha! Ok I won't put 100. LOL!

And yes I did tried it directly. It's kinda weird.

Posted: **Sat Jun 20, 2015 2:35 am**

At a quick glance you have a comma where it shouldn't be on you or reduceTime column after the "null"

Posted: **Sat Jun 20, 2015 6:55 am**

Thanks Kyle! it works now.

Indie-Resource.com

why is my Install.sql code is not working?

why is my Install.sql code is not working?

Re: why is my Install.sql code is not working?

Re: why is my Install.sql code is not working?

Re: why is my Install.sql code is not working?

Re: why is my Install.sql code is not working?

Re: why is my Install.sql code is not working?