Error when importing into MySQL

cspgsl
13 years ago
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
idemsisvoje
12 years, 11 months ago
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 ]
cspgsl
12 years, 11 months ago
I'm thinking support just isn't a priority of the developer
cspgsl
12 years, 11 months ago
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.
dryabov
12 years, 11 months ago
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.
idemsisvoje
12 years, 11 months ago
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.
dryabov
12 years, 11 months ago
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.
Webhoard
12 years, 11 months ago
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.
pilsnermonkey
12 years, 11 months ago
Can you tell me the table that those procedures are stored in?
1

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.