Now i tried to upgrade my PHP Version from 7.0.9 to Version 7.3.27. I showed me errors so i searched and found someone mentioning 3.2x will support max PHP v7.2. So now i installed xampp version 7.2.33. Still im facing errors. Since i have 1GB of Database size i use MySQL Dump option to import them.
I use this query for importing my large db using cmd line
to skip import process
Code: Select all
mysql -u username -p database_name < "/path/file.sql"
to view import process
Code: Select all
mysql -u username -p -v database_name < "/path/file.sql"
but still i couldn't get # ~ which initiates the import is complete (even though i'm not worried about it)
Now i could see Errors when replying to the post (i.e creating new post)
The errors are
Code: Select all
SQL ERROR [ mysqli ]
Field 'post_id' doesn't have a default value [1364]
SQL
INSERT INTO phpbb_posts (forum_id, poster_id, icon_id, poster_ip, post_time, post_visibility, enable_bbcode, enable_smilies, enable_magic_url, enable_sig, post_username, post_subject, post_text, post_checksum, post_attachment, bbcode_bitfield, bbcode_uid, post_postcount, post_edit_locked, topic_id) VALUES
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 997
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 196
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/includes/functions_posting.php
LINE: 2000
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/posting.php
LINE: 1504
CALL: submit_post()