Page 5 of 20

Re: phpBB Statistics

Posted: Wed Dec 02, 2009 11:45 am
by marian0810
marc1706 wrote:I'm currently working on some add-ons, including ... phpBB Arcade.
That would be so awesome! :D
Unfortunately, I'll have to redo the phpBB Arcade Add-On after I lost some data on my old computer.
I hope that didn't stop you 8-) Really looking forward to this!

Re: phpBB Statistics

Posted: Wed Dec 02, 2009 2:55 pm
by johanx
Hi there,

I Installed the mod and see the link. But, when i try to see the statistics...I get an HTTP-error 500, internal server error.

Can you tell me what I did wrong?

Johan

Re: phpBB Statistics

Posted: Wed Dec 02, 2009 4:25 pm
by Marc
You have uploaded all files? On what PHP Version is your server running?
With what editor did you edit your files?

@noelcrowley: I'm currently trying to set up an IIS Server with MSSQL, but I'm kind of having a hard time, so it will take some more time. :roll:

Re: phpBB Statistics

Posted: Wed Dec 02, 2009 4:47 pm
by noelcrowley
Thanks Marc.

I am greatful for your help. I understand that it is best effort. Thank you again.

Noeel

Re: phpBB Statistics

Posted: Fri Dec 04, 2009 2:53 am
by Marc
Ah, I finally got my SQL Server 2008 working on Windows 7. You can't imagine how hard it was to make that work, probably the reason why most servers run Apache. :roll:

Anyhow, now I can start taking a look at your errors. ;)

Re: phpBB Statistics

Posted: Fri Dec 04, 2009 7:39 am
by Traction
I once used a mod about 5 years ago that said stats for the days and months. For example, it would say something like 4,767 post in October 2009, 5,497 in November 2009, etc. Does this do that?

Re: phpBB Statistics

Posted: Fri Dec 04, 2009 9:16 am
by Marc
Yes, this MOD does that. Just take a look at my site: www.m-a-styles.de/stats.php

Re: phpBB Statistics

Posted: Fri Dec 04, 2009 11:14 am
by Marc
@noelcrowley:
Fixed a lot of bugs with MSSQL and comitted to SVN:
http://phpbbstatistics.svn.sourceforge. ... evision=78

Re: phpBB Statistics

Posted: Fri Dec 04, 2009 5:01 pm
by noelcrowley
marc1706 wrote:@noelcrowley:
Fixed a lot of bugs with MSSQL and comitted to SVN:
http://phpbbstatistics.svn.sourceforge. ... evision=78

Thanks Marc, it will be monday before I can test. I will let you know how I get on.

Re: phpBB Statistics

Posted: Sun Dec 06, 2009 10:57 am
by johanx
Problem solved. Conflicted with the quick language mod.

ty!

Re: phpBB Statistics

Posted: Tue Dec 08, 2009 8:45 am
by noelcrowley
noelcrowley wrote:
marc1706 wrote:@noelcrowley:
Fixed a lot of bugs with MSSQL and comitted to SVN:
http://phpbbstatistics.svn.sourceforge. ... evision=78

Thanks Marc, it will be monday before I can test. I will let you know how I get on.

Hi Mark,

Now I am geting this error!

Code: Select all

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'UNSIGNED'. [37000]

SQL

ALTER TABLE phpbb_profile_fields ADD field_stats_show TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT 0;

BACKTRACE


FILE: includes/db/mssql_odbc.php
LINE: 165
CALL: dbal->sql_error()

FILE: install/install_install.php
LINE: 139
CALL: dbal_mssql_odbc->sql_query()

FILE: install/install_install.php
LINE: 73
CALL: install_install->load_schema()

FILE: install/index.php
LINE: 252
CALL: install_install->main()

FILE: install/index.php
LINE: 53
CALL: module->load()

Re: phpBB Statistics

Posted: Tue Dec 08, 2009 12:11 pm
by Marc
Here: http://phpbbstatistics.svn.sourceforge. ... pathrev=78

Before opening the page again, please delete the tables phpbb_stats_config, phpbb_stats_smilies, phpbb_stats_bbcodes from your database. Otherwise you will get another SQL error.

Do you have ICQ or MSN? If you just send me your account info via PM I can help you fast and easy. ;)

Re: phpBB Statistics

Posted: Tue Dec 08, 2009 2:05 pm
by noelcrowley
marc1706 wrote:Here: http://phpbbstatistics.svn.sourceforge. ... pathrev=78

Before opening the page again, please delete the tables phpbb_stats_config, phpbb_stats_smilies, phpbb_stats_bbcodes from your database. Otherwise you will get another SQL error.

Do you have ICQ or MSN? If you just send me your account info via PM I can help you fast and easy. ;)

Thank you very much for your help with this. I finally got it working. I have to make 2 other changes with the schema file. It is working now and I am greatful for your help.

Code: Select all

CREATE TABLE [phpbb_stats_smilies] (
	[smiley_url] [varchar] (255) DEFAULT ('') NOT NULL ,
	[smiley_count] [int] DEFAULT (0) NOT NULL
) /*ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]*/

CREATE TABLE [phpbb_stats_bbcodes] (
	[bbcode] [varchar] (255) DEFAULT ('') NOT NULL ,
	[bbcode_count] [int] DEFAULT (0) NOT NULL
) /*ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]*/
GO
It is a nice bit of code.

Re: phpBB Statistics

Posted: Tue Dec 08, 2009 3:01 pm
by Marc
Oh, I think I also changed that in the SVN.

Glad to hear it's finally working.

Re: phpBB Statistics

Posted: Tue Dec 08, 2009 10:13 pm
by Traction
marc1706 wrote:Here: http://phpbbstatistics.svn.sourceforge. ... pathrev=78

Before opening the page again, please delete the tables phpbb_stats_config, phpbb_stats_smilies, phpbb_stats_bbcodes from your database. Otherwise you will get another SQL error.

Do you have ICQ or MSN? If you just send me your account info via PM I can help you fast and easy. ;)
I didn't delete any tables and I don't get any errors.