We need HELP !! recovering categories

[easyskillz]

I need to know if there is a way to update the vba_gallery TABLES from rc2 to 1.01.

Knowing that i cannot do it ...via the normal method.

i really need costum help on this one and to chat with someone ...to explain exactly the problem.

PLease Brian or someone. i am really desperate here

Please quit posting about the same thing under multiple threads. That just slows us down and makes it even harder to help you.
Why can't you run the upgrade script? As long as you do that then that should update all tables to work with 1.0.1.

[easyskillz]

i can't run the update script because i do NOT have the other rc2 files ..all i have is the database.

[easyskillz]

i wish i could talk to u via a chat or something to explain better ...

[easyskillz]

well i am going home ...will login from there to see if you found a solution for me ..

Thanks man.

Restore those database tables, run this query through the Admin CP:
UPDATE adv_setting SET value = '1.0 RC2' WHERE varname = 'gallery_version';

Then run the upgrade script.

[easyskillz]

ok ..so i did that and got

Database error in vBulletin 3.5.0:

Invalid SQL:
INSERT INTO adv_settinggroup (grouptitle, displayorder) VALUES ('adv_gallery_paths', 2), ('adv_gallery_usercats', 10), ('adv_gallery_categorybit', 5);

MySQL Error : Duplicate entry 'adv_gallery_paths' for key 1
Error Number : 1062
Date : Saturday, October 22nd 2005 @ 06:35:25 PM
Script : http://maroceve.com/forums/admincp/v...ry_install.php
Referrer : http://maroceve.com/forums/admincp/v...ry_install.php
IP Address : 196.206.147.75
Username : Ez
Classname : vb_database

i am going to reupload the databases and try again in case i missed something.

[easyskillz]

ok i confirm this error when i do the upgrade

[easyskillz]

?

[easyskillz]

more errors when i save a category and usergroupe permissin and i go and click on a category
i get this

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT categories.catid, title, description, hasimages, categories.catuserid, password, parent, parentlist, membercat, options, useroptions
, NOT ISNULL(subscribecat.catid) AS subsribecatid, subscribecat.catuserid AS subcatuserid
FROM adv_gallery_categories AS categories
LEFT JOIN adv_gallery_subscribecat AS subscribecat ON (categories.catid = subscribecat.catid AND subscribecat.userid = 1)
WHERE categories.catid = '4';

MySQL Error : Unknown column 'subscribecat.catuserid' in 'field list'
Error Number : 1054
Date : Saturday, October 22nd 2005 @ 08:52:50 PM
Script : http://www.maroceve.com/gallery/browseimages.php?c=4
Referrer : http://www.maroceve.com/gallery/
IP Address : 196.206.147.75
Username : Ez
Classname : vb_database

Sounds like you didn't restore all of the tables. Uninstall the script, restore the tables, and then run the upgrade.

[easyskillz]

i am pretty sure i restored all my tables. what script are u talking about ?

The first error happens during the upgrade. It crashes ..man i wish u could take a look at this trought a ticket yourself.

[easyskillz]

there is the error i get during the update

Database error in vBulletin 3.5.0:

Invalid SQL:
INSERT INTO adv_settinggroup (grouptitle, displayorder) VALUES ('adv_gallery_paths', 2), ('adv_gallery_usercats', 10), ('adv_gallery_categorybit', 5);

MySQL Error : Duplicate entry 'adv_gallery_paths' for key 1
Error Number : 1062
Date : Saturday, October 22nd 2005 @ 09:53:42 PM
Script : http://www.maroceve.com/forums/admin...ry_install.php
Referrer : http://www.maroceve.com/forums/admin...ry_install.php
IP Address : 196.206.147.75
Username : Ez
Classname : vb_database

[easyskillz]

Content visible to verified customers only.

there is my restored dbs

adv_setting and adv_settinggroup are also vBa Gallery tables. Judging from your last error, it doesn't look like you deleted/restored those.

[easyskillz]

ouch ok let me try...

Thank you brian for ur help..ok so im gonna try

[easyskillz]

what about adv pages and adv modules ?

[easyskillz]

Well, i get this error now when i try to upgrade

Invalid SQL:
CREATE TABLE adv_gallery_exif (
imageid int(10) unsigned NOT NULL default '0',
exifinfo text NOT NULL,
UNIQUE KEY imageid (imageid)
) TYPE=MyISAM;

MySQL Error : Table 'adv_gallery_exif' already exists
Error Number : 1050
Date : Saturday, October 22nd 2005 @ 10:28:25 PM
Script : http://www.maroceve.com/forums/admin...ry_install.php
Referrer : http://www.maroceve.com/forums/admin...ry_install.php
IP Address : 196.206.147.75
Username : Ez
Classname : vb_database

but now when i click on a category i get

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT categories.catid, title, description, hasimages, categories.catuserid, password, parent, parentlist, membercat, options, useroptions
, NOT ISNULL(subscribecat.catid) AS subsribecatid, subscribecat.catuserid AS subcatuserid
FROM adv_gallery_categories AS categories
LEFT JOIN adv_gallery_subscribecat AS subscribecat ON (categories.catid = subscribecat.catid AND subscribecat.userid = 1)
WHERE categories.catid = '4';

MySQL Error : Unknown column 'subscribecat.catuserid' in 'field list'
Error Number : 1054
Date : Saturday, October 22nd 2005 @ 10:31:24 PM
Script : http://www.maroceve.com/gallery/browseimages.php?c=4
Referrer : http://www.maroceve.com/gallery/
IP Address : 196.206.147.75
Username : Ez
Classname : vb_database

[easyskillz]

Well i am about to single handedly reupload 8000 pictures to my vbgallery ..ill start that monday morning ..if by then anyone cares to help me in any way solve this ...Please let me know

hamzaalami@gmail.com for msn.

Thanks Brian ..but this didn't work ...probably cause i didn't do something right ..i know ..

peace