First post here and am thankful to all (Steve) the work on this great piece of code!
I initially installed this on my testbed (WAMP) and all is working fine, my problems started when I installed to my webhosting (HostGator)
I had problems getting past the installation of the database as my host capped the Mem at 64M which as I read other post it needs 256M
min to run the large file. Reading the other post I was able to backup my local database and restore in on my hosting site.
That didnt go smooth either as I received an error msg for the CREATE DEFINER Stored Procedures, basically to run these procedures
my database user needs EXECUTE permission which is clearly stated in instructions but my host doesnt allow this with the current plan I have.
I dont want to upgrade my plan or move webhost, is there another way around this/these issues so I can effectivly run this without dumbing down
the scripts?
Error msg
- Code: Select all
CREATE DEFINER = `myDatabase_name`@`%` PROCEDURE `TeraWurfl_FallBackDevices` ( current_fall_back VARCHAR( 64 ) ) BEGIN WHILE current_fall_back != 'root' DO SELECT capabilities
FROM TeraWurflMerge
WHERE deviceID = current_fall_back;
SELECT fall_back
FROM 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