مشكلة بعد رفع ملف stamps.sql الخاص بهاك الاوسمة

[ماسيك]

صارت معي مشكلة بعد رفع ملف stamps.sql
أول ما ارفع الملف تظهر لي هذه العبارات و لم أفهم فيها اي شيء





CREATE TABLE `award` (
`award_id` smallint(5) unsigned NOT NULL auto_increment,
`award_cat_id` smallint(5) NOT NULL default '1',
`award_name` varchar(50) NOT NULL default '',
`award_desc` text NOT NULL,
`award_icon_url` varchar(250) NOT NULL default '',
`award_img_url` varchar(225) NOT NULL default '',
`award_displayorder` smallint(5) NOT NULL default '0',
`award_allowrequest` tinyint(1) NOT NULL default '1',
`award_active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`award_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;# MySQL returned an empty result set (i.e. zero rows).


INSERT INTO `award` VALUES (1, 4, 'أ#أîأëأù أ#أ#أ-أí', 'أ#أîأëأù أ#أ#أ-أí', 'awards/0.gif', 'awards/1.gif', 1, 1, 1);# Affected rows: 1

INSERT INTO `award` VALUES (2, 5, 'أöأñأ& أ#أ#أ[...]

DROP TABLE IF EXISTS `award`;# MySQL returned an empty result set (i.e. zero rows ).


أتمنى ان تجدوا لي حلا لأن الهاك رائع ومحتاجه

تحياتي

[ابو عيسى]

السلام عليكم ورحمة الله وبركاته
لكى لايحدث هذا الخطا
الرجاء اتباع الخطوات بالترتيب ( ومهم الترتيب )

رفع المحتويات الى المنتدى
ثم
استيراد المنتج
ثم
استيراد الملف STAMP الى قاعدة البيانات
وللشرح بالتفصيل تفضل بزيارة موضوع الاخ ابوراشد

http://www.mwadah.com/t100649/

[ماسيك]

[align=center]اخي سوبت مثل الب يالشرح نفس المشكلةلاكن هذه المرة تمكنت من استهراج الخطأ الرئيسي

كلع لي هذا الكود


Error

SQL query:
DROP TABLE IF EXISTS `award` ;# MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE `award` ( `award_id` smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
`award_cat_id` smallint( 5 ) NOT NULL default '1',
`award_name` varchar( 50 ) NOT NULL default '',
`award_desc` text NOT NULL ,
`award_icon_url` varchar( 250 ) NOT NULL default '',
`award_img_url` varchar( 225 ) NOT NULL default '',
`award_displayorder` smallint( 5 ) NOT NULL default '0',
`award_allowrequest` tinyint( 1 ) NOT NULL default '1',
`award_active` tinyint( 1 ) NOT NULL default '1',
PRIMARY KEY ( `award_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =42;# MySQL returned an empty result set (i.e. zero rows).
INSERT INTO `award`
VALUES ( 1, 4, 'ãÔÑ&#22 1; ããíÒ' , 'ãÔÑ&#22 1; ããíÒ' , 'awards/0.gif', 'awards/1.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 2, 5, 'ÚÖæ ããíÒ' , 'ÚÖæ ããíÒ' , 'awards/0.gif', 'awards/2.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 3, 1, 'ÇáÊß Ñíã', 'ÇáÊß Ñíã', 'awards/0.gif', 'awards/3.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 4, 1, 'ÇáÅÈ ÏÇÚ', 'ÇáÅÈ ÏÇÚ', 'awards/0.gif', 'awards/4.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 5, 1, 'ÇáÅÈ ÏÇÚ', 'ÇáÅÈ ÏÇÚ', 'awards/0.gif', 'awards/5.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 6, 1, 'ÇáÅÊ ÞÇä', 'ÇáÅÊ ÞÇä', 'awards/0.gif', 'awards/6.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 7, 1, 'ÇáßÇ ÊÈ Çáãã& #237;Ò', 'ÇáßÇ ÊÈ Çáãã& #237;Ò', 'awards/0.gif', 'awards/7.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 8, 1, 'ãÊãí Ò Ýí Ýä ÇáÚá& #199;ÞÇÊ', 'ãÊãí Ò Ýí Ýä ÇáÚá& #199;ÞÇÊ', 'awards/0.gif', 'awards/8.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 9, 1, 'ÔÇÚ&#20 9; ããíÒ' , 'ÔÇÚ&#20 9; ããíÒ' , 'awards/0.gif', 'awards/9.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 10, 1, 'ÇáÊß Ñíã', 'ÇáÊß Ñíã', 'awards/0.gif', 'awards/10.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 11, 1, 'ÇáÊã íÒ', 'ÇáÊã íÒ', 'awards/0.gif', 'awards/11.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 12, 1, 'ÇáÊæ ÇÕá', 'ÇáÊæ ÇÕá', 'awards/0.gif', 'awards/20.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 13, 2, 'ÇáÅÏ ÇÑí Çáãã& #237;Ò', 'ÇáÅÏ ÇÑí Çáãã& #237;Ò', 'awards/0.gif', 'awards/13.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 14, 4, 'ÇáãÔ ÑÝ Çáãã& #237;Ò', 'ÇáãÔ ÑÝ Çáãã& #237;Ò', 'awards/0.gif', 'awards/14.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 15, 4, 'ÇáãÔ ÑÝÉ Çáãã& #237;ÒÉ', 'ÇáãÔ ÑÝÉ Çáãã& #237;ÒÉ', 'awards/0.gif', 'awards/15.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 16, 1, 'ßÈÇ&#20 9; ÇáÔÎ& #213;íÇÊ', 'ßÈÇ&#20 9; ÇáÔÎ& #213;íÇÊ', 'awards/0.gif', 'awards/16.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 17, 5, 'ÇáÊã íÒ ÇáÐå& #200;í', 'ÇáÊã íÒ ÇáÐå& #200;í', 'awards/0.gif', 'awards/17.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 18, 5, 'ÇáÊã íÒ ÇáÝÖ& #237;', 'ÇáÊã íÒ ÇáÝÖ& #237;', 'awards/0.gif', 'awards/18.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 19, 5, 'ÇáÊã íÒ ÇáÈÑ& #230;äÒí', 'ÇáÊã íÒ ÇáÈÑ& #230;äÒí', 'awards/0.gif', 'awards/19.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 20, 1, 'ÇáÞá ã Çáãã& #237;Ò', 'ÇáÞá ã Çáãã& #237;Ò', 'awards/0.gif', 'awards/20.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 21, 3, 'ÇáÍÖ æÑ Çáãã& #237;Ò', 'ÇáÍÖ æÑ Çáãã& #237;Ò', 'awards/0.gif', 'awards/21.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 22, 1, 'ÇáÊã íÒ ÇáÑí& #199;Öí', 'ÇáÊã íÒ ÇáÑí& #199;Öí', 'awards/0.gif', 'awards/22.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 23, 5, 'ÇáÚÖ æ Çáãã& #237;Ò', 'ÇáÚÖ æ Çáãã& #237;Ò', 'awards/0.gif', 'awards/23.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 24, 1, 'ÇáãÕ ãã Çáãã& #237;Ò', 'ÇáãÕ ãã Çáãã& #237;Ò', 'awards/0.gif', 'awards/24.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 25, 1, 'ÍæÇÁ ', 'ÍæÇÁ ', 'awards/0.gif', 'awards/25.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 26, 1, 'ãÕã&#22 7; ãÈÏÚ' , 'ãÕã&#22 7; ãÈÏÚ' , 'awards/0.gif', 'awards/26.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 27, 5, 'ÚÖæ ÐåÈí' , 'ÚÖæ ÐåÈí' , 'awards/0.gif', 'awards/27.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 28, 1, 'äÌã&#20 1; Çáãä& #202;Ïì', 'äÌã&#20 1; Çáãä& #202;Ïì', 'awards/0.gif', 'awards/28.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 29, 5, 'ÚÖæ ãÍÊÑ& #221;', 'ÚÖæ ãÍÊÑ& #221;', 'awards/0.gif', 'awards/29.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 30, 3, 'ÇáæÓ Çã ÇáÐå& #200;í', 'ÇáæÓ Çã ÇáÐå& #200;í', 'awards/0.gif', 'awards/30.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 31, 3, 'ÇáæÓ Çã ÇáÝÖ& #237;', 'ÇáæÓ Çã ÇáÝÖ& #237;', 'awards/0.gif', 'awards/31.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 32, 3, 'ÇáæÓ Çã ÇáÈÑ& #230;äÒí', 'ÇáæÓ Çã ÇáÈÑ& #230;äÒí', 'awards/0.gif', 'awards/32.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 33, 4, 'ÇáÞÓ ã Çáãã& #237;Ò', 'ÇáÞÓ ã Çáãã& #237;Ò', 'awards/0.gif', 'awards/33.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 34, 4, 'ÇáãÔ ÑÝ Çáãã& #237;Ò', 'ÇáãÔ ÑÝ Çáãã& #237;Ò', 'awards/0.gif', 'awards/34.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 35, 5, 'ÇáÚÖ æ Çáãã& #237;Ò', 'ÇáÚÖ æ Çáãã& #237;Ò', 'awards/0.gif', 'awards/35.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 36, 2, 'æÓÇ&#22 7; ÇáÊã& #237;Ò', 'æÓÇ&#22 7; ÇáÊã& #237;Ò', 'awards/0.gif', 'awards/36.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 37, 5, 'ÇáÚÖ æ Çáãã& #237;Ò', 'ÇáÚÖ æ Çáãã& #237;Ò', 'awards/0.gif', 'awards/37.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 38, 4, 'ÇáãÔ ÑÝ Çáãã& #237;Ò', 'ÇáãÔ ÑÝ Çáãã& #237;Ò', 'awards/0.gif', 'awards/38.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 39, 5, 'ÇáæÓ Çã ÇáÐå& #200;í', 'ÇáæÓ Çã ÇáÐå& #200;í', 'awards/0.gif', 'awards/30.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 40, 5, 'ÇáæÓ Çã ÇáÝÖ& #237;', 'ÇáæÓ Çã ÇáÝÖ& #237;', 'awards/0.gif', 'awards/31.gif', 1, 1, 1 ) ;# Affected rows: 1
INSERT INTO `award`
VALUES ( 41, 5, 'ÇáÊã íÒ ÇáÈÑ& #230;äÒí', 'ÇáÊã íÒ ÇáÈÑ& #230;äÒí', 'awards/0.gif', 'awards/32.gif', 1, 1, 1 ) ;# Affected rows: 1
DROP TABLE IF EXISTS `award_cat` ;# MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE `award_cat` ( `award_cat_id` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`award_cat_title` varchar( 100 ) NOT NULL default '',
`award_cat_desc` varchar( 250 ) NOT NULL default '',
`award_cat_displayorder` mediumint( 8 ) unsigned NOT NULL default '0',
`award_cat_parentid` mediumint( 8 ) NOT NULL default '-1',
PRIMARY KEY ( `award_cat_id` ) ,
KEY `award_cat_order` ( `award_cat_displayorder` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =6;# MySQL returned an empty result set (i.e. zero rows).
INSERT INTO `award_cat`
VALUES ( 1, 'ãäæÚ É', 'ÃæÓã É ãäæÚ& #201;', 1, -1 ) ;# Affected rows: 1
INSERT INTO `award_cat`
VALUES ( 2, 'ÇáÅÏ ÇÑíí& #228;', 'ÃæÓã É ÇáÅÏ& #199;Ñíí&# 228;', 2, -1 ) ;# Affected rows: 1
INSERT INTO `award_cat`
VALUES ( 3, 'ÇáãÑ ÇÞÈí& #228;', 'ÃæÓã É ÇáãÑ& #199;ÞÈí&# 228;', 3, -1 ) ;# Affected rows: 1
INSERT INTO `award_cat`
VALUES ( 4, 'ÇáãÔ ÑÝíä' , 'ÃæÓã É ÇáãÔ& #209;Ýíä', 4, -1 ) ;# Affected rows: 1
INSERT INTO `award_cat`
VALUES ( 5, 'ÇáÃÚ ÖÇÁ', 'ÃæÓã É ÇáÃÚ& #214;ÇÁ', 5, -1 ) ;# Affected rows: 1

MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE `award` ' at line 1
[/align]

[ابو عيسى]

السلام عليكم ورحمة الله وبركاته
استخدم الامر DROP اولا لحذف الملف بالكامل وبعد ما تحذف الملف بالكامل
استخدم الامر import وقم باستيراد الملف من جديد
الاوامر تجدها فى الاعلى على هيئة ازرار

[ماسيك]

[align=center]لم أجد ملف باسم Stamps في اللائحة[/align]