Hi Rob,
Error_reporting is set to 2039 and the script is not written in an
object-oriented way. When you type too many characters in the textarea, you
can't even get a simple print("Hello World!"); statement to work; I am
really surprised with that...
Could you please offer any other perspectives of what might be going wrong?
George
"I think there is a world market for maybe five computers."
Thomas Watson, Chairman of IBM, 1943.
----- Original Message -----
From: "Rob A. Brahier" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 18, 2003 5:43 PM
Subject: RE: Working with the text datatype in Mysql
| So this happens even with shorter blocks of text? This is going to take
| some narrowing down. Make a new PHP file in the same directory as your
| script. It should contain only one line:
|
| <?php phpinfo(); ?>
|
| Navigate to that in your web browser. You should see a pre-generated PHP
| page come on the screen. Do a search for 'error_reporting' and tell me
what
| it's set to.
| Ideas off the top of my head:
| --If error_reporting is turned off then your script might be dying at an
| earlier part of your script.
| --If your script is written in an object-oriented style then you might be
| sure you have a new MyObjectNameGoesHere() type of call somewhere outisde
of
| the function.
| --Try adding an echo to the very beginning of your file, just after the
| opening <?php tag. See if it will return even a plain text string that
way.
| --Lastly, check your apache log file--it should usually be in
| </path/to/apache>/logs/error_log. See if there are any errors in there
from
| when you last ran the script--it may be crashing.
|
| -Rob
|
| -----Original Message-----
| From: Lekeas GK [mailto:[EMAIL PROTECTED]
| Sent: Friday, July 18, 2003 12:29 PM
| To: Rob A. Brahier
| Cc: [EMAIL PROTECTED]
| Subject: Re: Working with the text datatype in Mysql
|
|
| Nope, same situation...When you hit the submit button, nothing happens...I
| check the database afterwards and find out that nothing was inserted...
|
| George
|
| "I think there is a world market for maybe five computers."
| Thomas Watson, Chairman of IBM, 1943.
|
| ----- Original Message -----
| From: "Rob A. Brahier" <[EMAIL PROTECTED]>
| To: "Lekeas GK" <[EMAIL PROTECTED]>
| Sent: Friday, July 18, 2003 5:01 PM
| Subject: RE: Working with the text datatype in Mysql
|
|
| | hmm, add this after your mysql_query() line in the script
| |
| | echo mysql_error();
| |
| | Does that return anything?
| |
| |
| | -----Original Message-----
| | From: Lekeas GK [mailto:[EMAIL PROTECTED]
| | Sent: Friday, July 18, 2003 11:52 AM
| | To: Rob A. Brahier
| | Cc: [EMAIL PROTECTED]
| | Subject: Re: Working with the text datatype in Mysql
| |
| |
| | Rob,
| |
| | The script is indeed written in PHP version 4.3.1. The full version of
| mysql
| | I am using is 3.23.30-gamma.
| |
| | Thanks,
| | George
| |
| | "I think there is a world market for maybe five computers."
| | Thomas Watson, Chairman of IBM, 1943.
| |
| | ----- Original Message -----
| | From: "Rob A. Brahier" <[EMAIL PROTECTED]>
| | To: "Lekeas GK" <[EMAIL PROTECTED]>
| | Sent: Friday, July 18, 2003 4:31 PM
| | Subject: RE: Working with the text datatype in Mysql
| |
| |
| | | George,
| | | You keep leaving out the vital bits. What are your sers using to
enter
| | | this data? We know it's a web page, but what script does that web
page
| | run
| | | when the user submits their data? Is it a script written in the PHP
| | | programming language or something else? What is the FULL version
number
| | of
| | | the MySQL server you are using, and what is the version of the
| programming
| | | language that you wrote your script in?
| | |
| | | -Rob
| | |
| | | -----Original Message-----
| | | From: Lekeas GK [mailto:[EMAIL PROTECTED]
| | | Sent: Friday, July 18, 2003 10:17 AM
| | | To: gerald_clark
| | | Cc: [EMAIL PROTECTED]
| | | Subject: Re: Working with the text datatype in Mysql
| | |
| | |
| | | The checking is done from the mysql command line tool and all special
| | | characters are properly quoted (even tried it with a sequence of
| | characters
| | | without any punctuation marks or anything else). The mysql_query()
call
| | has
| | | a die() statement as well but it is not coming up.
| | |
| | | George
| | |
| | | "I think there is a world market for maybe five computers."
| | | Thomas Watson, Chairman of IBM, 1943.
| | |
| | | ----- Original Message -----
| | | From: "gerald_clark" <[EMAIL PROTECTED]>
| | | To: "Lekeas GK" <[EMAIL PROTECTED]>
| | | Cc: <[EMAIL PROTECTED]>
| | | Sent: Friday, July 18, 2003 3:00 PM
| | | Subject: Re: Working with the text datatype in Mysql
| | |
| | |
| | | |
| | | |
| | | | Lekeas GK wrote:
| | | |
| | | | >Gerald,
| | | | >
| | | | >The version of MySQL is 3.23,
| | | | >
| | | | That only spans 50 some odd releases. Which one?
| | | |
| | | | > the platform is Solaris, the language is
| | | | >English
| | | | >
| | | | Computer language.
| | | | PHP?
| | | | Perl?
| | | | Python?
| | | | Mysql command line tool?
| | | |
| | | | Did the program performing the insert properly quote special
| characters?
| | | | Did it check for sucess of the insert?
| | | |
| | | | > and the way I check whether data has been entered in the database
or
| | | | >not is by running a select query on the database.
| | | | >
| | | | Useing Which language above?
| | | |
| | | | >
| | | | >Was that of any help? I tried searching the net but couldn't find
| more
| | | | >information about what might be causing the problem...
| | | | >
| | | | >Thanks,
| | | | >George
| | | | >
| | | | >"I think there is a world market for maybe five computers."
| | | | >Thomas Watson, Chairman of IBM, 1943.
| | | | >
| | | | >----- Original Message -----
| | | | >From: "gerald_clark" <[EMAIL PROTECTED]>
| | | | >To: "Lekeas GK" <[EMAIL PROTECTED]>
| | | | >Cc: <[EMAIL PROTECTED]>
| | | | >Sent: Friday, July 18, 2003 2:11 PM
| | | | >Subject: Re: Working with the text datatype in Mysql
| | | | >
| | | | >
| | | | >| You supply almost no useful information here.
| | | | >| What version of MySQL are you using?
| | | | >| What platform?
| | | | >| What language?
| | | | >| How do you check to see if anything was entered?
| | | | >|
| | | | >|
| | | | >| Lekeas GK wrote:
| | | | >|
| | | | >| >Hi All,
| | | | >| >
| | | | >| >I am managing a small database where a few fields are defined as
| | being
| | | of
| | | | >| >type text. In my understanding, this would allow the user to
enter
| | up
| | | to
| | | | >| >about 65,000 characters in the text field.
| | | | >| >
| | | | >| >However, if the user types about 2,000 characters, then nothing
is
| | | | >entered
| | | | >| >in the database. I have checked the max_packet_allowed and the
| | | | >| >net_buffer_length and the limits are quite high.
| | | | >| >
| | | | >| >Could somebody advice me on how to go about solving this
problem?
| | | | >| >
| | | | >| >I look forward to hearing from you soon.
| | | | >| >
| | | | >| >Thanks in advance.
| | | | >| >
| | | | >| >George
| | | | >| >
| | | | >| >"I think there is a world market for maybe five computers."
| | | | >| >Thomas Watson, Chairman of IBM, 1943.
| | | | >| >
| | | | >| >
| | | | >| >
| | | | >| >
| | | | >| >
| | | | >|
| | | | >|
| | | | >
| | | | >
| | | | >
| | | | >
| | | |
| | | |
| | |
| | |
| |
|
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
