vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)
-   -   vB Pager 2.0.4 (https://vborg.vbsupport.ru/showthread.php?t=72823)

mello_mike 01-28-2005 01:42 AM

For some strange reason.. all my members can send messages .. but we cannot GET any. I made sure permissions were correct.. still no luck

All message are marked unread.. members aren't getting their messages.

docvader 01-28-2005 01:48 AM

Wolfe, what are you fixing? The persistent pager box problem?

wolfe 01-28-2005 02:01 AM

Quote:

Originally Posted by docvader
Wolfe, what are you fixing? The persistent pager box problem?

the guest popup one i fixed i have also fixed some bugsin the pager file where there was no " . TABLE_PREFIX . " where it was needed ;)

my guest box don't pop up no more

docvader 01-28-2005 02:05 AM

Wolfe, nice, but, I instituted your changes, and it wiped out the user's ability to see anything in the board, once I sent him a message.

I sent myself a message, from one of my test accounts, and bamm. I got mysql errors for every damn page of my site. Other users had no problem. Just the guy that got a message.

I reverted to the originals, and my board works for me again.

I don't use table prefixes. Might that be the cause??? There's also a line where you changed the UPDATE pager table. Wonder if that screwed me up. I can see why you added quotes to everything. But the UPDATE command change, was that necessary?

Scared the living s... out of me man.

docvader 01-28-2005 02:32 AM

I've also noticed, that if you have a pager box that you cannot close, and, you just leave it be, it will cause your forum page to refresh, every minute or so. Yet, it won't go away.

mello_mike 01-28-2005 02:34 AM

I'm getting this SQL error when I got to view messages in the AdminCP

Quote:

Database error in vBulletin 3.0.3:

Invalid SQL: select pagerid, parentpid, tosessionid, fromsessionid, touserid, fromuserid, message, msgdate, deliverdate, canreply, hidden, delread, delsent, active, username from pager as p left join user as u on (p.touserid=u.userid) where active=0 order by msgdate desc LIMIT -15, 15
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 '-15, 15' at line 1

mysql error number: 1064

laborer75 01-28-2005 03:37 AM

K-I got it installed. When I click to send a message in IE, it errors and I have to shut IE down. It does not do this in firefox though. My members are all having the same problem. Any ideas why this is happening? I read a couple others are having the same problem in this thread. Wondering if anybodys figured out why yet? Thanx in advance.......

uae 01-28-2005 08:53 AM

Quote:

Originally Posted by docvader
I've also noticed, that if you have a pager box that you cannot close, and, you just leave it be, it will cause your forum page to refresh, every minute or so. Yet, it won't go away.

Hey, I just registered @ your forum http://x.russbo.com/vb/
I logged in as a registered user "uae", then I went to WOL page using Internet Explorer, and I opened FireFox and logged in as a guest!
I was able to send a pager message from uae to that guest, and both buttons were working fine, Reply and Close button!
I haven't noticed that if you got a pager message popup opened, the page will keep refreshing!

Close or Reply button, both should update DB and set that message as READ.
So, that message should never popUP again!

I just can't see your problem!

wolfe 01-28-2005 02:08 PM

m8 the table prefix will only come into action if you have got a prefix if not it will not do anything also that file stopped all the mysql errors on my site

docvader 01-28-2005 02:17 PM

Understand, m8. You've got a New Yorker talking like a Brit now. Anyway, I noticed basically two portions of code that you put into pager.php, that changes it. One had an "else" statement, the other changed the way the table updated. The rest, were quotation mark additions.

I'm not sure which one caused my mysql errors throughout the board. Got any idea???

Uae, keep checking into http://x.russbo.com/vb/index.php. You'll see the error. Use IE.


All times are GMT. The time now is 09:45 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.01453 seconds
  • Memory Usage 1,740KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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