Problem in MySQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
harshil
Forum Newbie
Posts: 13
Joined: Fri Aug 01, 2008 1:21 am

Problem in MySQL

Post 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 !!
User avatar
jayshields
DevNet Resident
Posts: 1912
Joined: Mon Aug 22, 2005 12:11 pm
Location: Leeds/Manchester, England

Re: Problem in MySQL

Post by jayshields »

Change it to match the MySQL table exactly and try it?
harshil
Forum Newbie
Posts: 13
Joined: Fri Aug 01, 2008 1:21 am

Re: Problem in MySQL

Post 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 ?
User avatar
jayshields
DevNet Resident
Posts: 1912
Joined: Mon Aug 22, 2005 12:11 pm
Location: Leeds/Manchester, England

Re: Problem in MySQL

Post 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.
harshil
Forum Newbie
Posts: 13
Joined: Fri Aug 01, 2008 1:21 am

Re: Problem in MySQL

Post by harshil »

Server is in Linux & my local machine is in windows !
So, any changes to do while uploading in Linux ??
murp3433
Forum Newbie
Posts: 4
Joined: Fri Sep 19, 2008 11:02 pm

Re: Problem in MySQL

Post 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?
harshil
Forum Newbie
Posts: 13
Joined: Fri Aug 01, 2008 1:21 am

Re: Problem in MySQL

Post by harshil »

Thanks !

Its working right now !!
Post Reply