Skip to main content
S
SJurick
Known Participant
March 30, 2009
Question

Trying to access live database on server

  • March 30, 2009
  • 1 reply
  • 1125 views
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
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
March 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
S
SJurickAuthor
Known Participant
March 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
Firefly Community Gallery
Adobe Firefly

Remix with Firefly Community Gallery

Thousands of free creations to fall in love with and remix in Firefly.

Explore now
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices