Forum Error/BUGS!

Discussion of the Genuine Buddy, Hooligan, Black Jack and other topics, both scooter related and not

Moderator: Modern Buddy Staff

Post Reply
User avatar
ericalm
Site Admin
Posts: 16842
Joined: Sat Jun 10, 2006 3:01 am
Location: Los Angeles, CA
Contact:

Forum Error/BUGS!

Post by ericalm »

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.
Eric // LA Scooter Meetup Group // Stella 4T // Vespa LX // Vespa LXS // Honda Helix // some, uh, projects…
User avatar
viney266
Member
Posts: 2270
Joined: Thu May 19, 2011 8:49 pm
Location: westminster md
Contact:

Post by viney266 »

Just got on over lunch. Seems to be working fine for me so far.
Speed is only a matter of money...How fast do you want to go?
teabow1
Member
Posts: 328
Joined: Sat Nov 05, 2011 12:15 pm
Location: Triangle region, NC

Post by teabow1 »

What's not working for me is using the "quote" button to reply.
User avatar
Skootz Kabootz
Member
Posts: 4305
Joined: Sat Nov 15, 2008 12:47 pm
Location: West Hollywood, CA
Contact:

Post by Skootz Kabootz »

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.
Image

"It's only fun if you live to talk about it." | Adventurists Scooter Group |
User avatar
viney266
Member
Posts: 2270
Joined: Thu May 19, 2011 8:49 pm
Location: westminster md
Contact:

Post by viney266 »

^^^ Same here. I just tried to quote what you said and got an error screen.
Speed is only a matter of money...How fast do you want to go?
User avatar
LunaP
Member
Posts: 1152
Joined: Mon Oct 03, 2011 3:17 am
Location: Richmond, VA

Post by LunaP »

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? :P
User avatar
ed85379
Member
Posts: 510
Joined: Thu Apr 15, 2010 10:00 pm
Location: Boston

Post by ed85379 »

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.
Image
User avatar
ericalm
Site Admin
Posts: 16842
Joined: Sat Jun 10, 2006 3:01 am
Location: Los Angeles, CA
Contact:

Post by ericalm »

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!
Eric // LA Scooter Meetup Group // Stella 4T // Vespa LX // Vespa LXS // Honda Helix // some, uh, projects…
User avatar
ed85379
Member
Posts: 510
Joined: Thu Apr 15, 2010 10:00 pm
Location: Boston

Post by ed85379 »

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. :)
Image
User avatar
babblefish
Member
Posts: 3118
Joined: Tue Dec 04, 2007 8:42 am
Location: San Francisco

Post by babblefish »

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 .
Some people can break a crowbar in a sandbox.
User avatar
ericalm
Site Admin
Posts: 16842
Joined: Sat Jun 10, 2006 3:01 am
Location: Los Angeles, CA
Contact:

Post by ericalm »

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

Support request sent to host. We'll see…
Eric // LA Scooter Meetup Group // Stella 4T // Vespa LX // Vespa LXS // Honda Helix // some, uh, projects…
User avatar
Dooglas
Moderator
Posts: 4368
Joined: Sun Jul 08, 2007 2:17 am
Location: Oregon City, OR

Post by Dooglas »

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 :wink: )
User avatar
ericalm
Site Admin
Posts: 16842
Joined: Sat Jun 10, 2006 3:01 am
Location: Los Angeles, CA
Contact:

Post by ericalm »

Nope. One response from support. I replied to that. They're looking at it. I hope.
Eric // LA Scooter Meetup Group // Stella 4T // Vespa LX // Vespa LXS // Honda Helix // some, uh, projects…
Southerner
Member
Posts: 1045
Joined: Mon Aug 15, 2011 11:44 am
Location: Alabama

Post by Southerner »

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?
User avatar
ericalm
Site Admin
Posts: 16842
Joined: Sat Jun 10, 2006 3:01 am
Location: Los Angeles, CA
Contact:

Post by ericalm »

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!
Eric // LA Scooter Meetup Group // Stella 4T // Vespa LX // Vespa LXS // Honda Helix // some, uh, projects…
Southerner
Member
Posts: 1045
Joined: Mon Aug 15, 2011 11:44 am
Location: Alabama

Post by Southerner »

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.
User avatar
ericalm
Site Admin
Posts: 16842
Joined: Sat Jun 10, 2006 3:01 am
Location: Los Angeles, CA
Contact:

Post by ericalm »

That's the one!

Maybe I can dig for the offending line…
Eric // LA Scooter Meetup Group // Stella 4T // Vespa LX // Vespa LXS // Honda Helix // some, uh, projects…
teabow1
Member
Posts: 328
Joined: Sat Nov 05, 2011 12:15 pm
Location: Triangle region, NC

Post by teabow1 »

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
User avatar
babblefish
Member
Posts: 3118
Joined: Tue Dec 04, 2007 8:42 am
Location: San Francisco

Post by babblefish »

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
Some people can break a crowbar in a sandbox.
User avatar
ericalm
Site Admin
Posts: 16842
Joined: Sat Jun 10, 2006 3:01 am
Location: Los Angeles, CA
Contact:

Post by ericalm »

FIXED! I think.

Thanks, all. If the issue pops up again, let me know!
Eric // LA Scooter Meetup Group // Stella 4T // Vespa LX // Vespa LXS // Honda Helix // some, uh, projects…
Southerner
Member
Posts: 1045
Joined: Mon Aug 15, 2011 11:44 am
Location: Alabama

Post by Southerner »

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!
User avatar
LunaP
Member
Posts: 1152
Joined: Mon Oct 03, 2011 3:17 am
Location: Richmond, VA

Post by LunaP »

Thank you!! :)
Post Reply