Welcome to Geeklog, Anonymous Tuesday, April 16 2024 @ 08:01 pm EDT

Geeklog Forums

Media Gallery

Post New Reply

Author:

Mood:

Code

Font Color Font Size Close Tags

Forum BBCode Help

BBCode	Effect
[b]bolded text[/b]	bolded text
[i]italicized text[/i]	italicized text
[u]underlined text[/u]	underlined text
[s]strikethrough text[/s]	strikethrough text
[img]http://www.site.com/forum/images/forum.png[/img] OR [img h=65 w=50]http://www.site.com/forum/images/forum.png[/img]
[url=https://www.geeklog.net]Geeklog[/url]	Geeklog
[quote]quoted text[/quote]	To quote: quoted text
[size=15]Your Text[/size] "12" is usually standard on message boards. Usually measured in pixels (px).	Your Text
[color=red]Red Text[/color] OR [color=#FF0000]Red Text[/color] Can use many different color names or hex codes.	Red Text
[list] []List item 1 []List item 2 [/list] OR [list=1] []List item 1 []List item 2 [/list]	List item 1 List item 2 List item 1 List item 2
[code]monospaced text[/code]	monospaced text
[code=XYX]formatted code[/code] Where XYZ can be any of the following: c css html4strict java javascript jquery perl php plain python SQL and many more...	formatted code
To enter a backslash (\) in your post, use \\\\	\

Subject

[QUOTE][u]Quote by: denis[/u][p]In my documents I created new tekst documents with names :
gl_mg_media
gl_mg_media_albums -
gl_mg_media_album_queue
gl_mg_media_queue 
and there I copied teksts from exported gl_mg_ files.
Then,with phpMyAdmin in my new website database i clicked on "Import" and I highlighted "gl_mg_media" ,in the "Browse" i found my copy of "gl_mg_media" tekst and I clicked on "Go" ,but I received error message:
[quote]Error

SQL query:

-- 
-- Database: `my_gklg3`
-- 
-- --------------------------------------------------------
-- 
-- Table structure for table `gl_mg_albums`
-- 
CREATE TABLE `gl_mg_albums` (
`album_id` int( 11 ) NOT NULL default '0',
`album_title` varchar( 255 ) NOT NULL default '',
`album_desc` text NOT NULL ,
`album_parent` int( 11 ) NOT NULL default '0',
`album_order` int( 11 ) NOT NULL default '0',
`album_cover` varchar( 40 ) NOT NULL default '-1',
`album_cover_filename` varchar( 255 ) default '',
`media_count` int( 11 ) unsigned NOT NULL default '0',
`last_update` int( 11 ) NOT NULL default '0',
`enable_comments` tinyint( 4 ) NOT NULL default '0',
`exif_display` tinyint( 4 ) NOT NULL default '0',
`enable_rating` tinyint( 4 ) NOT NULL default '0',
`playback_type` tinyint( 4 ) NOT NULL default '0',
`tn_attached` tinyint( 4 ) NOT NULL default '0',
`enable_slideshow` tinyint( 4 ) NOT NULL default '0',
`enable_random` tinyint( 4 ) NOT NULL default '0',
`enable_shutterfly` tinyint( 4 ) NOT NULL default '0',
`enable_views` tinyint( 4 ) NOT NULL default '0',
`enable_sort` tinyint( 4 ) NOT NULL default '0',
`albums_first` tinyint( 4 ) NOT NULL default '1',
`full_display` tinyint( 4 ) NOT NULL default '0',
`tn_size` tinyint( 4 ) NOT NULL default '0',
`display_rows` tinyint( 4 ) NOT NULL default '3',
`display_columns` tinyint( 4 ) NOT NULL default '3',
`member_uploads` tinyint( 4 ) NOT NULL default '0',
`moderate` tinyint( 4 ) NOT NULL default '0',
`email_mod` tinyint( 4 ) NOT NULL default '0',
`featured` tinyint( 4 ) NOT NULL default '0',
`cbposition` tinyint( 1 ) NOT NULL default '0',
`cbpage` varchar( 20 ) NOT NULL default '',
`owner_id` mediumint( 9 ) NOT NULL default '0',
`group_id` mediumint( 9 ) NOT NULL default '0',
`mod_group_id` mediumint( 9 ) NOT NULL default '0',
`perm_owner` tinyint( 1 ) unsigned NOT NULL default '0',
`perm_group` tinyint( 1 ) unsigned NOT NULL default '0',
`perm_members` tinyint( 1 ) unsigned NOT NULL default '0',
`perm_anon` tinyint( 1 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `album_id` ) ,
KEY `album_parent` ( `album_parent` ) ,
KEY `last_update` ( `last_update` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said: Documentation
#1050 - Table 'gl_mg_albums' already exists [/quote]

:banghead:  :banghead:  :banghead: [/p][/QUOTE]

Options:

HTML Mode

Geeklog Forums

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Articles last 4 weeks

Comments last 4 weeks

Pages last 4 weeks

Links last 4 weeks

Downloads last 4 weeks