Install Error with MySQL - HELP !!!

[MMirski]

Here is what happens step by step. Anyone there to help? I am installing on Windows server being physically loged in at the terminal.

1. Some quesries fail:

Adding EasyMOD table to your database
Executing SQL: CREATE TABLE phpbb_easymod ( mod_id mediumint(8) NOT NULL auto_increment, mod_title varchar(255) NULL DEFAULT '', mod_file varchar(255) NULL DEFAULT '', mod_version varchar(15) NULL DEFAULT '', mod_author_handle varchar(25) NULL DEFAULT '', mod_author_email varchar(100) NULL DEFAULT '', mod_author_name varchar(100) NULL DEFAULT '', mod_author_url varchar(100) NULL DEFAULT '', mod_description text NULL DEFAULT '', mod_process_date int(11) NULL DEFAULT '0', mod_phpBB_version varchar(15) NULL DEFAULT '', mod_processed_themes varchar(200) NULL DEFAULT '', mod_processed_langs varchar(200) NULL DEFAULT '', mod_files_edited mediumint(8) NULL DEFAULT '0', mod_tables_added mediumint(8) NULL DEFAULT '0', mod_tables_altered mediumint(8) NULL DEFAULT '0', mod_rows_inserted mediumint(8) NULL DEFAULT '0', PRIMARY KEY (mod_id))

Progress :: . Done
Result :: Some queries failed, the statements and errors are listing below

Error :: BLOB/TEXT column 'mod_description' can't have a default value
SQL :: CREATE TABLE phpbb_easymod ( mod_id mediumint(8) NOT NULL auto_increment, mod_title varchar(255) NULL DEFAULT '', mod_file varchar(255) NULL DEFAULT '', mod_version varchar(15) NULL DEFAULT '', mod_author_handle varchar(25) NULL DEFAULT '', mod_author_email varchar(100) NULL DEFAULT '', mod_author_name varchar(100) NULL DEFAULT '', mod_author_url varchar(100) NULL DEFAULT '', mod_description text NULL DEFAULT '', mod_process_date int(11) NULL DEFAULT '0', mod_phpBB_version varchar(15) NULL DEFAULT '', mod_processed_themes varchar(200) NULL DEFAULT '', mod_processed_langs varchar(200) NULL DEFAULT '', mod_files_edited mediumint(8) NULL DEFAULT '0', mod_tables_added mediumint(8) NULL DEFAULT '0', mod_tables_altered mediumint(8) NULL DEFAULT '0', mod_rows_inserted mediumint(8) NULL DEFAULT '0', PRIMARY KEY (mod_id))


This is probably nothing to worry about, install will continue. Should this fail to complete you may need to seek help at our development board.

2. Major Error with table update

Final Step: EasyMOD is now confirming all files have been correctly moved into place. If confirmed, then your database will be updated and installation will be complete!






admin_easymod.php, looking for: admin_easymod.php
Confirmed!


mod_install.tpl: verifying existence
Confirmed!




Updating EasyMOD table data
Storing config table entries: Done

Executing SQL: INSERT INTO phpbb_easymod ( mod_title, mod_file, mod_version, mod_author_handle, mod_author_email, mod_author_name, mod_author_url, mod_description, mod_process_date, mod_phpBB_version, mod_processed_themes, mod_processed_langs, mod_files_edited, mod_tables_added, mod_tables_altered, mod_rows_inserted) VALUES ( 'EasyMOD', 'easymod/easymod_install.php', '0.2.1a', 'Nuttzy', 'pktoolkit@blizzhackers.com', 'n/a', 'http://www.blizzhackers.com', 'EasyMOD automatically perfoms in seconds which previously required the tedious task of manually editing files.', 1202575437, '2.0.22', 'subSilver', 'english', 0, 1, 0, 1)

Progress :: . Done
Result :: Some queries failed, the statements and errors are listing below

Error :: Table 'mysql.phpbb_easymod' doesn't exist
SQL :: INSERT INTO phpbb_easymod ( mod_title, mod_file, mod_version, mod_author_handle, mod_author_email, mod_author_name, mod_author_url, mod_description, mod_process_date, mod_phpBB_version, mod_processed_themes, mod_processed_langs, mod_files_edited, mod_tables_added, mod_tables_altered, mod_rows_inserted) VALUES ( 'EasyMOD', 'easymod/easymod_install.php', '0.2.1a', 'Nuttzy', 'pktoolkit@blizzhackers.com', 'n/a', 'http://www.blizzhackers.com', 'EasyMOD automatically perfoms in seconds which previously required the tedious task of manually editing files.', 1202575437, '2.0.22', 'subSilver', 'english', 0, 1, 0, 1)

3. Here is the code from that page:

(formatted for forum posting)

phpBB version: 2.0.22
Working Dir: F:\RIOMAR\website\forums\admin\mods\easymod
Install Step: 7
Mode:

Could not successfully update table. Something is wrong and install cannot complete.

Permissions: (including system errors)

read access :: OK
write access :: OK
root path write :: OK
chmod access :: OK
unlink access :: OK
mkdir access :: OK
tmp path write :: OK
FTP extension :: OK
Safe Mode :: OFF
copy access :: OK



Recommendations:
write: server
move: copy

Selected settings:
write: server
move: copy
ftp dir: /
ftp host: localhost
ftp port: 21
ftp debug: false
ftp ext: fsock
ftp cache: false

CWD Listing:

Code: Select all

drwxrwxrwx . 
drwxrwxrwx .. 
-;rw-rw-rw- easymod.gif 
-;rw-rw-rw- easymod_display_functions.php 
-;rw-rw-rw- easymod_install.php 
-;rw-rw-rw- easymod_install.php~ 
drwxrwxrwx em_includes 
drwxrwxrwx includes 
drwxrwxrwx languages 
-;rwxrwxrwx post_process.bat 
-;rw-rw-rw- post_process.sh 
drwxrwxrwx templates 

Not testing FTP since it is not being used.

Any ideas?

Regards,

MM

[MMirski]

Here is what I get when trying to install any mod:


Could not obtain EasyMod information

DEBUG MODE

SQL Error : 1146 Table 'mysql.phpbb_easymod' doesn't exist

INSERT INTO phpbb_easymod ( mod_file, mod_title, mod_version, mod_author_handle, mod_author_email, mod_author_url, mod_author_name, mod_description, mod_process_date, mod_phpBB_version, mod_processed_themes, mod_processed_langs, mod_files_edited) VALUES ( 'Admin_Userlist_2/install_userlist_206c.txt', 'Admin Userlist', '2.0.6c', 'Milkboy31', 'N/A', 'N/A', 'Brent Pirolli', 'This MOD lets you view all of you members and various information about them in the Admin Control Panel. From the list, you can perform various actions on multiple users.', 1202576028, '2.0.22', 'subSilver', 'english', 2)

Line : 3171
File : admin_easymod.php

[WhiteWolfSix]

It seems EasyMOD wasn't properly istalled.