View incorrect on the database

  • Posts: 597
  • Thank you received: 23
  • Hikaserial Subscription Hikashop Multisite
10 years 5 months ago #194977

-- HikaShop version -- : 2.4.0
-- Joomla version -- : 3.4
-- PHP version -- : 5.4.35-1byte1
-- Browser(s) name and version -- : FF

Hi,

On the 13th I did an update to Hikashop 2.4.0.
But today I got an e-mail from our hoster that there is something wrong wit the database.
There is an view incorrect on the database. These views refer to other tables / columns that no longer exist. So now the hoster can't make good back-ups/

I don't know what it means, but it has to do with Hikashop, see ERROR below:

2015-03-16 11:28:54,267 dbbackup.utils.mysqldumper CRITICAL [db062963_live] Mysqldump stderr: mysqldump: Got error: 1356: View 'db062963_live.cryp_hikashop_click_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `cryp_hikashop_click_view`': View 'db062963_live.cryp_hikashop_click_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `cryp_hikashop_lead_view`': View 'db062963_live.cryp_hikashop_lead_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `cryp_hikashop_sale_view`': View 'db062963_live.cryp_hikashop_sale_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)

I hope you can help me with this issue.

Kind regards,
Lumiga


Kind regards,
Lumiga

Please Log in or Create an account to join the conversation.

  • Posts: 84220
  • Thank you received: 13673
  • MODERATOR
10 years 5 months ago #194989

Hi,

I don't see why the tables columns wouldn't exist as we never removed a column/table in the database of HikaShop.
I also don't see why the update would be the reason for that as the only thing we added in the 2.4.0 is the deletion of these views after their use, in order to prevent such backup issues where the mysql user doesn't have the right to delete/use these views.

Anyway, simply delete the views manually in your database and that will solve the issue.

Please Log in or Create an account to join the conversation.

  • Posts: 597
  • Thank you received: 23
  • Hikaserial Subscription Hikashop Multisite
10 years 5 months ago #195335

Hi Nicolas,

Thanks for your anser. :)
But I still don't know why these tables exist. But that is probably due to my poor knowledge of databases :(
Do I have to delete these tables every time?

During the update I had problems installing it in the normal way. Finally I placed the installation files to a folder on the server and install from there. Could it have to do with this?

Anyway:
When I want to delete these tables I get an error that it's not possible. :S
It says: Error while processing the command (see image)
The table is also in use! (see image)

What should I do now?

Kind regards
Lumiga


Kind regards,
Lumiga
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 26264
  • Thank you received: 4043
  • MODERATOR
10 years 5 months ago #195377

Hi,

When you use the affiliate system in the HikaShop backend, HikaShop will create temporally some views and will delete them just after that.
Some export/import my in PHPMyAdmin does not handle right the views and import them as "table" (but it's not tables).
That's why we now force the deletion of the views in the affiliate system once the processing has been made.

If you really can't delete them ; One solution could be to create a new database, to move every tables except the views, drop the old database and rename the new one.
Once you will clean these views/tables ; you shouldn't have any other issue because HikaShop are deleting them now (so they won't be in the future database exports).

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Time to create page: 0.055 seconds
Powered by Kunena Forum