Forum Screwy, Or Just Me?

Test the syntax here, shout, do whatever (discuss about the forum if you want ...) but please behave ;) ... and spam is not welcome

Forum Screwy, Or Just Me?

Postby B » 2010-03-18 13:52

Am I the only one having problems today? First two times I tried using "View Posts Since Last Visit", I got errors of the form:

General Error

Could not delete old search id sessions

DEBUG MODE

SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes

DELETE FROM uvnc_phpbb_search_results WHERE session_id NOT IN ('0001f57bb179b5974441847d26b16247',

'00025baef2e9d6bde1fe33c692c56e75', '00032923569a3ff2ef48e11e1aad266a', '0004e577a7781d4ed2bc263cca7777c8',

'00060b4a0cc4bdeb6fa6319d3da299fe', '00090aafa0cd04d63479eb8a592897c3', '000a9238068e13c108c9c70a10bcfcd3',

'000e577ed4cdb74e852e8d086137863e', '000ecaae59269883de2c769cd8433ba1', '00154564174a49b5f8353f2f87330f90',

'001548f6d3dddd269332dfd10c716883', '0015c7617f9b59931ab500c8c28593ef', '0015ca2330b22e58c23660b6011387ce',

'00179f17102133e27140683e194920e2', '001913ab0d3dbc2584361f4ac3ecbd2a', '001e01e3bb55cfa4b8b6cd7d95eea240',

'00215afbd0776899c4838728e27cc02b', '002242466220b06073e72a44564d2bf6', '0023e4726e8ce8022ea1e0246c7314f0',

'002410d5d9f65246646b5d33f2920083', '0024ffe8e7bbaf939c0359258d09d4c4', '0026225b881ff18e976d1ad6cb56c285',

'002a934119ef118d0832eff5f875a7ce', '002d03d7e882f5b9c346d34f2cfc711d', '002dd2c0d45ae04e6550d5012f26c1d3',

'0030da077e9a22acedb00e277fc2c585', '003197140a034c7a33841b40faccfff2', '0031f7d14a542d5c2785425293c09fc1',

'0032f857fb0e24549844874dd2109a6f', '0034a3ca2275dc40bc57a83829d7d6ec', '0043fbac9eb931225604d5ea2bf5b7ff',

'00465b3f35a99abc81a461161f7ce635', '004b63067ef086c27f532be3f638b70f', '004cfa922c74ca79d48adb21a1c44ca5',

'004f3f23930c99270e86f4cc821b5852', '0050e7a20fb2a272fe84e4c4cbd837aa', '0051c6b17178350386b3c71a21417c23',

'0055b4c712083c58ebc22a4967710c45', '0058014ed4aa0d86de7e79fcbd4b363e', '00586690cd7bcf3129b8a9f5c8049b7f',

'00597ffe543d8c144475e91a1fd93b46', '005cc58ec13b45a61bc51c9a2a03e13c', '0061171e8bc53fcad82b77a70491088e',

'00612c2132d80b485d977c4ee280e8b1', '0062db9148306fe44fccf71ccaa56bbf', '0064b87f41e6b5bb6e8712f564a1d584',

'006b640f0b2326121d02197c774bbfdd', '006bf82dc83cf9ffc467f71e936d5161', '006df9cccc9a568715c7241a92937586',

'0071bcc91e4fb0d74a4e40434f8633aa', '00770d595f35901f44103e1f6404545e', '0078d27fee6f451e129943f0a6c55de9',

'0078f60d751ea0df09f28192a4c91ea8', '007b414f82a2bcc6e8a8dc16b3ad136b', '007bac8e45f8becf863552ad53f0d028',

'007e21a44723b80470678f02587a61ca', '007ef22cbf4f3ba4d3869a8526fabf43', '00878459df949f4ad7efb41d2331bc1c',

'008aa8d0394c31a7f8cc67134443d12a', '008ccff605fb894a1bb484b3e7e30d6e', '008f452c3f381dd8623119da9dc4c14b',

'009667bc37974d6af23753f297de84d6', '00968d20a861d89f9669a437861bd105', '0098685286e03031e6936057e45bd4af',

'009b328bc207d658c6a6210686b9ebd8', '009d781b9fe9be1fd9439c23380b4636', '00a17c4a9c63c8cad9945d40529fb273',

'00a1ddc043abb22b0f8a42a6c1aff951', '00a1f4ec04b2bb22568e67964c3d1476', '00a34a075248b98f63aba44950b2c259',

'00a3792d323650f51de96ee079e69fbc', '00a45ab74e276db9004257f86db0d096', '00a5e2378efcdf4d024754d648865a52',

'00a671d0152f2abec9e49eaadfe8f7e1', '00a9573c789d06e1c7e53566919c41b3', '00a9e54aab8a7769d4a09122b769f447',

'00ae8d47ab57cfd779bbf3dc63495bb1', '00b09ef080f16a30ae43d48b17796cc3', '00b2676c895b04336c97e9b04acb40f3',

'00b316ede040c7a8d25ffceca49bcbb9', '00b52e6a1607461c0ccd750179e1bf2e', '00b80006bb1518452493ffcba1057498',

'00bec7cd05f5bab838d6fbaa997b1f42', '00c12d0d17f6535873ec50c03994d86e', '00c28a59ce466cd6a79df039a8cfa88b',

'00c4520e6bd678ebf5b4daae0e3ba9d3', '00c5ead94fabf02e63a2defc094fc897', '00c621738c0dfbe1eb4f0521d95cf6fe',

'00c6c5f0ae2a57a2dd557ac624cc6cd5', '00c99d892228a92f65ca28957003547b', '00ca93a114e87d3d599d371b78f28f07',

'00cb143364d5ae6752773d08a30811c1', '00cfc4d7fc9bf6f3b48873eb704f6674', '00cff8c769030af81d1c63903effe36c',

'00d11341f5a5f2546b7568e8e2cf25fe', '00d3038ebe2f136f1adef51cf63b9046', '00d6a1fe904b0491c1ff29fc3a87a276',

'00da47a7da9d3344225688aafd85afb7', '00da98589011528f600947d5b410873d', '00de959174e33e0bae683c2da52bfa45',

'00e17394f928b993b65d28f053094133', '00e4a8aa49b0610bdf0b92c8e0a88138', '00eae2d208c9141e777459abb2bd2a46',

'00eb9594d48911b552b9abce757c141a', '00ecf2a4bb184cec837c35ac95182c0e', '00ee3993942a6a9fc3f6933ed1e0ece1',

'00efb20694cb4434ebdd3fa2fcce1003', '00f0993bd8cd72352707b9b6c648b5c2', '00f584c214a66ddb5e05c80719a30843',

'00f6c8f223b076caaf40b685cb6fec6d', '00ff57765a1d7728d393fad8f432049a', '0100c1530e976f4197ef406e4ea6d8f9',

'01068f1124b5a6085e6a9c34875d30a8', '01088c6397c09ec76834b6de549c9cd8', '010b4d2fda6dc134d5fd9bfda6f32358',

'0110ea01d5c7e0533d872e9ceda86123', '0112845d5abf64874f4a0b12cd5daffd', '01134a459e9a61203d69dedcafc4e961',

'01152096e0c759631e01096650d05cca', '01157c73d016bead3c28ec2462b93342', '01160cbd243c107647abda406472b8ae',



{ A WHOLE MEGABYTE OF STUFF; Yes I counted }


'fffd4dfc44962cdd88184662b2f50d53', 'fffd6bb25727f6d7109f4b2b5ef943c4')

