Database issue

gilibaus · 2022-04-12 09:51:37

I use Txp 4.5.7 on a shared hosting (PHP 5.6.40 and MySQL 5.7.30). (I know I know I should have updated Txp a long time ago…). I published last article a couple of days ago with no issue at all. I have been publishing a weekly post for the last 8 years with no issue. Never. Yesterday something changed. I cannot save any new / edited article. The website is slower. The diagnostics tell me that I have 9 corrupted tables in the database:

textpattern: error: Table upgrade required. Please do "REPAIR TABLE...
txp_discuss_ipban: error: Table upgrade required. Please do "REPAIR TABLE...
txp_discuss_nonce: error: Table upgrade required. Please do "REPAIR TABLE...
txp_file: error: Table upgrade required. Please do "REPAIR TABLE...
txp_image: error: Table upgrade required. Please do "REPAIR TABLE...
txp_lang: error: Table upgrade required. Please do "REPAIR TABLE...
txp_link: error: Table upgrade required. Please do "REPAIR TABLE...
txp_log: error: Table upgrade required. Please do "REPAIR TABLE...
txp_users: error: Table upgrade required. Please do "REPAIR TABLE...

When I try to save an article in debug mode, I get this message: https://ibb.co/KVqZGRt

I got in touch with the hosting provider, no issue on their side according to them (really?).

Fortunately I have a database backup from mid-March. I leave it as a last resort as that would require a few hours’ work to bring back the website to the current situation. Any fixes to try before last resort?

Thanks.

Last edited by gilibaus (2022-04-12 09:52:40)

gaekwad · 2022-04-12 10:12:16

If all was well until it wasn’t, that implies something behind the scenes has likely changed – out of your control. Can you visit Diagnostics and post the results here? I don’t recall if 4.5.7 has the option to hide private info, but you can smush out your site details if you like.

At the risk of stating the obvious, you could try a REPAIR on those tables first. Grab a copy of Adminer, upload to your site, take a backup, then try the repair route.

bici · 2022-04-12 17:49:42

“Yesterday something changed. I cannot save any new / edited article. The website is slower.”

Have you checked with the hosting provider to see if any updates on the PHP / MySQL environment were pushed out?
I just visited your website and it seems fairly responsive. and your last article was upated over 1000 days ago

gilibaus · 2022-04-12 20:08:09

gaekwad wrote #333069:

At the risk of stating the obvious, you could try a REPAIR on those tables first.

Sure, I will try a REPAIR and report the results back here. Thanks.

gilibaus · 2022-04-12 20:17:06

bici wrote #333071:

Have you checked with the hosting provider to see if any updates on the PHP / MySQL environment were pushed out? I just visited your website and it seems fairly responsive. and your last article was upated over 1000 days ago.

Yes, I have checked with the hosting provider. They say no updates were pushed out recently. As for the last article, if you go to the PODCAST section you will see that the last episode was published today (but I wrote and scheduled it a couple of days ago).

colak · 2022-04-13 03:40:55

I always have rss_admin_db_manager installed and repair tables, minimum once a week. I’m not sure if any older versions, compatible with your php version, are currently available.

gomedia · 2022-04-13 03:57:01

Is this or this any help? I know you’re not upgrading TXP but the complaint about datetime 000-00-00 00:00:00 smells of MySQL STRICT issues.

gilibaus · 2022-04-13 11:59:30

Ok, I did two things: first, edited textpattern/lib/txplib_db.php following this old suggestion by ruud. Second, I repaired (via rss_admin_db_manager) a few database tables as suggested in Diagnostics section. These two things fixed the issue: now I can create / edit / save articles again. And Diagnostics shows no database warnings anymore. Thanks everyone, your support was critical.

Last edited by gilibaus (2022-04-13 12:03:00)

gaekwad · 2022-04-13 12:39:22

Gentle nudge that your Textpattern site may well drop offline with an error message if the PHP at your server is updated, so consider moving to a newer Textpattern release in the future.

gilibaus · 2022-04-13 13:28:30

gaekwad wrote #333088:

Gentle nudge that your Textpattern site may well drop offline with an error message if the PHP at your server is updated, so consider moving to a newer Textpattern release in the future.

