We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Get started

Update 1.5.3 to 1.7 | Forum

Topic location: Forum home » Support » Bug reports and troubleshooting

Philippe Jul 18 '14

Hello,

I've a 1.5.3 version installed on my server and when use the package for the manual update to 1.7 i've this error (before i'm desactived all plugin and use a default template) :

Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mobile' in 'field list'
File: /var/www/devsite/xxxx/ow_core/database.php
Line: 331
Trace: 

#0 /var/www/devsite/xxxx/ow_core/database.php(331): PDOStatement->execute()
#1 /var/www/devsite/xxxx/ow_core/database.php(564): OW_Database->execute('INSERT INTO `ow...', Array)
#2 /var/www/devsite/xxxx/ow_core/database.php(601): OW_Database->insert('INSERT INTO `ow...', Array)
#3 /var/www/devsite/xxxx/ow_core/base_dao.php(216): OW_Database->insertObject('ow_base_theme_c...', Object(BOL_ThemeControl))
#4 /var/www/devsite/xxxx/ow_system_plugins/base/bol/theme_service.php(388): OW_BaseDao->save(Object(BOL_ThemeControl))
#5 /var/www/devsite/xxxx/ow_system_plugins/base/bol/theme_service.php(309): BOL_ThemeService->processTheme(925)
#6 /var/www/devsite/xxxx/ow_core/application.php(775): BOL_ThemeService->processAllThemes()
#7 /var/www/devsite/xxxx/ow_core/application.php(742): OW_Application->updateCachedEntities(true)
#8 /var/www/devsite/xxxx/ow_core/application.php(158): OW_Application->devActions()
#9 /var/www/devsite/xxxx/index.php(43): OW_Application->init()
#10 {main}

Type: PDOException

Philippe.

The Forum post is edited by Philippe Jul 18 '14

Omari Jul 18 '14

database problem. you see u extract the files into your server. but you have not updated the database to match.

if you did the update through the admin console it would have written in the new database fields required.

my suggestion is rollback to 1.5 files.
(these will match your current database)

then perform update through the admin panel.

else you will have to manually add fields to your database

Philippe Jul 19 '14

I do not think that will be the database that have a problem. EN 1.5.3 mobile part did not exist, she appeared with version 1.6 so I guess I have gone through version 1.6 before updating to 1.7 but unfortunately I can not find where to download the file containing only update.

Pete Jul 19 '14

Just try running the update again .

Team

ross Jul 20 '14

please restore your back up and read this: http://www.oxwall.org/forum/topic/21778?page=1

Philippe Jul 20 '14

Hello,
- i'm copy a production site to a test;
- i'm desatived all plugins;
- i'm changed the theme to origin;
- i'm copy update file;
- i'm modify the function checkUpdate;
- i'm go to http://mysite/ow_updates

I've the identical error :(

Team

ross Jul 20 '14

Philippe, you need to restore your backup and change the function, and try again to update your software either manual or automatic. This error means that update has not been successfully completed.

Philippe Jul 21 '14

ok, but the package update contains a file plugin_service.php and function CheckUpdates.

I still followed your message:

- Copy my production file to a folder of test;
- Copy the production database to a test;
- Set the folder and the test database;
- Verify that the test folder function normalmenent;
- Disable all plugins;
- Activate the theme origin;
- Go into maintenance mode;
- Change the CheckUpdates function in the test folder;
- Copy the update file in the test;
- Go to the following address: http://monsite/dossiertest/ow_updates

It's ok now, the only difference is that in my previous attempt debug mode was active.

Thank you.

Team

ross Jul 21 '14

Yes, the function is there but it was changed. So everything works now?

Team

ross Jul 21 '14

Topic was moved from Installation Troubleshooter and Server setup.

#10

Oxwall Software

Please sign in

We build. You grow.

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Update 1.5.3 to 1.7 | Forum