Line : 670
File : search.php




Portions © 2004-2007 by -=Assarbad=- / v1.7d



Now, on the 3rd try after restarting the browser again, I get "No topics or posts met your search criteria", which I guess may be technically NOW, since I restarted and logged in again...


EDIT: After making this post, the SAME problem recurs. Clearly the forum is trying to tell me I've been visiting too often. :(
Last edited by B on 2010-03-18 13:59, edited 1 time in total.
B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby supercoe » 2010-03-18 15:24

B,

You're not the only one, seems like the forum went down for a bit and now it's fast again! :D
http://www.chunkvnc.com - ChunkVNC - Free PC Remote control with the Open Source UltraVNC wrapper InstantSupport!
User avatar
supercoe
Super-Mod
Super-Mod
 
Posts: 1735
Joined: 2009-07-20 21:27
Location: Walker, MN

Re: Forum Screwy, Or Just Me?

Postby B » 2010-03-18 16:39

Well, it's not entirely "back" for me -- still getting the "Could not delete old search id sessions... SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes".
B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby supercoe » 2010-03-18 16:55

Ahhhh yes, search still isn't working... I'll report to Oliver.
http://www.chunkvnc.com - ChunkVNC - Free PC Remote control with the Open Source UltraVNC wrapper InstantSupport!
User avatar
supercoe
Super-Mod
Super-Mod
 
