Help for new guy- cant get attachment mod premade files to..
Moderator: Experts
-
- Posts: 24
- Joined: Thu Jan 25, 2007 7:49 pm
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?)
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?)
-
- Posts: 24
- Joined: Thu Jan 25, 2007 7:49 pm
-
- Posts: 24
- Joined: Thu Jan 25, 2007 7:49 pm
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.
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.
-
- Posts: 24
- Joined: Thu Jan 25, 2007 7:49 pm
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.
-
- Posts: 24
- Joined: Thu Jan 25, 2007 7:49 pm
-
- Posts: 24
- Joined: Thu Jan 25, 2007 7:49 pm
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
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
One of two problems could be the issue. Try putting this into notepad and save as phpinfo.php:
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.
Code: Select all
<?php phpinfo(); ?>
-
- Posts: 24
- Joined: Thu Jan 25, 2007 7:49 pm
upload_max_filesize 50M 50M
post_max_size 50M 50M
http://www.arcturus-uav.com/forum/phpinfo.php
thnaks for the fast reply
post_max_size 50M 50M
http://www.arcturus-uav.com/forum/phpinfo.php
thnaks for the fast reply
-
- Posts: 24
- Joined: Thu Jan 25, 2007 7:49 pm
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:
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:
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.
Code: Select all
php_value max_input_time 60
php_value max_execution_time 120
Code: Select all
max_execution_time = 120
max_input_time = 60