Print

[Konstantinos]

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 ?

[Nibbler]

Change the owner_id of the pictures and the category of the user albums is 10000+id.

[Konstantinos]

you mean 100+id right ?

[Nibbler]

ten thousand plus the id of the user. If the user is 12 then the category is 10000+12 = 10012

[Konstantinos]

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 ?

[Nibbler]

Code: [Select]

UPDATE cpg_pictures SET owner_id = 1345 WHERE owner_id = 14

[Konstantinos]

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 ?

[Nibbler]

Yes, make backups before you run any queries you are unsure of.

[Konstantinos]

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

[Joachim Müller]

hm, be careful with thread drift...

[Konstantinos]

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   

[Nibbler]

UPDATE cpg_pictures SET owner_id = 1345 WHERE owner_id = 14 AND aid=148

[Konstantinos]

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'

[Konstantinos]

of i figured it out thanx man