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 November 28th, 2007, 04:22 AM   #1 (permalink)
Junior Member
Verified Customer
 
Join Date: Apr 2007
Posts: 15
Unhappy Unknown MySQL Error Report

Hey everyone..

I just upgraded to 6.01 from 5.62. I use Greek as my Gallery language and had to do some testing before upgrading so my gallery is not messed up.

Anyway, i got 4 emails with these sql errors. As I don't know much about programming i can't really tell what's wrong.

Any help would be appreciated...


REPLACE INTO pp_iponline (ipaddr,userid,uid,date,what,item,agent,referer) VALUES ('x.x.x.x','Guest',0,'1196243636','showgallery','0','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)','http://www.myxbox.gr/')

The query returned with an errorcode of:

Unknown column 'uid' in 'field list'


I have removed the IP address and replaced it with x.x.x.x....
Gotmian is offline   Reply With Quote
Old November 28th, 2007, 06:51 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,947
You need to run your upgrade script and upgrade your 5.62 database to 6.0 status. I show you have forgotten to run your upgrade so your missing by example that uid column that is suppose to exist in that table.
__________________
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 November 28th, 2007, 07:00 AM   #3 (permalink)
Junior Member
Verified Customer
 
Join Date: Apr 2007
Posts: 15
....

Quote:
Originally Posted by Chuck S View Post
You need to run your upgrade script and upgrade your 5.62 database to 6.0 status. I show you have forgotten to run your upgrade so your missing by example that uid column that is suppose to exist in that table.
Well, i thought of that too, but you see i have already run the script... :S
And when i check the admin page, i do get the proper version...

So, now what? Maybe it was an error while the files where uploaded? Minutes before i run the upgrade script??

I haven't got any other report, other than those 4...

Should i wait and see?
Gotmian is offline   Reply With Quote
Old November 28th, 2007, 11:04 AM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,947
Well this is right in the upgrade script you can see we add it so it would appear to me the upgrade has not been ran with the mysql error you report.

Code:
Content visible to verified customers only.
I would suggest you wait and see if you get any other reports maybe those where before you can your upgrade you failed to close your gallery while upgrading and people where viewing the gallery.
__________________
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
Forum MySQL Error Report JoeWho Photopost Pro Bug Reports 1 February 18th, 2007 02:34 PM
MySQL Error Report mjm Photopost Pro Bug Reports 21 January 1st, 2007 11:00 PM
MySQL Error Report Emails swaindg Photopost Pro How Do I...? 1 May 30th, 2006 09:14 PM
ClassifiedAdzS MySQL Error Report Johnbmtl Classifieds Bug Reports 6 January 13th, 2006 08:06 AM


All times are GMT -5. The time now is 03:45 AM.

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