Forum Error/BUGS!

Post by **ericalm** » Tue Nov 29, 2011 6:28 pm

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.

viney266 · Post by **viney266** » Tue Nov 29, 2011 6:47 pm

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

teabow1 · Post by **teabow1** » Tue Nov 29, 2011 6:50 pm

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

Skootz Kabootz · Post by **Skootz Kabootz** » Tue Nov 29, 2011 6:53 pm

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.

viney266 · Post by **viney266** » Tue Nov 29, 2011 6:53 pm

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

LunaP · Post by **LunaP** » Tue Nov 29, 2011 6:54 pm

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?

ed85379 · Post by **ed85379** » Tue Nov 29, 2011 7:35 pm

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.

Post by **ericalm** » Tue Nov 29, 2011 8:18 pm

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!

ed85379 · Post by **ed85379** » Tue Nov 29, 2011 8:26 pm

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.

babblefish · Post by **babblefish** » Tue Nov 29, 2011 10:14 pm

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 .

Post by **ericalm** » Wed Nov 30, 2011 6:21 am

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

Support request sent to host. We'll see…

Dooglas · Post by **Dooglas** » Thu Dec 01, 2011 12:06 am

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

)

Post by **ericalm** » Thu Dec 01, 2011 12:44 am

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

Southerner · Post by **Southerner** » Thu Dec 01, 2011 12:50 am

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?

Post by **ericalm** » Thu Dec 01, 2011 12:56 am

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!

Southerner · Post by **Southerner** » Thu Dec 01, 2011 1:01 am

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.

Post by **ericalm** » Thu Dec 01, 2011 1:08 am

That's the one!

Maybe I can dig for the offending line…

teabow1 · Post by **teabow1** » Thu Dec 01, 2011 1:31 am

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

babblefish · Post by **babblefish** » Thu Dec 01, 2011 2:04 am

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

Post by **ericalm** » Thu Dec 01, 2011 4:25 pm

FIXED! I think.

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

Southerner · Post by **Southerner** » Thu Dec 01, 2011 5:39 pm

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!

LunaP · Post by **LunaP** » Thu Dec 01, 2011 5:48 pm

Thank you!!