phpMyAdmin & PHP 4.2.3

[flash99]

I am using PHP 4.2.3, and I am also using phpMyAdmin. I am getting many errors when trying to perform basic tasks such as creating a table using the SQL editor. I have been told that the PHP version I am using does not quite work as well as previous version. Does anybody know any info about this or how to fix this error!

Thanks in advance!

[weekender]

i am running php 4.2.3 and phpmyadmin fine on my laptop, with no problems at all, using IIS 4. Can you tell me what errors you are getting? Cant really help if i don't know what the errors say...

adam

[flash99]

Well in the SQL editor in phpMyAdmin I tried to create a table in an exsiting database and get the following error:

MySQL said:

You have an error in your SQL syntax near 'NOT NULL, 2 VARCHAR NOT NULL, 3 VARCHAR NOT NULL)' at line 1

Here is the simple SQL query I entered:

CREATE TABLE test (

1 VARCHAR NOT NULL ,
2 VARCHAR NOT NULL ,
3 VARCHAR NOT NULL
) ;

I have also change syntax if the query but with no results, infact I used the same query on the mySQL (GUI) SQL editor and it worked with no problem, and I also tried it on the prompt and it also worked.

There are many users experiancing this problem as I have found many sites that are discussing this issue, the main site is the home page for phpMyAdmin and can be access with the following url:

http://bugs.php.net/bug.php?id=19404

[weekender]

i'm not sure you can use numbers as field names... try using the following

CREATE TABLE test (

one VARCHAR NOT NULL ,
two VARCHAR NOT NULL ,
three VARCHAR NOT NULL
) ;

if that doesnt work, try using the mysql table builder... start with a one-field table, and then add further fields to it.

[flash99]

I still get the same error! Does it work with you?