Damaged site - Recover content Topic is solved

[dhbrown44]

I know basic web design, no web dev experience. I know of Joomla, but not working knowledge of it.

A new client asked me to recover her site. I downloaded (ftp) the entire site to my local machine. I installed Xampp and tried to run the site, but the following error comes up:
Fatal error: Uncaught Error: Call to undefined function set_magic_quotes_runtime() in C:\xampp\htdocs\current\includes\framework.php:20 Stack trace: #0 C:\xampp\htdocs\current\index.php(22): require_once() #1 {main} thrown in C:\xampp\htdocs\current\includes\framework.php on line 20

I tried "downgrading" the php version, but then there are even more errors. I have tried using script to removed the "magic-quotes", but that didn't work either.

I am a joke of a newbie - but trying desperately to recover the content of the site.

[Per Yngve Berg]

Remember that magic quote was an Option that have to be off in php.ini in the version 5.3 of php.

[AMurray]

This is a web server issue not a web design problem.

Did this trouble only start when you restored the site to your localhost (i.e. XAMPP)?

You say you downloaded the files by FTP but did you import the site's database from the live server?

Create the database (in XAmPP) and export the datbase (from the live site) and import it into the local (XAMPP) site via PHPMyAdmin.

I would possibly start over and refer to https://docs.joomla.org/Copying_a_Joomla_website for details of how to successfully copy or transfer a website from one server to another.

The easiest way to turn off magic quotes as already mentioned by @per, is to edit the php.ini (a text file, you can browse to it through Windows Explorer and open it in a text editor), it should be in the folder where the site is under the XAMPP folder). Refer to https://docs.joomla.org/J3.x:How_to_tur ... quotes_gpc for further information.

[Webdongle]

Would suggest Wamp is better for virtual Host than xampp

More history of the site is needed e.g. what the site needs recovering from.

[dhbrown44]

Oh my gosh. I am in deeper than I thought. I have read all the suggestions, but I am now even more in the dark than before.
Thank you for the support.

[Webdongle]

Start at the beginning and take one step at a time.
History as to why your client wants the site recovered

[dhbrown44]

Client said that her site stopped working properly. Only showed an error code.
I imported the db into phpMyAdmin with MAMP, disabled the Magic script with MAMP... and now the page is completely blank

[dhbrown44]

I opened the db to try read the contents. oh boy!

[abernyte]

Okay, that blank page is likely a php error, we now need to know what the error is. In the root of the site there is a file called configuration.php.
Open it and find the line like this:

Code: Select all

public $error_reporting = 'none';

Change the none to maximum and save and exit and try to access the site and see if we get the error.

What php version are you running in MAMP? This sounds like it is going to be a very old version of Joomla so it has to be nothing higher than php 5.6

[dhbrown44]

Okay, that blank page is likely a php error, we now need to know what the error is. In the root of the site there is a file called configuration.php.
Open it and find the line like this:

Code: Select all

public $error_reporting = 'none';

Change the none to maximum and save and exit and try to access the site and see if we get the error.

What php version are you running in MAMP? This sounds like it is going to be a very old version of Joomla so it has to be nothing higher than php 5.6

I located the configuration file in the root and changed the line as requested var $error_reporting = 'maximum'; - still blank page.

I am running 7.4.1 on MAMP.

[Webdongle]

OK so you have a mac, forget my post about Wamp as that is for PC's
On the server where the site is not working you should be able to change the php version to php5.6
Once you have done that you can run the fpa and post the results
Then make a backup with Akeeba (simple operation when you use the correct version)

Don't panic, one step at a time change the php version on the server first.

[dhbrown44]

OK so you have a mac, forget my post about Wamp as that is for PC's
On the server where the site is not working you should be able to change the php version to php5.6
Once you have done that you can run the fpa and post the results
Then make a backup with Akeeba (simple operation when you use the correct version)

Don't panic, one step at a time change the php version on the server first.

I am using MAMP on Windows 10. Client asked me to remove the old site completely, so I could upload an "under construction" page, so I downloaded the entire site, exported the db and imported into the localhost via phpMyAdmin on MAMP.

