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 December 17th, 2008, 06:05 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: Oct 2007
Posts: 38
error upload photos

Hi Chuck
my apologies for my problem
in my photopost gallery when the users try to upload the photos i receive this error:

********************
We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: INSERT IGNORE INTO BMWM_FORUM_users (userid,lastphoto,lastdate) VALUES (1,0,0)

Result: Unknown column 'lastphoto' in 'field list'

Database handle: Resource id #42
***********************

Please my friend can you help me?
thanks
regards
Ivan
serraivan is offline   Reply With Quote
Old December 17th, 2008, 06:09 AM   #2 (permalink)
Member
Verified Customer
 
Join Date: Oct 2007
Posts: 38
no my board is closed for maintenance because i'm waiting you help befor open it again!

Message - BMWM Photo-Audio-Videos Gallery
serraivan is offline   Reply With Quote
Old December 17th, 2008, 07:53 AM   #3 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 68,070
have you ran your upgrade script if you recently upgraded?

That would appear to me is you have attempted to upgrade and not ran a specific upgrade you needed to. For instance that field was added in 5.5 upgrade of photopost.
__________________
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 December 21st, 2008, 05:14 AM   #4 (permalink)
Member
Verified Customer
 
Join Date: Oct 2007
Posts: 38
hi done the upgrade script i receive the error from the mysql database maybe because i have ran the script last time after the installed new version
i receive also this error when i try to upload the files:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT SUM(filesize) AS fsize FROM BMWM_FORUM_photos WHERE userid= AND storecat=0

Result: 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 'AND storecat=0' at line 1

Database handle: Resource id #46

the link here:
http://www.bobmarleymagazine.com/pho...umbs=&mature=0
serraivan is offline   Reply With Quote
Old December 21st, 2008, 09:36 AM   #5 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 68,070
what integration are you using?
__________________
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 December 21st, 2008, 03:31 PM   #6 (permalink)
Member
Verified Customer
 
Join Date: Oct 2007
Posts: 38
vbulletin 3.7.4 PL1
serraivan is offline   Reply With Quote
Old December 21st, 2008, 09:05 PM   #7 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 68,070
In bulkupload.php try making the line this and tell me if that helps line 151

Code:
Content visible to verified customers only.
__________________
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 December 22nd, 2008, 11:12 AM   #8 (permalink)
Member
Verified Customer
 
Join Date: Oct 2007
Posts: 38
hi Chuck what do you mean? i have the line 138:

$resulta = ppmysql_query("SELECT SUM(filesize) AS fsize FROM {$Globals['pp_db_prefix']}photos WHERE userid=$upuserid AND storecat=0", $link);

the same like your above

you want that i comment this line or delete it?
serraivan is offline   Reply With Quote
Old December 22nd, 2008, 11:31 AM   #9 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 68,070
Make the line what I have posted above they look identical but are not.
__________________
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
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
Upload Pending Cue - Cust Unable to Upload New Photos HeritageScrap Photopost Pro How Do I...? 5 March 7th, 2010 04:31 PM
error when users upload photos hornstar6969 Photopost Pro Installation & Upgrades 1 April 15th, 2008 06:46 AM
Error message on upload of larger photos KenDude Classifieds Bug Reports 17 May 16th, 2007 02:36 PM
Cannot Upload Photos - image-inc.php error smokn28 Photopost Pro How Do I...? 7 March 4th, 2007 12:01 PM
Error - Can't Upload Photos! tourworld Photopost Pro Bug Reports 1 February 23rd, 2007 03:53 PM


All times are GMT -5. The time now is 11:00 AM.

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