 | |  | |
October 22nd, 2005, 10:08 AM
|
#1 (permalink)
| | Member Verified Customer
Join Date: Jan 2005
Posts: 118
| 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
| |
| |
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
| |
| |
October 22nd, 2005, 10:47 AM
|
#3 (permalink)
| | Guest | Re: restoring vba_gallery database to 3.5
Sounds like you didn't run the upgrade script.
| |
| |
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 ...
|
| |
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 ..
|
| |
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
|
| |
October 22nd, 2005, 12:27 PM
|
#7 (permalink)
| | Guest | 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.
| |
| | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Thread Tools | | | | Display Modes | Rate This Thread | Linear Mode | |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts HTML code is Off | | | All times are GMT -5. The time now is 01:09 PM. | |