Skip to main content
September 17, 2010
Question

Database connects but no tables are shown

  • September 17, 2010
  • 1 reply
  • 880 views

Hello

I have connected to the database on my remote server in dreamweaver 8 and it says its connected successfully, but when I open the tree or try to make a recordset no tables are show and when I try it in advanced this error appears:

"Error calling GetTables:

MySQL Error#: 1064

You have an error in your SQL syntax; check the manual that

correponds to you MySQL server version for the right syntax to use

near '-maillist' at line1"

maillist being my database name

I'm not very good at dynamics yet so don't really understand the SQL syntax

This is what dreamweaver connection made me:

<?php

# FileName="Connection_php_mysql.htm"

# Type="MYSQL"

# HTTP="true"

$hostname_blog = "localhost";

$database_blog = "servername"

$username_blog ="servername"

$password_blog ="password"

$blog = mysql_pconnect ($hostname_blog, $username_blog, $password_blog or trigger_error (mysql_error (), E_USER_ERROR);

?>

Don't know if any of this makes sence to you.

Please Help!

This topic has been closed for replies.

1 reply

Lon_Winters
Inspiring
September 18, 2010

There is a patch for DW 8 that fixes this, along with other steps you may need to take. It should still be somewhere on the Adobe support site.

If you can't find it, delete the connection, delete the connection scripts, restart DW and add the connection back. (you may even need to do that after installing the patch.

September 19, 2010

Hi I installed the update dreamweaver 8.0.1 updates and dreamweaver 8.0.2 updater but they didn't work is this the patch?

Lon_Winters
Inspiring
September 20, 2010

Yep, that's the one. Did you try deleting the connection scripts, etc?