David IQ Software Development

Posted: **Fri Jan 26, 2007 9:25 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?)

Posted: **Sat Jan 27, 2007 12:17 am**

Try the install/install.php script again that comes with phpBB.

Posted: **Sat Jan 27, 2007 2:18 pm**

I would but I deleated that file when it told me too, heh I guess il start from scratch again...

Posted: **Sat Jan 27, 2007 4:40 pm**

You could just upload that folder again...

Posted: **Tue Jan 30, 2007 7:54 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.

Posted: **Tue Jan 30, 2007 11:14 pm**

Well at least you got the steps right this time around

Posted: **Wed Jan 31, 2007 8:44 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.

Posted: **Wed Jan 31, 2007 8:47 pm**

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

Posted: **Wed Jan 31, 2007 11:05 pm**

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.

Posted: **Thu Feb 01, 2007 12:41 am**

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

Posted: **Thu Feb 01, 2007 12:56 am**

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.

Posted: **Thu Feb 01, 2007 1:05 am**

upload_max_filesize 50M 50M
post_max_size 50M 50M

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

thnaks for the fast reply

Posted: **Thu Feb 01, 2007 1:20 am**

well how did you do that...
8) you can add attachments but I cant....

Posted: **Thu Feb 01, 2007 7:31 am**

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.

Posted: **Thu Feb 01, 2007 7:40 am**

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.

David IQ Software Development

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