DragonflyCMS Projects > Storez > [fixed] Database Error :( > Community Forums > Phoenix Netology
Forum Index > eCommerce > Storez

[fixed] Database Error :( Reply to topic


When I was trying to add a store, I accidentally hit enter in the store name field. It added 2 blank stores! Now neither of the stores will delete, it says cannot delete because there are products in the store, but there aren't. I gave the 2 blank stores names, just so they weren't identical blanks. It continues to say cannot delete because there are products in the store.

I tried checking the databases. Something is wrong w/ my information_schema database. I am got "A database error has occurred. The Webmaster has been notified" Error. When I went to phpMyAdmin, it gave me:

#1044 - Access denied for user 'XXX'@'localhost' to database 'information_schema'

I'm running Dragonfly (9.2.1) w/ Storez. Any ideas how I can fix this?

Thanks,
Dave

Initiated by Bugger (Original Entry) - Comments Here Please.

Please enter your server specs in your user profile! 😢


Thanks for using Bugger Smile

hmm, strange oddity that one - I can duplicate the first part i.e. cannot delete a blank.

However, after editing and giving each a name, I was able to successfully delete them.

It turns out that it's an original error where the store_id global isn't gathered for a GET link but is gathered for a POST link, so it was always picking up a zero through that particular link - a zero meant the check was finding sub-stores (rather than products) for a parent id of zero. The fix will be in the next bugfix release (soon) and I've also made the lang define more specific.

I don't get any db errors though - information_schema isn't relevant to DF or Storez - that's a matter between you and your host.

Donations & Audit for DragonflyCMS

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

All times are Australia/Adelaide


Jump to: