What is the problem in changing the file position?

post/{:any}

you forget there a “/”

you are still doing not correct anyway

you querrying in controller the passed varriable only as “int” but you send by router any.

send in route as /post/{id}

ok sir

you are so helpful❤

these are very basic stuffs, please read some the documentation of laravel

okay sure

http://game4.baifumeiba.com/minigame/ydygdy/

Anyone have source Code of this game?

Hi Guys , can someone assist please , I have the table in my database already but when i try to migrate i get the following error msg Base table or view not found: 1146 Table ‘portifolio.post_tag’ doesn’t exist

code ?

public function run()
{
$this->call(UsersTableSeeder::class);
$this->call(PostsTableSeeder::class);
$this->call(TagsTableSeeder::class);

//TODO join tags and posts

$posts = Post::all();

Tag::get()->each(function ($tag) use ($posts){
$tag->posts()->attach($posts->pluck(‘id’));
});
}

*/
public function up()
{
Schema::create(‘posts_tags’, function (Blueprint $table) {
$table->id();
$table->BigInteger(‘posts_id’);
$table->BigInteger(‘tags_id’);
$table->timestamps();
});
}

*/
public function up()
{
Schema::create(‘posts_tags’, function (Blueprint $table) {
$table->id();
$table->BigInteger(‘posts_id’);
$table->BigInteger(‘tags_id’);
$table->timestamps();
});
}

protected $table = ‘tags’;

public function posts()
{
return $this->belongsToMany(Post::class);
}

public function tags()
{
return $this->belongsToMany(Tag::class);
}

The above is my code

can you please try again after “composer dump-autoload”

and did you use migrate ?

I have done that still the same problem

i have done dump autoload still I am getting the same error

do you know debugging ?

$posts = Post::all();

Tag::get()->each(function ($tag) use ($posts){
dd($tag, $posts);
$tag->posts()->attach($posts->pluck(‘id’));
});

yes I now

How to do pagination for this type of list when i load data by ajax

local.ERROR: Declaration of CarbonTranslator::setLocale($locale) must be compatible with SymfonyContractsTranslationLocaleAwareInterface::setLocale(string $locale) {“exception”:”[object] (Symfony\Component\ErrorHandler\Error\FatalError(code: 0): Declaration of Carbon\Translator::setLocale($locale) must be compatible with Symfony\Contracts\Translation\LocaleAwareInterface::setLocale(string $locale) at /home1/contr724/public_html/transferencia.unisecal.edu.br/vendor/nesbot/carbon/src/Carbon/Translator.php:18)
[stacktrace]

Anybody with the same error?

Shivi:
Anyone know how to make the website fast

Actually my website has data upto lakhs

So the page load very slowly

????? I have used Vue is as frontend and code igniter as backend

Check the slower part of the website and try to fix it, there is no golden rule for it.

create table notification … done (time: 0.036s)
> add foreign key FK_notific_id: notification (notification_id) references notification (id) …Exception: SQLSTATE[HY000]: General error: 3780 Referencing column ‘notification_id’ and referenced column ‘id’ in foreign key constraint ‘FK_notific_id’ are incompatible.

how i can fix this error without change migrate file position

What is the problem in changing the file position?

@themanojyadav I can change the position of the file, but I know there is another option

I have a couple of migration files, and I try to run them I get the following error:
IlluminateDatabaseQueryException : SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation “users” already exists (SQL: create table “users” (“id” uuid not null, “firstname” varchar(100) not null, “lastname” varchar(200) null, “email” varchar(200) not null, “company_id” uuid not null, “username” varchar(200) not null, “password” varchar(255) not null, “email_verified_at” timestamp(0) without time zone null, “remember_token” varchar(255) not null, “created_at” timestamp(0) with time zone null, “updated_at” timestamp(0) with time zone null, “deleted_at” timestamp(0) with time zone null))

And My migration are the following
<?php

use IlluminateDatabaseMigrationsMigration;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateSupportFacadesSchema;

class Users extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create(‘users’, function (Blueprint $table) {

$table->uuid(‘id’)->primary();
$table->string(‘firstname’, 100);
$table->string(‘lastname’, 200)->nullable();
$table->string(’email’, 200)->unique();
$table->uuid(‘company_id’);
$table->string(‘username’, 200)->unique();
$table->string(‘password’, 255);
$table->dateTime(’email_verified_at’)->nullable();
$table->string(‘remember_token’, 255);
$table->timestampsTz();
$table->softDeletesTz();
});
}

/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists(‘users’);
}
}

Anu Cliue?

if you dont have data on your tables, try to do php artisan migrate:fresh

because even if it fails during the migration, it creates some of the tables

but not doing rollback himself

I got it! @Siberfx I forgot that my migrations are inside a package and Larevel by default has an users table… 🤦‍♂️

All it’s okay with this App ?

instead of overriding, you can modify the missing fields of the packages migration file (for users table) and go for it

@Siberfx What about this error:
Invalid foreign key: 7 ERROR: there is no unique constraint matching given keys for referenced table “user_actions” (SQL: alter table “group_policies” add constraint “fk_action_id” foreign key (“action_id”) references “user_actions” (“id”))

the user_actions migration is:
class UserActions extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create(‘user_actions’, function (Blueprint $table) {
$table->uuid(‘id’);
$table->string(‘name’, 100);
$table->string(‘description’, 200);
$table->timestamps();
$table->softDeletes();
});
}

/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists(‘user_actions’);
}
}
and the group_policies migration file is, the following, where the error appears:
class GroupPolicies extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create(‘group_policies’, function (Blueprint $table) {
$table->uuid(‘id’);
$table->uuid(‘group_id’);
$table->uuid(‘resource_id’);
$table->uuid(‘action_id’);
$table->timestamps();
$table->softDeletes();

$table->foreign(‘group_id’, ‘fk_group_id’)
->references(‘id’)
->on(‘groups’);

$table->foreign(‘action_id’, ‘fk_action_id’)
->references(‘id’)
->on(‘user_actions’);

$table->index(
[‘group_id’, ‘resource_id’,’action_id’],
‘group_resource_action_idx’
);
});
}

/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table(‘group_policies’, function (Blueprint $table) {
$table->dropForeign(‘group_id’);
$table->dropForeign(‘action_id’);
});

Schema::dropIfExists(‘group_policies’);
}
}

which package is it and for what I am interested 🙂

It’s my own package, I’m writting this one as first one… actually I’m learning about the packages 😉

why do you need so many uuid ?

cause I think that is more stable and it can grow without issues

if it fits your requirements, thats ok