vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Profile Enhancements - Automatically Add Friend (https://vborg.vbsupport.ru/showthread.php?t=177269)

King Kovifor 04-29-2008 06:34 PM

Guess Validate e-mail didn't stop it... Hm. Gotta look into that.

GoTTi 04-29-2008 10:59 PM

i upgraded to 3.7.0 today, but i am still getting a error that i think is caused by this mod...


Code:


Database error in vBulletin 3.7.0:
Invalid SQL:
INSERT INTO userlist (userid, relationid, type, friend) VALUES (, 1, 'buddy', 'yes');
MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 'buddy', 'yes')' at line 1
Error Number  : 1064
Request Date  : Tuesday, April 29th 2008 @ 01:11:23 PM
Error Date    : Tuesday, April 29th 2008 @ 01:11:23 PM
Script        : http://www.site.com/forums/register.php?do=activate
Referrer      : http://www.site.com/forums/register.php?a=ver
IP Address    : IP HERE
Username      : USERNAME-HERE
Classname    : vB_Database
MySQL Version :

ideas?

this error was emailed to me btw

GoTTi 04-29-2008 11:00 PM

and also, the new users that registered today were not added to my list.

Ryan Ashbrook 04-29-2008 11:29 PM

Been waiting for this, thanks. :)

King Kovifor 04-30-2008 12:06 AM

Quote:

Originally Posted by GoTTi (Post 1502803)
i upgraded to 3.7.0 today, but i am still getting a error that i think is caused by this mod...


Code:


Database error in vBulletin 3.7.0:
Invalid SQL:
INSERT INTO userlist (userid, relationid, type, friend) VALUES (, 1, 'buddy', 'yes');
MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 'buddy', 'yes')' at line 1
Error Number  : 1064
Request Date  : Tuesday, April 29th 2008 @ 01:11:23 PM
Error Date    : Tuesday, April 29th 2008 @ 01:11:23 PM
Script        : http://www.site.com/forums/register.php?do=activate
Referrer      : http://www.site.com/forums/register.php?a=ver
IP Address    : IP HERE
Username      : USERNAME-HERE
Classname    : vB_Database
MySQL Version :

ideas?

this error was emailed to me btw

Um... It seems like the user id is not added into the query. I guess $userid isn't available. Thanks for letting me know...

Quote:

Originally Posted by GoTTi (Post 1502804)
and also, the new users that registered today were not added to my list.

DId you turn the mutual setting on?

GoTTi 05-01-2008 02:03 PM

i have removed the mod. i am waiting for the fix for that error. do you want me to reinstall the mod and see if it duplicates? when will you be releasing the fixed version

GoTTi 05-01-2008 02:14 PM

ok when i click to activate account, i get taken to /register.php?a=act&u=486&i=XXXXX and i see that error again.

"Make This A Mutual Friendship" is set to yes.

King Kovifor 05-01-2008 03:17 PM

Quote:

Originally Posted by GoTTi (Post 1504569)
i have removed the mod. i am waiting for the fix for that error. do you want me to reinstall the mod and see if it duplicates? when will you be releasing the fixed version

Sorry to hear that, but I will be able to fix starting tomorrow. But I will be able to do it...

Quote:

Originally Posted by GoTTi (Post 1504584)
ok when i click to activate account, i get taken to /register.php?a=act&u=486&i=XXXXX and i see that error again.

"Make This A Mutual Friendship" is set to yes.

Thanks for the information. I guess that $userid isn't used within the validation code. I need to look into the userid variable that is used by default vBulletin code.

GoTTi 05-01-2008 11:04 PM

ok i have it uninstalled for now untill you get it fixed. lemme know. thanks.

King Kovifor 05-01-2008 11:41 PM

Quote:

Originally Posted by GoTTi (Post 1505116)
ok i have it uninstalled for now untill you get it fixed. lemme know. thanks.

At least I am getting the reports now. :) I am not going to code tonight, but will code tomorrow or this weekend. So you should have an update by monday.


All times are GMT. The time now is 09:41 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.01253 seconds
  • Memory Usage 1,745KB
  • 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_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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