Welcome, Guest
Username Password: Remember me

Error when importing into MySQL
(1 viewing) (1) Guest
  • Page:
  • 1
  • 2

TOPIC: Error when importing into MySQL

Error when importing into MySQL 12 years ago #8911

  • cspgsl
  • OFFLINE
  • Fresh Boarder
  • Posts: 17
  • Karma: 0
I am getting the following error when trying to import my .sql file through PHP MyAdmin

I am not a DB person so any assistance is welcomes, thanks
Error
 
SQL query:
 
$$ DROP PROCEDURE IF EXISTS `vdb_TeraWurfl_RIS` $$
 
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$
 
DROP PROCEDURE IF EXISTS `vdb_TeraWurfl_RIS`' at line 1

Re: Error when importing into MySQL 11 years, 11 months ago #9195

I am getting similar error. I tried uninstalling whole mobile joomla, removing tables in the db, and I am still getting the error when importing the database.
I read a forum, where guys identified it as a problem of mysql version, but I have to use mysql 5.x so not applicable for me.
Can anyone help please?

SQL query: Documentation
 
--
-- Database: `rt2`
--
DELIMITER $$--
-- Procedures
--
CREATE DEFINER = `root`@`localhost` PROCEDURE `j25_TeraWurfl_FallBackDevices` ( current_fall_back VARCHAR( 64 ) ) BEGIN WHILE current_fall_back != 'root' DO SELECT capabilities
FROM j25_TeraWurflMerge
WHERE deviceID = current_fall_back;
 
SELECT fall_back
FROM j25_TeraWurflMerge
WHERE deviceID = current_fall_back
INTO current_fall_back;
 
END WHILE;
 
END$$
 
MySQL said: Documentation
#1227 - Access denied; you need the SUPER privilege for this operation
[ Back ]

Re: Error when importing into MySQL 11 years, 11 months ago #9214

  • cspgsl
  • OFFLINE
  • Fresh Boarder
  • Posts: 17
  • Karma: 0
I'm thinking support just isn't a priority of the developer

Re: Error when importing into MySQL 11 years, 11 months ago #9215

I finally managed to fix it. The procedures of Mobile Joomla! stored in MySql were causing the error in my case.
Following extension helped me to get rid of them

extensions.joomla.org/extensions/hosting-a-servers/database-management/9886

Maybe it will also work for you cspgsl

Good luck

Re: Error when importing into MySQL 11 years, 11 months ago #9216

  • cspgsl
  • OFFLINE
  • Fresh Boarder
  • Posts: 17
  • Karma: 0
I managed to solve the problem but I do not remember how. I have a number of other sites that I will have to do over time so this might be the thing I am looking for

Thanks, I will look at it.

Re: Error when importing into MySQL 11 years, 11 months ago #9220

  • dryabov
  • OFFLINE
  • Administrator
  • Denis Ryabov, Lead Developer
  • Posts: 4866
  • Karma: 105
idemsisvoje wrote:
#1227 - Access denied; you need the SUPER privilege for this operation

It means that you need additional privileges to create mysql procedures. In the case of such a restriction you can switch to mysql4 mode in settings of Mobile-TeraWURFL plugin.

Re: Error when importing into MySQL 11 years, 11 months ago #9222

Yeah I know, but the problem was I uninstalled whole component, and was still getting the error. There was no plugin anymore in which I could change the settings for MySQL.
I also deleted every table of Mobile Joomla in the database, but the procedures were still present.

Re: Error when importing into MySQL 11 years, 11 months ago #9234

  • dryabov
  • OFFLINE
  • Administrator
  • Denis Ryabov, Lead Developer
  • Posts: 4866
  • Karma: 105
idemsisvoje, just run
DROP PROCEDURE IF EXISTS `<joomla-db-prefix>TeraWurfl_RIS`
DROP PROCEDURE IF EXISTS `<joomla-db-prefix>TeraWurfl_FallBackDevices`

to remove terawurfl's procedures.

Re: Error when importing into MySQL 11 years, 11 months ago #9261

  • Webhoard
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
I had the same issue when I tried my hands-on approach of importing the database in a shared hosting environment.

For me, I wanted to copy an existing installation for a new site. Akeeba Backup and Kickstart worked really well.

Re: Error when importing into MySQL 11 years, 11 months ago #9264

Can you tell me the table that those procedures are stored in?
  • Page:
  • 1
  • 2
Time to create page: 0.13 seconds

By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them. This site will not function correctly without cookies.

I accept cookies from this site.