Sure, but that scares me a bit. Current website uses a lot of awesome TXP plugins (maybe some of them have no updated versions) and works really fine for my needs. I am not sure it will be the same once I upload a newer TXP release, unless I put in A LOT of work (which I do not have atm).

gaekwad · 2022-04-13 15:09:08

gilibaus wrote #333089:

Sure, but that scares me a bit. Current website uses a lot of awesome TXP plugins (maybe some of them have no updated versions) and works really fine for my needs. I am not sure it will be the same once I upload a newer TXP release, unless I put in A LOT of work (which I do not have atm).

I get you – trust me, I’ve seen that a lot before. Here’s a relatively low work idea: post your diagnostics here and we can see what plugins you have, whether there are newer releases of them, and whether that makes the job easier with a bit more knowledge. There are plenty of people here who maintain sites with plugins, legacy and maintained, and so it might not be that big a task. Obviously no pressure or obligation, but we can guide / assist with a constructive tone.

Last edited by gaekwad (2022-04-13 15:14:23)

bici · 2022-04-13 15:12:41

backup everything asap and beware that when your hosting services updates MySQL / PHP you may have to do an upgrade.

Do you have the option to do a local installation under MAMP/WAMP and then upgrade local to see what gets broken?

gilibaus · 2022-04-14 06:17:32

gaekwad wrote #333091:

I get you – trust me, I’ve seen that a lot before. Here’s a relatively low work idea: post your diagnostics here and we can see what plugins you have, whether there are newer releases of them, and whether that makes the job easier with a bit more knowledge. There are plenty of people here who maintain sites with plugins, legacy and maintained, and so it might not be that big a task. Obviously no pressure or obligation, but we can guide / assist with a constructive tone.

Thank you, I do appreciate your support. I am going to try an upgrade with a local installation first (TXP 4.8.8 and PHP 7.4) to see what happens, as @bici suggested. In the meanwhile, here is my diagnostics:

Versione di Textpattern: 4.5.7 (r5900)
Ultimo aggiornamento: 2015-06-07 08:40:36/2015-06-07 08:32:55
Radice del documento: /home/mhd/www.[SNIPPED].net/htdocs (/home/mhd-01/www.[SNIPPED].net/htdocs)
$path_to_site: /home/mhd-01/www.[SNIPPED].net/htdocs
Percorso di Textpattern: /home/mhd-01/www.[SNIPPED].net/htdocs/textpattern
Schema URL articolo: title_only
Percorso cartella file temporanei: /home/mhd-01/www.[SNIPPED].net/htdocs/textpattern/tmp
URL del sito: www.[SNIPPED].net
Versione di PHP: 5.6.40-57+0~20211119.60+debian9~1.gbp8a9bd1
GD Graphics Library: 2.2.5; formati supportati: GIF, JPG, PNG.
Server TZ: Europe/Rome
Ora locale server: 2022-04-14 08:05:00
Abilito ora legale?: 1
Aggiorna automaticamente l’ora legale/solare?: 1
Fuso orario (differenza con GTM in secondi): Europe/Rome (3600)
MySQL: 5.7.30
Locale: it_IT.UTF-8
Server: Apache
PHP server API: cgi-fcgi
Header RFC 2616: 0
Sistema operativo server: Linux 4.9.0-17-amd64
Plug-in attivi: zem_contact_reborn-4.0.3.20, zem_contact_lang-4.0.3.6m, arc_social_share-1.3.2m, adi_contact-0.5m, aks_header-0.3.6m, arc_vimeo-1.1.1, aks_article-0.2.9, rah_replace-0.4.2, mg_setheader-0.1, mdn_count-2.2, smd_wrap-0.20, pap_contact_cleaner-0.1, smd_xml-0.4.3, adi_menu-1.4, smd_prognostics-0.30, etc_date-0.4.6, arc_redirect-1.2.1, pat_speeder-0.7.5, soo_required_files-0.2.8, rss_admin_db_manager-4.3.1, soo_plugin_pref-0.2.3, bot_write_tab_customize-0.7.2, sed_default_article_status-0.4.1.12, spf_codemirror-1.0, yab_copy_to_new-0.2m, wet_quicklink-0.8.2, kuo_robots_editor-0.1, smd_where_used-0.30m, arc_meta-1.4.0, ied_plugin_composer-1.06, rah_sitemap-1.3.0, smd_prefalizer-0.30
Tema per l’interfaccia di amministrazione: classic 4.5.7

Controlli preliminari: 
------------------------
Impossibile collegarsi al server RPC. Riprova più tardi.
Alcuni file di Textpattern sono stati modificati: 
	/home/mhd-01/www.[SNIPPED].net/htdocs/textpattern/lib/txplib_db.php
Le seguenti funzioni PHP (che potrebbero essere necessarie per il corretto funzionamento di Textpattern) sono disabilitate sul tuo server: pcntl_alarm, pcntl_fork, pcntl_waitpid, pcntl_wait, pcntl_wifexited, pcntl_wifstopped, pcntl_wifsignaled, pcntl_wifcontinued, pcntl_wexitstatus, pcntl_wtermsig, pcntl_wstopsig, pcntl_signal, pcntl_signal_dispatch, pcntl_get_last_error, pcntl_strerror, pcntl_sigprocmask, pcntl_sigwaitinfo, pcntl_sigtimedwait, pcntl_exec, pcntl_getpriority, pcntl_setpriority, 
------------------------

contenuto del file .htaccess: 
------------------------
#DirectoryIndex index.php index.html

#Options +FollowSymLinks
#Options -Indexes
#ErrorDocument 403 default

RedirectMatch 301 ^/mindfulness-nel-bosco /corsi#natura

<IfModule mod_rewrite.c>
    RewriteEngine On
    RewriteBase /

    RewriteCond %{HTTP:X-Forwarded-Proto} !https
	 RewriteCond %{HTTP_HOST} ^www.
	RewriteCond %{HTTPS} off
	RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301,NE]

    RewriteCond %{REQUEST_FILENAME} -f [OR]
    RewriteCond %{REQUEST_FILENAME} -d
    RewriteRule ^(.+) - [PT,L]

    RewriteCond %{REQUEST_URI} !=/favicon.ico
    RewriteRule ^(.*) index.php

    RewriteCond %{HTTP:Authorization}  !^$
    RewriteRule .* - [E=REMOTE_USER:%{HTTP:Authorization}]

    RewriteCond %{HTTP_REFERER} ^http://.*get-free-social-traffic\.com [NC,OR]
    RewriteCond %{HTTP_REFERER} ^http://.*floating-share-buttons\.com [NC,OR]
    RewriteCond %{HTTP_REFERER} ^http://.*event-tracking\.com [NC,OR]
    RewriteCond %{HTTP_REFERER} ^http://.*Get-Free-Traffic-Now\.com [NC,OR]
    RewriteCond %{HTTP_REFERER} ^http://.*free-floating-buttons\.com
    RewriteRule .* - [F]
</IfModule>

<IfModule mod_deflate.c>
  AddOutputFilterByType DEFLATE text/html
  AddOutputFilterByType DEFLATE text/css
  AddOutputFilterByType DEFLATE text/javascript
  AddOutputFilterByType DEFLATE text/xml
  AddOutputFilterByType DEFLATE text/plain
  AddOutputFilterByType DEFLATE image/x-icon
  AddOutputFilterByType DEFLATE image/svg+xml
  AddOutputFilterByType DEFLATE application/rss+xml
  AddOutputFilterByType DEFLATE application/atom+xml
  AddOutputFilterByType DEFLATE application/javascript
  AddOutputFilterByType DEFLATE application/x-javascript
  AddOutputFilterByType DEFLATE application/xml
  AddOutputFilterByType DEFLATE application/xhtml+xml
  AddOutputFilterByType DEFLATE application/x-font
  AddOutputFilterByType DEFLATE application/x-font-truetype
  AddOutputFilterByType DEFLATE application/x-font-ttf
  AddOutputFilterByType DEFLATE application/x-font-otf
  AddOutputFilterByType DEFLATE application/x-font-opentype
  AddOutputFilterByType DEFLATE application/vnd.ms-fontobject
  AddOutputFilterByType DEFLATE font/ttf
  AddOutputFilterByType DEFLATE font/otf
  AddOutputFilterByType DEFLATE font/opentype

