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:
QuoteCritical 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:
QuoteThe 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.
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...
Still didnt worked. I solved it just alter the tables in phpmyadmin instead. Solved the problem though :)
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?
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.
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
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?
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...
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....
Quote from: "11d-coppermine.sql"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]
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.
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.
Looks like, the install was able to make that change even though it screamed
run:
QuoteALTER 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
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:
the sql error is:
mySQL error: Unknown column 'user_group_list_cp' in 'field list'
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.
I guess I had that coming as I didnt delete the themes ;-)