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 Installation & Upgrades

Photopost Pro Installation & Upgrades If you're having install or upgrade problems

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old November 8th, 2006, 08:28 PM   #1 (permalink)
Junior Member
 
Join Date: Mar 2003
Location: Southern California
Posts: 11
Send a message via AIM to bwilliams Send a message via MSN to bwilliams Send a message via Yahoo to bwilliams
Database handle: Resource id #11

Getting this error:


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

Script:

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 user u LEFT JOIN userfield uf ON uf.userid=u.userid LEFT JOIN session s ON s.userid=u.userid LEFT JOIN usertextfield t ON t.userid=u.userid LEFT JOIN avatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = u.userid) WHERE u.userid=544 LIMIT 1

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

Database handle: Resource id #11

Here is a link: http://www.socaps.com/photopost/show...42/limit/last1
bwilliams is offline   Reply With Quote
Old November 9th, 2006, 02:11 PM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,806
MSQL_Fetch Issue

that should help
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old November 9th, 2006, 02:16 PM   #3 (permalink)
Junior Member
 
Join Date: Mar 2003
Location: Southern California
Posts: 11
Send a message via AIM to bwilliams Send a message via MSN to bwilliams Send a message via Yahoo to bwilliams
Quote:
Originally Posted by Chuck S View Post
MSQL_Fetch Issue

that should help
I ran the SQL command and that did the trick, thanks.
bwilliams 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
How does RP handle the move from 3.0.x to 3.5.x ab7fh ReviewPost Installation & Upgrades 2 January 15th, 2006 01:59 PM
How many categories can photopost handle? Garrynz General Discussion 6 November 19th, 2005 02:26 PM
Photopost 5.0.3 server resource questions Johnny Doomo Photopost Pro Installation & Upgrades 6 September 12th, 2005 11:44 AM
Database Handle error # 8 with PHPNuke Ilse Photopost Pro Installation & Upgrades 3 February 1st, 2005 06:23 AM
MySQL error - Database handle: Resource id #8 Andy R Photopost Pro Installation & Upgrades 2 July 21st, 2004 04:51 PM


All times are GMT -5. The time now is 02:47 PM.

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