Форум пользователей MySQL

#TA dle_banners`1`216|dle_category`1`28|dle_comments`0`0|dle_email`5`3232|dle_files`0`0|dle_flood`0`0|dle_images`0`0|dle_logs`0`0|dle_lostdb`0`0|dle_notice`0`0|dle_pm`0`0|dle_poll`0`0|dle_poll_log`0`0|dle_post`3`4760|dle_rss`1`124|dle_rssinform`1`76|dle_static`0`0|dle_usergroups`5`416|dle_users`1`124|dle_views`0`0|dle_vote`1`176|dle_vote_result`0`0|dle_admin_sections`0`0|dle_awards`3`128|dle_awards_list`3`152|dle_banned`49`1880|dle_banners`1`332|dle_category`29`1352|dle_com_log`0`0|dle_comments`6`2252|dle_comments_vote`0`0|dle_complaint`0`0|dle_complaints_news`1`144|dle_demokey`0`0|dle_email`6`3644|dle_email_vip`2`1156|dle_faqanswer`0`0|dle_faqcategories`0`0|dle_files`7`652|dle_flood`1`84|dle_forum_category`2`44|dle_forum_email`4`1852|dle_forum_files`0`0|dle_forum_forums`7`1108|dle_forum_groups`5`108|dle_forum_moderators`5`108|dle_forum_poll_log`0`0|dle_forum_posts`9`2604|dle_forum_reputation_log`0`0|dle_forum_sessions`1`208|dle_forum_subscription`0`0|dle_forum_titles`3`76|dle_forum_topics`3`288|dle_forum_views`6`96|dle_forum_warn_log`0`0|dle_guestbook`0`0|dle_images`4334`393292|dle_logs`0`0|dle_lostdb`0`0|dle_notes`0`0|dle_notice`1`408|dle_obmen`4`436|dle_online`4`15876|dle_partner`0`0|dle_partners_link`0`0|dle_pm`1`180|dle_poll`0`0|dle_poll_log`0`0|dle_post`8750`38140892|dle_post_log`0`0|dle_referer`23`4036|dle_repa_comm`0`0|dle_rss`1`128|dle_rssinform`1`88|dle_serials`0`0|dle_sessions`0`0|dle_static`1`2804|dle_static_files`0`0|dle_statistic`92`188588|dle_tags`11`240|dle_texlink`0`0|dle_toplist`4`1132|dle_usergroups`6`572|dle_users`316`77404|dle_users_filter`0`0|dle_views`0`0|dle_vote`1`608|dle_vote_result`8`420|forumaccess`0`0|forumadminhelp`1394`71628|forumadministrator`1`20|forumadminlog`43`2344|forumadminmessage`0`0|forumadminutil`1`24|forumannouncement`0`0|forumannouncementread`0`0|forumattachment`0`0|forumattachmentpermission`0`0|forumattachmenttype`11`700|forumattachmentviews`0`0|forumavatar`0`0|forumbbcode`0`0|forumcalendar`1`56|forumcalendarcustomfield`0`0|forumcalendarmoderator`0`0|forumcalendarpermission`0`0|forumcron`17`1620|forumcronlog`2`60|forumcustomavatar`0`0|forumcustomprofilepic`0`0|forumdatastore`20`37572|forumdeletionlog`0`0|forumeditlog`0`0|forumevent`0`0|forumexternalcache`0`0|forumfaq`33`1392|forumforum`9`1496|forumforumpermission`0`0|forumforumread`0`0|forumholiday`0`0|forumicon`14`604|forumimagecategory`3`84|forumimagecategorypermission`0`0|foruminfraction`0`0|foruminfractionban`0`0|foruminfractiongroup`0`0|foruminfractionlevel`4`72|forumlanguage`2`659156|forummailqueue`0`0|forummoderation`0`0|forummoderator`1`13|forummoderatorlog`0`0|forumpasswordhistory`0`0|forumpaymentapi`7`2024|forumpaymentinfo`0`0|forumpaymenttransaction`0`0|forumphrase`14686`2162076|forumphrasetype`59`2264|forumplugin`0`0|forumpm`0`0|forumpmreceipt`0`0|forumpmtext`0`0|forumpodcast`0`0|forumpodcastitem`0`0|forumpoll`0`0|forumpollvote`0`0|forumpost`1`132|forumposthash`1`49|forumpostindex`0`0|forumpostparsed`1`80|forumproduct`0`0|forumproductcode`0`0|forumproductdependency`0`0|forumprofilefield`4`96|forumprofilefieldcategory`0`0|forumranks`0`0|forumregimage`0`0|forumreminder`0`0|forumreputation`0`0|forumreputationlevel`15`135|forumrssfeed`0`0|forumrsslog`0`0|forumsearch`0`0|forumsession`0`0|forumsetting`309`31688|forumsettinggroup`40`1144|forumsigparsed`0`0|forumsigpic`0`0|forumsmilie`11`2497|forumstats`1`17|forumstrikes`0`0|forumstyle`1`23596|forumsubscribeevent`0`0|forumsubscribeforum`0`0|forumsubscribethread`0`0|forumsubscription`0`0|forumsubscriptionlog`0`0|forumsubscriptionpermission`0`0|forumtachyforumpost`0`0|forumtachythreadpost`0`0|forumtemplate`399`1515936|forumtemplatehistory`0`0|forumthread`1`80|forumthreadrate`0`0|forumthreadread`0`0|forumthreadredirect`0`0|forumthreadviews`0`0|forumupgradelog`0`0|forumuser`1`160|forumuseractivation`0`0|forumuserban`0`0|forumuserfield`1`20|forumusergroup`8`808|forumusergroupleader`0`0|forumusergrouprequest`0`0|forumuserlist`0`0|forumusernote`0`0|forumuserpromotion`0`0|forumusertextfield`1`20|forumusertitle`3`771|forumword`0`0|Ваш_префикс_online`0`16384
#EOH
# TC`dle_banners`cp1251_general_ci ;
CREATE TABLE `dle_banners` (

`id` smallint( 5 ) NOT NULL AUTO_INCREMENT ,
`banner_tag` varchar( 40 ) NOT NULL default '',
`descr` varchar( 200 ) NOT NULL default '',
`code` text NOT NULL ,
`approve` tinyint( 1 ) NOT NULL default '0',
`short_place` tinyint( 1 ) NOT NULL default '0',
`bstick` tinyint( 1 ) NOT NULL default '0',
`main` tinyint( 1 ) NOT NULL default '0',
`category` varchar( 200 ) NOT NULL default '',
`grouplevel` varchar( 100 ) NOT NULL default 'all',
PRIMARY KEY ( `id` ) ) ENGINE = MYISAM AUTO_INCREMENT =2 DEFAULT CHARSET = cp1251;



Ответ MySQL: 

#1050 - Table 'dle_banners' already exists

а после очистки пишет
#1153 - Got a packet bigger than 'max_allowed_packet' bytes



В чем может быть дело?
Спасибо.

Отредактированно dimon2242 (01.12.2009 23:06:47)