Hello !
wenn i try to import the coppermine.sql in my nuke db
i always get the following error message:
Duplicate column name 'user_group_cp'
i ofcourse use the original coppermine.sql but it doesn´t work.
please help
VirtuAl
Do you use an added module that also added "user_group_cp" field to nukes_users table ?
I didn't notice you are using Nuke version 5.5 have you checked the old board (http://coppermine.sourceforge.net/oldboard/)
Also did you read this in the installation file Installation-english.txt
Quote4-As you have phpnuke 5.x/6.0 you must do a small modification:
in modules/Your_Account/index.php about line 112 replace:
$result = sql_query("insert into ".$user_prefix."_users values[/quote] (NULL,'','$uname','$email','','$url','$user_avatar','$user_regdate','$user_icq','$user_occ','$user_from','$user_intrest','$user_sig','$user_viewemail','','$user_aim','$user_yim','$user_msnm','$cryptpass','$storyhome','','0','0','0','','0','','$Default_Theme','$commentlimit','0','0','0','0','0','1','1','0')", $dbi);
Quoteby:
$result = sql_query("insert into ".$user_prefix."_users values (NULL,'','$uname','$email','','$url','$user_avatar','$user_regdate','$user_icq','$user_occ','$user_from','$user_intrest','$user_sig','$user_viewemail','','$user_aim','$user_yim','$user_msnm','$cryptpass','$storyhome','','0','0','0','','0','','$Default_Theme','$commentlimit','0','0','0','0','0','1','1','0','','','','')", $dbi);
what is the added module which should make the table entries and where can i get it ?
i use the normal cpg1.1D package - nothing else.
is that right that i have to run an app called "image magick"?
or does cpg also run without that tool ?
I have done the modifications noticed in the Installation-english.txt
coppermine still doesn´t run and i don´t know why.
plz help !!
:(
sorry i missunderstood the upper posting.
no i dont´t habe any other module running in my phpnuke which could create the same table.
the 'user_group_cp' doesn´t exist but the error still appears
if you have NOT installed any other module that makes use of the field user_group_cp, but the installation if the coppermine.sql fails with this message, then make a backup of your table and then delet this field. then try again .--..-
ok, now i´ve modified the sql db a little bit.
when i build and activate the coppermine block the following error message appears:
Warning: Undefined index: debug_mode in C:\apache\htdocs\functions.inc.php on line 123
Template error
Failed to find block 'file_line'(#(<!-- BEGIN file_line -->)(.*?)(<!-- END file_line -->)#s) in :
the line 123 of the functions.inc.php looks like this:
if(!$CONFIG['debug_mode']) template_extract_block($template_cpg_die, 'file_line');
doesn´t seam to be an unsolveable error - only a template.
but where can i get or how can i create this template ?????
update your english file the prob is Warning: Undefined index: debug_mode in C:\apache\htdocs\functions.inc.php on line 123 so either debug_mode is not in english or not in the db
you probably installed wrong coppermine.sql or wrong coppermine module.
remove all cpg_ tables and the 4 last fields of the nuke_users table.
remove the modules/coppermine directory.
Upload Coppermine for phpNuke 5.5-6.0 NOT for 6.5
Go to you nuke database and install coppermine.sql for Nuke 5.5-6.0 NOT for 6.5 in that database.
Everything should work now.
I am using cpg1.1d for 5.5-6.0 for shure !
i deleted the cpg tables but i wasn´t able to erease the last 4 lines in the user_table.
i imported the coppermine.sql again.
this time without an error.
but the
Warning: Undefined index: debug_mode in C:\apache\htdocs\functions.inc.php on line 123
Template error
Failed to find block 'file_line'(#(<!-- BEGIN file_line -->)(.*?)(<!-- END file_line -->)#s) in :
is still remaining...... :cry:
Which CPG1.1D the package contains 2 versions
i am using Coppermine 1.1D for PHPNuke 5.5-6.0
the 2nd version in this package is for PHPNuke6.5 - i ignored this version.
should be alright.
did you setup modules/coppermine/include/config.inc.php properly ?
are the cpg_ tables in same database as nuke ?
is the user table named nuke_users ?
yes
yes
yes
i controlled the entries once again.
turn on debug mode and give us a url
sorry, i can´t give you an url because the site is going to run only in an intranet of a big office.
Meanwhile i solved the problem, but i´ve got a new on instead.
2 include paths in the init.inc.php were set wrong.
i changed the paths and coppermine started.
the new problem:
when i want to config cpg and save it, the following error message appears:
Warning: Failed opening 'themes/default/theme.php' for inclusion (include_path='.; \apache\includes;\apache\htdocs\;\apache\htdocs\phpmyadmin') in C:\apache\htdocs\html\header.php on line 43
Fatal error: Call to undefined function: themeheader() in C:\apache\htdocs\html\header.php on line 55
any idea ?
i killed all cookies loaded all new, logged in again
and it runs !
thx @ all !!!
I have had similar errors running, At the moment I am at the stage where when i try to view an image it gives me this error:
Template error
Failed to find block 'uname_input'(#(<!-- BEGIN uname_input -->)(.*?)(<!-
Etc.
We are running PHP-Nuke 5.5 and yes, we have run the correct files to install not the 6.5 ones but have this error. I tried reloading the .sql files and came up with the same error.
We are running PhpNukeBB aswell on the site does that conflict?
Matt
Also VirtualAl what steps did you take to solve your problem, I seem to have the same issues as you had
alright, sorry for the spam. I managed to fix all these issues with just using the main theme :o Seems Water_drop doesnt work even tho we love it !