Modern Buddy

If you guys are getting a php error screen with some weird messages, well, I am too.

Working on it.

Any SQL/phpBB experts out there?

I think our host did some kind of SQL upgrade or modification which hosed us.

Just got on over lunch. Seems to be working fine for me so far.

What's not working for me is using the "quote" button to reply.

Yep. I'm getting the debug message when I try to edit my posts. Now you're all going to see what a crappy speller I really am.

^^^ Same here. I just tried to quote what you said and got an error screen.

I couldn't quote, edit, or delete a post I wanted to add something to... it gave me the same error for all three options.

Anybody want to try reporting just to see what happens with that?

Looks to me like at least one SQL table needs to be reindexed.

If you have access to the DB, via the command-line, or I suppose you can do it through phpmyadmin or the like, you could try:

> repair table 'phpbb_attachments_desc';

Of course, if that is a large table, a repair could take awhile. But from what it sounds like, it is just a list of the attachments on the site, which shouldn't be *too* big, I'd think.

This could be affecting other tables too, but that is the only one I've seen an error for, when trying to view postings with attachments in them.

Just this one table and it seems to stem from a PHP upgrade by the host. Grr. I can go back to php4, but don't want to wreak any more possible havoc. Going to go bitch at the host and see what they come up with.

Thanks for your patience!

I don't really see how a PHP upgrade could cause this. The error is straight from the DB (MySQL presumably).

SQL Error : 1034 Incorrect key file for table 'phpbb_attachments_desc'; try to repair it

Are you sure they didn't upgrade the MySQL version as well? That can cause some tables to not work properly until a reindexing is done. I bet a simple repair on that table would solve the issue, and quickly, if you have the access.

FYI, I am a system administrator, fluent in php, and databases.

Yeah, I th err rs too. Es cially in the " Ne H nda Motocompo?! Yes, Please!" thre d. I hop th s gets fix d soon beca se it can be an oyin .

Tried to repair in phpMyAdmin. Getting a "Incorrect key file" error.

Support request sent to host. We'll see…

ericalm wrote:Support request sent to host. We'll see…

So far we are not seeing. Don't tell me you've been working at some job or other rather than giving this problem 24/7......... (just teasing, we are patiently waiting )

Nope. One response from support. I replied to that. They're looking at it. I hope.

I tried to open a link to another MB thread somebody had put into a post and came up with a funny message instead. Is that what you're talking about?

Could be. If anyone gets any error messages, it might help if you could paste them in this thread. I think they're all the same table causing this, though.

BAH!

Here's one:
Could not get Attachment Informations for post number 260780, 260781

DEBUG MODE

SQL Error : 1034 Incorrect key file for table 'phpbb_attachments_desc'; try to repair it

SELECT a.post_id, d.* FROM phpbb_attachments a, phpbb_attachments_desc d WHERE a.post_id IN (260780, 260781) AND a.attach_id = d.attach_id ORDER BY d.filetime ASC

Line : 543

This was from the Stella forum. Tried to open the thread "Here's a reason to get the 4T Stella." But it also happened with some others and also in the Blur forum. Not so much in General Discussion.

That's the one!

Maybe I can dig for the offending line…

Here's another one that I get when I tried to press on the "quote" button:

================================
GENERAL ERROR

Could not get Attachment Informations for post number 261792

DEBUG MODE

SQL Error : 1034 Incorrect key file for table 'phpbb_attachments_desc'; try to repair it

SELECT a.post_id, d.* FROM phpbb_attachments a, phpbb_attachments_desc d WHERE a.post_id IN (261792) AND a.attach_id = d.attach_id ORDER BY d.filetime ASC

Line : 543
File : functions_attach.php

From the Ethenol thread when I clicked on the "quote" button:
-----------------------------------------------------------------------

Could not get Attachment Informations for post number 261776

DEBUG MODE

SQL Error : 1034 Incorrect key file for table 'phpbb_attachments_desc'; try to repair it

SELECT a.post_id, d.* FROM phpbb_attachments a, phpbb_attachments_desc d WHERE a.post_id IN (261776) AND a.attach_id = d.attach_id ORDER BY d.filetime ASC

Line : 543
File : functions_attach.php

FIXED! I think.

Thanks, all. If the issue pops up again, let me know!

I tried some threads at random in both the Stella and Blur forums, including some that returned the errors, and all worked fine.

I think you got it!

Thank you!!