vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Photopost "gallery" clickable icon in postbit(_legacy) and/or profiles. (https://vborg.vbsupport.ru/showthread.php?t=111962)

StuntFactoryX 07-10-2006 03:50 AM

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 08-08-2006 04:57 PM

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

Schahab 08-14-2006 04:44 PM

Nobody can help?

Schahab 08-14-2006 05:05 PM

Hello,

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

ubblite 08-15-2006 06:24 AM

Quote:

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 09-27-2006 11:11 AM

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 11-11-2006 06:57 PM

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 12-05-2006 07:16 PM

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 12-05-2006 07:51 PM

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 12-11-2006 12:18 AM

Quote:

Originally Posted by mattselley (Post 1114933)
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.


All times are GMT. The time now is 02:22 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01238 seconds
  • Memory Usage 1,740KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete