Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Problem with SQL transfer.
(1 viewing) (1) Guest
Universal booking and reservations component for Joomla!.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: Problem with SQL transfer.

Problem with SQL transfer. 11 years, 4 months ago #40059

Hello.
I come to you because I have a problem with a SQL Database transfer.

I put the Joomla (containing Booking) on OVH server and I wanted to transfer it to a server in NUXIT.

Upon transfer of a SQL database to another, I have this message :

Erreur
Requête SQL:

CREATE ALGORITHM = UNDEFINED DEFINER = `yaquademsite`@`%` SQL SECURITY DEFINER VIEW `faz_booking_template_value_view` AS SELECT `value`.`id` AS `id` , `translation`.`language_id` AS `language` , `translation`.`value` AS `value`
FROM (

`faz_booking_template_value` `value`
LEFT JOIN `faz_falang_content` `translation` ON ( (
`translation`.`reference_id` = `value`.`id`
) )
)
WHERE (
(
`translation`.`reference_table` = 'booking_template_value'
)
AND (
`translation`.`reference_field` = 'value'
)
);

MySQL a répondu:

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

What does it do? I contacted the host who told me he had to adapt the script for it to pass, that they could do nothing.

Thank you for your help.
The topic has been locked.

Re: Problem with SQL transfer. 11 years, 4 months ago #40085

  • mitk
Hello,

I am not sure, you probably don't have enough rights to do this operation, or your database doesn't support ALGORITHMs.
The topic has been locked.
  • Page:
  • 1
User Login Empty