Print

[eengvig]

PHPNuke 6.9
Apache 1.3.28
MySql 4.0.16
PHP4.3.4

Extra modules:
nuCalendar 0.60
indyNews 1.1
eXtrene Guestbook 0.6.0

I used Coppermine 1.1d for phpnuke, and tried to update to coppermine 1.2.1 for phpnuke. Unzipped coppermine 1.2.1 files, deleted other themes from coppermine 1.1d folder. Copied Coppermine 1.2.1 to my root folder and opened homepage with /modules/coppermine/install.php

Installation went well, and ended up in the configuration screen for coppermine. Just applied changes after turning off debug mode etc.

And when i now try to open Coppermine i only get this error:

Critical error

There was an error while processing a database query.

While executing query "SELECT cid, catname, description FROM cpg_categories WHERE parent = ''  ORDER BY pos" on 0

mySQL error: Unknown column 'catname' in 'field list'
 

File: c:\program files\apache group\apache\htdocs\modules\coppermine\include\functions.inc.php - Line: 101

What did I do wrong, and tell me if there is some more information needed. And i do have chosen the default theme. Some answers here on the forum says install-english.txt and install/php, but when i run install.php again, it says that:

The installer is locked
? ? ? ERROR ? ? ?        
The install/upgrade has already been run successfuly for "coppermine" and is now locked.

The url for the page is: http://www.engvig.tk which is a referrer for
http://CPE-203-45-242-111.qld.bigpond.net.au And the link further is "Bilder" which means pictures in norwegian btw.

Thanks for help in advance.

[gtroll]

the install failed.
the first query in the upgrade script  is
ALTER TABLE cpg_categories CHANGE `namee` `catname` VARCHAR(255) NOT NULL;
with about twenty others ending with
cpg_config : allow_anon_fullsize

check your config table:
SELECT * FROM `cpg_config` WHERE `name` = 'allow_anon_fullsize';
(changing the cpg_ to your prefix)
if no results delete table cpg_installs and try install again.
otherwise post back...

[eengvig]

Still didnt worked. I solved it just alter the tables in phpmyadmin instead. Solved the problem though

[marlloyd]

Have the same problem, had to go back to 1.1D as I could not understand what is required to manually install this.

What exactly do I have to change in the tables to make this work?

[Ivo2]

Hi,

I have had the same problem. Upgrade from 1.1D to 1.2.1 is something not working. On my "testpage" where I've upgrade from 1.1D to 1.2.0rc2 and than to rc4 to rc5 all tables would be installed.

Code: [Select]

ALTER TABLE cpg_categories CHANGE `namee` `catname` VARCHAR(255) NOT NULL;

ALTER TABLE cpg_comments add msg_raw_ip tinytext;
ALTER TABLE cpg_comments add msg_hdr_ip tinytext;
ALTER TABLE cpg_pictures add pic_raw_ip tinytext;
ALTER TABLE cpg_pictures add pic_hdr_ip tinytext;

UPDATE cpg_config SET value= '1' WHERE name='debug_mode';
INSERT INTO cpg_config VALUES ('thumb_use', 'any');
INSERT INTO cpg_config VALUES ('show_private', '0');
INSERT INTO cpg_config VALUES ('first_level', '1');
INSERT INTO cpg_config VALUES ('display_film_strip', '1');
INSERT INTO cpg_config VALUES ('max_film_strip_items', '5');
INSERT INTO cpg_config VALUES ('comment_email_notification', '1');
INSERT INTO cpg_config VALUES ('nice_titles', '1');
INSERT INTO cpg_config VALUES ('advanced_debug_mode', '1');
INSERT INTO cpg_config VALUES ('read_iptc_data', '0');
INSERT INTO cpg_config VALUES ('picinfo_display_filename', '1');
INSERT INTO cpg_config VALUES ('picinfo_display_album_name', '1');
INSERT INTO cpg_config VALUES ('picinfo_display_file_size', '1');
INSERT INTO cpg_config VALUES ('picinfo_display_dimensions', '1');
INSERT INTO cpg_config VALUES ('picinfo_display_count_displayed', '1');
INSERT INTO cpg_config VALUES ('picinfo_display_URL', '1');
INSERT INTO cpg_config VALUES ('picinfo_display_URL_bookmark', '1');
INSERT INTO cpg_config VALUES ('picinfo_display_favorites', '1');
INSERT INTO cpg_config VALUES ('seo_alts', '0');
INSERT INTO cpg_config VALUES ('reg_notify_admin_email', '0');
INSERT INTO cpg_config VALUES ('disable_flood_protection', '0');
INSERT INTO cpg_config VALUES ('allow_anon_fullsize', '1');
UPDATE cpg_config SET value = 'breadcrumb/catlist/alblist/lastalb,1/lastup,1/lastcom,1/topn,1/toprated,1/random,1/anycontent' WHERE name = 'main_page_layout';
UPDATE cpg_config SET value = 'default' WHERE name = 'theme';
that must be the sql codes
copy and paste it in your mysqladmin
regards
Ivo

[marlloyd]

I couldnt even get past the first line when I pasted it in. I don't have any such entry called namee in my cpg_categories table.

Is there something else I am missing before these steps?

[gtroll]

