vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   New Posting Features - [tk] Egg Avatar (https://vborg.vbsupport.ru/showthread.php?t=208324)

whitetigergrowl 03-16-2009 04:16 AM

Amazing what happens when you try and egg yourself. >_> lol You get egg in the face alright.

rinkrat 03-16-2009 04:38 AM

OMG this freakin rules! I love the throw kisses! Works great.

rinkrat 03-16-2009 04:56 AM

OK, when you egg yourself there is a nasty database error. Can you fix it so you can either egg yourself or not be able to click the link?

Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT count(eggtype) as totaleggs FROM eggavatar WHERE userid = AND cleaned = 0 AND UNIX_TIMESTAMP( ) <= (dateline + 3600);

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 'AND cleaned = 0 AND UNIX_TIMESTAMP( ) <= (dateline + 3600)' at line 1
Error Number : 1064
Request Date : Sunday, March 15th 2009 @ 10:52:46 PM
Error Date : Sunday, March 15th 2009 @ 10:52:47 PM
Script : /bbs/eggavatar.php?do=addegg&p=1437306
Referrer : /bbs/f27/106476.html#post1437306
IP Address : 24.112.11.11
Username : rinkrat
Classname : vb_database
MySQL Version : 4.1.20

hambil 03-16-2009 05:07 AM

You should not be able to egg yourself - the problem must be something else. What you should see is either a nothing to do error message, or options to clean if appropriate. See attachments.

djilou 03-16-2009 08:32 AM

Quote:

Originally Posted by hambil (Post 1769179)
Did not realize that wasn't compiled in by default. Fixed now. Thanks.

Thanks for the fix,
but when I try to upgrade I got this error :

Invalid SQL:
ALTER TABLE usergroup ADD eggavatarpermissions INT(10) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error : Duplicate column name 'eggavatarpermissions'
Error Number : 1060
Request Date : Monday, March 16th 2009 @ 09:29:54 AM
Error Date : Monday, March 16th 2009 @ 09:29:54 AM
Script : /admincp/plugin.php?do=productimport
Referrer : /admincp/plugin.php?do=productadd

hambil 03-16-2009 08:43 AM

It didn't uninstall properly. Uninstall it, and reinstall. If it still doesn't work them you'll have to manually delete the column eggavatarpermissions from your database (though I'm not sure why uninstalling first wouldn't do that for you).

hambil 03-16-2009 08:43 AM

Actually, if you wait 10 mins I've got a minor update on the way anyway. :p

hambil 03-16-2009 08:57 AM

Minor update just put up. Fixes popup/cost display bug, and fixes images losing color when placed on some avatars.

djilou 03-16-2009 09:19 AM

Thank you :)

Sunka 03-16-2009 09:27 AM

Updated...working OK
Animated avatars are not animated more! But I take that like good options


All times are GMT. The time now is 05:19 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.01289 seconds
  • Memory Usage 1,734KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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