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

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

Dave
#38836 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)