kvesen Posted February 13, 2010 Report Share Posted February 13, 2010 Tātad es gribu pievienot jaunu tabulu ibf_forums tikai man nesanāk. Daru tā ieeju savā datubāzē uzspiežu SQL un tad iekopēju šo. Tad man izmet šo Error SQL query: INSERT INTO `ibf_forums` (`id`, `topics`, `posts`, `last_post`, `last_poster_id`, `last_poster_name`, `name`, `description`, `position`, `use_ibc`, `use_html`, `status`, `password`, `password_override`, `last_title`, `last_id`, `sort_key`, `sort_order`, `prune`, `topicfilter`, `show_rules`, `preview_posts`, `allow_poll`, `allow_pollbump`, `inc_postcount`, `skin_id`, `parent_id`, `quick_reply`, `redirect_url`, `redirect_on`, `redirect_hits`, `redirect_loc`, `rules_title`, `rules_text`, `topic_mm_id`, `notify_modq_emails`, `sub_can_post`, `permission_custom_error`, `permission_array`, `permission_showtopic`, `queued_topics`, `queued_posts`, `forum_allow_rating`, `forum_last_deletion`, `newest_title`, `newest_id`) VALUES (2, 5, 12, 1262615956, 3, 'Lostmag*', 'Jaunumi', 'Viss kas ir jauns iekš creekz', 1, 1, 0, 1, '', '', 'Labāko banneru konkurs !', 421, 'last_post', 'Z-A', 100, 'all', 0, 0, 1, 1, 1, NULL, 1, 1, '', 0, 0, '', '', '', '', '', 1, '', 'a:6:{s:11:\\"start_perms\\";s:3:\[...] MySQL said: Documentation #1146 - Table 'creekz_www.ibf_forums' doesn't exist Ceru ka sapratāt un varēsiet palīdzēt. Quote Link to comment Share on other sites More sharing options...
anonīms Posted February 13, 2010 Report Share Posted February 13, 2010 Tapēc, ka tu mēģini izveidot nevis jaunu tabulu, bet gan tajā neeksistējošajā tabulā kaut ko ievietot. http://dev.mysql.com/doc/refman/5.1/en/create-table.html Quote Link to comment Share on other sites More sharing options...
2easy Posted February 13, 2010 Report Share Posted February 13, 2010 yep, sākumā izveido tabulas struktūru ar visiem laukiem un tad varēsi insertot. atrodi sql, kas sākas ar CREATE TABLE ibf_forums (...) Quote Link to comment Share on other sites More sharing options...
kvesen Posted February 13, 2010 Author Report Share Posted February 13, 2010 (edited) Labi paldies! Bet tagad es gribētu zināt kas tā ir par tabulu ka piemēram dabūn atpakaļ visus vecos adminus web cieta nelielu hack un gadījās ka webā vairs neviens nav admins tādēļ es gribu no vecās datubāzes visu salasīt lai būtu kārtībā. Nu es gribu zināt kuru tabulu ieliekot varēs dabūt atpakaļ adminus. Forums man ir islēkts tas kurš tika manā ACP izslēdza un arī es domāju ka tikšu atpakaļ savā profilā varēšu forumu ieslēkt. Pareizāk sakot es pats esmu no foruma izdzēst, bet vecajā datubāzē vēl eksistēju. Tagad tā padomāju tad arī lietotāji ir jāliek, bet vai ir tāds risinājums ka es ielieku tikai sevi kā lietotāju iekšā ? Tikai protams tad arī es lai būtu admins. Edited February 13, 2010 by kvesen Quote Link to comment Share on other sites More sharing options...
anonīms Posted February 13, 2010 Report Share Posted February 13, 2010 nu tad paņem iemet veco tabulu, kurā tika uzskaitīti visi admini. Varētu pat būt, ka vainīga tabula ir 'members' Quote Link to comment Share on other sites More sharing options...
2easy Posted February 13, 2010 Report Share Posted February 13, 2010 ja tur vsp vēl ir useru tabula, tad vari sevi insertot, bet izskatās, ka tur nemaz vairs nav tādas user tabulas. līdz ar to, nav kur insertot... tādā gadījumā sākumā vajag atjaunot pašu tabulas struktūru (no vecās db). skaties vsp, kas tev tur vēl ir palicis pāri pēc tā uzbrukuma. pārējās tabulas ir? Quote Link to comment Share on other sites More sharing options...
kvesen Posted February 13, 2010 Author Report Share Posted February 13, 2010 (edited) Man ir palikšas visas tabulas, bet es pats kā galvenais admins esmu izdzēsts un visiem parējiem vnk admins ir noņemts tātad man ir saglabājusies vecā datubāze tikai protams tā ir vecā ar vecajiem topikiem un memberiem, bet nu topiki nav tik svarīgi gribu sevi dabūt no vecās datubāzes iekšā jaunajā. Tātad es kaut ko tur padarīju un saliku šādi[/url. Tikai es īsti nesaprotu kas man ir par kļūdu. Error SQL query: INSERT INTO `ibf_members` (`id`, `name`, `mgroup`, `email`, `joined`, `ip_address`, `posts`, `title`, `allow_admin_mails`, `time_offset`, `hide_email`, `email_pm`, `email_full`, `skin`, `warn_level`, `warn_lastwarn`, `language`, `last_post`, `restrict_post`, `view_sigs`, `view_img`, `view_avs`, `view_pop`, `bday_day`, `bday_month`, `bday_year`, `new_msg`, `msg_total`, `show_popup`, `misc`, `last_visit`, `last_activity`, `dst_in_use`, `view_prefs`, `coppa_user`, `mod_posts`, `auto_track`, `temp_ban`, `sub_end`, `login_anonymous`, `ignored_users`, `mgroup_others`, `org_perm_id`, `member_login_key`, `member_login_key_expire`, `subs_pkg_chosen`, `has_blog`, `has_gallery`, `members_markers`, `members_editor_choice`, `members_auto_dst`, `members_display_name`, `members_created_remote`, `members_cache`, `members_disable_pm`, `members_l_display_name`, `members_l_username`, `failed_logins`, `failed_login_count`, `members_profile_views`, `d22shoutbox_banned`, `d22shoutbox_banned_by`, `d22shoutbo[...] MySQL said: Documentation #1136 - Column count doesn't match value count at row 1 Nu kļūda ir tāda. Nu protams pirms liku INSERT INTO `ibf_members` Es ieliku tabulu. Nu kas tur var būt par kļūdu ? Edited February 13, 2010 by kvesen Quote Link to comment Share on other sites More sharing options...
2easy Posted February 13, 2010 Report Share Posted February 13, 2010 Nu kas tur var būt par kļūdu ? Column count doesn't match value count at row 1 http://translate.google.lv Quote Link to comment Share on other sites More sharing options...
kvesen Posted February 13, 2010 Author Report Share Posted February 13, 2010 Column count doesn't match value count at row 1 http://translate.google.lv Īsti nesapratu! Quote Link to comment Share on other sites More sharing options...
anonīms Posted February 13, 2010 Report Share Posted February 13, 2010 izmanto nevis insert into () bet gan ar value insert into (kollonas) values (dati) Quote Link to comment Share on other sites More sharing options...
2easy Posted February 13, 2010 Report Share Posted February 13, 2010 vai tu kādreiz pats esi rakstījis sql INSERT ? Quote Link to comment Share on other sites More sharing options...
kvesen Posted February 13, 2010 Author Report Share Posted February 13, 2010 Jāizskatās šādi ? VALUE INSERT INTO `ibf_members` (`id`, `name`, `mgroup`, `email`, `joined`, `ip_address`, `posts`, `title`, `allow_admin_mails`, `time_offset`, `hide_email`, `email_pm`, `email_full`, `skin`, `warn_level`, `warn_lastwarn`, `language`, `last_post`, `restrict_post`, `view_sigs`, `view_img`, `view_avs`, `view_pop`, `bday_day`, `bday_month`, `bday_year`, `new_msg`, `msg_total`, `show_popup`, `misc`, `last_visit`, `last_activity`, `dst_in_use`, `view_prefs`, `coppa_user`, `mod_posts`, `auto_track`, `temp_ban`, `sub_end`, `login_anonymous`, `ignored_users`, `mgroup_others`, `org_perm_id`, `member_login_key`, `member_login_key_expire`, `subs_pkg_chosen`, `has_blog`, `has_gallery`, `members_markers`, `members_editor_choice`, `members_auto_dst`, `members_display_name`, `members_created_remote`, `members_cache`, `members_disable_pm`, `members_l_display_name`, `members_l_username`, `failed_logins`, `failed_login_count`, `members_profile_views`, `d22shoutbox_banned`, `d22shoutbox_banned_by`, `d22shoutbox_banned_date`, `d22shoutbox_my_prefs`) VALUES Quote Link to comment Share on other sites More sharing options...
2easy Posted February 13, 2010 Report Share Posted February 13, 2010 nē. kolonnu nosaukumu skaitam ir jāsakrīt ar vērtību skaitu izklausās loģiski ne? Quote Link to comment Share on other sites More sharing options...
anonīms Posted February 13, 2010 Report Share Posted February 13, 2010 (edited) grūti tantei paprasīt? http://dev.mysql.com/doc/refman/5.1/en/insert.html un nē, tā nav jāizskatās. apmēram tā: INSERT INTO `ibf_members` (`id`, `name`, `mgroup`, `email`, `joined`) VALUES ('131314141', 'kakasmaka', 'hzkote', 'navpasts@com.lv','12314141') Edited February 13, 2010 by anonīms Quote Link to comment Share on other sites More sharing options...
kvesen Posted February 13, 2010 Author Report Share Posted February 13, 2010 (edited) Piemēram pirms lietotajiem VALUES (1, 'kvesen_', 4, 'admin@creekz.lv', 1261330177, '87.110.201.54', 160, 'Administrator', NULL, NULL, NULL, 1, NULL, 2, NULL, 0, NULL, 1262625272, '0', 1, 1, 1, 1, NULL, NULL, NULL, 0, 12, 0, NULL, 1262599466, 1262626115, 0, '-1&-1', 0, '0', '0', '0', 0, '0&1', NULL, '', '', 'af23761b128fefc1ed45793fd3267e06', 1263231214, 0, 0, 0, NULL, 'std', 1, 'kvesen_', 0, 'a:1:{s:7:"friends";a:0:{}}', 0, 'kvesen_', 'kvesen_', '', 0, 48), (2, 'BounTy', 3, 'gunchester@inbox.lv', 1261330456, '87.110.201.54', 3, '', 1, '0', '1', 1, NULL, 0, 0, 0, 'en', 1262125543, '0', 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, NULL, 1263925374, 1263930523, 1, '-1&-1', 0, '0', '0', '0', 0, '0&1', NULL, ',3,', '', 'f11b4ac1035195df2d5c8307aace9f71', 1264535334, 0, 0, 0, NULL, 'std', 1, 'BounTy', 0, NULL, 0, 'bounty', 'bounty', ',1264186301-87.110.201.54,1264186306-87.110.201.54,1264186311-87.110.201.54,1264786594-87.110.201.54,1264786598-87.110.201.54,1264786602-87.110.201.54', 6, 44, 0, NULL, NULL, ''), Ir jābūt takā VALUES ? Edited February 13, 2010 by kvesen Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.