my database gets wrecked all the time, can I manually upgrade the DB?
foxhound |
|
---|---|
I am trying (just for testing purposes) to update my current database to the latest Sienna version. But, I have been busy with it all day and have to simply give up. It keeps doing funny things with my database. No errors show in the installer but my entire database has been changed. My website structure is removed and replaced with the default. All my pages are still there though, just structure is gone. My forums structure is removed and replaced by the default. All forum posts etc are still there though....
So, instead of relying on the auto update, can I manually update as well? I have disabled all plugins on the Genoa website before attempting this. <img src="http://www.armaholic.com/datas/thumbs/green-sea-battalion-uniforms-version-03-preview_4.jpg" alt="green-sea-battalion-uniforms-version-03-" />
|
Trustmaster |
|
---|---|
Hi, It seems like upgrade from Genoa is broken because it tries to do a blank install instead of upgrade obviously. It should be tested by the team. Keep a watchful eye on https://github.com/Cotonti/Cotonti/issues/1301 and wait till it's fixed. May the Source be with you!
|
foxhound |
|
---|---|
Ok, thank you very much. I will keep an eye on the link you posted. <img src="http://www.armaholic.com/datas/thumbs/green-sea-battalion-uniforms-version-03-preview_4.jpg" alt="green-sea-battalion-uniforms-version-03-" />
|
Dave |
|
---|---|
hey there, any progres on that? im also trying to upgrate to SIena with same issues, users, pages, topics/posts are in the DB but strukture is default... ;/
i did manual update through phpmyadmin 0-6-23 > 0-6-24 > 0-9-15 (changed prefix from cot_ to sed_ in the: patch-genoa.sql/inc)
got this error: /* KEEP THIS AT THE BOTTOM AND UPDATE TO THE LATEST PATCH REVISION */ UPDATE `sed_updates` SET `upd_value` = '0.9.15-01' WHERE `upd_param` = 'revision'; MySQL zwrócił komunikat: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '------------------------------------------------------------------------------- ' at line 1
Your advertisement here :-)
Cotonti Genoa based site: forgotten-garage.pl |
Twiebie |
|
---|---|
That error is because of an invalid comment line, please try again with the latest version from GitHub. https://github.com/Cotonti/Cotonti/commit/f59fe53b6f4469f3ff67d543ffc1519b7f7c590e |
Dave |
|
---|---|
already found that, "update" went ok, i can log in but when i want to go to: admin.php?m=extensions SQL error 42S22: Column not found: 1054 Unknown column 'ct_plug' in 'where clause' #0 cot_diefatal(SQL error 42S22: Column not found: 1054 Unknown column 'ct_plug' in 'where clause') called at [C:\WebServ\httpd\system\database.php:568] #1 CotDB->query(SELECT * FROM sed_core WHERE ct_code NOT IN('forums','index','page','pfs','pm','polls','rss','users') AND ct_plug = 0) called at [C:\WebServ\httpd\system\admin\admin.extensions.php:586] #2 require(C:\WebServ\httpd\system\admin\admin.extensions.php) called at [C:\WebServ\httpd\system\admin\admin.main.php:69] #3 include(C:\WebServ\httpd\system\admin\admin.main.php) called at [C:\WebServ\httpd\admin.php:25] index.php?e=page&c=articles 2013-12-31 13:16 SQL error 42S22: Column not found: 1054 Unknown column 'page_' in 'order clause' #0 cot_diefatal(SQL error 42S22: Column not found: 1054 Unknown column 'page_' in 'order clause') called at [C:\WebServ\httpd\system\database.php:568] #1 CotDB->query(SELECT p.*, u.* FROM sed_pages as p LEFT JOIN sed_users AS u ON u.user_id=p.page_ownerid WHERE page_state=0 AND page_cat='articles' ORDER BY page_ LIMIT 0, 1, Array ()) called at [C:\WebServ\httpd\modules\page\inc\page.list.php:187] #2 require_once(C:\WebServ\httpd\modules\page\inc\page.list.php) called at [C:\WebServ\httpd\modules\page\page.php:43] #3 require_once(C:\WebServ\httpd\modules\page\page.php) called at [C:\WebServ\httpd\index.php:126] also the "update" didnt make ct_plug in cot_core Added 28 minutes later: managed to fix that :p only thing left is structure of the forums was not converted :( Your advertisement here :-)
Cotonti Genoa based site: forgotten-garage.pl |
|
This post was edited by Dave (2013-12-31 13:51, 11 years ago) |