cotonti.com : Need help with an upgrade

musashi9

Mon, 05 Dec 2011 08:01:53 -0000

That worked and I received a msg saying succesfull upgrade. However sorry to be a pain I now get this error.

2011-12-05 07:59

Fatal error: Default theme not found.

#0  cot_diefatal(Default theme not found.) called at [/hermes/web01/b2155/as.mysite/public_html/system/common.php:521]
#1  require_once(/hermes/web01/b2155/as.mysite/public_html/system/common.php) called at [/hermes/web01/b2155/as.mysite/public_html/index.php:37]
-----------------------------
my config looks like this
$cfg['defaulttheme'] = 'nemesis';    // Default theme code. Be SURE it's pointing to a valid folder in ./themes/... !!
and I have nemesis uploaded to themes folder

Nevermind I fixed it. thanks to everyone  for all the help

Trustmaster

Mon, 05 Dec 2011 06:40:44 -0000

Yes, this is the cause. Disable maintenance mode in Admin panel before upgrading.

musashi9

Sun, 04 Dec 2011 22:50:06 -0000

ah yes I did, is this causing me the problems? if so how may I fix it

Trustmaster

Sun, 04 Dec 2011 15:58:49 -0000

Hmm, did you put your site into maintenance mode before upgrading?

musashi9

Sun, 04 Dec 2011 14:21:59 -0000

Yes I run Install but it seems to jump straight to login.php.

This is everything I have done

#1 I had 0.6.5 install I was told to update to 6.20 which I did without problems, then I was told to update to Siena, and just run install.php. This gave me problems as described above

The main problem was my database was sed_ .... not cot_.. so I changed the value of $db_x from 'cot_' to 'sed_'. and I set $cfg['new_install'] = FALSE;

Now I get the error I pasted above

To answer your second question, no my DB doesn't have a sed_updates table. I don't think any of my DB backups has this table

Trustmaster

Sun, 04 Dec 2011 11:05:25 -0000

Are you sure that you run install.php, not login.php? The error message #4 tells that login.php is being run.

Another question: do you rollback your database before trying to upgrade again? Did your genoa database have sed_updates table?

musashi9

Sat, 03 Dec 2011 11:27:56 -0000

Yes and this is the msg that it gives me

Fatal error: SQL error 42S22: Column not found: 1054 Unknown column 'c_realm' in 'where clause'

#0 cot_diefatal(SQL error 42S22: Column not found: 1054 Unknown column 'c_realm' in 'where clause') called at [/hermes/web01/b2155/as.mysite/public_html/system/database.php:436]
#1 CotDB->query(SELECT c_name, c_value FROM `sed_cache` WHERE c_auto=1 AND c_realm IN('system','cot','users')) called at [/hermes/web01/b2155/as.mysite/public_html/system/cache.php:724]
#2 MySQL_cache->get_all(Array ([0] => system,[1] => cot,[2] => users)) called at [/hermes/web01/b2155/as.mysite/public_html/system/cache.php:1238]
#3 Cache->init() called at [/hermes/web01/b2155/as.mysite/public_html/system/common.php:90]
#4 require_once(/hermes/web01/b2155/as.mysite/public_html/system/common.php) called at [/hermes/web01/b2155/as.mysite/public_html/login.php:22

Added 12 hours later:

I just checked my sed_cache on myphp and it seems to be empty with no records at all.

GHengeveld

Sat, 03 Dec 2011 10:43:47 -0000

Did you run install.php again?

musashi9

Fri, 02 Dec 2011 02:38:12 -0000

Did this $cfg['new_install'] = FALSE;

and this $db_x 'cot_' now = 'sed_'.

Now I get this

2011-12-02 02:39

Added 1 day later:

Desperate for help. anybody ?

GHengeveld

Fri, 02 Dec 2011 02:17:24 -0000

Apparently the installer believes it's a fresh install rather than an upgrade. In datas/config.php set $cfg['new_install'] to FALSE. If it doesn't exist, create it as follows:

$cfg['new_install'] = FALSE;

musashi9

Fri, 02 Dec 2011 00:47:23 -0000

I changed config to sed then I goto install.php

