eror while running install.xml

[Calugarar]

Hello, i've installed phpBB statistics 1.0.2 using automod.
I had to do a force install after it gave me the following report

New Files
Source Target Status
root/adm/*.* adm/*.* Error
root/includes/acp/*.* includes/acp/*.* Success
root/includes/stats/*.* includes/stats/*.* Success
root/install/*.* install/*.* Success
root/language/en/mods/*.* language/en/mods/*.* Success
root/statistics/*.* statistics/*.* Success
root/styles/prosilver/template/stats/*.* styles/prosilver/template/stats/*.* Success
root/styles/prosilver/theme/statistics.css styles/prosilver/theme/statistics.css Success
root/stats.php stats.php Success
root/styles/subsilver2/template/stats/*.* styles/subsilver2/template/stats/*.* Success

I cant create the mods folder in adm.

Then i scrolled down to see if everything is ok and i found this:

posting.php
Find

// The last parameter tells submit_post if search indexer has to be run
$redirect_url = submit_post($mode, $post_data['post_subject'], $post_data['username'], $post_data['topic_type'], $poll, $data, $update_message, ($update_message || $update_subject) ? true : false);

Add Before

/** Start phpBB Statistics
* send BBCode and smiley count to the DB
*/
if(!function_exists('save_bbcode_smiley_count'))
{
include($phpbb_root_path . 'statistics/includes/functions.' . $phpEx);
}
save_bbcode_smiley_count($data, $mode);
// End phpBB Statistics

The Find specified by the MOD could not be found

I opened up posting.php and i edited it

While going to install.xml after i clicked Proceed to next step i got this:

General Error
SQL ERROR [ mysql4 ]

Duplicate column name 'field_stats_show' [1060]

SQL

ALTER TABLE phpbb_profile_fields ADD field_stats_show TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT 0

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: install/install_install.php
LINE: 170
CALL: dbal_mysql->sql_query()

FILE: install/install_install.php
LINE: 73
CALL: install_install->load_schema()

FILE: install/index.php
LINE: 255
CALL: install_install->main()

FILE: install/index.php
LINE: 56
CALL: module->load()

What should i do to fix this problem ?

[Marc]

Did you run the installer twice?
Try removing the field_stats_show column from phpbb_profile_fields table and run the installer again.

[Calugarar]

I still cant create the mods dir in adm

[Calugarar]

I completed the install without creating the mods directory in adm

[Marc]

You only need that if you have Handyman's MOD Version Check installed. Still, I don't think it is good if you yourself can't create a directory in there.