8.2.b to update from 9.2.1

fuxa · Posted: Wed May 28, 2008 12:29 pm Post subject: 8.2.b to update from 9.2.1

Hello I try cpgnuke since days of 8.2.b to 9.2.1 update!
I'm trying with the help of dragonflycms.org/Wiki/id=91/ contribute more to come but it does not work.
It reports to me always error
What am I doing wrong?

Thanks advance
Fuxa

Bush · Posted: Wed May 28, 2008 12:38 pm Post subject: Re: 8.2.b to update from 9.2.1

fuxa, you'll need to put in all your specs prior to getting help. Wink

fuxa · Posted: Wed May 28, 2008 12:45 pm Post subject: Re: 8.2.b to update from 9.2.1

Ups sorry dude Smile

Warning: Invalid argument supplied for foreach() in /var/www/web1117/html/install/cpg82.php on line 69

Warning: main(modules/copermine/install/cpg12rc.php) [function.main]: failed to open stream: No such file or directory in /var/www/web1117/html/install/coppermine.php on line 63

Warning: main(modules/copermine/install/cpg12rc.php) [function.main]: failed to open stream: No such file or directory in /var/www/web1117/html/install/coppermine.php on line 63

Warning: main(modules/copermine/install/cpg12rc.php) [function.main]: failed to open stream: No such file or directory in /var/www/web1117/html/install/coppermine.php on line 63

Fatal error: main() [function.require]: Failed opening required 'modules/copermine/install/cpg12rc.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/web1117/html/install/coppermine.php on line 63

Bush · Posted: Wed May 28, 2008 12:56 pm Post subject: Re: 8.2.b to update from 9.2.1

fuxa, in your profile where is shows your ServerOS/ Apache/ MySql / PHP / DragonflyCMS ...

Please provide that information. You can do that by going to "My Account" then "My Profile Information".

NanoCaiordo · Posted: Wed May 28, 2008 1:13 pm Post subject: Re: 8.2.b to update from 9.2.1

To get a proper support read our forums rules, thank you.

To upgrade:
1) put the site into maintenance
2) backup files and db
3) locally rename install.php to something.php for security
4) upload 9.1.2.1 including something.php
5) hit /something.php

If any error report the entire error please.

On failure if you want to retry:
1) restore the database only
2) hit /something.php

otherwise:
1) restore files and database

On success check:
1) delete the install directory as well as something.php from your site.
2) admin -> blocks (tip: click to activate, then drag & drop)
3) admin -> cpgmm (just refresh the page if you see something strange)
4) play around the administration and the site
5) when you feel comfortable admin -> settings -> maintenance off

thats all, let us know.

NanoCaiordo · Posted: Wed May 28, 2008 1:27 pm Post subject: Re: 8.2.b to update from 9.2.1

Well it took me a while to write the above reply ... I see where the error come from.

Before any of my previous step remove the install directory from your site as well as install.php .. I repeat: "before you do anything else remove the install directory from your site and install.php always from your site"

fuxa · Posted: Wed May 28, 2008 10:05 pm Post subject: Re: 8.2.b to update from 9.2.1

Next problem

Kann 'popmeson' nicht löschen. Existiert die Spalte oder der Schlüssel?
ALTER TABLE cms_users DROP popmeson
performing rollback:

Sad

NanoCaiordo · Posted: Thu May 29, 2008 9:06 am Post subject: Re: 8.2.b to update from 9.2.1

Try this new install/sql/upgrade/cpg8x.inc

fuxa · Posted: Thu May 29, 2008 12:47 pm Post subject: Re: 8.2.b to update from 9.2.1

the problem still exists Sad

NanoCaiordo · Posted: Thu May 29, 2008 3:40 pm Post subject: Re: 8.2.b to update from 9.2.1

Using a MySQL browser whats the Version_Num stored in config_custom table?

fuxa · Posted: Thu May 29, 2008 3:53 pm Post subject: Re: 8.2.b to update from 9.2.1

PHP:

<?php
/*********************************************
  CPG Dragonflyâ„¢ CMS
  ********************************************
  Copyright Â© 2004 - 2007 by CPG-Nuke Dev Team
  dragonflycms.org

  Dragonfly is released under the terms and conditions
  of the GNU GPL version 2 or any later version

  $Source: /cvs/html/install/sql/upgrade/tbl_config_custom.inc,v $
  $Revision: 1.4 $
  $Author: nanocaiordo $
  $Date: 2007/04/23 10:43:41 $
**********************************************/
if (!defined('INSTALL')) { exit; }

$installer->add_query('CREATE', 'config_custom', "
  cfg_name varchar(20) NOT NULL default '',
  cfg_field varchar(50) NOT NULL default '',
  cfg_value text NOT NULL,
  UNIQUE KEY unique_cfg (cfg_name,cfg_field)", 'config_custom');

if (isset($tablelist['config'])) {
  // Convert cms_config to cms_config_custom
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP copyright", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP footermsgtxt", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP email_send", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP attachmentdir", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP attachments", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP attachments_view", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP download_dir", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP defaultpopserver", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP singleaccount", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP singleaccountname", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP numaccounts", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP imgpath", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP filter_forward", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP max_upfile", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP index_foot", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP index_head", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP servermail", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP ultramode", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP anonymous", true);
  $db->sql_query("ALTER TABLE ".$prefix."_config DROP locale", true);

  $result = $db->sql_query('SELECT * FROM '.$prefix.'_config', true);
  $config = $db->sql_fetchrow($result);
  $db->sql_freeresult($result);

  if (!isset($config['main_module'])) {
	# Merge main_module table in config
	$main = 'News';
	if (isset($tablelist['main'])) {
	  $result = $db->sql_query('SELECT main_module FROM '.$prefix.'_main', true);
	  if ($result) {
		list($main) = $db->sql_fetchrow($result);
	  }
	  $installer->add_query('DROP', 'main');
	}
	$config['main_module'] = $main;
  }

  foreach($config as $var => $value) {
	if (!is_numeric($var)) {
		if (ereg('allow_html_email|smtp_on|smtp_auth|smtp_uname|smtp_pass|smtphost', $var)) {
			$installer->add_query('INSERT', 'config_custom', "'email', '$var', '$value'");
		} else if (ereg('path|domain', $var)) {
			$installer->add_query('INSERT', 'config_custom', "'server', '$var', '$value'");
		} else {
			$installer->add_query('INSERT', 'config_custom', "'global', '$var', '".Fix_Quotes($value)."'");
		}
	}
  }
  $installer->add_query('DROP', 'config');
}

if (isset($tablelist['users_config'])) {
	$result = $db->sql_query('SELECT * FROM '.$prefix.'_users_config', true);
	$user_cfg = $db->sql_fetchrow($result);
	$db->sql_freeresult($result);
	foreach($user_cfg as $key => $val) {
		if (!is_numeric($key)) {
			$installer->add_query('INSERT', 'config_custom', "'member', '$key', '".Fix_Quotes($val)."'");
		}
	}
	$installer->add_query('DROP', 'users_config');
}

NanoCaiordo · Posted: Fri May 30, 2008 8:06 am Post subject: Re: 8.2.b to update from 9.2.1

I rephrase again. Using phpMyAdmin whats the Version_Num stored in config_custom table?

fuxa · Posted: Fri May 30, 2008 1:31 pm Post subject: Re: 8.2.b to update from 9.2.1

nano see PM please!!:) thanx

fuxa · Posted: Sat May 31, 2008 7:36 am Post subject: Re: 8.2.b to update from 9.2.1

-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-6
-- www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 31. Mai 2008 um 09:38
-- Server Version: 4.0.24
-- PHP-Version: 5.2.0-8+etch1~bpo.1
--
-- Datenbank: `usr_web53_1`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `cms_config_custom`
--

CREATE TABLE `cms_config_custom` (
`cfg_name` varchar(20) NOT NULL default '',
`cfg_field` varchar(50) NOT NULL default '',
`cfg_value` text NOT NULL,
PRIMARY KEY (`cfg_field`,`cfg_name`)
) TYPE=MyISAM;

Eestlane · Posted: Sat May 31, 2008 11:07 am Post subject: Re: 8.2.b to update from 9.2.1

If being in phpMyAdmin, there is a list of tables on the left. Click the icon before the cms_config_custom (not the text itself). Then you should find Version_Num, if not there is a button for the next page, there are quite a lot stuff in the cms_config_custom table, so you might need to check second or third or whatever page aswell to find Version_Num.