Error message on posting

[Floyd]

Support Request Template
What version of phpBB are you using? phpBB 3.3.5
What is your board's URL? https://www.thisisms.com
Who do you host your board with? Conseev
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Please select your answer
Is registration required to reproduce this issue? Yes
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What extensions do you have installed? Advertisement Management, Precise Similar Topics, Recent Topics, Advanced BBCode Box
What styles do you currently have installed? Prosilver, Prosilver Special Edition, Prosilver 2022
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP but not phpBB
What username can be used to view this issue? No answer given
What password can be used to view this issue? No answer given
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? None
Please describe your problem. ThisIsMS Error: Occurred 2.21.2024 when posting to the Drug Pipeline forum. This error started with the Moderators forum about a week ago and now appears to affect all forums.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Code: Select all

SQL ERROR [ mysqli ]

    Duplicate entry '32564' for key 'PRIMARY' [1062]

    SQL

    INSERT INTO phpbb_topics (topic_poster, topic_time, topic_last_view_time, forum_id, icon_id, topic_posts_approved, topic_posts_softdeleted, topic_posts_unapproved, topic_visibility, topic_delete_user, topic_title, topic_first_poster_name, topic_first_poster_colour, topic_type, topic_time_limit, topic_attachment, topic_status) VALUES (1166, 1708541668, 1708541668, 13, 0, 1, 0, 0, 1, 0, 'Phase 2 Trial of Frexilamab', 'NHE', '00AA00', 0, 0, 0, 0)

    BACKTRACE


    FILE: (not given by php)
    LINE: (not given by php)
    CALL: msg_handler()

    FILE: [ROOT]/phpbb/db/driver/driver.php
    LINE: 1023
    CALL: trigger_error()

    FILE: [ROOT]/phpbb/db/driver/mysqli.php
    LINE: 202
    CALL: phpbb\db\driver\driver->sql_error()

    FILE: [ROOT]/phpbb/db/driver/factory.php
    LINE: 345
    CALL: phpbb\db\driver\mysqli->sql_query()

    FILE: [ROOT]/includes/functions_posting.php
    LINE: 1997
    CALL: phpbb\db\driver\factory->sql_query()

    FILE: [ROOT]/posting.php
    LINE: 1549
    CALL: submit_post()

Actions Taken:

Resynchronize statistics
Resynchronize post counts
Resynchronize dotted topics
Purge the cache

Tried resynchronizing the forums with the intent to do them all. I started with the General Discussion forum. The process appeared to get hung up. I let it run for an hour. It kept displaying a scrolling progress bar with the message that it was "Currently resyncing topic range 765/9913."

The resync finally completed.

A test post to the forum failed with a similar error message.

No forums can be posted to.

I tried a different login ID with standard user privileges. The results were the same.

The last post successfully made to the Forums was at 1:07 am on 2.24.2024.

Generated by SRT Generator

[Floyd]

One of our moderators received the following error message.

[SpIdErPiGgY]

Are your extensions up-to-date? Like: Precise Similar Topics

[warmweer]

Your cookie domain is currently www.thisisms.com
Change that to .thisisms.com (note the leading dot).

see Fixing incorrect cookie settings

You may want to try using the unofficial STK (not the official one for 3.0) and let it analyse the board.

For an STK adapted for 3.3 see https://www.phpbb.com/customise/db/offi ... pic/243994 .
However, it's not an official STK so it's a Use at your own risk.
But ... I've used it many times (as have others) and it works as expected/intended.

Just make sure you have a full backup (rule nr 1 anytime) in case something goes wrong

[thecoalman]

The primary key is the the topic ID and it should auto increment but you don't have 32K topics.

Using phpMyadmin open *phpbb_topics table and then click the structure tab. Sort the topic ID ascending so the highest is listed. What's the last topic ID number?

*phpbb_ is default prefix, yours may be different.

[Floyd]

The primary key is the the topic ID and it should auto increment but you don't have 32K topics.

Thanks for the reply.

The ACP indicates that there are 28765 topics.

A recent post had a topic ID of 32561.

https://www.thisisms.com/forum/viewtopic.php?f=1&t=32561&p=263462#p263462

Several posts have been incorrectly assigned the date Dec 31, 1969.

Your post appears to imply that there's a built in limit of topic IDs equal to 32k. Is that correct?

[thecoalman]

There is no limitation on the topic ID's. my mistake it dodn't appear you had that many topics.

Make a backup of your forum and then open the database. Put check next to phpbb_topics and scroll to the bottom of page. Next to with selected choose repair table.

Several posts have been incorrectly assigned the date Dec 31, 1969.

That would be indication of something else wrong. Check your server error logs for errors and you can also see if they have wrong date.

[Floyd]

I've discovered that I can make posts to existing topics. I, along with all other members, just can't create new topics.

[Brf]

Go into phpmyadmin.
click on your phpbb_topics table.
Click the top "Operations" tab.
Scroll down to the "Table Options" section.
At the bottom of that section in the AUTO_INCREMENT box change the number 32564 to the number of your highest numbered topic +1
Click the Go button under that section.

[Floyd]

Thank for the replies. The post topic table had an incorrect counter. Rebuilding the tables fixed the problem and the board is functional once again.