<% ONLINE %>
Sly
Admin
6184
June 2002
|
 |
April 11 2003,14:58 |
|
There seems to be a problem with SQL 4 thats causing major instability with boards and the tables keep getting 'locked up' resulting in errors.
To identify this, you will get an error like:
| Quote |
mySQL error
Can't query the data: Can't open file: 'ikb_forum_topics.MYI'. (errno: 145)
This error was reported at: Sources/Search/API/api_mySQL.pm line 54.
|
or:
| Quote |
Can't call method "fetchrow_hashref" on an undefined value
|
and when you view the database 'Structure' tab in phpMyAdmin you see that each row normally looks like:
 {this.width = (this.width/2)}" onclick="javascript:if(this.width > (screen.width/2 {this.width = (this.width*0.5)} else {this.width = (this.width*2)}" border="0" alt='Posted image: Click to resize'>
but the row thats giving the error will look like:
 {this.width = (this.width/2)}" onclick="javascript:if(this.width > (screen.width/2{this.width = (this.width*0.5)} else {this.width = (this.width*2)}" border="0" alt='Posted image: Click to resize'>
(it will have in use in the last 3 columns)
The way to fix it is in the Structure menu in phpMyAdmin, tick the affected table (the one thats marked as "in use") and then at the bottom select Repair Table as shown in the image below (the 3 steps to fixing the error):
------
The 3 steps:
1) Identify the table thats giving the error
2) Tick the box corresponding to that table
3) click 'Repair Table' to fix the problem
------
 {this.width = (this.width/2)}" onclick="javascript:if(this.width > (screen.width/2{this.width = (this.width*0.5)} else {this.width = (this.width*2)}" border="0" alt='Posted image: Click to resize'>
your board should then be fixed.
[ iB Supported home ]
... END OF LINE
|
| Back to top |
|
|
Sly
Admin
6184
June 2002
|
|
April 12 2003,13:30 |
|
For the Active sessions problem, I have changed my SQL schema to see if it fixes it. I will post the changes if it seems stable here and on another board that was also having huge problems.
[ iB Supported home ]
... END OF LINE
|
| Back to top |
|
|
deciever
Member
62
Dec. 2002
|
|
April 24 2003,04:32 |
|
oo i got a new error today..
| Code Sample | --------------------------------------------------------------------------------
Ikonboard has exited with the following error:
Can't query the data from 'forum_info' Reason: Got error 127 from table handler Query: SELECT * FROM ib_forum_info ORDER BY FORUM_POSITION ASC
This error was reported at: Sources/iDatabase/Driver/mySQL.pm line 269.
Please note that your 'real' paths have been removed to protect your information. |
|
| Back to top |
|
|
Sly
Admin
6184
June 2002
|
|
April 24 2003,13:43 |
|
Yep thats the same problem but a different table. I have so far had this problem with:
member_profiles
forum_topics
active_sessions
message_data
At first I thought it was related to how often a table was accessed but that does not seem to be the case. It seems to be a mismatch between SQL 4 ans perl or something and I have even heard of one host who downgraded their servers from SQL4 back to SQL3 because of the problems. 
[ iB Supported home ]
... END OF LINE
|
| Back to top |
|
|
deciever
Member
62
Dec. 2002
|
|
April 24 2003,16:57 |
|
The weird thing that happened with mine is that when i repaired the table. One of the forums info was lost. So all of a sudden i was missing a forum with 2700 posts  ... Thank god i had backed up just earlier that day so i had the forum info for the forum that got deleted. and all i did was just create a new row in the table, and inserted the data and luckily it worked
|
| Back to top |
|
|
Sly
Admin
6184
June 2002
|
|
April 24 2003,17:56 |
|
Hmm thats odd, it must have been writing to the table when it got corrupted
[ iB Supported home ]
... END OF LINE
|
| Back to top |
|
|
deciever
Member
62
Dec. 2002
|
|
April 24 2003,17:58 |
|
Thats what i was thinking.. but it really pissed me off, and i was up til like 2 in the monring trying to figure out what happened
|
| Back to top |
|
|
Sly
Admin
6184
June 2002
|
|
April 24 2003,20:18 |
|
I know all about that! I lost my attachments table (a small mistake on my part  ) and had to restore that, and that was a pain!
[ iB Supported home ]
... END OF LINE
|
| Back to top |
|
|
deciever
Member
62
Dec. 2002
|
|
April 24 2003,20:20 |
|
It can be so much work sometime..especially when people like me who have no experiance with SQL oranything try to fix it. Such a pain!
|
| Back to top |
|
|
Sly
Admin
6184
June 2002
|
|
April 25 2003,02:04 |
|
I know what you mean. I do not have a large amount of knowledge, only what I have picked up playing with my board here really and the problems I have had ... 
[ iB Supported home ]
... END OF LINE
|
| Back to top |
|
|
psycho
Member
20
Dec. 2002
|
|
April 27 2003,03:54 |
|
Sly, have you came across this error yet?:
| Quote | Can't count data from 'ib_member_profiles' table. You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''
This error was reported at: line 1 using query: MEMBER_JOINED < |
That error is occuring in one of My forums, but yet only on one of the topics.
|
| Back to top |
|
|
Sly
Admin
6184
June 2002
|
|
April 27 2003,20:59 |
|
Yep, you just have to go into phpMyAdmin anf fix the member profiles table
[ iB Supported home ]
... END OF LINE
|
| Back to top |
|
|
psycho
Member
20
Dec. 2002
|
|
April 28 2003,02:32 |
|
What exactly needs to be done to the member profiles table?
|
| Back to top |
|
|
psycho
Member
20
Dec. 2002
|
|
April 28 2003,13:51 |
|
So in other words, all finger pointing is now going to CPANEL? From what I read on the forum-forum.com page CPANEL is basically draging their feet on this issue, and not giving much support to their members. It's funny how you & Camil can come up with temporary fixes here and there, but yet CPANEL has lacked the ability to provide a patch to cure the problem.  {this.width = (this.width/2)}" onclick="javascript:if(this.width > (screen.width/2{this.width = (this.width*0.5)} else {this.width = (this.width*2)}" border="0" alt='Posted image: Click to resize'>
|
| Back to top |
|
|
Zain
iSupport
iBOTM Leader
230
April 2003
|
|
April 28 2003,16:52 |
|
| Quote (psycho @ April 28 2003,08:51) | | So in other words, all finger pointing is now going to CPANEL? From what I read on the forum-forum.com page CPANEL is basically draging their feet on this issue, and not giving much support to their members. It's funny how you & Camil can come up with temporary fixes here and there, but yet CPANEL has lacked the ability to provide a patch to cure the problem. {this.width = (this.width/2)}" onclick="javascript:if(this.width > (screen.width/2{this.width = (this.width*0.5)} else {this.width = (this.width*2)}" border="0" alt='Posted image: Click to resize'> |
Sorry for posting this stupid message in the wrong topic but your pissed off smiley is AWESOME AND I MEAN AWESOME.
Zain
|
| Back to top |
|
|
psycho
Member
20
Dec. 2002
|
|
April 30 2003,02:00 |
|
I wonder if rebuilding the Apache configuration through CPanel is the salution? {this.width = (this.width/2)}" onclick="javascript:if(this.width > (screen.width/2{this.width = (this.width*0.5)} else {this.width = (this.width*2)}" border="0" alt='Posted image: Click to resize'>
Sly, have you had any success with this rebuilding of Apache?
|
| Back to top |
|
|
Sly
Admin
6184
June 2002
|
|
April 30 2003,11:42 |
|
Well the problems seem to have stopped here and I think they have done something to the server. I think that it may be the answer to force Apache to use the correct SQL drivers
[ iB Supported home ]
... END OF LINE
|
| Back to top |
|
|
|
|
