Shopping Cart Operations > General Support

"Act on Behalf" not working

<< < (2/5) > >>

helperbee:

--- Quote from: abolabo on February 18, 2016, 04:39:51 AM ---i checked your admin and your case looks like:
 you created some additional store, some customers registered in it, and then this additional store was deleted, but assignment "customer-to-store" still present.
Can you please check you database table "customers", column "store_id".
 value must be the same as in table "stores".


--- End quote ---

The "stores" table has no records.
The value for "store_id" within "customers" table is 0 for all records.

If I were to create a record for the "stores" table, the store_id column is "AUTO_INCREMENT" so I don't know if I can enter the value of "0" ...plus what value is needed for the "alias" and "status" columns?

I tested the above, by using "status=1", but it did not fix the "Act on Behalf" issue.

abolabo:

--- Quote from: helperbee on February 18, 2016, 03:29:33 PM ---
--- Quote from: abolabo on February 18, 2016, 04:39:51 AM ---i checked your admin and your case looks like:
 you created some additional store, some customers registered in it, and then this additional store was deleted, but assignment "customer-to-store" still present.
Can you please check you database table "customers", column "store_id".
 value must be the same as in table "stores".


--- End quote ---

The "stores" table has no records.
The value for "store_id" within "customers" table is 0 for all records.

If I were to create a record for the "stores" table, the store_id column is "AUTO_INCREMENT" so I don't know if I can enter the value of "0" ...plus what value is needed for the "alias" and "status" columns?

I tested the above, by using "status=1", but it did not fix the "Act on Behalf" issue.

--- End quote ---

you can use this sql to revert data of table stores
 
--- Code: ---INSERT INTO `ac_stores` VALUES (0,'default','default',1);
--- End code ---
where ac_ - your table prefix
Also check table "settings", key "config_url" value and compare with your admin URL.

helperbee:
Within the "stores" table, the store_id column is "AUTO_INCREMENT" so when I ran the SQL the specified value of "0" was ignored. Instead it incremented to 4.

I checked the table "settings", key "config_url" value and it matched my admin URL.

What should I try next?

I very much appreciate your time and assistance. This is an important feature to our business.

abolabo:

--- Quote from: helperbee on February 19, 2016, 12:00:58 PM ---Within the "stores" table, the store_id column is "AUTO_INCREMENT" so when I ran the SQL the specified value of "0" was ignored. Instead it incremented to 4.

--- End quote ---

i guess cause is in it.

try to run this sql

--- Code: ---DELETE FROM `ac_stores`;
--- End code ---
Then

--- Code: ---ALTER TABLE `ac_stores` AUTO_INCREMENT = 0;
--- End code ---
and 

--- Code: ---INSERT INTO `ac_stores` VALUES (0,'default','default',1);
--- End code ---

helperbee:
Sorry to report that didn't work. Even when auto_increment" was set to 0, the new value in "store_id" became 1. It was a good idea, however.
On my own, I tried setting the auto_increment to -1, but that SQL failed.

What do you recommend next?

Navigation

[0] Message Index

[#] Next page

[*] Previous page