Photopost "gallery" clickable icon in postbit(_legacy) and/or profiles.

Gone

[StuntFactoryX]

hmm interesting. i get this error when trying to run scheduled task. i checked w/phpmyadmin, the table is there. i have hacks installed to display random pics on forum home ect. and my gallery works fine and intergrates fine w/ my forums. its the only username and database i have. any ideas of things i could check permission wise that i could have overlooked?

[Schahab]

Good Job, but don't work with Vbulletin 3.6 any Ideas?

[Schahab]

Nobody can help?

[Schahab]

Hello,

I don't get an error, the button don't appear... :-(

[ubblite]

Originally Posted by KBowers

I'm trying to get this to work, but I'm getting the following error messages:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT userid FROM mustangg_photopost.pp_photos;

MySQL Error : Access denied for user 'mustangg_bowers'@'%' to database 'mustangg_photopost'
Error Number : 1044
Date : Monday, May 8th 2006 @ 04:30:20 PM
Script : http://www.mustanggt.org/forums/cron.php?&rand=503085
Referrer : http://www.mustanggt.org/forums/showthread.php?t=41439
IP Address : 69.117.185.102
Username : Unregistered
Classname : vb_database

I'm assuming I'm getting this error message because I have my photopost database separate from my vbulletin database (and it requires different users - mustangg_bowers is the user for my vbulletin database and mustangg_bowers1 is the user for my photopost database). Is there anyway around this??

Help! :bunny: Thanks!

Same problem here. I tried the suggested fix by mini2 but still had the same error. Any other ideas?

[glowinggal]

yea we have our forum and gallery on separate databases and too have an issue of sorts... here is our error we got:

Database error in vBulletin 3.6.0:

Invalid SQL:
UPDATE userfield SET field61 = 'Yes' WHERE userfield.userid = 0 AND userfield.field61 != 'Yes';

MySQL Error : Unknown column 'userfield.field61' in 'where clause'
Error Number : 1054
Date : Wednesday, September 27th 2006 @ 08:10:50 AM
Script : http://www.vvvvv.com/chat/admincp/cr...cron&cronid=20
Referrer : http://www.vvvvv.com/chat/admincp/cr....php?do=modify
IP Address : 66.24.45.98
Username : pcloadmin
Classname : vb_database

[mattselley]

hi,

i get this error when trying to run the scheduled task in 3.6.2

Database error in vBulletin 3.6.2:

Invalid SQL:
SELECT userid FROM photopost.pp_photos;

MySQL Error : SELECT command denied to user 'mattsell_mattsel'@'localhost' for table 'pp_photos'
Error Number : 1142
Date : Saturday, November 11th 2006 @ 02:43:09 PM
Script : http://www.xxxxxxx.com/forum/admincp...cron&cronid=19
Referrer : http://www.xxxxxxx.com/forum/admincp/index.php
IP Address : 195.93.21.133
Username : Matt
Classname : vb_database

vb and pp both share the same database, and are both clean installs

any help would be great

[kellogs]

I tried to run the cron job manually using vbadmincp and it says Done.

But when i go to forum, i did not see the link?

User has photos in the photopost.

Where was wrong?

Thanks,
-K

[kellogs]

It is resolved now!!!

Have to explicitly insert the field number in the postbit legacy

It is an awesome mod!!!

Thank you Mini :knockedout:

-K

[seabiscuit]

Originally Posted by mattselley

hi,

i get this error when trying to run the scheduled task in 3.6.2

Database error in vBulletin 3.6.2:

Invalid SQL:
SELECT userid FROM photopost.pp_photos;

MySQL Error : SELECT command denied to user 'mattsell_mattsel'@'localhost' for table 'pp_photos'
Error Number : 1142

same problem here. That makes at least three users here.