MyBB Hacks

MyBB Hacks > MyBB Plugins > XThreads > SQL Error when creating New Forums/ child forums
Full Version: SQL Error when creating New Forums/ child forums
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

jlynx

06-07-2014, 07:18 AM
Whenever i want to create a new Forum or child forum this error pops up -->  error 1364 Field 'xthreads_tplprefix' doesn't have a default value. Nothing i do wants to work. I searched the php files for xthreads_tplprefix database insert but found nothing. In the Xthreads options of creating the forums i add prefixes but still shows the same error. I'm using xthreads 1.63 and MyBB 1.6.13. Is this a bug or what ?

jlynx

06-07-2014, 05:34 PM
Here is the whole error

PHP Code: 
MyBB has experienced an internal SQL error and cannot
continue.
SQL Error:
1364 - Field 'xthreads_tplprefix' doesn't have a default value
Query:
INSERT INTO mybb_forums
(`name`,`description`,`linkto`,`type`,`pid`,`parentlist`,`disporder`
,`activ​e`,`open`,`allowhtml`,`allowmycode`,`allowsmilies`,`
allowimgcode`,`allowvideocod​
e`,`allowpicons`,`allowtratings`,`usepostcounts`,`password`,`
showinjump`,`modpos​ts`,`modthreads`,`mod_edit_
posts`,`modattachments`,`style`,`overridestyle`,`rule​
stype`,`rulestitle`,`rules`,`defaultdatecut`,`defaultsortby`,`
defaultsortorder`) VALUES (' Forum B
2','','','f','4','','2','1','1','0','1','1','1','1','1','1','1','','1','0','0','0','0','0','
0','0','','','0','','')

the only place i see of a 'xthreads_tplprefix' database query is
in, inc/xthreads/xt_upgrader.php . But i'm nowhere near an
upgrade of any kind.

PHP Code: 
> line 108:
$db->write_query('ALTER TABLE `'.$db->table_
prefix.'forums` MODIFY `xthreads_tplprefix` varchar(255) not
null default ""');
> line 136:
$db->write_query('ALTER TABLE `'.$db->table_
prefix.'forums` MODIFY `xthreads_tplprefix` text not null');

the only place i see of a 'xthreads_tplprefix' database query is
in, inc/xthreads/xt_upgrader.php . But i'm nowhere near an
upgrade of any kind.

PHP Code: 
> line 108:
$db->write_query('ALTER TABLE `'.$db->table_
prefix.'forums` MODIFY `xthreads_tplprefix` varchar(255) not
null default ""');
> line 136:
$db->write_query('ALTER TABLE `'.$db->table_
prefix.'forums` MODIFY `xthreads_tplprefix` text not null');

jlynx

06-07-2014, 06:39 PM
or is there any way of setting a default value in a php file somewhere so the error can go away ? I reinstalled mybb with xthreads about 20 times now

jlynx

06-07-2014, 08:02 PM
thank GOD! i finally managed to fix this error !

PHP Code: 
// in inc/xthreads/xt_install.php i removed all sql queries like this:
'tplprefix' => 'text not null',
'langprefix' => 'text not null',
'defaultfilter' => 'text not null',

// Then replaced that with this:
'tplprefix' => 'varchar(255) default \'\'',
'langprefix' => 'varchar(255) default \'\'',
'defaultfilter' => 'varchar(255) default \'\'',


Now i can create forums again.

ZiNgA BuRgA

06-09-2014, 10:48 AM
Does MyBB work with MySQL under strict mode now?
It didn't used to (well, after 1.2.x), so I never bothered doing the same.

terzier

08-06-2016, 06:45 PM
I also experienced the same thing. mybb I used version 1.8.
Yumi please help.

nier3

05-26-2018, 11:18 AM
Hi, I have this problem, I tried to change in 'varchar(255) default \'\'', file "xt_install.php" but nothing, always error when I try to add a new forum or category Frown

PHP Code: 
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1364 - Field 'xthreads_tplprefix' doesn't have a default value
Query:
INSERT INTO mybb_forums (`name`,`description`,`linkto`,`type`,`pid`,`parentlist`,`disporder`,`active`,`open`,`allowhtml`,`allowmycode`,`allowsmilies`,`allowimgcode`,`allowvideocode`,`allowpicons`,`allowtratings`,`usepostcounts`,`usethreadcounts`,`requireprefix`,`password`,`showinjump`,`style`,`overridestyle`,`rulestype`,`rulestitle`,`rules`,`defaultdatecut`,`defaultsortby`,`defaultsortorder`) VALUES ('xdfsds','','','f',1,'',2,1,1,1,1,1,1,1,1,1,1,1,0,'',1,0,0,0,'','',0,'','')


I have
MyBB Version 1.8.15
PHP Version 7.1.7
SQL Engine MySQLi 5.7.19

Maybe I have to re-install Xthreads plugin? Frown(((

Thank you

EDIT: I tried to deactivate, uninstall and install again xthreads on a forum test and yes, with new version of xt_install.php (with varchar) now I can add new forums.

The problem is if I uninstall xthreads on my main forum, with all data threads etc I will lost all Frown

Gil

11-20-2019, 07:11 PM
in phpMyAdmin, you can execute this SQL request to set the default values of these 4 fields.

Code: 
ALTER TABLE `mybb_forums` CHANGE `xthreads_tplprefix` `xthreads_tplprefix` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `mybb_forums` CHANGE `xthreads_langprefix` `xthreads_langprefix` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `mybb_forums` CHANGE `xthreads_settingoverrides` `xthreads_settingoverrides` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `mybb_forums` CHANGE `xthreads_defaultfilter` `xthreads_defaultfilter` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

Remark : Modify this request if your table is not in utf8...

blacksword

02-18-2022, 03:02 AM
that's great if you know where to go... in phpmyadmin I cant find the damn thing...
MyBB Hacks > MyBB Plugins > XThreads > SQL Error when creating New Forums/ child forums
Reference URL's