Problems loading a TEXT field

2004-01-09 Thread mark
Table's defined with ... content TEXT field, but when I issue the command insert into content values ( 'test', '', 'index.html', 1.000, 'index.html','','', load_file('/home/projects/URCMS/test/index.html'), 'import', now(), 'test', 'import', 0,''); either as script input, or from the sql

Re: Problems loading a TEXT field

2004-01-09 Thread Diana Soares
From the manual, check: * the file must be on the server * you must specify the full pathname to the file (ok, you did this) * you must have the FILE privilege * the file must be readable by all and be smaller than max_allowed_packet If the file doesn't exist or can't be read due to one of the

Re: Problems loading a TEXT field

2004-01-09 Thread mark
On Friday 09 January 2004 01:44 pm, Diana Soares wrote: From the manual, check: * the file must be on the server * you must specify the full pathname to the file (ok, you did this) * you must have the FILE privilege Ahhh! Misunderstood that one. Got it, now. Thanks. Still don't understand

Re: Problems loading a TEXT field

2004-01-09 Thread Michael Stassen
mark wrote (1/9/2004): On Friday 09 January 2004 01:44 pm, Diana Soares wrote: From the manual, check: * the file must be on the server * you must specify the full pathname to the file (ok, you did this) * you must have the FILE privilege Ahhh! Misunderstood that one. Got it, now. Thanks.