I am having problems and need some 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
yellow
Registered User
Posts: 2
Joined: Sun Jan 13, 2008 10:54 am

I am having problems and need some help

Post by yellow » Sun Jan 13, 2008 11:04 am

First: When i attempt to ftp the files i get a error on one of the files(easymod_install.php~), I assume that it is caused by the "~" at the end of the filename?

I didn't think much of it at first so i continued to my site and tried to install easymod. I was able to get to step 7 and i am getting an error message:
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.', 1200220490, '2.0.18', 'subSilver', 'english', 0, 1, 0, 1)

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

Error :: Table 'phpbb.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.', 1200220490, '2.0.18', 'subSilver', 'english', 0, 1, 0, 1)



Error

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


Expanded Debug Info
(formatted for forum posting)
EM installer v0.2.1a wrote: phpBB version: 2.0.18
Working Dir: /phpBB/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 :: module not loaded
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

drwxrwxr-x . 
drwxrwxr-x .. 
-;rw-rw-r-- easymod.gif 
-;rw-rw-r-- easymod_display_functions.php 
-;rw-rw-r-- easymod_install.php 
drwxrwxr-x em_includes 
drwxrwxr-x includes 
drwxrwxr-x languages 
drwxrwxr-x templates 
-;rwxrwxrwx post_process.sh 
-;rwxrwxrwx post_process.bat 

Not testing FTP since it is not being used.




I have tried reinstalling easymod and get the same message. Any help here would be greatly appreciated. I am using phpBB version 2.0.18.
I am new to php and MySQL so try to dummy it down if possible

Realisty
Registered User
Posts: 107
Joined: Sat Jan 20, 2007 3:37 pm

Re: I am having problems and need some help

Post by Realisty » Sun Jan 13, 2008 12:16 pm

1 thing i do see is that you are installing an older version of easymod and not 0.3.0

yellow
Registered User
Posts: 2
Joined: Sun Jan 13, 2008 10:54 am

Re: I am having problems and need some help

Post by yellow » Sun Jan 13, 2008 6:45 pm

Thanks for the quick response. I found o.3.0 and uploaded it. No ftp error this time.

When i try to intall it: Step 4/5 is where the error starts
Adding EasyMOD tables 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))
CREATE TABLE phpbb_easymod_processed_files ( mod_processed_file varchar(255) NOT NULL DEFAULT '', mod_id mediumint(8) NOT NULL DEFAULT '0', KEY mod_processed_file (mod_processed_file), KEY mod_id (mod_id))

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

* Error :: Access denied for user 'yscr_bbJ-O-'@'localhost' to database 'phpbb'
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 :: Access denied for user 'yscr_bbJ-O-'@'localhost' to database 'phpbb'
SQL :: CREATE TABLE phpbb_easymod_processed_files ( mod_processed_file varchar(255) NOT NULL DEFAULT '', mod_id mediumint(8) NOT NULL DEFAULT '0', KEY mod_processed_file (mod_processed_file), KEY mod_id (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.


It says nothing to worry about so should i continue even though it can not create the apropriate databasa table((s)?
How can i make it create the table(s)?
I will stop the install where I am incase i need to do something different...

Thanks in advance for the help

Realisty
Registered User
Posts: 107
Joined: Sat Jan 20, 2007 3:37 pm

Re: I am having problems and need some help

Post by Realisty » Mon Jan 14, 2008 6:08 pm

as far as i can tell then the user for that database has not the permissions to create tables

User avatar
Lumpy Burgertushie
Registered User
Posts: 1006
Joined: Tue Feb 28, 2006 5:26 pm

Re: I am having problems and need some help

Post by Lumpy Burgertushie » Mon Jan 28, 2008 4:07 pm

it seems that you are using yahoo for hosting. they do not give you the proper permissions/access to your database. you will need to ask them for that access or at the very least to tell you how to work with your database.

robert

Locked