STEP #1

This script will setup the basic Cotonti installation and configuration for you.

Server Info
PHP 5.2.17 — valid!
mbstring Available
hash Available
MySQL Available

It is recommended to copy datas/config-sample.php to datas/config.php and set CHMOD 666 on datas/config.php before running this script.

File/Folder Permissions
./datas/config.php Writable
./datas/config-sample.php Found
./setup/install.sql Found
datas/avatars Writable
datas/cache Writable
datas/exflds Writable
datas/users Writable
datas/photos Writable
datas/thumbs Writable

Cotonti Web Installer ver. 0.9.4 Step 2 of 4

    MySQL Database Settings xxxx
    Database host xxxx
    Database user xxxx
    Database password xxxx
    Database name xxxx
    Table prefix xxxx

First you need to create a blank database with the above name on your server, if this user has no permission to create new databases.
2011-12-01 19:47

Then this................

Fatal error: SQL error 42S01: Base table or view already exists: 1050 Table 'sed_auth' already exists

#0  cot_diefatal(SQL error 42S01: Base table or view already exists: 1050 Table 'sed_auth' already exists) called a ect...... big list of stuff

GHengeveld

Thu, 01 Dec 2011 09:51:20 -0000

Sorry about that, I forgot about the database prefix which is different between Genoa and Siena. This is the reason why your database now contains both cot_* and sed_* tables.

Before you run install.php open datas/config.php and change the value of $db_x from 'cot_' to 'sed_'.

You can remove all tables starting with cot_. Those were created when you ran install.php so most of them will be empty. It's easiest to just continue using sed_* tables, it doesn't make any difference for the system. The goal is to let install.php use your existing database tables instead of having it create new tables. For this it will have to know the right prefix, otherwise it won't detect your existing tables.

musashi9

Thu, 01 Dec 2011 01:29:48 -0000

Ok thanks I am going to go from 0.6.5 > 0.6.20 first. then onto the latest version

Wish me luck :P

Added 1 hour later:

UPDATE:

0.6.5 > 0.6.20 worked withour problems

install.php > oh no!!! It did a fresh install and now my site is empty PLEASE HELP!!!

Added 3 minutes later:

my database now has 2 sets inside

set one goes like this cot_groups ect.......

set 2 goes like this sed_groups ect..... (original site 0.6.5)

Added 3 hours later:

busy day for me. I restored my original back up and I am now at step 2

This is my current working version.

Version (Revision) / Database 0.6.20(r1041) / 0.6.20

The last time I was here I used the method GHengeveld suggested but it installed a fresh install. How may I proceed without it doing this

Thanks

Trustmaster

Wed, 30 Nov 2011 09:41:09 -0000

I would recommend updating from 0.6.5 to 0.6.20 first. This procedure includes:

Download 0.6.20 package, upload the files to the server, overwriting old files.
Enter phpMyAdmin and apply there SQL patches found in 'sql' subfolder:

patch-0.6.3-0.6.9.sql
patch-0.6.9-0.6.12.sql
patch-0.6.12-0.6.14.sql

After updating to the latest 0.6.x you can safely leave it as it is or upgrade to 0.9.x like Gert described above.

GHengeveld

Wed, 30 Nov 2011 08:34:21 -0000

In Siena, the latest version, you no longer have to go through all those steps. You simply follow these steps:

Make a backup of your files and database.
Download the latest version of Cotonti and upload the files to the server, overwriting old files.
Set CHMOD 777 on /datas and subfolders/subfiles.
Visit yoursite.com/install.php and follow the install procedure.

musashi9

Wed, 30 Nov 2011 03:49:17 -0000

Hi, I have been using Cotonti (V 0.6.5 ?? I think) for a while now and never saw much of a reason to upgrade any further. However it has been a while and I feel I have to do something to try and keep up, so here is my problem.

How do I upgrade from my current version to the latest Cotonti release?

I am not even sure I know what my current version is, I go to admin then cotonti and it says this: Version / Database 0.6.5 / 0.6.5

Do I have to go through every upgrade one by one or is there just one package I can update from.

Is there a step by step guide or can someone follow me through it in a safe way.

Thanks