The point of the first line is to rename the field namee with catname
do that manually in phpmyadmin then run the rest of the queries..
then check that cpg_installs was created and tell me what values are there...

[gtroll]

ok I missed that ...no field named namee what is the field name that lists the category name in your version 1.1d had namee....

CREATE TABLE cpg_categories (
  cid int(11) NOT NULL auto_increment,
  owner_id int(11) NOT NULL default '0',
  namee varchar(255) NOT NULL default '',
  description text NOT NULL,
  pos int(11) NOT NULL default '0',
  parent int(11) NOT NULL default '0',
  subcat_count int(11) NOT NULL default '0',
  alb_count int(11) NOT NULL default '0',
  pic_count int(11) NOT NULL default '0',
  stat_uptodate enum('YES','NO') NOT NULL default 'NO',
  PRIMARY KEY  (cid),
  KEY cat_parent (parent),
  KEY cat_pos (pos),
  KEY cat_owner_id (owner_id)
) TYPE=MyISAM;

[size=20]Do not use this sql it is from 1.1d!!!![/size]

[marlloyd]

I have the following fields in cpg_categories:

   cid  int(11)  
   owner_id  int(11)
   catname  varchar(255)
   description  text
   pos  int(11)
   parent  int(11)
   subcat_count  int(11)
   alb_count  int(11)
   pic_count  int(11)
   stat_uptodate  

Perhaps I missed a step in the upgrade from the previous version to 1.1D? Was there some database change to 1.1D, I can't recall.

[marlloyd]

Looking at the sql script it seems as if I did not import that into the last update. Strange as it seemed to be working on 1.1D without any apparent problems.

In any case it looks like I will have to update the database. Should update the database with the script that is included with 1.1D or something newer in the lastest version?

Also, is there any recommended way to push all the current data into the new format. ie. comments, pictures.

[gtroll]

Looks like, the install was able to make that change even though it screamed
run:

ALTER TABLE cpg_comments add msg_raw_ip tinytext;
ALTER TABLE cpg_comments add msg_hdr_ip tinytext;
ALTER TABLE cpg_pictures add pic_raw_ip tinytext;
ALTER TABLE cpg_pictures add pic_hdr_ip tinytext;

UPDATE cpg_config SET value= '1' WHERE name='debug_mode';
INSERT INTO cpg_config VALUES ('thumb_use', 'any');
INSERT INTO cpg_config VALUES ('show_private', '0');
INSERT INTO cpg_config VALUES ('first_level', '1');
INSERT INTO cpg_config VALUES ('display_film_strip', '1');
INSERT INTO cpg_config VALUES ('max_film_strip_items', '5');
INSERT INTO cpg_config VALUES ('comment_email_notification', '1');
INSERT INTO cpg_config VALUES ('nice_titles', '1');
INSERT INTO cpg_config VALUES ('advanced_debug_mode', '1');
INSERT INTO cpg_config VALUES ('read_iptc_data', '0');
INSERT INTO cpg_config VALUES ('picinfo_display_filename', '1');
INSERT INTO cpg_config VALUES ('picinfo_display_album_name', '1');
INSERT INTO cpg_config VALUES ('picinfo_display_file_size', '1');
INSERT INTO cpg_config VALUES ('picinfo_display_dimensions', '1');
INSERT INTO cpg_config VALUES ('picinfo_display_count_displayed', '1');
INSERT INTO cpg_config VALUES ('picinfo_display_URL', '1');
INSERT INTO cpg_config VALUES ('picinfo_display_URL_bookmark', '1');
INSERT INTO cpg_config VALUES ('picinfo_display_favorites', '1');
INSERT INTO cpg_config VALUES ('seo_alts', '0');
INSERT INTO cpg_config VALUES ('reg_notify_admin_email', '0');
INSERT INTO cpg_config VALUES ('disable_flood_protection', '0');
INSERT INTO cpg_config VALUES ('allow_anon_fullsize', '1');
UPDATE cpg_config SET value = 'breadcrumb/catlist/alblist/lastalb,1/lastup,1/lastcom,1/topn,1/toprated,1/random,1/anycontent' WHERE name = 'main_page_layout';
UPDATE cpg_config SET value = 'default' WHERE name = 'theme';

If it stops(error) on one, skip to next, run.... please let us know exactely what happens... thanks

[marlloyd]

Everything is fine except for the following error which I get when I select Users -> Edit


While executing query "SELECT username, user_active_cp, user_group_cp, user_group_list_cp FROM nuke_users WHERE user_id = '25'" on 0

mySQL error:

[marlloyd]

the sql error is:


mySQL error: Unknown column 'user_group_list_cp' in 'field list'

[marlloyd]

oops, the whole thing crashed when I tried to change the theme to waterdrop, with the following error:

Fatal error: Cannot redeclare pageheader() (previously declared in /data/members/paid/d/g/dgs-gouda.org/htdocs/www/modules/coppermine/include/functions.inc.php:175) in /data/members/paid/d/g/dgs-gouda.org/htdocs/www/modules/coppermine/themes/water_drop/theme.php on line 660

Am trying to push back the default setting into the database right now.

[marlloyd]

I guess I had that coming as I didnt delete the themes ;-)