vb.org Archive
Page 2 of 40 1 2 3412 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   End-User Options - Favorite Smilies (https://vborg.vbsupport.ru/showthread.php?t=123116)

43082448 08-06-2006 04:05 AM
$vbulletin->db->query("ALTER TABLE user ADD favsmilies TEXT NOT NULL");

==>

$vbulletin->db->query("ALTER TABLE " . TABLE_PREFIX . "user ADD favsmilies TEXT NOT NULL");

Darwinist 08-06-2006 05:20 AM
Quote:
Originally Posted by Sooner95
welp, ok.. pretty pissed here.

Hack didnt work..ok NP. Yes, when i remove the steps, now my BBS is hosed. I understand that in the title it days 3.6, but would be nice if it Stated that it worked in ONLY 3.6
When the description states 3.6, best bet is to assume it's for 3.6 only unless told otherwise. You could've asked...

Quote:
Originally Posted by Sooner95
error



for those that care. I am continuing to find a fix for this, as my board is crap now.
You didn't revert the code in 'functions_editor.php'. Change 'query_read_slave' to 'query_read'.

I've posted a version that will work in 3.5 Here.

Quote:
Originally Posted by webwench
When I try to install this, I get a database error:

The table of course should be vb_user, but I don't know what to change to make this install. Can anyone help?
Install code fixed.

webwench 08-06-2006 11:14 AM
Quote:
Originally Posted by 43082448
$vbulletin->db->query("ALTER TABLE user ADD favsmilies TEXT NOT NULL");

==>

$vbulletin->db->query("ALTER TABLE " . TABLE_PREFIX . "user ADD favsmilies TEXT NOT NULL");
And if so, could you please explain? Thanks

Darwinist 08-06-2006 02:08 PM
Quote:
Originally Posted by webwench
And if so, could you please explain? Thanks
Just download the updated files and reinstall... in contains the fixes.

kvnband 08-06-2006 04:09 PM
Weird. I installed but when I try to set my favorite smilies, I get this error

Code:
Database error in vBulletin 3.6.0:

Invalid SQL:
UPDATE user SET favsmilies='212' WHERE userid='1';

MySQL Error  : Unknown column 'favsmilies' in 'field list'
Error Number : 1054
Date        : Sunday, August 6th 2006 @ 12:07:17 PM
Script      : http://www.secondwivesclub.com/portal/forum/misc.php
Referrer    : http://www.secondwivesclub.com/portal/forum/misc.php?do=editfavsmilies
IP Address  : 70.173.100.38
Username    : admin
Classname    : vB_Database
I checked in phpmyadmin and the column does indeed exist. Any idea what the deal is?

kvnband 08-06-2006 04:40 PM
You have problems in the product.

Line 143 should be changed from

Code:
$db->query("UPDATE user SET favsmilies='$favsmilies' WHERE userid='" . $vbulletin->userinfo['userid'] . "'");
to
Code:
$db->query("UPDATE " . TABLE_PREFIX . "user SET favsmilies='$favsmilies' WHERE userid='" . $vbulletin->userinfo['userid'] . "'");
and line 126 should be changed from
Code:
$db->query("UPDATE user SET favsmilies='' WHERE userid='" . $vbulletin->userinfo['userid'] . "'");
to
Code:
$db->query("UPDATE " . TABLE_PREFIX . "user SET favsmilies='' WHERE userid='" . $vbulletin->userinfo['userid'] . "'");
Kevin

Darwinist 08-06-2006 05:47 PM
I fixed it this morning... download the script again and reinstall.

webwench 08-06-2006 06:32 PM
Thanks very much!

GoNz00 08-08-2006 06:20 AM
i think i found a bug related, i removed this and deleted bitfield_user_smiley.xml from the xml folder, now i can save usergroups without the following error.

is this related to your product ?

Code:
Database error in vBulletin 3.6.0:
Invalid SQL:
UPDATE vb3_usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
 `title` = '(COPPA) Users Awaiting Moderation',
 `description` = '',
 `usertitle` = '',
 `opentag` = '',
 `closetag` = '',
 `passwordexpires` = '0',
 `passwordhistory` = '0',
 `forumpermissions` = '131072',
 `attachlimit` = '0',
 `pmquota` = '50',
 `pmpermissions` = '0',
 `pmsendmax` = '0',
 `calendarpermissions` = '32',
 `wolpermissions` = '0',
 `adminpermissions` = '0',
 `genericpermissions` = '0',
 `genericoptions` = '48',
 `profilepicmaxwidth` = '100',
 `profilepicmaxheight` = '100',
 `profilepicmaxsize` = '65535',
 `avatarmaxwidth` = '80',
 `avatarmaxheight` = '80',
 `avatarmaxsize` = '20000',
 `signaturepermissions` = '139263',
 `sigpicmaxwidth` = '500',
 `sigpicmaxheight` = '100',
 `sigpicmaxsize` = '20000',
 `sigmaxrawchars` = '4000',
 `sigmaxchars` = '2000',
 `sigmaxlines` = '0',
 `sigmaxsizebbcode` = '7',
 `sigmaximages` = '30',
 `usmilie_permissions` = '0'
WHERE usergroupid=4;
MySQL Error  : Unknown column 'usmilie_permissions' in 'field list'
Error Number : 1054
Date        : Tuesday, August 8th 2006 @ 09:08:37 AM
Script      : http://www.clandesertrats.co.uk/foru....php?do=update
Referrer    : http://www.clandesertrats.co.uk/foru...&usergroupid=4
IP Address  : 62.253.128.14
Username    : GoNz0
Classname    : vb_database
i tried your updated version as well to no joy :(

GoNz00 08-09-2006 09:15 AM
bump?


All times are GMT. The time now is 04:28 PM.
Page 2 of 40 1 2 3412 Last »
Show 40 post(s) from this thread on one page

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