php artisan db:seed --class=WorldSeeder Problem

[phemorah]

Running the seeder command php artisan db:seed --class=WorldSeeder does nothing. The Countries and States don't get to populate any record in the database.

Kindly assist.. Thank you

[nnjeim]

Hi. Please check 2 things1- did you publish the package? php artisan vendor: publish ….etc2- do you any php memory limit issue? Try to set php.ini memory limit to -1Restart your php fpm if using.This should fix the issueThanksSent from my iPhoneOn 17 Apr 2023, at 07:18, Femi Ajao @.***> wrote: Running the seeder command php artisan db:seed --class=WorldSeeder does nothing. The Countries and States don't get to populate any record in the database. Kindly assist.. Thank you

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you are subscribed to this thread.Message ID: @.***>

[phemorah]

Hi, thank you for your prompt response.

There seems to be no luck yet after carrying out your 2 suggestions.

First, I had to go over to roll out the vendor publishing; php artisan vendor:publish --tag=world once again. And secondly, I set my php memory_limit under the php.init file from 250M to -1 and had to restart my local wamp server.

Is there anything else I can do to get the php artisan db:seed --class=WorldSeeder command populating the countries and states records in my database please?

Cheers!

On Mon, 17 Apr 2023, 5:44 am Najm Njeim @.***> wrote:

Hi. Please check 2 things1- did you publish the package? php artisan vendor: publish ….etc2- do you any php memory limit issue? Try to set php.ini memory limit to -1Restart your php fpm if using.This should fix the issueThanksSent from my iPhoneOn 17 Apr 2023, at 07:18, Femi Ajao @.***> wrote: Running the seeder command php artisan db:seed --class=WorldSeeder does nothing. The Countries and States don't get to populate any record in the database. Kindly assist.. Thank you

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you are subscribed to this thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub https://github.com/nnjeim/world/issues/53#issuecomment-1510689085, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHLABJT45DGAJ6RRBY5A6CTXBTDEPANCNFSM6AAAAAAXAT3BNM . You are receiving this because you authored the thread.Message ID: @.***>

[nnjeim]

Are you getting any error when trying to seed? I am assuming that you run php artisan migrate.If yes are the tables being created in your DB?Sent from my iPhoneOn 17 Apr 2023, at 13:33, Femi Ajao @.***> wrote: Hi, thank you for your prompt response.

There seems to be no luck yet after carrying out your 2 suggestions.

First, I had to go over to roll out the vendor publishing; php artisan vendor:publish --tag=world once again. And secondly, I set my php memory_limit under the php.init file from 250M to -1 and had to restart my local wamp server.

Is there anything else I can do to get the php artisan db:seed --class=WorldSeeder command populating the countries and states records in my database please?

Cheers!

On Mon, 17 Apr 2023, 5:44 am Najm Njeim @.***> wrote:

Hi. Please check 2 things1- did you publish the package? php artisan vendor: publish ….etc2- do you any php memory limit issue? Try to set php.ini memory limit to -1Restart your php fpm if using.This should fix the issueThanksSent from my iPhoneOn 17 Apr 2023, at 07:18, Femi Ajao @.***> wrote: Running the seeder command php artisan db:seed --class=WorldSeeder does nothing. The Countries and States don't get to populate any record in the database. Kindly assist.. Thank you

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you are subscribed to this thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub https://github.com/nnjeim/world/issues/53#issuecomment-1510689085, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHLABJT45DGAJ6RRBY5A6CTXBTDEPANCNFSM6AAAAAAXAT3BNM . You are receiving this because you authored the thread.Message ID: @.***>

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you commented.Message ID: @.***>

[phemorah]

Yes, I ran a *php migrate" command and the tables were all migrated successfully.

Meanwhile, I'm not getting any error when I run "php artisan db:seed --class=WorldSeeder" command. it only shows "seeding database" on the console when i run the command, it then takes me back to the original command prompt directory line where I would enter a command again.

On Mon, 17 Apr 2023, 1:12 pm Najm Njeim @.***> wrote:

Are you getting any error when trying to seed? I am assuming that you run php artisan migrate.If yes are the tables being created in your DB?Sent from my iPhoneOn 17 Apr 2023, at 13:33, Femi Ajao @.***> wrote: Hi, thank you for your prompt response.

There seems to be no luck yet after carrying out your 2 suggestions.

First, I had to go over to roll out the vendor publishing; php artisan vendor:publish --tag=world once again. And secondly, I set my php memory_limit under the php.init file from 250M to -1 and had to restart my local wamp server.

Is there anything else I can do to get the php artisan db:seed --class=WorldSeeder command populating the countries and states records in my database please?

Cheers!

On Mon, 17 Apr 2023, 5:44 am Najm Njeim @.***> wrote:

Hi. Please check 2 things1- did you publish the package? php artisan vendor: publish ….etc2- do you any php memory limit issue? Try to set php.ini memory limit to -1Restart your php fpm if using.This should fix the issueThanksSent from my iPhoneOn 17 Apr 2023, at 07:18, Femi Ajao @.***> wrote: Running the seeder command php artisan db:seed --class=WorldSeeder does nothing. The Countries and States don't get to populate any record in the database. Kindly assist.. Thank you

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you are subscribed to this thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub https://github.com/nnjeim/world/issues/53#issuecomment-1510689085, or unsubscribe < https://github.com/notifications/unsubscribe-auth/AHLABJT45DGAJ6RRBY5A6CTXBTDEPANCNFSM6AAAAAAXAT3BNM

