search for: longblob

I''m struggling with activerecord and mysql blobs (uploading files)... blobs over 400K-ish cause the below exception... ActiveRecord::StatementInvalid in File#upload Mysql::Error: Lost connection to MySQL server during query: I''ve tried blob, mediumblob, and longblob... I''m using windows xp for development - and have not installed the mysql gem... simlar google postings/solutions have not worked thoughts/suggestions? -- Posted via http://www.ruby-forum.com/.

...) | YES | | NULL | | | macrocontext | varchar(80) | YES | | NULL | | | callerid | varchar(40) | YES | | NULL | | | origtime | varchar(40) | YES | | NULL | | | duration | varchar(20) | YES | | NULL | | | recording | longblob | YES | | NULL | | +--------------+-------------+------+-----+---------+-------+ manage users and storing voicemail messages according to ser database. Where can i find the schema of the SQL DB for voicemail accounts . for example in extconfig ; file.conf => driver,database...

I have file uploads to the database and stored in a longblob working on our client extranet, except that it kills mysql/activeRecord on files bigger than about 200kb. (is there a reason for this - running mysql 5.0.18, lighttpd or webrick on winxp??) So I''m now thinking about whether its possible to do either: 1) upload a file into #rails_root/...

...NULL > > | | > > | duration | varchar(20) | YES | | NULL > > | | > > | mailboxuser | varchar(80) | YES | | NULL > > | |* > > | mailboxcontext | varchar(80) | YES | | NULL > > | |* > > | recording | longblob | YES | | NULL > > | | > > > +----------------+-------------+------+-----+---------+-------+ > > > > according to app_voicemail.c i set > > mysql> desc voicemessages; > > > +----------------+-------------+------+-----+---------+-------+ &gt...

...drivers are now ODBC. I am running asterisk-cvs head as of last night 9/19/05 My question is this... the old voicemail.cgi script that allowed checking voicemail no longer works etc, and never did work for me without a static voicemail.conf file. Anyways.. that aside... how does one retrieve the longblob object from the database and present it to the user (upon authentication) via a website. I'd be happy to help someone with the www/php/mysql integration but I just dont know how to get blob's out and save to a temp file out of a database. Thanks

...NULL > > | | > > | duration | varchar(20) | YES | | NULL > > | | > > | mailboxuser | varchar(80) | YES | | NULL > > | |* > > | mailboxcontext | varchar(80) | YES | | NULL > > | |* > > | recording | longblob | YES | | NULL > > | | > > > +----------------+-------------+------+-----+---------+-------+ > > > > according to app_voicemail.c i set > > mysql> desc voicemessages; > > > +----------------+-------------+------+-----+---------+-------+ &gt...

...est file i could upload was 493KB and i''ve uploaded a bunch files under 490KB and they all worked. the smallest file which i failed to upload is 500KB so i guess that''s where the "limit" is. my data field in mysql is set to mediumblob, inevitably, i tried changing it to longblob which didn''t work. i''m running the webrick server. Any help would be greatly appreciated... thx -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Rub...

...e case of modifiable items such as word processor files I would like to change them and resave them. In the case of files such as short movies they would only be viewed. Using the book "Agile Web Development with Rails" I have been able to load a Word doc from a file location into a longblob in a table and put descriptive data in other fields (p.362 ff). I can''t figure out how to do the second part: make them available for editing. I would think that they should be copied to a temp location and then run from there, followed by resaving to the database, but I can'...

...age AMI action Cant Send Text Message Over PJSIP (Reported by Andrew Nagy) * ASTERISK-23818 - PBX_Lua: after asterisk startup module is loaded, but dialplan not available (Reported by Dennis Guse) * ASTERISK-23847 - Alembic voicemail script - 'recording' column should be longblob on MySQL (Reported by Stephen More) * ASTERISK-23825 - Alembic scripts - table queue_members missing unique index on column uniqueid (Reported by Stephen More) * ASTERISK-23909 - Alembic scripts - table sippeers could use a longer useragent column (Reported by Stephen More) * ASTERIS...

...age AMI action Cant Send Text Message Over PJSIP (Reported by Andrew Nagy) * ASTERISK-23818 - PBX_Lua: after asterisk startup module is loaded, but dialplan not available (Reported by Dennis Guse) * ASTERISK-23847 - Alembic voicemail script - 'recording' column should be longblob on MySQL (Reported by Stephen More) * ASTERISK-23825 - Alembic scripts - table queue_members missing unique index on column uniqueid (Reported by Stephen More) * ASTERISK-23909 - Alembic scripts - table sippeers could use a longer useragent column (Reported by Stephen More) * ASTERIS...

I have some files stored in db. When I try to download these I only get 65535 bytes from the database even if the file is a lot bigger. Is it a Rails setting I''ve missed or a database setting? Anything else? Using Rails 1.0, WinXP and MySQL4.1 /Marcus

Hello iam new to rubyonrails. Please any one help me out in "How to upload only jpeg & gif & png images into public/images using rubyonrails" Thanks in Advance -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060504/33a17ad2/attachment.html

...| varchar(40) | YES | | NULL | | | duration | varchar(20) | YES | | NULL | | | mailboxuser | varchar(80) | YES | | NULL | | | mailboxcontext | varchar(80) | YES | | NULL | | | recording | longblob | YES | | NULL | | +----------------+-------------+------+-----+---------+----------------+ 11 rows in set (0.00 sec) mysql> exit; Bye Here is an example of the errors I'm getting (ignore No route to destination, those phones just aren't on): -- E...

...nag. (I apologize in advance. I''m not very good at system administration.) I''m building an app that allows users to upload files. Up until now I have been storing the files on the file system, but tonight I decided to change the app so the files are stored in the database as a longblob. I thought everything was working great, until I tried uploading a file that is almost 1 meg in size. I''ve got a bunch of test images I use, and the smaller ones (200k and below) work fine. But when I try the 700k & 900k files it just doesn''t work. (It did work when I was...

...39;', `macrocontext` varchar(80) default '', `callerid` varchar(40) default '', `origtime` varchar(40) default '', `duration` varchar(20) default '', `mailboxuser` varchar(80) default '', `mailboxcontext` varchar(80) default '', `recording` longblob, PRIMARY KEY (`id`), KEY `dir` (`dir`) ) ENGINE=MyISAM; Does anybody have any ideas on what's causing this error? Why would MySQL not have enough memory? What does it mean, "points outside data file"? Is anybody else doing this successfully, or am I a lone freak? Any assistan...