Forums / Cotonti / Support / Upgrading to Sienna fails all the time

my database gets wrecked all the time, can I manually upgrade the DB?

foxhound
#1 2013-12-07 17:10

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.
Let me first tell what I did.
1- upgraded to latest Genoa version (database + files)
2- uploaded the latest Sienna files, overwriting the old files
3 - uploaded the legacy Sienna files, overwriting the previously uploaded files
4- run the installer
 

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....


I can not acces the forums at all, I get an sql error. When vieiwing the users there is only one, just me. But, in the database which was there before the install was run there were 47k users.

I have no idea what this is causing. Some parts of my DB are still there but other parts are replaced by the defaults.

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.
What would be the correct procedure to manually upgrade the DB? I took a look in the setup folders but I am not sure which sql patches I should all execute and which I should just not touch.
Say, I want to upgrade my DB from 0.6.25 genoa to Sienna 0.9.15, how could I manually do that?

Also, the prefix of my tables is still "sed_", I changed that in the config (otherwise the install could not even run) but I was wondering if having a "sed_" prefix could cause issues in the future? How would I go about to change all my DB prefixes to cot_ instead of sed_?

<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
#2 2013-12-07 17:58

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
#3 2013-12-07 18:13

Ok, thank you very much. I will keep an eye on the link you posted.
I can not wait to see my DB in Sienna on my new website with all these new features :)

<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
#4 2013-12-31 11:51

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
#5 2013-12-31 12:53

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
#6 2013-12-31 13:14

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, 10 years ago)