Google+

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Rezolvat Problema Subforums list
#1

Code:
1
2
3
4
5
6
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1146 - Table 'lastfrag_forum.mybb_mybb_settinggroups' doesn't exist
Query:
    INSERT INTO mybb_mybb_settinggroups (`gid`,`title`,`name`,`description`,`disporder`,`isdefault`) VALUES ('NULL','Subforums in columns','Subforums in columns','Settings for Subforums in columns.','3','no') 


Cum pot rezolva?

#2
Ce ai facut ca sa iti dea erroarea asta?
[Image: logo1.png]
#3
Mergi in phpmyadmin si verifica daca ai tabelul ala creat.

daca nu il ai ruleaza urmatorul query ca sa il creezi

Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
CREATE TABLE `mybb_settinggroups` (
  `gid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `title` varchar(220) NOT NULL default '',
  `description` text NOT NULL,
  `disporder` smallint(5) unsigned NOT NULL default '0',
  `isdefault` int(1) NOT NULL default '0',
  PRIMARY KEY  (`gid`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;

-- 
-- Dumping data for table `mybb_settinggroups`
-- 

INSERT INTO `mybb_settinggroups` VALUES (1, 'calendar', 'Calendar', 'The board calendar allows the public and private listing of events and members'' birthdays. This section allows you to control and manage the settings for the Calendar.', 14, 1);
INSERT INTO `mybb_settinggroups` VALUES (2, 'clickablecode', 'Clickable Smilies and BB Code', 'This section allows you to change how the clickable smilies inserter appears.', 20, 1);
INSERT INTO `mybb_settinggroups` VALUES (3, 'cpprefs', 'Control Panel Preferences (Global)', 'This section allows you to set the global preferences for the Admin Control Panel.', 21, 1);
INSERT INTO `mybb_settinggroups` VALUES (4, 'datetime', 'Date and Time Formats', 'Here you can specify the different date and time formats used to display dates and times on the forums.', 4, 1);
INSERT INTO `mybb_settinggroups` VALUES (5, 'forumdisplay', 'Forum Display Options', 'This section allows you to manage the various settings used on the forum display (forumdisplay.php) of your boards such as enabling and disabling different features.', 6, 1);
INSERT INTO `mybb_settinggroups` VALUES (6, 'forumhome', 'Forum Home Options', 'This section allows you to manage the various settings used on the forum home (index.php) of your boards such as enabling and disabling different features.', 5, 1);
INSERT INTO `mybb_settinggroups` VALUES (7, 'general', 'General Configuration', 'This section contains various settings such as your board name and url, as well as your website name and url.', 2, 1);
INSERT INTO `mybb_settinggroups` VALUES (8, 'mailsettings', 'Mail Settings', 'This section allows you to control various aspects of the MyBB mail system, such as sending with PHP mail or with a off server SMTP server.', 22, 1);
INSERT INTO `mybb_settinggroups` VALUES (9, 'member', 'User Registration and Profile Options', 'Here you can control various settings with relation to user account registration and account management.', 8, 1);
INSERT INTO `mybb_settinggroups` VALUES (10, 'memberlist', 'Member List', 'This section allows you to control various aspects of the board member listing (memberlist.php), such as how many members to show per page, and which features to enable or disable.', 10, 1);
INSERT INTO `mybb_settinggroups` VALUES (11, 'onlineoffline', 'Board Online / Offline', 'These settings allow you to globally turn your forums online or offline, and allow you to specify a reason for turning them off.', 1, 1);
INSERT INTO `mybb_settinggroups` VALUES (12, 'portal', 'Portal Settings', 'The portal page compiles several different pieces of information about your forum, including latest posts, who''s online, forum stats, announcements, and more. This section has settings to control the aspects of the portal page (portal.php).', 17, 1);
INSERT INTO `mybb_settinggroups` VALUES (13, 'posting', 'Posting', 'These options control the various elements in relation to posting messages on the forums.', 9, 1);
INSERT INTO `mybb_settinggroups` VALUES (14, 'privatemessaging', 'Private Messaging', 'Various options with relation to the MyBB Private Messaging system (private.php) can be managed and set here.', 13, 1);
INSERT INTO `mybb_settinggroups` VALUES (15, 'reputation', 'Reputation', 'The reputation system allows your users to rate others and leave a comment on the user. This section has settings to disable and change other aspects of the reputation page (reputation.php).', 10, 1);
INSERT INTO `mybb_settinggroups` VALUES (16, 'search', 'Search System', 'The various settings in this group allow you to make changes to the built in search mechanism for threads and posts in MyBB.', 18, 1);
INSERT INTO `mybb_settinggroups` VALUES (17, 'server', 'Server and Optimization Options', 'These options allow you to set various server and optimization preferences allowing you to reduce the load on your server, and gain better performance on your board.', 3, 1);
INSERT INTO `mybb_settinggroups` VALUES (18, 'showthread', 'Show Thread Options', 'This section allows you to manage the various settings used on the thread display page (showthread.php) of your boards such as enabling and disabling different features.', 7, 1);
INSERT INTO `mybb_settinggroups` VALUES (19, 'warning', 'Warning System Settings', 'The warning system allows forum staff to warn users for rule violations. Here you can manage the settings that control the warning system.', 11, 1);
INSERT INTO `mybb_settinggroups` VALUES (20, 'whosonline', 'Who''s Online', 'Various settings regarding the Who is Online functionality.', 15, 1);
INSERT INTO `mybb_settinggroups` VALUES (21, 'userpruning', 'User Pruning', 'User Pruning allows you to remove users from your forum meeting certain criteria. Here you can configure that criteria.', 16, 1);
        


atentie insa la prefixul pe care l-ai setat atunci cand ai instalat mybb-ul
codul de mai sus o sa iti creezi tabelul mybb_settinggroups, daca ai setat alt prefix decat cel defaul atunci cand ai instalat mybb-ul schimba "mybb" su prefixul setat de tine la instalare.
sper sa te descuri.

nu inteleg insa cum s-a ajuns la eroarea asta.



Forum Jump:


Users browsing this thread: 1 Guest(s)