سلام دوستان
برای انتقال فایلها و دیتابیس فرومم به هاست جدید با مشکل مواجه شدم...
از طرف پشتیبانی هاست جدید (که مسئول انتقال فایلها بودند) اعلام کردند که هنگام ایمپورت دیتابیس با این ارور مواجه شدند:
ERROR 1064 (42000) at line 69: 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 ''vbulleti' at line 1
و گفتند که این مشکل رو باید خودم برطرف کنم...
منتهی من هیچ سررشتهای در خصوص رفع این مشکل ندارم...!
کسی میتونه منو راهنمایی کنه؟
فرومم بین زمین و هوا باقی مونده...!
در خط 1 دیتابیسم همچین عبارتی وجود داره:
MySQL dump 10.13 Distrib 5.1.70, for unknown-linux-gnu (x86_64)
و در خط 69 هم چنین چیزی نوشته شده:
INSERT INTO `adminhelp` (`adminhelpid`, `script`, `action`, `optionname`, `displayorder`, `volatile`, `product`) VALUES (1,'accessmask','','',1,1,'vbulletin'),(2,'accessm ask','edit','',1,1,'vbulletin'),(3,'accessmask','m odify','',1,1,'vbulletin'),(4,'accessmask','quicke dit','',1,1,'vbulletin'),(5,'accessmask','resetall ','',1,1,'vbulletin'),(6,'admincalendar','','',1,1 ,'vbulletin'),(7,'admincalendar','add','',1,1,'vbu lletin'),(8,'admincalendar','add,edit','title',20, 1,'vbulletin'),(9,'admincalendar','add,edit','disp layorder',40,1,'vbulletin'),(10,'admincalendar','a dd,edit','customfields',50,1,'vbulletin'),(11,'adm incalendar','add,edit','neweventemail',60,1,'vbull etin'),(12,'admincalendar','add,edit','moderatenew ',70,1,'vbulletin'),(13,'admincalendar','add,edit' ,'daterange',75,1,'vbulletin'),(14,'admincalendar' ,'add,edit','default',76,1,'vbulletin'),(15,'admin calendar','add,edit','startofweek',80,1,'vbulletin '),(16,'admincalendar','add,edit','cutoff',90,1,'v bulletin'),(17,'admincalendar','add,edit','eventco unt',100,1,'vbulletin'),(18,'admincalendar','add,e dit','birthdaycount',110,1,'vbulletin'),(19,'admin calendar','add,edit','showbirthdays',120,1,'vbulle tin'),(20,'admincalendar','add,edit','showholidays ',130,1,'vbulletin'),(21,'admincalendar','add,edit ','holidays',135,1,'vbulletin'),(22,'admincalendar ','add,edit','showweekends',140,1,'vbulletin'),(23 ,'admincalendar','add,edit','showupcoming',145,1,' vbulletin'),(24,'admincalendar','add,edit','allowh tml',150,1,'vbulletin'),(25,'admincalendar','add,e dit','allowbbcode',160,1,'vbulletin'),(26,'adminca lendar','add,edit','allowimgcode',170,1,'vbulletin '),(27,'admincalendar','add,edit','allowsmilies',1 80,1,'vbulletin'),(28,'admincalendar','addcustom', '',1,1,'vbulletin'),(29,'admincalendar','addcustom ','title',20,1,'vbulletin'),(30,'admincalendar','a ddcustom','description',25,1,'vbulletin'),(31,'adm incalendar','addcustom','options',30,1,'vbulletin' ),(32,'admincalendar','addcustom','allowentry',40, 1,'vbulletin'),(33,'admincalendar','addcustom','le ngth',50,1,'vbulletin'),(34,'admincalendar','addcu stom','required',60,1,'vbulletin'),(35,'admincalen dar','addmod','',1,1,'vbulletin'),(36,'admincalend ar','addmod','modusername',30,1,'vbulletin'),(37,' admincalendar','addmod,editmod','calendarid',20,1, 'vbulletin'),(38,'admincalendar','addmod,editmod', 'caneditevents',40,1,'vbulletin'),(39,'admincalend ar','addmod,editmod','candeleteevents',50,1,'vbull etin'),(40,'admincalendar','addmod,editmod','canmo veevents',55,1,'vbulletin'),(41,'admincalendar','a ddmod,editmod','canmoderateevents',60,1,'vbulletin '),(42,'admincalendar','addmod,editmod','canviewip s',70,1,'vbulletin'),(43,'admincalendar','deletecu stom','',1,1,'vbulletin'),(44,'admincalendar','edi t','',1,1,'vbulletin'),(45,'admincalendar','editmo d','',1,1,'vbulletin'),(46,'admincalendar','modify ','',1,1,'vbulletin'),(47,'admincalendar','modifyh oliday','',1,1,'vbulletin'),(48,'admincalendar','r emove','',1,1,'vbulletin'),(49,'admincalendar','re moveholiday','',1,1,'vbulletin'),(50,'admincalenda r','removemod','',1,1,'vbulletin'),(51,'admincalen dar','updateholiday','',1,1,'vbulletin'),(52,'admi ncalendar','updateholiday','description',1,1,'vbul letin'),(53,'admincalendar','updateholiday','varna me',10,1,'vbulletin'),(54,'admincalendar','updateh oliday','title',20,1,'vbulletin'),(55,'admincalend ar','updateholiday','event',30,1,'vbulletin'),(56, 'admincalendar','updateholiday','recurring',40,1,' vbulletin'),(57,'admincalendar','updateholiday','a llowsmilies',50,1,'vbulletin'),(58,'admininfractio n','','',1,1,'vbulletin'),(59,'admininfraction','e ditbangroup','amount',10,1,'vbulletin'),(60,'admin infraction','editbangroup','method',20,1,'vbulleti n'),(61,'admininfraction','editbangroup','usergrou pid',30,1,'vbulletin'),(62,'admininfraction','edit bangroup','banusergroupid',50,1,'vbulletin'),(63,' admininfraction','editbangroup','period',60,1,'vbu lletin'),(64,'admininfraction','editgroup','',1,1, 'vbulletin'),(65,'admininfraction','editgroup','ov erride',1,1,'vbulletin'),(66,'admininfraction','ed itgroup','pointlevel',2,1,'vbulletin'),(67,'admini nfraction','editgroup','usergroupid',10,1,'vbullet in'),(68,'admininfraction','editgroup','orusergrou pid',30,1,'vbulletin'),(69,'admininfraction','edit level','title',1,1,'vbulletin'),(70,'admininfracti on','editlevel','expires',5,1,'vbulletin'),(71,'ad mininfraction','editlevel','points',7,1,'vbulletin '),(72,'admininfraction','editlevel','warning',10, 1,'vbulletin'),(73,'admininfraction','editlevel',' extend',15,1,'vbulletin'),(74,'admininfraction','m odify','',1,1,'vbulletin'),(75,'adminlog','','',1, 1,'vbulletin'),(76,'adminlog','choose','',1,1,'vbu lletin'),(77,'adminlog','choose','enddate',1,1,'vb ulletin'),(78,'adminlog','choose','startdate',1,1, 'vbulletin'),(79,'adminlog','choose','perpage',20, 1,'vbulletin'),(80,'adminlog','choose','script',30 ,1,'vbulletin'),(81,'adminlog','choose','userid',4 0,1,'vbulletin'),(82,'adminlog','choose','orderby' ,50,1,'vbulletin'),(83,'adminlog','choose','pscrip t',60,1,'vbulletin'),(84,'adminlog','choose','puse rid',70,1,'vbulletin'),(85,'adminlog','choose','da ysprune',80,1,'vbulletin'),(86,'adminlog','prunelo g','',1,1,'vbulletin'),(87,'adminlog','resolveip', '',2,1,'vbulletin'),(88,'adminlog','restrict','',1 ,1,'vbulletin'),(89,'adminlog','view','',1,1,'vbul letin'),(90,'adminpermissions','','',1,1,'vbulleti n'),(91,'adminpermissions','edit','',1,1,'vbulleti n'),(92,'adminpermissions','edit','canadminmodlog' ,1,1,'vbulletin'),(93,'adminpermissions','edit','d ismissednews',1,1,'vbulletin'),(94,'adminpermissio ns','edit','canadminsettings',20,1,'vbulletin'),(9 5,'adminpermissions','edit','canadminstyles',30,1, 'vbulletin'),(96,'adminpermissions','edit','canadm inlanguages',40,1,'vbulletin'),(97,'adminpermissio ns','edit','canadminforums',50,1,'vbulletin'),(98, 'adminpermissions','edit','canadminthreads',60,1,' vbulletin'),(99,'adminpermissions','edit','canadmi ncalendars',70,1,'vbulletin'),(100,'adminpermissio ns','edit','canadminusers',80,1,'vbulletin'),(101, 'adminpermissions','edit','canadminfaq',90,1,'vbul letin'),(102,'adminpermissions','edit','canadminpe rmissions',90,1,'vbulletin'),(103,'adminpermission s','edit','canadminimages',100,1,'vbulletin'),(104 ,'adminpermissions','edit','canadminbbcodes',110,1 ,'vbulletin'),(105,'adminpermissions','edit','cana dmincron',120,1,'vbulletin'),(106,'adminpermission s','edit','canadminmaintain',130,1,'vbulletin'),(1 07,'adminpermissions','edit','canadminplugins',135 ,1,'vbulletin'),(108,'adminpermissions','edit','ca nadminnotices',136,1,'vbulletin'),(109,'adminpermi ssions','edit','cssprefs',140,1,'vbulletin'),(110, 'adminpermissions','modify','',1,1,'vbulletin'),(1 11,'adminreputation','','',1,1,'vbulletin'),(112,' adminreputation','add','',1,1,'vbulletin'),(113,'a dminreputation','add,edit','level',10,1,'vbulletin '),(114,'adminreputation','add,edit','minimumreput ation',20,1,'vbulletin'),(115,'adminreputation','d eletereputation','',1,1,'vbulletin'),(116,'adminre putation','dolist','',1,1,'vbulletin'),(117,'admin reputation','edit','',1,1,'vbulletin'),(118,'admin reputation','editreputation','',1,1,'vbulletin'),( 119,'adminreputation','editreputation','reason',10 ,1,'vbulletin'),(120,'adminreputation','editreputa tion','reputation',20,1,'vbulletin'),(121,'adminre putation','list','',1,1,'vbulletin'),(122,'adminre putation','list,dolist','leftfor',10,1,'vbulletin' ),(123,'adminreputation','list,dolist','leftby',20 ,1,'vbulletin'),(124,'adminreputation','list,dolis t','start',30,1,'vbulletin'),(125,'adminreputation ','list,dolist','end',40,1,'vbulletin'),(126,'admi nreputation','modify','',1,1,'vbulletin'),(127,'ad minreputation','remove','',1,1,'vbulletin'),(128,' album','storage','',1,1,'vbulletin'),(129,'album', 'switchtype','album_picpath',1,1,'vbulletin'),(130 ,'album','switchtype','album_thumbpath',1,1,'vbull etin'),(131,'album','switchtype','album_thumburl', 1,1,'vbulletin'),(132,'album','thumb','perpage',1, 1,'vbulletin'),(133,'album','thumb','quality',1,1, 'vbulletin'),(134,'announcement','','',1,1,'vbulle tin'),(135,'announcement','add','',1,1,'vbulletin' ),(136,'announcement','add','signature',120,1,'vbu lletin'),(137,'announcement','add,edit','forumid', 20,1,'vbulletin'),(138,'announcement','add,edit',' title',30,1,'vbulletin'),(139,'announcement','add, edit','startdate',40,1,'vbulletin'),(140,'announce ment','add,edit','enddate',50,1,'vbulletin'),(141, 'announcement','add,edit','pagetext',60,1,'vbullet in'),(142,'announcement','add,edit','allowbbcode', 70,1,'vbulletin'),(143,'announcement','add,edit',' allowsmilies',80,1,'vbulletin'),(144,'announcement ','add,edit','allowhtml',90,1,'vbulletin'),(145,'a nnouncement','add,edit','parseurl',110,1,'vbulleti n'),(146,'announcement','edit','',1,1,'vbulletin') ,(147,'announcement','edit','reset_views',100,1,'v bulletin'),(148,'announcement','modify','',1,1,'vb ulletin'),(149,'announcement','remove','',1,1,'vbu lletin'),(150,'attachment','','',1,1,'vbulletin'), (151,'attachment','delete','',1,1,'vbulletin'),(15 2,'attachment','edit','',1,1,'vbulletin'),(153,'at tachment','edit','upload',1,1,'vbulletin'),(154,'a ttachment','edit','url',1,1,'vbulletin'),(155,'att achment','edit','a_filename',20,1,'vbulletin'),(15 6,'attachment','edit','a_counter',30,1,'vbulletin' ),(157,'attachment','edit','a_visible',40,1,'vbull etin'),(158,'attachment','intro','',1,1,'vbulletin '),(159,'attachment','intro','prunedate',10,1,'vbu lletin'),(160,'attachment','intro','filename',15,1 ,'vbulletin'),(161,'attachment','intro','attachedb y',20,1,'vbulletin'),(162,'attachment','intro','da telinebefore',30,1,'vbulletin'),(163,'attachment', 'intro','datelineafter',40,1,'vbulletin'),(164,'at tachment','intro','downloadsmore',50,1,'vbulletin' ),(165,'attachment','intro','downloadsless',60,1,' vbulletin'),(166,'attachment','intro','sizemore',7 0,1,'vbulletin'),(167,'attachment','intro','sizele ss',80,1,'vbulletin'),(168,'attachment','intro','v isible',90,1,'vbulletin'),(169,'attachment','intro ','orderby',100,1,'vbulletin'),(170,'attachment',' intro','results',110,1,'vbulletin'),(171,'attachme nt','massdelete','',1,1,'vbulletin'),(172,'attachm ent','removetype','',1,1,'vbulletin'),(173,'attach ment','search','',1,1,'vbulletin'),(174,'attachmen t','stats','',1,1,'vbulletin'),(175,'attachment',' storage,switchtype','',1,1,'vbulletin'),(176,'atta chment','switchtype','attachpath',1,1,'vbulletin') ,(177,'attachment','types','',1,1,'vbulletin'),(17 8,'attachment','updatetype','',1,1,'vbulletin'),(1 79,'attachment','updatetype','extension',10,1,'vbu lletin'),(180,'attachment','updatetype','size',20, 1,'vbulletin'),(181,'attachment','updatetype','hei ght',30,1,'vbulletin'),(182,'attachment','updatety pe','width',40,1,'vbulletin'),(183,'attachment','u pdatetype','mimetype',50,1,'vbulletin'),(184,'atta chment','updatetype','enabled',60,1,'vbulletin'),( 185,'attachment','updatetype','newwindow',70,1,'vb ulletin'),(186,'attachmentpermission','edit','heig ht',1,1,'vbulletin'),(187,'attachmentpermission',' edit','size',1,1,'vbulletin'),(188,'attachmentperm ission','edit','useextension',1,1,'vbulletin'),(18 9,'attachmentpermission','edit','width',1,1,'vbull etin'),(190,'avatar','','',1,1,'vbulletin'),(191,' avatar','storage,switchtype','',1,1,'vbulletin'),( 192,'avatar','switchtype','avatarpath',1,1,'vbulle tin'),(193,'avatar','switchtype','avatarurl',1,1,' vbulletin'),(194,'avatar','switchtype','profilepic path',1,1,'vbulletin'),(195,'avatar','switchtype', 'profilepicurl',1,1,'vbulletin'),(196,'avatar','sw itchtype','sigpicpath',1,1,'vbulletin'),(197,'avat ar','switchtype','sigpicurl',1,1,'vbulletin'),(198 ,'backup','','',1,1,'vbulletin'),(199,'backup','ch oose','',1,1,'vbulletin'),(200,'backup','choose',' filename',10,1,'vbulletin'),(201,'backup','choose' ,'table',20,1,'vbulletin'),(202,'backup','choose', 'separator',30,1,'vbulletin'),(203,'backup','choos e','quotes',40,1,'vbulletin'),(204,'backup','choos e','showhead',50,1,'vbulletin'),(205,'backup','mys qldump','',1,1,'vbulletin'),(206,'banning','','',1 ,1,'vbulletin'),(207,'banning','banuser','',1,1,'v bulletin'),(208,'banning','banuser','username',10, 1,'vbulletin'),(209,'banning','banuser','usergroup id',20,1,'vbulletin'),(210,'banning','banuser','pe riod',30,1,'vbulletin'),(211,'banning','banuser,ed itreason','reason',40,1,'vbulletin'),(212,'banning ','modify','',1,1,'vbulletin'),(213,'bbcode','','' ,1,1,'vbulletin'),(214,'bbcode','add','',1,1,'vbul letin'),(215,'bbcode','add,edit','title',10,1,'vbu lletin'),(216,'bbcode','add,edit','bbcodetag',20,1 ,'vbulletin'),(217,'bbcode','add,edit','bbcoderepl acement',30,1,'vbulletin'),(218,'bbcode','add,edit ','bbcodeexample',50,1,'vbulletin'),(219,'bbcode', 'add,edit','bbcodeexplanation',60,1,'vbulletin'),( 220,'bbcode','add,edit','twoparams',70,1,'vbulleti n'),(221,'bbcode','add,edit','buttonimage',80,1,'v bulletin'),(222,'bbcode','add,edit','strip_empty', 90,1,'vbulletin'),(223,'bbcode','add,edit','stop_p arse',100,1,'vbulletin'),(224,'bbcode','add,edit', 'disable_smilies',110,1,'vbulletin'),(225,'bbcode' ,'add,edit','disable_wordwrap',120,1,'vbulletin'), (226,'bbcode','edit','',1,1,'vbulletin'),(227,'bbc ode','modify','',1,1,'vbulletin'),(228,'bbcode','m odify','text',20,1,'vbulletin'),(229,'bbcode','rem ove','',1,1,'vbulletin'),(230,'bookmarksite','add, edit','active',1,1,'vbulletin'),(231,'bookmarksite ','add,edit','displayorder',1,1,'vbulleti
از اساتید اهل فن، به شدت تقاضای کمک دارم...!![]()
علاقه مندی ها (Bookmarks)