SQL Errors During Install x2

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!
Registered User
Posts: 1
Joined: Sun Oct 07, 2007 6:15 pm

SQL Errors During Install x2

Post by chii »

Hi all im working with a fresh install of phpbb 2.22? the final ver 2 can't recall the number lol; i went to install easymod and it errord twice during sql installs here are the errors

Code: Select all

# 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))

Error :: Table 'wordpress.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.3.0', '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.', 1191694772, '2.0.22', 'subSilver', 'english', 0, 1, 0, 1)

below is the debug info. i am currently using php 5.2.3 and apache 2.2.4 with mysql 5.2 :S dunno wat went wrong it looks like it works in the cp but i don't want to risk anything

EM installer v0.3.0 wrote: EM status: New Install
phpBB version: 2.0.22
Working Dir: F:\www\getbleach\forum\admin\mods\easymod
Install Step: 7

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

Additional System Information:

System: Windows NT WEB-SERVER 5.2 build 3790
Configure Command: cscript /nologo configure.js "--enable-snapshot-build" "--with-gd=shared"
PHP version: 5.2.1
register_globals: OFF
magic_quotes_gpc: OFF
magic_quotes_runtime: OFF
allow_url_fopen: ON
sockets_support: enabled

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
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.