Dreamweaver cs5 recordsets issues...frustating! any ideas?

Report · Sep 06, 2010

Hi- any suggestion on how to deal with D cs5 software recordsets issues. Most of the time when I open a page that has a recordsets, or when I tried to edit or when creating recordsets or deleting, using the recordsets window, the program keeps crashing!! it is very frustrating, and I am not adding additional custom code to the recorsets, the software keeps crashing with its own generated code. If I switch between simple and advanced mode, it does the same thing.

Sometimes, when you try to edit a recordset it duplicates the recordset instead of editing the existing one.

I have been waiting for an update for this issue but nothing....I am using Windows 7 and developing in PHP/MySQL

Thanks,

Renier

Report · Sep 07, 2010

Has it done this since you first installed CS5, or did it develop this behavior later on? Have you tried installing the Dreamweaver CS5 updater? It focuses mostly on HTML5 updates, but there were a number of bug fixes, perhaps this will help. After trying this if it still crashes you may have to try a full uninstall and reinstall... Or contact Adobe Support directly.

--
Lawrence Carmer - *Adobe Community Professional*
http://www.Cartweaver.com
Complete Shopping Cart Application for
Dreamweaver, available in PHP and ColdFusion

Stay updated - http://blog.cartweaver.com

Report · Sep 08, 2010

Here are the steps I would take when I start seeing crashes when using recordsets or other server behaviors. But I'm still on cs4, so it may be purely a CS5 issue as mentioned above.

1. Delete the Wincache file (usually only a temporary fix)

2. Could be a conflict with an installed 3rd party extension.

3. Does it happen on just a particular page, or any page? Iff it's just one, you can try on a blank or less populated page - I've occasionally had to just re-build the page and that would help. Sometimes it was just the removal of a single field of dynamic data tied to the recordset. removing this binding and re-adding ti worked, even though the code was exactly the same in both cases.

4. Deleting the database connection and removing the connection scripts, then re-creating the connection

And sometimes, for whatever reason, I have seen where it added another set of recordset code, or just parts of it. And sometimes when you delete a recordset, parts still remain. It is frustrating, no doubt.

Report · May 05, 2011

I'm having the same probs with the recordsets duplicating. It's driving me mad and I have a lot of stuff to get on with. The program is almost unusable because of this. I will try some of these suggestions but does anyone have a definate answer why this is happening yet?

I've made a fresh page, fresh connection, simple MYSQL statement, put a couple of results onto the page as a test, ok.

Went back into the recordset from the panel, edited the recordset and it duplicated it!! So nothing to do with Variables or repeat regions.

Any ideas please. Here is my code.

<?php require_once('MyConnections/connection.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
}
return $theValue;
}
}

mysql_select_db($database_database, $Database);
$query_Recordset1 = "SELECT * FROM cards ";
$Recordset1 = mysql_query($query_Recordset1, $Database) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);mysql_select_db($database_database, $Database);
$query_Recordset1 = "SELECT * FROM cards where EmployeeID = 1";
$Recordset1 = mysql_query($query_Recordset1, $Database) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

Report · May 05, 2011

I don't think there's a definite answer to this one. Perhaps someone who has submitted a support ticket with Adobe could report.

Here's a longshot - have you noticed any difference whether you're in Code view or Design view when editing the recordset? I've noticed that when you select something from the behavior panel, there are times when it actually selects different blocks of code depending on which view you're in.

Report · May 05, 2011

Hi Lon,

Thank you for answering. I have a large monitor and nearly always work

in Split mode. I have noticed that when you select a record set it

sometimes seems to select more that the code for that record set.

After reading some replys to this same problem in CS4 I believe I may

have caused it. I wanted the data in the second record set to read using

a field from the first (master - detail) so I added some code to load

the key between the two record sets.

Kind Regards

John

Report · May 05, 2011

Yes John, but take a look at the example code I posted a couple of posts above. It does it even on the simplest recordset, with no variables.

