I have mysql moved from windows to a linux
I found some issue after migration
all table name in windows are lowcase
for example glinks_links
while actually in linux
it should be capitalised in first letter
glinks_Links
so i fixed this problem.
I had a global, it still not fonctional while it works when host mysql in windows
. it returned "no pic" when host mysqld in linux. it seems it did not grab information sucessful
Code:
sub {
my $tags = shift;
my $file = $DB->table('Links')->file_info('image1', $tags->{ID}) or return "nopic";
return $file->File_RelativePath();
}
I have a field in table glinks_Links called image1(all letter is low case),
could anyone here give me some clue ?
Thanks