Excuse me if this problem was already posted but it is difficult to
search the archive...
I am using php 4.3.9 and mysql 4.1.7. To install mysql, I used an
installer from mysql.com and compile php from the source.
The main problem we are facing its the tables creation. the idea is
users come to a web page where they enter their name and password and
choose a database. If the DB do not yet exist a form will appear and
ask for the mysql admin name and root for the creation of the tables.
This is done by feeding each line of a tables.sql file (containing the
create tables statement) into mysql by a php script through fopen
and mysql_query() functions. This allow us to change on the fly lines
from the tables.sql file.
Here is the statement for the user table:
CREATE TABLE User (
id integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
username varchar(10) NOT NULL UNIQUE,
md5Pass varchar(40) NOT NULL,
admin tinyint(1) NOT NULL DEFAULT '0'
And the TYPE=INNODB seems to produce the error. Is it because it is
wrong to pass line by line a mysql_query() or is it because the innodb
engine is problematic with mac os x or the statement contains
Thank you for your help
Do not post admin requests to the list. They will be ignored.
Web-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden