Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Column 'licenseid' cannot be null after accepting the order #4

Closed
Th3St0ni3 opened this issue Feb 10, 2022 · 2 comments
Closed

Column 'licenseid' cannot be null after accepting the order #4

Th3St0ni3 opened this issue Feb 10, 2022 · 2 comments

Comments

@Th3St0ni3
Copy link

Describe the bug
Every time a customer (in my case a test customer) books a license via the system, I get the following error message as soon as I release the order.

Error: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'licenseid' cannot be null (SQL: insert into mod_tekbase_licenses (serviceid, customerid, licenseid, licensekey, siteip, siteurl, sitepath, version, cms, shop, gwislots, rwislots, swislots, updated_at, created_at) values (31, MeMpbFwD3e8q, ?, Not retrieved yet.
To retrieve the License Key make sure you've set url and path at the settings!, , domain/tekbase/, /var/www/vhosts/domain/httpdocs/tekbase/, private, ?, ?, 1, 1, 1, 2022-02-10 13:35:27, 2022-02-10 13:35:27))

domain is replaced with the correct values in the original error message and is only entered here for anonymization.

I hope you can help me to solve the problem.

To Reproduce
Steps to reproduce the behavior:

  1. Create an order as an customer
  2. As Admin, try to accept the order. As soon as you try it the error is displayed
  3. See error

Versions:

  • WHMCS: 8.4.0
  • tekbase-whmcs: latets downloadable version

Logs:

10.02.2022 13:35 {"StatusCode":"500","Message":"Server replied with an error."}

10.02.2022 13:35 Module Create Failed - Service ID: 31 - Error: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'licenseid' cannot be null (SQL: insert into mod_tekbase_licenses (serviceid, customerid, licenseid, licensekey, siteip, siteurl, sitepath, version, cms, shop, gwislots, rwislots, swislots, updated_at, created_at) values (31, MeMpbFwD3e8q, ?, Not retrieved yet.
To retrieve the License Key make sure you've set url and path at the settings!, , domain/tekbase/, /var/www/vhosts/domain/httpdocs/tekbase/, private, ?, ?, 1, 1, 1, 2022-02-10 13:35:27, 2022-02-10 13:35:27))

@ConanDoyl
Copy link
Owner

Thanks, i'll check that.

ConanDoyl pushed a commit that referenced this issue Feb 10, 2022
Signed-off-by: Thomas Brinkmann <doyl@dsh.icu>
ConanDoyl added a commit that referenced this issue Feb 10, 2022
#4 - Bugfix - Fixed the empty license id
@ConanDoyl
Copy link
Owner

Has been fixed in the new Release =)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants