Thread: Log Logins Hack
View Single Post
  #6  
Old 15 Jul 2005, 21:30
Abe1's Avatar
Abe1 Abe1 is offline
 
Join Date: Feb 2004
Real name: Abe
Originally Posted by cipciop
after lunch the puglin i have the problem with database:

Database error in vBulletin 3.5.0 Beta 4:

Invalid SQL:
CREATE TABLE IF NOT EXISTS`logins` (
`logid` int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`userid` int(10) NOT NULL,
`username` char(100) NOT NULL,
`ipaddress` char(15) NOT NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,
`phpdate` int(10) NOT NULL);

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
'CURRENT_TIMESTAMP,
`phpdate` int(10) NOT NULL)' at line 6
Error Number : 1064

What can resolved this problem ?

Tks.

Sorry for my bad english
OK. I updated the zip file. Please try to install again now. Also, you sould first manualy delete any hooks that got installed before. After you delete them, you can import this new file.
__________________
MY HACKS -

Active Link Security 3.0.X | Add Title to Rank Images 3.5.X | Admin Log In As User 3.5.X 3.6.X | Advanced BBCode Permissions 3.5.X 3.6.X | Can't See Attachments Before Thanking a Post 3.5.X | Can't Thank and Groan the Same Post 3.5.X | Delete Post when Giving Infraction 3.6.X | Edit New Thread Button 3.5.X | External Data Provider Usergroup Permissions Setting 3.5.X | Forms Hack 3.5.X, 3.6.X | Log Logins Hack 3.5.X 3.6.X | Moderator Statistics 3.5.X | Post Award Hack 3.0.X 3.5.X | [AJAX] Post Thank You Hack 3.0.X 3.5.X 3.6.X | [AJAX] Post Groan Hack 3.5.X 3.6.X | Post Thank You Hack Stats for vBadvanced CMPS 2.x 3.5.X | Search Title only in search drop-down 3.5.X, 3.6.X | 'vBMenu' DHTML User Option 3.5.X 3.6.X | vBShout on all pages! 3.5.X
Reply With Quote