Hi All,
I have a problem,
that in one thread only a blank white page comes up
with no content.
Look at it yourself.
Go to:
http://www.overunity.com/index.php?topic=3354.180
and then try to click page 14.
http://www.overunity.com/index.php?topic=3354.195
Then only a blank page comes up !
If you click onto page 15,
then you can see again the newer postings in this thread.
In the last days there was some corruption inside my
MySQL database and I needed to fix it via PHPMyAdmin
Repair tables commands.
So far all other things works great with this SMF 1.1.4 and TP 0.983
setup, but just this page
comes up blank.
Maybe someone posted in this thread some corrupted attachments
or something simular ?
How can I find this out ?
Can I try to correct it in PHPMyAdmin ?
How can I find this page via PHPMYAdmin in the SQL database and
see what was posted there ?
I had disabled the error log in my forum to save database accesses bandwidth,
so I can not look anything up inside the error log.
Also the maintainance function in SMF admin area shows no errors,
so how can I resolve this blank page problem ?
Many thanks.
Regards, Stefan.
Hi Stefan,
Not sure of your level with PHPMyAdmin but I assume you can:
-select & expand your databse
-click on "smf_messages" table and then Browse
I am not sure of how to execute exact sql to find that message but you can try narrowing it down by username.
-Click on SQL link.tab on top and paste this code adjusted to suspected user
SELECT * FROM `smf_messages` WHERE posterName=UserNameThatPosted
Perhaps someone here can give better/direct sql to hit that message..if not post more details in which board (board ID) it is posted to so you narrow the search down.
I suspect you can delete that one message if it is not too much of a lost.
...hmm best I could think of...never really messed with the database directly.
All the best!
Hartiberlin, please seek help with your forum problem at simplemachines.org. We can only support so much here, and doing SMF support is beyond what we are trying to keep up on. Thanks.
Also make sure you actually HAVE a page 14 article added.
If you remove an article and that one had page 14 , that page have been used and will not be reused by tp.
If you are SURE you HAVE a page 14 article, make sure the content in it is correct, php code needs to have a php article etc etc.
Looking at the links "topic=3354.195" I am fairly sure he didnt mean a TP Article, more like page 15 of a thread.
So it's not connected even a little bit with TP. :)
Quote from: Hairy on November 01, 2007, 09:07:42 AM
Looking at the links "topic=3354.195" I am fairly sure he didnt mean a TP Article, more like page 15 of a thread.
So it's not connected even a little bit with TP. :)
That is right,
I meant page 14 of a thread in my forum.
Not Tinyportal related, but I did not find any help yet at simplemachines.org
yet.
So as here are also the power users, I thought it would help to ask
over here for help.
Hmm,
I just had again errors in my
www.overunity.com
forum
and I have now looked with PHPMyAdmin .
I marked all tables and then gave the command:
Check tables.
Then it gave me the error listing:
Problems with indexes of table `smf_messages`
UNIQUE and INDEX keys should not both be set for column `ID_TOPIC`
UNIQUE and INDEX keys should not both be set for column `ID_MEMBER`
More than one INDEX key was created for column `ID_MEMBER`
So, then I repaired it with Rapair tables,
but after a short while I see again these errors...
So what can I do now ?
Many thanks.
P.S: I could not access the admin area in my forum before this problem
was not repaired in database, so it seems to be a urgent problem.
Regards, Stefan.
Hmm,
what is this OVERHEAD
listing in the PHPMyAdmin listing ?
For the table smf_sessions I always get some Overhead
also after the repair function.
Is this normal ?
See here:
smf_sessions Browse Structure Search Insert Empty Drop 622 MyISAM 4.6 MiB 3.7 KiB
The last value: 3.7 KiBis the Overhead value.
Many thanks.
Regards, Stefan.
QuoteProblems with indexes of table `smf_messages`
UNIQUE and INDEX keys should not both be set for column `ID_TOPIC`
UNIQUE and INDEX keys should not both be set for column `ID_MEMBER`
More than one INDEX key was created for column `ID_MEMBER`
I get this but it doesn't cause any issues
Quote
So, then I repaired it with Rapair tables,
but after a short while I see again these errors...
Aghhhh I hope you backed up your tables before doing this....since there was no need to do so.
"smf_sessions"
I am not sure but this may be the reason why u could not login...generally speaking "sessions" can be deleted or destroyed as they are created on user logins or hold some temp value for longer period of time...Don't quote me on this when it comes to SMF, I don't know thats why isaid 'generally'....
I would not mess with this on 'live server' and users logged in and adding records so put it in maintenance mode until u get this fixed!
Why are you reparing tables and all that before trying to focus on one post that may be corrupted? PHPMyAdmin is like doing open heart surgery on your fourms...you can just poke at it and see what happens.
Sorry man, best advise I can give u is
1. BACKUP
2. put your forum in maintenance mode utill you get ALL of it fixed.
3. Don't panic and mess arround in sql admin unless u know what ur doing.
4. You may have to purchase support from SMF so check out http://www.simplemachines.org/charter/ their charter plan
Good luck!