unable to write mysql files at the end

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Garrett Connelly
Registered User
Posts: 87
Joined: Sat May 19, 2007 2:08 am

unable to write mysql files at the end

Post by Garrett Connelly »

A fatal and unrecoverable database error has occurred. This may be because the specified user does not have appropriate permissions to CREATE TABLES or INSERT data, etc. Further information may be given below. Please contact your hosting provider in the first instance or the support forums of phpBB for further assistance.

install_install.php [ 1177 ]

SQL : CREATE TABLE phpbb_3attachments ( attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, physical_filename varchar(255) DEFAULT '' NOT NULL, real_filename varchar(255) DEFAULT '' NOT NULL, download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, attach_comment text NOT NULL, extension varchar(100) DEFAULT '' NOT NULL, mimetype varchar(100) DEFAULT '' NOT NULL, filesize int(20) UNSIGNED DEFAULT '0' NOT NULL, filetime int(11) UNSIGNED DEFAULT '0' NOT NULL, thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (attach_id), KEY filetime (filetime), KEY post_msg_id (post_msg_id), KEY topic_id (topic_id), KEY poster_id (poster_id), KEY is_orphan (is_orphan) ) CHARACTER SET `utf8` COLLATE `utf8_bin`

Can't create/write to file './mysql/phpbb_3attachments.MYD' (Errcode: 9)

User avatar
m157y
Registered User
Posts: 482
Joined: Mon Apr 30, 2007 9:39 am
Location: Russia, Moscow, Khimki
Contact:

Re: unable to write mysql files at the end

Post by m157y »

i have yhis error when i don't have enought space on hdd with sql-server on when this table already exists... check this :)
m157y aka Misty
NO SUPPORT VIA PM
KarmaMOD for phpBB 3.0.x | bbAJAX
Follow me on twitter

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: unable to write mysql files at the end

Post by karlsemple »

Does the database user have the correct permissions to create tables?
Image

Garrett Connelly
Registered User
Posts: 87
Joined: Sat May 19, 2007 2:08 am

Re: unable to write mysql files at the end

Post by Garrett Connelly »

karlsemple wrote:

Does the database user have the correct permissions to create tables?
--------------------------

Yes, It worked fine until the porn spammers signed on and one of them couldn't be removed. That's when I deleted phpBB2. Now both 2 & 3 get this error.

All I wanted to do is share the questions people write in and ask, so I guess I could forget the whole idea and just post my answers, but, then, ideas from other people won't have the phpBB community to be seen and appreciated or learned from. This porn spam stuff is a real suprise.

Is the below mod suggesting that [hide] [/hide] are already part of the forum and I have use the mod to turn that off?

## easymod compliant
##############################################################
## MOD Title: bbHide
## MOD Author: m157y < ru.m157y@gmail.com > (Andrey) n/a
## MOD Author: [R: R@m$e$ :U] < Ramses@FromRU.com > (Ramses) http://www.phpbbguru.net
## MOD Description: This MOD allows users to hide a part of message via [hide][/hide]
## or [hide=x][/hide] or [hide="group"][/hide] or [hide=gx][/hide] or
## [hide=thanks][/hide] BBCodes. To see the hidden message, user must
## be a logged member or if used [hide=x], where x > 0 user also must
## have x posts, if used [hide="group"], user must be at group with
## name "group", if used [hide=gx] user must be in group with id x,
## if used [hide=thanks] user must say thanks for post
## You can limit x from ACP, also you can disable ability to use
## [hide="group"][/hide]([hide=gx][/hide]) and [hide=thanks][/hide]
## or you can disable tags except [hide=thanks][/hide] at this
## situation [hide][/hide] will be parsed like [hide=thanks][/hide]
## NOTE: You also can use [hide=] in addition of [hide=0] and [hide]
## You also can use [hide="x"], in addition of [hide=x]
## MOD Version: 1.0.0 alpha #18
##
## Installation Level: Easy
## Installation Time: ~30 Minutes
## Files To Edit: (11)
...
## Included Files: (15)

User avatar
david63
Registered User
Posts: 17257
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: unable to write mysql files at the end

Post by david63 »

That mod is for phpbb2 and will not work on phpbb3.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

User avatar
m157y
Registered User
Posts: 482
Joined: Mon Apr 30, 2007 9:39 am
Location: Russia, Moscow, Khimki
Contact:

Re: unable to write mysql files at the end

Post by m157y »

2 Garrett Connelly
and development this mod for olympus not actually, because highway of life develops analog of this mod :) but i have about 40% features of it in olympus on my localhost :)
m157y aka Misty
NO SUPPORT VIA PM
KarmaMOD for phpBB 3.0.x | bbAJAX
Follow me on twitter

Garrett Connelly
Registered User
Posts: 87
Joined: Sat May 19, 2007 2:08 am

Re: unable to write mysql files at the end

Post by Garrett Connelly »

So, let's say the db is full because hidden groups ran a pole that I can't find to delete because it's hidden.

What do I do?

Garrett

PS > My open source friend in Russia, Constantine, a genius. I can't find him. Can you google inside Russia better than me?

Locked

Return to “[3.0.x] Support Forum”