Posts: 1735
Joined: 2009-07-20 21:27
Location: Walker, MN

Re: Forum Screwy, Or Just Me?

Postby B » 2010-03-19 13:04

Seems to be working today. Thanks.
B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby B » 2010-04-13 14:20

It's doing it again! Coincidentally (?) I recently restarted my browser and had to log in again.

Could not delete old search id sessions

DEBUG MODE

SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes

DELETE FROM uvnc_phpbb_search_results WHERE session_id NOT IN ('0001397524caf87b50789a565c2215b4', '00019a54c48bc1d6af701749626c0d15', '0001f37401ae66af2abcf4e53c5aaff2', '00026b5934695f2b6579b30fd638d4f0', '00048744afaff2d3cb030f0313f59621', '0004cf1fbc77a5862c114bd26f077331', '00064ca0a2a485d4d3b3e23d6b7e7ec0', '000c030e1f5c15bb4d3944bd770a4111', '000cbf92d781e98b3d58ef7335ab0495', '000f9dfb8a3d89bcff0833d786995e6d', '000faa358feacbaae44d9823d2558799', '00126ac0b6d4975b644a9b604c35e9a1', '001332a7ab21ea2fe4cb385710362a8f', '0016de07f6ee07ce55ec53b9a2ef0616', '0019606ac954a01c922425864264efde', '001b9bc2f049ba2c5c49cb7081d706be', '001d1251f24cc474898ff912786c8c84', '001d3c89e9c627519cf8edf80030e301', '001e9cd3d2dfa2ccb04354c4c7cd0b39', '002081365a9dcf7a4d52819135f0ebc6', '002467ffcf9f6834aa36f0f439945332', '0027751df4309bd50299a18e62baf650', '0029ad37ac33e2557630d8b1f329653e', '002afded285474fe3553112406faffbd', '002eda861c96aea88bb5767218044d8b', '0030990a030c53500fa07d06a0dad514', '0034f4cc6184b19be373d1d31a590cb



Yeah, I think it's really time to move on from this forum software!
B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby supercoe » 2010-04-13 14:34

Confirmed, I'll report the issue and yes phpbb3 is coming soon.
http://www.chunkvnc.com - ChunkVNC - Free PC Remote control with the Open Source UltraVNC wrapper InstantSupport!
User avatar
supercoe
Super-Mod
Super-Mod
 
Posts: 1735
Joined: 2009-07-20 21:27
Location: Walker, MN

Re: Forum Screwy, Or Just Me?

Postby redge » 2010-04-13 21:50

confirmed, me too, the same issue with browser Opera 10.51
UltraVNC 1.0.9.6.1 (built 20110518)
OS Win: xp home + vista business + 7 home
only experienced user, not developer
redge
Super-Mod
Super-Mod
 
Posts: 6815
Joined: 2004-07-03 17:05
Location: Switzerland - Geneva

Re: Forum Screwy, Or Just Me?

Postby B » 2010-04-14 17:39

Working again today... :)
B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby B » 2010-05-19 10:47

Doing it again, May 19, 2010:

Could not delete old search id sessions

DEBUG MODE

SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes

DELETE FROM uvnc_phpbb_search_results WHERE session_id NOT IN ('000063537d8c4a831ed19aee0c44c1aa', '0000b43f797d837a03b277b4a515a551', '0002a4636cf1080416278dd96832581c', '0006141bb3e25b5cf741db45d9fee594', '000761ad59e79f4d0401d8d53422f911', '000869967a229b8e02f09fcff4510bc4', '000c84540a4eac06012cacbb79f97b79',

...

B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby supercoe » 2010-05-19 16:16

Confirmed, I'll let the boss know.
http://www.chunkvnc.com - ChunkVNC - Free PC Remote control with the Open Source UltraVNC wrapper InstantSupport!
User avatar
supercoe
Super-Mod
Super-Mod
 
Posts: 1735
Joined: 2009-07-20 21:27
Location: Walker, MN

Re: Forum Screwy, Or Just Me?

Postby B » 2010-05-24 13:52

Sigh. It's doing it again. 5/24/2010.

Could not delete old search id sessions

DEBUG MODE

SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes

DELETE FROM uvnc_phpbb_search_results WHERE session_id NOT IN ('0000a49e1bfda7d0e5929fbe72e2218d', '0004fdf12ece9fc17134175e772e8827', '00052063d4ef20b1b813f29d30610dd9', '00070536cf9e70fe3c9867a3b203e3ef', '000ea67b3bb6688d5c2a04454f26ed45', '000ed32a0740cebb0f7a2fdf069abbaa', '0019d753a2edf5fcebb1a88df443590c', '00212885b11239388787e3cfb6b4a4f4', '002221a0d372b7249d25aabfe67d66fe',

etc.
B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby supercoe » 2010-05-24 14:09

It's been doing it for me since the 19th... :|
http://www.chunkvnc.com - ChunkVNC - Free PC Remote control with the Open Source UltraVNC wrapper InstantSupport!
User avatar
supercoe
Super-Mod
Super-Mod
 
Posts: 1735
Joined: 2009-07-20 21:27
Location: Walker, MN

Re: Forum Screwy, Or Just Me?

Postby B » 2010-05-24 15:15

Really? I'm pretty sure it was working for me over the last few days... (but could be retroactively hallucinating)
Last edited by B on 2010-05-24 15:16, edited 1 time in total.
B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby B » 2010-05-25 14:02

Working again this morning.

...........aaaaaaaaand it's broken <b>again</b> a couple of hours later.


First Google hit for this error reports:

Oke, I solve this. I have finded this link, there is a answer ;)

by D¡cky on Wed Feb 27, 2008 6:10 am
"The 'max_allowed_packet' has to do with the MySQL configuration on your host. The error may be caused by a lot of exceptionally long usernames or it may be that your host has the setting for packet size set too low. Contact your host and see if they will raise the packet size for you."

I have do it so and solve this ;)




(Previous edit at 16:13)


And now it's working again!
Last edited by B on 2010-05-25 19:16, edited 3 times in total.
B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby B » 2010-05-26 17:11

Oh, this is a new one.

General Error

Could not insert search results

DEBUG MODE

SQL Error : 1062 Duplicate entry '702635734' for key 1

INSERT INTO uvnc_phpbb_search_results (search_id, session_id, search_array) VALUES(702635734, '092f8ab57c54a6af85aeea7e3e667cad', 'a:7:{s:14:"search_results";s:40:"18002, 18035, 18091, 18097, 18098, 18099";s:17:"total_match_count";i:6;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:200;}')

Line : 721
File : search.php


But it was a one-off. It's working again now.
B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby supercoe » 2010-05-27 13:32

