vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=208324

hambil 16 Mar 2009 21:01

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 16 Mar 2009 21:06

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 16 Mar 2009 21:21


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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

woffie 16 Mar 2009 21:27

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 16 Mar 2009 21:33

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 16 Mar 2009 21:53

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

DobieGillis© 16 Mar 2009 22:08

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

DobieGillis© 16 Mar 2009 22:09

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

DobieGillis© 16 Mar 2009 22:16

little weird with live topic.

djilou 16 Mar 2009 22:21

Still get this error when I try to upgrade


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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

hambil 16 Mar 2009 22:23

There is no upgrade. Uninstall and reinstall.

hambil 16 Mar 2009 22:23

Okay, I've been putting it off, but next version I'll start including upgrade scripts lol

DobieGillis© 16 Mar 2009 22:24

you have to refresh the page manually if you use Live Topic, at least for me anyway

rinkrat 16 Mar 2009 22:41

That will be good because people don't want to see all of their egging go to waste, plus we have to set all the permissions again with each upgrade.

lostguy 16 Mar 2009 23:34

I installed everything work fine ! But i cant view my own avatar ...For some reason my avatar not showing but just X mark say no avatar but i did have avatar . Weird

pls help .

lg


All times are GMT. The time now is 15:09.

Powered by vBulletin® Version 3.8.14
Copyright © 2021, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.