Customer Registration error

[lovue]

Hello,

I have v1.4.1 and using the Novator template extension. When registering a new customer account and hitting the submit button, it will redirect to a /static_page/index.php error page. It does not tell me if the customer creation was successful or not. When I look in the admin backend, I can see that the new customer was created. Why is it throwing this error when it does in fact create a new customer? How do I configure to show a successful customer creation response page?

[abolabo]

please read this https://forum.abantecart.com/index.php/topic,3197.0.html

[Basara]

I can see that the new customer was created. Why is it throwing this error when it does in fact create a new customer?

Hello.
Please check your AbanteCart error log. Have you recently made changes to any languages or email templates?"

[lovue]

I did not make any language or email template changes. The only changes we did before this error is upgrading Abantecart from v1.3.4, to v1.4.0 and then to v1.4.1. I recreated the issue today and the error log says:

"2025-04-02 3:29:40 - database error: AbanteCart core v.1.4.1 SQL Error: Table 'databasename.abpz_customer_sessions' doesn't exist\nError No: 1146\nSQL: SELECT c.*, cg.*
FROM abpz_customers c
LEFT JOIN abpz_customer_groups cg
ON c.customer_group_id = cg.customer_group_id
INNER JOIN abpz_customer_sessions cs
ON c.customer_id = cs.customer_id
WHERE c.customer_id = '33'
AND cs.session_id = '1a7b2f2c285303d9160b01663e915fda' AND status = '1'PHP call stack:
#0 /home/domain/public_html/core/lib/db.php:119
#1 /home/domain/public_html/core/engine/extensions.php:1159
#2 /home/domain/public_html/core/engine/extensions.php:390
#3 /home/domain/public_html/core/lib/db.php:85
#4 /home/domain/public_html/core/lib/customer.php:93
#5 /home/domain/public_html/index.php:72
in /home/domain/public_html/core/database/amysqli.php on line 162"

[Basara]

I did not make any language or email template changes. The only changes we did before this error is upgrading Abantecart from v1.3.4, to v1.4.0 and then to v1.4.1. I recreated the issue today and the error log says:

"2025-04-02 3:29:40 - database error: AbanteCart core v.1.4.1 SQL Error: Table 'databasename.abpz_customer_sessions' doesn't exist\nE

Hello.

It seems that the missing table error is a clear indication that the upgrade process might not have completed successfully. Could you clarify whether you upgraded from version 1.4.0 to 1.4.1 manually (e.g., through file uploads) or automatically using a link or upgrade key? Additionally, did you encounter any errors or unusual messages during the upgrade process? Understanding these details will help us pinpoint the root of the issue.

[lovue]

I upgraded automatically using a link from the message manager inbox. Nothing unusual during the upgrade but after the upgrade, I couldn't get the admin console login page to load and it was giving a "webserver need version php8.2+ to work properly" error. But after clearing cache and using a different web browser I was able to log in. I didn't notice anything wrong with abantecart or the database.

[abolabo]

I upgraded automatically using a link from the message manager inbox. Nothing unusual during the upgrade but after the upgrade, I couldn't get the admin console login page to load and it was giving a "webserver need version php8.2+ to work properly" error. But after clearing cache and using a different web browser I was able to log in. I didn't notice anything wrong with abantecart or the database.

We noticed that some database servers ignores some of sql-queries of upgrade script.
Can you tell us what database server version do you use? (see server info link under tabs in your phpAdmin)

Anyway to solve issue you should to run every SQL query from file https://github.com/abantecart/abantecart-src/blob/master/public_html/install/abantecart_database_upgrade.sql
inside phpAdmin ( do not forget to change table prefix before run! ).
Also check privileges of your database user. Just set GRANT ALL for him before execution of sql.
Probably some of them was ran successfully during upgrade process.

[lovue]

server version is 8.0.41 - MySQL Community Server - GPL, protocol version 10. Ok will run the SQL queries and let you know if that works. Thanks!

[lovue]

server version is 8.0.41 - MySQL Community Server - GPL, protocol version 10. Ok will run the SQL queries and let you know if that works. Thanks!

Running the SQL command CREATE TABLE `ac_customer_sessions`; resolved my issue. Thank you so much!