read the line... how do you add a column called urlshop after the column urlshop if it's not there in the first place?
anyway, i had the same problem, here is the correct sql:
ALTER TABLE `mos_akogallery` CHANGE `imgdate` `imgdate` datetime NOT NULL default '0000-00-00 00:00:00';
ALTER TABLE `mos_akogallery` ADD `publish_up` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `published`;
ALTER TABLE `mos_akogallery` ADD `publish_down` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `publish_up`;
ALTER TABLE `mos_akogallery` ADD `urlshop` text NOT NULL AFTER `publish_down`;
ALTER TABLE `mos_akogallery` ADD `urldownload` text NOT NULL AFTER `urlshop`;
ALTER TABLE `mos_akogallery` ADD `ordering` float unsigned NOT NULL default '0' AFTER `urldownload`;
ALTER TABLE `mos_akogallery` ADD `metakey` text NOT NULL AFTER `ordering`;
ALTER TABLE `mos_akogallery` ADD `metadesc` text NOT NULL AFTER `metakey`;