[ixpmanager] Your user account is not associated with any members., Why?

[Basil Elbalaawi]

Hi Yann

i am posed :
systemctl restart memcached.service
php ${IXPROOT}/artisan update:customer

*root at ixpmanager:/srv/ixpmanager# php artisan update:customer*


ONLY RUN ONCE AND ONLY WHEN UPGRADING TO IXP Manager v5.0.0 from v4.9.x

THIS WILL TRUNCATE THE customer:user n:m TABLE - meaning any users created
after upgrading to v5.0.0 will be unlinked from their customers.


This command will restructure the customer/user data from 1:m to n:m.

Generally, this command should only ever be run once and only when
migrating to V5.0.0.

Are you sure you wish to proceed?  (yes/no) [no]:
 > yes

The customer_to_users table has been truncated
Migration in progress, please wait...
 0/2 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   0%
In AbstractMySQLDriver.php line 103:

  An exception occurred while executing 'INSERT INTO customer_to_users
(privs, extra_attributes, last_login_date, last_login_from, last_login_via,
created_at, customer_id, user_id) V
  ALUES (?, ?, ?, ?, ?, ?, ?, ?)' with params [3,
"{\"created_by\":{\"type\":\"migration-script\"}}", null, false, null,
"2020-12-29 11:44:47", null, 1]:

  SQLSTATE[23000]: Integrity constraint violation: 1048 Column
'customer_id' cannot be null


In PDOStatement.php line 129:

  SQLSTATE[23000]: Integrity constraint violation: 1048 Column
'customer_id' cannot be null


In PDOStatement.php line 127:

  SQLSTATE[23000]: Integrity constraint violation: 1048 Column
'customer_id' cannot be null



*without any change ! What can I do now???*

FYI, i am installed v5.5 before 5 months and upgrade to v5.6 without any
problem , now i created now VM with v5.7 and follow every procedure in the
manual installation , but after completed then puase
http://192.168.1.202/login , get the error as you see in the link:
https://imgur.com/a/Rqf0bT5


On Tue, Dec 29, 2020 at 10:44 AM Yann Robin <yann at islandbridgenetworks.ie>
wrote:

> Hello,
>
> Did you run the following command line ?
>
> update:customer2users
>
> This command should solve your issue.
>
> Basil Elbalaawi wrote on 27/12/2020 10:19:
>
> Dear support
>
> After I finish the installation , I can't login to the ixpmanager web
> access, whey?
> so you can check the link to see the problem?
>
> https://imgur.com/a/Rqf0bT5
>
> thanks advanced,,,
>
>
> _______________________________________________
> INEX IXP Manager mailing listixpmanager at inex.ie
> Unsubscribe or change options here: https://www.inex.ie/mailman/listinfo/ixpmanager
>
>
> --
> Kind regards,
>
> Yann Robin
>
> +353 1 531 3334
>
> Island Bridge Networks Ltd.
>
> https://www.islandbridgenetworks.ie/ <http://www.islandbridgenetworks.ie/>
>
> <https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.inex.ie/pipermail/ixpmanager/attachments/20201229/45a2b88b/attachment.htm>