 | [Solved] Attachment mod install via EM problem |  |
 Posted: 05/06/2007 3:58 PM |
 |
|
|
|
|
| Sparrow |
| Posts |
10 |
| Word Cnt. |
1,317 |
| BDay |
N/A |
| Sign |
N/A |
|
|
|
|
|
Joined: May 06, 2007
Local time: 2:49 AM
Location: Berkeley, CA
|
|
|
|
|
 |
When installing Attach Mod via EM, (using EM version of install.txt made by NightRider, thread) I reach the second page of the install, (step 2 of 3). That page has six boxes, each of which lists the following six Warnings with a header saying they were "Reported by the SQL Parser:"
| Code:
|
1. Inconsistent display width specified "INTEGER(20)" in column "max_filesize", statement: 3, table: "phpbb_extension_groups"
2. Identifier "comment" is a reserved keyword (reference: MySQL), statement: 4, table: "phpbb_extensions"
3. Identifier "comment" is a reserved keyword (reference: MySQL), statement: 5, table: "phpbb_attachments_desc"
4. Inconsistent display width specified "INTEGER(20)" in column "filesize", statement: 5, table: "phpbb_attachments_desc"
5. Column "comment" has been found using 2 different data types in 2 tables: VARCHAR(100) in phpbb_extensions; VARCHAR(255) in phpbb_attachments_desc.
6. Column "auth_download" has been found using 2 different data types in 2 tables: TINYINT(2) in phpbb_forums; TINYINT(1) in phpbb_auth_access.
|
After the above warnings is a list of 94 SQL statements that will be executed. The warnings all seemed minor, and according to previous posts they can be ignored. But when I clicked on "Complete Installation" button to perform Step 3, the result is always a blank page in the main frame. (Nothing is displayed except the admin navigation menu on the left). Also nothings seems to be installed or modified. When I view the source of the blank page, I see:
Sorry, your browser doesn't seem to support frames
Even though the browsers I tried (both IE 6 and FireFox) do support frames. Monitoring via Firefox Livehttp Headers tool, I see that the returned page has code: HTTP/1.x 406 Not Acceptable. If I deselect all the SQL statements before starting step 3, the result is the same. EM seems to be working because I was able to use it to install a different module.
Any idea what's going on? |
|
|
|
|
| Back to Top |
|
|
| Re: Attachment mod install via EM problem | |
| Posted: 05/06/2007 4:10 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 6:49 AM
Location: St Pete, FL
|
|
|
|
|
|
Welcome to RCF jefft!!!
You can safely ignore these errors. They are purely informational and ignoring them causes no problems. Go ahead and complete the MOD install...
Woops, I just finished reading the rest of your story. Try this. Remove all the SQL queries from the MOD then save and upload it back to its admin/mods MOD folder. Then upload the included install folder to your phpBB forum folder and run the install.php file from your browser. The path could look something like this:
http://yourdomain.com/phpBB2/install/install.php
Your forum will be offline as long as the install folder is present in the phpBB forum folder. So after successfully updating your database, you can delete the install folder. Be careful not to delete the includes folder by accident. That would be a disaster...
Then go ahead and try installing the Attachment MOD again using EM, minus the SQL query section:
| Code:
|
#
#-----[ SQL ]------------------------------------------------
#
CREATE TABLE phpbb_attachments_config (
config_name varchar(255) NOT NULL,
config_value varchar(255) NOT NULL,
PRIMARY KEY (config_name)
);
CREATE TABLE phpbb_forbidden_extensions (
ext_id mediumint(8) UNSIGNED NOT NULL auto_increment,
extension varchar(100) NOT NULL,
PRIMARY KEY (ext_id)
);
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)
);
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)
);
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)
);
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)
);
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)
);
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)
);
ALTER TABLE phpbb_forums ADD auth_download TINYINT(2) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_auth_access ADD auth_download TINYINT(1) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_posts ADD post_attachment TINYINT(1) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_topics ADD topic_attachment TINYINT(1) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_privmsgs ADD privmsgs_attachment TINYINT(1) DEFAULT '0' NOT NULL;
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_dir','files');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_img','images/icon_clip.gif');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('topic_icon','images/icon_clip.gif');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('display_order','0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize','262144');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_quota','52428800');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize_pm','262144');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments','3');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments_pm','1');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('disable_mod','0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_pm_attach','1');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_topic_review','0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_ftp_upload','0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('show_apcp','0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attach_version','2.4.5');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_upload_quota', '0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_pm_quota', '0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_server','');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_path','');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('download_path','');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_user','');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pass','');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pasv_mode','1');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_display_inlined','1');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_width','0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_height','0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_width','0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_height','0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_create_thumbnail','0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_min_thumb_filesize','12000');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_imagick', '');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('use_gd2','0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('wma_autoplay','0');
INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('flash_autoplay','0');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (1,'php');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (2,'php3');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (3,'php4');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (4,'phtml');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (5,'pl');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (6,'asp');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (7,'cgi');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (8,'php5');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (9,'php6');
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,'');
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,'');
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,'');
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,'');
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,'');
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,'');
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,'');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (1, 1,'gif', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (2, 1,'png', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (3, 1,'jpeg', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (4, 1,'jpg', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (5, 1,'tif', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (6, 1,'tga', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (7, 2,'gtar', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (8, 2,'gz', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (9, 2,'tar', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (10, 2,'zip', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (11, 2,'rar', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (12, 2,'ace', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (13, 3,'txt', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (14, 3,'c', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (15, 3,'h', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (16, 3,'cpp', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (17, 3,'hpp', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (18, 3,'diz', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (19, 4,'xls', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (20, 4,'doc', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (21, 4,'dot', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (22, 4,'pdf', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (23, 4,'ai', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (24, 4,'ps', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (25, 4,'ppt', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (26, 5,'rm', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (27, 6,'wma', '');
INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (28, 7,'swf', '');
INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (1, 'Low', 262144);
INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (2, 'Medium', 2097152);
INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (3, 'High', 5242880);
|
Welcome to RCF jefft!!!
 |
|
|
|
|
| Back to Top |
|
|
| Re: Attachment mod install via EM problem | |
| Posted: 05/06/2007 6:49 PM |
|
|
|
|
|
| Sparrow |
| Posts |
10 |
| Word Cnt. |
1,317 |
| BDay |
N/A |
| Sign |
N/A |
|
|
|
|
|
Joined: May 06, 2007
Local time: 2:49 AM
Location: Berkeley, CA
|
|
|
|
|
|
| Ok. That seems to have solved the problem. Just to summarize the problem and solution. The problem was that my attempt to install the attachment mod using EM was failing at step 3, giving a blank screen. Nightrider suggested that rather than use EM to do the entire install, the database setup be done first by loading install.php from a browser, and EM be used for the rest. So, first I loading the database by following step 1 in the DIY instructions in the original attachment mod install.txt file. (Which Nightrider summarized in his answer to my post). Then, after removing the database related commands from the EM friendly install.txt file (and commands that were copying files in the install directory), I used EM to make all the necessary file changes (but not do any database changes). This allowed the installation process to make it through step 3 and the module seems to be installed correctly. Thanks Nightrider! |
|
|
|
|
| Back to Top |
|
|
| Re: Attachment mod install via EM problem | |
| Posted: 05/06/2007 9:34 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 6:49 AM
Location: St Pete, FL
|
|
|
|
|
|
Unfortunately on some servers, the ALTER TABLE SQL queries cause the problem that you described. However, all the other SQL queries work fine. I don't have an explanation of why that happens on some server or how to fix it...
So in the future, if you encounter the problem again, simply remove the ALTER TABLE SQL queries from the MOD script and complete the install using EM. Then if the MOD author did not include a DB Update file with the MOD, you can use the following utility to create your own DB Update file that you can run from your browser:
MySQL to PHP Converter
Once you have created your own DB Update file using the SQL queries from the MOD script, you can upload the file to your phpBB forum folder then run it from your browser. The path could look something like this:
http://yourdomain.com/phpBB2/db_update.php
Once you have successfully updated your database, you can delete the db_update.php file from your phpBB forum folder and finish the MOD install using EM...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Attachment mod install via EM problem | |
| Posted: 05/07/2007 3:12 PM |
|
|
|
|
|
| Sparrow |
| Posts |
10 |
| Word Cnt. |
1,317 |
| BDay |
N/A |
| Sign |
N/A |
|
|
|
|
|
Joined: May 06, 2007
Local time: 2:49 AM
Location: Berkeley, CA
|
|
|
|
|
|
| Is there any way to debug EM problems like this? It's happening to me again with the mail2form mod www.mail2forum.com. Install guide for the mod gives instructions for EM installation (implying that it has worked with EM) but when I try it, I get another blank screen. This time before step 2. I did not see any alter table commands in the install file. In fact, there were no database commands. Yet EM fails, giving a blank screen. Any suggestion for how I could figure out why EM is failing for me now, when it was working for others on these modules? |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Attachment mod install via EM problem | |
| Posted: 05/07/2007 3:43 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 6:49 AM
Location: St Pete, FL
|
|
|
|
|
|
Ok, which version of the Mail2Forum MOD are you attempting to install? I just downloaded the current stable version, 1.2.6. Who is your host? Does your host require that the file permissions be set to anything other than 644???
I used to have the Mail2Forum MOD installed here, but it caused a lot of problems. So I eventually removed it. I hope they have corrected the problems that this MOD was causing for us...
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Attachment mod install via EM problem | |
| Posted: 05/07/2007 5:47 PM |
|
|
|
|
|
| Sparrow |
| Posts |
10 |
| Word Cnt. |
1,317 |
| BDay |
N/A |
| Sign |
N/A |
|
|
|
|
|
Joined: May 06, 2007
Local time: 2:49 AM
Location: Berkeley, CA
|
|
|
|
|
|
| I'm using latest stable release of mail2forum (1.2.6). Service provider is hoststock http://www.hoststock.com which I've been very satisfied with. Excellent prices and great service. EM is configured to use buffer/FTP to update files. I don't think file permissions are a problem. What mostly puzzles me is that EM is giving a blank page, rather than an error message. It seems to me that it should be written in a way that at least gives an error message if something goes wrong, rather than just die and generate a blank page. Must be something with my setup, because I don't see much mention of this problem from other EM users in this forum. Thanks for mentioning the problems you had with mail2forum. I'll want to test it thoroughly before we commit to using it. |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Attachment mod install via EM problem | |
| Posted: 05/07/2007 8:16 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 6:49 AM
Location: St Pete, FL
|
|
|
|
|
|
When there is an error using EM, there usually is an Error message. But on some sites, that doesn't happen. Often the problem is on sites that require file permissions other than the standard 644. If you are on one of these sites where the host server requires file permissions to be set to something other than 644, then you would have to install a modified version of EM that I can make available to you. But there is no need to install it unless you are on one of those exceptions. That's why I asked about your file permissions...
Do you know whether Safe Mode is turned on on your server???
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Attachment mod install via EM problem | |
| Posted: 05/08/2007 12:52 AM |
|
|
|
|
|
| Sparrow |
| Posts |
10 |
| Word Cnt. |
1,317 |
| BDay |
N/A |
| Sign |
N/A |
|
|
|
|
|
Joined: May 06, 2007
Local time: 2:49 AM
Location: Berkeley, CA
|
|
|
|
|
|
| I think file permissions 644 are ok because permissions on files in another software package on the system (durpal) are set to 644 and it works fine. Safe mode is off (according to phpinfo()). I wonder if there is some way to turn on a debugging mode in EM to get a trace of what is happening? The ftp debug option in EM Settings does not help. Still get a blank page (406 error, with view source showing "Sorry, your browser doesn't seem to support frames") and no debugging info. |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Attachment mod install via EM problem | |
| Posted: 05/08/2007 2:07 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 6:49 AM
Location: St Pete, FL
|
|
|
|
|
|
The blank page problem is caused by settings on your host side beyond EM's control. There is a setting in your includes/constants.php file that should be turned on:
| Code:
|
|
define('DEBUG', 1); // Debugging on
|
You may be able to add this to your .htaccess file too, which would be stored in the phpBB forum folder. If it doesn't exist, you can always create it:
| Code:
|
|
php_flag display_errors On
|
If you have a php.ini file, you might be able to add the following line in it or if the display_errors line exists, make sure that it is set to On:
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
