Help for new guy- cant get attachment mod premade files to..

Since Opentools.de has now gone away I've created this forum to house FAQs and support for this mod in phpBB2.

Moderator: Experts

doubleatheman
Posts: 24
Joined: Thu Jan 25, 2007 7:49 pm

Post by doubleatheman »

I am using the php admin tool provided by yahoo to acess my mysql.. and this is the first time looking at my mysql page so...

I dont even really know wht it does...

im learning

thanks again

---------------------------------------------
Edit:
Im assuming I need to grant the user all privlages so I have..... now what shail I do?

(also, I have 6 php databases.... can I deleate all the other old ones?)
DavidIQ
Site Admin
Posts: 619
Joined: Thu Sep 07, 2006 4:31 pm
Location: Earth
Contact:

Post by DavidIQ »

Try the install/install.php script again that comes with phpBB.
doubleatheman
Posts: 24
Joined: Thu Jan 25, 2007 7:49 pm

Post by doubleatheman »

I would but I deleated that file when it told me too, heh I guess il start from scratch again...
DavidIQ
Site Admin
Posts: 619
Joined: Thu Sep 07, 2006 4:31 pm
Location: Earth
Contact:

Post by DavidIQ »

You could just upload that folder again...
doubleatheman
Posts: 24
Joined: Thu Jan 25, 2007 7:49 pm

Post by doubleatheman »

Oh cool, I didnt know you could reupload and run the install files..


My prolonged pause is due to me messing up my Mysql database....
(I changed the yroot user password, please dont ask why, that was my stupid mistake, I know now to never change the yroot user)

So I couldent remake a new fourm after deleating my old one. Yahoo used the yroot user to create pbpbb fourms. I am currently having yahoo reset my database. A clean start would be good for me anyway.


So once my mysql is back up, My plans are...

Install myphpadmin tool...
Install pbpbb 2.0.18 (again waht comes form yahoo)
Look at the config.php file find the mysql user
Go into myphpadmin and change premisison to that user to "grand all acess"
Upload phpbb 2.0.22 files
Run update php files
upload attachments mod
install attachments mod
Hopefully I will have a working fourms.


Thanks again for your help, Im sure ill be back once my mysql is reset.
DavidIQ
Site Admin
Posts: 619
Joined: Thu Sep 07, 2006 4:31 pm
Location: Earth
Contact:

Post by DavidIQ »

Well at least you got the steps right this time around ;-)
doubleatheman
Posts: 24
Joined: Thu Jan 25, 2007 7:49 pm

Post by doubleatheman »

Just sticking these here, I encounterd a few errors....


Code: Select all

Checking attachment mod storage directory:
 files/  Directory found, Directory writeable

Running :: CREATE TABLE phpbb_attachments_config ( config_name varchar(255) NOT NULL, config_value varchar(255) NOT NULL, PRIMARY KEY (config_name) ) -> COMPLETED

Running :: CREATE TABLE phpbb_forbidden_extensions ( ext_id mediumint(8) UNSIGNED NOT NULL auto_increment, extension varchar(100) NOT NULL, PRIMARY KEY (ext_id) ) -> COMPLETED

Running :: CREATE TABLE phpbb_extension_groups ( group_id mediumint(8) NOT NULL auto_increment, group_name char(20) NOT NULL, cat_id tinyint(2) DEFAULT '0' NOT NULL, allow_group tinyint(1) DEFAULT '0' NOT NULL, download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, upload_icon varchar(100) DEFAULT '', max_filesize int(20) DEFAULT '0' NOT NULL, forum_permissions varchar(255) default '' NOT NULL, PRIMARY KEY group_id (group_id) ) -> COMPLETED

Running :: CREATE TABLE phpbb_extensions ( ext_id mediumint(8) UNSIGNED NOT NULL auto_increment, group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, extension varchar(100) NOT NULL, comment varchar(100), PRIMARY KEY ext_id (ext_id) ) -> COMPLETED

Running :: CREATE TABLE phpbb_attachments_desc ( attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, physical_filename varchar(255) NOT NULL, real_filename varchar(255) NOT NULL, download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, comment varchar(255), extension varchar(100), mimetype varchar(100), filesize int(20) NOT NULL, filetime int(11) DEFAULT '0' NOT NULL, thumbnail tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (attach_id), KEY filetime (filetime), KEY physical_filename (physical_filename(10)), KEY filesize (filesize) ) -> COMPLETED

Running :: CREATE TABLE phpbb_attachments ( attach_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, privmsgs_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_id_1 mediumint(8) NOT NULL, user_id_2 mediumint(8) NOT NULL, KEY attach_id_post_id (attach_id, post_id), KEY attach_id_privmsgs_id (attach_id, privmsgs_id), KEY post_id (post_id), KEY privmsgs_id (privmsgs_id) ) -> COMPLETED