Just a SELECT * FROM statement.

When I alter that from the panel to SELECT * FROM ..... WHERE ..... , it all goes tits up with nothing else on the page. A totally blank page except the recordset.

Where are ADOBE on this? Why are they not giving us an answer or even aknowledgement of our problem, which is major and makes the multi-thousand dollar software almost useless?

Report · May 05, 2011

Adobe does not take part in this forum, it is only user-to-user. I say only, but I've been helped more times than I can count here.

Someone should file a support ticket and see what happens and report back. But even if you get the best support engineer in the world, if he or she cannot recreate the issue there's not much they can do about it. If you can recreate it consistently, document the steps and let them know.

Created a recrodset based on the output of a previous recordset may or may not be part of it, but it shouldn't be. I've done this before and the only problem I had was when the first recordset returned a null value, then the page would just fail. So instead, I would define a variable within and IF statement and use that.

But anything that I get even similar to this problem is happenstance, and there doesn't seem to be a pattern. Another example, I save the the recordset, it just goes away from the behaviors panel, and I get red exclamation marks nest to the dynamic data entries. The actual code is still intact, and all I have to do is close and save the page, and reopen it. But I can never willfully make that happen - the only real thing I can think of is sometimes I just get ahead of the program, and click something while it's doing something else, and it can't keep up and throws the glitch. Still, these things only happen to me less than 5% of the time. If it were greater than that, say approaching 50% or so the next thing I would try would be a complete reinstall of the entire Creative Suite and all the available updates.

Report · May 05, 2011

I am having the same problems but instead of editing what I do is save my work, delete the record set and create a new one. I bit of a nuicence but for me it is better than working out what code has been duplicated and/or deleted and having to correct it.

Report · May 05, 2011

I've got used to it now.. It's very consistent when it does it so I just check which is the latest SQL query I wanted and just delete the old one that remains. If you look you'll notice that the old code starts in the middle of a line, which makes it a bit more difficult to see:

$row_rsDomjobs = mysql_fetch_assoc($rsDomjobs);(OLD STARTS HERE)if (isset($_GET['totalRows_rsDomjobs'])) {

If you split them apart at teh point shown above you'll see the 2 blocks of code are similar, apart obviously form your new SQL query. Just delete the old one..

I can't believe it hasn't been fixed on CS5 as it did it in 3 and 4 too. I presume most people who produce more dynamic sites use CF or just code it themselves, as I now do.. It's disappointing that Adobe don't even acknowledge the problem though

Report · May 05, 2011

..It also adds another (reduntant) connection line at the top too:

<?php require_once('../Connections/latitude.php'); ?>

I end up with several that I delete, leaving just one...

Report · May 05, 2011

I've just done a bit of testing and might have something.

I made a simple PHP page with any SELECT statement using the advanced recordset panel.

I could edit this to my hearts content and all is good ..... until.......I upload it to the server.

Then, when I change my recordset in the panel (or even just open it and close it) the recordset is duplicated. If I then use UNDO , then we're back to normal, can edit happily.

In fact whenever I interact with the server, like looking at MANAGE SITES for instance, and I then open and close the recordset, the recordset is duplicated.

So it seems it's something to do with connecting to the server. I tried altering a few settings but couldn't shake the problem. If anyone can use this to solve our problem then I'd be very happy to hear about it.

AS A GETAROUND. AFTER you upload your page, either close and re-open it before you edit your recordset. OR open the recordset, close it (problem occurs) then UNDO and go again.

Try it out, see if you get the same.

Kelly.

Report · May 06, 2011

Kelly, I think you're on the right track - There have been numerous complaints over the years about the "interacting with server" thing popping up for no good apparent reason. That part of it alone I think is worse when working in ASP - it feels the need to interact with the server when I go to select something as innocuous as static text on the page!

My next stretch of work will be back to PHP sites, so I'll keep a close watch on things and report back if I learn or see anything suspicious.