Show Posts


Messages - hani

Pages: [1] 2 3 ... 8
1
Extension Support / Re: Extension Weight Based Shipping problem
« on: April 06, 2021, 07:37:20 AM »
Issue solved it was a server side issue

Thanks

2
Extension Support / Extension Weight Based Shipping problem
« on: April 06, 2021, 04:53:23 AM »
Hi

I use the "Weight Based Shipping" extension and was trying to update the prices in the database and when i click the save button i get the below error


There has been a critical error processing your request
SQL Error: Incorrect key file for table './XXXXXXX_aban_bcc/abc_settings.MYI'; try to repair it
Error No: 126
SQL: DELETE FROM abc_settings WHERE `group` = 'default_weight' AND `key` = 'default_weight_1_rate' AND `store_id` = '0' PHP call stack: #0 /home/XXXXXXX/public_html/core/lib/db.php:100 #1 /home/XXXXXXX/public_html/core/engine/extensions.php:1176 #2 /home/XXXXXXX/public_html/core/engine/extensions.php:1127 #3 /home/XXXXXXX/public_html/core/lib/db.php:67 #4 /home/XXXXXXX/public_html/admin/model/setting/setting.php:294 #5 /home/XXXXXXX/public_html/extensions/default_weight/admin/controller/pages/extension/default_weight.php:48 #6 /home/XXXXXXX/public_html/core/engine/dispatcher.php:293 #7 /home/XXXXXX/public_html/core/engine/dispatcher.php:328 #8 /home/XXXXXXX/public_html/core/engine/page.php:108 #9 /home/XXXXXX/public_html/core/engine/router.php:176 #10 /home/XXXXXXX/public_html/core/engine/router.php:80 #11 /home/XXXXXXX/public_html/index.php:94 in /home/XXXXXX/public_html/core/database/amysqli.php on line 119

3
Support / Re: Fast Checkout
« on: February 12, 2021, 06:52:43 AM »
Hi

From what i can see is that fast checkout does not include the shipping cost specifically when there are more than one shipping option.

I have attached screenshots of the Weight-Based-Shipping extension but to see it more clear go to my website >> add small items to cart >> if the total weight is less than 2kg you can choose different shipping costs.

my website is https://www.bethlehemcasting.com
i stopped the fast checkout extension.


4
Support / Re: Fast Checkout
« on: February 12, 2021, 01:35:43 AM »
Hi

See attached image when fast checkout tested

5
Support / Re: Fast Checkout
« on: February 12, 2021, 01:15:01 AM »
I just checked it and what i see is that in some cases the cost off shipping is not included in the Fast checkout payment

6
Support / Re: Fast Checkout
« on: February 12, 2021, 01:08:05 AM »
Hello

I use default_weight for the shipping method no 3rd party and for payment 2checkout.com

In the default_weight i have split in 3 categories, there is Economy shipping, ECO post Shipping and EMS shipping and when the customer adds to cart he has the choice to choose which method and cost if with the weight range and this has been working fine.
What i noticed that Fast checkout is working correctly but the was one case that this happened

Thanks in advance for checking
 

7
Support / Fast Checkout
« on: February 11, 2021, 10:26:59 AM »
Hello

I recently activated the fast checkout extension and got a sale but the the customer was charged with the subtotal of the order.
I use 2checkout as our payment processor and the customer was supposed to be charged $64 + $19 for shipping, total $83 instead he was charged only for $64


8
General Support / Multi store menu
« on: December 27, 2020, 12:35:45 AM »
Hi Everyone

I have a multi store setup one for retail sales and the second is for wholesale sales both working great but and i need to set the menu to show different links on each store.

Here is what i want to do:
On the retail store to show a link to the wholesale store and on the wholesale store to show a link to retail store

I searched how this can be done but cannot find out how to do it.

If it is not possible then it will be a good idea to add this feature

Thanks for the help in advance

9
Hi
Thanks for your reply.

here is the code how made it
    //2. check mysql driver
       // $sql = "SELECT TABLE_NAME AS 'table_name',
               //table_rows AS 'num_rows', (data_length + index_length - data_free) AS 'size'
            //FROM information_schema.TABLES
            //WHERE information_schema.TABLES.table_schema = '".DB_DATABASE."'";
      $sql = "SELECT TABLE_NAME AS 'table_name',
      table_rows AS 'num_rows', (data_length as signed + index_length  as signed - data_free as signed) AS 'size'
   FROM information_schema.TABLES
   WHERE information_schema.TABLES.table_schema = '".DB_DATABASE."'";   
        //$result = $this->db->query($sql,true);

Note that i had to last line i had to remove, if kept it does not solve the problem.
Now with this code the error message is gone

Thanks again

10
Mysql version is 5.7

11
Hello

I contacted my host support and they checked in depth the cause for this message [ Cannot get tables list. Please check privileges of mysql database user.] and their reply is below.

==================================================================================

The reason for the experienced issue appears to be in the core files of Abantecart and more precisely in the following one:

core/lib/backup.php
In this file there is the following code:

 //2. check mysql driver
        $sql = "SELECT TABLE_NAME AS 'table_name',
                                        table_rows AS 'num_rows', (data_length + index_length - data_free) AS 'size'
                                FROM information_schema.TABLES
                                WHERE information_schema.TABLES.table_schema = '".DB_DATABASE."'";
        $result = $this->db->query($sql, true);
        if ($result === false && DB_DRIVER == 'mysql') {
            $this->error[] = 'Probably error will occur. Please change db-driver to "amysqli" in your /system/config.php file.';
        } elseif ($result === false) {
            $this->error[] = 'Cannot get tables list. Please check privileges of mysql database user.';
            var_dump($result);
        }
From what I can see this code is being used to check if the tables and data in your database, however opposite to the expected behavior of the application this SQL query returns false which makes the error "Cannot get tables list. Please check privileges of mysql database user." appear at the top of the extensions installation page.

This issue has nothing to do with the privileges of your MySQL user to the information_schema table as your database use already have full privileges for that table. Instead the issue here is caused by something else and that thing is the error which that SQL query results in:

SQL Error: BIGINT UNSIGNED value is out of range in '((`information_schema`.`TABLES`.`DATA_LENGTH` + `information_schema`.`TABLES`.`INDEX_LENGTH`) - `information_schema`.`TABLES`.`DATA_FREE`)'
Error No: 1690
Now, I am not sure why that error appears but definitely, it has nothing to do with the setup of the web hosting service. You might want to forward this result to the authors of the application. I read quite a lot about this error and I even tried to set the SQL mode to "NO_UNSIGNED_SUBTRACTION", however this error still persist.

By the way, from what I understand the file core/lib/backup.php is used with backup purposes, however, we already provide you with a free complimentary backup service so you should simply disregard this message and proceed further with the installation of the module except of course if that error prevents you to proceed with the installation.

12
Not with any specific extension, I get this message when i want to install an extension see attached image

13
Hi
Thank for your reply

I did check with my host provider before i submitted this issue on the forum and from the server side all privileges are allowed.

14
Hello everyone

I moved my website to a new server and everything was fine but when i stated installing some extensions I get the message
Cannot get tables list. Please check privileges of mysql database user.

i checked my database user privileges and all is OK and cannot see where is the problem.

Any advice
Thanks in advance

15
General Support / Error in logs file after 1.2.16 upgrade
« on: August 16, 2020, 11:31:05 PM »
Hi to all

I am having these errors in my logs file can anyone please help

2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli::__construct(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/core/database/amysqli.php</b> on line <b>50</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:40 - App Error: AbanteCart core v.1.2.16 Cannot establish database connection to XXXXXXX_aban454 using XXXXXXX_admin@localhost
Trace:
#0 /home/XXXXXXX/public_html/core/database/amysqli.php on line 52
#1 /home/XXXXXXX/public_html/core/lib/db.php on line 52
#2 /home/XXXXXXX/public_html/core/init.php on line 320
#3 /home/XXXXXXX/public_html/index.php on line 55
2020-08-16 19:04:40 - database error: AbanteCart core v.1.2.16 Cannot establish database connection. Check your database connection settings. in <b>/home/XXXXXXX/public_html/core/database/amysqli.php</b> on line <b>54</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:40 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:41 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:41 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:41 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:41 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:42 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:42 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>
2020-08-16 19:04:42 - warning: AbanteCart core v.1.2.16 mysqli_connect(): (HY000/1203): User XXXXXXX_admin already has more than 'max_user_connections' active connections in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>806</b>
2020-08-16 19:04:42 - warning: AbanteCart core v.1.2.16 extract() expects parameter 1 to be array, null given in <b>/home/XXXXXXX/public_html/extensions/editor/core/helpers.php</b> on line <b>651</b>

Thanks in advance

Pages: [1] 2 3 ... 8

Powered by SMFPacks Social Login Mod