[x] Navigation

[x] Languages

[x] Design
Each user can view the site with a different theme.
Themes marked with a * also change the forum look.

Fehlr beim Upgrade Nuke 6.8 auf CPG 8.1.1

This forum is locked: you cannot post, reply to, or edit topics.    This topic is locked: you cannot edit posts or make replies.    Printer Friendly Page     Forum Index ›  Installation

View previous topic :: View next topic  
Author Message
Horrid
Investigator
Investigator

Offline Offline
Joined: Apr 21, 2004
Posts: 2

PostPosted: 21.04.2004 10:15
Post subject: Fehlr beim Upgrade Nuke 6.8 auf CPG 8.1.1

Bekomme beim Upgradevorgang von Nuke 6.8 auf CPG 8.1.1 folgende Meldungen:

Array:
ALTER TABLE cms4u_users ADD `user_active_cp` ENUM('YES', 'NO') DEFAULT 'YES' NOT NULL, ADD `user_regdate_cp` DATETIME NOT NULL	mySQL Error: Doppelter Spaltenname vorhanden: 'user_active_cp'
UPDATE cms4u_banner SET cid=2 WHERE cid=	mySQL Error: Fehler in der Syntax bei '' in Zeile 1.
UPDATE cms4u_banner SET cid=4 WHERE cid=	mySQL Error: Fehler in der Syntax bei '' in Zeile 1.
UPDATE cms4u_banner SET cid=6 WHERE cid=	mySQL Error: Fehler in der Syntax bei '' in Zeile 1.
UPDATE cms4u_banner SET cid=8 WHERE cid=	mySQL Error: Fehler in der Syntax bei '' in Zeile 1.

Frage 1
Der doppelte Spaltenname kommt in der Tabelle cms4u_users und in der Tabelle cpg_users (Coppermine Gallery 1.1d) vor. Kennt jemand dieses Problem und gibt es daf


Horrid please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile Visit poster's website
Ertan
Webmaster
Webmaster

Offline Offline
Joined: Mar 19, 2004
Posts: 1264
Location: Germany
PostPosted: 21.04.2004 12:02
Post subject: Re: Fehlr beim Upgrade Nuke 6.8 auf CPG 8.1.1

hi,

in install/upgrade.php

line 160 :
you find this:

######################################
# #
# Coppermine Photo Gallery #
# #
######################################
if (!mysql_query("SELECT dirname FROM cpg_installs LIMIT 0", $db->db_connect_id)) {
if (!mysql_query("SELECT dirname FROM ".$prefix."_cpg_installs LIMIT 0", $db->db_connect_id)) {
require('install/coppermine.php');
if (mysql_query("SELECT user_group_cp FROM ".$user_prefix."_users LIMIT 0", $db->db_connect_id)) {
$sql[] = "ALTER TABLE ".$user_prefix."_users DROP user_group_cp";
}
$sql[] = "ALTER TABLE ".$user_prefix."_users ADD `user_group_cp` INT(11) NOT NULL DEFAULT '2' NOT NULL, ADD `user_group_list_cp` varchar(100) NOT NULL DEFAULT '2' NOT NULL"; $sql[] = "ALTER TABLE ".$user_prefix."_users ADD `user_active_cp` ENUM('YES', 'NO') DEFAULT 'YES' NOT NULL, ADD `user_regdate_cp` DATETIME NOT NULL";
$sql[] = "UPDATE ".$user_prefix."_users SET user_group_cp='3', user_group_list_cp = '3' WHERE user_id='-1'";
$sql[] = "UPDATE ".$user_prefix."_users SET user_group_cp='3', user_group_list_cp = '3' WHERE user_id='1'";
$sql[] = "UPDATE ".$user_prefix."_users SET user_group_cp='1' WHERE user_id='2'";
}
}


the bold line comment it out

means // before this line
:

// $sql[] = "ALTER TABLE ".$user_prefix."_users ADD `user_group_cp` INT(11) NOT NULL DEFAULT '2' NOT NULL, ADD `user_group_list_cp` varchar(100) NOT NULL DEFAULT '2' NOT NULL";



i hope this helps

ertan


Ertan's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Send e-mail Visit poster's website Photo Gallery
Horrid
Investigator
Investigator

Offline Offline
Joined: Apr 21, 2004
Posts: 2

PostPosted: 22.04.2004 09:51
Post subject: Re: Fehler beim Upgrade Nuke 6.8 auf CPG 8.1.1

Vielen Dank f


Horrid please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile Visit poster's website
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.    This topic is locked: you cannot edit posts or make replies.    Printer Friendly Page    Forum Index ›  Installation
Page 1 of 1
All times are GMT + 1 Hour



Jump to:  


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum




Interactive software released under GNU GPL, Code Credits, Privacy Policy