PHPNuke5.5 & CPG 1.1D probs with phpmyadmin

[VirtuAl]

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

[DJMaze]

Do you use an added module that also added "user_group_cp" field to nukes_users table ?

[gtroll]

I didn't notice you are using Nuke version 5.5 have you checked the old board
Also did you read this in the installation file Installation-english.txt

4-As you have phpnuke 5.x/6.0 you must do a small modification:
in modules/Your_Account/index.php about line 112 replace:

Code Select Expand


$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);

by:

Code Select Expand


$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);


[VirtuAl]

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

[VirtuAl]

coppermine still doesn´t run and i don´t know why.
plz help !!

 

[VirtuAl]

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

[sigi]

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 .--..-

[VirtuAl]

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 ??

[gtroll]

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

[DJMaze]

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.

[VirtuAl]

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:

[DJMaze]

Which CPG1.1D the package contains 2 versions

[VirtuAl]

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.

[DJMaze]

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 ?

[VirtuAl]

yes
yes
yes

i controlled the entries once again.

[DJMaze]

turn on debug mode and give us a url

[VirtuAl]

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 ?

[VirtuAl]

i killed all cookies loaded all new, logged in again
and it runs !

thx @ all !!!

[aptivous]

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

[aptivous]

Also VirtualAl what steps did you take to solve your problem, I seem to have the same issues as you had