PhotoPost Community - Error Report...

PhotoPost Community (http://www.photopost.com/forum/)

- Photopost Pro Bug Reports (http://www.photopost.com/forum/photopost-pro-bug-reports/)

- - Error Report... (http://www.photopost.com/forum/photopost-pro-bug-reports/132200-error-report.html)

Gotmian

June 15th, 2007 01:19 AM

Error Report...

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

http://www.photopost.com/forum/showt...ghlight=field2

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

2 more problems

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

All times are GMT -5. The time now is 12:27 AM.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97