Page 1 of 1

Debugging saving large scripts

PostPosted: Mon May 11, 2009 3:39 pm
by chrism
Hi All,

We have some very large scripts that include HTML that we are looking to use. However, when we enter them in through the script interface, it says it saves them to the database and return success, but nothing is there. The only way I can get the large scripts to save is to go directly into the database. I thought is may be a number of characters issue for the 'text' field in the database, but it inserts just fine with PHPMyAdmin.

Any thoughts?

PostPosted: Mon May 11, 2009 11:16 pm
by mflorell
Usually it's not the size, but the use of special characters that causes issues like this. Try stripping all of the curly quotes and triple dots...(and similar Microsoft word characters) out of the file first and try it again.

PostPosted: Tue May 12, 2009 6:55 am
by chrism
I'll give that a shot.

Is there any sort of routine you recommend checking the return results to see what is actually being passed into the database insert call?

PostPosted: Tue May 12, 2009 7:53 pm
by mflorell
In more recent SVN trunk versions of admin.php I did add some $DB printouts for script submissions to catch some stuff like this. I also made quite a few changes in SVN trunk specifically related to scripts and filters and these kinds of issues.