phpMyAdmin error

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
DuFF
Forum Contributor
Posts: 495
Joined: Tue Jun 24, 2003 7:49 pm
Location: USA

phpMyAdmin error

Post by DuFF »

Alright, I'm trying to create a table in phpMyAdmin named joinstaff. For some reason when I click the "Save" button after filling out all the fields a javascript window opens up and says "This is not a number!". When I click OK nothing happens and the table refuses to be entered into the database. I have no idea which field the error is referring to and tried refreshing the page, starting a new table, etc... but to no avail.

Here is a picture of the table

If anyone can tell me why this is happening and what I have to change it would be much appreciated. Thanks :D
User avatar
xisle
Forum Contributor
Posts: 249
Joined: Wed Jun 25, 2003 1:53 pm

Post by xisle »

Looks like the column named 'file' does not have a length for the varchar, change to a text field if you don't want to set the size
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post by JAM »

xisle's post was wise. I'm just thinking about the error you got.

"This is not a number!"

Yah? What? The button I just pressed, or the cup of coffee I'm holding in my left hand?

When you click OK, does ther page go away/clears out? Do check if the cursor places itself in the file-textbox (or the file-textbox for the lenght) automaticly. Perhaps it does and you missed that (?).
Post Reply