|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0001521||SMF 2.0||public||2008-02-08 16:37||2009-03-12 14:19|
|Summary||0001521: [POSTGRESQL] Installer can't create the Database|
|Description||Using the SMF installer it is unable to create a database if it doesn't exist.|
Yet using the same exact user I can create it via phpPgAdmin.
|Tags||No tags attached.|
JayBachatero (SMF Friend)
|This is by design. The installer assumes that the database has been created. Look t install.php 'always_has_db' is set to true for postgre and sqlite. I think that in most live environments you wont be able to create a database like that. The other thing would be the UTF-8 support. You can only enable UTF-8 support in postgre when you create the database.|
karlbenson (SMF Friend)
On install, there is the line
"If this database does not exist, this installer will try to create it."
maybe that needs altering if your select postgresql or sqlite then?
karl made my point.. the installer say it should, so it either should or shouldn't say
Would be nice for the installer to do this though and save me time during the test installs i do.
Last edited: 2008-07-29 14:16
I think this should easily fix it. It adds a language string.
$txt['db_settings_database_info'] = 'Fill in the name of the database you want to use for SMF to store its data in.
If this database does not exist, this installer will try to create it.';
$txt['db_settings_database_info'] = 'Fill in the name of the database you want to use for SMF to store its data in.';
$txt['db_settings_database_info_note'] = 'If this database does not exist, this installer will try to create it.';
<div style="font-size: smaller; margin-bottom: 2ex;">', $txt['db_settings_database_info'], '</div>
<div style="font-size: smaller; margin-bottom: 2ex;">', $txt['db_settings_database_info'], '
<span id="db_name_info_warning">', $txt['db_settings_database_info_note'], '</span></div>
document.getElementById(\'db_name_contain\').style.display = showAll ? \'\' : \'none\';
document.getElementById(\'db_filename_contain\').style.display = !showAll ? \'\' : \'none\';
if (document.getElementById(\'db_type_input\').value == "postgresql")
document.getElementById(\'db_name_info_warning\').style.display = \'none\';
document.getElementById(\'db_name_info_warning\').style.display = \'\';
JayBachatero (SMF Friend)
|I was working on a fix to actually support this. I can't remember where I saved those files :(.|
|! We can't create the db for Postgresql, so hide the part which says it does create it (install.php, Install.english.php) Revision 8066|