Welcome Guest [Log In] [Register]
We hope you enjoy your visit.

You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free.


Join our community!


If you're already a member please log in to your account to access all of our features:

Username:   Password:
Add Reply
MySQL Error for Forum Back-Up
Topic Started: Sep 4 2010, 04:22 AM (330 Views)
ali5541-ZNS
Member
 *  
Hello,

I purchased the SQL database from invisionfree so I can have a back-up of my site. I followed the directions clearly and installed IPB 1.3.

Quote:
 
Be sure you have a freshly installed IPB (v1.3.x) with the default mysql table prefix (ibf_).
Next empty the following tables on the fresh install (again make sure the install is using the prefix ibf_):
ibf_badwords
ibf_posts
ibf_calendar_events
ibf_categories
ibf_contacts
ibf_emoticons
ibf_forums
ibf_groups
ibf_members
ibf_messages
ibf_moderators
ibf_polls
ibf_stats
ibf_titles
ibf_topics
ibf_tracker
ibf_voters
ibf_cache_store
ibf_forum_perms
ibf_topic_mmod
ibf_validating;

or you can use these queries:


DELETE FROM ibf_badwords;
DELETE FROM ibf_posts;
DELETE FROM ibf_calendar_events;
DELETE FROM ibf_categories;
DELETE FROM ibf_contacts;
DELETE FROM ibf_emoticons;
DELETE FROM ibf_forums;
DELETE FROM ibf_groups;
DELETE FROM ibf_members;
DELETE FROM ibf_messages;
DELETE FROM ibf_moderators;
DELETE FROM ibf_polls;
DELETE FROM ibf_stats;
DELETE FROM ibf_titles;
DELETE FROM ibf_topics;
DELETE FROM ibf_tracker;
DELETE FROM ibf_voters;
DELETE FROM ibf_cache_store;
DELETE FROM ibf_forum_perms;
DELETE FROM ibf_topic_mmod;
DELETE FROM ibf_validating;


They cleared successfully and I begin the import, I repeated the process a few times via import and via query and got the same exact error. Can anyone help me with this? The error as is follows:

Quote:
 
SQL query:

INSERT IGNORE INTO ibf_forums (id, topics, posts, last_post, last_poster_id, last_poster_name, name, description, position, use_ibc, use_html, status, start_perms, reply_perms, read_perms, password, category, last_title, last_id, sort_key, sort_order, prune, show_rules, upload_perms, preview_posts, allow_poll, allow_pollbump, inc_postcount, parent_id, subwrap, sub_can_post, quick_reply, redirect_url, redirect_on, redirect_hits, redirect_loc, rules_title, rules_text, has_mod_posts, topic_mm_id, notify_modq_emails, checked) VALUES ('2','64','437','1282889431','125','Pollard','Applications','Make an application here.','1','1','0','1','31,26,27,28,34,40,1,38,47,56,30,57,32,59,61,64,65,68,72,73,74,76,10,79,58,80,81,33,82,83,4,2,36,84,85','31,26,27,28,34,40,1,38,47,56,30,57,32,59,61,64,65,68,72,73,74,76,10,79,58,80,81,33,82,83,4,2,36,84,85','31,26,27,28,34,40,1,38,47,56,30,57,32,59,61,64,65,68,72,73,74,76,10,79,58,80,81,33,82,83,4,2,36,84,85','','2','Peeka Boo!','1674','last_post','Z-A'[...]

MySQL said: Documentation
#1054 - Unknown column 'checked' in 'field list'


How do I solve this? I can provide a link to the SQL Database Dump Upon Request.

EDIT: Link to Forum
Edited by ali5541-ZNS, Sep 4 2010, 04:24 AM.
Offline Profile Quote Post Goto Top
 
Jonathan
Member Avatar


I'd recommend bumping the support ticket you submitted where you were provided your database back-up. Also, tell us what the name of the ticket was you originally submitted. :)

Jonathan
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · zIFBoards Support & Galleries · Next Topic »
Add Reply