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)

hambil 03-16-2009 07:01 PM

Quote:

Originally Posted by g0dfather1984 (Post 1769888)
Sorry to bother you again, but I received this:

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 : Monday, March 16th 2009 @ 03:53:32 PM
Error Date : Monday, March 16th 2009 @ 03:53:32 PM

Yes, that seems to be happening to a number of folks. If you want to send me login into via PM or email, I'll see if I can find out what is going on.

hambil 03-16-2009 07:06 PM

A question to the people getting the database error: Are you getting the error AFTER you've selected an 'egg' to throw and clicked submit?

Vitaly 03-16-2009 07:21 PM

HTML Code:

<script language="javascript">
nd_mode="tomato";
</script>
<script language="javascript" src="http://www.netdisaster.com/js/mynd.js"></script>

Try to insert at any page such demo. May be that will give you some idea how to throw eggs to post :)

woffie 03-16-2009 07:27 PM

Quote:

Originally Posted by hambil (Post 1769897)
A question to the people getting the database error: Are you getting the error AFTER you've selected an 'egg' to throw and clicked submit?

If you try to click on the menu before the page is finished loading that is when I got errors. It seems like that is the only time. After I get the error, the post of the person that I was going to throw an egg at disappears.

hambil 03-16-2009 07:33 PM

Quote:

Originally Posted by woffie (Post 1769911)
If you try to click on the menu before the page is finished loading that is when I got errors. It seems like that is the only time. After I get the error, the post of the person that I was going to throw an egg at disappears.

I might have a solution - I'm testing it now.

hambil 03-16-2009 07:53 PM

Updated: Let me know if that fixes the database errors for those having them.

DobieGillis? 03-16-2009 08:08 PM

its working just not sure how to clean someones av so I can see if the animation comes back

DobieGillis? 03-16-2009 08:09 PM

never mind it's very cool, working fine so far

DobieGillis? 03-16-2009 08:16 PM

little weird with live topic.

djilou 03-16-2009 08:21 PM

Still get this error when I try to upgrade

Code:

Invalid SQL: ALTER TABLE usergroup ADD eggavatarpermissions INT(10) UNSIGNED DEFAULT '1' 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

It's annoying because I loose all settings, and I must redone permessions for every usergroups.


All times are GMT. The time now is 12:36 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.01530 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
  • (1)bbcode_code_printable
  • (1)bbcode_html_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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