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)
-   -   [vbadvanced Gallery & Links] Number of contributed pics & links in profile (https://vborg.vbsupport.ru/showthread.php?t=100667)

puregraf 07-01-2006 08:19 PM

Hi, I am getting this error:




Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT COUNT(*) AS count FROM links WHERE userid = '1' AND valid = 1;

MySQL Error : Table 'puregraf_peegee.links' doesn't exist
Error Number : 1146
Date : Saturday, July 1st 2006 @ 02:18:49 PM
Script : http://www.puregraffiti.com/graffiti...member.php?u=1
Referrer : http://www.puregraffiti.com/graffiti-space/index.php
IP Address : ***
Username : puregraffiti
Classname : vb_database




can you please help me fix this?
THANKS!
:bunny:

Lea Verou 07-02-2006 07:18 AM

You obviously don't hve vbdvanced links directory installed. Comment out the section of the plugin that refers to links and don't do the template edit for links, just for the gallery.

criscokid 07-02-2006 10:46 AM

Quote:

Originally Posted by Dsyn11
I have photopost instead of vBa gallery. How do I change the product to pull the count from there?

Has anyone modified this mod to work with PhotoPost?

puregraf 07-03-2006 12:17 AM

Quote:

Originally Posted by Michelle
You obviously don't hve vbdvanced links directory installed. Comment out the section of the plugin that refers to links and don't do the template edit for links, just for the gallery.

i found Links contributed: $userlinks[count]
in MEMBERINFO and removed it and stil same error when i click on the usernames name, takes me to a page with that error.

what else could it be?

is there a way to restore things without restore the database. i tried uninstalling the plugin re-installing but didnt work either.

thank you i appreciate your help, im not very good with php.

puregraf 07-03-2006 11:05 PM

<!--
Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT COUNT(*) AS count FROM links WHERE userid = '35' AND valid = 1;

MySQL Error : Table 'puregraf_peegee.links' doesn't exist
Error Number : 1146
Date : Monday, July 3rd 2006 @ 05:03:44 PM
Script : http://www.puregraffiti.com/graffiti...poster&amp;f=5
Referrer : http://www.puregraffiti.com/graffiti-space/index.php
IP Address : *****
Username : cartman
Classname : vb_database
-->:( :( :( :( need to fix this please asap

Eggie 08-19-2006 04:06 PM

Quote:

Originally Posted by Michelle
I need to know the database structure of the photopost tables. Can you look into it via phpmyadmin and tell me?
About paid services: I don't accept international projects at the moment :)


hi Michelle,

I too would be intrested in using this with PhotoPost.. here are the tables for it

# Browse pp_admingroups
# Browse pp_admlog
# Browse pp_cache
# Browse pp_categories
# Browse pp_comments
# Browse pp_ecards
# Browse pp_exif
# Browse pp_extrafields
# Browse pp_favorites
# Browse pp_ipcache
# Browse pp_iponline
# Browse pp_laston
# Browse pp_notify
# Browse pp_photoextras
# Browse pp_photos
# Browse pp_photoviews
# Browse pp_settings
# Browse pp_sort
# Browse pp_sortmemb
# Browse pp_usergroups
# Browse pp_users

any help getting this to work would be great!

Eggie 08-21-2006 11:39 AM

/me bumps in hopes of an answer.

Spikeman 09-24-2006 03:59 PM

Works perfect with vB 3.6.1, thanks :)

FleaBag 10-16-2006 09:50 PM

Quote:

Originally Posted by puregraf
Hi, I am getting this error:




Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT COUNT(*) AS count FROM links WHERE userid = '1' AND valid = 1;

MySQL Error : Table 'puregraf_peegee.links' doesn't exist
Error Number : 1146
Date : Saturday, July 1st 2006 @ 02:18:49 PM
Script : http://www.puregraffiti.com/graffiti...member.php?u=1
Referrer : http://www.puregraffiti.com/graffiti-space/index.php
IP Address : ***
Username : puregraffiti
Classname : vb_database




can you please help me fix this?
THANKS!
:bunny:

Hi Michelle; I am getting this error since upgrading to the latest version of Links. It seems the hack is not compatible.

gilbert 11-12-2006 11:27 AM

Anyone get this working with photopost yet?


All times are GMT. The time now is 10:25 AM.

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.01170 seconds
  • Memory Usage 1,741KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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