Can somebody please help me integrate coppermine with invisionboard. This is chinese to me.
Thanks
CG
search the boards for "invision" or "IPB", there are many posts on the subject.
Did you read the instructions? http://coppermine.sourceforge.net/manual.php#integrating
You have to ask more specific questions.
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
FIRST I MADE SURE I INSTALLED COPPERMINE IN THE SAME TABLE AS INVISIONBOARD
I Chmod 777 albums and include
A good start is to provide us with the error messages you are getting.
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'
the above happens when I'm logged in as an admin. But as a guest I can use the e-card system
cg
/home/fightwor/public_html/ipowerb/copper/include/functions.inc.php - Line: 105
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
This board isnt slowchat. Try posting more text per post instead of posting 1 sentence per post every few minutes.
Quote from: Hein on February 03, 2005, 07:58:47 AM
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? ::)
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.
Quote from: kegobeer on February 03, 2005, 01:46:03 PM
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
Same goes as in this thread:
http://forum.coppermine-gallery.net/index.php?topic=12067.0
Quote from: Nibbler on February 03, 2005, 01:59:28 PM
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
The solution lies in your hands, you need to look at the database and modify the query to fit what you can see.
Quote from: Nibbler on February 03, 2005, 02:02:46 PM
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
Try it and see. If it breaks then try changing 'location as user_location' to ' '' AS user_location'
Quote from: Nibbler on February 03, 2005, 02:08:01 PM
Try it and see. If it breaks then try changing 'location as user_location' to ' '' AS user_location'
I'll try it now Sir. Thanks
CG
I think I see the problem. The data requested by the sql statement is not only in the members table but the member_extra table. wouldn't these two tables have the be joined based on UserID so the SQL statement is able to retrieve the databa?
CG
Quote from: mrpcpro on February 03, 2005, 01:12:20 PM
Quote from: Hein on February 03, 2005, 07:58:47 AM
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? ::)
It's my opinion on your way of posting. See it as advice to shorten the threads you open and getting a quicker answer from those who are kind enough to help out.
Quote from: Hein on February 03, 2005, 02:29:01 PM
Quote from: mrpcpro on February 03, 2005, 01:12:20 PM
Quote from: Hein on February 03, 2005, 07:58:47 AM
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? ::)
It's my opinion on your way of posting. See it as advice to shorten the threads you open and getting a quicker answer from those who are kind enough to help out.
I understand, but your smart ass "this isn't slow chat" comment was necessary. I'm trying to do the best I can, I'm sorry that doesn't please you.
CG
I think I know what I'm going to try. Since I know joined isn't a field I'll replace it with another field I know exists. I'll let you know when I blow up my computer
well that did the trick! I replaced the fields that I know don't exist in the members table with fields I know do exist. Obviously what would be better would be to join members and members extra table to get the original query to work.
Any ideas on how to do that? Hein, you've been brilliant so far. Maybe you have some ideas?
QuoteCome 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.
That's another way of saying it. Seeing how well you take advice on how to post i wish you the best of luck with coppermine and this board. You might want to read the HowTo on posting on this board while your at it.
Quote from: Hein on February 03, 2005, 03:09:03 PM
QuoteCome 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.
That's another way of saying it. Seeing how well you take advice on how to post i wish you the best of luck with coppermine and this board. You might want to read the HowTo on posting on this board while your at it.
Well I did do that. After he explained why it was better I immediately posted everything in one shot.
I think you are the one with the problem. Not everyone can take jokes very well. Your first post was to make fun of me rather then help. If this is your contribution to my question then why bother? I'm not being nasty or anything to you. I simply said I needed help and you just make fun of me. That's not fair.
Anyway, I really don't understand why those fields are requested in the SQL statement because they are not used in the e-card system. Pretty silly if you ask me
I hope my solution helps somebody. It's not the greatest solution, but it's certainly better then "IT'S UP TO YOU TO FIX IT" answers I've seen.
I guess the biggest problem with Invision board support is that you have to buy Invision Board in order to understand what someone is experiencing. So it must be hard for the open source people to integrate with this board without having to spend lots of $$$
I really think it sucks that Invision board is paid now, but it's a pretty amazing board with tons of options.I hope SMF becomes better and stays free so I can switch over to this board. It's pretty nice.
Finally, I still don't know why that SQL statement asks for location, website, and other stuff because it doesn't use it. Maybe it's somewhere else and I can't find it.
I'll report back to see if I can find it
simple enough, it's under Profile. When you pull up a user's profile you get the results of the fields I substituted. For "Location in user_location" is used "posts in user_location" so when you pull up a profile rather then "location" you will get "posts". So to fix the error you would have to join members and members_extra table and then run the original query.
The above is just my guess.
CG
Just for the sake of argument. My first post was not ment to make fun of you but merely to point out you were kinda flooding the thread with one-liners, as kegobeer points out as wel. EOF
Quote from: Hein on February 03, 2005, 04:00:43 PM
Just for the sake of argument. My first post was not ment to make fun of you but merely to point out you were kinda flooding the thread with one-liners, as kegobeer points out as wel. EOF
OK. Thanks Hein. I guess it was my mistake. Sorry
CG