��

�� · 12-03-2007, 05:16 PM

��
��

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE forum SET
title_clean = '�� ',
title = '�� ',
description_clean = '�� ',
description = '<img src=\"http://www.s55h.com/vb/images/a5.gif\">\r\n�� ',
link = '',
displayorder = 6,
parentid = 3,
daysprune = 30,
defaultsortfield = 'title',
defaultsortorder = 'asc',
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 - 8192, options),
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 & 256, options - 256, options),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options, options + 128),
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),
styleid = 0,
password = ''
WHERE forumid = 87;

MySQL Error : Unknown column 'defaultsortfield' in 'field list'
Error Number : 1054
Date : Monday, March 12th 2007 @ 06:08:23 PM
Script : http://www.al-kasser.com/vb/eig/forum.php?do=update
Referrer : http://www.al-kasser.com/vb/eig/foru...o=edit&f=87&s=
IP Address : 213.42.2.11
Username : UAE
Classname : vb_database

��

ahmed-samara · 12-03-2007, 06:16 PM

��
http://www.swalif.net/softs/showthre...77#post1378577
��

� �� · 12-03-2007, 06:17 PM

��

��

��:

ALTER TABLE forum ADD showprivate TINYINT UNSIGNED NOT NULL DEFAULT '0'

�� 1000

M� мostafa · 12-03-2007, 11:20 PM

��

�� PHP:

  ALTER TABLE `forum` ADD `defaultsortfield` VARCHAR( 50 ) NOT NULL DEFAULT 'LASTPOST';

�� PHP:

  ALTER TABLE `forum` ADD `defaultsortorder` ENUM( 'asc', 'desc' ) NOT NULL DEFAULT 'DESC';

�� PHP:

  ALTER TABLE `forum` ADD `showprivate` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0';