I'M AN IDIOT PLEASE HELP

[mrpcpro]

Can somebody please help me integrate coppermine with invisionboard. This is chinese to me.

Thanks

CG

[donnoman]

search the boards for "invision" or "IPB", there are many posts on the subject.

[Tranz]

Did you read the instructions? http://coppermine.sourceforge.net/manual.php#integrating

You have to ask more specific questions.

[mrpcpro]

I read the instructions. Coppermine works fine without the integration. As soon as I integrate I get weird errors. LIke I can't use the e-card system. I'm going to install it again then give you my files to look at.

CG

[mrpcpro]

FIRST I MADE SURE I INSTALLED COPPERMINE IN THE SAME TABLE AS INVISIONBOARD

[mrpcpro]

I Chmod 777 albums and include

[Tranz]

A good start is to provide us with the error messages you are getting.

[mrpcpro]

While executing query "SELECT name as user_name, mgroup, email as user_email, joined as user_regdate, location as user_location, interests as user_interests, website as user_website FROM `fightwor_ipowerb`.ibf_members WHERE id = '335'" on 0

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

[mrpcpro]

the above happens when I'm logged in as an admin. But as a guest I can use the e-card system

cg

[mrpcpro]

/home/fightwor/public_html/ipowerb/copper/include/functions.inc.php - Line: 105

[mrpcpro]

actually it happens checking groups I guess. When I don't login I can access e-card system. When I login I get the error above.

CG

[Hein Traag]

This board isnt slowchat. Try posting more text per post instead of posting 1 sentence per post every few minutes.

[mrpcpro]

This board isnt slowchat. Try posting more text per post instead of posting 1 sentence per post every few minutes.

Is this your professional guess at what's the problem? 

[kegobeer]

Come on man, help us out.  It's so much easier to read when you compose a complete message instead of posing several one line messages.

[mrpcpro]

Come on man, help us out.  It's so much easier to read when you compose a complete message instead of posing several one line messages.

So here it is all in one shot.

I installed Coppermine in the invision board database, I edited the files that come with coppermine 1.3.2 and uploaded them to the correct directory. When I login to Invisionboard then go to the coppermine index.php it logs me in automatically. I knows I'm an admin and all of the features seem to work fine except that as soon as I try to use the e-card system I get this error:

While executing query "SELECT name as user_name, mgroup, email as user_email, joined as user_regdate, location as user_location, interests as user_interests, website as user_website FROM `fightwor_ipowerb`.ibf_members WHERE id = '335'" on 0

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


File: /home/fightwor/public_html/ipowerb/copper/include/functions.inc.php - Line: 105


Here is the debug info:

USER:
------------------
Array
(
    [ID] => 231ef02fb25b7c182e10805d243b28c6
    [am] => 1
    [liv] => Array
        (
           

• => 1
              [1] => 2
              [2] => 3
          )
  
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
     
• => 335
      [user_id] => 335
      [1] => Cupey Alto
      [user_name] => Cupey Alto
      [2] => 4
      [mgroup] => 4
      [3] => 4
      [group_id] => 4
      [4] => Admin
      [group_name] => Admin
      [5] => 0
      [group_quota] => 0
      [6] => 0
      [has_admin_access] => 1
      [7] => 1
      [can_rate_pictures] => 1
      [8] => 1
      [can_send_ecards] => 1
      [9] => 1
      [can_post_comments] => 1
      [10] => 1
      [can_upload_pictures] => 1
      [11] => 1
      [can_create_albums] => 1
      [12] => 0
      [pub_upl_need_approval] => 0
      [13] => 0
      [priv_upl_need_approval] => 0
      [14] => 0
      [upload_form_config] => 0
      [15] => 0
      [custom_user_upload] => 0
      [16] => 5
      [num_file_upload] => 5
      [17] => 3
      [num_URI_upload] => 3
      [groups] => Array
          (
             
• => 4
          )
  
      [can_see_all_albums] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content FROM cpg132_filetypes;
      [1] => SELECT member_id as user_id, member_name as user_name, member_group as mgroup FROM `fightwor_ipowerb`.ibf_sessions WHERE id = 'fe164e0a903d9e0a42d9f0b133439362' AND ip_address = '24.44.21.178'
      [2] => SELECT * FROM cpg132_usergroups WHERE group_id = '4'
      [3] => DELETE FROM cpg132_banned WHERE expiry < 1107435173
      [4] => SELECT * FROM cpg132_banned WHERE ip_addr='24.44.21.178' OR ip_addr='24.44.21.178' OR user_id=335
      [5] => SELECT name as user_name, mgroup, email as user_email, joined as user_regdate, location as user_location, interests as user_interests, website as user_website FROM `fightwor_ipowerb`.ibf_members WHERE id = '335'
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
      [album] => 1
      [pid] => 1
      [pos] => 0
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.3.10 - OK
  ------------------
  mySQL version: 4.0.23-standard
  ------------------
  Coppermine version: 1.3.2
  ==========================
  Module: gd
  ------------------
  GD Support enabled
  GD Version bundled (2.0.28 compatible)
  FreeType Support enabled
  FreeType Linkage with freetype
  GIF Read Support enabled
  GIF Create Support enabled
  JPG Support enabled
  PNG Support enabled
  WBMP Support enabled
  XBM Support enabled
  ==========================
  Module: mysql
  ------------------
  Active Persistent Links 1
  Active Links 2
  Client API version 3.23.49
  MYSQL_MODULE_TYPE builtin
  MYSQL_SOCKET /var/tmp/mysql.sock
  MYSQL_INCLUDE no value
  MYSQL_LIBS no value
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.1.4
  Linked Version 1.1.4
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | Off
  safe_mode_exec_dir | no value | no value
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | no value | no value
  sql.safe_mode | Off | Off
  disable_functions | no value | no value
  file_uploads | On | On
  include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
  open_basedir | no value | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | no value | no value
  sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 30 | 30
  max_input_time | -1 | -1
  upload_max_filesize | 2M | 2M
  post_max_size | 55M | 55M
  ==========================
  Page generated in 0.035 seconds - 6 queries in 0.001 seconds - Album set :
  
  
  
  
  I hope that helps. I do appreciate the support. I didn't want to sound foolish, and the reason I did one line per post was in case I made a mistake during the process.
  
  
  CG
  
  
  
  
  

[Nibbler]

Same goes as in this thread:

http://forum.coppermine-gallery.net/index.php?topic=12067.0

[mrpcpro]

Same goes as in this thread:

http://forum.coppermine-gallery.net/index.php?topic=12067.0

I see, but that problem has no resolution? Is this the same case for my problem?

CG

[Nibbler]

The solution lies in your hands, you need to look at the database and modify the query to fit what you can see.

[mrpcpro]

The solution lies in your hands, you need to look at the database and modify the query to fit what you can see.

would removing that portion of the query damage the program, in your opinion?

CG

[Nibbler]

Try it and see. If it breaks then try changing 'location as user_location' to ' '' AS user_location'