Page 1 of 1

long posts getting cut off

Posted: Mon Apr 10, 2006 6:24 pm
by cruiserweight
I apologize as I'm sure there is an answer for this already; I just can't find it. I'm running phpbb on windoze with mysql4. It always cuts off long post withou warning. I've seen the 'odbc' about changing the db/msaccess and mssql-odbc files, but this did not work for me. thank you very much in advance for your understanding and patience. best.

Posted: Mon Apr 10, 2006 6:46 pm
by espicom
Are you using the direct MySQL connector (database type set to "mysql" or "mysql4" in config.php), or ODBC? The MySQL connector is controlled by php.ini, but there is no limit that can be set in there on post size.

However, the web server can have a limit on the maximum size of data posted via the POST method. For many services, this is 8 megabytes, but some hosts set it quite small. If you create a file containing the following and upload it as "phpinfo.php" to your website, it will tell you what you want to know:

Code: Select all

<?php phpinfo(); ?>
You want to run that in your browser, and search for the value next to "post_max_size".

Oops! MSSQL not MySQL

Posted: Tue Apr 11, 2006 8:39 am
by cruiserweight
Yikes!!! Major apologies. My original post should have read 'MSSQL', not MySql (habit, I guess). That said:

post_max_size on php.ini says '8M'. my phpbb config file says 'mssql'. That would seem to indicate that it's not using odbc. Querying the database directly (with hand-coded php) gives the same truncated result, and i'm stuck using some mickey mouse mylittleadmin tool -- which doesn't show the complete entry, only a few words and (...) -- so i've no idea what's actually in the database.

any ideas? thanks very much.

Posted: Tue Apr 11, 2006 10:59 am
by SpacePower
I had the same problem with MS-SQL-Server. Long postings were cut. Didin't work for me so I decided to use mysql. Gets phantastic until the new update 2.0.20 :x

Posted: Wed Apr 12, 2006 3:50 am
by cruiserweight
certainly there must be a fix for this, no? I mean, the whole idea of a database is to store information. If it can't do that propertly, than it's essentially garbage.

Posted: Wed Apr 12, 2006 3:58 am
by Lumpy Burgertushie
cruiserweight wrote: certainly there must be a fix for this, no? I mean, the whole idea of a database is to store information. If it can't do that propertly, than it's essentially garbage.


well, mssql is what it is. you can make some changes to it, but in the long run you would much better off using mysql instead. however, in it's default setting, it has limits for this as well. the limits are just much higher.

the bottom line is that this is a bulletin board, if you want to post gigantic articles, put them in a web page and link to them.

luck,
robert