[fixed]Posting error, please help

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
User avatar
mrtaz4u
Registered User
Posts: 246
Joined: Mon Nov 11, 2002 4:55 am
Location: new york
Contact:

[fixed]Posting error, please help

Post by mrtaz4u »

i get this error, but the post still goes through.
i am using 2.11.
i have the quick reply hack
attachment hack
gender
temp usergroup
Error in posting

DEBUG MODE

SQL Error : 1196 Warning: Some non-transactional changed tables couldn't be rolled back

UPDATE phpbb_forums SET forum_posts = forum_posts + 1, forum_last_post_id = 34649 WHERE forum_id = 3

Line : 465
File : /home/erotiqpussy/www/forum/includes/functions_post.php
Last edited by mrtaz4u on Wed Jan 19, 2005 11:07 pm, edited 1 time in total.
xy2er
Registered User
Posts: 3
Joined: Wed Jan 19, 2005 8:46 pm

Post by xy2er »

that kind of Database you use?
Have you chance the Table-Types?
xy2er
Registered User
Posts: 3
Joined: Wed Jan 19, 2005 8:46 pm

Post by xy2er »

here is something out of the MySQL-Doc that might help you:

http://dev.mysql.com/doc/mysql/en/Non-t ... ables.html
User avatar
mrtaz4u
Registered User
Posts: 246
Joined: Mon Nov 11, 2002 4:55 am
Location: new york
Contact:

Post by mrtaz4u »

sorry i use mysql and no i havent changed the table types


my table types are all the same " MyISAM"
User avatar
mrtaz4u
Registered User
Posts: 246
Joined: Mon Nov 11, 2002 4:55 am
Location: new york
Contact:

Post by mrtaz4u »

now i am gettin this error on my whole forum
Could not query forums information

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_forums.MYI'. (errno: 145)

SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( phpbb_forums f LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order

Line : 168
File : /home/erotiqpussy/www/forum/index.php
User avatar
mrtaz4u
Registered User
Posts: 246
Joined: Mon Nov 11, 2002 4:55 am
Location: new york
Contact:

Post by mrtaz4u »

i found what i needed to do. was run this

REPAIR TABLE phpbb_forums;
Locked

Return to “2.0.x Support Forum”