Bug Database error on forums changes

Status
Not open for further replies.

bosss

Customer
Database error on forums name changes

When i change something on my forums (name or descriptions) i get php and database errors (forums have vbforms) in my admincp - forum manager

error 1 -

PHP:
PHP Warning: mysqli_query(): (42S22/1054): Unknown column 'dbtech_dbforms_hideoptions' in 'field list' in ..../includes/class_core.php on line 1393

and after that database error in same window

PHP:
Database error in vBulletin 4.2.3 Beta 3:

Invalid SQL:
UPDATE forum SET
	title_clean = 'PRIJAVE 10/2014',
	title = 'PRIJAVE 10/2014',
	description_clean = '',
	description = '',
	link = '',
	displayorder = 1,
	parentid = 41,
	daysprune = -1,
	defaultsortfield = 'lastpost',
	defaultsortorder = 'desc',
	showprivate = 0,
	newpostemail = '',
	newthreademail = '',
	### Bitfield: forum.options ###
		options = IF(options & 8, options - 8, options),
		options = IF(options & 16, options - 16, options),
		options = IF(options & 32, options - 32, options),
		options = IF(options & 32768, options - 32768, options),
		options = IF(options & 8192, options, options + 8192),
		options = IF(options & 4, options, options + 4),
		options = IF(options & 1, options, options + 1),
		options = IF(options & 2, options, options + 2),
		options = IF(options & 16384, options, options + 16384),
		options = IF(options & 524288, options - 524288, options),
		options = IF(options & 256, options - 256, options),
		options = IF(options & 64, options, options + 64),
		options = IF(options & 128, options, options + 128),
		options = IF(options & 262144, options, options + 262144),
		options = IF(options & 512, options, options + 512),
		options = IF(options & 1024, options, options + 1024),
		options = IF(options & 2048, options, options + 2048),
		options = IF(options & 4096, options, options + 4096),
		options = IF(options & 65536, options, options + 65536),
		options = IF(options & 131072, options - 131072, options),
		options = IF(options & 1048576, options, options + 1048576),
		options = IF(options & 2097152, options, options + 2097152),
	styleid = 0,
	imageprefix = '',
	password = '',
	forumiconimg = '',
	dbtech_dbforms_defaultcategoryid = 0,
	dbtech_dbforms_hideoptions = 0,
	dbtech_dbforms_overrideform = 0,
	kirky_splash = '<span style=\"color: red; font-weight: bold; font-size: 20px;\">Pravila Turnira - Obavezno procitajte!</span>\r\n<br />\r\n<br />\r\n<span style=\"color: #f9ecb6; font-weight: bold; font-size: 16px;\">1. Svi prijavljeni parovi moraju biti registrirani na Libru i ne mogu igrati sa iste IP adrese .</span>\r\n<br />\r\n<span style=\"color: #f9ecb6; font-weight: bold; font-size: 16px;\">2. Svaki put drugi par otvara sobu .</span>\r\n<br />\r\n<span style=\"color: #f9ecb6; font-weight: bold; font-size: 16px;\">3. Nije dozvoljeno vrijedjanje suigraca i pozeljna je brza igra .</span>\r\n<br />\r\n<span style=\"color: #f9ecb6; font-weight: bold; font-size: 16px;\">4. Postujte tudje vrijeme .</span>\r\n<br />\r\n<span style=\"color: #f9ecb6; font-weight: bold; font-size: 16px;\">5. Nakon zavrsenog susreta obavezno je postanje rezultata .</span>\r\n<br />\r\n<br />\r\n<span style=\"color: #5ca028; font-weight: bold; font-size: 16px;\">U prvoj fazi turnira igraju se 4 partije ( pobjeda 3 boda - nerijeseno 1 bod ) . Igraci se mijesaju medjusobno ( rangiraju se po bodovima i score ) i dobijemo parove koji igraju u drugoj fazi Cup sistem na 3 dobijene partije ( pobjeda nosi 3 boda , score se takodjer uzima u obzir ) .</span>\r\n<br />\r\n<span style=\"color: #5ca028; font-weight: bold; font-size: 16px;\">Apelujemo na zdrav razum i takmicarski duh ( ipak je ovo igra , najvaznije je sudjelovati ) .</span>\r\n<br />\r\n<span style=\"color: #0096fd; font-weight: bold; font-size: 16px;\">Zelimo dobru zabavu svima .</span>',
	dbtech_vbanswers_show = 0
WHERE forumid = 42;

MySQL Error   : Unknown column 'dbtech_dbforms_hideoptions' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, December 3rd 2014 @ 02:37:19 AM
Error Date    : Wednesday, December 3rd 2014 @ 02:37:20 AM
Script        : http://www.mysite.com/forum/admincp/forum.php?do=update
Referrer      : http://www.mysite.com/forum/admincp/forum.php?do=edit&f=42&s=
IP Address    : xxxxxxxxxxx
Username      : Bosss
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.40-cll


Fillip H. please help - that is urgent

regards

bosss
 
Last edited:
Code:
ALTER TABLE forum ADD dbtech_dbforms_hideoptions TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'
 
Not help ....

execute query but still errors

PHP Warning: mysqli_query(): (42S22/1054): Unknown column 'dbtech_dbforms_overrideform' in 'field list' in ..../includes/class_core.php on line 1393


and database error

PHP:
Database error in vBulletin 4.2.3 Beta 3:

Invalid SQL:
UPDATE forum SET
	title_clean = 'PRIJAVE 10/2014',
	title = 'PRIJAVE 10/2014',
	description_clean = '',
	description = '',
	link = '',
	displayorder = 1,
	parentid = 41,
	daysprune = -1,
	defaultsortfield = 'lastpost',
	defaultsortorder = 'desc',
	showprivate = 0,
	newpostemail = '',
	newthreademail = '',
	### Bitfield: forum.options ###
		options = IF(options & 8, options - 8, options),
		options = IF(options & 16, options - 16, options),
		options = IF(options & 32, options - 32, options),
		options = IF(options & 32768, options - 32768, options),
		options = IF(options & 8192, options, options + 8192),
		options = IF(options & 4, options, options + 4),
		options = IF(options & 1, options, options + 1),
		options = IF(options & 2, options, options + 2),
		options = IF(options & 16384, options, options + 16384),
		options = IF(options & 524288, options - 524288, options),
		options = IF(options & 256, options - 256, options),
		options = IF(options & 64, options, options + 64),
		options = IF(options & 128, options, options + 128),
		options = IF(options & 262144, options, options + 262144),
		options = IF(options & 512, options, options + 512),
		options = IF(options & 1024, options, options + 1024),
		options = IF(options & 2048, options, options + 2048),
		options = IF(options & 4096, options, options + 4096),
		options = IF(options & 65536, options, options + 65536),
		options = IF(options & 131072, options - 131072, options),
		options = IF(options & 1048576, options, options + 1048576),
		options = IF(options & 2097152, options, options + 2097152),
	styleid = 0,
	imageprefix = '',
	password = '',
	forumiconimg = '',
	dbtech_dbforms_defaultcategoryid = 0,
	dbtech_dbforms_hideoptions = 0,
	dbtech_dbforms_overrideform = 0,
	kirky_splash = '<span style=\"color: red; font-weight: bold; font-size: 20px;\">Pravila Turnira - Obavezno procitajte!</span>\r\n<br />\r\n<br />\r\n<span style=\"color: #f9ecb6; font-weight: bold; font-size: 16px;\">1. Svi prijavljeni parovi moraju biti registrirani na Libru i ne mogu igrati sa iste IP adrese .</span>\r\n<br />\r\n<span style=\"color: #f9ecb6; font-weight: bold; font-size: 16px;\">2. Svaki put drugi par otvara sobu .</span>\r\n<br />\r\n<span style=\"color: #f9ecb6; font-weight: bold; font-size: 16px;\">3. Nije dozvoljeno vrijedjanje suigraca i pozeljna je brza igra .</span>\r\n<br />\r\n<span style=\"color: #f9ecb6; font-weight: bold; font-size: 16px;\">4. Postujte tudje vrijeme .</span>\r\n<br />\r\n<span style=\"color: #f9ecb6; font-weight: bold; font-size: 16px;\">5. Nakon zavrsenog susreta obavezno je postanje rezultata .</span>\r\n<br />\r\n<br />\r\n<span style=\"color: #5ca028; font-weight: bold; font-size: 16px;\">U prvoj fazi turnira igraju se 4 partije ( pobjeda 3 boda - nerijeseno 1 bod ) . Igraci se mijesaju medjusobno ( rangiraju se po bodovima i score ) i dobijemo parove koji igraju u drugoj fazi Cup sistem na 3 dobijene partije ( pobjeda nosi 3 boda , score se takodjer uzima u obzir ) .</span>\r\n<br />\r\n<span style=\"color: #5ca028; font-weight: bold; font-size: 16px;\">Apelujemo na zdrav razum i takmicarski duh ( ipak je ovo igra , najvaznije je sudjelovati ) .</span>\r\n<br />\r\n<span style=\"color: #0096fd; font-weight: bold; font-size: 16px;\">Zelimo dobru zabavu svima .</span>',
	dbtech_vbanswers_show = 0
WHERE forumid = 42;

MySQL Error   : Unknown column 'dbtech_dbforms_overrideform' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, December 3rd 2014 @ 10:06:07 AM
Error Date    : Wednesday, December 3rd 2014 @ 10:06:08 AM
Script        : http://www.mysite.com/forum/admincp/forum.php?do=update
Referrer      : http://www.mysite.com/forum/admincp/forum.php?do=edit&f=42&s=
IP Address    : xxxxxxxxxxxx
Username      : Bosss
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.40-cll

Fillip H. please some more help....

regards

bosss


must i also re-downloaded files and install product xml again?
 
Code:
ALTER TABLE forum ADD dbtech_dbforms_overrideform TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'
 
Status
Not open for further replies.

Legacy DragonByte vBForms

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
385
Customer rating
0.00 star(s) 0 ratings
Back
Top