Galaxietool Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000548Hosting by eX0du5(No Category)public2011-09-20 15:062011-09-23 21:07
ReporterOmar Hawk 
Assigned ToeX0du5 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusresolvedResolutionfixed 
Summary0000548: Another issue with mysql dump from hosting
DescriptionThe following error message appears when trying to insert an espionage report into a Galaxytool with a dump from the Galaxytool Hosting.

MySQL error occurred while inserting or updating reports
    The user specified as a definer ('krischan'@'localhost') does not exist
        INSERT INTO de_draco_reports (galaxy,system,planet,planetname,moon,metal,crystal,deuterium,energy,kt,gt,lj,sj,krz,ss,kolo,rec,spio,bomb,zerri,ds,skrz,sat,rak,ll,sl,ion,gauss,plasma,ksk,gsk,arak,irak,memi,krimi,deutsyn,solar,fusion,robo,nani,rawe,mesp,krissp,deutsp,folab,terra,allydep,raksilo,mbase,sensor,sprungtor,spiolvl,computech,waffentech,schildtech,rpz,energytech,hypertech,vbt,impulse,hra,lasertech,iontech,plasmatech,forschungsnetz,expedition,gravi,fleet_resis,defence_resis,scantime,user_id,scanned,min_phalanx,max_phalanx,min_rak,max_rak) VALUES (5,254,8,'Krishändler','false',393641,135906,107329,16381,0,50,0,0,0,0,0,0,0,0,0,0,0,sat,rak,ll,sl,ion,gauss,plasma,ksk,gsk,arak,irak,memi,krimi,deutsyn,solar,fusion,robo,nani,rawe,mesp,krissp,deutsp,folab,terra,allydep,raksil
Steps To Reproducereported by E-x-e-c-u-t-e in IRC
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
(0001366)
Omar Hawk (updater)
2011-09-20 15:23
edited on: 2011-09-20 15:24

The reason seems to be the definer set at the TRIGGERs. Maybe you could prevent the dump from setting the definer or set the current_user as definer.

From the dump of my test tool:
*!50003 CREATE*/ /*!50017 DEFINER=`krischan`@`localhost`*/ /*!50003 TRIGGER de_Omar_Test_players_ai AFTER IN
[...]

(0001375)
eX0du5 (developer)
2011-09-23 21:07

Definer are now removed from the tool dump.
MySQL does not offer this feature yet, but "sed" is a powerful tool for this :-)

- Issue History
Date Modified Username Field Change
2011-09-20 15:06 Omar Hawk New Issue
2011-09-20 15:06 Omar Hawk Assigned To => eX0du5
2011-09-20 15:06 Omar Hawk Status new => assigned
2011-09-20 15:23 Omar Hawk Note Added: 0001366
2011-09-20 15:24 Omar Hawk Note Edited: 0001366 View Revisions
2011-09-20 15:24 Omar Hawk Note Edited: 0001366 View Revisions
2011-09-23 21:07 eX0du5 Note Added: 0001375
2011-09-23 21:07 eX0du5 Status assigned => resolved
2011-09-23 21:07 eX0du5 Resolution open => fixed



Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker