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
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.
ok, here is the error message:
QuoteFatal 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
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
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.
get a tool like phpMyAdmin and check if the table is actually there!
GauGau
Hi
I have same problem
QuoteWhile 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
if you get
QuoteFatal 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
Quote from: "gaugau"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
_____________________________________________________________
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