vb.org Archive - psiStats 2006 (The New vBStats for vBulletin 3.5.x

Page 17 of 58

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - psiStats 2006 (The New vBStats for vBulletin 3.5.x - 3.8.x) (https://vborg.vbsupport.ru/showthread.php?t=104213)

akanevsky

01-09-2006 07:31 PM

I will verify & fix the problems on the weekend.

Yorixz

01-09-2006 07:35 PM

Sadly it caused a database error for my IE visitors so I've got it disabled for now, might reinstall later if it's fixed.

Loki12

01-09-2006 07:42 PM

I have database errors too the last few days, although I can't confirm that it is from this hack.

akanevsky

01-09-2006 08:19 PM

Quote:

Sadly it caused a database error for my IE visitors so I've got it disabled for now, might reinstall later if it's fixed.

Have you undone class_core file edits?

firstrebel

01-09-2006 08:26 PM

See http://www.vbulletin.com/forum/bugs3...iew&bugid=2056

Bob

akanevsky

01-09-2006 08:31 PM

Uh huh. Thought so. So it's not an error on my side :) Thanks, Bob.

Zelda-King

01-09-2006 09:05 PM

That fix didn't sort my little issue though. :/

S@NL - BlackBik

01-09-2006 09:41 PM

I've found out the errors i'm getting:

Code:

Database error in vBulletin 3.5.3:



Invalid SQL:

LOCK TABLES psistats_cache READ, psistats_data READ;



MySQL Error  : Access denied for user: 'phpuser@127.0.0.1' to database 'setiforum'

Error Number : 1044

Date         : Monday, January 9th 2006 @ 05:27:41 PM

Script       : ../cron.php?&rand=397415

Referrer     : ..forumdisplay.php?f=13

IP Address   : xx.xxx.xx

That has nothing to do with the UNLOCK error. That has been fixed btw.
I don't get this error on any other cron of vB function and my default user has all the rights it needs as far as I know.
What could be wrong?

FFMG	01-09-2006 10:57 PM

Hi,

I have found 1 problem with the install. Forgive me if I am wrong.

In product-psistats.xml, line 38.

Code:

$db->query_write("INSERT INTO `" . TABLE_PREFIX . "cron` VALUES (14, 1136665500, -1, -1, -1, 'a:1:{i:0;i:25;}', './includes/cron/psistats_update.php', 1, 'psiStats 2006 Hourly Update')");

That doesn?t work for me because I already have more than 14 cron jobs.
Surely the insert should not give an ID number.

And as for the lock until a solution is found I had to disable

Code:

$vbulletin->db->lock_tables(array('psistats_cache' => 'READ', 'psistats_data' => 'READ'));

//and

$vbulletin->db->unlock_tables();

Because I don?t have those permissions and I don?t know where to disable it in the options.

Thanks.

FFMG

S@NL - BlackBik

01-09-2006 11:10 PM

8)

Great sollution FFMG, that does the trick.
Does anybody know what the risc is for disableing those two commands?

All times are GMT. The time now is 08:18 PM.

Page 17 of 58

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01244 seconds Memory Usage 1,735KB 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_code_printable (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
Messages: