Print

[ilbt]

I just installed my gallery and integrated it into my invision forum.  I get the following error when I try to login in or view my gallery.  any help is greatly appreciated.

Fatal error :
There was an error while processing a database query

[Joachim Müller]

as you can't get into the config right now, edit init.inc.php and turn the integration off for the moment (putt the // back in). Then log into coppermine standalone (with the username/pw you created on installation) and switch debug_mode on in coppermine config. Afterwards you log out and turn bbs integration back on (init.inc.php). Check what the debug output says (copy-and-paste it into your posting/reply here).

GauGau

[ilbt]

hi.

ok, here is the error message:

Fatal error :

There was an error while processing a database query.

While executing query "SELECT id as user_id, name as user_name, mgroup FROM `dormadsc_Bg4r`.ibf_members WHERE id='0' AND password='*'" on 0

mySQL error: Table 'dormadsc_Bg4r.ibf_members' doesn't exist

[Joachim Müller]

Well, the error says it clearly: the table doesn't exist!
Did you try to have mySQL tables with dots in the table name? This won't work!

GauGau

[ilbt]

Well, I know nothing about mysql or php.  so I'm kinda lost at the moment here.  My forum has been running on this database for almost a year now without any problems, so I'm confused why I'm getting this error.  I don't remember creating any tables with dots in the name.  

Can you tell me what I can do?  create a new table?  If so how?

I really want to get my gallery up and running.  Thanks.

[Joachim Müller]

get a tool like phpMyAdmin and check if the table is actually there!

GauGau

[Kronberg]

Hi

I have same problem

While executing query "SELECT user_id, username as user_name, user_level FROM `thaidatabase`.phpbb_users WHERE user_id='0' AND user_password='*'" on 0

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

And I have not a dot in the database name, and it is actually there when I look in MYSQL

What can I do???

Regards, Robert

[Joachim Müller]

if you get

Fatal error :
There was an error while processing a database query

go to coppermine config, switch debug_mode on (at the very bottom of the page) and check the debug output - it should give you an idea what query fails...

GauGau

[tatapx]

as you can't get into the config right now, edit init.inc.php and turn the integration off for the moment (putt the // back in). Then log into coppermine standalone (with the username/pw you created on installation) and switch debug_mode on in coppermine config. Afterwards you log out and turn bbs integration back on (init.inc.php). Check what the debug output says (copy-and-paste it into your posting/reply here).

GauGau

Hi,

I have the same problem and follwed your tip to enable debug. Got the error below. (I edited my IP below)

Fatal error :

There was an error while processing a database query.

_____________________________________________________________
While executing query "SELECT member_id as user_id, member_name as user_name, member_group as mgroup FROM `dbase`.ibf_sessions WHERE id = 'd5b2169084320b59ce67603f5ba90528' AND ip_address = '203.x.x.x'" on 0

mySQL error: Table 'dbase.ibf_sessions' doesn't exist
_____________________________________________________________

[tatapx]

Ooops, I got it. I need to edit the line below in invisionboard.inc.php as I didn't took the default when I set up Invision.

Thanks.

define('IB_TABLE_PREFIX', 'ibf_'); // The prefix used for the DB tables

to

define('IB_TABLE_PREFIX', 'forum_'); // The prefix used for the DB tables