~Daniel Friesen(Dantman, Nadir-Seen-Fire) of: -The Nadir-Point Group (http://nadir-point.com) --It's Wiki-Tools subgroup (http://wiki-tools.com) --The ElectronicMe project (http://electronic-me.org) --Games-G.P.S. (http://ggps.org) -And Wikia ACG on Wikia.com (http://wikia.com/wiki/Wikia_ACG) --Animepedia (http://anime.wikia.com) --Narutopedia (http://naruto.wikia.com)It would probably be best to create the temporary table with an explicit set of fields, and add the id then. And then, fill the table up with the data. That could be done in a second INSERT ... SELECT ... query, or it may actually be possible to combine everything into the one create query.
~Daniel Friesen(Dantman, Nadir-Seen-Fire) of: -The Nadir-Point Group (http://nadir-point.com) --It's Wiki-Tools subgroup (http://wiki-tools.com) --The ElectronicMe project (http://electronic-me.org) --Games-G.P.S. (http://ggps.org) -And Wikia ACG on Wikia.com (http://wikia.com/wiki/Wikia_ACG) --Animepedia (http://anime.wikia.com) --Narutopedia (http://naruto.wikia.com) Yaron Koren wrote: > Hi, > > What SQL code would you suggest in its place? Originally the call was > "CREATE INDEX", but this too sometimes led to an access-denied error: > > https://bugzilla.wikimedia.org/show_bug.cgi?id=13352 > > -Yaron > > > On Sat, Aug 23, 2008 at 9:42 AM, Daniel Friesen <[EMAIL PROTECTED]>wrote: > > >> It appears that Semantic Drilldown's BrowseDataPage::createTempTable is >> using a SQL ALTER command. >> >> This would be a case of lazy coding. It adds a extra query for something >> which should be done inside of the create statement, and it also >> requires that the unprivileged mysql user has the ability to alter the >> structure of the tables, which would be considered an administrative >> thing. The ALTER command does not have a TEMPORARY like DROP does, and >> honestly does not need one since all of the definitions for a temporary >> table should be specified inside of it's creation. >> >> -- >> ~Daniel Friesen(Dantman, Nadir-Seen-Fire) of: >> -The Nadir-Point Group (http://nadir-point.com) >> --It's Wiki-Tools subgroup (http://wiki-tools.com) >> --The ElectronicMe project (http://electronic-me.org) >> --Games-G.P.S. (http://ggps.org) >> -And Wikia ACG on Wikia.com (http://wikia.com/wiki/Wikia_ACG) >> --Animepedia (http://anime.wikia.com) >> --Narutopedia (http://naruto.wikia.com) >> >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's >> challenge >> Build the coolest Linux based applications with Moblin SDK & win great >> prizes >> Grand prize is a trip for two to an Open Source event anywhere in the world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> Semediawiki-devel mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/semediawiki-devel >> >> > > ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Semediawiki-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