# For Olders Browsers Which Can't Handle Compression
  BrowserMatch ^Mozilla/4 gzip-only-text/html
  BrowserMatch ^Mozilla/4\.0[678] no-gzip
  BrowserMatch \bMSIE !no-gzip !gzip-only-text/html
</IfModule>

<IfModule mod_expires.c>
ExpiresActive On
ExpiresByType image/jpg "access plus 1 month"
ExpiresByType image/svg+xml "access plus 1 month"
ExpiresByType image/jpeg "access plus 1 month"
ExpiresByType image/gif "access plus 1 month"
ExpiresByType image/png "access plus 1 month"
ExpiresByType text/css "access plus 1 month"
ExpiresByType application/pdf "access plus 1 month"
ExpiresByType application/x-javascript "access plus 1 month"
ExpiresByType application/x-shockwave-flash "access plus 1 month"
ExpiresByType image/x-icon "access plus 1 month"
ExpiresDefault "access plus 1 month"
</IfModule>

<IfModule mod_mime.c>
  AddEncoding gzip svgz
</IfModule>

AddType video/ogg .ogv
AddType video/mp4 .mp4
AddType video/mp4 .mov
AddType video/webm .webm
AddType application/rss+xml .xml
AddType application/atom+xml .xml
AddType image/svg+xml svg svgz

#php_value register_globals 0
------------------------

Last edited by gilibaus (2022-04-14 06:18:09)

gilibaus · 2022-04-14 06:19:38

bici wrote #333092:

Do you have the option to do a local installation under MAMP/WAMP and then upgrade local to see what gets broken?

Thank you, that’s what I will do.

gaekwad · 2022-04-14 08:59:17

Extracted:

zem_contact_reborn-4.0.3.20
zem_contact_lang-4.0.3.6m
arc_social_share-1.3.2m
adi_contact-0.5m
aks_header-0.3.6m
arc_vimeo-1.1.1
aks_article-0.2.9
rah_replace-0.4.2
mg_setheader-0.1
mdn_count-2.2
smd_wrap-0.20
pap_contact_cleaner-0.1
smd_xml-0.4.3
adi_menu-1.4
smd_prognostics-0.30
etc_date-0.4.6
arc_redirect-1.2.1
pat_speeder-0.7.5
soo_required_files-0.2.8
rss_admin_db_manager-4.3.1
soo_plugin_pref-0.2.3
bot_write_tab_customize-0.7.2
sed_default_article_status-0.4.1.12
spf_codemirror-1.0
yab_copy_to_new-0.2m
wet_quicklink-0.8.2
kuo_robots_editor-0.1
smd_where_used-0.30m
arc_meta-1.4.0
ied_plugin_composer-1.06
rah_sitemap-1.3.0
smd_prefalizer-0.30

Textpattern CMS

Textpattern CMS support forum

#1 2022-04-12 09:51:37

Database issue

#2 2022-04-12 10:12:16

Re: Database issue

#3 2022-04-12 17:49:42

Re: Database issue

#4 2022-04-12 20:08:09

Re: Database issue

gaekwad wrote #333069:

#5 2022-04-12 20:17:06

Re: Database issue

bici wrote #333071:

#6 2022-04-13 03:40:55

Re: Database issue

#7 2022-04-13 03:57:01

Re: Database issue

#8 2022-04-13 11:59:30

Re: Database issue

#9 2022-04-13 12:39:22

Re: Database issue

#10 2022-04-13 13:28:30

Re: Database issue

gaekwad wrote #333088:

#11 2022-04-13 15:09:08

Re: Database issue

gilibaus wrote #333089:

#12 2022-04-13 15:12:41

Re: Database issue

#13 2022-04-14 06:17:32

Re: Database issue

gaekwad wrote #333091:

#14 2022-04-14 06:19:38

Re: Database issue

bici wrote #333092:

#15 2022-04-14 08:59:17

Re: Database issue

Board footer