Thread: Database access error

Hey people, thnx for this cool site, found out many interesting things...
anyway here is my problem:
well i launched dolphin 2 times. 1st try was locally (using xampp),changed the profile fields,added a couple of users just to test this thing and everything worked out pretty well (well, except the email notification,i dont have a mail server installed on my windows pc)
here is the interesting part
i launch/install dolphin on my linux server. From the admin point of view everything worked out pretty well...added profile fields etc(i have a mail server working) and then, from the moment i registered a new (first to be exact) user, everytime the user tries to log i get a database access error(sth that never happened locally), and user has no access to control panel plus from admin when admin tries to view the users profile, i get the same error...
from search any user can see the profile i made...
so any ideas why i get this error??
(ps:all mods were set according to the instructions)
thnx in advance,
vicky

mySQL on windows changes your table names to all lower case. This works ok on windows - windows does not care...

on linux, it matters - so if you upload a database that was running on a windows install of mySQL - you will need to fix the table names as they were in the original configuration.

you can play around with the mysql value for
lower_case_tablenames
on windows - but my experience is that does not work.

So, in general, if you move a DB between windows mysql and linux mysql - you will have problems unless you fix the table names.

In GPLdate - we are fixing this... this affects aeDating and Dolphin due to poor database design.

Smoge

if you are using xampp, you can use the mercury mail. just start the mercury mail server at the xampp control panel..... and configure/add users in the mail server by running mercury.exe at "(xampp_folder)\mercurymail".


after which, configure ms outlook. add email accounts at >tools>email accounts
choose pop3.....
127.0.0.1 for pop3 and smtp. email should be [email]@localhost.

then you can test dolphin locally.

i have database access errors once, and it occurred when i removed some fields
in the user's profile.

if you have done the same, an email must have been automatically sent to you by the script regarding the error/bug. It contains the possible error.

likewise, you can view the error by adding:
"echo PrintErr("Error in $_SERVER[PHP_SELF]: " . mysql_error());"

after

"echo PrintErr( 'Database access error' );"

in the functions in inc/db.inc.php.
*(this is for testing purposes only and should be removed when site goes on operation)

i hope this would help.

God bless.

Originally Posted by nathan

i have database access errors once, and it occurred when i removed some fields
in the user's profile.

if you have done the same, an email must have been automatically sent to you by the script regarding the error/bug. It contains the possible error.

likewise, you can view the error by adding:
"echo PrintErr("Error in $_SERVER[PHP_SELF]: " . mysql_error());"

after

"echo PrintErr( 'Database access error' );"

in the functions in inc/db.inc.php.
*(this is for testing purposes only and should be removed when site goes on operation)

i hope this would help.

God bless.

Thanks I was battling to find where my error was till you showed me this neat trick.
Helped pinpoint the error in no time