Updating table

shockinsanity

I posted this in coding by accident, sorry.

I can insert a new row, no problem. I can update a row, no problem as long as there is very little text being updated. If I try to update a large amount of text, it does nothing at all. I think this could be a configuration issue but I can insert a new row with what seems to be no limitation on the amount of text, so I'm stumped and would appreciate any help. Thanks.

zabmilenko

Well....

First, what db schema are you using? MySQL? PgSQL?

Second, post an example of a failing query and a passing query so we can see the data.

Please be more specific when you post questions, so we can give you more specific answers.

shockinsanity

Sorry... The DB I'm using is MySQL. The query that fails is the same as the passing one, I haven't altered the code. When I attempt to update more text into a row it just don't take. I don't get an error, nothing happens.

I'm using php behind a shockwave flash movie, passing variables from flash to php and back. All of that works great, just after a couple hundred characters are in the field, MYSQL won't take them. I set the col type in mysql to longtext, and again when I INSERT, (posting a new thread) I can put in as much text as I want. If nothing else I figure I could just grab all the info I want and delete whichever row, insert a new one with the information inserted as if it were updated?

Appreciate any help.

zabmilenko

Can you run this query and paste us the results: "show columns from $table_name"

Replacing the $table_name of course

I am guessing the field is a varchar(255) or similar, when it should be a blob/text field...

shockinsanity

Field Type Null Key Default Extra

id int(11) NO

user_name text NO

the_subject text NO

the_statement longtext NO

the_date text NO

last_user_post text NO

modified text NO

the_emotion text NO

replies text NO

viewed text NO

the_rating text NO

bump text NO

preview longtext NO

zabmilenko

Well, seeing that it's already basically a bunch of text fields, it's really out of my league, but I found a few interesting things to note at this link http://dev.mysql.com/doc/refman/5.0/en/blob.html

QUOTED:
The maximum size of a BLOB or TEXT object is determined by its type, but the largest value you actually can transmit between the client and server is determined by the amount of available memory and the size of the communications buffers. You can change the message buffer size by changing the value of the max_allowed_packet variable, but you must do so for both the server and your client program. For example, both mysql and mysqldump allow you to change the client-side max_allowed_packet value. See Section 7.5.2, “Tuning Server Parameters”, Section 8.6, “mysql — The MySQL Command-Line Tool”, and Section 8.12, “mysqldump — A Database Backup Program”. You may also want to compare the packet sizes and the size of the data objects you are storing with the storage requirements, see Section 11.5, “Data Type Storage Requirements”

Are you passing in foreign characters by chance? You may need to use a blob rather than a text field. Don't quote me though...

Beyond this, I simply don't know, but when I see all those text fields I think "corruption city". How often do you repair your tables?

shockinsanity

I know very little about php or mysql, I started out just using a few lines of code. Slowly I've tried more complicated things, most of them work for what I need on the front end, but are probably not "right". What I've been able to do so far on the flash side with the help of php and the database is absolutely awesome to me. So I'm learning, but entry level at best. Thanks for the help.