Trying to access live database on server

Report · Mar 30, 2009

I have a MySQL 5.0.62 Community database which has been created on my hosting domain server using phpAdmin. I flip back over to DW CS4 and make a connection to the database using the Insert Record behavior. The connection works fine, I can see all the contents of the table and map fields as expected, however when I click OK to confirm my settings I get the following error: "While executing applyServerBehavior in InsertRecord.htm, a JavaScript error occurred."

I tried creating a RecordSet thinking this was the issue but got a similar error message upon clicking OK. Instead of "InsertRecord.htm" it read "Recordset.htm".

So I think I'm close seeing that I can connect to the db but don't know why I can't complete the behavior.

Thanks,
Steve

Report · Mar 30, 2009

sjurick wrote:
> I get the following error: "While executing
> applyServerBehavior in InsertRecord.htm, a JavaScript error occurred."

That's usually the sign of a corrupted file cache in Dreamweaver. Follow
troubleshooting step 4 in the following technote:

http://www.adobe.com/go/tn_19105

--
David Powers
Adobe Community Expert, Dreamweaver
http://foundationphp.com

Report · Mar 30, 2009

Thanks for the link David. That's a good troubleshooting list for future reference, however I got rid of the errors by creating a new page and added the insert record behavior to it. Then I copied that code (top and bottom) to the existing page. I made sure I placed the code after the two behaviors that were already being used on that page and it didn't bark at me. So I uploaded the page to the server and tried to access it. Now I'm getting a new set of errors on the web page.

Errors on webpage:
Warning: require_once(Connections/connSCT.php) [function.require-once]: failed to open stream: No such file or directory in /home/shortcou/public_html/registration_db.php on line 3

Fatal error: require_once() [function.require]: Failed opening required 'Connections/connSCT.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/shortcou/public_html/registration_db.php on line 3

I believe I read somewhere that you must remove the (<?php require_once('Connections/connSCT.php'); ?>) code once it's actually on the server?

Steve

Report · Mar 30, 2009

sjurick wrote:
> Errors on webpage:
> Warning: require_once(Connections/connSCT.php) [function.require-once]: failed
> to open stream: No such file or directory in
> /home/shortcou/public_html/registration_db.php on line 3

That means that connSCT.php is missing.

> I believe I read somewhere that you must remove the (<?php
> require_once('Connections/connSCT.php'); ?>) code once it's actually on the
> server?

Nope. It won't work without it.

--
David Powers
Adobe Community Expert, Dreamweaver
http://foundationphp.com