derek_budd wrote: I just downloaded and installed 2.0.7. Are there any issues with using the attachment mod with this version? can the pre-edited files be used?
camm15h wrote: Users and mods are having a problem uploading attachments, apart from the admin. This is the error:Any ideas? Can't see a setting for attachment upload size limits.
Code: Select all
The Attachment/Image must be less than 125 pixels wide and 125 pixels high.
timbercrawler wrote: I want to know how you specify attachment dimensions, that would be great if i could do that! Can I?
SuperStyro wrote: I just need to figure out how to add phpbb_attach_quota table back in to my database with a sql script file.
I get this error when logged in on any account while looking at everyone else's profile besides my own....
Could not get User Quota
SQL Error : 1146 Table 'mysql.phpbb_attach_quota' doesn't exist
SELECT l.quota_limit FROM phpbb_attach_quota q, phpbb_quota_limits l WHERE (q.user_id = 8 ) AND (q.user_id <> 0) AND (q.quota_type = 1) AND (q.quota_limit_id = l.quota_limit_id) LIMIT 1
Line : 184
File : c:\inetpub\wwwroot\phpscript\phpbb2\attach_mod\posting_attachments.php
I am using MySQL 4 and I just cannot get the correct format down in the sql file to add the table i guess.
I am pretty sure that it is something like this for the sql file.
CREATE TABLE [phpbb_attach_quota] (
[user_id] [int] NOT NULL,
[group_id] [int] NOT NULL,
[quota_type] [tinyint] NOT NULL,
[quota_limit_id] [int] NOT NULL
I hope this is all that is just needed
PS I think i also need something like with this in an sql file
ALTER TABLE [phpbb_attach_quota] WITH NOCHECK ADD
CONSTRAINT [DF_phpbb_attach_quota_user_id] DEFAULT (0) FOR [user_id],
CONSTRAINT [DF_phpbb_attach_quota_group_id] DEFAULT (0) FOR [group_id],
CONSTRAINT [DF_phpbb_attach_quota_quota_type] DEFAULT (0) FOR [quota_type],
CONSTRAINT [DF_phpbb_attach_quota_quota_limit_id] DEFAULT (0) FOR [quota_limit_id]