Skip to main content
A
Anonymous
January 22, 2010
Question

Since upgrade to PHP5, No Table Found when defining Recordset

  • January 22, 2010
  • 1 reply
  • 395 views

I am a high school teacher, and have been using Dreamweaver MX 2004 to maintain our site since 2004 (our budget won't buy me a new version anytime soon). I have taught my students how to do basic queries using Dreamweaver by going to the Application panel, Server Behaviors, and creating a New Recordset.

We upgraded our Apache server to PHP5 recently, and now Dreamweaver cannot recognize any tables when I try to attach to a database. When trying to create a new Recordset, the Table will say *** No Table Found. I have attached a file of the window with that message.

All the PHP code works fine if I code it, but it is much easier for most of my HS students to be introduced to database integration w/ Dreamweaver allowing us to create recordsets. Any suggestions?

This topic has been closed for replies.

1 reply

David_Powers
David_Powers
Inspiring
January 22, 2010

This thread has been moved to the Dreamweaver Application Development forum, which deals with PHP and other server-side issues.

I appreciate the difficulty with budgets, but you should realize that Dreamweaver MX 2004 creates outdated PHP code that is insecure. You would do your school and your students a big favour by upgrading as soon as practicable. Adobe offers generous discounts to teachers and bona-fide students.

Anyway, to your problem. Several thoughts spring to mind:

  • Run phpinfo() to check your PHP configuration. Search for register_long_arrays in the Core section. It probably says "off". Get your server administrator to change the value in php.ini to "on", and restart Apache. See if that fixes the problem.
  • Another possibility is that you are using illegal characters, such as spaces or hyphens, in the table or column names. Replace any spaces or hyphens with an underscore.

MX 2004 was released a year before PHP 5. It certainly worked with early versions of PHP 5 (I know, because I switched to PHP as soon as it was released). However PHP 5.3 has introduced a lot of changes that make it much more strict in what it accepts. MX 2004 is no longer supported, so you will need to upgrade sooner or later.

Hello World!

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