Install Error with MySQL - HELP !!!

Having problems installing EM? Let's fix that
Forum rules
DO NOT give out any FTP passwords to anyone! There is no reason to do so! If you need help badly enough, create a temporary FTP account that is restricted to only the files that you need help with and give the information for that. Giving out FTP information can be very dangerous!
Locked
MMirski
Registered User
Posts: 2
Joined: Sat Feb 09, 2008 4:37 pm

Install Error with MySQL - HELP !!!

Post by MMirski » Sat Feb 09, 2008 4:47 pm

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)
EM installer v0.2.1a wrote: phpBB version: 2.0.22
Working Dir: F:\RIOMAR\website\forums\admin\mods\easymod
Install Step: 7
Mode:
The Error wrote:
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
Registered User
Posts: 2
Joined: Sat Feb 09, 2008 4:37 pm

Re: Install Error with MySQL - HELP !!!

Post by MMirski » Sat Feb 09, 2008 4:54 pm

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

User avatar
WhiteWolfSix
Registered User
Posts: 210
Joined: Fri Jan 21, 2005 9:05 am
Location: 48°43′N, 19°08′E

Re: Install Error with MySQL - HELP !!!

Post by WhiteWolfSix » Sat Feb 09, 2008 5:02 pm

It seems EasyMOD wasn't properly istalled.
Image
WhiteWolfSix (WW6)

Locked