Arkadaşlar my egallry kurulumunda tablo hatası ile karşılaşı

_erc_ · Mesaj: 1+ Kayıt: Jan 08, 2006 Mesajlar: 12

arkadaşlar kurulum un sonunda bu çıkıyor nuke sürümüm (PHP-Nuke 7.6.0.3.1b)

My_eGallery Installation

This script will install the My_eGallery database and help you set up the variables that you need to start. You will be taken through a variety of pages. Each page sets a different portion of the script. We estimate that this entire process will take about two minutes. At any time that you get stuck, please visit our support forums for help.

Unable to make nuke_gallery_categories
Unable to make nuke_gallery_comments
Unable to make nuke_gallery_pictures
Unable to make nuke_gallery_pictures_newpicture
Unable to make nuke_gallery_rate_check
Unable to nuke_gallery_template_types
Unable to make nuke_gallery_media_class
Unable to make nuke_gallery_media_types

My_eGallery tables already exist!

You probably need to Upgrade the current version or Uninstall the previous installation before installing the new one.

Thank you for trying My_eGallery.

yani benden bu tabloları istiyor sanırım ama sql dosyası da burda bi bakın

# phpMyAdmin MySQL-Dump
# version 2.2.2
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# --------------------------------------------------------

#
# Tabel structuur voor tabel `nuke_gallery_categories`
#

