Error message on posting

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Floyd
Registered User
Posts: 190
Joined: Tue Sep 03, 2013 10:16 am

Error message on posting

Post by 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
Last edited by Mick on Wed Mar 06, 2024 8:52 am, edited 4 times in total.
Reason: Solved.
Entropy is maintenance free.
Floyd
Registered User
Posts: 190
Joined: Tue Sep 03, 2013 10:16 am

Re: Error message on posting

Post by Floyd »

One of our moderators received the following error message.
You do not have the required permissions to view the files attached to this post.
Entropy is maintenance free.
User avatar
SpIdErPiGgY
Registered User
Posts: 311
Joined: Sun May 02, 2021 2:11 pm
Location: Erpe-Mere, Aalst, BE
Name: Andy Dm

Re: Error message on posting

Post by SpIdErPiGgY »

Are your extensions up-to-date? Like: Precise Similar Topics
Image
User avatar
warmweer
Jr. Extension Validator
Posts: 11874
Joined: Fri Jul 04, 2003 6:34 am
Location: somewhere in the space-time continuum

Re: Error message on posting

Post by 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
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 6433
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.

Re: Error message on posting

Post by 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.
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison
Floyd
Registered User
Posts: 190
Joined: Tue Sep 03, 2013 10:16 am

Re: Error message on posting

Post by Floyd »

thecoalman wrote: Fri Feb 23, 2024 1:46 pm 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?
Entropy is maintenance free.
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 6433
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.

Re: Error message on posting

Post by 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.
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison
Floyd
Registered User
Posts: 190
Joined: Tue Sep 03, 2013 10:16 am

Re: Error message on posting

Post by Floyd »

I've discovered that I can make posts to existing topics. I, along with all other members, just can't create new topics.
Last edited by Floyd on Tue Mar 05, 2024 9:50 pm, edited 1 time in total.
Entropy is maintenance free.
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53568
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}

Re: Error message on posting

Post by 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
Registered User
Posts: 190
Joined: Tue Sep 03, 2013 10:16 am

Re: Error message on posting

Post by 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.
Entropy is maintenance free.

Return to “[3.3.x] Support Forum”