View Single Post
Old August 27th, 2008, 07:21 AM   #23 (permalink)
Mike_K
Member
Verified Customer
 
Join Date: Dec 2005
Location: Germany
Posts: 165
Wow.... now I have realy an DB error.

After adding the plugin no access more. DB errors:

Quote:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.phrasegroup_adv_gallery_int AS phrasegroup_adv_gallery_int,
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
, user.userid AS userid, ppgal_user.lastpostid AS gallastpostid, user.lastpostid AS lastpostid
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 language AS language ON (language.languageid = IF(user.languageid = 0, 2, user.languageid))

WHERE user.userid = 88;

MySQL-Fehler : Unknown column 'ppgal_user.lastpostid' in 'field list'
Fehler-Nr. : 1054
Fehler-Zeit : Wednesday, 27.08.2008 @ 12:02:24
Datum : Wednesday, 27.08.2008 @ 12:02:24
Skript : Title here!
Referrer :
IP-Adresse : 87.1xxxxxx
Benutzername :
Klassenname : vB_Database
MySQL-Version :
No access to the forum or admin-cp!

I deleted now in the DB the plugin.
Deleted also in the Datastore / pluginlist the code

Quote:
s:595:"$hook_query_fields .= ", user.userid AS userid, ppgal_user.lastpostid AS gallastpostid, user.lastpostid AS lastpostid";
Now I have access to the forum, but not to the admin-cp!
Error: Warnung: array_merge() [function.array-merge]: Argument #1 is not an array in [path]/includes/init.php (Zeile 271)

In the forum, all plugins are not present.

I have run the tools.php from vbulletin. But nothing happend.

I need HELP!
Mike_K is offline   Reply With Quote