DROP TABLE IF EXISTS `nuke_gallery_categories`;
CREATE TABLE `nuke_gallery_categories` (
`gallid` int(3) NOT NULL auto_increment,
`gallname` varchar(30) NOT NULL default '',
`gallimg` varchar(50) NOT NULL default '',
`galloc` longtext,
`description` text NOT NULL,
`parent` int(3) NOT NULL default '-1',
`visible` tinyint(3) unsigned NOT NULL default '0',
`template` int(10) unsigned NOT NULL default '2',
`thumbwidth` int(2) unsigned NOT NULL default '70',
`numcol` tinyint(3) unsigned NOT NULL default '3',
`total` int(10) unsigned NOT NULL default '0',
`lastadd` date NOT NULL default '0000-00-00',
PRIMARY KEY (`gallid`),
KEY `gallid` (`gallid`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabel structuur voor tabel `nuke_gallery_comments`
#

DROP TABLE IF EXISTS `nuke_gallery_comments`;
CREATE TABLE `nuke_gallery_comments` (
`cid` int(11) NOT NULL auto_increment,
`pid` int(4) NOT NULL default '0',
`comment` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`name` varchar(255) default NULL,
`member` int(1) NOT NULL default '0',
PRIMARY KEY (`cid`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabel structuur voor tabel `nuke_gallery_pictures`
#

DROP TABLE IF EXISTS `nuke_gallery_pictures`;
CREATE TABLE `nuke_gallery_pictures` (
`pid` int(10) unsigned NOT NULL auto_increment,
`gid` int(3) NOT NULL default '0',
`img` varchar(255) NOT NULL default '',
`counter` int(10) unsigned NOT NULL default '0',
`submitter` varchar(24) NOT NULL default 'Webmaster',
`date` datetime default NULL,
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`votes` int(10) unsigned NOT NULL default '0',
`rate` float NOT NULL default '0',
`extension` varchar(10) NOT NULL default 'image',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`pid`),
KEY `pid` (`pid`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabel structuur voor tabel `nuke_gallery_pictures_newpicture`
#

DROP TABLE IF EXISTS `nuke_gallery_pictures_newpicture`;
CREATE TABLE `nuke_gallery_pictures_newpicture` (
`pid` int(10) unsigned NOT NULL auto_increment,
`gid` int(3) NOT NULL default '0',
`img` varchar(255) NOT NULL default '',
`counter` int(10) unsigned NOT NULL default '0',
`submitter` varchar(24) NOT NULL default 'Webmaster',
`date` datetime default NULL,
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`votes` int(10) unsigned NOT NULL default '0',
`rate` float NOT NULL default '0',
`extension` varchar(10) NOT NULL default 'image',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`pid`),
KEY `pid` (`pid`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabel structuur voor tabel `nuke_gallery_rate_check`
#

DROP TABLE IF EXISTS `nuke_gallery_rate_check`;
CREATE TABLE `nuke_gallery_rate_check` (
`ip` varchar(20) NOT NULL default '',
`time` varchar(14) NOT NULL default '',
`pid` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;

#
# Tabel structuur voor tabel `nuke_gallery_media_class`
#

DROP TABLE IF EXISTS `nuke_gallery_media_class`;
CREATE TABLE `nuke_gallery_media_class` (
`id` int(2) NOT NULL default '0',
`class` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;

#
# Gegevens worden uitgevoerd voor tabel `nuke_gallery_media_class`
#

INSERT INTO `nuke_gallery_media_class` (`id`, `class`) VALUES (1, 'Image'),
(2, 'Audio'),
(3, 'Video');
# --------------------------------------------------------

#
# Tabel structuur voor tabel `nuke_gallery_media_types`
#

DROP TABLE IF EXISTS `nuke_gallery_media_types`;
CREATE TABLE `nuke_gallery_media_types` (
`extension` varchar(10) NOT NULL default '',
`description` text NOT NULL,
`filetype` varchar(20) NOT NULL default '',
`displaytag` text NOT NULL,
`thumbnail` varchar(255) NOT NULL default '',
PRIMARY KEY (`extension`)
) TYPE=MyISAM;

#
# Gegevens worden uitgevoerd voor tabel `nuke_gallery_media_types`
#

INSERT INTO `nuke_gallery_media_types` (`extension`, `description`, `filetype`, `displaytag`, `thumbnail`) VALUES ('bmp', 'Image/BMP', '1', '<img src="<:FILENAME:>" border="0" alt="<:DESCRIPTION:>">', 'image_gif.gif'),
('gif', 'Image/GIF', '1', '<img src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" alt="<:DESCRIPTION:>">', 'image_gif.gif'),
('jpg', 'Image/JPG', '1', '<img src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" alt="<:DESCRIPTION:>">', 'image_jpg.gif'),
('png', 'Image/PNG', '1', '<img src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" alt="<:DESCRIPTION:>">', 'image_png.gif'),
('mov', 'Video/Quicktime', '3', '<embed controller="true" width="<:WIDTH:>" height="<:HEIGHT:>" src="<:FILENAME:>" border="0" pluginspage="http://www.apple.com/quicktime/download/indext.html"></embed>', 'video_mov.gif'),
('avi', 'Video/AVI', '3', '<embed src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" type="application/x-mplayer2"></embed>', 'video_avi.gif'),
('mpg', 'Video/MPEG', '3', '<embed src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" type="application/x-mplayer2"></embed>', 'video_mpg.gif'),
('mp3', 'Audio/MP3', '2', '<embed controller="true" width="200" height="20" src="<:FILENAME:>" border="0" pluginspage="http://www.apple.com/quicktime/download/indext.html"></embed>', 'audio_mp3.gif'),
('mid', 'Audio/MIDI', '2', '<embed src="<:FILENAME:>" type="audio/midi" hidden="false" autostart="true" loop="true" height="20" width="200"></embed>', 'audio_mid.gif'),
('swf', 'Video/Flash', '3', '<embed src="<:FILENAME:>" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="<:WIDTH:>" height="<:HEIGHT:>" play="true" loop="true" quality="high" scale="showall" menu="true"></embed>', 'video_swf.gif'),
('rm', 'Video/RealMedia', '3', '<OBJECT height="<:HEIGHT:>">\n<PARAM NAME="CONTROLS" VALUE="ImageWindow">\n<PARAM NAME="AUTOSTART" Value="true">\n<PARAM NAME="SRC" VALUE="<:FILENAME:>">\n<embed height="<:HEIGHT:>" width="<:WIDTH:>" controls="ImageWindow" src="<:FILENAME:>?embed" type="audio/x-pn-realaudio-plugin" autostart="true" nolabels="0" autogotourl="-1"></OBJECT>', 'video_realmedia.gif');
# --------------------------------------------------------

#
# Tabel structuur voor tabel `nuke_gallery_template_types`
#

DROP TABLE IF EXISTS `nuke_gallery_template_types`;
CREATE TABLE `nuke_gallery_template_types` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`type` tinyint(3) unsigned NOT NULL default '2',
`templateCategory` longtext NOT NULL,
`templatePictures` longtext NOT NULL,
`templateCSS` longtext,
PRIMARY KEY (`id`)
) TYPE=MyISAM;

#
# Gegevens worden uitgevoerd voor tabel `nuke_gallery_template_types`
#

INSERT INTO `nuke_gallery_template_types` (`id`, `title`, `type`, `templateCategory`, `templatePictures`, `templateCSS`) VALUES (1, 'Default Main Page Template', 1, '<table align="center">\n<tr>\n <td colspan="2">\n <:GALLNAME:>\n </td>\n</tr>\n<tr>\n <td>\n <:IMAGE:>\n </td>\n <td valign="top" align="left">\n <:DESCRIPTION:>\n </td>\n</tr>\n</table>', '2', '.common_text_black {text-color:#000000}\n.common_text_white {text-color:#ffffff}'),
(2, 'Default', 2, '<table border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n <td>\r\n <:IMAGE:>\r\n </td>\r\n <td valign="top">\r\n <p>\r\n <table>\r\n <tr>\r\n <td align="center">\r\n <:DATE:>\r\n </td>\r\n <td align="center">\r\n <:RATE:>\r\n </td>\r\n <td align="center">\r\n <:HITS:>\r\n </td>\r\n <td align="center">\r\n <:NEW:>\r\n </td>\r\n </tr>\r\n </table>\r\n </p>\r\n <p>\r\n <:DESCRIPTION:>\r\n </p>\r\n <p>\r\n <:NBCOMMENTS:> <br> <:FORMAT:> <br> <:SIZE:>\r\n </p>\r\n </td>\r\n</tr>\r\n</table>', '<table>\r\n<tr>\r\n <td valign="top" align="center">\r\n <:NAMESIZE:>\r\n <br><br>\r\n <TABLE CellPadding="0" CellSpacing="0">\r\n <TR>\r\n <TD valign="top">\r\n <:SUBMITTER:>\r\n <:DATE:>\r\n <:HITS:>\r\n <:RATE:>\r\n </TD>\r\n </TR>\r\n </table><br>\r\n <:RATINGBAR:><br>\r\n <:POSTCARD:><br>\r\n <:DOWNLOAD:><br>\r\n <:PRINT:>\r\n </td>\r\n <td width="80%" align="center">\r\n <:IMAGE:>\r\n </td>\r\n</tr>\r\n<tr>\r\n <td colspan="2"><:DESCRIPTION:></td>\r\n</tr>\r\n<tr>\r\n <td colspan="2">\r\n <:COMMENTS:>\r\n </td>\r\n</tr>\r\n</table>', '.common_text_black {text-color:#000000}\r\n.common_text_white {text-color:#ffffff}');

Anlamadım gitti bu tablolar niye farklılık gösteriyor birisi bana YARDIM etsin

Bu Site Google Adsense ile Gelir Elde Ediyor · Tarih: 2024-10-06, 05:40:19 Mesaj konusu: Forum Arası Reklamlar

aslanonur · Tarih: 2006-01-08, 18:17:18 Mesaj konusu:

Sakın kurma çok büyük bi açık var

seyranli · Tarih: 2006-01-08, 18:28:46 Mesaj konusu:

kapatılamayacak açık yoktur, iki 3 satır kodla kapanır o açık, ki cagonni de şahit geçenlerde bi yerinkini ayak üstü kapattım, sql de sorun yok, zaten daha önceden de yüklemişsin, o yüzden hata veriyo

_erc_ · Mesaj: 1+ Kayıt: Jan 08, 2006 Mesajlar: 12

e peki napçaz hate nerde veya başka bir öneriniz var mı?

seyranli · Tarih: 2006-01-08, 20:01:17 Mesaj konusu:

zaten daha önce yüklemişsin, hata vermiyo daha önceden oluşturulmuş bu diyo yine oluşturamayız diyo, istersen eskilerini sil devam et