MyBB Community Forums

Full Version: Users cannot access usercp due to warning system problems
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
Hey i get this error everytime i try to warn someone

http://cricketlife.net/warnings.php?acti...n&uid=1037

Also people that have already been warned before cannot access their usercp anymore. Can anyone give me the mysql script to fix the missing table.
Can anyone help me out with this
criclover, that link will only work for people registered on your forum who have warning permissions.

Try taking a screenshot and uploading it for us.
This is what it says

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'cricketl_db.clmsd_warninglevels' doesn't exist
Query:
SELECT * FROM clmsd_warninglevels
CREATE TABLE clmsd_warninglevels (
	lid int unsigned NOT NULL auto_increment,
	percentage int(3) NOT NULL default '0',
	action text NOT NULL,
	PRIMARY KEY (lid)
) ENGINE=MyISAM;
I did run that but now i get this:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'cricketl_db.clmsd_warningtypes' doesn't exist
Query:
SELECT * FROM clmsd_warningtypes ORDER BY title

hey .m i still get the same error even after i used your updated code
can a developer of mybb help me out with this one.

BTW guys i need the sql code to enter into phpmyadmin to create the missing tables

Can a developer please help me out with this one
Is there anyone that knows anythingh about this issue i still get this error:


MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'cricketl_db.clmsd_warningtypes' doesn't exist
Query:
SELECT * FROM clmsd_warningtypes ORDER BY title

i need the sql code to enter into phpmyadmin to create the missing tables
if it is warningtypes table
CREATE TABLE `clmsd_warningtypes` (
  `tid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(120) NOT NULL DEFAULT '',
  `points` int(10) unsigned NOT NULL DEFAULT '0',
  `expirationtime` bigint(30) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
(2013-05-04, 05:18 PM)criclover Wrote: [ -> ]Is there anyone that knows anythingh about this issue i still get this error:


MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'cricketl_db.clmsd_warningtypes' doesn't exist
Query:
SELECT * FROM clmsd_warningtypes ORDER BY title

i need the sql code to enter into phpmyadmin to create the missing tables
it would appear you have some tables missing .. you could use phpmyadmin to create them example the warningtypes table

1 tid int(10) UNSIGNED No None AUTO_INCREMENT
2 title varchar(120) utf8_general_ci No
3 points int(10) UNSIGNED No 0
4 expirationtime bigint(30) No 0

however do you have a backup you can use to restore the missing tables ?
Pages: 1 2