AbanteCart Community

AbanteCart Development => Extensions and Add-Ons => Topic started by: AromeCity on March 28, 2025, 12:58:50 AM

Title: Unable to save Options
Post by: AromeCity on March 28, 2025, 12:58:50 AM

Hi,

I am using Version 1.3.4.

I am unable to save options. See screen shot below.

Do I need to first enable some other feature for options to be enable cart wise?

Title: Re: Unable to save Options
Post by: Basara on March 28, 2025, 02:34:53 AM

Hello.
You might want to check for errors in two places:
Browser Console: Open your browser's developer tools (usually accessible by pressing F12 or right-clicking and selecting "Inspect"). Navigate to the "Console" tab and see if there are any error messages when trying to save options.
AbanteCart Error Log: Check the error log in your AbanteCart admin panel (under System > Logs). This log can provide insights into any issues happening on the server side.

Title: Re: Unable to save Options
Post by: AromeCity on March 28, 2025, 04:21:42 AM

Hi,

Any idea what this error means??

2025-03-28 3:29:49 - 2006: MySQL server has gone away
SELECT DISTINCT
e.*,
s.store_id,
st.alias as store_name,
s.value as status
FROM gsog_extensions e
LEFT JOIN gsog_settings s
ON ( s.`group` = e.`key` AND s.`key` = CONCAT(e.`key`,'_status') )
LEFT JOIN gsog_stores st ON st.store_id = s.store_id
WHERE e.key<>'' AND e.`type` IN ('extensions', 'extension', 'payment', 'shipping', 'template', 'language', 'tax') AND COALESCE(s.`store_id`,0) = '0'
ORDER BY e.priority desc

Title: Re: Unable to save Options
Post by: abolabo on March 28, 2025, 08:09:27 AM

Quote from: AromeCity on March 28, 2025, 04:21:42 AM

Hi,

Any idea what this error means??

2025-03-28 3:29:49 - 2006: MySQL server has gone away
SELECT DISTINCT
e.*,
s.store_id,
st.alias as store_name,
s.value as status
FROM gsog_extensions e
LEFT JOIN gsog_settings s
ON ( s.`group` = e.`key` AND s.`key` = CONCAT(e.`key`,'_status') )
LEFT JOIN gsog_stores st ON st.store_id = s.store_id
WHERE e.key<>'' AND e.`type` IN ('extensions', 'extension', 'payment', 'shipping', 'template', 'language', 'tax') AND COALESCE(s.`store_id`,0) = '0'
ORDER BY e.priority desc

We already added reconnect cycle into amysqli driver in v1.4.1.
If you wish to prevent such errors in the future you can replace your file public_html/core/database/amysqli.php with this  (https://github.com/abantecart/abantecart-src/blob/1.4.2/public_html/core/database/amysqli.php)

Title: Re: Unable to save Options
Post by: AromeCity on March 30, 2025, 03:23:45 AM

Hi,

Ok If I replace this file.

What parameters I need to update in the new file?

I copied over the following from amysqli.php but the admin panel is not loding anymore.

        $connection->query("SET NAMES 'utf8'");
        $connection->query("SET CHARACTER SET utf8");
        $connection->query("SET CHARACTER_SET_CONNECTION=utf8");
        $connection->query("SET SQL_MODE = ''");
        $connection->query("SET session wait_timeout=60;");
        $connection->query("SET SESSION SQL_BIG_SELECTS=1;");

Title: Re: Unable to save Options
Post by: abolabo on March 30, 2025, 05:24:24 AM

Quote from: AromeCity on March 30, 2025, 03:23:45 AM

Hi,

Ok If I replace this file.

What parameters I need to update in the new file?

I copied over the following from amysqli.php but the admin panel is not loding anymore.

        $connection->query("SET NAMES 'utf8'");
        $connection->query("SET CHARACTER SET utf8");
        $connection->query("SET CHARACTER_SET_CONNECTION=utf8");
        $connection->query("SET SQL_MODE = ''");
        $connection->query("SET session wait_timeout=60;");
        $connection->query("SET SESSION SQL_BIG_SELECTS=1;");

why you edited file? Just replace with new