Welcome, Guest |
You have to register before you can post on our site.
|
Forum Statistics |
» Members: 133,793
» Latest member: matt6950
» Forum threads: 176,943
» Forum posts: 1,239,679
Full Statistics
|
|
|
SQL Error when adding forum |
Posted by: Eric - 2010-08-07, 12:57 AM - Forum: 1.6 General Support
- Replies (9)
|
|
I get this when I try to create a new forum on my website (As in a new Forum under a Category).
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'allowvideocode' in 'field list'
Query:
INSERT INTO mybb_forums (name ,description ,linkto ,type ,pid ,parentlist ,disporder ,active ,open ,allowhtml ,allowmycode ,allowsmilies ,allowimgcode ,allowvideocode ,allowpicons ,allowtratings ,usepostcounts ,password ,showinjump ,modposts ,modthreads ,mod_edit_posts ,modattachments ,style ,overridestyle ,rulestype ,rulestitle ,rules ,defaultdatecut ,defaultsortby ,defaultsortorder ) VALUES ('Diamond and Pearl Discussion','Discuss the 4th Generation of Pokemon here.','','f','5','','1','1','1','0','1','1','1','1','1','1','1','','1','0','0','0','0','0','0','0','','','0','','')
|
|
|
Templates don't save |
Posted by: Riad C. - 2010-08-06, 10:50 PM - Forum: 1.6 General Support
- Replies (7)
|
|
I'm trying to update my templates, every time I press save, I then go de-activate a plug in and activate, check back, the templates not saved... I'm trying to configure my tabbed menu.
I just got it working after 3 times, but still a small problem.
|
|
|
what happened to my forum? get a giant block of code when i try to access it |
Posted by: ilovethrees - 2010-08-06, 08:01 PM - Forum: 1.6 General Support
- Replies (5)
|
|
when i try to access my forum, i just get a page with this giant block of code
// Get the announcements if the forum is not a category. if($forum['type'] == 'f') { $sql = build_parent_list($forum['fid'], "fid", "OR", $forum['parentlist']); $time = TIME_NOW; $query = $db->simple_select("announcements", "*", "startdate < '{$time}' AND (enddate > '{$time}' OR enddate=0) AND ({$sql} OR fid='-1')"); if($db->num_rows($query) > 0) { echo "
\n"; echo "
{$lang->forumbit_announcements}
"; echo "
\n"; while($announcement = $db->fetch_array($query)) { echo "
".htmlspecialchars_uni($announcement['subject'])."
"; } echo "
\n
\n"; } } // Get the stickies if the forum is not a category. if($forum['type'] == 'f') { $options = array( 'order_by' => 'sticky, lastpost', 'order_dir' => 'desc', 'limit_start' => $start, 'limit' => $perpage ); $query = $db->simple_select("threads", "*", "fid='{$id}' AND visible='1' AND sticky='1' AND closed NOT LIKE 'moved|%'", $options); if($db->num_rows($query) > 0) { echo "
\n"; echo "
{$lang->forumbit_stickies}
"; echo "
\n"; while($sticky = $db->fetch_array($query)) { $sticky['subject'] = htmlspecialchars_uni($parser->parse_badwords($sticky['subject'])); if($sticky['replies'] != 1) { $lang_reply_text = $lang->archive_replies; } else { $lang_reply_text = $lang->archive_reply; } $plugins->run_hooks("archive_forum_thread"); echo "
{$sticky['subject']}"; echo " ({$sticky['replies']} {$lang_reply_text})
"; } echo "
\n
\n"; } } // Get the threads if the forum is not a category. if($forum['type'] == 'f') { $options = array( 'order_by' => 'sticky, lastpost', 'order_dir' => 'desc', 'limit_start' => $start, 'limit' => $perpage ); $query = $db->simple_select("threads", "*", "fid='{$id}' AND visible='1' AND sticky='0' AND closed NOT LIKE 'moved|%'", $options); if($db->num_rows($query) > 0) { echo "
\n"; echo "
{$lang->forumbit_threads}
"; echo "
\n"; while($thread = $db->fetch_array($query)) { $thread['subject'] = htmlspecialchars_uni($parser->parse_badwords($thread['subject'])); if($thread['replies'] != 1) { $lang_reply_text = $lang->archive_replies; } else { $lang_reply_text = $lang->archive_reply; } $plugins->run_hooks("archive_forum_thread"); echo "
{$thread['subject']}"; echo " ({$thread['replies']} {$lang_reply_text})
"; } echo "
\n
\n"; } } echo "\n"; archive_multipage($threadcount, $perpage, $page, "{$base_url}forum-$id"); $plugins->run_hooks("archive_forum_end"); archive_footer(); break; // Display the board home. case "index": // Build our forum listing $forums = build_archive_forumbits(0); archive_header("", $mybb->settings['bbname_orig'], $mybb->settings['bburl']."/index.php"); $plugins->run_hooks("archive_index_start"); echo "
\n
{$mybb->settings['bbname']}
\n
\n
\n"; echo $forums; echo "\n
\n
\n
"; $plugins->run_hooks("archive_index_end"); archive_footer(); break; default: header("HTTP/1.0 404 Not Found"); echo $lang->archive_not_found; } $plugins->run_hooks("archive_end"); /** * Gets a list of forums and possibly subforums. * * @param int The parent forum to get the childforums for. * @return array Array of information regarding the child forums of this parent forum */ function build_archive_forumbits($pid=0) { global $db, $forumpermissions, $mybb, $lang, $archiveurl, $base_url; // Sort out the forum cache first. static $fcache; if(!is_array($fcache)) { // Fetch forums $query = $db->simple_select("forums", "*", "active!=0 AND password=''", array('order_by' =>'pid, disporder')); while($forum = $db->fetch_array($query)) { $fcache[$forum['pid']][$forum['disporder']][$forum['fid']] = $forum; } $forumpermissions = forum_permissions(); } // Start the process. if(is_array($fcache[$pid])) { foreach($fcache[$pid] as $key => $main) { foreach($main as $key => $forum) { $perms = $forumpermissions[$forum['fid']]; if(($perms['canview'] == 1 || $mybb->settings['hideprivateforums'] == 0) && $forum['active'] != 0) { if($forum['linkto']) { $forums .= "
{$forum['name']}"; } elseif($forum['type'] == "c") { $forums .= "
{$forum['name']}"; } else { $forums .= "
{$forum['name']}"; } if($fcache[$forum['fid']]) { $forums .= "\n
\n"; $forums .= build_archive_forumbits($forum['fid']); $forums .= "
\n"; } $forums .= "
\n"; } } } } return $forums; } ?>ast_post
any idea whats going on here?
|
|
|
Query |
Posted by: Janota - 2010-08-06, 07:48 PM - Forum: 1.6 General Support
- Replies (2)
|
|
Is there a query that we can run to set everyone to automatically receive a email when they receive a private message ?
|
|
|
|