Running :: CREATE TABLE phpbb_quota_limits ( quota_limit_id mediumint(8) unsigned NOT NULL auto_increment, quota_desc varchar(20) NOT NULL default '', quota_limit bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (quota_limit_id) ) -> FAILED ---> Table 'phpbb_quota_limits' already exists

Running :: CREATE TABLE phpbb_attach_quota ( user_id mediumint(8) unsigned NOT NULL default '0', group_id mediumint(8) unsigned NOT NULL default '0', quota_type smallint(2) NOT NULL default '0', quota_limit_id mediumint(8) unsigned NOT NULL default '0', KEY quota_type (quota_type) ) -> FAILED ---> Table 'phpbb_attach_quota' already exists

Running :: ALTER TABLE phpbb_forums ADD auth_download TINYINT(2) DEFAULT '0' NOT NULL -> COMPLETED

Running :: ALTER TABLE phpbb_auth_access ADD auth_download TINYINT(1) DEFAULT '0' NOT NULL -> COMPLETED

Running :: ALTER TABLE phpbb_posts ADD post_attachment TINYINT(1) DEFAULT '0' NOT NULL -> COMPLETED

Running :: ALTER TABLE phpbb_topics ADD topic_attachment TINYINT(1) DEFAULT '0' NOT NULL -> COMPLETED

Running :: ALTER TABLE phpbb_privmsgs ADD privmsgs_attachment TINYINT(1) DEFAULT '0' NOT NULL -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_dir','files') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_img','images/icon_clip.gif') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('topic_icon','images/icon_clip.gif') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('display_order','0') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize','262144') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_quota','52428800') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize_pm','262144') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments','3') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments_pm','1') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('disable_mod','0') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_pm_attach','1') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_topic_review','0') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_ftp_upload','0') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('show_apcp','0') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attach_version','2.4.5') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_upload_quota', '0') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_pm_quota', '0') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_server','') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_path','') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('download_path','') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_user','') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pass','') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pasv_mode','1') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_display_inlined','1') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_width','0') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_height','0') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_width','0') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_height','0') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_create_thumbnail','0') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_min_thumb_filesize','12000') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_imagick', '') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('use_gd2','0') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('wma_autoplay','0') -> COMPLETED

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('flash_autoplay','0') -> COMPLETED

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (1,'php') -> COMPLETED

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (2,'php3') -> COMPLETED

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (3,'php4') -> COMPLETED

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (4,'phtml') -> COMPLETED

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (5,'pl') -> COMPLETED

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (6,'asp') -> COMPLETED

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (7,'cgi') -> COMPLETED

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (8,'php5') -> COMPLETED

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (9,'php6') -> COMPLETED

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (1,'Images',1,1,1,'',0,'') -> COMPLETED

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (2,'Archives',0,1,1,'',0,'') -> COMPLETED

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (3,'Plain Text',0,0,1,'',0,'') -> COMPLETED

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (4,'Documents',0,0,1,'',0,'') -> COMPLETED

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (5,'Real Media',0,0,2,'',0,'') -> COMPLETED

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (6,'Streams',2,0,1,'',0,'') -> COMPLETED

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (7,'Flash Files',3,0,1,'',0,'') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (1, 1,'gif', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (2, 1,'png', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (3, 1,'jpeg', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (4, 1,'jpg', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (5, 1,'tif', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (6, 1,'tga', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (7, 2,'gtar', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (8, 2,'gz', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (9, 2,'tar', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (10, 2,'zip', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (11, 2,'rar', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (12, 2,'ace', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (13, 3,'txt', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (14, 3,'c', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (15, 3,'h', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (16, 3,'cpp', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (17, 3,'hpp', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (18, 3,'diz', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (19, 4,'xls', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (20, 4,'doc', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (21, 4,'dot', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (22, 4,'pdf', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (23, 4,'ai', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (24, 4,'ps', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (25, 4,'ppt', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (26, 5,'rm', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (27, 6,'wma', '') -> COMPLETED

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (28, 7,'swf', '') -> COMPLETED

Running :: INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (1, 'Low', 262144) -> FAILED ---> Duplicate entry '1' for key 1

Running :: INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (2, 'Medium', 2097152) -> FAILED ---> Duplicate entry '2' for key 1

Running :: INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (3, 'High', 5242880) -> FAILED ---> Duplicate entry '3' for key 1


COMPLETE!

Some queries failed.
This is sometimes due to tables already there (from a previous installation), therefore please READ the errors and warnings and use common sense in interpreting them. Support is offered at opentools.de for questions you might have regarding those errors/warnings.

NOW REMOVE THE INSTALL AND CONTRIB DIRECTORIES

Code: Select all

Add new fields to the config table...




Add new INDEX to the Attachments Description Table...


Running :: ALTER TABLE phpbb_attachments_desc ADD INDEX (filetime) -> FAILED ---> Table 'phpbb.phpbb_attachments_desc' doesn't exist



Add new INDEX to the Attachments Description Table...


Running :: ALTER TABLE phpbb_attachments_desc ADD INDEX (physical_filename(10)) -> FAILED ---> Table 'phpbb.phpbb_attachments_desc' doesn't exist



Add new INDEX to the Attachments Description Table...


Running :: ALTER TABLE phpbb_attachments_desc ADD INDEX (filesize) -> FAILED ---> Table 'phpbb.phpbb_attachments_desc' doesn't exist



Add new INDEX to the Attachments Table...


Running :: ALTER TABLE phpbb_attachments ADD INDEX (post_id) -> FAILED ---> Table 'phpbb.phpbb_attachments' doesn't exist



Add new INDEX to the Attachments Table...


Running :: ALTER TABLE phpbb_attachments ADD INDEX (privmsgs_id) -> FAILED ---> Table 'phpbb.phpbb_attachments' doesn't exist



Add new row to the Extension Groups Table...


Running :: ALTER TABLE phpbb_extension_groups ADD forum_permissions VARCHAR(255) DEFAULT '' NOT NULL -> FAILED ---> Table 'phpbb.phpbb_extension_groups' doesn't exist



Add Quota Tables...


Running :: CREATE TABLE phpbb_quota_limits ( quota_limit_id mediumint(8) unsigned NOT NULL auto_increment, quota_desc varchar(20) NOT NULL default '', quota_limit bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (quota_limit_id) ) -> COMPLETED

Running :: CREATE TABLE phpbb_attach_quota ( user_id mediumint(8) unsigned NOT NULL default '0', group_id mediumint(8) unsigned NOT NULL default '0', quota_type smallint(2) NOT NULL default '0', quota_limit_id mediumint(8) unsigned NOT NULL default '0', KEY quota_type (quota_type) ) -> COMPLETED

Running :: INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (1, 'Low', 262144) -> COMPLETED

Running :: INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (2, 'Medium', 2097152) -> COMPLETED

Running :: INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (3, 'High', 5242880) -> COMPLETED



Change attachment data to new format (this can take a bit, please do not stop this script)




Finished... now remove the install and contrib directories.
doubleatheman
Posts: 24
Joined: Thu Jan 25, 2007 7:49 pm

Post by doubleatheman »

whooo.....!!!!!!!!!!

I did it all on my own... erm well, actualy thanks mostly to davidiq I have a working forums 2.0.22 with attachemnts mod

I got a few errors, please tell me if they will cause me problems... I did attach an image and it worked :)
DavidIQ
Site Admin
Posts: 619
Joined: Thu Sep 07, 2006 4:31 pm
Location: Earth
Contact:

Post by DavidIQ »

Nope...won't be a problem. All the errors you got mean that for some reason the entries were already in the table so you're good to go.
doubleatheman
Posts: 24
Joined: Thu Jan 25, 2007 7:49 pm

Post by doubleatheman »

well, it works for smaller images....

When I try a (about 1 meg file) it begins to upload but then stops... and goes to ablank page.

It seems I have read somehwere on how to fix this, whish I remebered where.

You can try uploading a file if you want/need to....

http://www.arcturus-uav.com/forum

(create your own user account if you want to but I have made this one to save you time:

Username: davidiq
password: yahoo
DavidIQ
Site Admin
Posts: 619
Joined: Thu Sep 07, 2006 4:31 pm
Location: Earth
Contact:

Post by DavidIQ »

One of two problems could be the issue. Try putting this into notepad and save as phpinfo.php:

Code: Select all

<?php phpinfo(); ?>
Then upload to your server and open the file in a browser. Look for upload_max_filesize and post_max_size and post back what values these are set to.
doubleatheman
Posts: 24
Joined: Thu Jan 25, 2007 7:49 pm

Post by doubleatheman »

upload_max_filesize 50M 50M
post_max_size 50M 50M

http://www.arcturus-uav.com/forum/phpinfo.php

thnaks for the fast reply :)
doubleatheman
Posts: 24
Joined: Thu Jan 25, 2007 7:49 pm

Post by doubleatheman »

well how did you do that...
8) you can add attachments but I cant....
DavidIQ
Site Admin
Posts: 619
Joined: Thu Sep 07, 2006 4:31 pm
Location: Earth
Contact:

Post by DavidIQ »

Well not exactly...I added it but I can't edit it (upload newer version). My guess is that the script is timing out before it completes the upload process... still looking.
DavidIQ
Site Admin
Posts: 619
Joined: Thu Sep 07, 2006 4:31 pm
Location: Earth
Contact:

Post by DavidIQ »

Well I can no longer upload the large files after enabling the thumbnails (that picture was huge). Try this. Open notepad and put this into it:

Code: Select all

php_value max_input_time 60
php_value max_execution_time 120
save it as htaccess and upload to your forum's root folder. Rename it .htaccess after having uploaded it. If your forum doesn't come up at all after uploading this file then delete it and try instead to create another file in notepad with the following:

Code: Select all

max_execution_time = 120
max_input_time = 60
save it as php.ini and put it in your forum's root folder. If this works then you should see in the phpinfo.php page a change in both values.
Locked