Can't save an edited entry

[jnkwebdesignz]

I tried to search but not real sure what to search for.

My issue is I create an entry and save it in my admin area with "No problem", but when I go back to that entry and make a change and click "Save" nothing happens.

If I remove some information from some of the fields it will save fine, It appears that there is too much info to save it?

If I limit the info it will save OK.

I will include the DB fields if that helps:

id mediumint(9)
category varchar(100)
subcategory varchar(100)
title varchar(100)
description longtext
manufacturer varchar(100)
link1 longtext
link2 longtext
link3 longtext
retail decimal(6,2)
price decimal(6,2)
image1 varchar(255)
image2 varchar(255)
image3 varchar(255)
image4 varchar(255)
review longtext
ebaywords varchar(255)

Could it be something to do with the "longtext" those fields hold the most info and seems like they might be the culprit.

[leatherback]

Please provide us with answers to:

• What is the query that you submit to the database
• What is the error mysql gives off
• What is the method you use to determine whether you update or insert

[jnkwebdesignz]

leatherback wrote:

Please provide us with answers to:

• What is the query that you submit to the database
• What is the error mysql gives off
• What is the method you use to determine whether you update or insert

Leatherback - Thanks for your help.

As for the query, I am submitting through:
<form action="savereview.php" method="get">

  The savereview.php runs a _REQUEST for all variables then passed to this :[code=php]// if $id is not defined, we have a new entry, otherwise update the old entry

if( $id )
{
$query = "UPDATE review SET category='$category', subcategory='$subcategory', title='$title', description='$description', manufacturer='$manufacturer', link1='$link1', link2='$link2', link3='$link3', retail='$retail', price='$price', image1='$image1', image2='$image2', image3='$image3',review='$review',ehreview='$ehreview', ebaywords='$ebaywords' WHERE id='$id'";
}
else
{
$query = "INSERT INTO review ( category,subcategory,title,description,manufacturer,link1,link2,link3,retail,price,image1,image2,image3,review,ehreview,ebaywords )
VALUES ( '$category','$subcategory','$title','$description','$manufacturer','$link1','$link2','$link3','$retail','$price','$image1','$image2','$image3','$review','$ehreview','$ebaywords' )";

}

// save the info to the database
$results = mysql_query( $query );

// print out the results
if( $results )
{
echo( "Entry has been successfully saved. <a href='reviewdetails.php'>Details Page</a><br /><br />" );
echo( "Entry has been successfully saved. <a href='index.php'>Administration</a><br><br>" );
}
else
{
die( "Trouble saving information to the database: " . mysql_error() );
}[/code]

As for an error, I don't get any error, its like the Submit button doesn't do anything when clicked.

Does this help at all?

I also changed the "longtext" to "text" in the DB and reduced some of the VARCHAR's to lower amounts, but that didn't affect anything.

[jnkwebdesignz]

I just went in and checked the field with the longest amount of information (description) and it had 926 characters, I cut it down to 716 characters and it saved.

Does this make any sense?

[leatherback]

Hi,

Description is in a longtext field, and, according to the mysql website:

LONGTEXT
A BLOB or TEXT column with a maximum length of 4,294,967,295 or 4GB (2³² -
1) characters. Up to MySQL 3.23, the client/server protocol and MyISAM tables
had a limit of 16MB per communication packet / table row. From MySQL 4.0, the
maximum allowed length of LONGBLOB or LONGTEXT columns depends on the configured
maximum packet size in the client/server protocol and available memory.

So that should not be an issue. As far as I know there is no problem with anything of that size. I think it has to do with the query you try and send to the database. As you use extract() -which you shouldn't, as it create a serious security risk- you have no control over your input variables, unless you do serious variable checking on the submitted data.

Please place this code:

   echo "<pre>";
   print_r($_POST);
   echo $query;
   // save the info to the database
   $results = mysql_query( $query ) or die(mysql_error()); 
   echo "</pre>";

in stead of

   // save the info to the database
   $results = mysql_query( $query ); 

And post what the result is (Please place

 [/code ] tags around the post so it is easier to read for us.

[jnkwebdesignz]

I swapped the below with what I had and it worked on Firefox but not IE.

   echo "<pre>";
   print_r($_POST);
   echo $query;
   // save the info to the database
   $results = mysql_query( $query ) or die(mysql_error()); 
   echo "</pre>";

So I updated IE and still had an issue, I changed the "get" to "post" in the "form action" and it worked fine.

The "post" allows more info to pass? as opposed to the "get"?