AbleCommerce Shopping Cart Software

Since completing our upgrade to 7.0.2 we have been unable to delete users via the Admin menu. When trying, we get a popup window saying giving a 500 error. Has anyone else had this issue, and how can we resolve it?

I've got my dev install of Solunar.com running on 7.0.2 - no problems deleting users at all.

Have you tried deleting the same user manually from SQL manager? Perhaps it's SQL throwing an error....

You were on the right track, Joe. I went directly into the SQL table and was unable to delete the user even when working with the table itself. The error was:

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid Object Name 'ac_Orders'.

Now, prior to the upgrade it was not a problem to delete customers from the Admin menu or the table (we had done both).

So I took a look at the permissions on the tables, and three tables have an incorrect owner associated with them (the main user name from the file instead of dbo). How do I correct this?

Hmmm an invalid object error when deleting a table record suggests a referential integrity check that fails. Sounds like ac_Users has somehow gotten linked to ac_Orders inside SQL.

Check the referential integrity setup on ac_Users. It should not be set to cascade deletes/updates into ac_Orders. Otherwise, deleting a user would also delete that users orders which would be bad.

Brewhaus wrote:So I took a look at the permissions on the tables, and three tables have an incorrect owner associated with them (the main user name from the file instead of dbo). How do I correct this?

You talking about the schema i.e. [dbo].ac_Users instead of [someuser].ac_Users?

When you pull the list of tables, the column 'Owner' has dbo listed for all but three of the tables. For those three tables a different owner is listed. I know that this can be changed, but do not recall how.

Something must have happened when we restored a backup after a problem upgrading a week ago, as everything was working fine prior to that.

So you're thinking at this point is that permissions are wrong? You can edit records and save new records, but you cannot delete?

That would be a very specific permissions issue, but I guess it's possible.

Check out these SQL commands, perhaps they'll help: http://www.mssqltips.com/tip.asp?tip=1396

Ar you familiar enough with SQL to know where we perform this?

Yeah but not through forum posts. It's something I'd have to look at and see first-hand...

PM'd you my contact info.