Support

Site Restoration

#24792 Cannot get kickstart to run

Posted in ‘Site restoration’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
n/a
CMS Type
Other
CMS Version
n/a
Backup Tool Version
n/a
Kickstart version
n/a

Latest post by on Sunday, 01 May 2016 17:20 CDT

bibbp
 After an upgrade to Joomla 3.5 from 3.4.8 I cannot bring up the site. So I moved the backup to the root, loaded kickstart.php and tried to run it, as www.IGspectrum.com/kickstart.php and I get the following message and kickstart doe snot run so I cannot restore the site:
1267 - Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation 'locate' SQL=SELECT m.id,m.id AS item_id,m.title,m.link,m.type,@tmp_search := '"menu-meta_description":"' AS tmp_search, @tmp_search_len := LENGTH(@tmp_search) AS tmp_search_len, @start := LOCATE(@tmp_search, m.params) AS tmp_start, @end := LOCATE('"', m.params, @start + @tmp_search_len) AS tmp_end, TRIM(SUBSTRING(m.params, @start + @tmp_search_len, @end - @start - @tmp_search_len)) AS metadescription,"" AS description,@tmp_search := '"page_title":"' AS tmp_search, @tmp_search_len := LENGTH(@tmp_search) AS tmp_search_len, @start := LOCATE(@tmp_search, m.params) AS tmp_start, @end := LOCATE('"', m.params, @start + @tmp_search_len) AS tmp_end, TRIM(SUBSTRING(m.params, @start + @tmp_search_len, @end - @start - @tmp_search_len)) AS metatitle,e.element as extension FROM #__menu AS m LEFT JOIN `#__extensions` AS e ON m.component_id = e.extension_id WHERE m.id = '101'

nicholas
Akeeba Staff
Manager
Your .htaccess file does not allow kickstart.php to run. As a result Joomla! kicks in and tries to display an error page. However, since the upgrade from 3.4.8 to 3.5.0 failed Joomla! crashes while trying to do that. Hence the error message you see.

Delete the .htaccess file from your site's root. This will prevent Joomla! from trying to intercept Kickstart and you will be able to access Kickstart. If you cannot see the .htaccess file –all files whose names start with a dot are hidden on Linux servers– please ask your host for help deleting it.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

bibbp
Thank you very much, this enabled me to run kickstart.php, so now I can proceed.

nicholas
Akeeba Staff
Manager
You're welcome!

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!