Text only | Text with Images

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 bridging => Topic started by: Konstantinos on May 01, 2006, 01:54:03 PM

Title: convert mybb to vbulletin and bridge works but
Post by: Konstantinos on May 01, 2006, 01:54:03 PM
after i converted my mybb forum to vbulletin i applied the bridge and works ok but the problem is that after the convertion the mybb user id's are not the same as vbulleting user id.s which means that the albums in cpg are shown but they show as belonging to a different user. what i want to do is to change the user id in cpg tables in phpmyadmin in order to associate the album to the correct user. i browsed the albums tables but there is no user id only album id. any help ? ohh and i know that i can do it the opposite way meaning that i can change the user id in the forum to match the album but this way i will mess the threads therefore the best way to do it is to change the user id at cpg . how to do that ?
Title: Re: convert mybb to vbulletin and bridge works but
Post by: Nibbler on May 01, 2006, 02:12:10 PM
Change the owner_id of the pictures and the category of the user albums is 10000+id.
Title: Re: convert mybb to vbulletin and bridge works but
Post by: Konstantinos on May 01, 2006, 02:23:24 PM
you mean 100+id right ?
Title: Re: convert mybb to vbulletin and bridge works but
Post by: Nibbler on May 01, 2006, 03:19:01 PM
ten thousand plus the id of the user. If the user is 12 then the category is 10000+12 = 10012
Title: Re: convert mybb to vbulletin and bridge works but
Post by: Konstantinos on May 15, 2006, 08:49:21 PM
which query to run to replace the old id with the id in the pictures table ? for example replacing owner id 14 with 1345 automaticly ?
Title: Re: convert mybb to vbulletin and bridge works but
Post by: Nibbler on May 15, 2006, 08:50:43 PM
Code Select
UPDATE cpg_pictures SET owner_id = 1345 WHERE owner_id = 14
Title: Re: convert mybb to vbulletin and bridge works but
Post by: Konstantinos on May 15, 2006, 09:14:37 PM
awesome thanx, i need to do the same for the comments now, the command is

UPDATE cpg_comments SET author_id = 1345 WHERE author_id = 14

right ?
Title: Re: convert mybb to vbulletin and bridge works but
Post by: Nibbler on May 15, 2006, 09:26:03 PM
Yes, make backups before you run any queries you are unsure of.
Title: Re: convert mybb to vbulletin and bridge works but
Post by: Konstantinos on May 16, 2006, 09:53:42 AM
after upgrading to 1.4.5 i get this in bridge manager

Fatal error: Cannot redeclare class core_udb in /home/xxx/public_html/albums/bridge/udb_base.inc.php on line 22  while i tried to disable and rerun the bridge manager in order to set permission per post count however the bridge still works but i cant disable it and re do it
Title: Re: convert mybb to vbulletin and bridge works but
Post by: Joachim Müller on May 17, 2006, 12:23:18 AM
hm, be careful with thread drift...
Title: Re: convert mybb to vbulletin and bridge works but
Post by: Konstantinos on December 02, 2006, 07:19:44 PM
and if i want to run the same query but for only to change the properties in pics in a specific album ex aid=184

will this work ? UPDATE cpg_pictures SET owner_id = 1345 WHERE owner_id = 14 WHERE aid=148   ???
Title: Re: convert mybb to vbulletin and bridge works but
Post by: Nibbler on December 02, 2006, 09:21:44 PM
UPDATE cpg_pictures SET owner_id = 1345 WHERE owner_id = 14 AND aid=148
Title: Re: convert mybb to vbulletin and bridge works but
Post by: Konstantinos on December 03, 2006, 01:51:01 AM
ok it worked but i also trying changing the uploader name by using this it didnt work . whats the problem

UPDATE cpg132_pictures SET owner_name = john WHERE owner_name = nick AND aid=148


#1054 - Unknown column 'john' in 'field list'
Title: Re: convert mybb to vbulletin and bridge works but
Post by: Konstantinos on December 03, 2006, 01:55:41 AM
of i figured it out thanx man
Text only | Text with Images