[Webdongle]

Mamp is difficult to change php version. Wamp changes it on the fly. On windows you need Wamp to do what you need to do.

[abernyte]

If MAMP is all you have then MAMP it is. Are you sure that you have connected the site files and the database?
You said that you managed to find configuration.php. Did you ensure that the database name and password and user in that file match what is the database name and password and user in the DB that you made?
When you are in configuration.php ensure that

Code: Select all

public $sef_rewrite = '0';

is set as shown.
I am pretty sure this site won't run on php7.4.x but you will have to deal with that later.

[Webdongle]

...
I am pretty sure this site won't run on php7.4.x but you will have to deal with that later.

No he will need to deal with that first. Either edit the mamp files then re edit them later or install Wamp and change the php version on the fly.

[dhbrown44]

...
I am pretty sure this site won't run on php7.4.x but you will have to deal with that later.

No he will need to deal with that first. Either edit the mamp files then re edit them later or install Wamp and change the php version on the fly.

Right, I have uninstalled xampp and mamp. installed wamp, imported the db and changed the php to 5.6.40. The result now is an insane amount of errors. https://www.pixbox.co.za/help

[Webdongle]

Great that is a result.
If you can get to /administrator the in global config change error reporting
Otherwise
Click the wamp icon in your windows tray
Hover over php
click php.ini
Search for error_reporting
Change the (uncommented) error_reporting = E_ALL to error_reporting = OFF

Also please
https://forumpostassistant.github.io/docs/

[dhbrown44]

Great that is a result.
If you can get to /administrator the in global config change error reporting
Otherwise
Click the wamp icon in your windows tray
Hover over php
click php.ini
Search for error_reporting
Change the (uncommented) error_reporting = E_ALL to error_reporting = OFF

Also please
https://forumpostassistant.github.io/docs/

[23-Jul-2021 15:00:46 UTC] PHP 5. JTable->getInstance() C:\wamp64\www\current\libraries\joomla\session\storage\database.php:89

Joomla! Instance :: Joomla! 1.5.15-Stable (Wojmamni Ama Mamni) 05-November-2009
Joomla! Configured :: Yes | Writable (666) |
Configuration Options :: Offline: false | SEF: false | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: No | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: N/A | FTP Layer: false | Proxy: N/A | LiveSite: | Session lifetime: 25 | Session handler: database | Shared sessions: N/A | SSL: 0 | Error Reporting: -1 | Site Debug: false | Language Debug: false | Default Access: N/A | Unicode Slugs: N/A | dbConnection Type: mysql | PHP Supports J! 1.5.15: No | Database Supports J! 1.5.15: Maybe | Database Credentials Present: Yes |

Host Configuration :: OS: Windows NT | OS Version: 10.0 | Technology: AMD64 | Web Server: Apache/2.4.46 (Win64) PHP/5.6.40 | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 359.18 GiB |

PHP Configuration :: Version: 5.6.40 | PHP API: apache2handler | Session Path Writable: Yes | Display Errors: 1 | Error Reporting: 32767 | Log Errors To: c:/wamp64/logs/php_error.log | Last Known Error: 23rd July 2021 15:00:46. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 2M | Max. POST Size: 8M | Max. Input Time: 60 | Max. Execution Time: 120 | Memory Limit: 128M

Database Configuration :: Version: 5.5.5-10.4.20-MariaDB-1:10.4.20+maria~stretch (Client:mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $) | Database Size: 53.92 MiB | #of Tables with config prefix:  64 | #of other Tables:  0 | User Privileges : GRANT SELECTUser Privileges : INSERTUser Privileges : UPDATEUser Privileges : DELETEUser Privileges : CREATEUser Privileges : DROPUser Privileges : REFERENCESUser Privileges : INDEXUser Privileges : ALTERUser Privileges : CREATE TEMPORARY TABLESUser Privileges : LOCK TABLESUser Privileges : EXECUTEUser Privileges : CREATE VIEWUser Privileges : SHOW VIEWUser Privileges : CREATE ROUTINEUser Privileges : ALTER ROUTINE ON `italiaxp\_db`.* TO `italiaxp`@`%`

