PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Pro Support Forums > Photopost Pro Bug Reports

Photopost Pro Bug Reports Post post installation PhotoPost Pro problems here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old January 23rd, 2007, 12:03 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: Nov 2006
Posts: 39
Error Messages

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
LoriW is offline   Reply With Quote
Old January 23rd, 2007, 09:10 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,788
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
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old January 25th, 2007, 10:35 PM   #3 (permalink)
Member
Verified Customer
 
Join Date: Nov 2006
Posts: 39
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.
LoriW is offline   Reply With Quote
Old January 26th, 2007, 10:34 AM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,788
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
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old January 27th, 2007, 12:14 AM   #5 (permalink)
Member
Verified Customer
 
Join Date: Nov 2006
Posts: 39
Thanks Chuck. Just did the upgrade again.
LoriW is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error Messages not showing up BryanG ReviewPost Bug Reports 10 July 18th, 2006 07:38 PM
error messages whitetigergrowl Photopost Pro How Do I...? 8 June 18th, 2006 10:45 PM
Several error messages jbwax Photopost Pro Bug Reports 18 February 1st, 2006 05:05 PM
re: I get error messages agardonia Photopost Pro Installation & Upgrades 1 June 21st, 2005 08:36 AM


All times are GMT -5. The time now is 07:40 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0