Martin1182

Hi sorry I'm bothering me again, but I don't understand that I can't start the migration .... What am I doing wrong ??

 public function up()
    {
        Schema::create('order_product', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('order_id')->nullable();
            $table->unsignedBigInteger('product_id')->nullable();

            $table->foreign('order_id')->references('id')->on('orders')->onUpdate('cascade')->onDelete('set null');
            $table->foreign('product_id')->references('id')->on('products')->onUpdate('cascade')->onDelete('set null');

            $table->integer('quantity')->unsigned();
            $table->timestamps();
        });

    }

 public function up()
    {
        Schema::create('orders', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('user_id')->nullable();
            $table->foreign('user_id')->references('id')->on('users')->onUpdate('cascade')->onDelete('set null');

            $table->string('billing_email')->nullable();
            $table->string('billing_name')->nullable();
            $table->string('billing_address')->nullable();
            $table->string('billing_city')->nullable();
            $table->string('billing_province')->nullable();
            $table->string('billing_postalcode')->nullable();
            $table->string('billing_phone')->nullable();
            $table->string('billing_name_on_card')->nullable();
            $table->integer('billing_discount')->default(0);
            $table->string('billing_discount_code')->nullable();
            $table->integer('billing_subtotal');
            $table->integer('billing_tax');
            $table->integer('billing_total');
            $table->string('payment_gateway')->default('stripe');
            $table->boolean('shipped')->default(false);
            $table->string('error')->nullable();
            $table->timestamps();
        });
    }

Hi, I'm getting the following error ... Don't know where the error might be?

Facade\Ignition\Exceptions\ViewException file_exists(): open_basedir restriction in effect. File(storage/products/dummy/laptop-1.jpg) is not within the allowed path(s): (/nfsmnt/:/data/:/usr/php74/:/usr/bin/:/apachetmp:/tmp/:/var/tmp/:/dev/urandom:/usr/lib/x86_64-linux-gnu/ImageMagick-6.8.9/bin-Q16/:/usr/local/bin/:/etc/ssl/certs/ca-certificates.crt) (View: /data/8/1/8120c1e3-a8d3-49dd-abe7-d9b8b3a41100/halaj.online/web/resources/views/product.blade.php)

function productImage($path)

{

    return $path && file_exists('storage/'.$path) ? asset('storage/'.$path) : asset('img/not-found.png');

}

THX

Now I have a problem with seeding

   Illuminate\Database\QueryException

  SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value (SQL: insert into `category_product` (`category_id`, `product_id`) values (1, 1))

  at D:\www\MAGZ-Ecommerce\vendor\laravel\framework\src\Illuminate\Database\Connection.php:671
    667|         // If an exception occurs when attempting to run a query, we'll format the error
    668|         // message to include the bindings with SQL, which will make this exception a
    669|         // lot more helpful to the developer instead of just the database's errors.
    670|         catch (Exception $e) {
  > 671|             throw new QueryException(
    672|                 $query, $this->prepareBindings($bindings), $e
    673|             );
    674|         }
    675|

  1   D:\www\MAGZ-Ecommerce\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:129
      Doctrine\DBAL\Driver\PDOException::("SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value")

  2   D:\www\MAGZ-Ecommerce\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:127
      PDOException::("SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value")

public function up()
    {
        Schema::create('categories', function (Blueprint $table) {
            $table->id();
            $table->string('name')->unique();
            $table->string('slug')->unique();
            $table->timestamps();
        });
    }

public function run()
    {
        // Laptops
        for ($i = 1; $i <= 30; $i++) {
            Product::create([
                'name' => 'Laptop ' . $i,
                'slug' => 'laptop-' . $i,
                'details' => [13, 14, 15][array_rand([13, 14, 15])] . ' inch, ' . [1, 2, 3][array_rand([1, 2, 3])] . ' TB SSD, 32GB RAM',
                'price' => rand(149999, 249999),
                'description' => 'Lorem ' . $i . ' ipsum dolor sit amet, consectetur adipisicing elit. Ipsum temporibus iusto ipsa, asperiores voluptas unde aspernatur praesentium in? Aliquam, dolore!',
            ])->categories()->attach(1);
        }

        // Make laptop have a category of "Desktop" as well.
        $product = Product::find(1);
        $product->categories()->attach(2);

        // Desktops
        for ($i = 1; $i <= 9; $i++) {
            Product::create([
                'name' => 'Desktop ' . $i,
                'slug' => 'desktop-' . $i,
                'details' => [24, 25, 27][array_rand([24, 25, 27])] . ' inch, ' . [1, 2, 3][array_rand([1, 2, 3])] . ' TB SSD, 32GB RAM',
                'price' => rand(249999, 449999),
                'description' => 'Lorem ' . $i . ' ipsum dolor sit amet, consectetur adipisicing elit. Ipsum temporibus iusto ipsa, asperiores voluptas unde aspernatur praesentium in? Aliquam, dolore!',
            ])->categories()->attach(2);
        }

        // Phones
        for ($i = 1; $i <= 9; $i++) {
            Product::create([
                'name' => 'Phone ' . $i,
                'slug' => 'phone-' . $i,
                'details' => [16, 32, 64][array_rand([16, 32, 64])] . 'GB, 5.' . [7, 8, 9][array_rand([7, 8, 9])] . ' inch screen, 4GHz Quad Core',
                'price' => rand(79999, 149999),
                'description' => 'Lorem ' . $i . ' ipsum dolor sit amet, consectetur adipisicing elit. Ipsum temporibus iusto ipsa, asperiores voluptas unde aspernatur praesentium in? Aliquam, dolore!',
            ])->categories()->attach(3);
        }

        // Tablets
        for ($i = 1; $i <= 9; $i++) {
            Product::create([
                'name' => 'Tablet ' . $i,
                'slug' => 'tablet-' . $i,
                'details' => [16, 32, 64][array_rand([16, 32, 64])] . 'GB, 5.' . [10, 11, 12][array_rand([10, 11, 12])] . ' inch screen, 4GHz Quad Core',
                'price' => rand(49999, 149999),
                'description' => 'Lorem ' . $i . ' ipsum dolor sit amet, consectetur adipisicing elit. Ipsum temporibus iusto ipsa, asperiores voluptas unde aspernatur praesentium in? Aliquam, dolore!',
            ])->categories()->attach(4);
        }

        // TVs
        for ($i = 1; $i <= 9; $i++) {
            Product::create([
                'name' => 'TV ' . $i,
                'slug' => 'tv-' . $i,
                'details' => [46, 50, 60][array_rand([7, 8, 9])] . ' inch screen, Smart TV, 4K',
                'price' => rand(79999, 149999),
                'description' => 'Lorem ' . $i . ' ipsum dolor sit amet, consectetur adipisicing elit. Ipsum temporibus iusto ipsa, asperiores voluptas unde aspernatur praesentium in? Aliquam, dolore!',
            ])->categories()->attach(5);
        }

        // Cameras
        for ($i = 1; $i <= 9; $i++) {
            Product::create([
                'name' => 'Camera ' . $i,
                'slug' => 'camera-' . $i,
                'details' => 'Full Frame DSLR, with 18-55mm kit lens.',
                'price' => rand(79999, 249999),
                'description' => 'Lorem ' . $i . ' ipsum dolor sit amet, consectetur adipisicing elit. Ipsum temporibus iusto ipsa, asperiores voluptas unde aspernatur praesentium in? Aliquam, dolore!',
            ])->categories()->attach(6);
        }

        // Appliances
        for ($i = 1; $i <= 9; $i++) {
            Product::create([
                'name' => 'Appliance ' . $i,
                'slug' => 'appliance-' . $i,
                'details' => 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Perferendis, dolorum!',
                'price' => rand(79999, 149999),
                'description' => 'Lorem ' . $i . ' ipsum dolor sit amet, consectetur adipisicing elit. Ipsum temporibus iusto ipsa, asperiores voluptas unde aspernatur praesentium in? Aliquam, dolore!',
            ])->categories()->attach(7);
        }

        // Select random entries to be featured
        Product::whereIn('id', [1, 12, 22, 31, 41, 43, 47, 51, 53, 61, 69, 73, 80])->update(['featured' => true]);
    }

Can you help me?

Yes it already works thank you.

categories

Hi, Can anyone help me fix a migration bug?

public function up()
    {
        Schema::create('category_product', function (Blueprint $table) {
            $table->unsignedBigInteger('id', true);
            $table->integer('product_id')->unsigned()->nullable();
            $table->foreign('product_id')->references('id')
                ->on('products')->onDelete('cascade');
            $table->integer('category_id')->unsigned()->nullable();
            $table->foreign('category_id')->references('id')
                ->on('category')->onDelete('cascade');
            $table->timestamps();
        });
    }

Error

   Illuminate\Database\QueryException

  SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table `category_product` add constraint `category_product_product_id_foreign` foreign key (`product_id`) references `products` (`id`) on delete cascade)

  at D:\www\MAGZ-Ecommerce\vendor\laravel\framework\src\Illuminate\Database\Connection.php:671
    667|         // If an exception occurs when attempting to run a query, we'll format the error
    668|         // message to include the bindings with SQL, which will make this exception a
    669|         // lot more helpful to the developer instead of just the database's errors.
    670|         catch (Exception $e) {
  > 671|             throw new QueryException(
    672|                 $query, $this->prepareBindings($bindings), $e
    673|             );
    674|         }
    675|

  1   D:\www\MAGZ-Ecommerce\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:129
      Doctrine\DBAL\Driver\PDOException::("SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint")

  2   D:\www\MAGZ-Ecommerce\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:127
      PDOException::("SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint")

Thank you for all the help!

Hi everybody... I use voyager as an admin dashboard. The point is that if I try to make an update and I am logged in as an admin with all rights, it will redirect me to the homepage and role_id will be deleted from the database. Changes will be saved .... This will only happen if the admin wants to edit his data. This does not happen when editing other users. Can you help me? Thank you

Voyager/UsersController.php

namespace App\Http\Controllers\Voyager;

use Illuminate\Http\Request;
use TCG\Voyager\Facades\Voyager;
use Illuminate\Database\Eloquent\Model;
use TCG\Voyager\Events\BreadDataUpdated;
use TCG\Voyager\Http\Controllers\VoyagerBaseController;
use TCG\Voyager\Http\Controllers\Traits\BreadRelationshipParser;

class UsersController extends VoyagerBaseController
{
	use BreadRelationshipParser;

	public function update(Request $request, $id)
	{
		$slug = $this->getSlug($request);

		$dataType = Voyager::model('DataType')->where('slug', '=', $slug)->first();

		// Compatibility with Model binding.
		$id = $id instanceof Model ? $id->{$id->getKeyName()} : $id;

		$data = call_user_func([$dataType->model_name, 'findOrFail'], $id);

		// Check permission
		$this->authorize('edit', $data);

		if (!auth()->user()->hasPermission('edit_roles')) {

			unset($request['role_id']);

			return back()->with([
				'message' => '....ERROR....',
				'alert-type' => 'error',
			]);
		}

		// Validate fields with ajax
		$val = $this->validateBread($request->all(), $dataType->editRows, $slug, $id);

		if ($val->fails()) {
			return response()->json(['errors' => $val->messages()]);
		}

		if (!$request->ajax()) {
			$this->insertUpdateData($request, $slug, $dataType->editRows, $data);

			event(new BreadDataUpdated($dataType, $data));

			return redirect()
				->route("voyager.{$dataType->slug}.index")
				->with([
					'message' => __('successfully_updated') . " {$dataType->display_name_singular}",
					'alert-type' => 'success',
				]);
		}
	}
}

thx...

Hi, Could you help me fix the error I'm getting?

CartUpdatedListener.php

    public function handle($event)
    {
        $couponName = session()->get('coupon')['name'];

        if ($couponName) {
            $coupon = Coupon::where('code', $couponName)->first();

            dispatch_now(new UpdateCoupon($coupon));
        }
    }

Execute the job

public function handle()
    {
        if (Cart::currentInstance() === 'default') {
            session()->put('coupon', [
                'name' => $this->coupon->code,
                'discount' => $this->coupon->discount(Cart::subtotal()),
            ]);
        }
    }

ERROR: Trying to access array offset on value of type null

thx.

Greetings and if it's Oauth? well thank you

public function githubRedirect() {

    $user = Socialite::driver('github')->user();
    $user = User::firstOrCreate([
        'email' => $user->email,
        'github_id' => $user->id,
        'avatar' => $user->avatar,
    ], [
        'name' => $user->name,
        'password' => Hash::make(Str::random(24)),
    ]);
    Auth::login($user, true);
    
    return redirect('/home')->with('flash', 'HELLO! You are logged in');

}

Good day. When registering a user in the register controller, I would like to call the update function in apiTokenController to automatically create an api_token and save this token in the DB. I want to do this so that the user has api_token assigned to him after registration so that he does not have to request it manually. What is the best way? Well thank you.

protected function create(array $data) {

    return User::create([
        'name' => $data['name'],
        'email' => $data['email'],
        'password' => Hash::make($data['password']),
        'api_token' => Str::random(80),
    ]);
}

public function update(Request $ request) {

    $token = Str::random(60);

    $request->user()->forceFill([
        'api_token' => hash('sha256', $token),
    ])->save();

    return ['token' => $token];
}

Hi, can you advise me? I'm trying to get an api in the VUE component. It still returns an error. The application runs in laravel. well thank you

mounted: function() {

   return axios(
            `https://newsapi.org/v2/top-headlines?sources=bbc- 
              news&apiKey=2a571f1425d44f8ab56de12e0e0e9b1b`,
            {
	    method: 'GET',
                mode: "no-cors",
                headers: {
                    "Access-Control-Allow-Origin": "*",
                    "Content-Type": "application/json"
                },
                withCredentials: true,
                credentials: "same-origin"
            }
        )
        .then(response => {
            this.posts = [];
            response.data.articles.forEach(posts => {
                this.posts.push(this.extractData(posts));
            });
        })
        .catch(response => {
            console.log(response);
        });

},

error:

Access to XMLHttpRequest at 'https://newsapi.org/v2/top-headlines?sources=bbc-news&apiKey=2a571f1425d44f8ab56de12e0e0e9b1b' from origin 'http://localhost' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource.

Hi, it's not working

Hello, can anyone advise me how to do pagination in the model? I have an album with pictures and I would like to see, for example, 20 pictures. Thanks for help

namespace App;

use Illuminate\Database\Eloquent\Model;

class Album extends Model {

protected $fillable =
[
    'title', 'text', 'image'
];
public function images()
{
  return $this->hasMany('App\Image')->latest();
}

}

Hi thank you for your advice, but it didn't help me.

url my app is : https://laravel.halaj.online/albums --- So far you're just a detsktop version on the phone it will not work.

When I uploaded the app to the server, the code for adding images to the gallery stopped working. On localhost, the code worked without error and the images were added to the DB and folder.

The development environment is windows. Server linux. Images are sent via axios to the api controller. no error message will be added to the console. Images will not be written to the database or folder. Thanks for help

public function store(Request $request) {

    $this->validate($request, [
        'images' => 'required',
        'images.*' => 'image|mimes:jpeg,png,jpg,gif,svg|max:3600'
    ]);

    $albumId = $request->get('album_id');

    if($request->hasFile('images')) {
        foreach($request->file('images') as $image) {
            $filename = strtolower ( trim ( $image->getClientOriginalName() ));
            $name = time().rand(100,999).$filename;
            $destinationPath = public_path('img/gallery-img/');
            $image->move($destinationPath, $name);

            $image = new Image([
                'image' => $name,
                'album_id' => $albumId
            ]);

            $image->save();
        }
    }

    return response()->json([
    'message' => 'All images uplaoded successfully',
    ], 201);
}

The full app code is here: https://github.com/Martin-1182/CMS

server: Apache 2,4 PHP 7.3

I modified folder permissions to 775

chmod 775 -R storage

It didn't help me ... do you have any idea?

There is no existing directory at "/home/halaj.online/sub/laravel/storage/logs" and its not buildable: Permission denied

Can I tell you how to fix this problem? I have now uploaded the application to the server and cleared the cache. Has anyone encountered such a problem?

https://laravel.halaj.online/

Error not resolved. I work in windows but I never got this error.

https://laravelcms.halaj.online/

I set

sudo chmod 775 -R storage

Could they sre advise me how to fix it ?? thx

Error not resolved. I work in windows but I never got this error.

https://laravelcms.halaj.online/

I set

sudo chmod 775 -R storage

Could they sre advise me how to fix it ?? thx

Please, I threw laravel on the web and is there a mistake you can tell me how to remove it ??? on locale it normally works all ok and not on the server. thanks

https://laravelcms.halaj.online/