News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Posts exists but are NOT Displayed

Started by deb8, January 26, 2012, 04:36:42 AM

Previous topic - Next topic

deb8

Hi all.

A strange thing occurred to my forum.

Although the posts exists, these are not displayed.
I assumed that the posts exists since when I try to edit one, then inside the editor the code of the posts is displayed properly.

In other words everything seems to be correct except the fact that the  posts cannot be displayed.

Arantor

Do the posts contain any accented letters? Got a link we can look at?


Arantor

I was hoping for a link directly to a topic where it was happening, but never mind.

So, when did this start happening?

deb8

I think it started to happen when i uninstalled SimplePortal but I am not really sure..

The strange thing is that the post do exists.
The display of the posts in view mode has something.

Arantor

QuoteThe strange thing is that the post do exists.
The display of the posts in view mode has something.

Yes, we established this already.

QuoteI think it started to happen when i uninstalled SimplePortal but I am not really sure..

When was it last working?

deb8

I am sure it was last working before I uninstalled SimplePortal.

Arantor

Hrm, not sure why uninstalling SP would cause that to occur.

Do you have access to phpMyAdmin?


Arantor

Then take a look at the database and let me know what collation is being used for the tables, most importantly for smf_messages.

deb8


Arantor

OK, so I'm now a bit confused since that looks like it should be right.

If you use the default theme does it work?


Arantor

OK... if you look at the smf_messages table directly, what are the listed collations for each column?

deb8

1    id_msg    int(10)       UNSIGNED    No    None    AUTO_INCREMENT
2    id_topic    mediumint(8)       UNSIGNED    No    0       
3    id_board    smallint(5)       UNSIGNED    No    0       
4    poster_time    int(10)       UNSIGNED    No    0    
5    id_member    mediumint(8)       UNSIGNED    No    0
6    id_msg_modified    int(10)       UNSIGNED    No    0
7    subject    varchar(255)    utf8_general_ci       
8    poster_name    varchar(255)    utf8_general_ci       No       
9    poster_email    varchar(255)    utf8_general_ci       No          
10    poster_ip    varchar(255)    utf8_general_ci       No          
11    smileys_enabled    tinyint(4)          No    1       
12    modified_time    int(10)       UNSIGNED    No    0       
13    modified_name    varchar(255)    utf8_general_ci       No
14    body    text    utf8_general_ci       No    None    
15    icon    varchar(16)    utf8_general_ci       No    xx       
16    approved    tinyint(3)          No    1       

Arantor

I don't get it. I see absolutely no reason why that shouldn't be working as expected.

Mind you, now SimplePortal is partly installed, partly not installed (and the forum is unavailable as a consequence since it can't find the Portal template) so going further is going to be tricky.

deb8

I can see where it is going..

Therefore I must admit to myself to consider the topic closed and removed.

I will make a full backup from a previous (a lot outdated) version.

Thanks a lot for your patience and help.

Arantor

Try restoring a backup of the *files*. I'm not sure the database is damaged at this point - you can use the 'large upgrade' package to refresh all the files without altering the DB.

deb8

I restored the files.

However a message that notifies for an error in database appears.

Is anything I should to do to find a clue why is this happening?

Arantor

Look in the error log? Without knowing what the database error is, it's impossible to debug

Advertisement: