SMF 2.0 RC2 Upgrading waiting at log_search_subjects - Step 6: Converting to UTF

Started by Sudhakar Arjunan, April 29, 2020, 09:56:16 AM

Previous topic - Next topic

shawnb61

Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

shawnb61

Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Sudhakar Arjunan

Quote from: shawnb61 on May 03, 2020, 10:20:25 PM
Does your server have mysqli installed?

YES its a dedicated box

Quote from: shawnb61 on May 03, 2020, 11:00:49 PM
Is there an explanation for the 500 error in the apache logs?


here are the apache logs

Quote from: Sudhakar Arjunan on May 03, 2020, 08:53:32 PM
My error log for your reference, cannot delete upgrade.php after step 6 is over.

Stack trace:
#0 /home/website/public_html/community/Sources/ScheduledTasks.php(1071): loadEssentialThemeData()
#1 /home/website/public_html/community/upgrade.php(1739): scheduled_fetchSMfiles()
#2 /home/website/public_html/community/upgrade.php(332): DeleteUpgrade()
#3 {main}
  thrown in /home/website/public_html/community/Sources/ScheduledTasks.php on line 1022
[04-May-2020 06:03:05 Asia/Kolkata] PHP Notice:  Undefined index: htmlspecialchars in /home/website/public_html/community/Sources/ScheduledTasks.php on line 1022
[04-May-2020 06:03:05 Asia/Kolkata] PHP Fatal error:  Function name must be a string in /home/website/public_html/community/Sources/ScheduledTasks.php on line 1022
[04-May-2020 06:04:11 Asia/Kolkata] PHP Notice:  Undefined index: htmlspecialchars in /home/website/public_html/community/Sources/ScheduledTasks.php on line 1022
[04-May-2020 06:04:11 Asia/Kolkata] PHP Fatal error:  Function name must be a string in /home/website/public_html/community/Sources/ScheduledTasks.php on line 1022
[04-May-2020 06:04:49 Asia/Kolkata] PHP Notice:  Undefined index: htmlspecialchars in /home/website/public_html/community/Sources/ScheduledTasks.php on line 1022
[04-May-2020 06:04:49 Asia/Kolkata] PHP Fatal error:  Function name must be a string in /home/website/public_html/community/Sources/ScheduledTasks.php on line 1022


Working on New Mods & Themes for SMF... Will update soon... My Blog page
My Smf forum : Discuss ITAcumens :: My SMF Forum

shawnb61

Can an admin login if the theme is specified, e.g.:
https://blah/blah/index.php?theme=1

Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

shawnb61

What language is used (lngfile on the member record) for the folks that cannot logon?
Are new 2.1 language files present that support the language?
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Sudhakar Arjunan

Quote from: shawnb61 on May 03, 2020, 11:47:08 PM
Can an admin login if the theme is specified, e.g.:
https://blah/blah/index.php?theme=1



admin not logging , site loading, theme showing up only default theme


Quote from: shawnb61 on May 03, 2020, 11:58:12 PM
What language is used (lngfile on the member record) for the folks that cannot logon?
Are new 2.1 language files present that support the language?


yes what doubt is that.
Working on New Mods & Themes for SMF... Will update soon... My Blog page
My Smf forum : Discuss ITAcumens :: My SMF Forum

Sudhakar Arjunan

Dear Team,

Anyone help where am struck on step 7 deleting the upgrade.php file

Step 7: Delete Upgrade.php

click continue - error -

This page isn't working www.forumname.com is currently unable to handle this request.
HTTP ERROR 500

Error Log shows this,

[04-May-2020 04:34:07 Asia/Kolkata] PHP Notice:  Undefined index: htmlspecialchars in /home/website/public_html/community/Sources/ScheduledTasks.php on line 1022
[04-May-2020 04:34:07 Asia/Kolkata] PHP Fatal error:  Function name must be a string in /home/website/public_html/community/Sources/ScheduledTasks.php on line 1022

but forum page is loading with guest access to topics and boards but cannot login to admin account or any account -

Database Error
Please try again. If you come back to this error screen, report the error to an administrator.


Quote from: Sudhakar Arjunan on May 03, 2020, 07:11:07 PM
Dear Team,

Step 6: Convert to UTF-8
Step 7: Delete Upgrade.php

After completing the step 6 by deleting the files log search words and log search subjects.

========Converting to UTF8Please wait while your database is converted to UTF-8. For large forums this may take some time!Completed 222 out of 222 tables.Conversion Complete! Click Continue to Proceed.========

Step 7: Delete Upgrade.php

click continue - error -

This page isn't working www.forumname.com is currently unable to handle this request.
HTTP ERROR 500

Error Log shows this,

[04-May-2020 04:34:07 Asia/Kolkata] PHP Notice:  Undefined index: htmlspecialchars in /home/website/public_html/community/Sources/ScheduledTasks.php on line 1022
[04-May-2020 04:34:07 Asia/Kolkata] PHP Fatal error:  Function name must be a string in /home/website/public_html/community/Sources/ScheduledTasks.php on line 1022

but forum page is loading with guest access to topics and boards but cannot login to admin account or any account -

Database Error
Please try again. If you come back to this error screen, report the error to an administrator.
Working on New Mods & Themes for SMF... Will update soon... My Blog page
My Smf forum : Discuss ITAcumens :: My SMF Forum

Sudhakar Arjunan

Dear Team,

New year wishes everyone, also advance wishes for 2.1.3 update.

Same error in upgrading 2.1.3 large upgrade from current version 2.0 RC 2.

Error in Step 6 : Convert to UTF-8

smf_log_search_subjects   - 13,00,000 rows - 50 mb table size

Guide me, as i have struck for last 20 days with it on maintance mode.

Thanks in Advance.
Working on New Mods & Themes for SMF... Will update soon... My Blog page
My Smf forum : Discuss ITAcumens :: My SMF Forum

Kindred

I thought it should have had a warning to remove the search index before upgrading....
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Sudhakar Arjunan

Hi Kindred,

No warnings, how do i remove search index before upgrading.
My forum is down for 40 days now without this upgrade. Any help is appreciated.
Working on New Mods & Themes for SMF... Will update soon... My Blog page
My Smf forum : Discuss ITAcumens :: My SMF Forum

Steve

DO NOT pm me for support!

Arantor

Then from the same page, select the "remove index" option. It won't go just because you disable it.

Steve

DO NOT pm me for support!

Sir Osis of Liver

Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Sudhakar Arjunan

Thanks for the response.

As Suggested by Kindred ,

Quote from: Kindred on January 20, 2023, 02:55:30 PMI thought it should have had a warning to remove the search index before upgrading....

1) Took backup of smf_log_search_subjects separately
2) Emptied the smf_log_search_subjects table
3) Run the upgrader , completed the upgrade to 2.1.3
4) Could log in to forum after Maintanece mode is disabled
5) Then clicked on search index under maintenance in admin page
6) The search index built on it own.

Forum is live with few errors while replying and opening a post as admin. Just fixing it.

Error 1) - public_html/Sources/Subs-Post.php (Line 1897)

Type of error: Database
Error messageSelect
Database Error: Field 'description' doesn't have a default value


 INSERT INTO smf_messages(`id_board`, `id_topic`, `id_member`, `subject`, `body`, `poster_name`, `poster_email`, `poster_time`, `poster_ip`, `smileys_enabled`, `modified_name`, `icon`, `approved`)
 VALUES
 (79, 160794, 0, SUBSTRING('Re: games', 1, 255), SUBSTRING('wow good to know', 1, 65534), SUBSTRING('nice', 1, 255), SUBSTRING('[email protected]', 1, 255), 1677880696, unhex('ace0e51a'), 1, '', SUBSTRING('xx', 1, 16), 0)

Error 2) - public_html/Sources/Display.php (Line 930)

Type of error: Database
Error messageSelect
Database Error: Field 'lastView' doesn't have a default value


 REPLACE INTO smf_log_topics(`id_member`, `id_topic`, `id_msg`, `unwatched`)
 VALUES
 (1, 192892, 299204, 0)
Working on New Mods & Themes for SMF... Will update soon... My Blog page
My Smf forum : Discuss ITAcumens :: My SMF Forum

Kindred

That error is almost certainly due to an old mod.

Easiest, especially if you plan to re-add the mod,  is to give the database columns a default value  (usually null)
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Sudhakar Arjunan

Quote from: Kindred on March 03, 2023, 08:30:12 PMThat error is almost certainly due to an old mod.

Easiest, especially if you plan to re-add the mod,  is to give the database columns a default value  (usually null)

Thank you but installing mod name is doubt, could I know how to make those two tables null
Working on New Mods & Themes for SMF... Will update soon... My Blog page
My Smf forum : Discuss ITAcumens :: My SMF Forum

Kindred

Use phpmyadmin

ALTER col_name SET DEFAULT NULL;

Or

ALTER TABLE mytbl ALTER col_name SET DEFAULT NULL;

of course, replace mytbl and col_name with your values
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Sudhakar Arjunan

Quote from: Kindred on March 04, 2023, 09:56:33 AMUse phpmyadmin

ALTER col_name SET DEFAULT NULL;

Or

ALTER TABLE mytbl ALTER col_name SET DEFAULT NULL;

of course, replace mytbl and col_name with your values

Excuse for the delay

====

ALTER lastView SET DEFAULT NULL;

Error
Static analysis:

1 errors were found during analysis.

Unrecognized alter operation. (near "" at position 0)
SQL query:

ALTER lastView SET DEFAULT NULL

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lastView SET DEFAULT NULL' at line 1

====

ALTER TABLE smf_log_topics ALTER lastView SET DEFAULT NULL;

Error
SQL query:

ALTER TABLE smf_log_topics ALTER lastView SET DEFAULT NULL
MySQL said: Documentation

#1101 - BLOB, TEXT, GEOMETRY or JSON column 'lastView' can't have a default value
Working on New Mods & Themes for SMF... Will update soon... My Blog page
My Smf forum : Discuss ITAcumens :: My SMF Forum

Sudhakar Arjunan

Same error for other table too

====

ALTER description SET DEFAULT NULL;

Error
Static analysis:

1 errors were found during analysis.

Unrecognized alter operation. (near "" at position 0)
SQL query:

ALTER description SET DEFAULT NULL

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'description SET DEFAULT NULL' at line 1

====

ALTER TABLE smf_messages ALTER description SET DEFAULT NULL;

Error
SQL query:


ALTER TABLE smf_messages ALTER description SET DEFAULT NULL
MySQL said: Documentation

#1101 - BLOB, TEXT, GEOMETRY or JSON column 'description' can't have a default value
Working on New Mods & Themes for SMF... Will update soon... My Blog page
My Smf forum : Discuss ITAcumens :: My SMF Forum

Advertisement: