PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |
Old October 22nd, 2005, 10:08 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: Jan 2005
Posts: 118
Arrow restoring vba_gallery database to 3.5

I tried restoring all the vba_gallery databases from my old website " gallery rc2" to my new 1.1 ...
It gives me all categories in admin panel ...but i get an error when i try to save one of the categories.

Quote:
Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE adv_gallery_categories SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Evenements publics',
`description` = 'Public events',
`displayorder` = '1',
`parent` = '0',
`catimage` = '',
`newimageemail` = '',
`newpostemail` = '',
`hasimages` = '1',
`active` = '1',
`membercat` = '0',
`allowusercats` = '1',
`password` = '',
`catid` = '2',
`catuserid` = '',
`disext` = '',
`adv_setting` = '',
`options` = '1666779',
`useroptions` = '0'
WHERE catid = '2';

MySQL Error : Unknown column 'membercat' in 'field list'
Error Number : 1054
Date : Saturday, October 22nd 2005 @ 03:07:55 PM
Script : http://www.maroceve.com/forums/admin...lery_admin.php
Referrer : http://www.maroceve.com/forums/admin...ditcat&catid=2
IP Address : 81.192.222.248
Username : Ez
Classname : vb_database
easyskillz is offline  
Old October 22nd, 2005, 10:20 AM   #2 (permalink)
Member
Verified Customer
 
Join Date: Jan 2005
Posts: 118
Re: restoring vba_gallery database to 3.5

and when i click on the only thumbnails showing ..it gives me this
Quote:
Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT images.imageid, username, images.userid, images.title, images.catid, dateline, images.description, keywords, filename, thumbname, width, height, extension, filesize, originalname, originalfilesize, originalwidth, originalheight, views, posts, valid, open, sticky, votenum, votetotal, options, catimage, catuserid, membercat, useroptions, customfields.*
,NOT ISNULL(favorites.imageid) AS favid
,NOT ISNULL(subscribeimage.imageid) AS issubscribed
, exifinfo
FROM adv_gallery_images AS images
LEFT JOIN adv_gallery_categories AS categories ON (images.catid = categories.catid)
LEFT JOIN adv_gallery_customfields_entries AS customfields ON (images.imageid = customfields.imgid)
LEFT JOIN adv_gallery_favorites AS favorites ON (favorites.imageid = images.imageid AND favorites.userid = 1)
LEFT JOIN adv_gallery_subscribeimage AS subscribeimage ON (subscribeimage.imageid = images.imageid AND subscribeimage.userid = 1)
LEFT JOIN adv_gallery_exif AS exif ON (images.imageid = exif.imageid)
WHERE images.imageid = '9495';

MySQL Error : Unknown column 'membercat' in 'field list'
Error Number : 1054
Date : Saturday, October 22nd 2005 @ 03:20:24 PM
Script : http://www.maroceve.com/gallery/show...atid=newimages
Referrer : http://www.maroceve.com/gallery/
IP Address : 81.192.222.248
Username : Ez
Classname : vb_database
easyskillz is offline  
Old October 22nd, 2005, 10:47 AM   #3 (permalink)
Brian
Guest
 
Posts: n/a
Re: restoring vba_gallery database to 3.5

Sounds like you didn't run the upgrade script.
 
Old October 22nd, 2005, 10:51 AM   #4 (permalink)
Member
Verified Customer
 
Join Date: Jan 2005
Posts: 118
Re: restoring vba_gallery database to 3.5

It tells me
You are already running the current version of vBadvanced Gallery

which is logical since this is on a completely different server ...
easyskillz is offline  
Old October 22nd, 2005, 10:59 AM   #5 (permalink)
Member
Verified Customer
 
Join Date: Jan 2005
Posts: 118
Re: restoring vba_gallery database to 3.5

man it would be really great if someone can help me fix this ...we haven't had any sleep in 3 days... im pretty sure it will take only 5 Minutes of your time ...by msn or by phone or something ..

I am even willing to pay for a normal conversation ...not having to use the forums.. ... we need to get our old categories back or it's gonna be a reupload of 8000 pictures ..
easyskillz is offline  
Old October 22nd, 2005, 12:08 PM   #6 (permalink)
Member
Verified Customer
 
Join Date: Jan 2005
Posts: 118
Re: restoring vba_gallery database to 3.5

just let me know that you will eventually respond later ? i don't even know if anyone is actually going to help ..So do i go do other stuff ? or wait here until somone comes ? or what ? Please guys I really need help
easyskillz is offline  
Old October 22nd, 2005, 12:27 PM   #7 (permalink)
Brian
Guest
 
Posts: n/a
Re: restoring vba_gallery database to 3.5

Closing this since you have multiple threads about the same subject open and that just adds to the confusion.
 
Closed Thread


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
Use "forums" database or "photopost" database thephonemall Photopost Pro Installation & Upgrades 1 August 11th, 2005 02:18 PM
database garybrun Photopost Pro How Do I...? 2 May 25th, 2005 05:59 PM
Database error izan Classifieds Bug Reports 7 October 23rd, 2004 11:40 AM
User database name? nf71 Before You Buy 2 October 1st, 2004 11:21 PM


All times are GMT -5. The time now is 01:09 PM.

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