bo...

**colin** · 06-09-2007, 17:14

Dove' l'errore??

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_plugins AS phrasegroup_plugins,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 16, user.languageid))

WHERE user.userid = 1;

MySQL Error : Unknown column 'language.phrasegroup_plugins' in 'field list'
Error Number : 1054

**colin** · 06-09-2007, 21:51

in sostanza mi servirebbe di aggiungere nella table "language" un altro campo cioe' "`phrasegroup_plugins`"

**y2ksw** · 06-09-2007, 21:55

yup

**colin** · 06-09-2007, 22:03

manca nella table del mio forum e' mi da l'errore

`phrasegroup_forumdisplay` mediumtext,
`phrasegroup_messaging` mediumtext,
`phrasegroup_inlinemod` mediumtext,
`phrasegroup_plugins` mediumtext,
`phrasegroup_cprofilefield` mediumtext,
`phrasegroup_reputationlevel` mediumtext,
`phrasegroup_infraction` mediumtext,
`phrasegroup_infractionlevel` mediumtext,
PRIMARY KEY (`languageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dump dei dati per la tabella `language`
--

INSERT INTO `language` (`languageid`, `title`, `userselect`, `options`, `languagecode`, `charset`, `imagesoverride`, `dateoverride`, `timeoverride`, `registereddateoverride`, `calformat1override`, `calformat2override`, `logdateoverride`, `locale`, `decimalsep`, `thousandsep`, `phrasegroup_global`, `phrasegroup_cpglobal`, `phrasegroup_cppermission`, `phrasegroup_forum`, `phrasegroup_calendar`, `phrasegroup_attachment_image`, `phrasegroup_style`, `phrasegroup_logging`, `phrasegroup_cphome`, `phrasegroup_promotion`, `phrasegroup_user`, `phrasegroup_help_faq`, `phrasegroup_sql`, `phrasegroup_subscription`, `phrasegroup_language`, `phrasegroup_bbcode`, `phrasegroup_stats`, `phrasegroup_diagnostic`, `phrasegroup_maintenance`, `phrasegroup_profilefield`, `phrasegroup_thread`, `phrasegroup_timezone`, `phrasegroup_banning`, `phrasegroup_reputation`, `phrasegroup_wol`, `phrasegroup_threadmanage`, `phrasegroup_pm`, `phrasegroup_cpuser`, `phrasegroup_accessmask`, `phrasegroup_cron`, `phrasegroup_moderator`, `phrasegroup_cpoption`, `phrasegroup_cprank`, `phrasegroup_cpusergroup`, `phrasegroup_holiday`, `phrasegroup_posting`, `phrasegroup_poll`, `phrasegroup_fronthelp`, `phrasegroup_register`, `phrasegroup_search`, `phrasegroup_showthread`, `phrasegroup_postbit`, `phrasegroup_forumdisplay`, `phrasegroup_messaging`, `phrasegroup_inlinemod`, `phrasegroup_plugins`, `phrasegroup_cprofilefield`, `phrasegroup_reputationlevel`, `phrasegroup_infraction`, `phrasegroup_infractionlevel`) VALUES
(1, 'English (US)', 1, 1, 'en', 'ISO-8859-1', '', '', '', '', '', '', '', '', '.', ',', 'a:522:{s:9:"1_day_ago";s:9:"1 Day

**y2ksw** · 07-09-2007, 00:00

yup = esatto

**colin** · 07-09-2007, 14:19

Originariamente Scritto da y2ksw

yup = esatto

E' pensare che l'inglese e' la mia prima lingua

...comunque c'e' lo quasi fatta

**colin** · 07-09-2007, 17:59

fatto..grazie a tutti, il pensiero(e' so che e' di tutti)a volte aiuta molto di piu'....ho fatto cosi'

DOPO: PHRASEGROUP_INLINEMOD
aggiungi

campo
phrasegroup_plugins

TIPO
mediumtext

COLLATION
latin1_swedish_ci

NULL

Si

PREDEFINITO

NULL

Discussione: bo...

Strumenti Discussione

bo...

Tag per Questa Discussione

Segnalibri

Segnalibri

Permessi di Scrittura