Error Report...

Gotmian · June 15th, 2007, 01:19 AM

Can someone help me with this error please???

Quote:

An error was encountered during execution of the query:

SELECT u.username,u.homepage,u.usertitle,u.posts,u.joindate,uf.field2,s.host,t.signature,avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustomavatar,u.avatarrevision FROM vb350_user u
LEFT JOIN vb350_userfield uf ON uf.userid=u.userid
LEFT JOIN vb350_session s ON s.userid=u.userid
LEFT JOIN vb350_usertextfield t ON t.userid=u.userid LEFT JOIN vb350_avatar AS avatar ON (avatar.avatarid = u.avatarid)
LEFT JOIN vb350_customavatar AS customavatar ON (customavatar.userid = u.userid) WHERE u.userid=2 LIMIT 1

The query returned with an errorcode of:

Unknown column 'uf.field2' in 'field list'

I would really appreciate any help.
Thank you for the time and attention.

Chuck S · June 15th, 2007, 07:05 AM

Getting MySQL error

that is what you need

Gotmian · June 15th, 2007, 08:03 AM

Yeap, that seems to work

I understood that something was wrong with the db but couldn't figure out what and how to fix it...

Thank you for the time, attention and immediate response.

Chuck S · June 15th, 2007, 08:20 AM

not a problem

Gotmian · June 17th, 2007, 02:38 PM

I have 2 more problems (reports)...

Quote:

INSERT INTO pp_searchids (searchid,userid,searchtype,searchterms,searchdate,cats,name,preview,idlist,numresults,ipaddress,searchtime,date)
VALUES ( [...] )

The query returned with an errorcode of:

Table 'db_forum.pp_searchids' doesn't exist

Quote:

DELETE FROM pp_searchids WHERE date < 1181501056

The query returned with an errorcode of:

Table 'db_forum.pp_searchids' doesn't exist

Since they both call pp_searchids and there is no such table what can i do?
Can i simply create a table? Will that be enough (and if yes, please, how do i create the table...)? Noob here... :P

Chuck S · June 17th, 2007, 06:06 PM

Okay well if you recently upgraded did you happen to run the upgrade script?

Looks to me like you forgot to do that

Gotmian · June 17th, 2007, 11:47 PM

I was not in charge of the technical stuff, so unfortunately i have no idea what the guy who was responsible for this did and what he did not...

Since he is no longer in the team, i can't find out what he did and what he didnot do, but the PP version seems OK (It is up to date).

Can i somehow create the missing tables or something?....

Thank you again for the time and attention.

Chuck S · June 18th, 2007, 08:44 AM

You would run the upgrade.php script and say run the 5.5 and 5.6 upgrade scripts