Can't see my Fields in my MySQL database when I view through Dreamweaver


Perhaps something shamefully obvious, but I can't see the fields of my MySQL database when I try to view it  through Dreamweaver. I have connected to my mySQL database and am able to see the database table in my database applications window, but when I click on the  database, it appears to be empty.

I created the database using MySql and pHpmyadmin, and when I view it on pHpmyadmin it is populated and I can see the fields. But when I click on the table or try to view through  record insertion form - form fields area (I want to create a record insertion form) nothing seems to be there.

Thanks for viewing this.
AdamTrying to learn phpAsked:
Who is Participating?
 
Havin_itConnect With a Mentor Commented:
Hi Adam,

I think it may be a bug in DW. Many people here have reported similar issues and (as in my own case) an explanation is not always forthcoming. If the problem recurs, check whether you are also unable to use Live Data View or conduct a URL Prefix test in the Site Definition wizard. I found these failed at the same time as the database connection.

I haven't found a fix or explanation for this behavior, it's happened to me on two different PCs, but it seems to go back to normal after a while (equally without warning). Not much help I guess, but just to let you know.
0
 
rockmansatticCommented:
so your saying that DW is connected t ot he database and it can see the tables (even new ones?)
but when you are trying to run a query, you cant see any fields (as in advanced mode?)

rockman
0
 
AdamTrying to learn phpAuthor Commented:
Yes, it is connected to the database. I was following a tutorial which was going well up until I opened up a Record Insertion form, and where I expected to see my Form Fields, nothing was there. Should I see them? I sense I have missed a step or something. I haven't tried to run any queries yet.
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
rockmansatticCommented:
not just using a insert form.  If you use the wizard, then it will do all the work for you.  the only way to see the fields in the insert form, it to create a form for the data, then add a server behavior, then you can choose which form field goes into which database field.

So , no you shouldnt see the fields in insert form.
you should if you run a normal request query.

Rockman
0
 
AdamTrying to learn phpAuthor Commented:
So... I choose a recordset and defined my connection(the connection to my database). My table appeared, I selected it, but '***no column found' appeared.

Now, did I run a normal request query there - or was that something else?

Thanks.

Adam
0
 
rockmansatticCommented:
"Now, did I run a normal request query there - or was that something else?"
Yes.
wierd.

Are you connecting to this database locally?
how did you test the connection to the database in DW?

Rockman
0
 
AdamTrying to learn phpAuthor Commented:
No, I am connecting to a database on a remote hosting company server.

I tested the connection by clicking on the database icon and selecting Test in the MySQL dialogue box. The connection came up as successful. Also, if I click on the + to expand the connection, I can see my table, but when I click on it, it appears to be empty. Also when I click on the connection in the recordset, my database appears.
0
 
rockmansatticCommented:
I little beyond my expertise, but it could be that you dont have proper user access to the database.  
This hardly seems possible since you can see the table.

This is as far as I can go....
I would check with your hosting company to see if the settings are correct on thier side.
I would also put a 20pt question in the mysql section of EE that point to this one.  It may be a mysql question and not DW.

Good Luck, and Ill do some research when I get a chance.

Rockman
0
 
AdamTrying to learn phpAuthor Commented:


Thanks for your time and the advice.

Cheers,

Adam
0
 
scottparksCommented:
Make sure you have access to the MySQL database and that port 3360 is not closed at their router.  Typically you can not connect and use MySQL from a different host unless you have added that user.  

Say you have a user name:  dreamweaver and you are connecting from 192.168.0.5.  You would add a user dreamweaver @ 192.168.0.5 to the MySQL user table.

If you can not connect after that make sure port 3360 on your ISP is not blocked.

-Scott
0
 
AdamTrying to learn phpAuthor Commented:

Hi Scott,

Sorry for the delay - I'm in Japan.Yes I have a connection. I have been playing around with it a bit more and I can now see the contents of the database. I am worried I am wasting other people's time here, and I should probably read the help files again. Basically I tried to create a recordset - I selected the connection I had created and my database table appeared. However what troubled me was that no columms were found even though the 'all' radio button was selected.

However when I clicked 'test', the database contents appeared in a 'test SQL statement' - so I guess it is there. I just expected it to be viewable in the recordset dialogue box under columns. Anyway, I'm going to go back to the tutorials I originally looked at, create the SQL database again and try again. I don't want to waste people's time here, if what I am seeing is completely normal - or due to me setting up my SQL database incorrectly.

Thanks for your help. I'll be back if I can't make progress with the new database.

Cheers Scott,

Adam
0
 
AdamTrying to learn phpAuthor Commented:
Got this one sorted I think. The problem seemed to have been that mysql database had no autonumber specified and wasn't set to incriment.

I can see the contents now.

Thanks all.
0
 
AdamTrying to learn phpAuthor Commented:
thanks.

Adam
0
 
Havin_itCommented:
You're welcome - hope it works itself out for you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.