Форуми / Cotonti / Support / Need help with an upgrade

12>>>

6.5 > newest

musashi9
#1 30.11.2011 03:49

Members

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

 
GHengeveld
#2 30.11.2011 08:34

Team
Thanked: 52 рази

In Siena, the latest version, you no longer have to go through all those steps. You simply follow these steps:
  1. Make a backup of your files and database.
  2. Download the latest version of Cotonti and upload the files to the server, overwriting old files.
  3. Set CHMOD 777 on /datas and subfolders/subfiles.
  4. Visit yoursite.com/install.php and follow the install procedure.
See also: Updating from Genoa
Trustmaster
#3 30.11.2011 09:41

Administrators
Thanked: 265 раз

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

  1. Download 0.6.20 package, upload the files to the server, overwriting old files.
  2. 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.

May the Source be with you!
musashi9
#4 01.12.2011 01:29

Members

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

Відредаговано: musashi9 (01.12.2011 07:16, 13 років тому)
GHengeveld
#5 01.12.2011 09:51

Team
Thanked: 52 рази

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.

Відредаговано: GHengeveld (01.12.2011 11:26, 13 років тому)
musashi9
#6 02.12.2011 00:47

Members

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

Відредаговано: musashi9 (02.12.2011 01:16, 13 років тому)
GHengeveld
#7 02.12.2011 02:17

Team
Thanked: 52 рази

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
#8 02.12.2011 02:38

Members

Did this $cfg['new_install'] = FALSE;
and this $db_x  'cot_' now =  'sed_'.

Now I get this

2011-12-02 02:39


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 1 day later:

Desperate for help. anybody ?

Відредаговано: musashi9 (03.12.2011 09:40, 13 років тому)
GHengeveld
#9 03.12.2011 10:43

Team
Thanked: 52 рази

Did you run install.php again?
musashi9
#10 03.12.2011 11:27

Members

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.

Відредаговано: musashi9 (04.12.2011 00:17, 13 років тому)
Trustmaster
#11 04.12.2011 11:05

Administrators
Thanked: 265 раз

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?

May the Source be with you!
musashi9
#12 04.12.2011 14:21

Members

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
#13 04.12.2011 15:58

Administrators
Thanked: 265 раз

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

May the Source be with you!
musashi9
#14 04.12.2011 22:50

Members

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

Відредаговано: musashi9 (05.12.2011 03:05, 13 років тому)
Trustmaster
#15 05.12.2011 06:40

Administrators
Thanked: 265 раз

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

May the Source be with you!

12>>>