Topic: Invalid default value for id_block (was Re: SimplePortal tables missing after

[stefanwa]

Is my problem related somehow? This is what I get when trying to install the new version after uninstalling 2.3.2:

Invalid default value for 'id_block'

Should I open a new topic about it? Thanks

[AngelinaBelle]

Please try re-downloading the SimplePortal 2.3.3 package.  There was an earlier problem with that, fixed in the latest download (no version change).
 
Thanks

[Stern]

the same problem.
after upgrade SMF from 1.1.13 to 2.05:

"Invalid default value for 'id_block'
Файл: /ххххххххххххххххххххххххl/Packages/temp/install2.php
Строка: 500"

string from 498 to 515:

Code: [Select]

foreach ($data['columns'] as $column)
{
if (!isset($column['deprecated_name']) || !$smcFunc['db_change_column']($smf_db_prefix . $table, $column['deprecated_name'], $column))
$smcFunc['db_add_column']($smf_db_prefix . $table, $column);

if ($is_utf8 && in_array($column['type'], array('text', 'tinytext')))
{
$smcFunc['db_query']('', '
ALTER TABLE {db_prefix}{raw:table}
CHANGE {raw:name} {raw:name} {raw:type} CHARACTER SET utf8',
array(
'table' => $table,
'name' => $column['name'],
'type' => $column['type'],
)
);
}
}


[AngelinaBelle]

I think  this advice ought to work:
Re: Database Error After Upgrade to RC5

[Stern]

thank you, Angelina!

I solved the problem as follows:
renamed smf_sp_parameters and smf_sp_blocks (add _old), after which the portal to install without problems, but then again renamed the same table (new tables renamed to _new, old tables - deleted _old from names), and held a service of the CMF.

Everything works!)

[AngelinaBelle]

As they say, there is more than one way to skin a cat.
I'm glad you figured out a workaround for this problem.