• 05-08-2008, 01:16:18
    #1
    Bu hata neden olabilir.. Versionu 3.5.x 'den 3.6.7 'e aldık herşey çalışıyor ancak kullanıcı grubu vs. eklerken bu tip bir hata veriyor.

    Database error in vBulletin 3.6.7:
    
    Invalid SQL:
    
    ### INSERT QUERY GENERATED BY fetch_query_sql() ###
    INSERT INTO usergroup
    	(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions2`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`, `albumpermissions`, `albumpicmaxwidth`, `albumpicmaxheight`, `albumpicmaxsize`, `albummaxpics`, `albummaxsize`, `usercsspermissions`, `visitormessagepermissions`, `socialgrouppermissions`)
    VALUES
    	('Bayan Üye 1', '', 'Bayan Üye 1', '<b><font color=\"magenta\">', '<b></font>', '0', '0', '0', '0', '786423', '268967811', '1000000', '50', '3', '2', '0', '5', '0', '0', '46', '200', '200', '250000', '150', '150', '200000', '172031', '500', '100', '20000', '1000', '500', '0', '7', '0', '0', '', '', '', '', '', '0', '0', '0');
    
    MySQL Error  : Unknown column 'genericpermissions2' in 'field list'
    Error Number : 1054
    Date         : Tuesday, August 5th 2008 @ 12:11:55 AM
    Script       : http://www.domain.com/admincp/usergroup.php?do=update
    Referrer     : http://www.domain.com/admincp/usergroup.php?do=add
    IP Address   : 88.231.251.15
    Username     : VolkaN
    Classname    : vB_Database
  • 05-08-2008, 16:48:24
    #2
    ALTER  TABLE  `usergroup` ADD `genericpermissions2` int(10) unsigned NOT NULL default '0';
  • 06-08-2008, 00:44:34
    #3
    anlamadım ne demek istediğini tespara
  • 06-08-2008, 01:15:42
    #4
    Kurumsal Üye
    Diyor ki;

    Phpmyadmin'e gir ve aşağıdaki sorguyu çalıştır ;
      ALTER  TABLE  `usergroup` ADD `genericpermissions2` int(10) unsigned NOT NULL default '0';
  • 13-08-2008, 00:21:14
    #5
    Hata verdi sorguyu çalıştırdığımda.

    [b]Hata[/b]
    
    SQL sorgusu: 
    ALTER TABLE `usergroup` ADD `genericpermissions2` int( 10 ) unsigned NOT NULL default '0' 
    MySQL çıktısı: [IMG]http://www.eglence41.com:2082/3rdparty/phpMyAdmin/themes/original/img/b_help.png[/IMG] 
    #1060 - Duplicate column name 'genericpermissions2'