Hi,
Im trying to send Ecard but it fails.
Before the integration on IPB 2.0.4 it worked.
Im importing usergroups from my Data Base and i changed in the IPB bridge file
$sql = "SELECT id as user_id, name as user_name, mgroup " . "FROM " . $UDB_DB_NAME_PREFIX . IB_TABLE_PREFIX . IB_USER_TABLE . " " . "WHERE id='$cookie_uid' AND password='$cookie_pass'";to
$sql = "SELECT id as user_id, name as user_name, mgroup " . "FROM " . $UDB_DB_NAME_PREFIX . IB_TABLE_PREFIX . IB_USER_TABLE . " " . "WHERE id='$cookie_uid' AND member_login_key='$cookie_pass'";and now the Ecard function doesn´t work :(
Here is the error message:
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 `forum`.ibf_members WHERE id = '1'" on 0
mySQL error: unknown column 'location' i field list
USER:
------------------
Array
(
[ID] => 53c83d4821ab0b3e21c5bdf69ab03006
[am] => 1
[liv] => Array
(
- => 1651
[1] => 1469
[2] => 1725
[3] => 1393
[4] => 1315
)
)
==========================
USER DATA:
------------------
Array
(
- => 1
[user_id] => 1
[1] => DaxMan
[user_name] => DaxMan
[2] => 4
[mgroup] => 4
[3] => 4
[group_id] => 4
[4] => Admin
[group_name] => Admin
[5] => 100024
[group_quota] => 100024
[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] => 3
[upload_form_config] => 3
[15] => 1
[custom_user_upload] => 1
[16] => 10
[num_file_upload] => 10
[17] => 10
[num_URI_upload] => 10
[groups] => Array
(
- => 4
)
[can_see_all_albums] => 1
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content FROM cpg134_filetypes;
[1] => SELECT id as user_id, name as user_name, mgroup FROM `forum`.ibf_members WHERE id='1' AND member_login_key='**************'
[2] => SELECT * FROM cpg134_usergroups WHERE group_id = '4'
[3] => DELETE FROM cpg134_banned WHERE expiry < '2005-09-03 21:41:11'
[4] => SELECT * FROM cpg134_banned WHERE ip_addr='***.***.***.***' OR ip_addr='***.***.***.***' OR user_id=1
[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 `forum`.ibf_members WHERE id = '1'
)
==========================
GET :
------------------
Array
(
[album] => 19
[pid] => 1315
[pos] => 5
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 4.3.4 - OK
------------------
mySQL version: 4.0.17-max-debug
------------------
Coppermine version: 1.3.4
==========================
Module: gd
------------------
module doesn't exist
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 3.23.49
==========================
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 | .;c:\php4\pear | .;c:\php4\pear
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | zapp68@bredband.net | zapp68@bredband.net
sendmail_path | no value | no value
SMTP | smtp.bredband.net | smtp.bredband.net
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 5M | 5M
post_max_size | 8M | 8M
==========================
Page generated in 0.151 seconds - 6 queries in 0.01 seconds - Album set :
Please help me :\'(
//DaxMan
Are you using the 2.0 version of the IPB bridge file ?
Quote from: Nibbler on September 03, 2005, 10:08:52 PM
Are you using the 2.0 version of the IPB bridge file ?
Im using this file ( info from the header )
/*************************
Coppermine Photo Gallery
************************
Copyright (c) 2003-2005 Coppermine Dev Team
v1.1 originaly written by Gregory DEMAR
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
********************************************
Coppermine version: 1.3.4
$Source: /cvsroot/coppermine/stable/bridge/invisionboard.inc.php,v $
$Revision: 1.10 $
$Author: gaugau $
$Date: 2005/08/19 07:08:25 $
**********************************************/
Right, that file is for IPB 1.3. You need to grab the file for IPB 2 from the mods board.
Quote from: Nibbler on September 03, 2005, 10:13:54 PM
Right, that file is for IPB 1.3. You need to grab the file for IPB 2 from the mods board.
Ok...sorry to be a noob here ( it my first day ) where can i find this "mods board"
//DaxMan
Modifications/Add-Ons/Hacks (http://forum.coppermine-gallery.net/index.php?board=8.0)