Error Messages

[LoriW]

Hi,

Was wondering if someone could tell me why I got this email with the following error -

An error was encountered during execution of the query:

UPDATE pp_users SET lastphoto=130, lastdate=1169527351 WHERE userid=4

The query returned with an errorcode of:

Unknown column 'lastphoto' in 'field list'

I also got this one when I think I tried to search for a word -

SELECT id,cat FROM pp_photos WHERE approved=1 AND storecat=0 AND ((title LIKE "% Lifes%" OR description LIKE "% Lifes%" OR keywords LIKE "% Lifes%" OR bigimage LIKE "% Lifes%"
OR extra1 LIKE "% Lifes%" OR extra2 LIKE "% Lifes%" OR extra3 LIKE "% Lifes%" OR extra4 LIKE "% Lifes%" OR extra5 LIKE "% Lifes%" OR extra6 LIKE "% Lifes%") OR (title LIKE "Lifes%" OR description LIKE "Lifes%" OR keywords LIKE "Lifes%" OR bigimage LIKE "Lifes%"
OR extra1 LIKE "%Lifes%" OR extra2 LIKE "%Lifes%" OR extra3 LIKE "%Lifes%" OR extra4 LIKE "%Lifes%" OR extra5 LIKE "%Lifes%" OR extra6 LIKE "%Lifes%"))AND ((title LIKE "% Little%" OR description LIKE "% Little%" OR keywords LIKE "% Little%" OR bigimage LIKE "% Little%"
OR extra1 LIKE "% Little%" OR extra2 LIKE "% Little%" OR extra3 LIKE "% Little%" OR extra4 LIKE "% Little%" OR extra5 LIKE "% Little%" OR extra6 LIKE "% Little%") OR (title LIKE "Little%" OR description LIKE "Little%" OR keywords LIKE "Little%" OR bigimage LIKE "Little%"
OR extra1 LIKE "%Little%" OR extra2 LIKE "%Little%" OR extra3 LIKE "%Little%" OR extra4 LIKE "%Little%" OR extra5 LIKE "%Little%" OR extra6 LIKE "%Little%"))AND ((title LIKE "% moments%" OR description LIKE "% moments%" OR keywords LIKE "% moments%" OR bigimage LIKE "% moments%"
OR extra1 LIKE "% moments%" OR extra2 LIKE "% moments%" OR extra3 LIKE "% moments%" OR extra4 LIKE "% moments%" OR extra5 LIKE "% moments%" OR extra6 LIKE "% moments%") OR (title LIKE "moments%" OR description LIKE "moments%" OR keywords LIKE "moments%" OR bigimage LIKE "moments%"
OR extra1 LIKE "%moments%" OR extra2 LIKE "%moments%" OR extra3 LIKE "%moments%" OR extra4 LIKE "%moments%" OR extra5 LIKE "%moments%" OR extra6 LIKE "%moments%")) ORDER BY date DESC LIMIT

The query returned with an errorcode of:

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 '' at line 7

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

Any ideas what could be causing these?

Thanks!

Lori

[Chuck S]

You have not ran all the upgrades when upgrading your site. Try running the 5.5 upgrades through 5.61

I think any issues would be solved by downloading the build. Reuploading all files except the config files and running the 5.5 5.6 an d 5.61 upgrades

[LoriW]

Thanks Chuck for your reply. Now another silly question. When I originally got photopost it was 5.5 and then when I looked again it had jumped to 5.62. Where do I find the inbetween downloads? Or do I need those?

Thanks.

[Chuck S]

You do not need those you just need to download 5.62 and upgrade instructions are in the documentation folder

Basically upload all files except the config files install.php and any header and footer.htm files and run upgrade.php selecting any upgrade since your version which would be 5.6 and 5.61

[LoriW]

Thanks Chuck. Just did the upgrade again.