MyBB Community Forums

Full Version: Hello, I have got an problems with my forums.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi all.

I have bought the old GFX-Depot and also translated it to an VB forums at: GFX-DEPOT/VB/

This forums are made in 2007 - 2008 and are been down for a while.

Now I have reopen it and people are posting in it again.

But as Admin and Owner I got this error message each time I try to post an post are answer or post in the MYBB forums:

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1146 - Table 'sebaldus68.mybb_mybb_threads' doesn't exist
Query:
SELECT * FROM mybb_mybb_threads WHERE lastposteruid='1' AND tid='1777' LIMIT 1
Please contact the MyBB Group for support.


Can you please help me out with this big issue?

Thanks in Advance from Sebaldus
Hello sebaldus,
This part looks wrong ' mybb_mybb_threads ' unless you have an unusual name for your db tables.

1) Check your inc/config.php and see what it says here:
$config['database']['table_prefix'] = 'mybb_';
2) Check the database and see what the actual table names are.


(2010-10-24, 06:07 AM)seeker Wrote: [ -> ]Hello sebaldus,
This part looks wrong ' mybb_mybb_threads ' unless you have an unusual name for your db tables.

1) Check your inc/config.php and see what it says here:
$config['database']['table_prefix'] = 'mybb_';
2) Check the database and see what the actual table names are.

Hi again and thanks for quick answer.

Here are what the config.php says:
<?php
/**
 * Database configuration
 *
 * Please see the MyBB Wiki for advanced
 * database configuration for larger installations
 * http://wiki.mybboard.net/
 */

$config['database']['type'] = 'mysql';
$config['database']['database'] = 'sebaldus68';
$config['database']['table_prefix'] = 'mybb_';

$config['database']['hostname'] = 'mysql1085.servage.net';
$config['database']['username'] = 'sebaldus68';
$config['database']['password'] = '********';

/**
 * Admin CP directory
 *  For security reasons, it is recommended you
 *  rename your Admin CP directory. You then need
 *  to adjust the value below to point to the
 *  new directory.
 */

$config['admin_dir'] = 'admin';

/**
 * Hide all Admin CP links
 *  If you wish to hide all Admin CP links
 *  on the front end of the board after
 *  renaming your Admin CP directory, set this
 *  to 1.
 */

$config['hide_admin_links'] = 0;

/**
 * Data-cache configuration
 *  The data cache is a temporary cache
 *  of the most commonly accessed data in MyBB.
 *  By default, the database is used to store this data.
 *
 *  If you wish to use the file system (cache/ directory)
 *  you can change the value below to 'files', 'memcache' or 'eaccelerator' from 'db'.
 */

$config['cache_store'] = 'db';

/**
 * Memcache configuration
 *  If you are using memcache as your data-cache,
 *  you need to configure the hostname and port
 *  of your memcache server below.
 *
 * If not using memcache, ignore this section.
 */

$config['memcache_host'] = 'localhost';
$config['memcache_port'] = 11211;

/**
 * Super Administrators
 *  A comma separated list of user IDs who cannot
 *  be edited, deleted or banned in the Admin CP.
 *  The administrator permissions for these users
 *  cannot be altered either.
 */

$config['super_admins'] = '1';

/**
 * Database Encoding
 *  If you wish to set an encoding for MyBB uncomment 
 *  the line below (if it isn't already) and change
 *  the current value to the mysql charset:
 *  http://dev.mysql.com/doc/refman/5.1/en/charset-mysql.html
 */

 // $config['database']['encoding'] = 'utf8';

/**
 * Automatic Log Pruning
 *  The MyBB task system can automatically prune
 *  various log files created by MyBB.
 *  To enable this functionality for the logs below, set the
 *  the number of days before each log should be pruned.
 *  If you set the value to 0, the logs will not be pruned.
 */

$config['log_pruning'] = array(
	'admin_logs' => 365, // Administrator logs
	'mod_logs' => 0, // Moderator logs
	'task_logs' => 30, // Scheduled task logs
	'mail_logs' => 180, // Mail error logs
	'user_mail_logs' => 180, // User mail logs
	'promotion_logs' => 180 // Promotion logs
);

?>

I also have translated my myBB forums to an vBulletin forums with an redirect script.

This forums was created in 2007-08 and have been down for a while.
I bought this domain and myBB forums and have translated it to an vB forums also using IMPEX on vB.

Both forums are running fine, people can register and post, but as Admin I can't post without that error message..Sad

I have had over 20 VBulletin forums and have my own Support forums for vB setup and technical support.

But have never used myBB before.

I just upgrade my myBB forums to the latest version.

But still the same error when I try to post or answer.

Both the database for myBB and vBulletin are in same SQL server.

My database in phpMyAdmin looks like this:

sebaldus68 (346) 
Sidenummer: 1


> >> 
•	 affiliates
•	 mybb_adminlog
•	 mybb_adminoptions
•	 mybb_adminsessions
•	 mybb_adminviews
•	 mybb_announcements
•	 mybb_attachments
•	 mybb_attachtypes
•	 mybb_awaitingactivation
•	 mybb_badwords
•	 mybb_banfilters
•	 mybb_banned
•	 mybb_calendarpermissions
•	 mybb_calendars
•	 mybb_captcha
•	 mybb_datacache
•	 mybb_dbarc
•	 mybb_emods
•	 mybb_events
•	 mybb_forumpermissions
•	 mybb_forums
•	 mybb_forumsread
•	 mybb_forumsubscriptions
•	 mybb_groupleaders
•	 mybb_helpdocs
•	 mybb_helpsections
•	 mybb_icons
•	 mybb_joinrequests
•	 mybb_mailerrors
•	 mybb_maillogs
•	 mybb_mailqueue
•	 mybb_massemails
•	 mybb_moderatorlog
•	 mybb_moderators
•	 mybb_modtools
•	 mybb_mycode
•	 mybb_nars_backup
•	 mybb_pages
•	 mybb_pmarchive
•	 mybb_polls
•	 mybb_pollvotes
•	 mybb_posts
•	 mybb_privatemessages
•	 mybb_profilefields
•	 mybb_promotionlogs
•	 mybb_promotions
•	 mybb_regimages
•	 mybb_reportedposts
•	 mybb_reputation
•	 mybb_searchlog
•	 mybb_sessions
•	 mybb_settinggroups
•	 mybb_settings
•	 mybb_shouts
•	 mybb_smilies
•	 mybb_spiders
•	 mybb_stats
•	 mybb_tasklog
•	 mybb_tasks
•	 mybb_td_backup
•	 mybb_templategroups
•	 mybb_templates
•	 mybb_templatesets
•	 mybb_themes
•	 mybb_themestylesheets
•	 mybb_threadratings
•	 mybb_threads
•	 mybb_threadsread
•	 mybb_threadsubscriptions
•	 mybb_threadviews
•	 mybb_thx
•	 mybb_upgrade_data
•	 mybb_userfields
•	 mybb_usergroups
•	 mybb_users
•	 mybb_usertitles
•	 mybb_warninglevels
•	 mybb_warnings
•	 mybb_warningtypes
•	 vb_access
•	 vb_action
•	 vb_ad
•	 vb_adcriteria
•	 vb_adminhelp
•	 vb_administrator
•	 vb_adminlog
•	 vb_adminmessage
•	 vb_adminutil
•	 vb_album
•	 vb_albumupdate
•	 vb_announcement
•	 vb_announcementread
•	 vb_attachment
•	 vb_attachmentcategory
•	 vb_attachmentcategoryuser
•	 vb_attachmentpermission
•	 vb_attachmenttype
•	 vb_attachmentviews
•	 vb_avatar
•	 vb_badwords
•	 vb_bbcode
•	 vb_bbcode_video
•	 vb_block
•	 vb_blockconfig
•	 vb_blocktype
•	 vb_blog
•	 vb_blog_attachment
•	 vb_blog_attachmentlegacy
•	 vb_blog_attachmentviews
•	 vb_blog_category
•	 vb_blog_categorypermission
•	 vb_blog_categoryuser
•	 vb_blog_custom_block
•	 vb_blog_custom_block_parsed
•	 vb_blog_deletionlog
•	 vb_blog_editlog
•	 vb_blog_featured
•	 vb_blog_groupmembership
•	 vb_blog_grouppermission
•	 vb_blog_hash
•	 vb_blog_moderation
•	 vb_blog_moderator
•	 vb_blog_pinghistory
•	 vb_blog_rate
•	 vb_blog_read
•	 vb_blog_relationship
•	 vb_blog_search
•	 vb_blog_searchresult
•	 vb_blog_subscribeentry
•	 vb_blog_subscribeuser
•	 vb_blog_summarystats
•	 vb_blog_tachyentry
•	 vb_blog_text
•	 vb_blog_textparsed
•	 vb_blog_trackback
•	 vb_blog_trackbacklog
•	 vb_blog_user
•	 vb_blog_usercss
•	 vb_blog_usercsscache
•	 vb_blog_userread
•	 vb_blog_userstats
•	 vb_blog_views
•	 vb_blog_visitor
•	 vb_bookmarksite
•	 vb_cache
•	 vb_cacheevent
•	 vb_calendar
•	 vb_calendarcustomfield
•	 vb_calendarmoderator
•	 vb_calendarpermission
•	 vb_cms_article
•	 vb_cms_category
•	 vb_cms_grid
•	 vb_cms_layout
•	 vb_cms_layoutwidget
•	 vb_cms_navigation
•	 vb_cms_node
•	 vb_cms_nodecategory
•	 vb_cms_nodeconfig
•	 vb_cms_nodeinfo
•	 vb_cms_permissions
•	 vb_cms_rate
•	 vb_cms_sectionorder
•	 vb_cms_widget
•	 vb_cms_widgetconfig
•	 vb_cms_widgettype
•	 vb_contentpriority
•	 vb_contenttype
•	 vb_cpsession
•	 vb_cron
•	 vb_cronlog
•	 vb_customavatar
•	 vb_customprofilepic
•	 vb_datastore
•	 vb_deletionlog
•	 vb_digitalpoint_spy
•	 vb_discussion
•	 vb_discussionread
•	 vb_editlog
•	 vb_event
•	 vb_externalcache
•	 vb_faq
•	 vb_filedata
•	 vb_forum
•	 vb_forumpermission
•	 vb_forumprefixset
•	 vb_forumread
•	 vb_games_cats
•	 vb_games_champs
•	 vb_games_league
•	 vb_games_list
•	 vb_games_savedGames
•	 vb_games_scores
•	 vb_games_session
•	 vb_games_settings
•	 vb_groupmessage
•	 vb_groupmessage_hash
•	 vb_groupread
•	 vb_holiday
•	 vb_humanverify
•	 vb_hvanswer
•	 vb_hvquestion
•	 vb_icon
•	 vb_imagecategory
•	 vb_imagecategorypermission
•	 vb_impexerror
•	 vb_indexqueue
•	 vb_infraction
•	 vb_infractionban
•	 vb_infractiongroup
•	 vb_infractionlevel
•	 vb_language
•	 vb_linkback
•	 vb_macro
•	 vb_mailqueue
•	 vb_media
•	 vb_media_category
•	 vb_microclassifieds_categories
•	 vb_microclassifieds_items
•	 vb_microclassifieds_item_files
•	 vb_microclassifieds_item_hits
•	 vb_microclassifieds_item_payments
•	 vb_microclassifieds_item_photos
•	 vb_microclassifieds_item_shipping
•	 vb_moderation
•	 vb_moderator
•	 vb_moderatorlog
•	 vb_notice
•	 vb_noticecriteria
•	 vb_noticedismissed
•	 vb_package
•	 vb_passwordhistory
•	 vb_paymentapi
•	 vb_paymentinfo
•	 vb_paymenttransaction
•	 vb_phrase
•	 vb_phrasetype
•	 vb_picturecomment
•	 vb_picturecomment_hash
•	 vb_picturelegacy
•	 vb_plugin
•	 vb_pm
•	 vb_pmreceipt
•	 vb_pmtext
•	 vb_pmthrottle
•	 vb_podcast
•	 vb_podcastitem
•	 vb_poll
•	 vb_pollvote
•	 vb_post
Sidenummer:1.

Here are screenshots from mysql:
MYSQL

Thanks in Advance from Sebaldus
1) This:
$config['database']['table_prefix'] = 'mybb_';
is 'normal', and this:
SQL Error:
1146 - Table 'sebaldus68.mybb_mybb_threads' doesn't exist
is clearly looking for the prefix to be
mybb_mybb_

2)
  • Only the admin account is seeing the errors.

##
One of your active plugins, related to usergroup / admin actions / perms,
(i.e. A plugin which allows you to set...
"Some action___ or permission____ for admingroup only")

Lightbulb

One of your active plugins...
Is adding an extra 'mybb_' to the table prefix during a query.

^^^
Somewhere in the above mess, you probably have ~75 to 99% of the exact issue described in detail.

Step-by-Step to fix:
1) Use the above "clues", and figure it out. Toungue

// It's fixable, let me know how it works out  :o)
Most likely cause is having plugins running that were made for MyBB 1.2, judging by the age of the forum.
(2010-10-24, 10:48 AM)MattRogowski Wrote: [ -> ]Most likely cause is having plugins running that were made for MyBB 1.2, judging by the age of the forum.
Hi and thanks both of you.

Is it possible to close plugins just add an sentence as I use to do in config.php on my vBulletin bords?

Can I easy add this to the config,php ? <?php
define('DISABLE_HOOKS', true);

Will it works on myBB?

Or is it another way to disable plugins?
My board are upgrade to latest version, but not sure if all plugins are?

Have also problems with smilyes.

Is it possible to ask for payed support here?
Best Regards from Sebaldus
There's no paid support here, but you wouldn't get answers any quicker anyway. If we're available to give support, we're on these forums anyway.

You can put this in ./inc/init.php:

define("NO_PLUGINS", 1);

You'll be able to see the compatibility of plugins in the files themselves. What version are you actually running now??
Moved to General Support as this is not a problem with the merge system. Smile