Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

problem in moving from windows to linux

Quote Reply
problem in moving from windows to linux
     

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

Last edited by:

courierb: May 12, 2012, 10:53 PM
Quote Reply
Re: [courierb] problem in moving from windows to linux In reply to
Hi,

Mmm.. have you checked the table glinks_Links_Files? There will be a field in there that references the field name. It could be that its got broken (not sure why Windows uses lowercase tables - as thats messes up a LOT of stuff on the inner code!)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [courierb] problem in moving from windows to linux In reply to
Hi courerb,

The issue with the capital letters is from windows, it's just case insensitive on file system level.

As for file table, have you checked if the proper path is set in File_Directory field in Links_Files and file_save_in in def file for glinks_Links?

Cheers,
Boris

Facebook, Twitter and Google+ Auth for GLinks and GCommunity | reCAPTCHA for GLinks | Free GLinks Plugins