XF 2.1 Members cannot post in threads

[Radiola]

I may not explain this well but here goes.

We moved host last week to a new host server. It turns out the DNS name server change did not take. That was fixed but we had posts from only the date of the move, April 16. The forum has been re-imported to the new host and everything posted in the last week is there. All posts and changes are current.

However, now no one (even admins) can post within a thread or start a new thread.

Is there a debug feature that may have gotten turned on or off some time during the move? Is there a "post" button which has been turned off somewhere?

 

[Paul B]

You haven't clarified what errors or messages are displayed when attempting to post, but if no changes were made to the XF settings or permissions then something went wrong with the server move or database dump and restore.

You may want to do it again.

 

[Radiola]

There's no error message. I just type in text, post reply, I see the little lines across the top right corner and nothing's posted.

But the dump and restore is a thought.

 

[Paul B]

I see the little lines across the top right corner and nothing's posted.

Check the browser console for error messages.

Have you confirmed the new server meets the minimum requirements?

 

[Radiola]

There were no new error messages. The last was April 9, too many connections.

Server size is no problem. We don't use cPanel now and the new server sees no problems at all.

 

[Max Taxable]

There were no new error messages

BROWSER CONSOLE.

 

[Radiola]

There no new ones at the time. Now we have several pages of:

• XF\Db\Exception: MySQL statement prepare error [1146]: Table 'antifraud6_xf.xf_thread' doesn't exist
• src/XF/Db/AbstractStatement.php:228
• Generated by: Unknown account
• Apr 24, 2020 at 1:12 PM

Stack trace
SELECT xf_thread., xf_user_User_1., xf_forum_Forum_2., xf_node_Node_3., xf_permission_cache_content_Permissions_4.*
FROM xf_thread
LEFT JOIN xf_user AS xf_user_User_1 ON (xf_user_User_1.user_id = xf_thread.user_id)
LEFT JOIN xf_forum AS xf_forum_Forum_2 ON (xf_forum_Forum_2.node_id = xf_thread.node_id)
LEFT JOIN xf_node AS xf_node_Node_3 ON (xf_node_Node_3.node_id = xf_forum_Forum_2.node_id)
LEFT JOIN xf_permission_cache_content AS xf_permission_cache_content_Permissions_4 ON (xf_permission_cache_content_Permissions_4.content_type = 'node' AND xf_permission_cache_content_Permissions_4.content_id = xf_node_Node_3.node_id AND xf_permission_cache_content_Permissions_4.permission_combination_id = '1')
WHERE (xf_thread.thread_id = '618')


LIMIT 1
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Mvc/Entity/Finder.php(1261): XF\Db\AbstractAdapter->query('
SELECT `xf_...')
#5 src/XF/Mvc/Entity/Manager.php(149): XF\Mvc\Entity\Finder->fetchOne()
#6 src/XF/Pub/Controller/Thread.php(1375): XF\Mvc\Entity\Manager->find('XF:Thread', '618', Array)
#7 src/XF/Pub/Controller/Thread.php(12): XF\Pub\Controller\Thread->assertViewableThread('618', Array)
#8 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(261): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Index', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Thread), NULL)
#10 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Thread), NULL)
#11 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#13 src/XF.php(391): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}
Request state
array(4) {
["url"] => string(64) "/threads/mr-emma-eze-federal-ministry-of-petroleum-resources.618"
["referrer"] => bool(false)
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

 

[Radiola]

Also: https://antifraudintl.org/req.php

And
MySQL
====
[root@host public_html]# mysql -v
Server version: 5.7.27 MySQL Community Server (GPL)

 

[Paul B]

Table 'antifraud6_xf.xf_thread' doesn't exist

xf_thread is a fairly important table.

That suggests the dump or restore (or both) failed in some way.

 

[Radiola]

I think that the path to the DB has been changed. The site looks like it's a copy of the site at the time of the transfer but has no dynamic function. But TY Brogan, that give me a starting point. (I just woke up so my brain is not fully operational as yet,

File health check: All 4,517 checked files are present and correct.

Also get this message in email:

/etc/cron.daily/logrotate:

error: stat of /var/log/exim/processlog failed: No such file or directory

And this is new:

Time: Fri Apr 24 08:41:33 2020 -0400
Error: Failed to detect code [ryo41dpPXdaKkshCXY] in SYSLOG_LOG [/var/log/messages]

SYSLOG may not be running correctly on host.antifraudintl.org

 

[Radiola]

This is a mess.

Oops! We ran into some problems.
Oops! We ran into some problems. Please try again later. More error details may be in the browser console.
---

We're also seeing this in the system logs now:

---
==> /var/log/httpd/domains/antifraudintl.org.error.log <==
[Sat Apr 25 23:10:38.595632 2020] [proxy_fcgi:error] [pid 30320] [client 67.222.0.35:54020] AH01067: Failed to read FastCGI header, referer: https://antifraudintl.org/forums/anything-goes.49/post-thread
[Sat Apr 25 23:10:38.595674 2020] [proxy_fcgi:error] [pid 30320] (104)Connection reset by peer: [client 67.222.0.35:54020] AH01075: Error dispatching request to : , referer: https://antifraudintl.org/forums/anything-goes.49/post-thread

==> /var/log/mysqld.log <==
2020-04-26T03:10:38.595634Z 568 [Note] Aborted connection 568 to db: 'antifraud6_xf' user: 'antifraud6_miyu' host: 'localhost' (Got an error reading communication packets)
---

It seems that something in the site is causing PHP to crash before it can finish the post.

 

[Radiola]

This is the latest error message if that tells you much of anything.

 

[Ozzy47]

That is the inspector tab, click on the console tab.

 

[Radiola]

Sorry Ozzy, this is new to me.

 

[jeb35]

Looks like its a host issue.

 

[Radiola]

Yes, but they keep telling to check with XF.

 

[Radiola]

Oh, here's a new thing that popped up this morning. I sure didn't alter anything.

Check completed on 4,517 files. The files listed below have contents different from those originally downloaded.

If you have edited these files yourself, you may ignore this message, otherwise you should investigate further as this may be evidence of corrupted or altered files.

XenForo

src/XF.php Unexpected contents

 

[Max Taxable]

Yes, but they keep telling to check with XF.

They're typically going to say that, it's a canned reply.

 

[Radiola]

And all too familiar.

 

[Max Taxable]

And all too familiar.

You're not getting any scripted or canned replies here. You're getting replies from experienced people actually trying to help. But you're making it more difficult than it needs to be.