can't use Referers Management & same block
 
 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.   printer-friendly view    phpMiX.org Forum Index -> mxBB Modules -> mxBB Module: mx_sitestats
View previous topic :: View next topic  
Author Message
okcorp
Starter
Starter


Joined: 29 May 2005
Posts: 4

PostPosted: Sat Sep 17, 2005 10:32 am    Post subject: can't use Referers Management & same block Reply with quote

Couldn't retrieve HTTP Referers data

DEBUG MODE

SQL Error : 1146 Table 'db_okcorp_1.mx_sitestats_referer' doesn't exist

SELECT * FROM mx_sitestats_referer WHERE enabled = 1 ORDER BY hits DESC, lastvisit DESC LIMIT 10

Line : 57
File : topreferers.php
 
Back to top
View user's profile Send private message
markus
[Administrator]
[Administrator]


Joined: 28 Jul 2003
Posts: 1124

PostPosted: Sat Sep 17, 2005 12:21 pm    Post subject: Re: can't use Referers Management & same block Reply with quote

It looks like the table doesn't exist. Maybe you got an error while installing the module in the mxBB ACP? Try to install and then re-install.


.

 
 
_________________
http://www.phpmix.org
 
Back to top
View user's profile Send private message
okcorp
Starter
Starter


Joined: 29 May 2005
Posts: 4

PostPosted: Sat Sep 17, 2005 8:53 pm    Post subject: Re: can't use Referers Management & same block Reply with quote

markus wrote:
It looks like the table doesn't exist. Maybe you got an error while installing the module in the mxBB ACP? Try to install and then re-install.
.

nothing happend.
what columns in the table, may be i can create it my self?
 
Back to top
View user's profile Send private message
okcorp
Starter
Starter


Joined: 29 May 2005
Posts: 4

PostPosted: Sat Sep 17, 2005 9:11 pm    Post subject: Re: can't use Referers Management & same block Reply with quote

tryed to make it manualy, has an error
SQL-запрос :

Quote:
CREATE TABLE MX_SITESTATS_REFERER_TABLE(

id INT( 11 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
host VARCHAR( 255 ) DEFAULT '' NOT NULL ,
hits INT( 11 ) DEFAULT '0' NOT NULL ,
firstvisit INT( 11 ) DEFAULT '0' NOT NULL ,
lastvisit INT( 11 ) DEFAULT '0' NOT NULL ,
enabled TINYINT( 1 ) DEFAULT '0' NOT NULL ,
PRIMARY KEY ( id ) ,
KEY hits( enabled DESC , hits DESC , lastvisit ASC )
)

reply MySQL:


#1067 - Invalid default value for 'id'
 
Back to top
View user's profile Send private message
markus
[Administrator]
[Administrator]


Joined: 28 Jul 2003
Posts: 1124

PostPosted: Sat Sep 17, 2005 9:21 pm    Post subject: Re: can't use Referers Management & same block Reply with quote

Try removing the DEFAULT '0' clausule from the 'id' column, ie. something like:

Code:
CREATE TABLE MX_SITESTATS_REFERER_TABLE(
    id INT( 11 ) NOT NULL AUTO_INCREMENT,
    host VARCHAR( 255 ) DEFAULT '' NOT NULL,
    hits INT( 11 ) DEFAULT '0' NOT NULL,
    firstvisit INT( 11 ) DEFAULT '0' NOT NULL,
    lastvisit INT( 11 ) DEFAULT '0' NOT NULL,
    enabled TINYINT( 1 ) DEFAULT '0' NOT NULL,
    PRIMARY KEY ( id ),
    KEY hits( enabled DESC , hits DESC , lastvisit ASC )
)

Look at the file db_install.php in the mx_sitestats folder.

Then uninstall and install the module again.

 
 
_________________
http://www.phpmix.org
 
Back to top
View user's profile Send private message
okcorp
Starter
Starter


Joined: 29 May 2005
Posts: 4

PostPosted: Sat Sep 17, 2005 9:45 pm    Post subject: Re: can't use Referers Management & same block Reply with quote

made such sql, and Referers Management now is shown in admin & everything is working
mistake was in
Quote:
id INT(11) DEFAULT '0' NOT NULL auto_increment,

Quote:
DEFAULT '0'
must be deleted in this case & in other must be
Quote:
DEFAULT 0


CREATE TABLE mx_sitestats_referer ( id INT( 11 ) NOT NULL AUTO_INCREMENT ,
host VARCHAR( 255 ) DEFAULT '' NOT NULL ,
hits INT( 11 ) DEFAULT 0 NOT NULL ,
firstvisit INT( 11 ) DEFAULT 0 NOT NULL ,
lastvisit INT( 11 ) DEFAULT 0 NOT NULL ,
enabled TINYINT( 1 ) DEFAULT 0 NOT NULL ,
PRIMARY KEY ( id ) ,
KEY hits( enabled DESC , hits DESC , lastvisit ASC ) );
 
Back to top
View user's profile Send private message
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.   printer-friendly view    phpMiX.org Forum Index -> mxBB Modules -> mxBB Module: mx_sitestats All times are GMT + 1 Hour
 
Page 1 of 1


 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum