News:

AbanteCart v1.4.2 is released.

Main Menu
support

Unable to save Options

Started by AromeCity, March 28, 2025, 12:58:50 AM

Previous topic - Next topic

AromeCity

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?


Basara

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.

AromeCity

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

abolabo

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
"No one is useless in this world who lightens the burdens of another."
― Charles Dickens

AromeCity

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;");

abolabo

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
"No one is useless in this world who lightens the burdens of another."
― Charles Dickens

Forum Rules Code of conduct
AbanteCart.com 2010 -