PHP Extensions :: Core (5.6.40) | bcmath () | calendar () | ctype () | date (5.6.40) | ereg () | filter (0.11.0) | ftp () | hash (1.0) | iconv () | json (1.2.1) | mcrypt () | SPL (0.2) | odbc (1.0) | pcre () | Reflection ($Id: 5f15287237d5f78d75b19c26915aa7bd83dee8b8 $) | session () | standard (5.6.40) | mysqlnd (mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $) | tokenizer (0.1) | zip (1.12.5) | zlib (2.0) | libxml () | dom (20031129) | PDO (1.0.4dev) | bz2 () | SimpleXML (0.1) | wddx () | xml () | xmlreader (0.1) | xmlwriter (0.1) | apache2handler () | openssl () | curl () | com_dotnet (0.1) | fileinfo (1.0.5) | gd () | gettext () | gmp () | intl (1.1.0) | imap () | ldap () | mbstring () | exif (1.4 $Id: cad29b729548e4206f0697710cc9e177f26fdff3 $) | mysql (1.0) | mysqli (0.1) | Phar (2.0.2) | pdo_mysql (1.0.2) | pdo_sqlite (1.0.1) | soap () | sockets () | sqlite3 (0.7-dev) | xmlrpc (0.51) | xsl (0.1) | mhash () | Zend OPcache (7.0.6-devFE) | xdebug (2.5.5) | Zend Engine (2.6.0) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: No | Server SU: No | PHP SU: No | Potential Ownership Issues: No

Apache Modules :: core | mod_win32 | mpm_winnt | http_core | mod_so | mod_access_compat | mod_actions | mod_alias | mod_allowmethods | mod_asis | mod_auth_basic | mod_auth_digest | mod_authn_core | mod_authn_file | mod_authz_core | mod_authz_groupfile | mod_authz_host | mod_authz_user | mod_autoindex | mod_cache | mod_cache_disk | mod_cgi | mod_dir | mod_env | mod_file_cache | mod_include | mod_isapi | mod_log_config | mod_mime | mod_negotiation | mod_rewrite | mod_setenvif | mod_userdir | mod_vhost_alias | mod_php5 | Apache/2.4.46 (Win64) PHP/5.6.40 |
Potential Missing Modules :: mod_expires | mod_deflate | mod_security | mod_evasive | mod_dosevasive | mod_ssl | mod_qos |

Core Folders :: images/ (777) | components/ (777) | modules/ (777) | plugins/ (777) | language/ (777) | templates/ (777) | cache/ (777) | logs/ (777) | tmp/ (777) | administrator/components/ (777) | administrator/modules/ (777) | administrator/language/ (777) | administrator/templates/ (777) | administrator/logs/ (---) |

Elevated Permissions (First 10) :: administrator/ (777) | administrator/backups/ (777) | administrator/cache/ (777) | administrator/components/ (777) | administrator/components/com_admin/ (777) | administrator/components/com_admin/tmpl/ (777) | administrator/components/com_aicontactsafe/ (777) | administrator/components/com_aicontactsafe/controllers/ (777) | administrator/components/com_aicontactsafe/images/ (777) | administrator/components/com_aicontactsafe/includes/ (777) |

Database statistics :: Uptime: 207894 | Threads: 30 | Questions: 29263038 | Slow queries: 249 | Opens: 437394 | Flush tables: 1 | Open tables: 2000 | Queries per second avg: 140.759 |

Components :: Site ::
Core :: MailTo (1.5.0) ? | User (1.5.0) ? | Wrapper (1.5.0) ? |
3rd Party::

Components :: Admin ::
Core :: Banners (1.5.0) ? | Cache Manager (1.5.0) ? | Configuration Manager (1.5.0) ? | Contact Items (1.0.0) ? | Content Page (1.5.0) ? | Control Panel (1.5.0) ? | Frontpage (1.5.0) ? | Installation Manager (1.5.0) ? | Language Manager (1.5.0) ? | Mass Mail (1.5.0) ? | Media Manager (1.5.0) ? | Menus Manager (1.5.0) ? | Messaging (1.5.0) ? | Module Manager (1.5.0) ? | Newsfeeds (1.5.0) ? | Plugin Manager (1.5.0) ? | Polls (1.5.0) ? | Search (1.5.0) ? | Template Manager (1.5.0) ? | Trash (1.0.0) ? | User Manager (1.5.0) ? | Weblinks (1.5.0) ? |
3rd Party:: aiContactSafe (2.0.8.stable) ? | aiContactSafe (1.0.0) ? | aiContactSafe module (1.0.7.stable) ? | aiContactSafe - Form (1.0.8.stable) ? | aiContactSafe - Link (1.0.4.stable) ? | eXtplorer (2.0.1) ? | JoomlaStats (3.0.3) ? |

Modules :: Site ::
Core :: Archived Content (1.5.0) ? | Banner (1.5.0) ? | Breadcrumbs (1.5.0) ? | Custom HTML (1.5.0) ? | Feed Display (1.5.0) ? | Footer (1.5.0) ? | Latest News (1.5.0) ? | Login (1.5.0) ? | Menu (1.5.0) ? | Most Read Content (1.5.0) ? | Newsflash (1.5.0) ? | Poll (1.5.0) ? | Random Image (1.5.0) ? | Related Items (1.0.0) ? | Search (1.0.0) ? | Sections (1.5.0) ? | Statistics (1.5.0) ? | Syndicate (1.5.0) ? | Who\'s Online (1.0.0) ? | Wrapper (1.0.0) ? |
3rd Party:: djcategories (1.1) ? | djcatmaincat (1.1) ? | djcatproducers (1.1) ? | djfrontpage (1.1) ? | Simple Image Rotator (1.2) ? | JB MicroBlog (1.3.3) ? | JB Slideshow v3.2 (3.2.3) ? |

Modules :: Admin ::
Core :: Custom HTML (1.5.0) ? | Feed Display (1.5.0) ? | Footer (1.0.0) ? | Latest News (1.0.0) ? | Logged in Users (1.0.0) ? | Login Form (1.0.0) ? | Admin Menu (1.0.0) ? | Online Users (1.0.0) ? | Popular Items (1.0.0) ? | Quick Icons (1.0.0) ? | Items Stats (1.0.0) ? | User Status (1.5.0) ? | Admin Submenu (1.0.0) ? | Title (1.0.0) ? | Toolbar (1.0.0) ? | Unread Items (1.0.0) ? |
3rd Party:: JoomlaStats Back-end (3.0.0) ? |

Libraries ::
Core ::
3rd Party::

Plugins ::
Core :: Authentication - Example (1.5) ? | Authentication - GMail (1.5) ? | Authentication - Joomla (1.5) ? | Authentication - LDAP (1.5) ? | Authentication - OpenID (1.5) ? | Content - Email Cloaking (1.5) ? | Content - Example (1.0) ? | Content - Code Highlighter (GeSHi) (1.5) ? | Content - Load Modules (1.5) ? | Content - Pagebreak (1.5) ? | Content - Page Navigation (1.5) ? | Content - Vote (1.5) ? | Editor - XStandard Lite for Joomla! (1.0) ? | Button - Image (1.0.0) ? | Button - Pagebreak (1.5) ? | Button - Readmore (1.5) ? | Search - Categories (1.5) ? | Search - Contacts (1.5) ? | Search - Content (1.5) ? | Search - Newsfeeds (1.5) ? | Search - Sections (1.5) ? | Search - Weblinks (1.5) ? | System - Backlinks (1.5) ? | System - Cache (1.5) ? | System - Debug (1.5) ? | System - Legacy (1.5) ? | System - Log (1.5) ? | System - Remember Me (1.5) ? | System - SEF (1.5) ? | User - Example (1.0) ? | User - Joomla! (1.5) ? | XML-RPC - Blogger API (1.0) ? | XML-RPC - Joomla API (1.0) ? |
3rd Party:: Google Maps (2.12m) ? | Editor - TinyMCE 3 (3.2.6) ? | Search - DJCatalog (1.0) ? | System - AntiCopy (1.8.1) ? | System - JB Type (1.1) ? | System - JB Library (1.0.10) ? |

Templates :: Site :: beez (1.0.0) ? | JA_Purity (1.2.0) ? | rhuk_milkyway (1.0.2) ? | Sprint (1) ? |
Templates :: Admin :: Khepri (1.0) ? |

[Per Yngve Berg]

Mod. Note: Relocated the topic to the J1.5 forum.

You are not on the latest version of the 1.5 series which is 1.5.26.

The update file is here: https://downloads.joomla.org/cms/joomla ... format=zip

Updating on 1.5 is done by unzipping the file and upload overwriting files on the site.

[Webdongle]

php 5.6.40 might be too new for J1.5 and methinks there is not a php5.4 version that can be added to wamp. It could be done by installing an older version of wamp but that is a lot of messing about.

If you manage to update Joomla to the last official J1.5.26 there is an unofficial J1.5.27 that fixes a zero day exploit. Even then the site is out of date and migrating to j.3.9.28 from J1.5 is complex.

I suggest that you would find it easier and quicker to build a new site.

[dhbrown44]

php 5.6.40 might be too new for J1.5 and methinks there is not a php5.4 version that can be added to wamp. It could be done by installing an older version of wamp but that is a lot of messing about.

If you manage to update Joomla to the last official J1.5.26 there is an unofficial J1.5.27 that fixes a zero day exploit. Even then the site is out of date and migrating to j.3.9.28 from J1.5 is complex.

I suggest that you would find it easier and quicker to build a new site.

The ultimate goal is not to build the site, but merely recover the content of the site, to rebuild at a later stage. Is there a way to recover it's content?

[Webdongle]

All the text for the Articles is in the database. All your images should be in the files.

But if you want to see it as a site:
https://markushedlund.com/dev/install-p ... 3-on-wamp/ how to install a different php on wamp
https://stackoverflow.com/questions/431 ... n-mamp-4-1 for installing a different php version on mamp

Even if you get the old site running you will be struggling to find a Host to support an old version. Methinks it would take twice (or 3 times) as long to get the 1.5 site running than it would be to build from scratch. All the text for the Articles is in the database.

[dhbrown44]

1000 apologies if I sound thick...but how would I read the db? I opened the db file in notepad, but it is all greek to me.

I won't use this site on a host package - no hosts will run that php version.

[Pavel-ww]

1000 apologies if I sound thick...but how would I read the db? I opened the db file in notepad, but it is all greek to me.

Hi. Enter the database via phpMyadmin, open the table your-prefix__content.

[dhbrown44]

All the text for the Articles is in the database. All your images should be in the files.

But if you want to see it as a site:
https://markushedlund.com/dev/install-p ... 3-on-wamp/ how to install a different php on wamp
https://stackoverflow.com/questions/431 ... n-mamp-4-1 for installing a different php version on mamp

Even if you get the old site running you will be struggling to find a Host to support an old version. Methinks it would take twice (or 3 times) as long to get the 1.5 site running than it would be to build from scratch. All the text for the Articles is in the database.

Took your advice to add php5.4.0 to WAMP. Quite an ordeal. I changed the PHP version in WAMP, there was an error, but now the site is live on localhost. I tried to log into joomla admin, but no avail, how can I recover the login?

[Per Yngve Berg]

https://docs.joomla.org/How_do_you_reco ... assword%3F

[Webdongle]

https://docs.joomla.org/J1.5:How_do_you ... assword%3F for J1.5

[dhbrown44]

Thank you all that assisted. I have recovered the content and the site. I will rebuild the site at a later stage. Sadly I still have no confidence working with Joomla. I will stick with Bootstrap 4.
Thank you all again.

[Webdongle]

Sorry that someone's negligence of site maintenance has caused you to have no confidence in the software they failed to maintain. I hope you get as much help with bootstrap 4 problems as you have received in this forum.