Strange error after step 1 - Joomla! Forum - community, help and support

hello,

after hours of trying figure out doing wrong, finnaly got past step 1 when verified info, went step 2 following error in place should enter name of joomla site....

sql=blob/text column \'text\' can\'t have default value sql=# table structure table `jos_poll_data`\n\ncreate table `jos_poll_data` (\n  `id` int(11) not null auto_increment,\n  `pollid` int(4) not null default \'0\',\n  `text` text not null default \'\',\n  `hits` int(11) not null default \'0\',\n  primary key  (`id`),\n  key `pollid` (`pollid`,`text`(1))\n) type=myisam:
- - - - - - - - - -
# table structure table `#__poll_data`

create table `#__poll_data` (
  `id` int(11) not null auto_increment,
  `pollid` int(4) not null default '0',
  `text` text not null default '',
  `hits` int(11) not null default '0',
  primary key  (`id`),
  key `pollid` (`pollid`,`text`(1))
) type=myisam
= = = = = = = = = =

sql=table \'joomladb.jos_poll_data\' doesn\'t exist sql=# dumping data table `jos_poll_data`\n\ninsert `jos_poll_data` values (1, 14, \'absolutely simple\', 1):
- - - - - - - - - -
# dumping data table `#__poll_data`

insert `#__poll_data` values (1, 14, 'absolutely simple', 1)
= = = = = = = = = =

sql=table \'joomladb.jos_poll_data\' doesn\'t exist sql=insert `jos_poll_data` values (2, 14, \'reasonably easy\', 0):
- - - - - - - - - -
insert `#__poll_data` values (2, 14, 'reasonably easy', 0)
= = = = = = = = = =

sql=table \'joomladb.jos_poll_data\' doesn\'t exist sql=insert `jos_poll_data` values (3, 14, \'not straight-forward worked out\', 0):
- - - - - - - - - -
insert `#__poll_data` values (3, 14, 'not straight-forward worked out', 0)
= = = = = = = = = =

sql=table \'joomladb.jos_poll_data\' doesn\'t exist sql=insert `jos_poll_data` values (4, 14, \'i had install server stuff\', 0):
- - - - - - - - - -
insert `#__poll_data` values (4, 14, 'i had install server stuff', 0)
= = = = = = = = = =

sql=table \'joomladb.jos_poll_data\' doesn\'t exist sql=insert `jos_poll_data` values (5, 14, \'i had no idea , got friend it\', 0):
- - - - - - - - - -
insert `#__poll_data` values (5, 14, 'i had no idea , got friend it', 0)
= = = = = = = = = =

sql=table \'joomladb.jos_poll_data\' doesn\'t exist sql=insert `jos_poll_data` values (6, 14, \'my dog ran away readme ...\', 0):
- - - - - - - - - -
insert `#__poll_data` values (6, 14, 'my dog ran away readme ...', 0)
= = = = = = = = = =

sql=table \'joomladb.jos_poll_data\' doesn\'t exist sql=insert `jos_poll_data` values (7, 14, \'\', 0):
- - - - - - - - - -
insert `#__poll_data` values (7, 14, '', 0)
= = = = = = = = = =

sql=table \'joomladb.jos_poll_data\' doesn\'t exist sql=insert `jos_poll_data` values (8, 14, \'\', 0):
- - - - - - - - - -
insert `#__poll_data` values (8, 14, '', 0)
= = = = = = = = = =

sql=table \'joomladb.jos_poll_data\' doesn\'t exist sql=insert `jos_poll_data` values (9, 14, \'\', 0):
- - - - - - - - - -
insert `#__poll_data` values (9, 14, '', 0)
= = = = = = = = = =

sql=table \'joomladb.jos_poll_data\' doesn\'t exist sql=insert `jos_poll_data` values (10, 14, \'\', 0):
- - - - - - - - - -
insert `#__poll_data` values (10, 14, '', 0)
= = = = = = = = = =

sql=table \'joomladb.jos_poll_data\' doesn\'t exist sql=insert `jos_poll_data` values (11, 14, \'\', 0):
- - - - - - - - - -
insert `#__poll_data` values (11, 14, '', 0)
= = = = = = = = = =

sql=table \'joomladb.jos_poll_data\' doesn\'t exist sql=insert `jos_poll_data` values (12, 14, \'\', 0):
- - - - - - - - - -
insert `#__poll_data` values (12, 14, '', 0)


can fixed or waisting time?

thanks in advanced

there error in sql file joomla installs during installation.
in /installation/sql/joomla.sql file

find block of sql code:

# table structure table `#__poll_data`

create table `#__poll_data` (
  `id` int(11) not null auto_increment,
  `pollid` int(4) not null default '0',
  `text` text not null default '',
  `hits` int(11) not null default '0',
  primary key  (`id`),
  key `pollid` (`pollid`,`text`(1))
) type=myisam

in particular find line:
`text` text not null default '',

and change line to:
`text` text not null,

save file and  upload /installation/sql/ folder on server.
now try again.
you want tick option drop (or backup) existing tables.
for better experience may wish delete or @ least drop of tables within current (botched) db before trying again.

hope helps.

dean