[Solved]: Database error and notices...

[VecTreX]

I just updated my CPG1.2.1 -> 1.3.0 and I have a few problems now

First of all I get quite a lot of notices of Undefined index and Undefined variable... I have no clue why

I updated the gallery after reading the docs and it went ok, but....

When I go to Admin tools I get a database error...

Code Select Expand

While executing query "SELECT aid, category, IF(name IS NOT NULL, CONCAT('(', name, ') ',title), CONCAT(' - ', title)) AS title FROM Gallery_albums AS a LEFT JOIN ACR_members AS u ON category = (10000 + id) ORDER BY category, title" on

mySQL error: Column: 'title' in field list is ambiguous


I use Invision board integration btw

here's the debug:

Code Select Expand


USER:
------------------
Array
(
   [ID] => ecf14146f325328f323c353000c77fff
   [am] => 1
   [liv] => Array
       (
           [0] => 164
           [1] => 178
           [2] => 179
           [3] => 156
           [4] => 177
       )

)

==========================
USER DATA:
------------------
Array
(
   [0] => 1
   [user_id] => 1
   [1] => VecTreX
   [user_name] => VecTreX
   [2] => 4
   [mgroup] => 4
   [3] => 4
   [group_id] => 4
   [4] => Racing.Admin
   [group_name] => Racing.Admin
   [5] => 10000
   [group_quota] => 10000
   [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] => 0
   [custom_user_upload] => 0
   [16] => 5
   [num_file_upload] => 5
   [17] => 3
   [num_URI_upload] => 3
   [groups] => Array
       (
           [0] => 4
       )

   [can_see_all_albums] => 1
)

==========================
Queries:
------------------
Array
(
   [0] => SELECT extension, mime, content FROM Gallery_filetypes;
   [1] => SELECT id as user_id, name as user_name, mgroup FROM `racing`.ACR_members WHERE id='1' AND password='***'
   [2] => SELECT * FROM Gallery_usergroups WHERE group_id = '4'
   [3] => DELETE FROM Gallery_banned WHERE expiry < 1088055015
   [4] => SELECT * FROM Gallery_banned WHERE ip_addr='195.249.90.225' OR ip_addr='195.249.90.225' OR user_id=1
   [5] => SELECT aid, category, IF(name IS NOT NULL, CONCAT('(', name, ') ',title), CONCAT(' - ', title)) AS title FROM Gallery_albums AS a LEFT JOIN ACR_members AS u ON category = (10000 + id) ORDER BY category, title
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 4.3.4 - OK
------------------
mySQL version: 4.0.18
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.15 compatible)
FreeType Support enabled
FreeType Linkage with freetype
T1Lib Support enabled
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
JIS-mapped Japanese Font Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 4.0.18
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/usr/local/include/mysql
MYSQL_LIBS -L/usr/local/lib/mysql -lmysqlclient  
==========================
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/local/share/pear | .:/usr/local/share/pear
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 | 60 | 60
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.061 seconds - 6 queries in 0.002 seconds - Album set :


Any ideas ?

[Joachim Müller]

1) Get rid of the notices by turning debug_mode off in coppermine config.
2) What version are you actually running? Post a link

GauGau

[VecTreX]

As I already posted above I upgraded to version 1.3.0  

Anyway, I've solved the problem of the admin tools page now...

http://cvs.sourceforge.net/viewcvs.py/coppermine/stable/bridge/invisionboard.inc.php <-- revision 1.6 solved it