Ticket #494 (new defect)

Opened 9 months ago

Last modified 9 months ago

schema.php MySQL TEXT field syntax incorrect.

Reported by: reporter Assigned to: mbonetti
Priority: normal Milestone:
Component: BUGS Version:
Severity: normal Keywords:
Cc:

Description

Good day,

When "php schema.php --dump" is invoked from the command line, MySQL TEXT fields are not created with the correct MySQL syntax for the USERS and DASHBOARD tables.

eg: userips TEXT default should be: userips TEXT

eg: url text NOT NULL default should be: url text NOT NULL

Of course I could be wrong and be missing something...

Even with the latest nightly build this is still in there.

You have to modify dbstruct.sql to import those two tables correctly or else create them by "hand" manually.

Regards Craig craig@pop.co.za

Change History

09/24/07 19:36:13 changed by cfriesen

Are you by chance using MySQL 5?

I think I ran into something similar to this while upgrading another PHP application on my server. Something about the syntax of TEXT/BLOB being changed.

Chris