Notifications
Clear all

[Solved] Lost all topics and Forum posts?!

19 Posts
3 Users
1 Reactions
362 Views
Posts: 10
 TomB
Topic starter
(@tomb)
Active Member
Joined: 6 months ago

Hi at all,

 

we have strange issue at our wpforo plugin.

All topics and posts are lost or not visible. But if i check at wpforo dashboard i can see that (see screenshot)

So i guess at the database is still everything there (?) but its not shown. What can i do?

 

many thanks for ideas

 

edit:

i saw a error message at the database:

i tried to solve the database problem with the button, nothing happened, then i follow the suggestion to insert direct at phpmayadmin

 

this:

SET AUTOCOMMIT = 0;
SET sql_mode='NO_AUTO_VALUE_ON_ZERO';

INSERT INTO `wp_wpforo_boards` (`boardid`, `title`, `slug`, `pageid`, `modules`, `locale`, `is_standalone`, `excld_urls`, `status`, `settings`) VALUES(0, 'mein-tagebuch.de Sardinien', 'sardinien', 339, '{\"tags\":true,\"subscriptions\":true,\"mentioning\":true,\"follows\":true,\"notifications\":true,\"logging\":true,\"seo\":true,\"antispam\":true,\"akismet\":true,\"rss\":true,\"social\":true,\"revisions\":true,\"bookmarks\":true,\"wpforo-user-custom-fields\":true,\"wpforo-topic-custom-fields\":true,\"wpforo-private-messages\":true,\"wpforo-topic-prefix\":true,\"wpforo-advanced-attachments\":true,\"wpforo-embeds\":true,\"wpforo-memberpress\":true,\"wpforo-groups\":true,\"wpforo-suremembers\":true,\"wpforo-paid-membership-pro\":true,\"wpforo-woocommerce-memberships\":true,\"wpforo-mentioning\":true,\"wpforo-voice-posting\":true,\"wpforo-cross-posting\":true,\"wpforo-ad-manager\":true,\"wpforo-polls\":true,\"wpforo-emoticons\":true,\"wpforo-tenor\":true,\"wpforo-giphy\":true,\"wpforo-mycred\":true,\"wpforo-syntax-highlighter\":true}', 'de_DE', 0, '[]', 1, '{\"title\":\"mein-tagebuch.de Sardinien\",\"desc\":\"mein-tagebuch.de Informationsportal\"}');

;SET AUTOCOMMIT = 1;

 

after i get some error issues see second screenshot 

 

 

18 Replies
Robert
Posts: 10587
Admin
(@robert)
Support Team
Joined: 9 years ago

Hi @tomb 

Please install phpMyAdmin plugin or use the same tool in your hosting cPanel to access your database. Then find the wp_wpforo_boards table. Edit the row and set 0 the boardid field for that row.

The go Dashboard > wpForo > Overview admin page, scroll down, find [Delete all caches] button and click it.

 

Tutrix
Posts: 1453
(@tutrix)
Noble Member
Joined: 5 years ago

Hi @tomb 

Duplicate entry 'sardinien'

https://mein-tagebuch.de/ sardinien/
https://mein-tagebuch.de/ forum/ (also Sardinien)

Dashboard > wpForo > Boards

remove the board you don't want
forum or sardinien

Posts: 10
 TomB
Topic starter
(@tomb)
Active Member
Joined: 6 months ago

Hi guys, many thanks for your first replies.

 

But i cant follow you so well. What exactly i have to do?

At pyhpmyadmin i find this wp_wpforo_boards but i cant change here anything, or if i change and save it will change nothing

 

where i have to duplicate the entries? at my wpforo forum overview these forums are missing, see screenshot

 

4 Replies
Tutrix
(@tutrix)
Joined: 5 years ago

Noble Member
Posts: 1453

@tomb 

have you created 2 pages with the wpforo shortcode?

forum and sardinien

 TomB
(@tomb)
Joined: 6 months ago

Active Member
Posts: 10
Tutrix
(@tutrix)
Joined: 5 years ago

Noble Member
Posts: 1453

@tomb 

are you sure

https://mein-tagebuch.de/sardinien/
https://mein-tagebuch.de/forum/

 TomB
(@tomb)
Joined: 6 months ago

Active Member
Posts: 10

@tutrix yes, wpforo doesnt show my forum ...so the forum sardinien e.g. isnt shown , and the only forum i see, it shows that here are 0 topics 0 posts...)

 
i have only this page with the shortcode [wpforo]
 
but as you can see, no topics, no posts here
Tutrix
Posts: 1453
(@tutrix)
Noble Member
Joined: 5 years ago

again

you have 2 pages with your forum

once here as Sardinien

>> https://mein-tagebuch.de/sardinien/

and again here as Forum

>> https://mein-tagebuch.de/forum/

so 2 pages with the wpforo shortcode

remove one of them

10 Replies
 TomB
(@tomb)
Joined: 6 months ago

Active Member
Posts: 10

@tutrix its the same page...

here you see the page sardinien, with the url /forum/

no other page

Tutrix
(@tutrix)
Joined: 5 years ago

Noble Member
Posts: 1453

@tomb 

is_wpforo_url-0 is_wpforo_shortcode_page-1 (forum)

is_wpforo_url-1 is_wpforo_shortcode_page-0 (sardinien)

 

 TomB
(@tomb)
Joined: 6 months ago

Active Member
Posts: 10

@tutrix sorry cant follow, i tried to delete the page with /forum/ url, doesnt work. what can i do ?

i create a new page /forum-sardinien/

with shortcode [wpforo] forum doesnt shown here , but you see the last post of the useer eckart schuster, if i click on the last post:

Seite nicht gefunden – mein-tagebuch.de

page not found

Tutrix
(@tutrix)
Joined: 5 years ago

Noble Member
Posts: 1453

@tomb 

Have you not yet set the board ID to 0, as Robert wrote

you still have = wpf-boardid-1 

 

 TomB
(@tomb)
Joined: 6 months ago

Active Member
Posts: 10

@tutrix Im not sure how to this, as i wrote if if try to change here at phpmyadmin nothing happened or changed...

here are all entries at the wpforo boards at phpmyadmin, but at boardid i cant change anything

Tutrix
(@tutrix)
Joined: 5 years ago

Noble Member
Posts: 1453

@tomb 

I do not know this view on your screenshot
via phpMyAdmin plugin or directly via hosting cPanel phpMyAdmin you can easily edit this

 

 TomB
(@tomb)
Joined: 6 months ago

Active Member
Posts: 10

@tutrix thats the phpmyadmin, i installed now the phpmyadmin plugin, and looks the same!!!

 

 TomB
(@tomb)
Joined: 6 months ago

Active Member
Posts: 10

if i click on change, i see this (screenshot) so where i have to change the id to 0 ???

Tutrix
(@tutrix)
Joined: 5 years ago

Noble Member
Posts: 1453

@tomb 

wp_wpforo_boards table

 

 TomB
(@tomb)
Joined: 6 months ago

Active Member
Posts: 10

maybe i found the solution now. i was able to change the ID now to 0 and it worked...

thanks for your patience and help !