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

Classifieds Installation & Upgrades If you're having install or upgrade problems, post here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old January 1st, 2005, 11:52 AM   #1 (permalink)
Registered User
 
Join Date: Jan 2005
Posts: 2
Help! Install Error: 'Unkown Column in Field List'

We had installed an earlier version of classifieds a day or two ago and had it working fine. Saw that 2.0 was out and downloaded that, copied all the new files in on top of the old ones via FTP.

The install script does not complete, and the classifieds are now not available. This error shows up after the 'Complete PhotoPost Classifieds Installation' button is clicked in the install program:
MySQL error reported!

Script: install

Query: SELECT groupid, groupname, cpaccess, uploads, comments, uploadsize, editpho, editposts, modaccess, reqmod, highlight, bold, italic FROM ppc_usergroups

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

Database handle: Resource id #5
What can I do? I have tried running through the install twice now, same error. This field isn't being created.
XanaduRanch is offline   Reply With Quote
Old January 1st, 2005, 12:28 PM   #2 (permalink)
Registered User
 
Join Date: Jan 2005
Posts: 2
Additional Information

If I manually to a MySQL query from the vB3 control panel I get the same error unless I remove 'highlight, bold, italic' from the query string.

Are these just missing fields that need to be added to my 'ppc_usergroups' table? Can someone give me the MySQL query to insert these fields if so?

Thanks!
XanaduRanch 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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Error: Unknown column 'notcat' in 'where clause' mtha Photopost Pro Bug Reports 9 November 3rd, 2005 08:17 PM
SQL Error: Unknown column 'notcat' in 'where clause'(FIXED) qwk98gt Photopost Pro Bug Reports 10 October 21st, 2005 02:37 PM
New Install, unknown column 'albums' in 'field list' elyk Photopost Pro Installation & Upgrades 8 May 26th, 2005 09:09 AM
strange request, remove all thumnails, and list pics/files as a list? vwsport.com Photopost Pro How Do I...? 1 March 15th, 2005 08:22 PM


All times are GMT -5. The time now is 12:18 PM.

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