Back to the old one... :(

SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes
http://www.chunkvnc.com - ChunkVNC - Free PC Remote control with the Open Source UltraVNC wrapper InstantSupport!
User avatar
supercoe
Super-Mod
Super-Mod
 
Posts: 1735
Joined: 2009-07-20 21:27
Location: Walker, MN

Re: Forum Screwy, Or Just Me?

Postby B » 2010-05-27 13:48

Ditto here. :(
B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby B » 2010-05-28 14:55

Working again this morning.
B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby B » 2010-06-08 21:00

This one seems new, today, 6/9/2010.

General Error

Could not insert search results

DEBUG MODE

SQL Error : 1062 Duplicate entry '918429028' for key 1

INSERT INTO uvnc_phpbb_search_results (search_id, session_id, search_array) VALUES(918429028, '012635448ef2fea92d4cedfbbc44e4e3', 'a:7:{s:14:"search_results";s:82:"15840, 15941, 16486, 17350, 17712, 18059, 18104, 18131, 18164, 18199, 18206, 18207";s:17:"total_match_count";i:12;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:200;}')

Line : 721
File : search.php






NOTE TO MODS: Forum won't let me post -- <i>"You cannot make another post so soon after your last; please try again in a short while."</i> -- yet it's now been <b>many</b> minutes since this, my only post today. (If this is a spam prevention measure, it's <b>completely</b> counterproductive!) Let's see if I can post this edit...


EDIT2: Ah this is interesting -- seems to be a TIME CLOCK issue for the forum or server. It's stuck! It would explain my posting restriction. The first "Edit" and my initial post are <b>both</b> timestamped "21:00", even though they're around a 1/2 hour apart. Chances are THIS second edit will be timestamped "21:00" too, even though it's a few minutes later. Current EDT is 11:25 AM as a I post this....

EDIT3: Several minutes later. I can't even post a PM to a mod; same "too soon" error. Reboot this sucker. :)

EDIT4 (12:46 PM EDT, after supercoe's post below): Hi; unless your godlike powers permit, you won't be able to post again either, except to edit that one post here. For what little it's worth, I noticed the Forum Search behavior changed again, back to the long "SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes" error....
Last edited by B on 2010-06-08 21:00, edited 4 times in total.
B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby supercoe » 2010-06-08 21:00

Test post.

EDIT:

I'm not getting my PM notifications either, just so happens I'm addicted to this place and checked.

Confirmed: My post time is the same as B's
Last edited by supercoe on 2010-06-08 21:00, edited 2 times in total.
http://www.chunkvnc.com - ChunkVNC - Free PC Remote control with the Open Source UltraVNC wrapper InstantSupport!
User avatar
supercoe
Super-Mod
Super-Mod
 
Posts: 1735
Joined: 2009-07-20 21:27
Location: Walker, MN

Re: Forum Screwy, Or Just Me?

Postby B » 2010-06-09 20:27

Hey, I'm freeeeeee. I think I can post now. 4:27 PM EDT.

And the search / newpost feature http://forum.ultravnc.info/search.php?s ... d=newposts is working again.
Last edited by B on 2010-06-09 20:31, edited 1 time in total.
B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby supercoe » 2010-06-09 21:21

... and although the explanation post begs to differ, this is completely your fault! :P
http://www.chunkvnc.com - ChunkVNC - Free PC Remote control with the Open Source UltraVNC wrapper InstantSupport!
User avatar
supercoe
Super-Mod
Super-Mod
 
Posts: 1735
Joined: 2009-07-20 21:27
Location: Walker, MN

Re: Forum Screwy, Or Just Me?

Postby B » 2010-06-09 21:41

Oh I can believe that. (Or would, if I were still posting at the furious pace I was keeping recently.) Glad it's all back; though it's been tremendously slow periodically since the rebuild today. Maybe Oliver's other VMs are catching up as well and borrowing more CPU time....
B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby Oliver » 2010-06-09 22:07

B wrote:Oh I can believe that. (Or would, if I were still posting at the furious pace I was keeping recently.) Glad it's all back; though it's been tremendously slow periodically since the rebuild today. Maybe Oliver's other VMs are catching up as well and borrowing more CPU time....
So it seems ;)
Oliver

How to Report Bugs Effectively
My homepage | WinDirStat
PGP-keys:
  • Forum or UltraVNC-related: 0xA2DD1DBD, E18B 2E2F 4F3E D143 4ED4 3E2B E172 FB55 A2DD 1DBD
  • Other matters: 0x0E88590F, 38B5 5EBA A470 C0F7 0942 81B8 C779 D829 0E88 590F
User avatar
Oliver
Site-Admin
Site-Admin
 
Posts: 565
Joined: 2004-04-21 23:04
Location: Frankfurt am Main

Re: Forum Screwy, Or Just Me?

Postby B » 2011-06-13 14:08

Excuse me, Lisa, but I find it hard to believe you went through our forum registration hoops merely to add 3 words to a year-old thread. (Your only post.) You're a spammer and we can delete you, right?
B
Super-Mod
Super-Mod
 
Posts: 2347
Joined: 2009-09-09 14:05

Re: Forum Screwy, Or Just Me?

Postby Oliver » 2011-06-24 18:15

B wrote:Excuse me, Lisa, but I find it hard to believe you went through our forum registration hoops merely to add 3 words to a year-old thread. (Your only post.) You're a spammer and we can delete you, right?
Yep, she was a spammer. She and her posts are bleeding demised, they've passed on, they're no more, they've ceased to be, they've expired and gone to see their maker, this is a late spammer ...

http://www.youtube.com/watch?v=4vuW6tQ0218 :mrgreen:
Oliver

How to Report Bugs Effectively
My homepage | WinDirStat
PGP-keys:
  • Forum or UltraVNC-related: 0xA2DD1DBD, E18B 2E2F 4F3E D143 4ED4 3E2B E172 FB55 A2DD 1DBD
  • Other matters: 0x0E88590F, 38B5 5EBA A470 C0F7 0942 81B8 C779 D829 0E88 590F
User avatar
Oliver
Site-Admin
Site-Admin
 
Posts: 565
Joined: 2004-04-21 23:04
Location: Frankfurt am Main


Return to Off topic posts (Sandbox)

Who is online

Users browsing this forum: No registered users and 1 guest