. You are receiving this because you authored the thread.Message ID: @.***>

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub https://github.com/nnjeim/world/issues/53#issuecomment-1511225539, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHLABJTKDKDB7AE2TSQ2NDDXBUXSJANCNFSM6AAAAAAXAT3BNM . You are receiving this because you authored the thread.Message ID: @.***>

[nnjeim]

can you please check that your table are created and empty? if you are running a db:seed and the table are containing data, the seeder action will skip. as a sanity check i did the following on laravel-world.com 1- I dropped all the existing tables. 2- I have deleted the related entries from the migrations table. 3- I have re-published the package as php artisan vendor:publish --tag=world --force 4- I have run the migrations php artisan migrate 5- I run the seeder php artisan db:seed --class=WorldSeeder

If you upgrading from a previous version you are run php artisan world:refresh

[phemorah]

Thank you for your relentless efforts bro. I will give all your newly outlined steps/procedures a try. Meanwhile, what are the affected tables which are associated with the WorldSeeder migration actions, that would suggest I delete before re-running the migration afresh please?

Regards

On Mon, 17 Apr 2023, 2:33 pm Najm Njeim @.***> wrote:

can you please check that your table are created and empty? if you are running a db:seed and the table are containing data, the seeder action will skip. as a sanity check i did the following on laravel-world.com 1- I dropped all the existing tables. 2- I have deleted the related entries from the migrations table. 3- I have re-published the package as php artisan vendor:publish --tag=world --force 4- I have run the migrations php artisan migrate 5- I run the seeded php artisan db:seed --class=WorldSeeder [image: Screenshot 2023-04-17 at 16 32 32] https://user-images.githubusercontent.com/78922079/232499466-c0cf1bab-375b-470c-ab48-8686d20b19f7.jpg

If you upgrading from a previous version you are run php artisan world:refresh

— Reply to this email directly, view it on GitHub https://github.com/nnjeim/world/issues/53#issuecomment-1511357491, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHLABJW6N5OSUE26TLNSEA3XBVBA3ANCNFSM6AAAAAAXAT3BNM . You are receiving this because you authored the thread.Message ID: @.***>

[nnjeim]

Hi again,

you need to drop the countries, states, cities, languages, currencies and timezone tables. A total of 6. then edit the migrations table by deleting the rows corresponding to the above tables.

[phemorah]

The six nnjeim/world package database tables are all empty. Meanwhile I had a challenge migrating the tables after i manually dropped them directly using PhpMyAdmin.

It appears that nnjeim/world package has its migration files separated from the Laravel default migration path. Kindly guide me on how to drop the 6 tables and delete all the related entries from migration table without PhpMyAdmin.

I'm a little stuck here and I will be glad if you can assist further.

Thank you.

On Mon, 17 Apr 2023, 3:08 pm Najm Njeim @.***> wrote:

Hi again,

you need to drop the countries, states, cities, languages, currencies and timezone tables. A total of 6. then edit the migrations table by deleting the rows corresponding to the above tables.

— Reply to this email directly, view it on GitHub https://github.com/nnjeim/world/issues/53#issuecomment-1511425644, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHLABJXLZBCR6QD5I7AMVBLXBVFFNANCNFSM6AAAAAAXAT3BNM . You are receiving this because you authored the thread.Message ID: @.***>

[nnjeim]

Hi,

When you require the package nnjeim/world and following the post steps.

you should be able to run the migrate console command.

i have the feeling that there is something wrong in your local setup that is not allowing the migrations in the package to be loaded.

As if i understood you are running in windows it could be related to this.

On 17 Apr 2023, at 20:16, Femi Ajao @.***> wrote:

The six nnjeim/world package database tables are all empty. Meanwhile I had a challenge migrating the tables after i manually dropped them directly using PhpMyAdmin.

It appears that nnjeim/world package has its migration files separated from the Laravel default migration path. Kindly guide me on how to drop the 6 tables and delete all the related entries from migration table without PhpMyAdmin.

I'm a little stuck here and I will be glad if you can assist further.

Thank you.

On Mon, 17 Apr 2023, 3:08 pm Najm Njeim @.***> wrote:

Hi again,

you need to drop the countries, states, cities, languages, currencies and timezone tables. A total of 6. then edit the migrations table by deleting the rows corresponding to the above tables.

— Reply to this email directly, view it on GitHub https://github.com/nnjeim/world/issues/53#issuecomment-1511425644, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHLABJXLZBCR6QD5I7AMVBLXBVFFNANCNFSM6AAAAAAXAT3BNM . You are receiving this because you authored the thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub https://github.com/nnjeim/world/issues/53#issuecomment-1511771865, or unsubscribe https://github.com/notifications/unsubscribe-auth/AS2ECX3MULTOG5IALB4VVGDXBV3INANCNFSM6AAAAAAXAT3BNM. You are receiving this because you commented.

[calrloco]

if u had the same problem and don't know how to fix it, i fixed it by temporarily increasing the memory limit in the artisan command.

php -d memory_limit=1G artisan db:seed --class=WorldSeeder

[nnjeim]

Hi the memory limit can be -1Sent from my iPhoneOn 29 Feb 2024, at 11:48, carlo briganti @.***> wrote: if u had the same problem and don't know how to fix it, i fixed it by temporarily increasing the memory limit in the artisan command. php -d memory_limit=1G artisan db:seed --class=WorldSeeder

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you modified the open/close state.Message ID: @.***>