running migration errors about tracker HOT 8 CLOSED

This is a work in progress, I did not published this package, because it was not well tested yet, But it's working for me, at least using PostgreSQL.

1. Is your database MySQL?
2. How did you installed it?
3. how are you running the migration?

Looking at this error: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table

The problem might be some text fields I use as index, PostgreSQL is able to index them but your database isn't.

from tracker.

I just pushed a change which should make it work on MySQL too.

from tracker.

Unfortunately you probably will have to delete the already created tables manually. I just saw you have some errors like:

Table 'tracker_log' already exists (SQL: create table tracker_log (id

So you were running it for the second time and in the first time those tables were created.

from tracker.

I know that sorry I should of removed them I just did a screen capture I would run the migration then when it got a error I would remove the tables make the change that Artisan would complain about . Most of the issues are to do with applying indexes to string columns as no size is set the migration creates a text/blob column and the other issue had to do with indexes set on more then one column at a time which is fine but as there is no size limit on the string columns you get a size too big error .
They are the only errors I got, sorry for sending all the errors from my screen to you I did run migration twice where I missed removing the table first by mistake.

Jason Kristian | Director | Apps 4 U Pty Ltd.
ph: +61 075699 8109
mob: +61 0411 389 392
e: Jason Kristian

On 29 May 2014, at 1:11 am, Antonio Carlos Ribeiro [email protected] wrote:

Unfortunately you probably will have to delete the already created tables manually. I just saw you have some errors like:

Table 'tracker_log' already exists (SQL: create table tracker_log (id

So you were running it for the second time and in the first time those tables were created.

—
Reply to this email directly or view it on GitHub.

from tracker.

I'll send a pull request in the next few days I'm going to set some size limits on the string columns in the migration and that should stop artisan compiling that it can not assign a index to TEXT/BLOB columns.

from tracker.

The current version was tested on MySQL and works fine.

from tracker.

not on a os x 10.9 running mysql 5.6 or on ubuntu 10.3 LTS running mysql 5.1.73

from tracker.

Was the error related to ipv4_in_range or something?

composer update again and it should work.

Not that? Could show the error message?

from tracker.