After update from 1.0.10 to .12: Execution of a query to the database failed - Unknown column 'alias_visible' in 'field list'

Hi,

I upgraded a 1.0.10-installation to 1.0.12. I did the following:

• download the 1.0.12 ZIP file to target host
• unzip
• copy over all files overwriting the 1.0.10 installation
• run /install
• fix some minor permission issues until everything was “ok”
• “Install“
• rm -r install

When I now access hostname.example.com/manager I get:

-------
« MODX Parse Error »

MODX encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Unknown column 'alias_visible' in 'field list' »
SQL > SELECT id, IF(alias='', id, alias) AS alias, parent, alias_visible FROM `knubbelmac`.`modx_site_content`
Basic info
REQUEST_URI : /
Referer :
User Agent : Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9) AppleWebKit/537.71 (KHTML, like Gecko) Version/7.0 Safari/537.71
Benchmarks
MySQL : 0.0060 s (2 Requests)
PHP : 0.0069 s
Total : 0.0129 s
Memory : 0.77809906005859 mb

Backtrace

1 DocumentParser->executeParser()
index.php on line 140
2 DocumentParser->getSettings()
manager/includes/document.parser.class.inc.php on line 1495
3 synccache->buildCache()
manager/includes/document.parser.class.inc.php on line 269
4 synccache->getParents()
manager/processors/cache_sync.class.processor.php on line 208
5 DBAPI->query()
manager/processors/cache_sync.class.processor.php on line 39
-------

Host: Debian Linux 7
nginx/1.2.1 + php_fpm PHP Version 5.4.4-14+deb7u5 + xcache

I think this feature has missing script for upgrade?

Install should have executed the following line:


Maybe a DB rights issue? Or something else during update?

Quote from: Jako at Nov 04, 2013, 10:32 AM

Maybe a DB rights issue? Or something else during update?

DB rights: not that I know of any problem. Update went smoothly, no errors reported.

Quote from: Jako at Nov 04, 2013, 10:32 AM

Install should have executed the following line:

ALTER TABLE  `{PREFIX}site_content` ADD COLUMN `alias_visible` INT( 2 ) NOT NULL DEFAULT  '1';

I’ll try to execute that manually (with proper PREFIX), thanks.

need or manual run query ALTER TABLE
or do install update

Maybe update process did not get through because of a large database and the 30 seconds of the PHP script_time_limit are too low. But thats just a guess.

Feel free to dig deeper

Quote from: dmi3y at Nov 04, 2013, 10:48 AM

need or manual run query ALTER TABLE
or do install update

As I wrote above: I did to “/install”.

Quote from: Jako at Nov 04, 2013, 10:59 AM

Maybe update process did not get through because of a large database and the 30 seconds of the PHP script_time_limit are too low. But thats just a guess.

Feel free to dig deeper

Don't think so, updating needed less than 5 seconds. *sigh* then digging …

Just a last question: The install process was finished until the question: 'Remove the install folder and files from my website …' or 'Please remember to remove the 'install' folder'?

Would be interesting to solve that – if you have found the issue.