Exclusive eBooks, Software Solutions, Quality Guaranteed
 
Web NukeBiz
Welcome to NukeBiz · Members
Amazon
show cart or checkout0 items
Cart Value: 0.00

Forums » DragonflyCMS Projects » IP Tracker » [solved]Install issue - incorrect db_charset in config
[solved]Install issue - incorrect db_charset in config
Keeping tabs on visitors, bots and modules being used.
Topic initiation via Bugger.

Post new topic    Reply to topic    Printer Friendly Page     Forum Index »  Management » IP Tracker

View previous topic :: View next topic  
Author Message
American
Nice Poster
Nice Poster

Offline Offline
Joined: Feb 17, 2007
Posts: 9

PostPosted: Sun Feb 18, 2007 8:10 am
Post subject: [solved]Install issue - incorrect db_charset in config

Tried installing this on 9.1.1 and get this db error:

includes/db/db.php

* CMS Warning line 75: On /admin.php?op=modules&install=IP_Tracker While executing query "CREATE TABLE nuke_iptracking ( ipid int(10) NOT NULL auto_increment, ipusername varchar(25), date_time int(10) UNSIGNED NOT NULL DEFAULT 1171780350, ip_address varchar(15) NOT NULL, hostname varchar(100) NOT NULL, page varchar(150) NOT NULL, ipcode smallint(6) NOT NULL default 0, PRIMARY KEY (ipid), KEY i1iptracking (ip_address, hostname)) TYPE=MyISAM DEFAULT CHARSET=NULL" the following error occured: 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 'NULL' at line 10 In: /home/rommel/domains/mydomain.us/public_html/includes/classes/installer.php on line: 61

Using 9.0.0.7. Any insight?


American please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Sun Feb 18, 2007 11:36 am
Post subject: Re: IP tracker version

No time left today, but I will check it out tomorrow.

MySQL version?

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)


Last edited by Phoenix on Sun Feb 18, 2007 12:05 pm; edited 1 time in total
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
American
Nice Poster
Nice Poster

Offline Offline
Joined: Feb 17, 2007
Posts: 9

PostPosted: Sun Feb 18, 2007 12:05 pm
Post subject: Re: IP tracker version

Understood. I appreciate it as I use this often. I run a political/military/intel site that gets some abuse from some of our Islamic fundi bretheren and it's always good to keep tabs on IP addresses if you know what I mean.


American please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Sun Feb 18, 2007 12:06 pm
Post subject: Re: IP tracker version

okay, I just had an afterthought as I was going out the door, MySQL version?

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
American
Nice Poster
Nice Poster

Offline Offline
Joined: Feb 17, 2007
Posts: 9

PostPosted: Sun Feb 18, 2007 12:14 pm
Post subject: Re: IP tracker version

American's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
FC4/2.0.59/4.1.12/4.4.4/9.1.1

Also..while you're at it.... Smile
cpgnuke.com/Forums/vie...tml#121767

Some date issues with the profile in 9.1.1:

$Source: /cvs/html/modules/Your_Account/userinfo.php,v $
$Revision: 9.33 $
$Author: phoenix $
$Date: 2006/08/17 13:12:50 $

But my date in user's profiles still only gives the date like this: Joined: Tuesday, March 18

No year. It's correct in the forum when viewing a post just not in the profile.


American please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Mon Feb 19, 2007 12:04 pm
Post subject: Re: IP tracker version

It's not directly an issue with IPT - it's choking on DEFAULT CHARSET=NULL which is added by the installer, independently of IPT.

Do you have trouble installing any other module?

This looks like a DragonflyCMS installer issue, which I won't handle here, but have relayed to the developers.

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)


Last edited by Phoenix on Mon Feb 19, 2007 12:15 pm; edited 1 time in total
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
American
Nice Poster
Nice Poster

Offline Offline
Joined: Feb 17, 2007
Posts: 9

PostPosted: Mon Feb 19, 2007 12:09 pm
Post subject: Re: IP tracker version

I do have charset set to null.... had utf8 issues.

I have installed weblinks, downloads, etc with no issues.

Would it help to reset charset to utf during ipt install and then change or ???


American please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Mon Feb 19, 2007 12:16 pm
Post subject: Re: IP tracker version

hmm, I edited while you were responding - I've forwarded to the developers as it's not a module issue.

Also I found someone else with the same issue on a different module.
dragonflycms.org/Forum...21733.html

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Mon Feb 19, 2007 4:46 pm
Post subject: Re: IP tracker version

It appears your problem is caused by incorrect use of NULL in your config file.

Should be define('DB_CHARSET', NULL);
Not define('DB_CHARSET', 'NULL');

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
American
Nice Poster
Nice Poster

Offline Offline
Joined: Feb 17, 2007
Posts: 9

PostPosted: Mon Feb 19, 2007 8:33 pm
Post subject: Re: [solved]Install issue - incorrect db_charset in config

I changed it... made no difference, here is how it looks now:

Quote::
define('DB_CHARSET', NULL); // NULL (is default), latin1, utf8, etc.


American please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Mon Feb 19, 2007 8:37 pm
Post subject: Re: [solved]Install issue - incorrect db_charset in config

well, NULL in quotes was incorrect and leads to the problem you had.

It's just not an IP Tracker installation issue.

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
American
Nice Poster
Nice Poster

Offline Offline
Joined: Feb 17, 2007
Posts: 9

PostPosted: Mon Feb 19, 2007 8:49 pm
Post subject: Re: [solved]Install issue - incorrect db_charset in config

I apologize... must of been some sort of cache issue in my browser or something...works fine now.

Thank you for your help!


American please enter your server specs in your user profile! Crying or Very sad
Back to top
View user's profile
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Mon Feb 19, 2007 9:16 pm
Post subject: Re: [solved]Install issue - incorrect db_charset in config

whew, thank goodness for that, coz there was no other answer Smile

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
Display posts from previous:   
Post new topic    Reply to topic    Printer Friendly Page    Forum Index »  Management » IP Tracker
Page 1 of 1
All times are GMT + 9.5 Hours



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 cannot download files in this forum