Simple Machines Community Forum

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.

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

here is the link

http://macphalanx.dyndns.org

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

So, when did this start happening?

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.

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?

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

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

Do you have access to phpMyAdmin?

Sure I do

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

   utf8_general_ci

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?

no..

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

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       

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.

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.

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.

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?

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

these are the latest entries in the error log. hope they help

(4739, 1327593778, 0, '83.235.191.63', '?http://macphalanx.dyndns.org/', 'Σφάλμα βάσης δεδομένων: Unknown column ''spb.allowed_groups'' in ''field list''<br /><br />\r<br />      SELECT\r<br />         spb.id_block, spb.label, spb.type, spb.col, spb.row, spb.state,\r<br />         spb.force_view, spb.allowed_groups, spb.permission_type, spb.display,\r<br />         spb.display_custom, spb.style, spp.variable, spp.value\r<br />      FROM smf_sp_blocks AS spb\r<br />         LEFT JOIN smf_sp_parameters AS spp ON (spp.id_block = spb.id_block)\r<br />      WHERE spb.state = 1\r<br />      ORDER BY spb.col, spb.row', '12dc7aa42b7c80aafb7b4bd1d64d004a', 'database', '/users/deb8/www/macphalanx/Sources/Subs-Portal.php', 346),
(4740, 1327593778, 0, '83.235.191.63', '?http://macphalanx.dyndns.org/', '8: Undefined index: sitemap', '12dc7aa42b7c80aafb7b4bd1d64d004a', 'undefined_vars', '/users/deb8/www/macphalanx/Themes/default/Errors.template.php (body_below sub template - eval?)', 280);