[SOLVED] Upgrade 2.5.24 to 3.3 Control Panel with Error 1024

Need help upgrading your Joomla! website or converting to Joomla! 3.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
SigridGR
Joomla! Apprentice
Joomla! Apprentice
Posts: 26
Joined: Sat Nov 25, 2006 10:27 am

[SOLVED] Upgrade 2.5.24 to 3.3 Control Panel with Error 1024

Post by SigridGR » Tue Aug 26, 2014 10:12 am

Hello,

I have just upgraded a project from J2.5.24 to J3.3. - checked all requirements (I have done already other upgrades without a problem).

But for this installation:

For the control panel I get the error message:

Code: Select all

Error 1054: Unknown column '' in 'order clause' SQL=SELECT * FROM `#_postinstall_messages` WHERE `extension_id` = '700' AND `enabled` = '1' ORDER BY `` ASC 
For the Component "Post Installation Messages"

Code: Select all

Error 1146: Table 'tablename.#_postinstall_cpanels' doesn't exist SQL=SHOW FULL COLUMNS FROM `#_postinstall_cpanels` 
I did make a backup of the old J2.5
I deactivated all plugins not from Joomla and "Remember me". I tried to upgrade all components for J3.3 before update then update (except Joomgallery). I tried to uninstall all components, also uninstall Joomgallery before and install again afterwards. Still the same problem.

I did Extensions - Database -> there is nothing to fix (I still hit "Fix")
I did Extensions - Discover -> there is nothing to discover

I followed this post http://docs.joomla.org/J3.x:Table_xxx_p ... _not_exist which gives me a broken control panel. I copied the files back then.

Any ideas?

Thanks Sigrid
Last edited by SigridGR on Tue Aug 26, 2014 6:47 pm, edited 2 times in total.

User avatar
ribo
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3474
Joined: Sun Jan 03, 2010 8:47 pm
Contact:

Re: Upgrade 2.5.24 to 3.3 Control Panel with Error 1024

Post by ribo » Tue Aug 26, 2014 2:37 pm

just a thought:
export a table postinstall_messages from another joomla 3.3.3
drop the table postinstall_messages from your site you get the error
import the table postinstall_messages from your pc

these you can do it via phpmyadmin

back up before you do that
chat room spontes : http://www.spontes.com

SigridGR
Joomla! Apprentice
Joomla! Apprentice
Posts: 26
Joined: Sat Nov 25, 2006 10:27 am

Re: Upgrade 2.5.24 to 3.3 Control Panel with Error 1024

Post by SigridGR » Tue Aug 26, 2014 3:53 pm

thanks for your answer!
ribo wrote:just a thought:
export a table postinstall_messages from another joomla 3.3.3
drop the table postinstall_messages from your site you get the error
import the table postinstall_messages from your pc
I have other J3.3 installations and the postinstall_messages is exactly the same. Also in other "working" J3.3 installations there is no table #_postinstall_cpanels.

I think it has something to do with the changed libraries/fof but I don't know much about it.

Anybody an idea?

sovainfo
Joomla! Exemplar
Joomla! Exemplar
Posts: 8808
Joined: Sat Oct 01, 2011 7:06 pm

Re: Upgrade 2.5.24 to 3.3 Control Panel with Error 1024

Post by sovainfo » Tue Aug 26, 2014 6:06 pm

Scan this board for "practical guide" and you'll find the procedure to properly migrate your site. You failed to update the old fof. You should remove it befor updating!
Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!

SigridGR
Joomla! Apprentice
Joomla! Apprentice
Posts: 26
Joined: Sat Nov 25, 2006 10:27 am

Re: Upgrade 2.5.24 to 3.3 Control Panel with Error 1024

Post by SigridGR » Tue Aug 26, 2014 6:46 pm

sovainfo wrote:Scan this board for "practical guide" and you'll find the procedure to properly migrate your site. You failed to update the old fof. You should remove it befor updating!
Actually I did read the "practical guide", but the fof is only mentionend after like 40 topics on page 3 which I did not read all in detail.

However, with the following link from page 3 of the practical guide, I could solve my problem:
https://github.com/joomla/joomla-cms/pull/2519

I did replace the fof (backup or just rename your old folder!!!) and I did install the new fof plugin as mentioned in the github-article --> still screwed my site. Then I copied the new "fof" files over the old "fof files and then manually deleted the old files in the folder libraries/fof. Only the following files (and of course all folders) remain (don't delete):
include.php
index.html
lib_fof.xml
LICENSE.txt
version.txt

Downloaded new fof from here https://www.akeebabackup.com/download/fof/2-1-1.html

mitokat
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 106
Joined: Tue Apr 15, 2008 7:24 pm

Re: [SOLVED] Upgrade 2.5.24 to 3.3 Control Panel with Error

Post by mitokat » Mon Sep 29, 2014 3:36 pm

I landed here from a diff post suggestion. I wanted to update others. I did everything above and it did not work so I went and downloaded the last FOF. I eventually got rid of the error message but also lost my control panel. No errors. Just nothing on the page. All other pages of the admin worked. I ended up renaming the Library folder. I then uploaded the entire library folder from a fresh instal. Looks like everything is working as it should right now. This site though as very little other addons, components, plugins ect. That might have helped this solution not hurt something else.

User avatar
TomT
Joomla! Ace
Joomla! Ace
Posts: 1270
Joined: Thu Aug 18, 2005 5:50 am
Location: Amsterdam
Contact:

Re: [SOLVED] Upgrade 2.5.24 to 3.3 Control Panel with Error

Post by TomT » Fri Jan 30, 2015 1:07 pm

After reading the last post I decided to rename the fof folder in the libraries folder and upload the fof folder from the 3.3.6 installation package and that works.
Last edited by TomT on Fri Jan 30, 2015 2:00 pm, edited 1 time in total.

sovainfo
Joomla! Exemplar
Joomla! Exemplar
Posts: 8808
Joined: Sat Oct 01, 2011 7:06 pm

Re: [SOLVED] Upgrade 2.5.24 to 3.3 Control Panel with Error

Post by sovainfo » Fri Jan 30, 2015 1:27 pm

The PR for removing the old files has been accepted for J3.4.0 beta 1. So updating to J3.4 in a few weeks won't fail of old installation of fof anymore.
Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!

User avatar
ribo
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3474
Joined: Sun Jan 03, 2010 8:47 pm
Contact:

Re: [SOLVED] Upgrade 2.5.24 to 3.3 Control Panel with Error

Post by ribo » Sun Feb 15, 2015 9:20 am

sovainfo wrote:The PR for removing the old files has been accepted for J3.4.0 beta 1. So updating to J3.4 in a few weeks won't fail of old installation of fof anymore.
these are good news :)
chat room spontes : http://www.spontes.com


Locked

Return to “Migrating and Upgrading to Joomla! 3.x”