Error Querying Database.. Xoops bridged to coppermine 1.4.2

[foz]

I have the following problem when bridging Xoops 2.2.3 final with Coppermine 1.4.2 when I try to use the ecard or report feature.
These features work fine with the bridge disabled.
Also I have tried it with and without post based groups.  Changing that made no difference.

Also using search I did not find a similar problem

Critical error

There was an error while processing a database query.






While executing query "SELECT uname AS user_name,
                              email AS user_email,
                              user_regdate AS user_regdate,
                              '' AS user_location,
                              url AS user_website
                              
                              FROM  `databasename`.***_users WHERE uid = '1'" on Resource id #6

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



File: /****/******/public_html/testsite/cpg142/include/functions.inc.php - Line: 248

Thanks for your help in advance
foz


Coppermine install: http://www.thewoodlandsmonitor.com/testsite/cpg142
Forum install: http://www.thewoodlandsmonitor.com/testsite
Coppermine version: 1.4.2
Forum Version:  Xoops 2.2.3 final
Test user account: Testuser/test

Bridgemanager settings:
Forum URL:  http://www.thewoodlandsmonitor.com/testsite 
Relative path to your BBS's config file:  ../ 
Use post-based groups?:  0 

[Nibbler]

Edit bridge/xoops.inc.php

find

Code Select Expand

'regdate' => 'user_regdate', // name of 'registered' field in users table

change to

Code Select Expand

'regdate' => "''", // name of 'registered' field in users table

[foz]

Thanks for that info nibbler


Just correcting that one line was not all that was wrong apparently.

I also had to modify this line

'website' => 'url', // name of 'website' field in users table

to

'website' => "''", // name of 'website' field in users table

Thanks to your initial response I was able to fire up some brain cells and figure out the second problem.

Thanks a ton Nibbler


Foz