منتديات phpBBArabia

كود: تحديد الكل

#
# phpBB Backup Script
# Dump of tables for phpbb_
# DATE : 01-12-2013 22:00:25 GMT
#
# Table: phpbb_styles
DROP TABLE IF EXISTS phpbb_styles;
CREATE TABLE `phpbb_styles` (
  `style_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `style_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `style_copyright` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `style_active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `template_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `theme_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `imageset_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`style_id`),
  UNIQUE KEY `style_name` (`style_name`),
  KEY `template_id` (`template_id`),
  KEY `theme_id` (`theme_id`),
  KEY `imageset_id` (`imageset_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO phpbb_styles (style_id, style_name, style_copyright, style_active, template_id, theme_id, imageset_id) VALUES (1, 'prosilver', '© phpBB Group', 1, 1, 1, 1);

# Table: phpbb_styles_imageset
DROP TABLE IF EXISTS phpbb_styles_imageset;
CREATE TABLE `phpbb_styles_imageset` (
  `imageset_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `imageset_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `imageset_copyright` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `imageset_path` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`imageset_id`),
  UNIQUE KEY `imgset_nm` (`imageset_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO phpbb_styles_imageset (imageset_id, imageset_name, imageset_copyright, imageset_path) VALUES (1, 'prosilver', '© phpBB Group', 'prosilver');

# Table: phpbb_styles_imageset_data
DROP TABLE IF EXISTS phpbb_styles_imageset_data;
CREATE TABLE `phpbb_styles_imageset_data` (
  `image_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `image_name` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
  `image_filename` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
  `image_lang` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
  `image_height` smallint(4) unsigned NOT NULL DEFAULT '0',
  `image_width` smallint(4) unsigned NOT NULL DEFAULT '0',
  `imageset_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`image_id`),
  KEY `i_d` (`imageset_id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO phpbb_styles_imageset_data (image_id, image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES (1, 'site_logo', 'site_logo.gif', '', 52, 139, 1),(2, 'forum_link', 'forum_link.gif', '', 27, 27, 1),(3, 'forum_read', 'forum_read.gif', '', 27, 27, 1),(4, 'forum_read_locked', 'forum_read_locked.gif', '', 27, 27, 1),(5, 'forum_read_subforum', 'forum_read_subforum.gif', '', 27, 27, 1),(6, 'forum_unread', 'forum_unread.gif', '', 27, 27, 1),(7, 'forum_unread_locked', 'forum_unread_locked.gif', '', 27, 27, 1),(8, 'forum_unread_subforum', 'forum_unread_subforum.gif', '', 27, 27, 1),(9, 'topic_moved', 'topic_moved.gif', '', 27, 27, 1),(10, 'topic_read', 'topic_read.gif', '', 27, 27, 1),(11, 'topic_read_mine', 'topic_read_mine.gif', '', 27, 27, 1),(12, 'topic_read_hot', 'topic_read_hot.gif', '', 27, 27, 1),(13, 'topic_read_hot_mine', 'topic_read_hot_mine.gif', '', 27, 27, 1),(14, 'topic_read_locked', 'topic_read_locked.gif', '', 27, 27, 1),(15, 'topic_read_locked_mine', 'topic_read_locked_mine.gif', '', 27, 27, 1),(16, 'topic_unread', 'topic_unread.gif', '', 27, 27, 1),(17, 'topic_unread_mine', 'topic_unread_mine.gif', '', 27, 27, 1),(18, 'topic_unread_hot', 'topic_unread_hot.gif', '', 27, 27, 1),(19, 'topic_unread_hot_mine', 'topic_unread_hot_mine.gif', '', 27, 27, 1),(20, 'topic_unread_locked', 'topic_unread_locked.gif', '', 27, 27, 1),(21, 'topic_unread_locked_mine', 'topic_unread_locked_mine.gif', '', 27, 27, 1),(22, 'sticky_read', 'sticky_read.gif', '', 27, 27, 1),(23, 'sticky_read_mine', 'sticky_read_mine.gif', '', 27, 27, 1),(24, 'sticky_read_locked', 'sticky_read_locked.gif', '', 27, 27, 1),(25, 'sticky_read_locked_mine', 'sticky_read_locked_mine.gif', '', 27, 27, 1),(26, 'sticky_unread', 'sticky_unread.gif', '', 27, 27, 1),(27, 'sticky_unread_mine', 'sticky_unread_mine.gif', '', 27, 27, 1),(28, 'sticky_unread_locked', 'sticky_unread_locked.gif', '', 27, 27, 1),(29, 'sticky_unread_locked_mine', 'sticky_unread_locked_mine.gif', '', 27, 27, 1),(30, 'announce_read', 'announce_read.gif', '', 27, 27, 1),(31, 'announce_read_mine', 'announce_read_mine.gif', '', 27, 27, 1),(32, 'announce_read_locked', 'announce_read_locked.gif', '', 27, 27, 1),(33, 'announce_read_locked_mine', 'announce_read_locked_mine.gif', '', 27, 27, 1),(34, 'announce_unread', 'announce_unread.gif', '', 27, 27, 1),(35, 'announce_unread_mine', 'announce_unread_mine.gif', '', 27, 27, 1),(36, 'announce_unread_locked', 'announce_unread_locked.gif', '', 27, 27, 1),(37, 'announce_unread_locked_mine', 'announce_unread_locked_mine.gif', '', 27, 27, 1),(38, 'global_read', 'announce_read.gif', '', 27, 27, 1),(39, 'global_read_mine', 'announce_read_mine.gif', '', 27, 27, 1),(40, 'global_read_locked', 'announce_read_locked.gif', '', 27, 27, 1),(41, 'global_read_locked_mine', 'announce_read_locked_mine.gif', '', 27, 27, 1),(42, 'global_unread', 'announce_unread.gif', '', 27, 27, 1),(43, 'global_unread_mine', 'announce_unread_mine.gif', '', 27, 27, 1),(44, 'global_unread_locked', 'announce_unread_locked.gif', '', 27, 27, 1),(45, 'global_unread_locked_mine', 'announce_unread_locked_mine.gif', '', 27, 27, 1),(46, 'pm_read', 'topic_read.gif', '', 27, 27, 1),(47, 'pm_unread', 'topic_unread.gif', '', 27, 27, 1),(48, 'icon_back_top', 'icon_back_top.gif', '', 11, 11, 1),(49, 'icon_contact_aim', 'icon_contact_aim.gif', '', 20, 20, 1),(50, 'icon_contact_email', 'icon_contact_email.gif', '', 20, 20, 1),(51, 'icon_contact_icq', 'icon_contact_icq.gif', '', 20, 20, 1),(52, 'icon_contact_jabber', 'icon_contact_jabber.gif', '', 20, 20, 1),(53, 'icon_contact_msnm', 'icon_contact_msnm.gif', '', 20, 20, 1),(54, 'icon_contact_www', 'icon_contact_www.gif', '', 20, 20, 1),(55, 'icon_contact_yahoo', 'icon_contact_yahoo.gif', '', 20, 20, 1),(56, 'icon_post_delete', 'icon_post_delete.gif', '', 20, 20, 1),(57, 'icon_post_info', 'icon_post_info.gif', '', 20, 20, 1),(58, 'icon_post_report', 'icon_post_report.gif', '', 20, 20, 1),(59, 'icon_post_target', 'icon_post_target.gif', '', 9, 11, 1),(60, 'icon_post_target_unread', 'icon_post_target_unread.gif', '', 9, 11, 1),(61, 'icon_topic_attach', 'icon_topic_attach.gif', '', 10, 7, 1),(62, 'icon_topic_latest', 'icon_topic_latest.gif', '', 9, 11, 1),(63, 'icon_topic_newest', 'icon_topic_newest.gif', '', 9, 11, 1),(64, 'icon_topic_reported', 'icon_topic_reported.gif', '', 14, 16, 1),(65, 'icon_topic_unapproved', 'icon_topic_unapproved.gif', '', 14, 16, 1),(66, 'icon_user_warn', 'icon_user_warn.gif', '', 20, 20, 1),(67, 'subforum_read', 'subforum_read.gif', '', 9, 11, 1),(68, 'subforum_unread', 'subforum_unread.gif', '', 9, 11, 1),(69, 'icon_contact_pm', 'icon_contact_pm.gif', 'ar', 20, 28, 1),(70, 'icon_post_edit', 'icon_post_edit.gif', 'ar', 20, 42, 1),(71, 'icon_post_quote', 'icon_post_quote.gif', 'ar', 20, 54, 1),(72, 'icon_user_online', 'icon_user_online.gif', 'ar', 58, 58, 1),(73, 'button_pm_forward', 'button_pm_forward.gif', 'ar', 25, 96, 1),(74, 'button_pm_new', 'button_pm_new.gif', 'ar', 25, 84, 1),(75, 'button_pm_reply', 'button_pm_reply.gif', 'ar', 25, 70, 1),(76, 'button_topic_locked', 'button_topic_locked.gif', 'ar', 25, 88, 1),(77, 'button_topic_new', 'button_topic_new.gif', 'ar', 25, 96, 1),(78, 'button_topic_reply', 'button_topic_reply.gif', 'ar', 25, 96, 1),(79, 'icon_contact_pm', 'icon_contact_pm.gif', 'en', 20, 28, 1),(80, 'icon_post_edit', 'icon_post_edit.gif', 'en', 20, 42, 1),(81, 'icon_post_quote', 'icon_post_quote.gif', 'en', 20, 54, 1),(82, 'icon_user_online', 'icon_user_online.gif', 'en', 58, 58, 1),(83, 'button_pm_forward', 'button_pm_forward.gif', 'en', 25, 96, 1),(84, 'button_pm_new', 'button_pm_new.gif', 'en', 25, 84, 1),(85, 'button_pm_reply', 'button_pm_reply.gif', 'en', 25, 96, 1),(86, 'button_topic_locked', 'button_topic_locked.gif', 'en', 25, 88, 1),(87, 'button_topic_new', 'button_topic_new.gif', 'en', 25, 96, 1),(88, 'button_topic_reply', 'button_topic_reply.gif', 'en', 25, 96, 1);

# Table: phpbb_styles_template
DROP TABLE IF EXISTS phpbb_styles_template;
CREATE TABLE `phpbb_styles_template` (
  `template_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `template_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `template_copyright` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `template_path` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `bbcode_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'kNg=',
  `template_storedb` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `template_inherits_id` int(4) unsigned NOT NULL DEFAULT '0',
  `template_inherit_path` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`template_id`),
  UNIQUE KEY `tmplte_nm` (`template_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO phpbb_styles_template (template_id, template_name, template_copyright, template_path, bbcode_bitfield, template_storedb, template_inherits_id, template_inherit_path) VALUES (1, 'prosilver', '© phpBB Group', 'prosilver', 'lNg=', 0, 0, '');

# Table: phpbb_styles_template_data
DROP TABLE IF EXISTS phpbb_styles_template_data;
CREATE TABLE `phpbb_styles_template_data` (
  `template_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `template_filename` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `template_included` text COLLATE utf8_bin NOT NULL,
  `template_mtime` int(11) unsigned NOT NULL DEFAULT '0',
  `template_data` mediumtext COLLATE utf8_bin NOT NULL,
  KEY `tid` (`template_id`),
  KEY `tfn` (`template_filename`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

# Table: phpbb_styles_theme
DROP TABLE IF EXISTS phpbb_styles_theme;
CREATE TABLE `phpbb_styles_theme` (
  `theme_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `theme_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `theme_copyright` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `theme_path` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `theme_storedb` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `theme_mtime` int(11) unsigned NOT NULL DEFAULT '0',
  `theme_data` mediumtext COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`theme_id`),
  UNIQUE KEY `theme_name` (`theme_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO phpbb_styles_theme (theme_id, theme_name, theme_copyright, theme_path, theme_storedb, theme_mtime, theme_data) VALUES (1, 'prosilver', '© phpBB Group', 'prosilver', 1, 0, '');

كود: تحديد الكل

??? ???
Could not get style data

كود: تحديد الكل

?????

?????? ??????? ??????? ????? ?? ?????? prosilver ?? ???? ?????? ??????? ?? ???? ?????? ??? ????

كود: تحديد الكل

??? ???

SQL ERROR [ mysql4 ]

Field 'user_aboutme' doesn't have a default value [1364]

??? ??? SQL ????? ?????? ???????? ??????. ??? ????? ????? ?? ??????? ???? ??????? ?? ??? ???????

???? ??? ????? ???? ???????: admin@oil.x10.mx

كود: تحديد الكل

aldambi_phpb434.phpbb_styles
repair
note
The storage engine for the table doesn't support r...
aldambi_phpb434.phpbb_styles_imageset
repair
note
The storage engine for the table doesn't support r...
aldambi_phpb434.phpbb_styles_imageset_data
repair
note
The storage engine for the table doesn't support r...
aldambi_phpb434.phpbb_styles_template
repair
note
The storage engine for the table doesn't support r.
aldambi_phpb434.phpbb_styles_template_data
repair
note
The storage engine for the table doesn't support r...
aldambi_phpb434.phpbb_styles_theme
repair
note
The storage engine for the table doesn't support r...

كود: تحديد الكل

SQL ERROR [ mysql4 ]

Field 'user_aboutme' doesn't have a default value [1364]

كود: تحديد الكل

name =

كود: تحديد الكل

name = prosilver