Welcome to Geeklog, Anonymous Wednesday, November 27 2024 @ 07:27 am EST
Geeklog Forums
Media gallery error
Status: offline
Sniper12
Forum User
Regular Poster
Registered: 11/25/03
Posts: 81
Location:Denmark
I just moved my site to another server, and updated all plugins, but my gallery doesn’t look to good. I can't find the original files, but it seems to something in the layout.
See this pic http://www.sugecrew.dk/billeder/opload/gallery_error.jpg
:helpme:
See this pic http://www.sugecrew.dk/billeder/opload/gallery_error.jpg
:helpme:
19
12
Quote
Status: offline
::Ben
Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
Status: offline
Sniper12
Forum User
Regular Poster
Registered: 11/25/03
Posts: 81
Location:Denmark
can I just copy the files to the server, I thing the database is updatet for the 1.6.0 gallery now. This has been working fine on my old server, but there it no way to get to my old files 
he just closed the serveres down.
he just closed the serveres down.
12
12
Quote
Status: offline
::Ben
Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
Hi,
It is why the docs says "Always make a db backup before installing a plugin" :wink: :rtfm:
Upload all the files from the mg 1.5.1 archive and let's me know if you can do a plugin update
New items in the db may not be an issue
Update for MG 1.6.0
$_SQL[] = "ALTER TABLE {$_TABLES['mg_albums']} ADD `tnheight` INT NOT NULL DEFAULT '0' AFTER `tn_attached`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_albums']} ADD `tnwidth` INT NOT NULL DEFAULT '0' AFTER `tnheight`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_albums']} ADD `usealternate` TINYINT NOT NULL DEFAULT '0' AFTER `playback_type`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_albums']} ADD `skin` VARCHAR( 255 ) NOT NULL DEFAULT 'default' AFTER `album_order`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_albums']} ADD `rsschildren` TINYINT NOT NULL DEFAULT '0' AFTER `shopping_cart`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_albums']} ADD `mp3ribbon` TINYINT NOT NULL DEFAULT '0' AFTER `podcast`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_media']} ADD `artist` VARCHAR(255) NULL AFTER `media_watermarked`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_media']} ADD `album` VARCHAR(255) NULL AFTER `artist`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_media']} ADD `genre` VARCHAR(255) NULL AFTER `album`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_mediaqueue']} ADD `artist` VARCHAR(255) NULL AFTER `media_watermarked`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_mediaqueue']} ADD `album` VARCHAR(255) NULL AFTER `artist`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_mediaqueue']} ADD `genre` VARCHAR(255) NULL AFTER `album`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_sort']} ADD `referer` VARCHAR(255) NOT NULL DEFAULT '' AFTER `sort_datetime`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_sort']} ADD `keywords` VARCHAR(255) NOT NULL DEFAULT '' AFTER `referer`";
$_SQL[] = "CREATE TABLE {$_TABLES['mg_rating']} ( " .
"`id` int(11) unsigned NOT NULL default '0', " .
"`ip_address` varchar(14) NOT NULL, " .
"`uid` mediumint(8) NOT NULL, " .
"`media_id` varchar(40) NOT NULL, " .
"`ratingdate` int(11) NOT NULL, " .
"`owner_id` mediumint(8) NOT NULL default '2', " .
"PRIMARY KEY (`id`), " .
"KEY `owner_id` (`owner_id`));";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('random_skin','mgShadow')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_border','1')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_align','auto')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_width','0')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_height','0')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_src','tn')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_autoplay','0')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_enable_link','1')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_delay','5')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_showtitle','0')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('use_flowplayer','0')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('search_columns','3')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('search_rows','4')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('search_playback_type','0')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('search_enable_views','1')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('search_enable_rating','1')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('gallery_only','0')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('ad_tn_height','200')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('ad_tn_width','200')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('gallery_tn_height','200')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('gallery_tn_width','200')";
::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
It is why the docs says "Always make a db backup before installing a plugin" :wink: :rtfm:
Upload all the files from the mg 1.5.1 archive and let's me know if you can do a plugin update
New items in the db may not be an issue
Text Formatted Code
Update for MG 1.6.0
$_SQL[] = "ALTER TABLE {$_TABLES['mg_albums']} ADD `tnheight` INT NOT NULL DEFAULT '0' AFTER `tn_attached`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_albums']} ADD `tnwidth` INT NOT NULL DEFAULT '0' AFTER `tnheight`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_albums']} ADD `usealternate` TINYINT NOT NULL DEFAULT '0' AFTER `playback_type`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_albums']} ADD `skin` VARCHAR( 255 ) NOT NULL DEFAULT 'default' AFTER `album_order`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_albums']} ADD `rsschildren` TINYINT NOT NULL DEFAULT '0' AFTER `shopping_cart`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_albums']} ADD `mp3ribbon` TINYINT NOT NULL DEFAULT '0' AFTER `podcast`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_media']} ADD `artist` VARCHAR(255) NULL AFTER `media_watermarked`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_media']} ADD `album` VARCHAR(255) NULL AFTER `artist`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_media']} ADD `genre` VARCHAR(255) NULL AFTER `album`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_mediaqueue']} ADD `artist` VARCHAR(255) NULL AFTER `media_watermarked`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_mediaqueue']} ADD `album` VARCHAR(255) NULL AFTER `artist`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_mediaqueue']} ADD `genre` VARCHAR(255) NULL AFTER `album`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_sort']} ADD `referer` VARCHAR(255) NOT NULL DEFAULT '' AFTER `sort_datetime`";
$_SQL[] = "ALTER TABLE {$_TABLES['mg_sort']} ADD `keywords` VARCHAR(255) NOT NULL DEFAULT '' AFTER `referer`";
$_SQL[] = "CREATE TABLE {$_TABLES['mg_rating']} ( " .
"`id` int(11) unsigned NOT NULL default '0', " .
"`ip_address` varchar(14) NOT NULL, " .
"`uid` mediumint(8) NOT NULL, " .
"`media_id` varchar(40) NOT NULL, " .
"`ratingdate` int(11) NOT NULL, " .
"`owner_id` mediumint(8) NOT NULL default '2', " .
"PRIMARY KEY (`id`), " .
"KEY `owner_id` (`owner_id`));";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('random_skin','mgShadow')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_border','1')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_align','auto')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_width','0')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_height','0')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_src','tn')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_autoplay','0')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_enable_link','1')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_delay','5')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('at_showtitle','0')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('use_flowplayer','0')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('search_columns','3')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('search_rows','4')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('search_playback_type','0')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('search_enable_views','1')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('search_enable_rating','1')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('gallery_only','0')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('ad_tn_height','200')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('ad_tn_width','200')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('gallery_tn_height','200')";
$_SQL[] = "INSERT INTO {$_TABLES['mg_config']} VALUES ('gallery_tn_width','200')";
::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
11
14
Quote
All times are EST. The time is now 07:27 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content