Database issue

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

colak · 2022-04-14 09:01:36

Here is (most) of the latest countdown. You use a lot of plugins!!!

zem_contact_reborn-4.0.3.20, – can be replaced with com_connect
zem_contact_lang-4.0.3.6m, – obsolete
arc_social_share-1.3.2m, – can be replaced with some custom tags
adi_contact-0.5m, – can be updated to latest version
aks_header-0.3.6m, – it depends how you use it, if it is to zip content, you can just add an htacces directive
arc_vimeo-1.1.1, – You can do a shortcode for this. Here is a number of them that I did.
aks_article-0.2.9, – native tags can do this now
rah_replace-0.4.2, – It probably can be replaced with native tags
mg_setheader-0.1, – It probably can be replaced with native tags
mdn_count-2.2, – can be replaced with native tag
smd_wrap-0.20, – the latest version probably works
pap_contact_cleaner-0.1, – replace with pap_comconnect
smd_xml-0.4.3, – update to latest version
adi_menu-1.4, – not sure if there is a replacement, but you could achieve this manually with native tags
smd_prognostics-0.30, – latest version
etc_date-0.4.6, – Oleg might be able to update this
arc_redirect-1.2.1, – This version should work
pat_speeder-0.7.5, – latest version works
soo_required_files-0.2.8, – you can possibly achieve this using native tags
rss_admin_db_manager-4.3.1, – latest version
soo_plugin_pref-0.2.3, – note sure
bot_write_tab_customize-0.7.2, – Check – here
sed_default_article_status-0.4.1.12, – this is just lazy:) (EDIT Bloke: there’s a pref for it)
spf_codemirror-1.0, – anyone?
yab_copy_to_new-0.2m, – native
wet_quicklink-0.8.2, – is it really needed?
kuo_robots_editor-0.1, – how often did you use it? FTP does the job.
smd_where_used-0.30m, – update to latest version
arc_meta-1.4.0, – can be achieved with native tags
ied_plugin_composer-1.06, – latest version
rah_sitemap-1.3.0, – native tags
smd_prefalizer-0.30 – Stef?

Last edited by Bloke (2022-04-14 16:11:28)

Bloke · 2022-04-14 16:12:46

Not even sure if smd_prefalizer works any more. I haven’t used it in ages.

jakob · 2022-04-14 20:34:58

colak wrote #333096:

Here is (most) of the latest countdown. You use a lot of plugins!!!

That’s a damn good run-down of what to replace or update, Yiannis!

Filling in some more blanks:

ied_plugin_composer – I’m guessing there’s little need for this now.
I believe adi_menu still works.
spf_codemirror (syntax highlighting of plugin code panel) isn’t mission critical.
soo_plugin_prefs was only needed for soo_required_files.
soo_required_files – could be replaced with native tags as you say, or simply by including the css all together, or alternatively set a variable for particular needs, e.g. videos, lightbox, accordion, audio-player etc. and then check if the variable exists and load the javascript accordingly.
arc_meta: yes, use the trick with <txp:hide process="2"> … your meta tags here … </txp:hide>. The process="2" means process on the second pass, so you can use tags that would normally only be possible in the txp:article(_custom) block further down on the page. You could use this same principle for soo_required_files.

gomedia · 2022-04-14 22:48:34

adi_contact & adi_menu still compatible/supported for TXP 4.8 – upgrade to latest & give me a shout if there’re any issues.

colak · 2022-04-15 04:26:42

gilibaus,
Just to add that the community is here to help you to update your site.

gilibaus · 2022-04-15 10:44:07

colak wrote #333106:

gilibaus,
Just to add that the community is here to help you to update your site.

I know and have been aware of this since I started posting on this forum a few years ago. Support from the community is incredible. Thanks gaekwad, bici, colak, Bloke, jakob and gomedia for your help. Before upgrading the production website, I will keep you up-to-date on how things are going in my local test environment.

And yes, I use a lot of plugins :-)

Textpattern CMS

Textpattern CMS support forum

#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

#16 2022-04-14 09:01:36

Re: Database issue

#17 2022-04-14 16:12:46

Re: Database issue

#18 2022-04-14 20:34:58

Re: Database issue

colak wrote #333096:

#19 2022-04-14 22:48:34

Re: Database issue

#20 2022-04-15 04:26:42

Re: Database issue

#21 2022-04-15 10:44:07

Re: Database issue

colak wrote #333106:

Board footer