Page 1 of 1
Posting issues
Posted: Sun Mar 05, 2023 9:51 am
by sixxie
Submitting any reply seems to generate a big error page at the moment. The posts go through though.
Also, I can't actually see Giranda's last post in topic 11061 unless I append &start=2 to offset page 1 of the results. Before I replied, it cut off at the message above and didn't show that there should be a page 2. Now there is a page 2, but it only has my reply!
Edit: &start=9 seems to start with the post in question. I wonder if some post within the first 10 was "deleted", but the page counting doesn't account for that? Clutching at straws, never looked at phpbb.
Re: Posting issues
Posted: Mon Mar 06, 2023 4:58 pm
by jedie
test
EDIT: Replay and edit here, works for me
Re: Posting issues
Posted: Mon Mar 06, 2023 6:34 pm
by sixxie
Test, test.
Edit: submitting that caused the error for me, attaching pic.
- fatal-error.png (141.34 KiB) Viewed 22339 times
Edit to edit: editing this post didn't trigger any error
Re: Posting issues
Posted: Mon Mar 06, 2023 8:22 pm
by robcfg
I had a similar error last week and notified Simon about it:
Fatal error: Uncaught mysqli_sql_exception: Duplicate entry '446-11065' for key 'PRIMARY' in /homepages/21/d97208570/htdocs/HOSTING/Dragon2009/wiki/phpBB3/phpbb/db/driver/mysqli.php:193 Stack trace: #0 /homepages/21/d97208570/htdocs/HOSTING/Dragon2009/wiki/phpBB3/phpbb/db/driver/mysqli.php(193): mysqli_query(Object(mysqli), 'INSERT INTO php...') #1 /homepages/21/d97208570/htdocs/HOSTING/Dragon2009/wiki/phpBB3/phpbb/db/driver/factory.php(345): phpbb\db\driver\mysqli->sql_query('INSERT INTO php...', 0) #2 /homepages/21/d97208570/htdocs/HOSTING/Dragon2009/wiki/phpBB3/includes/functions.php(887): phpbb\db\driver\factory->sql_query('INSERT INTO php...') #3 /homepages/21/d97208570/htdocs/HOSTING/Dragon2009/wiki/phpBB3/includes/functions_posting.php(2318): markread('post', 9, 11065) #4 /homepages/21/d97208570/htdocs/HOSTING/Dragon2009/wiki/phpBB3/posting.php(1504): submit_post('reply', 'Re: Dragon 32 w...', '', 0, Array, Array, true, true) #5 {main} thrown in /homepages/21/d97208570/htdocs/HOSTING/Dragon2009/wiki/phpBB3/phpbb/db/driver/mysqli.php on line 193
Re: Posting issues
Posted: Mon Mar 06, 2023 11:43 pm
by Alastair
sixxie wrote: ↑Sun Mar 05, 2023 9:51 am
Also, I can't actually see Giranda's last post in topic 11061 unless I append &start=2 to offset page 1 of the results. Before I replied, it cut off at the message above and didn't show that there should be a page 2. Now there is a page 2, but it only has my reply!
Edit: &start=9 seems to start with the post in question. I wonder if some post within the first 10 was "deleted", but the page counting doesn't account for that? Clutching at straws, never looked at phpbb.
I see the same problem.
Edit. There were no error messages when I posted the above reply.
Re: Posting issues
Posted: Tue Mar 07, 2023 8:02 am
by jedie
Ah! Maybe it happens only on old posts?
I would like to reply here:
https://archive.worldofdragon.org/phpBB ... =3&t=10883 and i get the error:
Code: Select all
Fatal error: Uncaught mysqli_sql_exception: Duplicate entry '6691-10883' for key 'PRIMARY' in /homepages/21/d97208570/htdocs/HOSTING/Dragon2009/wiki/phpBB3/phpbb/db/driver/mysqli.php:193 Stack trace: #0 /homepages/21/d97208570/htdocs/HOSTING/Dragon2009/wiki/phpBB3/phpbb/db/driver/mysqli.php(193): mysqli_query(Object(mysqli), 'INSERT INTO php...') #1 /homepages/21/d97208570/htdocs/HOSTING/Dragon2009/wiki/phpBB3/phpbb/db/driver/factory.php(345): phpbb\db\driver\mysqli->sql_query('INSERT INTO php...', 0) #2 /homepages/21/d97208570/htdocs/HOSTING/Dragon2009/wiki/phpBB3/includes/functions.php(887): phpbb\db\driver\factory->sql_query('INSERT INTO php...') #3 /homepages/21/d97208570/htdocs/HOSTING/Dragon2009/wiki/phpBB3/includes/functions_posting.php(2318): markread('post', 3, 10883) #4 /homepages/21/d97208570/htdocs/HOSTING/Dragon2009/wiki/phpBB3/posting.php(1504): submit_post('reply', 'Re: Dragon 64 R...', '', 0, Array, Array, true, true) #5 {main} thrown in /homepages/21/d97208570/htdocs/HOSTING/Dragon2009/wiki/phpBB3/phpbb/db/driver/mysqli.php on line 193
Re: Posting issues
Posted: Tue Mar 07, 2023 8:03 am
by jedie
It sounds that the primary key is not unique, maybe because of full table and to low entropy?
Code: Select all
Duplicate entry '6691-10883' for key 'PRIMARY'
Re: Posting issues
Posted: Wed Mar 22, 2023 11:53 pm
by Alastair
I have a different issue. For the last few days whenever I submit a post the post goes through but instead of being redirected back to the thread I get a blank page instead.
Re: Posting issues
Posted: Thu Mar 23, 2023 7:38 am
by robcfg
Yep, I got the same yesterday.
Edit 1:(Today too…)
Edit 2:(But not when editing a post…)
Edit 3:(when you reload the forum after posting, your own post appears as unread.)
Re: Posting issues
Posted: Sun Mar 26, 2023 10:17 am
by admin
All,
I am aware of the issue. Looking back through all the change logs it appears to be a change in the PHP version by the hosts that has caused this issue. Its not a known or documented issue with phpBB but I will schedule an update to phpBB to see if it resolves this... Until then, please continue to suffer !!