[Solved]After Update from 3.3.3 to 3.3.4

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Alberto70
Registered User
Posts: 22
Joined: Thu Oct 24, 2019 5:57 am

[Solved]After Update from 3.3.3 to 3.3.4

Post by Alberto70 »

Hi together,

I can't post new topics or register new members.
PHP Version: 7.3.28 (tested also with 7.4.19 - same Result)
PHPBB version: 3.3.4
Database Version: 10.0.38-MariaDB-1~xenial - mariadb.org binary distribution


Error:
General Error
SQL ERROR [ mysqli ]

Field 'topic_id' doesn't have a default value [1364]

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 (302, 1627401634, 1627401634, 3, 0, 1, 0, 0, 1, 0, 'test', 'alberto', 'FF6600', 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: 195
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: 1959
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/posting.php
LINE: 1527
CALL: submit_post()
Thank you in advance for your help.

alberto
Last edited by Alberto70 on Tue Jul 27, 2021 6:49 pm, edited 1 time in total.
User avatar
ssl
Registered User
Posts: 1621
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert
Contact:

Re: After Update from 3.3.3 to 3.3.4

Post by ssl »

Hi
what update method did you use?
Sorry for my English ... I do my best!

phpBB: 3.3.11 | PHP: 8.2.16
[Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"
Alberto70
Registered User
Posts: 22
Joined: Thu Oct 24, 2019 5:57 am

Re: After Update from 3.3.3 to 3.3.4

Post by Alberto70 »

ssl wrote: Tue Jul 27, 2021 4:14 pm Hi
what update method did you use?
Hi ssl,

Thank you for your answer.

I tried both method. Full and Automatic. Cache is also clean.
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53401
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: After Update from 3.3.3 to 3.3.4

Post by Brf »

topic_id is an autoincrement column. If you restored your database from backup, it probably lost the autoincrement flags.
User avatar
warmweer
Jr. Extension Validator
Posts: 11242
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: After Update from 3.3.3 to 3.3.4

Post by warmweer »

This isn't the first time this problem is mentioned. However I cannot reproduce it
# Table: phpbb_topics
DROP TABLE IF EXISTS phpbb_topics;
CREATE TABLE `phpbb_topics` (
`topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
etc...
Tested restoring a 3.3.3 database > auto_increment remains set
Tested updating 3.3.3 to 3.3.4 using Full Package > auto_increment remains set
Restored the 3.3.3 and tested using autoupdate > auto_increment remains set
Tested restoring a 3.3.4 > database auto_increment remains set

Using phpMyAdmin (or another database manager): check the table structure and set A_I to checked if it isn't (and save)
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.
Alberto70
Registered User
Posts: 22
Joined: Thu Oct 24, 2019 5:57 am

Re: After Update from 3.3.3 to 3.3.4

Post by Alberto70 »

Brf wrote: Tue Jul 27, 2021 5:19 pm topic_id is an autoincrement column. If you restored your database from backup, it probably lost the autoincrement flags.
Hi brf,

thank you for your answer. Is there a way to rebuild the structure of the database?
Alberto70
Registered User
Posts: 22
Joined: Thu Oct 24, 2019 5:57 am

Re: After Update from 3.3.3 to 3.3.4

Post by Alberto70 »

Ok, I think I found a way.
I installed a resh installation and go now from table to table and adjust every single Table.

Seems to work now.

Thank you all for your time.
Alberto70
Registered User
Posts: 22
Joined: Thu Oct 24, 2019 5:57 am

Re: After Update from 3.3.3 to 3.3.4

Post by Alberto70 »

warmweer wrote: Tue Jul 27, 2021 5:42 pm This isn't the first time this problem is mentioned. However I cannot reproduce it
# Table: phpbb_topics
DROP TABLE IF EXISTS phpbb_topics;
CREATE TABLE `phpbb_topics` (
`topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
etc...
Tested restoring a 3.3.3 database > auto_increment remains set
Tested updating 3.3.3 to 3.3.4 using Full Package > auto_increment remains set
Restored the 3.3.3 and tested using autoupdate > auto_increment remains set
Tested restoring a 3.3.4 > database auto_increment remains set

Using phpMyAdmin (or another database manager): check the table structure and set A_I to checked if it isn't (and save)
Thank you very much warmweer. This took me to the solution.
Alberto70
Registered User
Posts: 22
Joined: Thu Oct 24, 2019 5:57 am

Re: After Update from 3.3.3 to 3.3.4

Post by Alberto70 »

Do I have to mark this as resolved or will it be closed by a mod?
Post Reply

Return to “[3.3.x] Support Forum”