Page 1 of 1

Problem in MySQL

Posted: Fri Sep 19, 2008 3:46 am
by harshil
Hello,

I have installed dolphin at my local machine & it is working fine.
But when I uploaded those files of my server machine, I am getting error in one of the MySQL table name in my config php file where table name is specified in capital letter but in MySQL it is in lower case. But the same scenario is there in my local machine which is working fine !!

Can anybody help me ???
Its URGENT !!

Thanks !!

Re: Problem in MySQL

Posted: Fri Sep 19, 2008 5:29 am
by jayshields
Change it to match the MySQL table exactly and try it?

Re: Problem in MySQL

Posted: Fri Sep 19, 2008 6:04 am
by harshil
Thanks jay,

I will try it & notify u !

But Is there any another way or some permission problem on server to solve this ?

Re: Problem in MySQL

Posted: Fri Sep 19, 2008 6:12 am
by jayshields
It might be to do with version numbers but I don't know. You should have things like that matching exactly anyway (including case) to prevent anything like this.

Re: Problem in MySQL

Posted: Fri Sep 19, 2008 11:07 pm
by harshil
Server is in Linux & my local machine is in windows !
So, any changes to do while uploading in Linux ??

Re: Problem in MySQL

Posted: Fri Sep 19, 2008 11:31 pm
by murp3433
harshil wrote:Server is in Linux & my local machine is in windows !
So, any changes to do while uploading in Linux ??


Check out the lower_case_table_names system variable. Usually in unix like systems it is set to 0 and windows it is set to 1. what ver of mysql are you using?

Re: Problem in MySQL

Posted: Sat Sep 20, 2008 3:38 am
by harshil
Thanks !

Its working right now !!