EasyMod Install - Not So Easy :(

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
grundybin
Registered User
Posts: 5
Joined: Wed Jan 05, 2005 6:07 am
Contact:

EasyMod Install - Not So Easy :(

Post by grundybin »

I have full access to the server concerned, I'm sure I'v followed everything (as they all say) but I'm stuck :roll:



and I get this MYSQL Error
Progress :: . Done
Result :: Some queries failed, the statements and errors are listing below

* Error :: Invalid default value for 'mod_id'
SQL :: CREATE TABLE phpbb_easymod ( mod_id mediumint(8) NOT NULL DEFAULT '0' auto_increment, mod_title varchar(50) 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))


(formatted for forum posting)
EM installer v0.0.10a wrote:
phpBB version:

2.0.11
Working Dir: C:\Inetpub\auspolice\phpbb\admin\mods\easymod
Install Step: 3
Mode: debug
The Error wrote:

No error.
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
copy access :: OK



Recommendations:
write: server
move: copy

Selected settings:
write: ftpb
move: ftpa
ftp dir: auspolice/phpbb/

CWD Listing:

Code: Select all

drwxrwxrwx .
drwxrwxrwx ..
−rw−rw−rw− admin_easymod_functions.php
drwxrwxrwx backups
−rw−rw−rw− easymod.gif
−rw−rw−rw− easymod_install.php
drwxrwxrwx includes
−rw−rw−rw− lang_easymod.php
drwxrwxrwx processed

Testing FTP access...
Trying to localhost:21 ...
220 Microsoft FTP Service
Connected to remote host "localhost:21"
> USER administrator
331 Password required for administrator.
> PASS ********
230 User administrator logged in.
Authentication succeeded

1) Logged in successfully
> PWD
257 "/" is current directory.
> PASV
227 Entering Passive Mode (127,0,0,1,13,12).
> NLST
Trying to 127.0.0.1:3340 ...
125 Data connection already open; Transfer starting.
Connected to remote host
Disconnected from remote host

Notice: Undefined offset: 1 in C:\Inetpub\auspolice\phpbb\admin\mods\easymod\admin_easymod_functions.php on line 1833
AdminScripts
auspolice
ftproot
phpbb.zip
Spare
wwwroot226 Transfer complete.
> CWD auspolice/phpbb//admin/mods/easymod
250 CWD command successful.
> PWD
257 "/auspolice/phpbb/admin/mods/easymod" is current directory.
2) CD to EasyMOD path successfully
> TYPE A
200 Type set to A.
> PASV
227 Entering Passive Mode (127,0,0,1,13,14).
> STOR ../../../easymod.gif
Trying to 127.0.0.1:3342 ...
125 Data connection already open; Transfer starting.
Connected to remote host
Storing local file "easymod.gif" to remote file "../../../easymod.gif"
Disconnected from remote host
226 Transfer complete.
> TYPE A
200 Type set to A.
> PASV
227 Entering Passive Mode (127,0,0,1,13,17).
> STOR ../../../easymod.gif
Trying to 127.0.0.1:3345 ...
125 Data connection already open; Transfer starting.
Connected to remote host
Storing local file "easymod.gif" to remote file "../../../easymod.gif"
Disconnected from remote host
226 Transfer complete.
> DELE ../../../easymod.gif
250 DELE command successful.
3) wrote to phpBB root successfully
> QUIT
221
Disconnected from remote host

FTP access test :: successful


bas
Registered User
Posts: 43
Joined: Fri Oct 31, 2003 12:57 pm

Re: EasyMod Install - Not So Easy :(

Post by bas »

Yeah, the 4.1-error!

I zipped up my easymod_install.php for you, to fix the problem!
You do not have the required permissions to view the files attached to this post.
What do you think i am using for my forum? phpBB, as you already guessed...

grundybin
Registered User
Posts: 5
Joined: Wed Jan 05, 2005 6:07 am
Contact:

Re: EasyMod Install - Not So Easy :(

Post by grundybin »

Is MYSQL 4.1 stupid or somthing cos I'll go back if it keeps causing problems.

bas
Registered User
Posts: 43
Joined: Fri Oct 31, 2003 12:57 pm

Re: EasyMod Install - Not So Easy :(

Post by bas »

No, but it restricts the default values a bit. Such as "AUTO_INCREMENT may not have a default", and "A default for a INT may not be surrounded by quotes"...
What do you think i am using for my forum? phpBB, as you already guessed...

borgBOB
Registered User
Posts: 1
Joined: Wed Jan 05, 2005 11:13 pm

Re: EasyMod Install - Not So Easy :(

Post by borgBOB »

bas wrote: Yeah, the 4.1-error!

I zipped up my easymod_install.php for you, to fix the problem!
How exactly do I use this? should i first use ftp to place the 'mods' folder in
the 'admin' folder? it does not exist now. and what about all the other stuff in nuttzy99's zip file?

I have a brand new phpBB version 2.0.11 installed, and want to get this first.

Thanks.

bas
Registered User
Posts: 43
Joined: Fri Oct 31, 2003 12:57 pm

Re: EasyMod Install - Not So Easy :(

Post by bas »

First, you upload the normal easymod, then, you overwrite admin/mods/easymod/easymod_install.php with my version...
What do you think i am using for my forum? phpBB, as you already guessed...

pcssbb
Registered User
Posts: 3
Joined: Mon Jan 17, 2005 11:08 am

Re: EasyMod Install - Not So Easy :(

Post by pcssbb »

bas wrote: No, but it restricts the default values a bit. Such as "AUTO_INCREMENT may not have a default", and "A default for a INT may not be surrounded by quotes"...
I failed on my initial install of Easymod due to the mySQL 4.1 problem. I downloaded your modded install.php file and am getting the "This version of EM has already been installed". There is no phpbb_easymod table in the DB. I had backed up my whole www directory structure before I started the initial easymod install and even copied it back to webroot and am still getting the "already installed" message. I also changed my boards default style to subSilver and tried to run the version changer but it won't run. I guess what I am asking is where is the easymod installer getting the information that it is already installed? Is there an environment variable or something? Having nothing easymod related in the DB and using web files from before I ever attempted the install has me perplexed as to why I am still getting this.

bas
Registered User
Posts: 43
Joined: Fri Oct 31, 2003 12:57 pm

Re: EasyMod Install - Not So Easy :(

Post by bas »

Just remove the entries starting with EM_ in phpbb_config.

That is made before phpbb_easymod table :mrgreen:
What do you think i am using for my forum? phpBB, as you already guessed...

pcssbb
Registered User
Posts: 3
Joined: Mon Jan 17, 2005 11:08 am

Re: EasyMod Install - Not So Easy :(

Post by pcssbb »

Thanks alot - I will give that a go. BTW, I applied your SQL changes for easymod to the Log_Actions mod to get it to work with mySQL 4.1.8 and it fixed the problem alot of us were having. Thanks for that as well.

Riley
Registered User
Posts: 1
Joined: Fri Jan 21, 2005 4:42 am

Re: EasyMod Install - Not So Easy :(

Post by Riley »

this is all fine and dandy and the mod is now installed, however, now we have the fact that it can not install anything because of the 4.1 sql problem...

Locked