Undefined property: stdClass::$column_name

[itelmenko]

• Laravel Version: 5.4.31
• Voyager Version: 0.11.14
• PHP Version: PHP 7.1.4-1+deb.sury.org~xenial+1 (cli) (built: Apr 11 2017 22:12:32) ( NTS )
• Database Driver & Version: mysql Ver 8.0.2-dmr for Linux on x86_64 (MySQL Community Server (GPL))

Description:

laradock@d347871da600:/var/www/laravel/voyager$ php artisan voyager:install --with-dummy
Publishing the Voyager assets, database, and config files
Copied Directory [/vendor/tcg/voyager/publishable/assets] To [/public/vendor/tcg/voyager/assets]
Copied Directory [/vendor/tcg/voyager/publishable/database/migrations] To [/database/migrations]
Copied Directory [/vendor/tcg/voyager/publishable/database/seeds] To [/database/seeds]
Copied Directory [/vendor/tcg/voyager/publishable/demo_content] To [/storage/app/public]
Copied File [/vendor/tcg/voyager/publishable/config/voyager.php] To [/config/voyager.php]
Publishing complete.
Copied File [/vendor/intervention/image/src/config/config.php] To [/config/image.php]
Publishing complete.
Migrating the database tables into your application

                                              
  [ErrorException]                            
  Undefined property: stdClass::$column_name  

Steps To Reproduce:

I just try to install voyager on clean laravel project. But I have such error

[itelmenko]

The reason is database/migrations/2016_01_01_000000_add_voyager_user_fields.php
line

if (!Schema::hasColumn('users', 'avatar')) {

If I remove this condition I see next error:

....
Migrating: 2017_01_15_000000_create_permission_groups_table
Migrated:  2017_01_15_000000_create_permission_groups_table
Migrating: 2017_01_15_000000_make_table_name_nullable_in_permissions_table
Migrated:  2017_01_15_000000_make_table_name_nullable_in_permissions_table
Migrating: 2017_03_06_000000_add_controller_to_data_types_table
Migrated:  2017_03_06_000000_add_controller_to_data_types_table
Migrating: 2017_04_21_000000_add_order_to_data_rows_table
Migrated:  2017_04_21_000000_add_order_to_data_rows_table
Dumping the autoloaded files and reloading all new files
Adding Voyager routes to routes/web.php
Seeding data into the database

                                            
  [InvalidArgumentException]                
  Route [voyager.posts.index] not defined.  

If I try command php artisan voyager:install --with-dummy -vvv after this for details I have no errors:

Publishing the Voyager assets, database, and config files
Copied Directory [/vendor/tcg/voyager/publishable/assets] To [/public/vendor/tcg/voyager/assets]
Copied Directory [/vendor/tcg/voyager/publishable/database/migrations] To [/database/migrations]
Copied Directory [/vendor/tcg/voyager/publishable/database/seeds] To [/database/seeds]
Copied Directory [/vendor/tcg/voyager/publishable/demo_content] To [/storage/app/public]
Publishing complete.
Publishing complete.
Migrating the database tables into your application
Nothing to migrate.
Dumping the autoloaded files and reloading all new files
Adding Voyager routes to routes/web.php
Seeding data into the database
Adding the storage symlink to your public folder
The [public/storage] directory has been linked.
Successfully installed Voyager! Enjoy 🎉

[itelmenko]

UPDATE: I use laradock. Error was when I used mysql container (run as docker-compose up -d nginx php-fpm mysql workspace). If I use mariadb container (run docker-compose up -d nginx php-fpm mariadb workspace)

I have not such error. But I have error "Route [voyager.posts.index] not defined."

...

Migrating: 2017_04_21_000000_add_order_to_data_rows_table
Migrated:  2017_04_21_000000_add_order_to_data_rows_table
Dumping the autoloaded files and reloading all new files
Adding Voyager routes to routes/web.php
Seeding data into the database

                                            
  [InvalidArgumentException]                
  Route [voyager.posts.index] not defined.  

But after rerun php artisan voyager:install --with-dummy I don't see this error.

[ruudz]

I'm trying to install Voyager on clean Laravel project and am running into the same problem.

Publishing the Voyager assets, database, and config files
Copied Directory [/vendor/tcg/voyager/publishable/assets] To [/public/vendor/tcg/voyager/assets]
Copied Directory [/vendor/tcg/voyager/publishable/database/migrations] To [/database/migrations]
Copied Directory [/vendor/tcg/voyager/publishable/database/seeds] To [/database/seeds]
Copied Directory [/vendor/tcg/voyager/publishable/demo_content] To [/storage/app/public]
Publishing complete.
Publishing complete.
Migrating the database tables into your application

                                              
  [ErrorException]                            
  Undefined property: stdClass::$column_name  
                                              

After running php artisan voyager:install (also with dummy data).

[itelmenko]

@ruudz , Do you use Laradock? What versions of mysql, php and laravel do you have?

[ruudz]

Yes, I'm using Laradock

• Voyager Version: 0.11.14
• Laravel: 5.4.*
• MySQL: 8.0.2-dmr Linux(x86_64) MySQL Community Server (GPL)
• PHP: 7.1.4-1+deb.sury.org~xenial+1 (cli) (built: Apr 11 2017 22:12:32) ( NTS )

[itelmenko]

Did you try mariadb instead of mysql?

[ruudz]

Yes, but I'm getting an error which I think has to do with my config (never worked with mariadb).
PDO::__construct(): php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution

[itelmenko]

You need update the ".env" config: DB_HOST=mariadb

[ruudz]

Thanks, a voyager:install using mariadb now results in:

Publishing the Voyager assets, database, and config files
Copied Directory [/vendor/tcg/voyager/publishable/assets] To [/public/vendor/tcg/voyager/assets]
Copied Directory [/vendor/tcg/voyager/publishable/database/migrations] To [/database/migrations]
Copied Directory [/vendor/tcg/voyager/publishable/database/seeds] To [/database/seeds]
Copied Directory [/vendor/tcg/voyager/publishable/demo_content] To [/storage/app/public]
Publishing complete.
Publishing complete.
Migrating the database tables into your application
Migration table created successfully.
Migrating: <migrations>
Migrated:  <migrations>
Dumping the autoloaded files and reloading all new files
Adding Voyager routes to routes/web.php
Seeding data into the database

                                            
  [InvalidArgumentException]                
  Route [voyager.posts.index] not defined. 

[itelmenko]

Yes, I have same error. But after rerun voyager:install it gone.

[ruudz]

Same here. Would be nice if it worked for mysql though.

[fletch3555]

There should be no issues with running MySQL, since that's what most of us maintainers use for our local dev environment. Though I don't think any of us are currently using LaraDock

[itelmenko]

@fletch3555 What Mysql version do maintainers (and you) use?

[lancepioch]

Labels: invalid

Close (user error)

[itelmenko]

It is not user's error. You can try it yourself in laradock. And you will see same error.

[ElioTohm]

found a temporary fix from the following laravel pull request
laravel/framework#21037
so basically in MySqlProcessor.php change column_name to upper case

[github-actions]

This issue has been automatically locked since there has not been any recent activity after it was closed. If you have further questions please ask in our Slack group.