Search

Hi Everyone,

I'm having trouble upgrading to 2.3.1 without using git. I know there's similar trouble here:

link text

But I don't use git and am unsure what all that git-talk means.

I've overwritten the symphony files with the 2.3.1 versions and was thinking that the update installer prompt would appear but when I try to access front or backend I am seeing:

Symphony Fatal Database Error: Unknown column 'e.modification_date' in 'field list'

SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`, UNIX_TIMESTAMP(e.`modification_date`) AS `modification_date` FROM `mb31_entries` AS `e` WHERE 1 AND `e`.`section_id` = '6' ORDER BY `e`.`id`DESC

Plus the backtrace stuff.

Does anyone know what's happening here?

I did a clean 2.3.1 install just to check and that seems to run fine.

I'm running the standard extensions and just a couple of others:

html5 doctype order entries subsection manager 2 unique upload field

It's just a simple site so I don't think there's anything exotic I've been doing to complicate stuff.

Oops spoke too soon, by manually visiting the install directory:

http:whatever.com/install/

I was able to do the upgrade routine and the site worked.

Sorry for the false alarm but I'm sure upgrading to 2.3 automatically gave the install prompt.

Afraid not, upgrading is a manual process.

What the heck is going on??? I CANNOT UPDATE from 2.2.5 to 2.3.2. I've updated all of my extensions to latest version.

This is what is happening...

  1. I pull up the install page and click on the Update Symphony button.
  2. It then returns an "Updating Failure" message and I click on the update log to see the error.
  3. The error that is returned is... StartTag: invalid element name in Entity, line: 1179 /Users/username/Sites/web.site/public/symphony/lib/toolkit/class.xsltprocess.php:135
  4. Then I click on debug and it shows that I have a MySQL error...

    MySQL Error (1054): Unknown column 'e.modification_date' in 'field list' in query: SELECT SQL_CACHE `e`.id,
                    `e`.section_id, e.`author_id`,
                    UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`,
                    UNIX_TIMESTAMP(e.`modification_date`) AS `modification_date`
            FROM `sym_entries` AS `e`
    
                LEFT JOIN
                    `sym_entries_data_150` AS t150_3
                    ON (e.id = t150_3.entry_id)
             LEFT JOIN `sym_entries_data_132` AS `t1322` ON `e`.`id` = `t1322`.entry_id 
            WHERE 1
    
            AND `e`.`section_id` = '21' 
    
                    AND (
                        t150_3.value IN ('yes')
                        OR
                        t150_3.value IS NULL
                    )
                 AND (`t1322`.date >= '2013-06-13 04:59:59'
                            AND `t1322`.date <= '10000-01-01 05:59:59' ) 
            ORDER BY (
                    SELECT `ed`.date
                    FROM sym_entries_data_131 AS `ed`
                    WHERE entry_id = e.id
                ) ASC
            LIMIT 0, 200
    

Here's a brief screencast showing you what is happening.

PLEASE HELP!!!!

FYI: I am running PHP 5.4.15 on my localhost Mac.

What the heck is going on??? I CANNOT UPDATE from 2.2.5 to 2.3.2

There was a change in the column names if I remember right. My advice would be to update from 2.2.5 to 2.3.0, then update from 2.3.0 to 2.3.2 and see if that works ok.

If so we can check the update process between versions as something may have been missed out.

NEVERMIND. I changed the permissions in my siteroot by running chmod -R 777 . And ran the update and the update completed. Go figure. @designermonkey, thank you for the reply.

No worries. Glad it worked out.

Create an account or sign in to comment.

Symphony • Open Source XSLT CMS

Server Requirements

  • PHP 5.3-5.6 or 7.0-7.3
  • PHP's LibXML module, with the XSLT extension enabled (--with-xsl)
  • MySQL 5.5 or above
  • An Apache or Litespeed webserver
  • Apache's mod_rewrite module or equivalent

Compatible Hosts

Sign in

Login details